Learn Both SQL Server & PostgreSQL By Doing. Enhance Your Data Analytics Career With Real World Data Science Exercises
InstructorKirill EremenkoInstruction covers core concepts like queries, joins, and table creation across both PostgreSQL (using PgAdmin 4) and MS SQL Server (using SSMS).
The curriculum includes a dedicated focus on database design, specifically investigating 1NF, 2NF, and 3NF schemas.
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.
Free
Free
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.
The curriculum aligns well with the goal of learning both PostgreSQL and database design for data-oriented roles.