Learn SQL by Writing Queries

In this lecture we'll introduce the DBMS we'll use in this course ad see how to install it.

In this lecture we'll see how to run the PostgreSQL server and how to create a new DB in it.

In this lecture we'll overview the example DB we'll use through this course.

In this lecture we'll see how we can create tables in the DB, and we'll use a script to create all tables in our data model.

In this lecture we'll see how we can insert data into tables with the insert statement and use the script to load data into the tables.

In this lecture we'll define the SQL language and see what types of queries we can ask.

In this lecture we'll learn about the basic select statement.

In this lecture we'll see how to type and run the queries on the shell, and how to look at the results.

In this lecture we'll add the where clause to the select query and see how we can filter the results using it.

In this lecture we'll see how we can make smarter conditions on strings using pattern matching with the like operator.

In this lecture we'll focus on the timestamp data type and see some manipulations we can do with dates.

In this lecture we'll see an important mathematical operation called the cartesian product, and we'll see how it applied to tables.

In this lecture we'll see how and where the cartesian product is performed in the select query

In this lecture we'll see how to use the cartesian product to retrieve information from more than one table.

In this lecture we'll see more complex joins queries.

In this lecture we'l see the aggregate functions to sum up a lot of values into one result.

In this lecture we'l see how to add a where cause to an aggregate query

In this lecture we'll see three basic sets operations from set's theory.

In this lecture w'll see how the sets operations are implemented and used in SQL queries.

In this lecture we'll make a short overview and see what a nested query is.

In this lecture we'll see how to use in and not in operators in sub queries.

In this lecture we'll see how to use the all and any operators in sub queries

In this lecture we'll see sub queries that use data from the outer queries.

In this lecture we'll see how to use the exists and not exists operators in sub queries.

In this lecture we'll see the group by clause and it's location and part in the select statement.

In this lecture we'll see how to use he group by clause

In this lecture we'll see how the where clause is combined with the group by.