Learn SQL Using PostgreSQL: From Zero to Hero
Master PostgreSQL starting with basics to advanced features like triggers, PL/pgSQL functions, Window Functions and CTE
4.70 (3571 reviews)
18 878
students
16 hours
content
Sep 2021
last update
$79.99
regular price
What you will learn
Perform sophisticated queries
Join tables together
Use Group By to answer questions on aggregated date
Create and modifying tables
Create indexes to improve search speed
Put in constraints to keep data clean
Use pgAdmin tool
Learn recursive queries
How views make accessing data simpler
Subqueries
Sequences to auto increment fields
Common Table Expressions
Conditional Expressions
Window Functions
How to handle date and time data
SQL Functions
Transactions and Concurrency Control
PL/pgSQL Functions
Triggers
Composite Data Types
Array Data Types
Course Gallery
Charts
Students
Price
Rating & Reviews
Enrollment Distribution
Comidoc Review
Our Verdict
This PostgreSQL course excels in offering a wide-ranging curriculum that covers various SQL topics, including unique PostgreSQL features. With abundant resources and real-world examples shared by an experienced instructor, it provides valuable insights for beginners and seasoned users alike. However, some inconsistencies in audio quality and interaction may detract slightly from the overall learning experience.
What We Liked
- The course provides a comprehensive overview of various SQL and PostgreSQL topics, catering well to both beginners and those already familiar with some SQL
- Topics specific to PostgreSQL like schemas, composite types, PL/pgSQL, user/database management, and advanced features are discussed in-depth
- Real-world use cases, personal experiences shared by the instructor, and a step-by-step approach make learning engaging
- A wide range of resources, practical examples, exercises, and supplementary materials accompany each topic, facilitating hands-on practice
Potential Drawbacks
- Some 'try it yourself' sections may not require the solution provided, allowing for different, potentially confusing answers
- Typos in the course content can be misleading and cause minor inconveniences for beginners following along with the examples
- The audio quality is inconsistent at times, making the instructor hard to understand
- Lack of interactivity such as graded tests or group work might make the learning experience less dynamic
Related Topics
1368384
udemy ID
01/10/2017
course created date
23/04/2020
course indexed date
Bot
course submited by