enosislearning
Creating Software Professionals
Apply for job Upload resume Request demo Quiz
WhatsApp 7757012052
Log in
ENOSIS LEARNING
Download Syllabus

SQL SERVER

Relational Databases, T-SQL & Indexing

12 Chapters
QUERY OPTIMIZATION
REAL PROJECTS
JOB READY

Course Curriculum - 12 Chapters

7757012051 | 7757012052 courses@enosislearning.com
01 Chapter 1 - Introducing SQL Server
  • What is SQL Server
  • Architecture of SQL Server
  • SQL Server Editions
  • Installing SQL Server
  • Sql Server Instances
  • Internals of Sql Server Database
  • MDF & LDF Files
  • Introducing SQL Server Management Studio
  • Creating a Database
02 Chapter 2 - Data Designing
  • Data Types
  • Designing Table Model
  • DDL Commands
  • Creating Tables
  • Alteration of Table Design
  • Add New Column, Drop Column
  • Drop Table
03 CHAPTER 3: Writing Queries
  • DML STATEMENTS
  • INSERT,UPDATE,DELETE,TRUNCATE
  • SELECT CLAUSE
  • WHERE CLAUSE
  • Mathematical Operator
  • Conditional Operators
  • AND , OR Operators
  • Like Operators
  • ORDER BY Clause
  • TOP N and TOP N PERCENT
  • Aggregate Functions
  • String Functions
  • Date Functions
  • GROUP BY and HAVING
04 CHAPTER 4: Constraint in SQL SERVER
  • What is Constraint
  • Adding constraints to columns in Tables
  • Primary Key Constraints
  • Unique Constraints
  • Check Constraints
  • Default Constraints
  • Alter Constraints
  • Drop Constraints in Tables
  • Introduction to RDBMS
  • Normalization
  • Denormalization
  • Advantages of Relational Model
  • Master Table & Child Tables
  • Introduction to Foreign Key
  • Creating Relations between tables
05 CHAPTER 5: JOINS IN SQL SERVER
  • Introduction to Joins
  • Types of Joins
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Writing Joins queries
  • Self-Join, Cross Join
  • APPLYING CLAUSES USING JOINS
06 CHAPTER 6: Advanced SQL QUERIES
  • OFFSET & FETCH
  • SELECT INTO queries
  • SUB-QUERIES
  • UNION
  • INTERSECT ,EXCEPT
  • ROW_NUMBER , RANK, DENSE_RANK
  • CUBE, ROLLUP
07 CHAPTER 7 : T-SQL
  • What is T-SQL?
  • Syntax Conventions
  • Executing SQL Statements
  • Identifiers , Variables
  • Operators
  • If – else statements
  • Case statements
  • Looping statements
  • Identity statements
  • Error Handling
  • Transactions
08 CHAPTER 8 : Stored Procedures, Functions
  • Introduction to Stored Procedures
  • Writing Stored Procedures
  • Using/Calling Procedures
  • Alteration of Procedure
  • 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
09 CHAPTER 9 : 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
10 CHAPTER 10 : Types of Tables in SQL SERVER
  • Temp Tables
  • Local Temp Table
  • Global Temp Table
  • Usage of Temp Tables
  • Introduction To CTE
  • Examples of CTE
  • Comparison between Temp Tables, CTE & Table Variables
  • Introduction to Views
  • Creating Views
  • Alteration of Views
  • Types of Views
  • Simple View & Complex View
  • Usage /Advantages of Views
11 CHAPTER 11: Indexes
  • Introduction to Index
  • Types of Indexes
  • Clustered Index & Non Clustered Index
  • Creating Indexes
  • Improving query performance using Index
  • Best Practices of Indexes Creation
12 CHAPTER 12: Advanced SQL-SERVER
  • Authentication Modes in SQL SERVER
  • Creating Users
  • Backup of Database
  • Restore BackUp to Database
  • Automating Tasks using Jobs

PROJECT IMPLEMENTATION IN SQL SERVER

Work on end-to-end real-world projects covering industry standards, hands-on architecture, code implementation & deployment.

100% Practical

Enquiry Form

Interview Q&A

Enosis Learning
Online