Enosis Learning is Providing Training on Sql Server 2012 with practical exposure.

Topics Covered

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

Basics of Database Design

• Normalization
• Denormalization
• Introducing SQL Server Management Studio
• Creating a Database
• Data Types
• Designing Table Model
• Creating Tables
• Alteration of Table Design
• Drop Table

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

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
• OFFSET & FETCH
• SELECT INTO queries
• SUB-QUERIES
• UNION
• CTE
• CUBE & ROLLUP
• RANK

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

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
• Introduction to Functions
• Writing Functions
• Types of functions
• Scalar Functions
• Table Value 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

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
• Types of Backups
• Restore
• Shrinking
• Email configuration in SQL SERVER.
• Creating Operators
• Automating Tasks using Jobs
• Fragmentation
• Query Optimization Techniques
• Execution Plan of SQL SERVER
• Query Lifecycle
• Execution Lifecycle of a query
• Statistics

Who should attend

AnyBody

Pre-requisites

Graduate

What you need to bring

Dedicated Time""""

Key Takeaways

Knowledge Materials Code Demo Databases