Advanced SQL Developer Master Class, Online,  May 22 to June 2, 2017

SQL Server is an enterprise level RDBMS server with a very powerful database engine capable of handling toughest of requirements in terms of scalability, availability, extensibility and performance. T-SQL differs from other programming language in many aspects. It’s easy to write a query, however writing an optimized query is an art and requires a solid understanding of T-SQL concepts and tuning techniques. This course is designed to give you the right amount of knowledge and loads of practical implementation techniques to write and tune queries in T-SQL. It also covers the In-Memory technology introduced in SQL Server 2014. Overall, this is the most detailed, advanced & comprehensive training on T-SQL programming, query tuning and optimization.

All Master Class participants will get a 6-month FREE subscription to SQLMaestros Hands-on-Labs. Apart from practicing course specific labs, participant’s will have access to the entire library.

Read Master Class Testimonials
Register For Sample Master Class (FREE)

Course Code PI_SQL_102
Course Title Advanced T-SQL Programming, Querying & Optimization
Course Brochure Download   download_img
List Price
(Super Early Bird) till Mar 4, 2017 USD 1,999
(Early Bird) March 5 to April 8, 2017       USD 2,199
(Regular) April 9 to May 22, 2017 USD 2,499
Duration 40 hours
(4 hours per day,10 working days/2 consecutive weeks)
Date Week 1: May 22-26, 2017
Week 2: May 29-June 2, 2017
Time Pre-Register with us and let us know your preferred timings. Learn more about our Registration Process
Level Level 300-400 (Advanced to Expert)
Target Audience This course is intended for SQL Developers, Programmers, Database Developers, Application Developers, SQL Server Database Administrators, SQL Database Engineers SQL Architects.
Prerequisites This course requires that participants have at least 1 year of genuine experience with SQL Programming/Querying. This course is not meant for Fresher!
Online Delivery GoToMeeting. Learn more about our Online Delivery Model
Sample Master Class(FREE) Register
Trainer/Instructor Ahmad Osama (Senior Consultant at SQLMaestros & Microsoft Data Platform MVP)

 
Key Highlights:

  • The most advanced SQL Developer Workshop
  • 40 hours of deep-dive learning
  • Exclusive, level 300/400 content
  • Packed with real-world scenarios and examples
  • Get your own copy of SQLMaestros course material developed by Ahmad Osama
  • Learn from the Master: Ahmad Osama (Senior Consultant at SQLMaestros & Microsoft Data Platform MVP)

Module 1:  Logic & Physical Query Processing

Logical query processing phases, Phases introduced in SQL Server 2005, Physical Query Processing & Data Flow, Query Plans & Compilations and more!!!

Module 2: Joins & Set Operations

Joins, CROSS, INNER, OUTER, Self-joins, Non-equi joins, joining more than 2 tables, Logical & Physical, Join Order, Semi-joins, Set Operations, UNION, EXCEPT, INTERSECT and more!!!

Module 3:  Subqueries & Table expressions

Subqueries, Self-contained, Correlated, Table Expressions, Derived Tables, Common Table Expressions(CTE) and more!!!

Module 4:  Advanced T-SQL Querying

Aggregating & Pivoting Data – OVER Clause, Running Aggregations, Pivoting, Un-pivoting, Histograms, CUBE and ROLLUP and more!!!

TOP & APPLY – SELECT TOP, TOP n, APPLY, frequently used scenarios for TOP & APPLY and more!!!

Ranking Functions – Row Number, Rank & Dense Rank, NTILE, OVER clause, Partition and Order by clause, complex examples and more!!!

Complex Scenarios – Graphs, Tree, Hierarchies and Recursion and more!!!

Module 5:  Data Modifications

Inserting Data, SELECT INTO, INSERT EXEC, INSERTING NEW DATA, INSERT with OUTPUT, BULK Insert, Deleting Data, DELETE, TRUNCATE, DELETE vs TRUNCATE, DELETE with OUTPUT, Removing Duplicate Data, Updating Data, UPDATE, UPDATE using joins, UPDATE with OUTPUT, Assignment UPDATE and more!!!

