Module 1 Section 1: Introduction
Unit 1 Intro Video
Module 2 Section 2: It's super easy to get Started
Unit 1 Welcome to this section! This is what you will learn
Unit 2 Installation: PostgreSQL & PgAdmin 4 for Windows
Unit 3 Installation: PostgreSQL & PgAdmin 4 for MAC OS
Unit 4 Installation: MS SQL Server & MS SQL Server Management Studio (SSMS) for Windows
Module 3 Section 3: Preparation
Unit 1 Welcome to this section! This is what you will learn
Unit 2 The challenge: Investigating Consumer Complaints
Unit 3 Upload Consumer Complaints
Unit 4 Getting To Know The PGADMIN
Unit 5 Upload Consumer Complaints MS SQL
Unit 6 Getting to know MS SQL SERVER
Module 4 Section 4: Basics of SQL
Unit 1 Welcome to this section! This is what you will learn
Unit 2 Theory Select Query
Unit 3 Time to write your first query in PostgreSQL
Unit 4 Adding a filter using WHERE in PostgreSQL
Unit 5 Logical conditions AND, OR in PostgreSQL
Unit 6 Using wildcards % and _ (advanced tutorial)
Unit 7 Comments in SQL
Unit 8 Getting to write your first query MS SQL
Unit 9 Where MS SQL
Unit 10 Logical conditions, AND OR MS SQL
Unit 11 Using wildcards MS SQL
Unit 12 Comments in SQL MS SQL
Module 5 Section 5: Working With Data
Unit 1 Welcome to this section! This is what you will learn
Unit 2 The challenge: Analyzing Console Games Sales
Unit 3 Uploading Console Games Dataset
Unit 4 Working with arithmetic data types
Unit 5 ORDER BY
Unit 6 WORKING WITH VARCHARS
Unit 7 WORKING WITH DATES
Unit 8 Implicit Data Conversion in SQL
Unit 9 WORKING WITH NULL
Unit 10 Uploading Console Games DATASET MS SQL
Unit 11 Working with arithmetic data types MS SQL
Unit 12 ORDER BY MS SQL
Unit 13 Working with VARCHAR MS SQL
Unit 14 Working with Dates MS SQL
Unit 15 Implicit DATA conversion MS SQL
Module 6 Section 6: Fundamentals of Database Theory
Unit 1 Welcome to this section! This is what you will learn
Unit 2 Structured vs Unstructured Data
Unit 3 Elements Of a Database
Unit 4 Relational Keys
Unit 5 Relational Database
Unit 6 Functional Dependency
Module 7 Section 7: Joining tables in SQL
Unit 1 Welcome to this section! This is what you will learn
Unit 2 Types of Joins
Unit 3 Duplicates in Joins
Unit 4 Joining on multiple fields
Unit 5 The challenge: The Vet's Clinic
Unit 6 Upload the data
Unit 7 Your First Left Outer Join
Unit 8 Joins Tips & Tricks
Unit 9 Inner Join
Unit 10 Full Outer join
Unit 11 Joining on Multiple Fields (Practice)
Unit 12 Complex Joins
Unit 13 Cleaning up your Join
Unit 14 Cross Join (advanced tutorial)
Unit 15 Upload The Data - MS SQL
Unit 16 Your First Left Outer Join - MS SQL
Unit 17 Joins Tips & Tricks - MS SQL
Unit 18 Inner Join - MS SQL
Unit 19 Full Outer Join - MS SQL
Unit 20 Joining on Multiple Fields (Practice) - MS SQL
Unit 21 Complex Joins - MS SQL
Unit 22 Cleaning Up Your Join - MS SQL
Unit 23 Cross Join (advanced tutorial) - MS SQL
Module 8 Section 8: Creating Tables in SQL
Unit 1 Welcome to this section! This is what you will learn
Unit 2 Create Database
Unit 3 Create Table
Unit 4 Insert Data
Unit 5 Alter Table
Unit 6 Drop Table
Unit 7 Create Database MS SQL
Unit 8 Create Table MS SQL
Unit 9 Insert Data MS SQL
Unit 10 Alter Table MS SQL
Unit 11 Drop Table MS SQL
Module 9 Section 9: Database Design
Unit 1 Welcome to this section! This is what you wil learn
Unit 2 What is Database Normalization?
Unit 3 Prime and non-prime attributes
Unit 4 First Normal Form (1NF)
Unit 5 Second Normal Form (2NF)
Unit 6 Third Normal Form (3NF)
Unit 7 The challenge: Online Clothing Store (OLTP Database)
Unit 8 Upload the data
Unit 9 Normalization 1NF Investigation
Unit 10 Normalization 2NF Investigation
Unit 11 Normalization 2NF Modification
Unit 12 Normalization 3NF Investigation
Unit 13 Normalization 3NF Modification
Unit 14 Upload The Data - MS SQL
Unit 15 Normalization 1NF Investigation - MS SQL
Unit 16 Normalization 2NF Investigation - MS SQL
Unit 17 Normalization 2NF Modification - MS SQL
Unit 18 Normalization 3NF Investigation - MS SQL
Unit 19 Normalization 3NF Modification - MS SQL
Powered By WP Courseware

Database Design & SQL

take-this-course

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
  • Schemas: what's the difference between a snowflake, star, and other schemas in a Database and how to use them to your advantage

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