enosis
learning
Creating Software Professionals
Apply For Internship
Apply For Job
Upload Your Resume
Request For Demo
7757012054
×
Request For Demo
Toggle navigation
Home
Courses
Full Stack.Net Contents
Full Stack Java Contents
Data Analytics Contents
.Net Core Contents
SQL SERVER Contents
POWER BI Contents
C Language Contents
C++ Language Contents
Web Designing Contents
Tutorials
Assignments
Interview Questions & Answers
C Language
C++ Language
Java
CSharp.Net
ASP.Net
ASP.NET MVC
WCF
SQL SERVER
MSBI
SSIS
SSRS
SSAS
POWERBI
Manual Testing
Selenium Testing
Web Designing
KnowledgeBase
SQLSERVER
POWERBI
CSHARP
ASP.NET
ASP.NET MVC
ENTITY FRAMEWORK
WEB API
JQUERY
ANGULAR JS
WEB DESIGNING
Question Papers
Articles
DownLoads
Clients
FAQ
Books
SQLSERVER BOOK
Contact
SQL SERVER COURSE CONTENTS
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
Please Select Course
.NET
JAVA
SQLSERVER
POWERBI
C
C++
DESIGNING
OTHERS
Interview Questions
ASP.NET MVC
Software Testing
Web Designing
C Language
SQL SERVER
POWERBI
C#.Net
ASP.Net
Selenium
SSIS
SSRS
SSAS
Java