SQL Server Classes in Hyderabad
 
 

SQL Server (T-SQL) Classroom Training

This impeccable SQL Server (with T-SQL Queries and Tuning) course is exclusively designed for starters as well as for experienced professionals addressing SQL Server Installation, DB Design, Queries, Joins, CTE, Stored Procedures, Triggers, Remote Queries, Transactions and Tuning options with BLOB Data and XML. Practice Material, Certification, Resume & Interview Guidance are included in this SQL Server T-SQL Course.


Schedules for SQL Server & T-SQL (DEV) Classroom Training

Schedule Timings Register
   
Schedule 1 6:30 AM to 8 AM Register
Schedule 2 11 AM to 12:30 PM Register
Schedule 4 5 30 PM to 7 PM Register
Schedule 3 7 PM to 8:30 PM Register

 

If none of the above schedules work for you?
please opt for On-demand, Self Paced 24x7 SQL Server Video Training Course
Trainer Profile, Duration, Pricing
 
Trainer: Mr Sai Phanindra T (11+ Yrs Exp, MS FTE)
 
Duration: 3.5 Weeks (Mon - Fri/Sat)
Total Course Fee: INR 4000/-
 
Training Location & Lab: SR Nagar, Hyderabad (India). Map
 
Course includes Real-time Project, Placement, Support.
 
Register Today For Free Demo
 

Module I: SQL Server & T-SQL

Duration: 1 Week
Module II: T-SQL Queries & Programming

Duration: 1 Week
Module III: Real-time Project

Duration: 1.5 Weeks

DAY 0: SQL Server Installation -- Free Demo

  • What is Data? What is Database?
  • Why SQL Server? Advantages & Usage
  • What is SQL? What is T-SQL? Advantages
  • Versions and Editions of SQL Server
  • LAB PLAN - 24x7 LIVE Server(Online Lab)
  • How to install SQL Server - Step by Step
  • SQL Server 2016 Software Installation
  • SQL Server 2014 / 2012 Installation
  • H/W & S/W Requirements. Instances
  • Common Installation Errors, Solutions
  • Server Components, Tools Installations
  • Instance Configurations, Warnings.
  • Services, Server Account, Authentication
  • SQL Server Management Studio (SSMS)    Register

DAY 1: SQL BASICS: DDL, DML -- Free Demo

  • Testing Installation, Local, Remote Labs
  • Defining New Sessions for SQL Queries
  • Basic SQL - Databases, Tables, Data
  • What is SQL? Writing Basic SQL?
  • DDL and DML Queries. SELECT Quries
  • Creating Databases, Tables :Basic Level
  • Data Store / INSERT Statement Types
  • Data Retreival, Verifications - Table Scan
  • Table Data UPDATES, Structure Updates
  • DELETE & TRUNCATE. DROP Options
  • SYSTEM DATABASES - Importance
  • CLIENT - SERVER Architecture (TDS)
    Register

DAY 2: SQL SERVER DATABASE DESIGN

  • SQL Server Database Architecture
  • SQL Server Database Design Concepts
  • Database Properties, Storage Options
  • Data Files : Sizing, Usage Options
  • Filegroups : Placement, Usage & Options
  • Log files : Sizing, Placement, Growth
  • Database Creation - GUI & T-SQL Scripts
  • Filegrowth, Autogrowth and MAXSIZE
  • Planning Very Large Databases (VLDB)
  • Database Structure Modifications, ALTER
  • Adding Filegroups to LIVE Databases
  • Adding Files to Secondary Filegroups
  • File Metadata Modifications, Options

DAY 3: TABLE DESIGN & SIMPLE QUERIES

  • Table Design - Defining, Creating Tables
  • Routing Tables to Database File Groups
  • Schemas - Purpose, Creation and Usage
  • Table Design using T-SQL Scripts, Options
  • Table Design using GUI - Options, Options
  • Naming Conventions for Table Columns
  • Single Row Inserts & Multi-Row Inserts
  • Table Aliases, Column Aliases and Usage
  • DDL, INSERT, UPDATE, DELETE, SELECT
  • SELECT Queries with Schema References
  • T-SQL Data Types, NULL Comparisons
  • Database Log Files for DML Operations
  • INSERTS, UPDATES, DELETES Limitations
  • DELETE Versus TRUNCATE Statements

DAY 4: CONSTRAINTS and KEYS

  • Constraints and Keys - Purpose, Usage
  • Normal Forms, Relational DB Design
  • OLTP Database Relations and BCNF
  • NULLABILITY Property and Importance
  • UNIQUE KEY Constraints and Importance
  • PRIMARY KEY Constraints and Limitations
  • FOREIGN KEY References and Relations
  • FOREIGN KEY Constraints - Rules, Usage
  • Schema Level and Table Level Relations
  • CHECK Constraints - Usage & Limitations
  • DEFAULT Column Constraints and Usage
  • Identity Property with PRIMARY KEY
  • Composite Primary Keys and Options
  • Constraints with Naming & Conventions

