BPB E Learning

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

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

Key

Creating Temporary tables

Section Introduction

Insert Statement

Update Statement

Delete Statement

Section Introduction

CREATE Table Statement

DROP Statement

ALTER Statement

TRUNCATE Statement

COMMENT In Query

Rename

Create Database User

GRANT permissions

REVOKE permissions

Section Introduction

SQL Statement Basic

Select Statement

Select Distinct

With Column Headings

Column AS Statement

SELECT WHERE Clause – theory

SELECT WHERE Clause – practical

Sum()

Min()-Max()

Order By Statement

Select Top Clause in SQL

Between Command

In Operator

Wildcard Characters And Like

Section Introduction

Group By – Theory

Group By – practical

Having Statement

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

Section Introduction

Check Constraint

Not Null Constraint

Unique Constraint

Creating Views

Reporting with Multiple Tables

Section Introduction

Timestamp

Extract From Timestamp

Mathematical Scalar Functions

Sub Query

SELECT With Calculations

String Functions

Create Stored Procedure

Stored Procedure With Parameter

Section Introduction

Import Flat File

Import .csv or Excel File

Export Data To Excel Or Any Format

Section Introduction

Creating Database Backup

Restoring Database Backup