arrow_back
Intrroduction
Introduction
Course Curriculum
How to get course requirements
Getting started on Windows, Linux or Docker
How to ask great questions
FAQ’s
Source Code File
SQL Server Setting up
Section Introduction
Microsoft SQL Server Installation
SQL Server Management Studio (SSMS) Installation
How to connect MS SQL (Windows Authentication)
How to connect MS SQL (SQL Server Authentication)
Download and Restore Sample Database
SQL Database Basic
Section Introduction
Overview of Databases
Creating Database
SQL Data Types
Column Data Types on SSMS
Creating Table
Overview of Primary Key and Foreign Key
Primary Key
Foreign Key
Creating Temporary tables
SQL DML (Data Manipulation Language)
Section Introduction
Insert statement
Update statement
Delete statement
SQL DDL (Data Definition Language)
Section Introduction
CREATE table statement
DROP statement
ALTER statement
TRUNCATE statement
COMMENT in query
RENAME
SQL DCL (Data Control Language)
Create Database user
GRANT permissions
REVOKE permissions
SQL Statement Basic
Section Introduction
SQL Statement basic
SELECT Statement
SELECT DISTINCT
SELECT with column headings
Column AS statement
Filtering Data Rows
SELECT WHERE Clause – theory
SELECT WHERE Clause – practical
Aggregate Functions
Sum()
Min()-Max()
SQL Query Statements
Order By statement
SELECT TOP clause in SQL
BETWEEN command
IN operator
Wildcard Characters and LIKE
SQL Group by Statement
Section Introduction
Group by – theory
Group by – practical
HAVING statement
JOINS
Overview of Joins
What are Joins
Inner join
Left outer join
Right outer join
Full outer join
Union
Cross join
Query Exercise
Solution for Query Exercise
SQL Constraints
Section introduction
Check constraint
NOT NULL constraint
UNIQUE constraint
Views
Creating Views
Reporting with multiple tables
Advanced SQL Commands
Section Introduction
Timestamp
Extract from timestamp
Mathematical scalar functions
String functions
Sub Query
SELECT with calculations
SQL Stored Procedures
Create stored procedure
Stored procedure with parameter
Import & Export Data
Section Introduction
Import Flat File
Import .csv or excel file
Export Data to Excel or any format
Backup and Restore Database
Section Introduction
Creating Database backup
Restoring Database backup