SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
12h 32m 7s
English
Paid
Course description
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.
Read more about the course
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
0:00
/ #1: Intro Video
All Course Lessons (98)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 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 subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
Dimensional Data Modeling
Sources: Eka Ponkratova
In today's world, where data plays a key role, effective organization of information is the foundation for quality analytics and report building.
1 hour 37 minutes 57 seconds
Master SQL Queries From Basic to Advanced
Sources: Kamran Ahmed
The course is designed for developers, data analysts, and anyone working with databases. It covers the entire range of SQL queries - from basics to advanced...
MySQL High Performance Tuning Guide
Sources: udemy
Tips for Tuning MySQL like a Pro. Learn how to prevent MySQL performance problems. Understand how MySQL optimizes and executes queries.
2 hours 49 minutes 22 seconds
Storing & Visualizing Time Series Data
Sources: Andreas Kretz
Processing, storing, and visualizing time series data is becoming an increasingly important task. From IoT data and system logs to statistics...
2 hours 11 minutes 34 seconds
PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours
Sources: udemy
Subqueries? Yes, Recursive CTEs? Yes, Server programming with SQL and PL/pgSQL, Stored Procedures? Yes, Window Functions? Yes indeed and much more... This compr
67 hours 20 minutes 55 seconds