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 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 (2016 / 2014) Installation -- Free Demo

  • What is Data? What is Database?
  • Why SQL Server? Advantages and Usage
  • What is SQL? What is T-SQL? Why T-SQL?
  • 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
  • SQL Server Management Studio (SSMS)    Register

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

  • Testing Installation, Local, Remote Labs
  • Defining New Sessions for SQL Queries
  • Basic SQL - Introducing Databases, Tables
  • What is SQL? Writing Basic SQL?
  • DDL and DML Queries. SELECT Quries
  • Creating Databases (Basic Level) & Tables
  • 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, Designing Very Large Databases
  • Database Structure Modifications, ALTER
  • Adding New Filegroups, Files to Database

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
  • Table Design using GUI - 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
  • Design Limitations and UPDATES
  • 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 & TUNING OPTIONS

  • Need for Joins and Use Case Scenarios
  • JOIN - Types, Queries and Usage
  • CROSS JOIN - Examples and Scenarios
  • INNER JOIN - Examples and Scenarios
  • OUTER JOINS - Types and Scenarios
  • SELF JOINS - Types and Scenarios
  • Query Tuning & Optimization Options
  • HASH JOIN - Example, Scenarios
  • MERGE JOIN - Example, Scenarios
  • LOOP JOIN - Example, Scenarios
  • 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
  • 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 with GROUP BY, HAVING Condition
  • Queries with GROUPING(), HAVING
  • ROLLUP Options and Column Aggregations
  • CUBE on Table Data - Purpose & Usage
  • HAVING Vs WHERE - Differences
  • Query Execution Order with ROLLUP

DAY 7: Functions and Queries

  • Functions: Types, Purpose and Usage
  • Scalar Value Returning Functions - Usage
  • Inline Table Value Returning Functions
  • Multi-line Table Value Returning Functions
  • Table Variables and 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
  • Miscellaneous System Functions
  • Views for Sub Queries & Functions
  • Real-time Case Study on Joins, Functions, Sub Queries

DAY 8: 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 9: 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 Self Joins, Sub Queries with CTEs
  • CTEs with Tuning Options inside SPs
  • Embedding CTEs inside Stored Procedures
  • CTE Limitations and Self Join Options
  • Dynamic SQL Queries, CTEs Aliasing
  • Cached Plans & Memory for Stored Procs
  • RECOMPILE Option & ENCRYPTION Option

DAY 10: 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
  • SPs For Loops and Iterations
  • Stored Procedures with Cursors
  • 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
  • Data Loads from SP to Global Temp Tables

DAY 11: 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 and Setting Priority
  • A Real-world UseCase For Triggers

DAY 12: TRANSACTIONS & STORED PROCEDURES - Level 4

  • ACID Properties and Transaction Types
  • EXPLICIT Transaction Types, Advantages
  • IMPLICIT Transactions Types, Advantages
  • Open Transactons - Query Blocking
  • Transactions Usage, DB 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
  • A Real-world UseCase For Transactions

DAY 13: INDEXES & QUERY TUNING

  • Indexes Types, Purpose, Plans
  • Clustered Indexes - 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
  • 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)
  • Unique Clustered, NonClustered Indexes
  • Index Limitations and Precautions
  • Clustered Versus NonClustered Indexes

DAY 14: 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
  • SQL Query Engine, SQL Manager, Buffers
  • Write Ahead Log, Lazy Writer
  • SQLOS Threads & Schedules, CLR
  • Database Architecture - RAID Levels
  • Log File - Mini LSN, Virtual Log Files
  • Network - MDAC, MSXML Components
  • DOP - Degree Of Parallelism, Tuning
  • Catalogs and CLR Integration

DAY 15,16,17: REAL-TIME PROJECT Explanation

  • Phase 1: Understanding Project Requirement - Banking
  • Phase 1: Database Design with FileGroups, Schemas
  • Phase 1: Table Design with FileGroups, Schemas
  • Phase 1: Defining Constraints, Relations & Synonyms
  • Phase 2: Views for Data Inserts, Possible Joined Queries
  • Phase 2: Reporting Functions, Joins
  • Phase 2: Queries for Pivot, DENSE_RANK, PARTITION BY
  • Phase 3: End-to-End Implementation
  • 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
*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

Register Today For Free Demo