PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours

Subqueries? Yes, Recursive CTEs? Yes, Server programming with SQL and PL/pgSQL, Stored Procedures? Yes, Window Functions? Yes indeed and much more…

I’ve design this course from step–by–step move from basic to advanced topics. Here is a partial list of some of the topics that are covered in 50+ sections and 60+ hours of this course:

Apply powerful SQL commands to store, update and retrieve information

Step–by–step walkthrough to perform simple to complex SQL queries

How to create a database from the scratch, Creating and modifying tables

Using UPSERT for INSERT and UPDATE at the same time

Query data with ORDER BY, Logical operators, and filters

Understand PostgreSQL various data types with examples

Data type conversions with CAST, and conversion functions

Create your own user–defined data types

Explore table and column constraints, create multiple composite constraints, see data integrity operations

Create your own custom sequences

Parsing data with queries using string functions

Aggregate data with aggregate functions

Date/Time data types, Intervals, and handling timezones

Grouping Data with GROUP BY, conditional filter with HAVING

Joining Multiple Tables with various joins techniques

Combining Queries together with UNION, INTERSECT, and EXCEPT

Understand and create PostgreSQL Schemas, ownership, security privileges

Constructing arrays and ranges, query array data with conditional filters