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
Database DevOps from Start to Finish
Sources: iamtimcorey.com (Tim Corey)
If you have only ever built a database using SQL Server Management Studio (SSMS), you are in for a treat. SQL Server Data Tools (SSDT) is designed for building
2 hours 40 minutes 37 seconds
Python for Data Science and Machine Learning Bootcamp
Sources: udemy
Are you ready to start your path to becoming a Data Scientist! This comprehensive course will be your guide to learning how to use the power of Python to analy
24 hours 49 minutes 42 seconds
Introduction to Data Engineering
Sources: zerotomastery.io
Companies of all sizes have access to enormous amounts of data, but the problem is that the data is often unstructured. In order to answer important...
57 minutes 26 seconds
Machine Learning & Containers on AWS
Sources: Andreas Kretz
In this practical course, you will learn how to build a complete data pipeline on the AWS platform - from obtaining data from the Twitter API to analysis, stora
1 hour 33 minutes 34 seconds
Apache Kafka Fundamentals
Sources: Andreas Kretz
In this course, you will acquire the basic knowledge necessary for confidently starting to work with Apache Kafka. You will learn how to set up a message...
1 hour 4 minutes 52 seconds