CF

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

Udemy is the largest open marketplace for online courses on the internet. Founded in 2010 by Eren Bali, Oktay Caglar, and Gagan Biyani and headquartered in San Francisco, the company went public on the Nasdaq in 2021 under the ticker UDMY. The platform hosts well over two hundred thousand courses across software development, IT and cloud, data science, design, business, marketing, and creative skills, taught by tens of thousands of independent instructors. Roughly seventy million learners use it worldwide, and the corporate arm — Udemy Business — supplies a curated subset of that catalog to enterprise customers.

Because Udemy is a marketplace rather than a single editorial publisher, the catalog is uneven by design. The strongest material lives in the long-form, project-based courses authored by working engineers — full-stack JavaScript, React, Node.js, Python data science, AWS, Docker and Kubernetes, mobile development with Flutter and React Native, and cloud certification preparation. The CourseFlix listing under this source is the slice of that catalog that has been mirrored here for offline-friendly viewing, organized by topic and updated as new releases land. Pricing on Udemy itself swings dramatically with the site's near-permanent sales, which is why the platform is best treated as a deep reference catalog: pick instructors with strong reviews and a track record of updating their material rather than buying on the headline price alone.

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

Course content

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

Related courses

Frequently asked questions

What is SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL about?
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…
Who teaches SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL?
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL is taught by Udemy. You can find more courses by this instructor on the corresponding source page.
How long is SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL?
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL contains 98 lessons with a total runtime of 12 hours 32 minutes. All lessons are available to watch online at your own pace.
Is SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL free to watch?
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL is part of CourseFlix's premium catalog. A CourseFlix subscription unlocks the full video player; the course description, table of contents, and preview information are available to everyone.
Where can I watch SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL online?
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL is available to watch online on CourseFlix at https://courseflix.net/course/sql-database-design-a-z-learn-ms-sql-server-postgresql. The page hosts every lesson with the integrated video player; no download is required.