Skip to content
UdemyPostgreSQLPaid courseAll LevelsCertificate

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL (Udemy.com)

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

Created by: Kirill Eremenko

Last updated April 2025

Our take

Based on the ratings of 5,426 students, a sample of their written reviews and the syllabus, as the course stood in April 2025. No course pays to be reviewed.

This is Kirill Eremenko's beginner SQL course, co-taught with Ilya Eremenko and built around two databases. It runs 12.7 hours over 103 lectures, teaching PostgreSQL first and then repeating the material in Microsoft SQL Server. The longest section, about 225 minutes, covers database design and normalization. The syllabus shows basic queries, joins and creating tables, with only three quizzes and no coding exercises. It suits people heading into data work who have never written a query.

Reviewers like the steady pace and clear explanations, and a couple single out normalization as the best part. One says it improved their efficiency at work. The complaints repeat, though. The SQL Server half mostly covers the same ground, and some say it feels like two courses stitched together. Audio volume swings between videos, and one co-presenter's microphone is noisy. A few want more advanced topics, such as subqueries. The two lowest reviews call it padded and over-explained.

The course was last updated in April 2025 and holds a 4.7 average across about 5,400 ratings, most of them four or five stars. One recent reviewer had to troubleshoot newer software versions during setup. Reviewers mostly treat it as a gentle first step, especially for the design material. Anyone who already knows basic SQL will likely find it slow, since reviewers call it basic and repetitive.

Best forBeginners heading into data analytics who want SQL plus normalization and OLAP vs OLTP basics.
Skip it ifYou want advanced SQL such as subqueries, or dislike seeing each lesson repeated on a second database.

Pros

  • Steady, easy-to-follow teaching that reviewers say suits people who have never used SQL
  • Normalization and database design get the longest section, and one reviewer calls it the best coverage they have seen
  • Repeating the lessons in SQL Server helps some students lock in the material
  • One reviewer reports better efficiency at work and a firmer grasp of relational database fundamentals

Cons

  • The SQL Server half largely repeats the PostgreSQL lessons, which some find padded
  • Audio volume is uneven between videos, and one presenter's mic is noisy
  • Stays basic: reviewers ask for subqueries and other advanced topics, and there are no coding exercises
This is a great course to introduce SQL to someone who has never used SQL before. It has a steady pace and what I really like is that you revise your learning on POSTGRESQL again on MS SQL SERVER.
Rahul Jayakumar, a student

Listed for all levels, but really a beginner course. Only basic computer skills are needed, and it stays at entry level.

icon
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 content

10 sections · 103 lectures · 13 hours of video 3 quizzes, 4 articles

  1. 1Introduction 2 free previews4 lectures · 4 min
  2. 2Installation 1 free preview4 lectures · 21 min
  3. 3Preparation6 lectures · 31 min
  4. 4Basics of SQL 1 free preview12 lectures · 1 quiz · 1.5 hours
  5. 5Working With Data 1 free preview16 lectures · 1 quiz · 1.9 hours
  6. 6Fundamentals of Database Theory6 lectures · 23 min
  7. 7Joining tables in SQL 1 free preview23 lectures · 3 hours
  8. 8Creating Tables in SQL 1 free preview11 lectures · 1 quiz · 1.2 hours
  9. 9Database Design 1 free preview20 lectures · 3.8 hours
  10. 10Congratulations!!1 lecture · 1 min

Who it is for

The instructor says it suits

  • Anybody who wants to learn PostgreSQL
  • Anybody who wants to better understand how databases work
  • Anybody who wants to enhance their Data Science career

What you need before you start

  • A basic knowledge of computers

How it compares

Against the other 47 rated Udemy courses in PostgreSQL on CourseDuck:

  • Rating4.7 out of 5higher than 93% of them
  • Reviews5,426#8 of 48 by number of reviews
  • Length12.7 hourslonger than 85% of them
  • Last updatedApril 2025more recently than 57% of them

icon
Course Description

Are you interested in a career in Data Science or Data Analytics?

In that case, inevitably you are going to encounter databases in your work.

But how do you interact with databases?

The answer is simple: SQL 

SQL stands for Structured Query Language and this is one of the main tools used to organize databases, input data into them and extract it on request.

In this course you will learn how to create queries in a popular variation of SQL called PostgreSQL. 

And even if at your workplace you are using a different variation (e.g. Oracle, SQL Server or MySQL), you will find that the skills you learn in this course are easily transferable.

But there are many SQL courses out there, so the question is:

What makes this course stand out?

The unique advantage of this course is that in addition to learning SQL you will also master the concepts of Database Design.

We will cover off topics such as:

- OLAP vs OLTP databases (Online Analytics Processing & Online Transaction Processing): you will understand exactly how and why the designs of these two types of Databases differ

- Normalization of Databases: we will show you the theory behind normalization AND together we will practice how to normalize a Database step-by-step

Why is that important?

Knowing how databases are designed is not a compulsory skill to have for a Data Scientist / Analyst. However, it's a HUGE added benefit.

These skills will allow you to better interact with databases and derive results and extract insights from your data faster.

