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

A Simple Introduction to Cisco CML2

0 3877 0

Mark Jacob, Cisco Instructor, presents an introduction to Cisco Modeling Labs 2.0 or CML2.0, an upgrade to Cisco’s VIRL Personal Edition. Mark demonstrates Terminal Emulator access to console, as well as console access from within the CML2.0 product. Hello, I’m Mark Jacob, a Cisco Instructor and Network Instructor at Interface Technical Training. I’ve been using … Continue reading A Simple Introduction to Cisco CML2

Cable Testers and How to Use them in Network Environments

0 724 1

This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader demonstrates how to use cable testers in network environments. Let’s look at some tools that we can use to test our different cables in our environment. Cable Testers Properly Wired Connectivity … Continue reading Cable Testers and How to Use them in Network Environments

Data Models in Business Analysis

0 200 0

This video is from our PMI-PBA Business Analysis for IT Analysts and Project Managers (PMI-PBA)® Certification now available at Interface Technical Training. Also see Steve’s PMP Project Management Certification Course: Project Management Professional (PMP®) Certification Video Training PMBOK® 6th Edition  Video Transcription: Data Models are part of the elicitation analysis in PMI-PBA. This is the way … Continue reading Data Models in Business Analysis

Write a Comment

See what people are saying...

    Share your thoughts...

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