Preview Microsoft SQL Server Bootcamp 2022: Go from Zero to Hero

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

Preview - Microsoft SQL Server Bootcamp 2022: Go from Zero to Hero