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

12h 32m 7s
English
Paid
November 22, 2024

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.

More

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!

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

Join premium to watch
Go to premium
# Title Duration
1 Intro Video 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

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

Deep Learning A-Z™: Hands-On Artificial Neural Networks
Learn MySQL and Solve 42 Practical Problems

Learn MySQL and Solve 42 Practical Problemsudemy

Duration 4 hours 24 minutes 35 seconds
Data Analysis for Beginners: Excel & Pivot Tables
The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert
100 Days Of Code: The Complete Web Development Bootcamp 2022
Effective Database Design

Effective Database DesignBen Brumm

Duration 1 hour 3 minutes 56 seconds
Complete linear algebra: theory and implementation

Complete linear algebra: theory and implementationudemy

Duration 32 hours 53 minutes 26 seconds
Complete SQL Mastery

Complete SQL Masterycodewithmosh (Mosh Hamedani)

Duration 10 hours 47 minutes 7 seconds
SQL & MySQL Subqueries: Understanding the weird parts

SQL & MySQL Subqueries: Understanding the weird partsudemy

Duration 8 hours 53 minutes 49 seconds