SQL & Database Design A-Z
Course Materials
Download the course materials here
Description
Are you pursuing a career in Data Science or Data Analytics? If so, working with databases is something you’ll undoubtedly encounter.
So how do you interact with databases efficiently? The answer: SQL.
SQL, or Structured Query Language, is the essential tool used to manage databases—allowing you to organize, insert, and extract data on demand.
In this course, you’ll learn how to write effective SQL queries using PostgreSQL, one of the most widely used SQL variants. Even if your workplace uses a different system like Oracle, SQL Server, or MySQL, the skills taught here are easily transferable across platforms.
But what makes this course stand out from the many SQL courses available?
Alongside mastering SQL, you’ll gain a deep understanding of Database Design—a key differentiator that will significantly enhance your value as a Data Scientist or Analyst.
You’ll explore topics such as:
OLAP vs OLTP (Online Analytical Processing vs Online Transaction Processing): Understand the purpose and structural differences between analytical and transactional databases.
Database Normalization: Learn the theory and practice of normalizing databases through step-by-step exercises.
Schemas: Discover the differences between snowflake, star, and other schema types, and how to use them effectively.
Why does this matter?
While database design isn’t a mandatory skill for every Data Scientist or Analyst, it’s an extremely valuable asset. Understanding how databases are structured helps you navigate them more efficiently, extract insights faster, and become more effective in your role.
This course was created specifically with Data Scientists and Analysts in mind. If you want to accelerate your career in Data Science, this course is the right place to start.
We look forward to seeing you in the course,
Kirill & Ilya