Installation
Preparation
Basics of SQL
-
011 Welcome to this section This is what you will learn (0:28)
-
012 Theory Select Query (3:51)
-
013 Time to write your first query in PostgreSQL (7:40)
-
014 Adding a filter using WHERE in PostgreSQL (6:16)
-
015 Logical conditions AND OR in PostgreSQL (8:11)
-
016 Using wildcards and _ advanced tutorial (10:39)
-
017 Comments in SQL (4:40)
-
018 Getting to write your first query MS SQL (11:02)
-
019 Where MS SQL (9:51)
-
020 Logical conditions AND OR MS SQL (11:09)
-
021 Using wildcards MS SQL (10:10)
-
022 Comments in SQL MS SQL (5:06)
Working With Data
-
023 Welcome to this section This is what you wil learn (0:39)
-
024 The challenge Analyzing Console Games Sales (3:30)
-
025 Uploading Console Games Dataset (3:56)
-
026 Working with arithmetic data types (10:37)
-
027 ORDER BY (5:57)
-
028 WORKING WITH VARCHARS (4:28)
-
029 WORKING WITH DATES (17:37)
-
030 Implicit Data Conversion in SQL (6:01)
-
031 WORKING WITH NULL (10:55)
-
032 Uploading Console Games DATASET MS SQL (4:58)
-
033 Working with arithmetic data types MS SQL (11:08)
-
034 ORDER BY MS SQL (7:24)
-
035 Working with VARCHAR MS SQL (4:39)
-
036 Working with Dates MS SQL (9:25)
-
037 Implicit DATA conversion MS SQL (3:12)
Fundamentals of Database Theory
Joining tables in SQL
-
044 Welcome to this section This is what you wil learn (0:37)
-
045 Types of Joins (6:18)
-
046 Duplicates in Joins (2:32)
-
047 Joining on multiple fields (5:21)
-
048 The challenge The Vets Clinic (2:21)
-
049 Upload the data (5:27)
-
050 Your First Left Outer Join (8:55)
-
051 Joins Tips Tricks (9:46)
-
052 Inner Join (11:44)
-
053 Full Outer join (4:52)
-
054 Joining on Multiple Fields Practice (11:09)
-
055 Complex Joins (9:50)
-
056 Cleaning up your Join (7:27)
-
057 Cross Join advanced tutorial (11:11)
-
058 Upload The Data - MS SQL (8:15)
-
059 Your First Left Outer Join - MS SQL (9:51)
-
060 Joins Tips Tricks - MS SQL (11:02)
-
061 Inner Join - MS SQL (12:26)
-
062 Full Outer Join - MS SQL (3:22)
-
063 Joining on Multiple Fields Practice - MS SQL (12:01)
-
064 Complex Joins - MS SQL (8:39)
-
065 Cleaning Up Your Join - MS SQL (7:56)
-
066 Cross Join advanced tutorial - MS SQL (11:29)
Creating Tables in SQL
-
067 Welcome to this section This is what you will learn (0:22)
-
068 Create Database (4:04)
-
069 Create Table (13:12)
-
070 Insert Data (13:30)
-
071 Alter Table (9:24)
-
072 Drop Table (7:27)
-
073 Create Database MS SQL (2:53)
-
074 Create Table MS SQL (6:02)
-
075 Insert Data MS SQL (7:46)
-
076 ALTER TABLE MS SQL (6:15)
-
077 DROP TABLE MS SQL (2:13)
Database Design
-
078 Welcome to this section This is what you wil learn (0:53)
-
079 What is Database Normalization (7:14)
-
080 Prime and non-prime attributes (10:05)
-
081 First Normal Form 1NF (7:54)
-
082 Second Normal Form 2NF (16:06)
-
083 Third Normal Form 3NF (19:13)
-
084 The challenge Online Clothing Store OLTP Database (4:32)
-
085 Upload the data (3:35)
-
086 Normalization 1NF Investigation (7:54)
-
087 Normalization 2NF Investigation (15:42)
-
088 Normalization 2NF Modification (12:53)
-
089 Normalization 3NF Investigation (17:23)
-
090 Normalization 3NF Modification (18:25)
-
091 Upload The Data - MS SQL (4:30)
-
092 Normalization 1NF Investigation - MS SQL (7:10)
-
093 Normalization 2NF Investigation - MS SQL (15:22)
-
094 Normalization 2NF Modification - MS SQL (16:37)
-
095 Normalization 3NF Investigation - MS SQL (17:22)
-
096 Normalization 3NF Modification - MS SQL (19:27)
