SQL Bootcamp: Complete SQL Course

You will learn many tips and tricks in PostgreSQL to query data through the following Topics covered in this course:

Using Real World PostgreSQL Database Airlines Database.

What is a Database

SQL database for beginners.

Installing PostgreSQL database.

Creating Tables in database using SQL.

Drop table from SQL database

SELECT Statement use with SQL database data querying

WHERE Clause use with SQL database data querying

Operators used with Where clause in SQL database data querying .

AND & OR use with SQL database data querying

like use with SQL database data querying .

Filtering Operators use with SQL database data querying .

ORDER BY use with SQL database data querying .

LIMIT use with SQL database data querying .

DISTINCT use with SQL database data querying .

Renaming Column in SQL database.

Functions use with SQL database data querying .

GROUP BY & HAVING Clauses use with database data querying .

Aggregation Queries in SQL database.

CASE Clause use with database data querying .

Time & date data in SQL in database.

Table Joins in SQL database.

INNER and OUTER Joins in SQL database.

UNION, UNION ALL, INTERSECT and EXCEPT Clauses use with SQL database data querying.

Sub–queries use with SQL database data querying .