The Complete Microsoft SQL Server from Scratch: Bootcamp by Microsoft Certified Professional

Course overview - 63

• Course Introduction

• Course Curriculum overview

• Overview of Databases

• Microsoft SQL Server Installation

• Microsoft SQL Management Studio Installation

• Connecting to MS-SQL (Windows Authentication)

• Connecting to MS-SQL (SQL Server Authentication)

• Overview of Challenges

• SQL Statement Basic

• SELECT Statement

• SELECT DISTINCT

• Column AS Statement

• SQL COUNT Function

• SELECT WHERE Clause – One

• SELECT WHERE Clause – Two

• SQL ORDER BY statement

• TOP in MSSQL

• BETWEEN

• IN Operator in SQL

• LIKE statement

• Overview of GROUP BY

• Aggregation Function – SUM()

• Aggregation Function – MIN()-MAX()

• GROUP BY – One(theory)

• GROUP BY – Two(practical)

• HAVING

• Task on HAVING

• Overview Assessment Test 1

• Assessment Test 1

• Solution to Assessment Test 1

• Overview of JOINS

• Introduction to JOINS

• SQL table AS Statement

• INNER Join

• Full Outer Join

• Left Outer Join

• Right Outer Join

• Union

• Basic of Advanced SQL Commands

• Timestamp

• Extract from Timestamp

• Mathematical Scalar Functions

• String Functions

• SubQuery

• Basic of Database and Tables

• MS SQL Data Types

• Select Data type on SSMS

• Create Table on SSMS

• How to set Primary Key

• How to set Foreign Key

• Create Table using SQL Script

• SQL Insert Statement

• SQL Update statement

• SQL Delete statement

• SQL Alter Table statement

• SQL Drop Table

• SQL Drop Table

• Check Constraint

• NOT NULL Constraint

• UNIQUE Constraint

• Overview of Database and Tables

• Creating a Database backup using SSMS

• Restoring a Database from backup using SSMS