Learn Both SQL Server & PostgreSQL By Doing. Enhance Your Data Analytics Career With Real World Data Science Exercises
InstructorKirill Eremenko
Free
Free
Instruction covers core concepts like queries, joins, and table creation across both PostgreSQL (using PgAdmin 4) and MS SQL Server (using SSMS).
Editorial course preview
These 4 complementary views highlight concrete, legible examples from the course presentation.
This screenshot demonstrates the practical outcome of executing a complex SQL query in pgAdmin, showing how multiple tables are joined to extract specific pet and procedure details.
This screenshot displays the pgAdmin 4 interface where a user is debugging a SQL query that fails due to an ambiguous column reference during a join operation.
This screenshot displays the pgAdmin statistics dashboard, featuring real-time monitoring graphs for server activity and a detailed list of current database connections.
The PostgreSQL official website download page is displayed, highlighting the available Windows installer options for setting up the database environment.
The curriculum includes a dedicated focus on database design, specifically investigating 1NF, 2NF, and 3NF schemas.
The technical scope focuses on basic syntax, leaving out more advanced topics such as grouping or mathematical functions. One signal suggests this lack of depth predates the displayed update; while the update label may have addressed it, it does not prove a correction.
Learners may encounter minor hurdles when setting up newer software versions compared to the original course material.
This course is best suited for beginners who want to understand how to structure databases and interact with multiple SQL engines simultaneously.
Score breakdown
The curriculum covers essential normalization theory and basic syntax, though it lacks more complex functions and deep subquery instruction.
Includes dataset preparation and hands-on exercises to apply concepts in practical scenarios.
Learner signals are mixed; while some find explanations clear, others report issues with audio volume and content repetition.
The material remains functional, though learners may need to troubleshoot newer software versions during setup.
The curriculum aligns well with the goal of learning both PostgreSQL and database design for data-oriented roles.