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.
|Course Title||Advanced T-SQL Programming, Querying & Optimization|
(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)|
- 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
Concept & Architecture
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 : email@example.com
Skype : firstname.lastname@example.org