SQL SERVER COURSE CONTENTS

SQL-SERVER-Training-Course-Content

INTRODUCTION

  • What is SQL Server?
  • Architecture of SQL Server
  • SQL Server Editions
  • Installing SQL Server
  • Sql Server Instances
  • Internal of SQL Server Database
  • MDF & LDF Files

Basic of Database Design

  • Normalization
  • Denormalization
  • Introduction to SQL Sever Management Studio
  • Creating Database
  • Data Types
  • Designing Table Model
  • Creating Tables
  • Alteration of Table Design
  • Drop Table

WRITING QUERIES

  • Insert queries
  • UPDATE queries
  • DELETE queries
  • TRUNCATE
  • The SELECT Clause
  • The FROM Clause
  • The WHERE Clause
  • Mathematical Operator
  • Conditional Operators
  • AND , OR Operators
  • Like Operators
  • The ORDER BY Clause
  • Aggregate Functions
  • String Functions
  • Date Functions
  • Using GROUP BY and HAVING
  • Using TOP N and TOP N PERCENT

Constraint in SQL SERVER

  • What is Constraint
  • Adding constraints to columns in Tables
  • Primary Key Constraints
  • Unique Constraints
  • Check Constraints
  • Default
  • Alter Constraints
  • Drop Constraints

Relational Database

  • Introduction to RDBMS
  • Why Relational Model
  • Advantages of Relational Model
  • Master Table & Child Tables
  • Introduction to Foreign Key
  • Creating Relations between tables

JOINS IN SQL SERVER

  • Introduction to Joins
  • Types of Joins
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Self-Join
  • Writing Joins queries
  • APPLYING CLAUSES USING JOINS

Advanced SQL QUERIES

  • OFFSET & FETCH
  • SELECT INTO queries
  • SUB-QUERIES
  • UNION
  • INTERSECT
  • EXCEPT
  • ROW_NUMBER
  • RANK
  • CUBE & ROLLUP

T-SQL

  • What is T-SQL?
  • Syntax Conventions
  • Executing SQL Statements
  • Identifiers
  • Operators
  • Variables
  • Using T-SQL to Build and Alter Objects
  • If – else statements
  • Case statements
  • Looping statements
  • Identity statements

Stored Procedures, Functions

  • Introduction to Stored Procedures
  • Writing Stored Procedures
  • Alteration of Processing
  • Using/Calling Procedures
  • Using Input & Output Parameters
  • Advantage of Stored Procedures
  • Introduction to Functions
  • Writing Functions
  • Types of functions
  • Scalar Functions
  • Table Value Functions
  • Comparison between Stored Procedures & Functions

Triggers

  • Introduction to Triggers
  • Creating DML Triggers
  • Altering DML Triggers
  • Types of Trigger
  • Instead of Triggers
  • After Triggers
  • Using the Inserted and Deleted Tables
  • Auditing Data using Triggers

Types of Tables in SQL SERVER

  • Temp Tables
  • Local Temp Table
  • Global Temp Table
  • CTE
  • Table Variables
  • Comparison between Temp Tables, CTE & Table Variables

Views

  • Introduction to Views
  • Creating Views
  • Alteration of Views
  • Types of Views

Indexes

  • Introduction to Indexes
  • Types of Indexes
  • Creating Indexes
  • Best Practices of Indexes Creation

Cursors

  • Introduction to Cursors
  • Types of Cursors
  • Creating Cursors

Advanced SQL-SERVER

  • Temporary Tables
  • Table Variables
  • Error Handling
  • Transactions
  • Authentication Modes in SQL SERVER
  • Creating Users
  • Backup
  • Restore
  • Email configuration in SQL SERVER.
  • Creating Operators
  • Automating Tasks using Jobs

Need More Details ? Fill The Enquiry Form