Advanced T-SQL Querying and Tuning Masterclass by MVP Guru Itzik Ben-Gan – One week only, Oct 17

Home > Blogs > SQL Server > 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

Like This Blog 1 Interface
Added by August 10, 2011

Itzik Ben-Gan's Advanced T-SQL Querying and Tuning for SQL Server 2005 and 2008One 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

Register for the class

Videos You May Like

Agile Methodology in Project Management

0 172 0

In 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

Creating Users and Managing Passwords in Microsoft Office 365

0 750 4

In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365.   For instructor-led Office 365 training classes, see our course schedulle: Spike Xavier SharePoint Instructor – Interface Technical Training Phoenix, AZ 20347: Enabling and Managing Office 365    

Using Navigation Controls in a Collaboration Site in SharePoint

0 351 1

In this SharePoint training video, I want to talk about the Navigation Controls in SharePoint. They tend to fall into two kind of different categories; one with the navigation controls in a typical Collaboration Site such as a Team Site or a Project Site. These are Sites that are based on the Team Site Template … Continue reading Using Navigation Controls in a Collaboration Site in SharePoint

Write a Comment

See what people are saying...

    Share your thoughts...

    Please fill out the comment form below to post a reply.