This course is designed with the Data Scientists and Analysts in mind, so if you want to propel your Data Science career, then this course is for you!

We look forward to seeing you inside,

Kirill & Ilya

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Kirill Eremenko

My name is Kirill Eremenko and I am super-psyched that you are reading this!

Professionally, I come from the Data Science consulting space with experience in finance, retail, transport and other industries. I was trained by the best analytics mentors at Deloitte Australia and since starting on Udemy I have passed on my knowledge to thousands of aspiring data scientists.

From my courses you will straight away notice how I combine my real-life experience and academic background in Physics and Mathematics to deliver professional step-by-step coaching in the space of Data Science. One of the strongest sides of my teaching style is that I focus on intuitive explanations, so you can be sure that you will truly understand even the most complex topics.

To sum up, I am absolutely and utterly passionate about Data Science and I am looking forward to sharing my passion and knowledge with you!

icon
More courses by Kirill Eremenko

$159.99

$189.99

$119.99

$139.99

$149.99

$17.99

icon
More PostgreSQL courses

$159.99

$139.99

$129.99

$139.99

$74.99

$54.99

icon
Reviews

4.7

5,426 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Tristan de Beer on 7/2/2026

It's enjoyabled so far, despite having done the course much later than it's release date and therefore having to do a bit of troubleshooting with newer software to get myself up and running. I do wish we could see the status bar on the bottom of your pgadmin/ ssms so we could easily reference results visually. Also, the audio level between videos is not consistent and in general is quite low.

By Ruben Araujo on 9/21/2020

An amazing course indeed! The instructors know what they are talking about, and don't edit out their own "mistypes", which is important to show that everyone makes simple mistakes. It is a humane way of teaching. Plus, the repetition aspect of using PostGre SQL and MS SQL, using the same exercises, serves to learn through repetition. Also, a big thanks to Daniel Labbe, for being the best TA I ever saw in a Udemy course! :) I have done two courses with Super Data Science and I am now on my third with Data Science A-Z, in hopes of landing a job in the area and changing career from Engineering to Data Science!

By Paul Cullen on 8/15/2020

This is the second course I have taken on Udemy with the Super Data Science team. Kirill and Ilya's enthusiasm is infectious and they lay out what is fairly complex material in an easy to understand and logical manner, making the complex accessible. My favorite part of the course (albeit the most difficult) was the content on database design and normalization. It really clicked for me after watching a few times and I can honestly say I now have a much better understanding of the relational databases I deal with day to day. Also big thumbs up for the tutorials which keep the student actively engaged. Can't recommend highly enough and really like Kirill and Ilya's immense knowledge, teaching style and most of all their enthusiasm and modesty! Thanks!

By Duc Hong on 7/13/2020

It's a good course, and I learned a lot not knowing a whole lot about SQL and it's coding part. I like the way the Instructors presented the materials, and going through the exercises to really understanding the concepts of SQL in a simple way. I would like to see some sections on how SQL is connected through Python with coding and Tableau for the visualization. Also update software to the latest MS SQL Server to 2019, and re-do some of the video as the sound quality is low.

By Fabian Styven Cubas Puente on 7/1/2020

I really like and enjoy the course. It was what I need. I didn't know which course would be the best for me. So I saw the rating, and the comments and I decide for this course. I think it has a lot of relevant information and an specific order for any step.

By Jody-Ann Jones on 1/12/2020

Awesome course. Just improve the audio and it will be perfect. The volume is a little too low. I had to max out my volume so I could hear you properly. Overall great job guys. Thank you for consistently producing valuable content and contributing to the data science community.

By Kerry Benjamin on 12/11/2017

I've taken other SQL courses before but this course made me feel like I really understand SQL and how to use it. Plus, being able to follow along with PostgreSQL on my own machine felt easy and really beneficial. I'm ready to put these skills into use and dive deeper into database design.

By Cristian Sanchez on 6/6/2017

I feel like I learned a lot in this course. It teaches how to make queries and analyze databases, and also some principles of database design. The instructor explains things very well and the format of the course is very efficient in my opinion. There is one thing that to me is both a pro and a con. Because they teach you how to use PostgreSQL and Microsoft SQL, the topics of the lessons are repeated between both platforms. It's a good thing that you learn both, but at the same time it can be slightly boring. However I still give the course 5 stars because it was great and I learned a lot!!

By Aron Szrnka on 5/30/2017

This course is for beginners. Not all levels. Half of the course is Postgre and half is MS SQL but they show the same tasks. They show very basic queries. I haven't had experience with SQL before but the progress is a bit slow. There is much talk but the amount of information is not so much. I think a book can give whole lot information but this video is a more practical way to learn.

By Fred Watters on 1/13/2017

I am running an iMac, dual booted to Windows and iOS in order to allow exploration of both environments. It is great to have a course that is teaching my both MS and open-source environments in order to be a more useful consultant in the future. It was a nice capstone after already completing the Data Science A-Z course.

By Alexej Vetuško

Too basic, very few new practical information

By Subhra Ray

Thank you for teaching me SQL through this course.

Showing 12 of 75 reviews

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100