This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MS SQL Server + PostgreSQL - SQL and DB Design Master Class
Installation
001 Welcome to this section This is what you wil learn (0:19)
002 Installation PostgreSQL PgAdmin 4 for Windows (10:02)
003 Installation PostgreSQL PgAdmin 4 for MAC OS (3:08)
004 Installation MS SQL Server MS SQL Server Management Studio SSMS for Windows (8:02)
Preparation
005 Welcome to this section This is what you will learn (0:21)
006 The challenge Investigating Consumer Complaints (2:42)
007 Upload Consumer Complaints (6:03)
008 Getting To Know The PGADMIN (7:29)
009 Upload COnsumer COmplaints MS SQL (9:15)
010 Getting to know MS SQL SERVER (4:27)
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
038 Welcome to this section This is what you will learn (0:20)
039 Structured vs Unstructured Data (5:32)
040 Elements Of a Database (2:56)
041 Relational Keys (5:00)
042 Relational Database (3:16)
043 Functional Dependency (5:33)
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)
092 Normalization 1NF Investigation - MS SQL
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock