Best Institute for learn exert level Online MS SQL Server Training By Experts, Learn MS SQL Server Certification Training with Course Material, Tutorial Videos, Attend Demo for free & you will find SpiritSofts is the best institute within reasonable fee, Job Support
Spiritsofts is the best Training Institutes to expand your skills and knowledge. We Provides the best learning Environment. Obtain all the training by our expert professional which is having working experience from Top IT companies.The Training in is every thing we explained based on real time scenarios, it works which we do in companies.
Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.
Key FeaturesCourse ContentFAQs
40 hours of Instructor Training Classes 24/7 Support
Lifetime Access to Recorded Sessions Practical Approach
Real World use cases and Scenarios Expert & Certified Trainers
MS SQL Server Online Training Course Content
What is an MS SQL Server? MS SQL Server Online Training
SQL Server is Relational Database Management System (RDBMS). It is a full-featured Database primarily designed to against competitors Oracle DB Database and MySQL. Like SQL Server supports ANSI SQL, RBDMS, the standard SQL language.
Module I : SQL & T-SQL Server
SQL Server Database Design
SQL Server Database Architecture- SQL Database Creation using GUI (SSMS)
- Database Creation using T-SQL Scripts
- DB Design using Files and File Groups
- DB File locations and Size Parameters
- Capacity Planning and Database Design
- Transaction Log Files – Size, Placement
- DB Structure Modifications & Ownership
- UI Limitations, ALTER Command Options
SQL Server Table Design
- Table creation using T-SQL Scripts
- SQL Server Tables & Filegroup Routing
- INSERT, UPDATE, DELETE Operations
- Single Row and Multi-Row Table Inserts
- Table Aliases, Column Aliases, Usage
- Table creation with Schemas, Filegroups
- DELETE Versus TRUNCATE, Usage
- SELECT Queries, Variants & Sub Queries
- Schemas and Nested Queries, Aliases
- Temporary Tables & Usage, Performance
Normal Forms, Keys & Constraints
- Data Integrity and Normal Forms (BCNF)
- Tables with Keys, Constraints (BCNF)
- NULL and IDENTITY Properties – Usage
- UNIQUE KEY Constraint and NOT NULL
- PRIMARY KEY Constraint & Importance
- FOREIGN KEY and REFERENCE Attributes
- CHECK and DEFAULT Constraints, Usage
- Duplicating Identity Property Values
- Disabling Constraints & Composite Keys
Views, Joins and Sub Queries
- SELECT Queries – IIF, SWITCH, CHOOSE
- GROUP BY, GROUPING, HAVING, OVER
- Sub Queries, Nested Queries and EXISTS
- DELETE FROM SELECT, Query Variants
- UPDATE FROM SELECT, Query Variants
- INSERT INTO SELECT & Data Copy
- Inner Joins – Purpose and Performance
- Outer Joins – Advantages, Usage
- Cross Joins – Advantages, Limitations
- Self Joins, Merge Joins, Sub Queries
- Working with Table Variables, Types
- WHILE Loops and Iteration Controls
- TARGET & NOT MATCH with MERGE
- NOCHECK and SET Options in Joins
- Sub Queries, Nested Queries and Usage
- Using Sub Queries for Data INSERTS
- Query Joins with UPDATE/DELETE
Module II : T-SQL Queries & Programming
Indexes and Query Tuning
- Indexes Architecture, Types and Purpose
- Clustered Indexes – Architecture, Usage
- Non Clustered Indexes & Page Usage
- Indexes on Table Columns With Options
- Index Scan, Index Seek and Key Lookup
- SORT_IN_TEMPDB & FillFactor Options
- INCLUDED Indexes & Query Optimizer
- Tuning Materialized (Indexed) Views
- Indexes for Joins & UNIQUE Constraints
- Using Indexes in Views and Query Plans
Stored Procedures (SPs) & Tuning
- Stored Procedures – Purpose and Usage
- Variables & Parameters (IN / OUT)
- Stored Procedures for Data Validations
- Stored Procedures for Dynamic Queries
- Stored Procedures for Data Reporting
- System Procedures & Metadata Access
- IF.. ELSE and IF .. ELSEIF Conditions
- Common Table Expressions (CTE), Uses
- CTE for Data Retrieval and Updates
- Recursive CTE and Query Performance
- Dynamic SQL Queries and Parameters
- OUTPUT Parameters in Procedures
- SPs for Table Variables and Temp Tables
Cursors and Joins with Procedures (SPs)
- Cursor Variables in T-SQL Queries
- Cursor Variables in Joins & Data Access
- Cursor Variables for Record Iterations
- Cursor For Dynamic SQL Programming
- Cursor Types – Benefits and Options
- FORWARD_ONLY & SCROLL Cursors
- STATIC and DYNAMIC Cursors – Memory
- LOCAL & GLOBAL Cursor Types – Scope
- Stored Procedures (SP), KeySet Cursors
- SPs with Table Variables Joins & Cursors
- SPs with Cursors, Dynamic Data Loads
Functions (UDF) and Sub Queries
- Functions: Types, Purpose and Usage
- Scalar Value Returning Functions, Usage
- Inline Table Functions and Purpose
- Multi-line Table Functions & Purpose
- Table Variables – Purpose and Usage
- SCHEMABINDING, ENCRYPTION Options
- Using System Functions & Metadata
- Date Functions, CAST and CONVERT()
- CROSSAPPLY and GROUP BY Operations
- ROW_COUNT(), GROUPING(), ROLLUP()
- Joins with Functions and Views
Triggers and Data Audits, DTC
- Use of Triggers – Purpose and Scope
- DML Triggers and Performance Impact
- FOR / AFTER DML Triggers – Importance
- INSTEAD OF DML Triggers – Importance
- INSERTED and DELETED Memory Tables
- Triggers for DML Audit Operations
- Triggers for Data Sampling Operations
- Database and Server Triggers – Usage
- Using Triggers for Updatable Views
- Triggers for Data Audits and MSDTC
Module III : Real Time Project
Understanding Real-time Databases
- Real-time Project Implementation
- Requirement Analysis & OLTP Modeling
- Identifying Entities and DB Objects
- ER (Entity Relation) Models for OLTP
- Database Diagrams and Scripting
- Normal Forms and Types in DB Design
- Advantages of BCNF Normal Form
- Data Type Checks and Column Integrity
- Synonyms and Object Level Access
- MERGE, PIVOT, Clone Operations
- New Features of SQL Server 2016
- SQL Server 2014 Vs SQL 2016
- Table Space & Memory Tables
- Query Store in SQL 2016
- Managed DB Objects in SQL 2016