Learn SQL quickly and efficiently!

You will learn how to read and write complex database queries using one of the most popular programming languages - SQL and a super popular DBMS (database management system) - PostgreSQL. All the knowledge that you will get on the course is easily applicable to other DBMS, such as MySQL, Microsoft SQL Server, Oracle.

Learning SQL is one of the fastest ways to move up the career ladder and start earning even more. In the course, you will learn and be given assignments to test yourself and improve your understanding of the material.

Who this course is for:
Beginners in programming who want to learn how to work with data through SQL and PostgreSQL

What you will learn
Relational model and SQL
PostgreSQL data types
Database and table creation
Relationships 1 to 1, 1 to many, many to many
Selections - SELECT
Data filtering - WHERE
Sorting and grouping data
UNION, INTERSECT, EXCEPT operators on sets
Table joins
Subqueries
Keys: primary and external
Restrictions
Sequences
Insert, delete, update
Database design
Indexes

Course content 23 sections - 146 lectures - Total duration 21 h 34 min