4.45 out of 5
4.45
2079 reviews on Udemy

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
Instructor:
Kirill Eremenko
13,446 students enrolled
English [Auto-generated] More
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

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

Introduction

1
Intro Video
2
Some Additional Resources!!

Installation

1
Welcome to this section! This is what you wil learn
2
Updates on Udemy Reviews
3
BONUS: Learning Paths
4
Installation: PostgreSQL & PgAdmin 4 for Windows
5
Installation: PostgreSQL & PgAdmin 4 for MAC OS
6
Installation: MS SQL Server & MS SQL Server Management Studio (SSMS) for Windows

Preparation

1
Welcome to this section! This is what you will learn
2
The challenge: Investigating Consumer Complaints
3
Upload Consumer Complaints
4
Getting To Know The PGADMIN
5
Upload COnsumer COmplaints MS SQL
6
Getting to know MS SQL SERVER

Basics of SQL

1
Welcome to this section! This is what you wil learn
2
Theory Select Query
3
Time to write your first query in PostgreSQL
4
Adding a filter using WHERE in PostgreSQL
5
Logical conditions AND, OR in PostgreSQL
6
Using wildcards % and _ (advanced tutorial)
7
Comments in SQL
8
Getting to write your first query MS SQL
9
Where MS SQL
10
Logical conditions, AND OR MS SQL
11
Using wildcards MS SQL
12
Comments in SQL MS SQL
13
Basics of SQL quiz

Working With Data

1
Welcome to this section! This is what you wil learn
2
The challenge: Analyzing Console Games Sales
3
Uploading Console Games Dataset
4
Working with arithmetic data types
5
ORDER BY
6
WORKING WITH VARCHARS
7
WORKING WITH DATES
8
Implicit Data Conversion in SQL
9
WORKING WITH NULL
10
Uploading Console Games DATASET MS SQL
11
Working with arithmetic data types MS SQL
12
ORDER BY MS SQL
13
Working with VARCHAR MS SQL
14
Working with Dates MS SQL
15
Implicit DATA conversion MS SQL
16
Working With Data quiz

Fundamentals of Database Theory

1
Welcome to this section! This is what you will learn
2
Structured vs Unstructured Data
3
Elements Of a Database
4
Relational Keys
5
Relational Database
6
Functional Dependency

Joining tables in SQL

1
Welcome to this section! This is what you wil learn
2
Types of Joins
3
Duplicates in Joins
4
Joining on multiple fields
5
The challenge: The Vet's Clinic
6
Upload the data
7
Your First Left Outer Join
8
Joins Tips & Tricks
9
Inner Join
10
Full Outer join
11
Joining on Multiple Fields (Practice)
12
Complex Joins
13
Cleaning up your Join
14
Cross Join (advanced tutorial)
15
Upload The Data - MS SQL
16
Your First Left Outer Join - MS SQL
17
Joins Tips & Tricks - MS SQL
18
Inner Join - MS SQL
19
Full Outer Join - MS SQL
20
Joining on Multiple Fields (Practice) - MS SQL
21
Complex Joins - MS SQL
22
Cleaning Up Your Join - MS SQL
23
Cross Join (advanced tutorial) - MS SQL

Creating Tables in SQL

1
Welcome to this section! This is what you will learn
2
Create Database
3
Create Table
4
Insert Data
5
Alter Table
6
Drop Table
7
Create Database MS SQL
8
Create Table MS SQL
9
Insert Data MS SQL
10
ALTER TABLE MS SQL
11
DROP TABLE MS SQL
12
Creating Tables in SQL quiz

Database Design

1
Welcome to this section! This is what you wil learn
2
MS SQL Server: What is Database Normalization?

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

3
Prime and non-prime attributes
4
First Normal Form (1NF)
5
Second Normal Form (2NF)
6
Third Normal Form (3NF)
7
The challenge: Online Clothing Store (OLTP Database)
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
2079 Ratings

Detailed Rating

Stars 5
1060
Stars 4
694
Stars 3
238
Stars 2
54
Stars 1
33
550df21062622faa7432e1b9b2d89ad0
30-Day Money-Back Guarantee

Includes

13 hours on-demand video
3 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion