About this course
Confidently write SQL queries against Oracle, MySQL, PostgreSQL, Microsoft SQL Server, Teradata, Snowflake and other databases.
This course covers the basics of the SQL language - unlike other courses, which have a lot of syntax elements that are rarely used in practice - here you will get exactly those skills that are often used in practice. This will allow you to start working immediately without wasting too much time.
The SQL language seems simple - and it really is. However, each case has its own subtleties. And these subtleties are outlined in this course - this is working with NULL values, duplicate rows and loss of rows when joining tables, and many others.
My main job for more than 18 years is data analysis using complex SQL queries. Therefore, I decided to create this course to share the experience and solutions to the problems that I face in my daily work.
Why is SQL needed? This skill is needed in many professions - programmers, testers, database administrators, analysts, data scientists and many others. The amount of data in the world is growing exponentially. And a lot of that data is still relational - made up of tables, rows, and columns. Therefore, the SQL language not only does not lose its relevance, but over time it becomes more and more in demand!
And also to everyone who is interested in open data. You can take any open data on the Internet in CSV format, upload it to your database, and extract the information you need from this data using SQL!
The course includes practical exercises. So you will not just watch the lectures, but also write SQL queries yourself. Also, after each exercise, we analyze the solutions to these tasks.
This is a compact course to save you time. All material is presented concisely. The course structure is thought out in such a way that you have a complete picture of the development of SQL queries.
You will learn SQL applicable to many databases. The exercises are done in PostgreSQL. However, we do not touch on PostgreSQL-specific features. 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, data has been loaded into them. And the task is to correctly and without errors write a selection of data from these tables.
Other SQL constructs - creating tables, modifying data - are also covered in this course.