English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 103 lectures (12h 35m) | 4.54 GB
Learn Both SQL Server & PostgreSQL By Doing. Enhance Your Data Analytics Career With Real World Data Science Exercises
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.
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!
What you’ll learn
- Create basic SQL Queries
- Create advanced SQL Queries
- Create Left, Right, Inner and Full Outer joins
- Create new tables, alter existing tables in Databases
- Normalize Databases
- Understand database design
- Understand first, second and third normal form schemas
Table of Contents
Introduction
1 Intro Video
2 Some Additional Resources
3 Learning Paths
4 Get the materials
5 Your Shortcut To Becoming A Better Data Scientist
Installation
6 Welcome to this section This is what you wil learn
7 Installation PostgreSQL PgAdmin 4 for Windows
8 Installation PostgreSQL PgAdmin 4 for MAC OS
9 Installation MS SQL Server MS SQL Server Management Studio SSMS for Windows
Preparation
10 Welcome to this section This is what you will learn
11 The challenge Investigating Consumer Complaints
12 Upload Consumer Complaints
13 Getting To Know The PGADMIN
14 Upload COnsumer COmplaints MS SQL
15 Getting to know MS SQL SERVER
Basics of SQL
16 Welcome to this section This is what you will learn
17 Theory Select Query
18 Time to write your first query in PostgreSQL
19 Adding a filter using WHERE in PostgreSQL
20 Logical conditions AND OR in PostgreSQL
21 Using wildcards and advanced tutorial
22 Comments in SQL
23 Getting to write your first query MS SQL
24 Where MS SQL
25 Logical conditions AND OR MS SQL
26 Using wildcards MS SQL
27 Comments in SQL MS SQL
Working With Data
28 Welcome to this section This is what you will learn
29 The challenge Analyzing Console Games Sales
30 Uploading Console Games Dataset
31 Working with arithmetic data types
32 ORDER BY
33 WORKING WITH VARCHARS
34 WORKING WITH DATES
35 Implicit Data Conversion in SQL
36 WORKING WITH NULL
37 Uploading Console Games DATASET MS SQL
38 Working with arithmetic data types MS SQL
39 ORDER BY MS SQL
40 Working with VARCHAR MS SQL
41 Working with Dates MS SQL
42 Implicit DATA conversion MS SQL
Fundamentals of Database Theory
43 Welcome to this section This is what you will learn
44 Structured vs Unstructured Data
45 Elements Of a Database
46 Relational Keys
47 Relational Database
48 Functional Dependency
Joining tables in SQL
49 Welcome to this section This is what you wil learn
50 Types of Joins
51 Duplicates in Joins
52 Joining on multiple fields
53 The challenge The Vets Clinic
54 Upload the data
55 Your First Left Outer Join
56 Joins Tips Tricks
57 Inner Join
58 Full Outer join
59 Joining on Multiple Fields Practice
60 Complex Joins
61 Cleaning up your Join
62 Cross Join advanced tutorial
63 Upload The Data MS SQL
64 Your First Left Outer Join MS SQL
65 Joins Tips Tricks MS SQL
66 Inner Join MS SQL
67 Full Outer Join MS SQL
68 Joining on Multiple Fields Practice MS SQL
69 Complex Joins MS SQL
70 Cleaning Up Your Join MS SQL
71 Cross Join advanced tutorial MS SQL
Creating Tables in SQL
72 Welcome to this section This is what you will learn
73 Create Database
74 Create Table
75 Insert Data
76 Alter Table
77 Drop Table
78 Create Database MS SQL
79 Create Table MS SQL
80 Insert Data MS SQL
81 ALTER TABLE MS SQL
82 DROP TABLE MS SQL
Database Design
83 Welcome to this section This is what you wil learn
84 MS SQL Server What is Database Normalization
85 Prime and nonprime attributes
86 First Normal Form 1NF
87 Second Normal Form 2NF
88 Third Normal Form 3NF
89 The challenge Online Clothing Store OLTP Database
90 Upload the data
91 Normalization 1NF Investigation
92 Normalization 2NF Investigation
93 Normalization 2NF Modification
94 Normalization 3NF Investigation
95 Normalization 3NF Modification
96 Upload The Data MS SQL
97 Normalization 1NF Investigation MS SQL
98 Normalization 2NF Investigation MS SQL
99 Normalization 2NF Modification MS SQL
100 Normalization 3NF Investigation MS SQL
101 Normalization 3NF Modification MS SQL
102 THANK YOU Video
Special Offer
103 YOUR SPECIAL BONUS
Resolve the captcha to access the links!