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
Watch Online SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
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 commentsSimilar courses
Azure Data Pipelines with Terraform
Sources: Andreas Kretz
Azure is becoming an increasingly popular platform for companies using the Microsoft365 ecosystem. If you want to enhance your data engineering skills...
4 hours 20 minutes 29 seconds
Relational Data Modeling
Sources: Eka Ponkratova
Relational modeling is widely used in building transactional databases. You might say, "But I'm not planning to become a backend engineer."
1 hour 52 minutes
Machine Learning A-Z : Become Kaggle Master
Sources: udemy
Want to become a good Data Scientist? Then this is a right course for you. This course has been designed by IIT professionals who have mastered in Mathematics and Data Science....
36 hours 23 minutes 54 seconds
SQL & MySQL Subqueries: Understanding the weird parts
Sources: udemy
Master the Art of SQL Subqueries with this Comprehensive Course - Take Your Data Management Skills to the Next Level! Whether you're a beginner or an ...
8 hours 53 minutes 49 seconds
Deep Learning A-Z™: Hands-On Artificial Neural Networks
Sources: udemy
Artificial intelligence is growing exponentially. There is no doubt about that. Self-driving cars are clocking up millions of miles, IBM Watson is diagnosing pa
22 hours 36 minutes 30 seconds
Want to join the conversation?
Sign in to comment