Preview Complete Microsoft SQL Server from Scratch: Bootcamp

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

Preview - Complete Microsoft SQL Server from Scratch: Bootcamp