One-day Training on Query Optimizer & T-SQL (By Rob Farley)

Eventbrite

DataPlatformGeeks' Free Saturday Training Events in Mindtree, Chennai (DevOps in Databases, April 22) & Microsoft, Bangalore (DevOps/Azure, April 29).

 Register Now

Dear SQL/Data Geek

When you were taught to write T-SQL, you learned how to create queries that are logically correct to produce the results you want. You were probably taught about using indexes, and other techniques for tuning, but what about - Hash Aggregates, Spools, or Parallelism?

Rob Farley, MCM, MVP, MCT & author, is coming to Bangalore, all the way from Australia, to teach you how to write queries that produce the plans you want, and identify how particular query plan operators can help or hinder the performance of your queries, to give the kind of performance you should expect.

Rob Farley will take a full-day workshop on the topic "Plan-first Querying – Writing Queries to Suit the Optimizer" on Aug 16 (Pre-Conference Seminar) as part of Data Platform Summit 2017. In this workshop, Rob will take a different approach to T-SQL, by teaching you to cater for what the Query Optimizer is doing.

Plan-first Querying – Writing Queries to Suit the Optimizer (Pre-con By Rob Farley on Aug 16)

  • The workshop will include the following modules:
    • Reading & Evaluating SQL Plans

    • Query rewrites

    • Simplification

    • Base Rows

    • Join & Aggregate Types

    • Seek Order & Sort Order

Demo's by Rob Farley

  • Rob says "it is full of it, and nothing else"

This month, Rob's Rs 9,200 priced one-day workshop is available to you at Rs 6,000 (exclusive taxes). Like our other pre-cons, Rob's pre-con is already very popular, so if you are interested, register at the earliest to block your seat and enjoy the reduced Pre-con price of March 2017. (Price increases every month).

Registration for Rob Farley's Pre-con


  • Offline Registration & Payment: Register here for offline registration and pay using offline methods (Cheque, Demand Draft, Pay Order, etc.)
  • Online Registration & Payment: If you want to register online & pay using Credit Card or Net Banking, Click Here
  • Are you being sponsored by your company?Download the Corporate Registration Kit.

Check-out our other Pre-con sessions/speakers of DPS 2017 below the signature.


Best Regards,

Data Platform Summit 2017 Team

+91 7829999046/47, +91 9503124667

Data Platform Summit 2017


  • Dates:                   Aug 17-19. Pre-Conference Seminars on Aug 16
  • Venue:                 NIMHANS Convention Centre, Bangalore.
  • Download Catalogue
  • Download the Corporate Registration Kit

Data Platform Summit 2017 Pre-Conference Seminars (Full Day Training)


Speaker

Track

Title

Denny Cherry

Cloud

Azure Infrastructure

 

Leila Etaati

Data Science /BI/Analytics

Advanced Analytics with R, Microsoft SQL Server, Power BI, and Azure Machine Learning

Peter Myers

Business Intelligence & Analytics

Zero to Microsoft Power BI

 

Rob Farley

Database Development / Administration

Plan-first Querying – Writing Queries to Suit the Optimizer

Steve Jones

Database Development

Building a Database DevOps Process

 

Uwe Ricken

Database Administration

Analysis of Your SQL Server Like a PRO

 


Contact the Organizer
 
This email was sent to seekajob@outlook.com
To stop receiving emails from this organizer, you can unsubscribe
Eventbrite | 155 5th St, 7th Floor | San Francisco, CA 94103
Copyright © 2017 Eventbrite. All rights reserved.

No comments:

Post a Comment