This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
Midwest Management Summit
View analytic
Monday, November 10 • 2:00pm - 3:45pm
SQL Operators

Log in to save this to your schedule and see who's attending!

Limited Capacity seats available

One of the hardest things for a non-SQL expert to do build queries which transform data. This session goes through the basics of SQL Operators that can be used to get total counts, transform a number code into the useful text, work with dates, and create subselect queries like a pro.

  • Counts

  • Sum

  • Datediff

  • Case statements

  • Subselect queries

  • Column Naming

  • Aliases

  • SQL query formatting

  • Tips and Tricks

avatar for Garth Jones

Garth Jones

Chief Architect, Enhansoft
Garth Jones is Chief Architect at Enhansoft, an Ottawa-based company that develops products and services to extend the value of System Center 2012 Configuration Manager (CM12) and System Center Configuration Manager 2007 (CM07). Garth started working with Systems Management Server (SMS) back in 1996. He is an MVP for System Center Enterprise Client Management (formerly System Center Configuration Manager). Garth is the founder of the Ottawa... Read More →
avatar for John Nelson

John Nelson

Apps Systems Engineer, Wells Fargo

Monday November 10, 2014 2:00pm - 3:45pm
Lakes C MMS