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

Related courses

Frequently asked questions

What are the prerequisites for enrolling in this course?
This course does not list any specific prerequisites, making it accessible to beginners. However, a basic understanding of data concepts may be beneficial. The course covers essential SQL installations and tools like PostgreSQL, PgAdmin 4, MS SQL Server, and MS SQL Server Management Studio, which will be thoroughly explained in the initial lessons.
What kind of projects will I work on during the course?
Throughout the course, you will engage in hands-on projects such as investigating consumer complaints, analyzing console games sales, and a challenge involving a vet's clinic. These projects are designed to give practical experience in handling real-world databases using SQL and database design principles.
Who is the target audience for this course?
The course is primarily aimed at aspiring Data Scientists and Data Analysts who wish to gain proficiency in SQL and database design. It is also suitable for anyone interested in learning about OLAP vs. OLTP databases, normalization, and other database management concepts.
How does this course compare to other SQL courses?
Unlike many SQL courses that focus solely on query writing, this course also emphasizes database design. It teaches the theory and practice of database normalization and covers OLAP vs. OLTP databases, providing a more comprehensive understanding of database management.
What database management systems are covered in the course?
The course includes lessons on PostgreSQL and MS SQL Server. It covers the installation and use of PostgreSQL with PgAdmin 4 and MS SQL Server with Management Studio. These lessons provide a solid foundation in using these popular database management systems.
What topics are not covered in this course?
The course does not cover other SQL variations like Oracle or MySQL in detail. While it provides skills transferable to these systems, specific installation or advanced features unique to those platforms are not included.
How much time should I expect to commit to this course?
The course consists of 98 lessons. While the total runtime is not specified, learners should plan to allocate time to watch the lessons, complete exercises, and work on projects. The course structure suggests a commitment suitable for a comprehensive learning experience.