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

What is Azure Data Studio

Azure Data Studio Installation steps

Azure Data Studio to Connect SQL Server

Create a Database

Create a Table

Insert Data rows

view the Data returned by Query

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

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

SELECT 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

String functions

Sub Query

SELECT with calculations

Create stored procedure

Stored procedure with parameter

Installing SandDance Extension

Visualization Charts

Multiple Table Data Charts

Type Decision for Data Analysis

Data Analysis with Case Statement and String Text

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