SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

Learn Both SQL Server & PostgreSQL By Doing. Enhance Your Data Analytics Career With Real World Data Science Exercises

4.42 (5351 reviews)

Udemy

platform

English

language

Data Science

What you will learn

Create basic SQL Queries

Create advanced SQL Queries

Create Left, Right, Inner and Full Outer joins

Create new tables, alter existing tables in Databases

Normalize Databases

Understand database design

Understand first, second and third normal form schemas

Course Gallery

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL – Screenshot 1 — Screenshot 1 – SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL – Screenshot 2 — Screenshot 2 – SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL – Screenshot 3 — Screenshot 3 – SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL – Screenshot 4 — Screenshot 4 – SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

Loading charts...

Comidoc Review

Our Verdict

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL serves as an informative and straightforward introduction to SQL for beginners. Real-world databases offer practical examples, providing a strong foundation in basic SQL concepts. However, important SQL features aren't fully explored, leaving the content less appealing for those preparing for job interviews. Technical issues such as low audio volume hamper the learning experience, but the easy-to-understand instructors help to alleviate these concerns. Although not without its flaws, this course provides sufficient insight into the world of SQL and database design for newcomers.

What We Liked

The course provides a solid foundation in SQL basics, making it approachable for beginners.
Real-world databases are used for practical applications throughout the course.
Clear and succinct instructors provide good basic tips that will be useful for further studies.
Real world data sets offer practical applications for learning.

Potential Drawbacks

The course lacks some advanced SQL features, such as 'Having', 'In/Not in', Aggregation Functions, Triggers, Functions, Views and Security.
Important but not advanced features are overlooked, making it less appealing for interview preparation.
Minimal practical problems with obvious answers limit the hands-on experience.
Sound issues affect multiple lessons, causing inconsistent volume levels.