SpiritSofts

• SQL Server 2014 & 2016 Installation/open=”yes”
• Services, Service Accounts and Usage
• Authentication Modes, Security, Logins
• Instance Configuration Options & Rules
• SQL Server Components and Features
•  Configuration Tools, Services and Use
• Naming Conventions & Collation Settings
• Using Management Studio (SSMS) Tool
• Post Installation Procedures and WMI
• Firewall Settings, Remote Configuration

• 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

• 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

• 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

• 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

• 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 – 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

• 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: 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

•  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

• 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

• Linked Servers and Data Distribution
• Configuring Linked Servers (Remote)
• sp_addlinkedserver & sp_addsrvlogin
• SQL Server & Non-SQL Server Products
• Using MSDTC for Remote Queries
• Using OPENROWSET for Remote Queries
• Multi User and Multi Database Access
• Real-world Query Blockings & Solutions
• Self Joins and CTEs – Query Tuning
• Using CTE and Temp Tables in SProcs
• Transactions in Procedures (SPs), Functions

• ACID Properties, Transaction Types
• EXPLICIT Transactions and Usage
• IMPLICIT Transaction Types, Options
• AUTOCOMMIT Transaction Advantages
• Transactions Nesting – Rules & Usage
• SAVEPOINT, Query Blocking Scenarios
• Lock Hints and Remote CTE Queries
• XML Data and Full Text Search (FTS)

• Sub Queries in T-SQL with XML
• Releated Sub Queries with XML
• XML PATH and Custom ROOT Options
• Indexing XML Data for Performance
• XML Operations on Views, Synonyms
• Nested Queries & XML Limitations
• KEYSET Cursors with XML Options
• Full Text Search Service Options
• Full Text Catalog and FT Indexes
• Storing BLOB / CLOB Data (Docs, Pdf)
• BULK..INSERT Commands – Options
• OPENROWSET and Bulk Data Loads
• SQL Server Architecture (Detailed)

• Client Server Architecture – Detailed
• TCP/IP, Named Pipes, Shared Memory
• TDS Packets and Network Options
• Storage Architecture, Transaction, IO
• Query Parse, Optimizer, Mini LSN
• Write Ahead Log, Lazy Writer Threads
• SQL Engine and SQL Manager @ Query
• SQLOS and Thread, Log Schedulers

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Spiritsofts verifies their technical background and expertise.

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

The Training itself is Real-time Project Oriented.

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

Keywords: Best Institute for  MS SQL Server Training,  MS SQL Server Course Material,  MS SQL Server Training,  MS SQL Server Training Material,  MS SQL Server Job Support,  MS SQL Server Software,  MS SQL Server Documentation,  MS SQL Server PDF,  MS SQL Server Jobs for Fresher’s,   MS SQL Server Online Training,  MS SQL Server Training in Hyderabad,  MS SQL Server Institute in Bangalore,  MS SQL Server Interview Questions,  MS SQL Server Tutorial Videos,  MS SQL Server institutes in Hyderabad.  MS SQL Server Training Fees,  MS SQL Server Certification Dumps

There are some Group discounts available if the participants are more than 2.

As we are one of the leading providers of Live Instructor LED training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, Sydney, France, Finland, Sweden, Spain, Russia Moscow, Denmark, London, England, South Africa, Switzerland, Kenya, Philippines, Japan, Indonesia, Pakistan, Saudi Arabia,  Qatar, Kuwait, Germany, Frankfurt Berlin Munich, Poland, Belarus, Belgium Brussels Netherlands Amsterdam, India and other parts of the world.

We are located in USA. Offering Online Training in Cities like New York, New jersey, Dallas, Seattle, Baltimore, Tempe, Chandler, Scottsdale, Peoria, Honolulu, Columbus, Raleigh, Nashville, Plano, Toronto, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Houston, Minneapolis, Los Angeles, San Francisco, San Jose, San Diego, Washington DC, Chicago, Philadelphia, St. Louis, Edison, Jacksonville, Towson, Salt Lake City, Davidson, Murfreesboro, Atlanta, Alexandria, Sunnyvale, Santa Clara, Carlsbad, San Marcos, Franklin, Tacoma, California, Bellevue, Austin, Charlotte, Garland, Raleigh-Cary, Boston, Orlando, Fort Lauderdale, Miami, Gilbert.

Hyderabad (Ameerpet), Kukatpally, Vizag, Nellore, Lucknow, Coimbatore, Marathahalli, Electronic city , Silk board, Kakinada, Goa, Vijayawada, Bangalore, Noida, Chennai, Kolkata, Pune, Whitefield, Mumbai, Delhi NCR, Dubai, Doha, Melbourne, Brisbane, Perth, Wellington, Leeds, Manchester, Liverpool, Ireland Dublin, Oxford, Cambridge, Brighton, Cardiff, Bristol, Lithuania,  Latvia, Italy, San Marion, China Beijing, Auckland etc…