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 database usage, integral components of modern applications. It consists of 8 units and begins with an introduction to databases and defining basic terms and types of data. The course includes the basic SQL clauses SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY. 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 of SQL results.

Through the course, participants will learn to use subqueries, the last lesson contains basic commands for editing data such as INSERT, UPDATE and DELETE.

PowerPoint presentations are used for each lesson, and it is especially useful that after each lesson, except introductory one, exercises are done in a pre-prepared environment.

Through the exercises, the understanding of the presented material is checked, and the presence of an instructor facilitates the solution and correction of mistakes.

 

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
  • Exercise 1.
  • Retrieving data from multiple tables
  • Exercise 2.
  • Scalar and arithmetic functions
  • Exercise 3.

 

Second day:

  • Aggregate functions and grouping
  • Exercise 4.
  • Union
  • Exercise 5.
  • Subqueries
  • Exercise 6.
  • Data editing
  • Exercise 7.

 

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