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.62 (4477 reviews)
34 755
students
67.5 hours
content
Oct 2023
last update
$89.99
regular price
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
Course Gallery
Loading charts...
Comidoc Review
Our Verdict
Though this extensive PostgreSQL Bootcamp provides learners with a comprehensive education in the subject matter and showcases the instructor's deep technical knowledge, there are areas for improvement, such as organizing the course structure and providing deeper content in advanced sections. Despite some limitations, the practical examples, helpful tips, and positive production quality make it an appealing option for those looking to expand their understanding of PostgreSQL.
What We Liked
- Covers a wide range of PostgreSQL topics, making it a comprehensive resource for learners seeking to gain extensive knowledge in the subject.
- High-quality production value, including clear audio and good video quality, ensuring a pleasant learning experience.
- Instructor demonstrates thorough technical knowledge, offering valuable insights and lesser-known tips that can enhance one's understanding of PostgreSQL.
- Provides real-world examples and exercises to help learners better understand the practical applications of various concepts.
Potential Drawbacks
- The course structure could be improved, as some learners may struggle with the repetitive nature of short videos in each section.
- Several learners have expressed difficulty setting up their terminal on Windows to access the database.
- Lacks a replication section, which was promised by the instructor and could be beneficial for those interested in PostgreSQL administration.
- The course's advanced sections may lack depth, with repetitive content that could be condensed to provide more focused coverage of critical details.
Related Topics
3499600
udemy ID
14/09/2020
course created date
18/01/2021
course indexed date
Bot
course submited by