DAY 5: JOINS and TUNING OPTIONS

  • Need for Joins & Use Case Scenarios
  • JOIN - Types, Queries and Usage Options
  • CROSS JOIN - Examples and Precautions
  • INNER JOIN - Examples and Precautions
  • OUTER JOINS - Types and Precautions
  • SELF JOINS & Self References, Scenarios
  • Query Tuning & Optimization Options
  • HASH JOIN - Examples, Precautions
  • MERGE JOIN - Examples, Precautions
  • LOOP JOIN - Examples, Precautions
  • Sub Queries and Joins. Alternate Syntax
  • End User Access to Queries - Interfaces
  • Use Case - Combining JOIN Types - An Online Medical System

DAY 6: VIEWS and SUB QUERIES

  • Defining Views on Tables and Views
  • Views as Stored SELECT Statements
  • Operations with Views - DML & DDL
  • Advantages of Views for Data Security
  • SCHEMABINDING & ENCRYPTION Options
  • Issues with Views For Data Validations
  • Cascaded Views, WITH CHECK OPTION
  • Orphan Views - Scenarios in Realworld
  • Common System Views, Metadata Access
  • Views on Multi Level Tables - Joins
  • Queries - GROUP BY, HAVING Condition
  • Queries with GROUPING(), HAVING
  • ROLLUP Options, Column Aggregations
  • CUBE on Table Data - Purpose & Usage
  • HAVING Vs WHERE - Uses, Performance
  • Query Execution Order with ROLLUP
  • Limitations with Query Stores, Views

DAY 7-8: FUNCTIONS & SUB QUERIES

  • Functions: Types, Purpose and Usage
  • Scalar Value Returning Functions - Usage
  • Inline Table Value Returning Functions
  • Multi-line Table Value Functions
  • Table Variables Usage with Functions
  • Function Arguments - Usage and Options
  • SCHEMABINDING & ENCRYPTION Options
  • System Functions and Metadata Access
  • Date & Time Formats, Styles, DATEDIFF
  • SOUNDEX, DIFFERENCE, CASE, ISNULL
  • CAST, CONVERT, TRY_PARSE, COALESCE
  • String Functions, ROW_NUMBER, RANK
  • CASE, MERGE, PIVOT, DENSE_RANK
  • PARTITION BY, OVER, Misc. Functions
  • Views for Sub Queries & Functions
  • Real-time Case Study on Joins, Functions, Sub Queries

DAY 9: STORED PROCEDURES - LEVEL 1

  • Stored Procedures - Purpose and Usage
  • Stored Procedures - Basic Examples
  • Execution Options and Variants, Batch
  • Variables Usage in Stored Procedures
  • Parameters Usage in Stored Procedures
  • Stored Procedures For Data Validations
  • Stored Procedures For Dynamic Queries
  • Stored Procedures For Data Reporting
  • Important System Procedures, Metadata
  • Extended Procedures For App. Access
  • IF.. ELSE, ELSE IF, IIF Conditions
  • Error Handling: TRY, CATCH, THROW
  • Dynamic SQL Parameters and Variables
  • Default Parameter Values, Usage Types
  • Variables For Default Parameters
  • Deciding between Variables, Parameters

DAY 10: STORED PROCEDURES - LEVEL 2

  • Dynamic SubQueries & Stored Procs
  • Nested Sub Queries with Stored Procs
  • Stored Procedures for Recursive Queries
  • OUTPUT Parameters and Query Options
  • Common Table Expressions (CTE) & Uses
  • Using CTE, Data Retrieval in Stored Procs
  • Using CTE for DML in Stored Procedures
  • Using Recursive CTEs with Procedures
  • Recursive CTEs - Performance Impact
  • Query Tuning Options with CTE Queries
  • CTEs with Parameters and Variables
  • Avoding Joins, Sub Queries with CTEs
  • CTEs with Tuning Options inside SPs
  • Embedding CTEs in Stored Procedures
  • CTE Limitations and Self Join Options
  • Dynamic SQL Queries, CTEs Aliasing
  • Cached Plans & Memory for Stored Procs
  • RECOMPILE Option, ENCRYPTION Option

DAY 11: STORED PROCEDURES - LEVEL 3

  • Parameter Sniffing, SQL Injection Issues
  • Table Value Parameters & Table Types
  • User Defined Table Data Types & TVP
  • Extended Stored Procedures - Examples
  • Startup Stored Procedures - Examples
  • System SPs for Server Configurations
  • Stored Procs For Loops & Iterations
  • Stored Procedures with Cursors, Fetch
  • Cursor Types - Benefits and Options
  • FORWARD_ONLY and SCROLL Cursors
  • STATIC and DYNAMIC Cursors & Queries
  • LOCAL and GLOBAL Cursors & Queries
  • KEYSET DRIVEN Cursors & Performance
  • Embedding Cursors in Procedures, UDFs
  • SPs with Cursors For Dynamic Data Loads
  • Data Formatting with SPs & Temp Tables
  • Data Loads from SP to Local Temp Tables
  • Local Versus Global Temp Tables

