SQL

The course does not require any basic concepts to complete it, because it provides detailed and up-to-date knowledge of relational databases using the example of one of the currently best DBMS PostgreSQL, and the language for working with them - SQL. Although the SQL standard will be applicable to any other relational databases, so do not worry that you are using a different DBMS in your project.

The course itself is divided into 3 main parts:

• basic level
• standard level
• advanced level

For beginners, you can complete the first two levels and then return to the last one, but you definitely need to understand all of the above over time!

The course contains a lot of practical exercises and completely covers all aspects of relational databases :

• defining and creating databases, schemas, tables and fields of these tables (DDL)
• creating SQL queries to obtain data (DML)
• window functions
• B-Tree indexes
• query execution plans
• working via the command line with a DBMS
• creating a database dump and vice versa , rolling out the DBMS schema and data from it
• what is DWH and its best representative from Google - BigQuery
• let’s touch on the topic of NoSQL with the CAP theorem.

< p>After completing all levels of this course, you will be confident in relational databases, have an understanding of NoSQL storages and why they are increasingly gaining popularity (but never replace relational ones!) and feel comfortable on any real project.