This course covers the basics of the SQL language - unlike other courses, which have a lot of syntax elements that are in fact rarely used in practice - here you will get exactly those skills that are often used in practice. This will allow you to get started right away without wasting too much time.

The SQL language seems simple - and it really is. However, every business has its subtleties. And these subtleties are outlined in this course - this is the work with NULL values, duplicate rows and row loss when joining tables and many others.

There are practical tasks in the course. So you will not only watch the lectures, but also write SQL queries yourself. Also, after each exercise we analyze the solutions to these exercises.

This is a compact course to save your time. All the material is presented concisely. The course structure is designed to give you a complete picture of SQL query development.

You will learn SQL applicable to many databases. The exercises are performed in PostgreSQL. However, we do not cover features that are specific to PostgreSQL only. Therefore, the knowledge gained is applicable to other databases: PostgreSQL, Oracle, Microsoft SQL Server, MySQL, Teradata, Amazon Redshift, Google BigQuery, and many others. The basic SQL constructs are the same everywhere.

The focus is on writing SELECT queries to read data. It often happens that tables have already been created and data has been loaded into them. And the task is to write a correct and error-free data selection from these tables.

Who this course is for:
Data Analysts
Data Scientists, Data Engineers
Database and data warehouse developers
Testers

What you will learn
Develop SQL queries for databases.
Avoid common mistakes that beginners make
Use SQL to analyze data
Identify SQL on your resume

Course content 14 sections - 97 lectures - Total duration 9 hours 50 minutes