arrow_back
The Complete SQL-MS-SQL
Introduction
Course Curriculum overview
Overview of Databases
SQL Environment Setup
MSSQL Installation
MSSQL SSMS Installation
Connecting to MS-SQL (Windows Authentication)
Connecting to MS-SQL (SQL Server Authentication)
SQL Statement Basics
Overview of Challenges
SQL statement basic
Select Statement
Select Distinct
Column AS Statement
Count
Filtering Data Rows
Select Clause – One
Select Where Clause – Two
SQL Query Operators
Order by
Top in MSSQL
Between
IN Operator - Condition
Like
Group by Statements
Overview of Group by
Aggregation Function – SUM()
Aggregation Function – MIN()-MAX()
Group by – One(theory)
Group by – Two(practical)
Having
Task on Having
Sol of Task on Having
Assessment Test 1
Join Assignment
Solution for Joins Assignment
Joins
Overview of joins
Introduction to Joins
AS Statement
Inner Join
Full Outer Join
Left Outer Join
Right Outer Join
Union
Advanced SQL Commands
Basic of Advanced SQL Commands
Timestamp
Extract from Timestamp
Mathematical Scalar Functions
String Functions
SubQuery
Creating Database and Tables
Basic of Database and Tables
Data Types
Select Datatype on SSMS
How to set Primary Key
How to set Foreign Key
Create Table using SQL Script
SQL CRUD Operations
Insert
Update
Delete
Alter Table
Drop Table
Check Constraint
Not Null Constraint
Unique Constraint
Backup and Restore Functions
Overview of Database and Tables
Creating a Database backup using SSMS
Restoring a Database from backup using SSMS