[Udemy] SQL & Database Design A-Z: Learn MS SQL Server + PostgreSQL [2018, ENG]

–
Introduction
02:23
Intro Video
Предварительный просмотр
02:17
Some Additional Resources!!
Предварительный просмотр
00:06
–
Installation
21:29
Welcome to this section! This is what you wil learn
Предварительный просмотр
00:19
Installation: PostgreSQL & PgAdmin 4 for Windows
10:02
Installation: PostgreSQL & PgAdmin 4 for MAC OS
03:07
Installation: MS SQL Server & MS SQL Server Management Studio (SSMS) for Windows
08:01
–
Preparation
30:13
Welcome to this section! This is what you will learn
00:20
The challenge: Investigating Consumer Complaints
02:42
Upload Consumer Complaints
06:02
Getting To Know The PGADMIN
07:28
Upload COnsumer COmplaints MS SQL
09:15
Getting to know MS SQL SERVER
04:26
–
Basics of SQL
01:29:00
Welcome to this section! This is what you wil learn
00:28
Theory Select Query
03:51
Time to write your first query in PostgreSQL
Предварительный просмотр
07:39
Adding a filter using WHERE in PostgreSQL
06:15
Logical conditions AND, OR in PostgreSQL
08:10
Using wildcards % and _ (advanced tutorial)
10:39
Comments in SQL
04:40
Getting to write your first query MS SQL
11:02
Where MS SQL
09:51
Logical conditions, AND OR MS SQL
11:09
Using wildcards MS SQL
10:10
Comments in SQL MS SQL
05:06
Basics of SQL quiz
4 вопроса
–
Working With Data
01:44:20
Welcome to this section! This is what you wil learn
00:39
The challenge: Analyzing Console Games Sales
03:29
Uploading Console Games Dataset
03:55
Working with arithmetic data types
10:37
ORDER BY
05:57
WORKING WITH VARCHARS
04:28
WORKING WITH DATES
Предварительный просмотр
17:37
Implicit Data Conversion in SQL
06:01
WORKING WITH NULL
10:54
Uploading Console Games DATASET MS SQL
04:58
Working with arithmetic data types MS SQL
11:07
ORDER BY MS SQL
07:23
Working with VARCHAR MS SQL
04:38
Working with Dates MS SQL
09:25
Implicit DATA conversion MS SQL
03:12
Working With Data quiz
4 вопроса
–
Fundamentals of Database Theory
22:35
Welcome to this section! This is what you will learn
00:20
Structured vs Unstructured Data
05:31
Elements Of a Database
02:55
Relational Keys
05:00
Relational Database
03:16
Functional Dependency
05:33
–
Joining tables in SQL
03:02:27
Welcome to this section! This is what you wil learn
00:37
Types of Joins
06:18
Duplicates in Joins
02:32
Joining on multiple fields
05:21
The challenge: The Vet's Clinic
02:20
Upload the data
05:27
Your First Left Outer Join
08:55
Joins Tips & Tricks
09:46
Inner Join
11:43
Full Outer join
04:52
Joining on Multiple Fields (Practice)
11:09
Complex Joins
Предварительный просмотр
09:50
Cleaning up your Join
07:27
Cross Join (advanced tutorial)
11:11
Upload The Data - MS SQL
08:15
Your First Left Outer Join - MS SQL
09:51
Joins Tips & Tricks - MS SQL
11:01
Inner Join - MS SQL
12:26
Full Outer Join - MS SQL
03:21
Joining on Multiple Fields (Practice) - MS SQL
12:01
Complex Joins - MS SQL
08:39
Cleaning Up Your Join - MS SQL
07:56
Cross Join (advanced tutorial) - MS SQL
11:29
–
Creating Tables in SQL
01:13:06
Welcome to this section! This is what you will learn
00:22
Create Database
04:04
Create Table
Предварительный просмотр
13:12
Insert Data
13:29
Alter Table
09:24
Drop Table
07:27
Create Database MS SQL
02:53
Create Table MS SQL
06:02
Insert Data MS SQL
07:46
ALTER TABLE MS SQL
06:14
DROP TABLE MS SQL
02:13
Creating Tables in SQL quiz
4 вопроса
–
Database Design
03:42:10
Welcome to this section! This is what you wil learn
00:52
What is Database Normalization?
Предварительный просмотр
07:14
Prime and non-prime attributes
10:05
First Normal Form (1NF)
07:54
Second Normal Form (2NF)
16:05
Third Normal Form (3NF)
19:13
The challenge: Online Clothing Store (OLTP Database)
04:32
Upload the data
03:35
Normalization 1NF Investigation
07:54
Normalization 2NF Investigation
15:41
Normalization 2NF Modification
12:53
Normalization 3NF Investigation
17:23
Normalization 3NF Modification
18:25
Upload The Data - MS SQL
04:30
Normalization 1NF Investigation - MS SQL
07:09
Normalization 2NF Investigation - MS SQL
15:21
Normalization 2NF Modification - MS SQL
16:37
Normalization 3NF Investigation - MS SQL
17:21
Normalization 3NF Modification - MS SQL
19:26
–
Bonus Lectures
01:59
***YOUR SPECIAL BONUS***
01:59