SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL
English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 12.5 Hours | 2.20 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!

We look forward to seeing you inside,

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

Installation
2 Welcome to this section This is what you wil learn
3 Installation PostgreSQL PgAdmin 4 for Windows
4 Installation PostgreSQL PgAdmin 4 for MAC OS
5 Installation MS SQL Server MS SQL Server Management Studio SSMS for Windows

Preparation
6 Welcome to this section This is what you will learn
7 The challenge Investigating Consumer Complaints
8 Upload Consumer Complaints
9 Getting To Know The PGADMIN
10 Upload COnsumer COmplaints MS SQL
11 Getting to know MS SQL SERVER

Basics of SQL
12 Welcome to this section This is what you wil learn
13 Theory Select Query
14 Time to write your first query in PostgreSQL
15 Adding a filter using WHERE in PostgreSQL
16 Logical conditions AND OR in PostgreSQL
17 Using wildcards and advanced tutorial
18 Comments in SQL
19 Getting to write your first query MS SQL
20 Where MS SQL
21 Logical conditions AND OR MS SQL
22 Using wildcards MS SQL
23 Comments in SQL MS SQL

Working With Data
24 Welcome to this section This is what you wil learn
25 The challenge Analyzing Console Games Sales
26 Uploading Console Games Dataset
27 Working with arithmetic data types
28 ORDER BY
29 WORKING WITH VARCHARS
30 WORKING WITH DATES
31 Implicit Data Conversion in SQL
32 WORKING WITH NULL
33 Uploading Console Games DATASET MS SQL
34 Working with arithmetic data types MS SQL
35 ORDER BY MS SQL
36 Working with VARCHAR MS SQL
37 Working with Dates MS SQL
38 Implicit DATA conversion MS SQL

Fundamentals of Database Theory
39 Welcome to this section This is what you will learn
40 Structured vs Unstructured Data
41 Elements Of a Database
42 Relational Keys
43 Relational Database
44 Functional Dependency

Joining tables in SQL
45 Welcome to this section This is what you wil learn
46 Types of Joins
47 Duplicates in Joins
48 Joining on multiple fields
49 The challenge The Vets Clinic
50 Upload the data
51 Your First Left Outer Join
52 Joins Tips Tricks
53 Inner Join
54 Full Outer join
55 Joining on Multiple Fields Practice
56 Complex Joins
57 Cleaning up your Join
58 Cross Join advanced tutorial
59 Upload The Data – MS SQL
60 Your First Left Outer Join – MS SQL
61 Joins Tips Tricks – MS SQL
62 Inner Join – MS SQL
63 Full Outer Join – MS SQL
64 Joining on Multiple Fields Practice – MS SQL
65 Complex Joins – MS SQL
66 Cleaning Up Your Join – MS SQL
67 Cross Join advanced tutorial – MS SQL

Creating Tables in SQL
68 Welcome to this section This is what you will learn
69 Create Database
70 Create Table
71 Insert Data
72 Alter Table
73 Drop Table
74 Create Database MS SQL
75 Create Table MS SQL
76 Insert Data MS SQL
77 ALTER TABLE MS SQL
78 DROP TABLE MS SQL

Database Design
79 Welcome to this section This is what you wil learn
80 What is Database Normalization
81 Prime and non-prime attributes
82 First Normal Form 1NF
83 Second Normal Form 2NF
84 Third Normal Form 3NF
85 The challenge Online Clothing Store OLTP Database
86 Upload the data
87 Normalization 1NF Investigation
88 Normalization 2NF Investigation
89 Normalization 2NF Modification
90 Normalization 3NF Investigation
91 Normalization 3NF Modification
92 Upload The Data – MS SQL
93 Normalization 1NF Investigation – MS SQL
94 Normalization 2NF Investigation – MS SQL
95 Normalization 2NF Modification – MS SQL
96 Normalization 3NF Investigation – MS SQL
97 Normalization 3NF Modification – MS SQL

Bonus Lectures
98 YOUR SPECIAL BONUS