Module 6:  Programmable Objects

Stored Procedures – Types of Stored Procedures, Compilations, Recompilations and reuse of execution plans, Parameter Sniffing & Auto Parameterization, Execute AS and more!!!

Views – Refreshing Views, ORDER BY in a view, Modular approach, Updating Views, Indexed Views and more!!!

Triggers – AFTER Triggers, INSTEAD OF Triggers, Common requirements with triggers

User Defined Functions – Scalar UDFs, Table valued UDFs, Per-Row UDFs and more!!!

Dynamic SQL – EXEC, sp_executesql, Dynamic SQL uses, SQL Injection and more!!!

Module 7:  Temporary Tables & Table Variables

Temporary Tables, Table variables, Tempdb considerations and more!!!

Module 8:  Transactions & Concurrency

Locking and blocking, Isolation levels, Save Points, Deadlocks, Guidelines & Best Practices for Transactional code, Concurrency problems and more!!!

Module 9:  Exception Handling

Exception Handling, TRY, CATCH and more!!!

Module 10:  Query Tuning & Optimization Transactional and Procedural code

What does performance mean and factors that affect performance, Tools recommendations, Tuning Methodology, Analyzing Query Plans, Detecting Problems in Plans, Monitoring Query Performance, Query Improvements / Rewriting including Query Hints, Index tuning, Query Processing Best Practices and more!!!

Module 11: Programmability Enhancements in SQL Server 2008 & 2012

New Data Types in SQL Server 2008 – New Date and Time Data Types, Spatial Support in SQL Server 2008, New Spatial Data types, Filestream & HierarchyID, Spatial Support, New Spatial Data types, XML Enhancements and more!!!

T-SQL Enhancements – Table-Valued Parameters, T-SQL Assign and Increment Operators, Row Constructors, Grouping Sets
MERGE statement, Dependency Views, Performance Enhancements and more!!!

New Database Programming Features – Change Tracking, Change Data Capture, Sparse Columns, Filtered Indexes and more!!!

Programmability Enhancements in SQL Server 2012 – File Tables, Statistical Semantic Search, Execute statement enhancement, Ad-hoc Query Paging (OFFSET/FETCH), Sequence Object, Throw statement, New build in functions, New query optimizer hints Over clause enhancement and more!!!

Module 12: Programmability Enhancements in SQL Server 2014

Inline specification of CLUSTERED and NONCLUSTERED, Select into enhancement, T-SQL for In-memory OLTP

In- Memory OLTP – In-Memory Architecture, Supported Datatypes, Accessing Memory optimized tables, Natively compiled stored procedures, Transaction logic and more!!!

Module 12: Resource Governor

Concept & Architecture
Implementation

Module 13: Table & Index Partitioning

Concept & Architecture
Implementation

In the words of Ahmad Osama

“Hi, my name is Ahmad Osama and I am the instructor of this course. SQL Server is an enterprise level RDBMS server with a very powerful database engine capable of handling toughest of requirements in terms of scalability, availability, extensibility and performance. T-SQL differs from other programming language in many aspects. A solid understanding of T-SQL concepts and capabilities is very important to write optimized code. This course is designed to give you the right amount knowledge and loads of practical implementation techniques to write and tune queries in T-SQL. The 40-hour class offers a comprehensive coverage of Logical and Physical query processing, Joins, Subqueries, TOP and APPLY, views, stored procedures, functions, triggers, transactions, exception handling, temporary table, table variables, ranking functions and data modifications. The course also teaches you to refactor queries for optimization, and optimize transactional and procedural code. The course has a special focus on programmability enhancement in SQL Server 2008, SQL Server 2012 and SQL Server 2014. The course also deep dives into SQL Server In-Memory technology introduced in SQL Server 2014. Note that this 40-hour class is rigorous and deep-dive!The course is packed with Hands-On-Labs powered by SQLMaestros.com.

Please feel free to contact us if you need any further information or Book a call with us now!

Email : classes@sqlmaestros.com
Skype : classes@sqlmaestros.com
Contact: +91-9503124667