DAY 12: TRIGGERS & DATA AUDITS

  • Use of Triggers - Purpose and Scope
  • DML Triggers and Performance Impact
  • FOR / AFTER Triggers - Importance
  • INSTEAD OF Triggers - Importance
  • INSERTED and DELETED Memory Tables
  • Triggers for DML Audits, Data Sampling
  • Database Level Triggers and Options
  • Server Level Triggers and Options
  • Bulk Operations & Updatable Views
  • Triggers for Table Data Distribution
  • Disabling Triggers - Use Case Scenarios
  • Trigger Priority : Purpose, Usage
  • Conflicts with Triggers, Bulk Updates
  • A Real-world UseCase For Triggers

DAY 13: STORED PROCEDURES - Level 4
and TRANSACTIONS

  • ACID Properties and Transaction Types
  • EXPLICIT Transaction Types, Advantages
  • IMPLICIT Transactions & Advantages
  • Open Transactions - Query Blocking
  • Transactions Usage, Database Settings
  • AUTOCOMMIT Transactions - Advantages
  • Nesting Transactions & SavePoints
  • LOCK HINTS: READPAST, NOLOCK, etc..
  • Transactional Integrity with Stored Procs
  • Transactions with SPs, Data Validation
  • Transactions with Triggers and SPs
  • Transactions, Error Handling and SPs
  • Transactional Consistency with SProcs
  • A Real-world Use Case For Transactions

DAY 14: INDEXES & QUERY TUNING

  • Indexes Types, Purpose, Execution Plans
  • Clustered Indexes: B Tree Architecture
  • NonClustered Indexes - Architecture
  • Execution Plans & Query Optimization
  • Table Scan, Index Scan, Index Seek
  • SORT_IN_TEMPDB and Index Memory
  • FILLFACTOR, PAD_INDEX, Fragmentation
  • INCLUDED Indexes and Performance
  • COLUMN STORE Indexes - Advantages
  • FILTERED Indexes - Advantages, Usage
  • ONLINE Indexes and OFFLINE Indexes
  • Indexes with JOIN Options in SELECT
  • Indexes with Merge and Loop Joins
  • Primary Key Index, Composite Indexes
  • STATISTICS - Types and Tuning Options
  • STATISTICS with Index Query Conditions
  • Materialized Views (Indexed Views), Usage
  • Unique Clustered, NonClustered Indexes
  • Index Limitations, Bulk Data Precautions
  • Clustered Versus NonClustered Indexes

DAY 15: SQL SERVER ARCHITECTURE

  • Basic Architecture - Client/Server
  • ISO-OSI Model of Encrypted Data
  • Query Processing & Query Optimizer(QO)
  • SQL Server Architecture - Protocols
  • DB Engine Architecture Components
  • Architecture - Query Processor Engine
  • Storage Engine Modes, Data Allocations
  • Query Parser, Query Optimizer (QO)
  • SQL Query Engine, SQL Manager, Buffers
  • Write Ahead Log, Lazy Writer, Checkpoint
  • SQLOS Threads and Schedules, CLR
  • Database Architecture - RAID Levels
  • Log File - Mini LSN, Virtual Log Files
  • Network - MDAC, MSXML Components
  • DOP - Degree Of Parallelism, Tuning
  • Database Catalogs & CLR Integration

DAY 16-20: REAL-TIME PROJECT @ Banking Domain

  • Phase 1: Understanding Project Requirement - Banking
  • Phase 1: Database Design with FileGroups, Schemas
  • Phase 1: Table Design with FileGroups, Schemas
  • Phase 1: Constraints, Synonyms, ER Diag
  • Phase 2: Views for Data Inserts, Possible Joined Queries
  • Phase 2: Reporting Functions, Joins
  • Phase 2: Pivot, DenseRank, Partition By
  • Phase 3: Stored Procedures For Data Inserts, Data Validations
  • Phase 3: ADVANCED, COMPLEX Stored Procedures
  • Phase 3: Updatable Views and Triggers. Deployment Options
  • Phase 3: XML Queries, XML Data, BLOB Data Store
  • Phase 3: End-to-End Implementation
  • Excel Reports, Pivot Tables, FETCH Options
*Above course curriculum applicable for registrations from Jan 18th, 2017.

 

24x7 LIVE Online Server (Lab) with Real-time Databases. Course includes ONE Real-time Project. Register Today

 

All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 LIVE Server.

 

Trainer : Mr. Sai Phanindra T, 11+ Yrs of Experience exclusively on SQL Server, SQL DBA, more..

Training Reviews

Register Now

 

SQL Server T-SQL Classroom Training - Highlights

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Certification Guidance to 70-461 Exam
  • Interview Preperation & MOCK Interviews
  • End-End Database Design & Implementation
  • Detailed SQL Server Architecture, DB Design
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, New Features of SQL Server 2016
  • Multi Server Triggers, Views, CTEs & BLOB Data
  • In-Memory Tables and HASH Joins, Query Tuning

 

Register Today . Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

 

Job-Oriented Real-time Training @ SQL School Training Institute


 

Register Today

 

 

Register Today

 

Register Today For Free Demo