The Complete Microsoft SQL Server from Scratch: Bootcamp by Microsoft Certified Professional
By Sekhar Metla, IT Analyst Cum Trainer
This course is for you
Learn SQL, The first step to MSSQL you need to learn to succeed in SQL database application development, it is easy to learn and understand our online MSSQL Training course is designed for you with the complete steps to require to learn real-world dynamic Database. Mr. Sudha Sekhar(MCP) will explain to you even complex topics to simplify and teach you even beginners can understand easily with real-world data science exercises.
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
Meet your instructor
