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

Learn about Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions...

4.49 (3118 reviews)

Udemy

platform

English

language

Databases

What you will learn

Learn with 60+ hours of hands-on practical exercises

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

Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions, and much more

How to create a database from scratch

Creating and using various Data types

Creating User-defined data types

Table and Column constraints

Understanding, Using, and creating custom Sequences

String Functions

Aggregate Functions

Date/Time Functions with query analysis

Grouping data with group sets

Schemas creations and privileges

Table Partitioning techniques

Exploring Array Functions

In-depth JSON data types and queries

Subqueries

Common Table Expressions (CTEs)

Recursive Common Table Expressions

Advanced Window Functions

Server Programming

Functions with SQL Language

Functions with PL/pgSQL Language

Exploring Stored Procedures

Indexes and queries performance optimizations

Multiple Data Views types and Security

Using Regular Expressions for Text Patterns

Power Text Searches with special data types and indexes

Crosstab Reports with crosstab extensions

Making our database for global languages - Internationalization

psql Utility Commands

Understanding PostgreSQL Internals

Triggers

Using Cursors

Data integrity with Transactions and Savepoints

Managing PostgreSQL security

Extended PostgreSQL echosystem

Analyze sample HR, Stocks, Northwind, Global Trades databases

Practice with huge number of queries

Use SQL to perform data analysis

Confident putting SQL and PostgreSQL on your resume

Why take this course?

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
Storing data with JSONB objects and Indexing
Query performance optimization with indexes, understanding indexes nodes and outputs
Create and update regular and materialize views
Simple to advances step-by-step Subqueries
Creating Common Table Expressions (CTEs), and recursive CTEs queries
Making data into group sets
Simple to advanced Windows Functions
Using regular expressions for text patterns
Powerful text searches in PostgreSQL
Create and exploring table partitioning techniques
Server programming with SQL and PL/pqSQL
Creating Stores Procedures
Extending PostgreSQL echosystem with custom indexes, and aggregate functions
Creating, and executing Triggers
Using Cursors
pqsql Utility Commands
Creating Crosstab reports
Making our database for storing global language data - Internationalization
Running queries with PostgreSQL transactions
Crating, and Managing PostgreSQL Security
All about PostgreSQL internals on how data gets stored and much more
Running hundreds of queries on sample databases like HR, Northwind, Stock Markets, Word Trades database

This comprehensive course will teach you everything about PostgreSQL to use in your next big project!

Master the PostgreSQL database, and see how to apply it with real world database and queries. Sign up today and master PostgreSQL!

Screenshots

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

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

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

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

Reviews

Sheila

November 6, 2023

None of the course videos are playing. I can hear the instructor, but no video as he is explaining what to do. I have tried this on Chrome, Safari, and Firefox. I have logged out and back in with no luck. I can watch videos from other instructors for other classes. This is a class added to our company's career path, as SQL is required for several management positions.

Cihad

October 30, 2023

Tablo yaratmayla ve kayıt eklemeyle çok uğraşıyor. Sanki 60+ saat dedik bir şekilde doldurmalıyız der gibi yavaş ve çok sıkıcı anlatıyor.

Linda

July 17, 2023

I do not like the fact he keeps saying these are advanced features. I expect him to go into it and explain them

Vladyslav

July 3, 2023

Great course overall. Cons: - a little bit chaotic from middle part as for me - strange structure of materials provided, plus if they available - used from long ago ( by lecture number). - you should to recheck official documentation for each section, cause course a little bit outdated and a bit confusing in a few points due to chaotic structure mentioned above

Swapnil

June 27, 2023

Content is pretty good but there is no support from the creator if we stuck somewhere or have any doubt in any topic. Asked by doubt long back but still its not been answered.

Jeremy

June 19, 2023

Pros : - Excellent coverage of PostGreSQL Cons : - Repetion, repetion, repetion, ... this course can be twice shorter if the professor did not repeat the same things over and over again. - Reading, without giving much context - Sometimes, the instructor uses a SQL clause that he never talked before - The mock data is often so badly chosen : how can you show how to use ORDER clause on multiple columns if there is no repetition among columns ? This course is not for beginner, you will need to look at Google to find complementary information. Nevertheless, if you are patient, you will find everything you need to know here

Chiwuzoh

May 26, 2023

For a basic course where you claim you need no prior knowledge this is really disappointing! There is no explanation of basic concepts e.g. about the choice of data types for the database columns. The content is also scattered. The delivery is also very bad and monotonic.

Brian

May 18, 2023

I love this course so far because it's hands on. I already know that I will be able to master the information because this is how I learn best.

Aleksei

May 14, 2023

The course is quite verbose, and it is definitely not a bootcamp. It feels more like skimming through the documentation: it covers many topics, but only touches on some of them briefly. I struggled to progress through the course. There are numerous short (1-5 minute) videos in each section. The material feels repetitive and somewhat dry. Examples of various statements are provided, but they don't convey much about the bigger picture. Having multiple short videos is exhausting. It's difficult to navigate and difficult to watch, as the player is constantly flickering switching videos. Hearing multiple intros and outros ("hello, in this video we will talk about...", etc) every couple of minutes is exhausting. Also, it seems like there is no real progress, as there are still literally hundreds of videos ahead. I fail to understand what was the target audience for this course. From other reviews, I see that complete beginners struggle to keep up, but I watched the videos at 2x speed and still felt bored. It is unclear why a beginner would spend an hour learning about creating custom data types or why more advanced learners would devote 5+ hours to very basic select queries. The course is quite lengthy. An hour is spent on explaining the GROUP BY statement without delving into the internals. One could read about this simple operation in PostgreSQL documentation in just five minutes. I am dreading the upcoming section on indexes, which is more than four hours long. I will likely search for a more concise course about Postgres.

Naman

May 11, 2023

Please improve voice quality for your tutorials in near future. Information wise this course is good.

Monika

April 23, 2023

I am happy that it coverages such great amount of topics, there is too much talking for me, but I am just using the faster play. It is very detailed with many many examples. Easy to understand.

Emmanuel

April 20, 2023

Very detailed course, learnt a lot. There are some areas where the volume of the tutor's voice fluctuated between sections, also the tutor should create a small video showing how the terminal can be set up on windows to access the db, i just could not get it to work on my own. Lastly, i was looking forward to a replication section which the tutor promised to cover but did not see that. Otherwise I would really love to appreciate the efforts and time put in to create this very lengthy course. Everyone who wants to take a look into this has to dedicate a huge chunk of their time. Overall, worth the while!

Norlan

March 30, 2023

I recommend this to my colleague. Very interesting and knowledgeable. Happy to learned and refreshing this course. Thank you!

Michael

March 26, 2023

The course is absolute immense in scope, and the instructor is VERY knowledgeable and good in instructing, but as a beginner the total lack of exercises/assignments is not reinforcing the theory learnt in the course. IF the course had exercises it would easy be a 5 star course

Himanshu

March 10, 2023

This course is very vast, and it requires a lot of discipline and consistency to finish it. But after completion I feel more confident in SQL. Now I have way more knowledge than my peers. I would like to thank the instructor for putting so much effort into this course !!!

Charts

Price

Rating

Enrollment distribution

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