Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MS SQL Server: Learn MS SQL Server from Scratch
What We Will Learn?
Intro to the MS SQL Course? (3:21)
Introduction to sql, sql server, microsoft sql server, microsoft sql
What is database? (3:19)
RDBMS (Relational Database Management System) (2:24)
What is SQL/Query? (2:49)
FAQ about MS SQL
Database Normalization
Normal Forms (NF) (7:56)
Normalization (2:58)
Installation for MS SQL
Install MS SQL Server Express Edition 2019 (4:35)
Starting to SSMS
Create, Alter and Drop Database (8:46)
Starting To SSMS (SQL Server Management Studio) (5:08)
Create, Rename and Drop Table (13:42)
Data Types and Constraints (5:52)
Foreign Key Constraint (5:14)
Unique & Check Constraint (5:31)
Quiz
Manipulating Data for MS SQL
Insert Data to Table (10:05)
Update Data in A Table (5:42)
Delete Data and AdventureWorks (6:17)
Basic Select Statement
Select Statement and Alias (7:09)
Where Clause and Operators (10:49)
Quiz
Sorting and Grouping Data
Sorting and Grouping Data (13:28)
Quiz
Wildcard Operations
Like Clause (8:03)
IF-THEN Statement
Case Function (4:37)
Conversion Functions
Convert and Cast Function (8:32)
Retrieve Data From Multiple Tables
Left and Right Join (7:29)
Inner Join (7:05)
Full and Self Join (6:02)
Set Operations
Union Operators (5:35)
Intersect and Except Operators (6:25)
Subqueries in Ms sql
Subqueries With Select Statement (8:44)
Single Row & Multiple Row Subqueries (5:25)
Insert, Update and Delete Statement (7:23)
DateTime Functions
DateTime Function (14:39)
Converting DateTime (7:39)
String Functions in mssql
String Functions (8:58)
Math Functions
Math Functions (13:24)
SQL Transactions
SQL Transactions (6:10)
SQL Transactions Commands (8:00)
User Management
Create Logins (8:42)
Users & User Permissions (10:57)
Permissions & Roles (18:10)
What We Have Learned?
What we have learned? (6:57)
Intro to the MS SQL Course?
Complete and Continue