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 153 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 642 3

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    

Detailed Forensic Investigation of Malware Infections – April 21, 2015

4 608 5

How 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

Write a Comment

See what people are saying...

  1. Avatar Jen Campion

    OH!!!!! I want to take this class so bad! I’m excited that Interface finally has this class on the schedule. 🙂

    Jen

Share your thoughts...

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