Home / techtutorials

MS SQL

Beginners

Overview
Syllabus

On Demand

Intro SQL Course For Beginners | Pluralsight

Microsoft SQL Server 2019 Essential Training | LinkedIn

Microsoft SQL For Beginners | Udemy

Online

SQL Server Tutorials | Mssqltips https://www.mssqltips.com/sql-server-tutorials/
SQL Server Tutorials | Edureka https://www.edureka.co/blog/sql-server-tutorial
MS SQL Server | Tutorialspoint https://www.tutorialspoint.com/ms_sql_server/index.htm

CLASSROOM

TSSQL Classroom Training | SQL School https://www.sqlschool.com/TSQL-Classroom-Training.html
Microsoft SQL Server Certification Training | Intellipaat https://intellipaat.com/microsoft-sql-server-certification-training/

What is MS SQL Server? Introduction, Version History
- What is SQL Server?
- Version History SQL Server
- SQL Server Editions
- MS SQL Server as Client-Server Architecture
- Key Components and Services of SQL Server
- SQL Server Instances
- Importance of SQL Server Instances
Download & Install SQL Server
- How to download SQL Server Setup
- How to Install SQL Server
SQL Server Architecture
- Protocol Layer - SNI
  - Shared Memory
  - TCP/IP
  - Named Pipes
  - What is TDS?
- Relational Engine
  - CMD Parser
  - Optimizer
  - Query Executor
- Storage Engine
  - File types
  - Access Method
  - Buffer Manager
  - Plan Cache
  - Data Parsing: Buffer cache & Data Storage
  - Transaction Manager
SQL Server Management Studio
- What is Server Management Studio
- Download & Install SQL Server Management Studio
- How to access "Management Studio"
- Access "Management Studio" using Command line
- Introduction to Data Management Studio IDE
- SSMS Tips and Issues
- SSMS Versions and Updates

On Demand

Microsoft SQL Server Training | Microsoft

MICROSOFT SQL SERVER Advanced Guide | Udemy

Online

Advanced SQL Server | Airpair https://www.airpair.com/sqlserver/posts/advanced-sql-server
SQL Server | Techonthenet https://www.techonthenet.com/sql_server/index.php
Advanced SQL Server | SQL Server Tutorial https://www.sqlservertutorial.net/advanced-sql-server/

CLASSROOM

SQL Server Administration Training | Zeolearn https://www.zeolearn.com/sql-server-administration-training/schedule?delivery-type=online-classroom
SQL Server Training | SQL School https://www.sqlskills.com/sql-server-training/

SQL Server Database
- What is Database?
- Rules to Create a Database
- Create Database using SQL Server Management Studio
- Create Database with T-SQL
- Alter Database with SQL Server Management Studio
- Alter Database with Transact-SQL
- Delete Database SQL Server Management Studio
- Delete Database using Transact-SQL
- Restore Database
SQL Server DataTypes
- What is DataType?
  - How to use MS SQL datatype
- Why use Datatypes?
  - Exact Numeric
  - Approximate Numeric
  - Date and Time
  - Character Strings
  - Unicode Character String
  - Binary String
  - Other Datatypes
SQL Server Variable
- What is Variable?
- Types of Variable: Local, Global
- How to DECLARE a variable
- Assigning a value to a Variable
  - During variable declaration using DECLARE keyword.
  - Using SET
  - Using SELECT
  - Other Examples
- Interesting Examples!
SQL Server Table
- What is a Table?
- How to create a Table
  - Using T-SQL
  - T-SQL: Create a New Table using an existing table.
  - Using Table Designer
- Alter Table
  - Using T-SQL
  - Using Table designer
- Delete Table
  - Using SQL Server Management Studio
  - Using T-SQL
SQL Server PRIMARY KEY
- What is a Primary Key
  - Rules for Primary Key
- How to create a Primary Key
  - Using SQL Server Management Studio
  - Using T-SQL: Create Table
  - Using T-SQL: Alter Table(Add to Existing table)
  - Interesting Facts
SQL Server Foreign Key
- What is a Foreign Key?
  - Rules for Foreign Key
- How to create Foreign Key
  - Using SQL Server Management Studio
  - Using T-SQL: Create Child Table
  - Using ALTER TABLE
  - Example Query Foreign Key
IF...ELSE Statement
- Why do you need Conditional Statements?
- If...Else Statement
  - If...Else with the variable in Boolean Expression
  - If...Else with Begin End
- If Statement with No Else
- Nested If...Else Statements
CASE Statement
- Overview of Case in Real life
- What is CASE?
- Simple CASE
- Searched CASE
- Difference between Simple and Searched CASE
- Nested CASE: CASE in If Else
- Nested CASE: CASE inside CASE
- CASE with UPDATE
- CASE with Order By
SQL Server SUBSTRING()
- What is Substring?
- Rules for using SUBSTRING
SQL Server Joins
- INNER JOIN
- LEFT OUTER JOIN
- RIGHT OUTER JOIN
- FULL OUTER JOIN
SQL Server Create User
- How to create a Login
- How to create a User
- Create User using SQL Server Management Studio
- Create User using T-SQL
- Assigning Permission to a User
- Assigning Permission Using SQL Server Management Studio
- Grant Permission using T-SQL
Oracle vs SQL Server
- What is MS SQL Server?
- What is Oracle Database
- Early History of MS SQL
- Early History of Oracle
- Features of MS SQL Server
- Features of Oracle
- Difference between SQL Server and Oracle
SSIS Tutorial
- What is SSIS
- Why we use SSIS
- History of SIS
- SSIS Features
- SSIS Architecture
- SSIS Tasks
- Advantages and DisAdvantages of using SSIS
- Other important ETL Tools
- SSIS Best Practices
SSRS Tutorial
- What is SSRS?
- Types of reporting services
- Why SSRS
- Examples of SSRS reporting
- Features of SSRS
- How SSRS works
- SSRS Architecture
- Reporting Lifecycle
- what is RDL?
- Type of SSRS Reports
- Advantages of using SSRS
- Disadvantages of using SSRS
SSAS Tutorial
- What is SSAS
- Architecture of SSAS
- History of SSAS
- Important SSAS Terminology
- Type of model in SSAS
- Tabular vs Multidimensional model
- Key features of SSAS
- SSAS vs PowerPivot
- Advantages of SSAS
- Disadvantages of using SSAS
- Best practices of using SSAS