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

19,931 students enrolled

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

19,931 students enrolled

Created by Kirill Eremenko, Ilya Eremenko, SuperDataScience Team

Last updated 6/2020

English

English [Auto], French [Auto],

Preview this course

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

$119.99 $199.99 40% off

2 days left at this price!

30-Day Money-Back Guarantee

12.5 hours on-demand video
4 articles
Full lifetime access
Access on mobile and TV

Certificate of Completion

Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business

What you'll 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

+ – Introduction

4 lectures 03:20

Preview 02:17

Some Additional Resources!!

Preview 00:06

BONUS: Learning Paths

00:51

Get the materials

00:05

+ – Installation

5 lectures 22:38

Welcome to this section! This is what you wil learn

Preview 00:19

Updates on Udemy Reviews

01:09

Installation: PostgreSQL & PgAdmin 4 for Windows

10:02

Installation: PostgreSQL & PgAdmin 4 for MAC OS

03:07

Installation: MS SQL Server & MS SQL Server Management Studio (SSMS) for Windows

08:01

+ – Preparation

6 lectures 30:13

Welcome to this section! This is what you will learn

00:20

The challenge: Investigating Consumer Complaints

02:42

Upload Consumer Complaints

06:02

Getting To Know The PGADMIN

07:28

Upload COnsumer COmplaints MS SQL

09:15

Getting to know MS SQL SERVER

04:26

+ – Basics of SQL

12 lectures 01:29:00

Welcome to this section! This is what you will learn

00:28

Theory Select Query

03:51

Time to write your first query in PostgreSQL

Preview 07:39

Adding a filter using WHERE in PostgreSQL

06:15

Logical conditions AND, OR in PostgreSQL

08:10

Using wildcards % and _ (advanced tutorial)

10:39

Comments in SQL

04:40

Getting to write your first query MS SQL

11:02

Where MS SQL

09:51

Logical conditions, AND OR MS SQL

11:09

Using wildcards MS SQL

10:10

Comments in SQL MS SQL

05:06

Basics of SQL quiz

4 questions

+ – Working With Data

15 lectures 01:44:20

Welcome to this section! This is what you will learn

00:39

The challenge: Analyzing Console Games Sales

03:29

Uploading Console Games Dataset

03:55

Working with arithmetic data types

10:37

ORDER BY

05:57

WORKING WITH VARCHARS

04:28

WORKING WITH DATES

Preview 17:37

Implicit Data Conversion in SQL

06:01

WORKING WITH NULL

10:54

Uploading Console Games DATASET MS SQL

04:58

Working with arithmetic data types MS SQL

11:07

ORDER BY MS SQL

07:23

Working with VARCHAR MS SQL

04:38

Working with Dates MS SQL

09:25

Implicit DATA conversion MS SQL

03:12

Working With Data quiz

4 questions

+ – Fundamentals of Database Theory

6 lectures 22:35

Welcome to this section! This is what you will learn

00:20

Structured vs Unstructured Data

05:31

Elements Of a Database

02:55

Relational Keys

05:00

Relational Database

03:16

Functional Dependency

05:33

+ – Joining tables in SQL

23 lectures 03:02:27

Welcome to this section! This is what you wil learn

00:37

Types of Joins

06:18

Duplicates in Joins

02:32

Joining on multiple fields

05:21

The challenge: The Vet's Clinic

02:20

Upload the data

05:27

Your First Left Outer Join

08:55

Joins Tips & Tricks

09:46

Inner Join

11:43

Full Outer join

04:52

Joining on Multiple Fields (Practice)

11:09

Preview 09:50

Cleaning up your Join

07:27

Cross Join (advanced tutorial)

11:11

Upload The Data - MS SQL

08:15

Your First Left Outer Join - MS SQL

09:51

Joins Tips & Tricks - MS SQL

11:01

Inner Join - MS SQL

12:26

Full Outer Join - MS SQL

03:21

Joining on Multiple Fields (Practice) - MS SQL

12:01

Complex Joins - MS SQL

08:39

Cleaning Up Your Join - MS SQL

07:56

Cross Join (advanced tutorial) - MS SQL

11:29

+ – Creating Tables in SQL

11 lectures 01:13:06

Welcome to this section! This is what you will learn

00:22

Create Database

04:04

Preview 13:12

Insert Data

13:29

Alter Table

09:24

Drop Table

07:27

Create Database MS SQL

02:53

Create Table MS SQL

06:02

Insert Data MS SQL

07:46

ALTER TABLE MS SQL

06:14

DROP TABLE MS SQL

02:13

Creating Tables in SQL quiz

4 questions

+ – Database Design

20 lectures 03:44:50

Welcome to this section! This is what you wil learn

00:52

In this tutorial, you will learn why you should know how the databases design and why it is essential for data scientists

MS SQL Server: What is Database Normalization?

Preview 07:14

Prime and non-prime attributes

10:05

First Normal Form (1NF)

07:54

Second Normal Form (2NF)

16:05

Third Normal Form (3NF)

19:13

The challenge: Online Clothing Store (OLTP Database)

04:32

Upload the data

03:35

Normalization 1NF Investigation

07:54

Normalization 2NF Investigation

15:41

Normalization 2NF Modification

12:53

Normalization 3NF Investigation

17:23

Normalization 3NF Modification

18:25

Upload The Data - MS SQL

04:30

Normalization 1NF Investigation - MS SQL

07:09

Normalization 2NF Investigation - MS SQL

15:21

Normalization 2NF Modification - MS SQL

16:37

Normalization 3NF Investigation - MS SQL

17:21

Normalization 3NF Modification - MS SQL

19:26

THANK YOU bonus video

02:40

+ – Bonus Lectures

1 lecture 01:51

***YOUR SPECIAL BONUS***

01:51

Requirements

A basic knowledge of computers

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

Who this course is for:

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

Featured review

Leon Sirghii ( 15 courses, 15 reviews )

a year ago

Kirill is simply the best instructor on Udemy! His courses are def top quality and the way he explains things is just amazing! There are very few instructors here that will engage you in same way, after taking his course, other instructors seemed really "meh" for me. Well done Kirill, keep it up! Don't think twice before purchasing his courses.