Subscribe to our 0800-DEVOPS Newsletter

    Get in touch

    Contact us for all inquiries regarding services and general information






      Get in touch

      Contact us for all inquiries regarding services and general information






        Use the form below to apply for course





          Get in touch

          Contact us for all inquiries regarding services and general information






          agile coaching
          Development

          SQL course

          DURATION 2 Days

          Short description of the course:

          The two–day course provides a theoretical and practical overview of database introduction and simple SQL queries.

           

          The SQL course introduces students to relational database usage. It consists of 8 units and begins with an introduction to databases and defining basic terms and types of data. The course includes the basics of Data Manipulation Language (DML) and Data Definition Language (DDL). Participants are introduced to the basic scalar and aggregate functions and how to apply them in everyday work. The second day of the seminar discusses the ways of grouping data and mandatory rules to create a union or difference of data sets.
          Through the course, participants will learn to use subqueries, the last lesson contains basic DDL commands.
          Through the exercises, the understanding of the presented material is checked, and the presence of an instructor facilitates the solution and correction of mistakes.
          All materials and all exercises are available online. The course could be organized online or onsite. All materials for repeating and practice are available a week after the course is finished. After each section students have a quiz to check their knowledge. After completing the course there is a link for outside checking knowledge.

           

          Content:

          The content of the course can be adapted to users with different prior knowledge. Each unit contains exercises, and exercises also “for those who want to know more.”

           

          First day:

          • Introduction
          • Simple SQL queries
          • Retrieving data from multiple tables
          • Scalar and arithmetic functions

           

          Second day:

          • Aggregate functions and grouping
          • Retrieving data from multiple data sets
          • Subqueries
          • Data editing

           

          Course duration: 2 days

           

          For all inquiries regarding education, please contact us at learn@croz.net.

          Check course dates.

          course-apply@3x
          APPLY TO COURSE

          For all inquiries regarding education, please contact us at learn@croz.net or apply online.

          Apply for course