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

12h 32m 7s
English
Paid

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 is one of the main tools used to organize databases, input data into them, and extract it upon request. In this course, you will learn how to create queries in a popular variation of SQL called PostgreSQL.

Even if your workplace uses a different variation (e.g., Oracle, SQL Server, or MySQL), the skills you learn in this course are easily transferable. But with many SQL courses available, you might wonder:

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.

Topics Covered

  • 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 explain the theory behind normalization and practice how to normalize a database step-by-step.

Why Is Database Design Important?

  • While not mandatory for Data Scientists or Analysts, understanding database design is a significant added benefit.
  • This knowledge enables you to interact with databases more effectively and extract insights from your data faster.
  • Designed with Data Scientists and Analysts in mind, taking this course can accelerate your Data Science career.

About the Author: udemy

udemy thumbnail
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams. Udemy is the leading global marketplace for teaching and learning, connecting millions of students to the skills they need to succeed. Udemy helps organizations of all kinds prepare for the ever-evolving future of work. Our curated collection of top-rated business and technical courses gives companies, governments, and nonprofits the power to develop in-house expertise and satisfy employees’ hunger for learning and development.

Watch Online 98 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 98 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Intro Video
All Course Lessons (98)
#Lesson TitleDurationAccess
1
Intro Video Demo
02:18
2
Welcome to this section! This is what you wil learn
00:20
3
Installation: PostgreSQL & PgAdmin 4 for Windows
10:03
4
Installation: PostgreSQL & PgAdmin 4 for MAC OS
03:08
5
Installation: MS SQL Server & MS SQL Server Management Studio (SSMS) for Windows
08:02
6
Welcome to this section! This is what you will learn
00:21
7
The challenge: Investigating Consumer Complaints
02:43
8
Upload Consumer Complaints
06:04
9
Getting To Know The PGADMIN
07:30
10
Upload COnsumer COmplaints MS SQL
09:16
11
Getting to know MS SQL SERVER
04:27
12
Welcome to this section! This is what you will learn
00:29
13
Theory Select Query
03:52
14
Time to write your first query in PostgreSQL
07:41
15
Adding a filter using WHERE in PostgreSQL
06:16
16
Logical conditions AND, OR in PostgreSQL
08:11
17
Using wildcards % and _ (advanced tutorial)
10:40
18
Comments in SQL
04:41
19
Getting to write your first query MS SQL
11:03
20
Where MS SQL
09:52
21
Logical conditions, AND OR MS SQL
11:10
22
Using wildcards MS SQL
10:11
23
Comments in SQL MS SQL
05:07
24
Welcome to this section! This is what you will learn
00:40
25
The challenge: Analyzing Console Games Sales
03:31
26
Uploading Console Games Dataset
03:56
27
Working with arithmetic data types
10:38
28
ORDER BY
05:58
29
WORKING WITH VARCHARS
04:29
30
WORKING WITH DATES
17:38
31
Implicit Data Conversion in SQL
06:02
32
WORKING WITH NULL
10:56
33
Uploading Console Games DATASET MS SQL
04:59
34
Working with arithmetic data types MS SQL
11:08
35
ORDER BY MS SQL
07:25
36
Working with VARCHAR MS SQL
04:40
37
Working with Dates MS SQL
09:26
38
Implicit DATA conversion MS SQL
03:13
39
Welcome to this section! This is what you will learn
00:21
40
Structured vs Unstructured Data
05:32
41
Elements Of a Database
02:56
42
Relational Keys
05:01
43
Relational Database
03:17
44
Functional Dependency
05:34
45
Welcome to this section! This is what you wil learn
00:38
46
Types of Joins
06:19
47
Duplicates in Joins
02:33
48
Joining on multiple fields
05:22
49
The challenge: The Vet's Clinic
02:22
50
Upload the data
05:28
51
Your First Left Outer Join
08:56
52
Joins Tips & Tricks
09:47
53
Inner Join
11:45
54
Full Outer join
04:53
55
Joining on Multiple Fields (Practice)
11:10
56
Complex Joins
09:51
57
Cleaning up your Join
07:28
58
Cross Join (advanced tutorial)
11:12
59
Upload The Data - MS SQL
08:16
60
Your First Left Outer Join - MS SQL
09:52
61
Joins Tips & Tricks - MS SQL
11:03
62
Inner Join - MS SQL
12:27
63
Full Outer Join - MS SQL
03:23
64
Joining on Multiple Fields (Practice) - MS SQL
12:02
65
Complex Joins - MS SQL
08:40
66
Cleaning Up Your Join - MS SQL
07:57
67
Cross Join (advanced tutorial) - MS SQL
11:30
68
Welcome to this section! This is what you will learn
00:23
69
Create Database
04:05
70
Create Table
13:13
71
Insert Data
13:30
72
Alter Table
09:25
73
Drop Table
07:28
74
Create Database MS SQL
02:54
75
Create Table MS SQL
06:03
76
Insert Data MS SQL
07:47
77
ALTER TABLE MS SQL
06:15
78
DROP TABLE MS SQL
02:14
79
Welcome to this section! This is what you wil learn
00:53
80
MS SQL Server: What is Database Normalization?
07:15
81
Prime and non-prime attributes
10:06
82
First Normal Form (1NF)
07:55
83
Second Normal Form (2NF)
16:06
84
Third Normal Form (3NF)
19:14
85
The challenge: Online Clothing Store (OLTP Database)
04:33
86
Upload the data
03:36
87
Normalization 1NF Investigation
07:55
88
Normalization 2NF Investigation
15:42
89
Normalization 2NF Modification
12:54
90
Normalization 3NF Investigation
17:24
91
Normalization 3NF Modification
18:26
92
Upload The Data - MS SQL
04:31
93
Normalization 1NF Investigation - MS SQL
07:10
94
Normalization 2NF Investigation - MS SQL
15:22
95
Normalization 2NF Modification - MS SQL
16:38
96
Normalization 3NF Investigation - MS SQL
17:23
97
Normalization 3NF Modification - MS SQL
19:27
98
THANK YOU Video
02:41
Unlock unlimited learning

Get instant access to all 97 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription