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
Complete Machine Learning and Data Science: Zero to Mastery
Sources: udemy, zerotomastery.io
This is a brand new Machine Learning and Data Science course just launched January 2020 and updated this month with the latest trends and skills! Become a complete Data Scientis...
43 hours 22 minutes 23 seconds
The Data Engineering Bootcamp: Zero to Mastery
Sources: zerotomastery.io
Learn to build streaming pipelines with Apache Kafka and Flink, create data lakes on AWS, run ML workflows on Spark, and integrate LLM models into...
13 hours 23 minutes 15 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
The Data Science Course: Complete Data Science Bootcamp 2023
Sources: udemy
Data scientist is one of the best suited professions to thrive this century. It is digital, programming-oriented, and analytical. Therefore, it comes as no surp
31 hours 14 minutes 14 seconds
SQL for Data Engineers
Sources: Andreas Kretz
SQL is the foundation for working with relational databases. And if you are planning to work in the field of Data Engineering, knowing SQL is not just a...
1 hour 51 minutes