Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft SQL Server And T-SQL Course For Beginners
Common Misconceptions
What Is SQL? (4:15)
What Is SQL Server? (4:10)
Self-Troubleshooting
Setting Up SQL Server & SSMS
Download SQL Server 2017 (1:19)
Install SQL Server 2017 (2:56)
Download SQL Server Management Studio (1:00)
Install SQL Server Management Studio (0:49)
Connect to SQL Server (0:42)
How Is Data Stored In SQL Server?
Simple Hierarchy (6:51)
Why Relational? (10:19)
Indexes (10:35)
DDL In SQL Server
Data Definition Language Commands (1:24)
How To Create? (18:08)
How To Modify? (5:32)
How To Truncate? (1:46)
How To Drop? (4:08)
Normalization (9:57)
Download and Import Adventure Works Database (2:16)
More On Index Creation (7:57)
DML In SQL Server
Data Manipulation Language Commands (1:04)
Begin With Retrieval (8:58)
Scalar Functions (12:37)
Sorting (3:53)
Column And Row Logic (13:14)
Joins (13:47)
Distinct Data (3:08)
Aggregate Functions (16:59)
SubQueries (18:35)
Set Operations (9:01)
Manipulate Data (5:32)
DCL in SQL Server
Data Control Language Commands (2:36)
Grant And Revoke (2:36)
Practical SQL Scenarios
Introduction To Section (0:29)
Problem 1 (4:41)
Problem 2 (7:51)
Problem 3 (12:24)
Problem 4 (6:52)
Problem 5 (14:30)
Problem 6 (5:34)
Problem 7 (13:18)
Problem 8 (5:35)
Resources
Source Code
Problem 6
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock