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 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
SQL - The Complete Guide (MySQL, PostgreSQL & more)
Sources: Academind Pro
SQL is THE most important query language you can learn! It's used by many popular database management systems like MySQL or PostgreSQL. But it's also used by data analysis and b...
19 hours 35 minutes 38 seconds
Data Analysis for Beginners: Python & Statistics
Sources: zerotomastery.io
This course is your first step into the world of data analysis using one of the main tools for analysts - Python. Without complicated terms, advanced...
6 hours 34 minutes 20 seconds
SQL and PostgreSQL: The Complete Developer's Guide
Sources: udemy, Stephen Grider
SQL and PostgreSQL: The Complete developer’s Guide is a comprehensive SQL language training course and PostgreSQL database management system . Nowadays, all app
22 hours 1 minute
The Data Bootcamp: Transform your Data using dbt™
Sources: udemy
Are you looking for a cutting-edge way to extract load and transform your data? Do you want to know more about dbt™ and how to use it? Well, this is the course
4 hours 10 minutes 51 seconds