Advanced T-SQL Querying and Tuning Masterclass by MVP Guru Itzik Ben-Gan – One week only, Oct 17
Advanced T-SQL Querying and Tuning Masterclass by MVP Guru Itzik Ben-Gan – One week only, Oct 17
One week only! Interface Technical Training offers SQL400: Itzik Ben-Gan's Advanced T-SQL Querying and Tuning for SQL Server 2005 and 2008 in Phoenix, October 17-21. This course can also be attended online with Interface Remote Live™ technology. This is a 5-day masterclass for writing and tuning queries, programming and problem solving with T-SQL, in SQL Server 2005 & 2008.
You will learn the details and capabilities of T-SQL in the following areas:
• Logical Query Processing
• Query Tuning
• Subqueries, Ranking Functions, Joins and Set Operations
• Aggregating and Pivoting Data
• TOP and APPLY
• Data Modification
• Data Type Related Problems
• Programmable Objects (Dynamic SQL, Views, User Defined Functions, Stored Procedures, Triggers, Transactions and Concurrency, Exception Handling)
• Graphs, Trees and Hierarchies.
Here’s your chance to learn from the T-SQL master, Itzik Ben-Gan.
Itzik Ben-Gan, a SolidQ mentor and founder, has been a SQL Server MVP since 1999. Ben-Gan provides cutting-edge training in Logical Query Processing, Query Tuning, Subqueries, Ranking Functions, Joins and Set Operations, Aggregating and Pivoting Data and more.
“T-SQL is my native tongue — I live and breathe it all the time. I have more than a decade of experience training people with advanced T-SQL topics, and training is my passion.”
Ben-Gan is the author of Microsoft SQL Server 2008: T-SQL Fundamentals, Inside Microsoft SQL Server 2008: T-SQL Querying and Inside Microsoft SQL Server 2008: T-SQL Programming. A founder of Solid Quality Mentors, now SolidQ, Ben-Gan is a primary resource for the company’s T-SQL activities.
Related Career Highlights:
• Developer of Advanced T-SQL Querying, Programming and Tuning for SQL Server 2005 and 2008
• SQL Server Magazine columnist
• Nationally recognized as one of a handful of key SQL Server instructors.
Course:
SQL400: Itzik Ben-Gan's Advanced T-SQL Querying and Tuning for SQL Server 2005 and 2008
5 days
October 17-21
$3995.00
You May Also Like
Agile Methodology in Project Management
0 162 0In this video, you will gain an understanding of Agile and Scrum Master Certification terminologies and concepts to help you make better decisions in your Project Management capabilities. Whether you’re a developer looking to obtain an Agile or Scrum Master Certification, or you’re a Project Manager/Product Owner who is attempting to get your product or … Continue reading Agile Methodology in Project Management
JavaScript for C# Developers – September 24, 2014
0 491 3Is JavaScript worth taking the time to learn if I’m a server-side .NET developer? How much of C# carries over to JavaScript? In this recorded video from Dan Wahlin’s webinar on September 24,2014, Dan answers these questions and more while also discussing similarities between the languages, key differences, and the future of JavaScript (ES6). If … Continue reading JavaScript for C# Developers – September 24, 2014
Detailed Forensic Investigation of Malware Infections – April 21, 2015
4 647 5How does an investigator hunt down and identify unknown malware? In this recording of our IT Security training webinar on April 21, 2015, Security expert Mike Danseglio (CISSP / CEH) performed several malware investigations on infected computers and identify symptoms, find root cause, and follow the leads to determine what’s happening. He demonstrated his preferred … Continue reading Detailed Forensic Investigation of Malware Infections – April 21, 2015
See what people are saying...