Querying Microsoft SQL Server 2012 Jump Start

Are you familiar with database fundamentals and working with SQL Server, and now you’re ready to take your skills to the next level? If you just want to understand the process better or you want to be able to retrieve, insert, or update your database information, this is the course for you. You’ll learn about data manipulation statements and how to alter tables – and you’ll see it all put into action in the demos. This course will help you prepare for Exam 70-461.

Course Outline

   - Introduction to SQL Server 2012
   - Advanced SELECT statements
   - SQL Server data types
   - Grouping, aggregating and modifying data
   - Table expressions and SET operators
   - Programming with T-SQL
   - Retrieving SQL Server metadata

Instructor Team
Brian Alderman | CEO & Founder, MicroTechPoint | @brianalderman
Brian has been focused on helping IT Pros and DBAs better understand core Microsoft technologies for over 25 years. As an industry-recognized consultant, author and conference speaker, Brian’s expertise and designs range across Microsoft operating systems, Active Directory, SQL Server, and SharePoint. A frequent presenter at SharePoint Conferences around the world, he has authored or contributed to several SharePoint and other technical books, and is a MCSE, MCT, and MCDBA. Brian has a BS and MS in Computer Information Systems where he graduated summa cum laude from Regis University of Colorado Springs and lives in Scottsdale, AZ where he enjoys playing golf year round and traveling around the world.
Tobias Ternstrom | Principal Program Manager Lead
Tobias is a Principal Program Manager Lead in the SQL Server & Windows Azure SQL DB product group. His team owns the development of the T-SQL language, type-system and server-side libraries as well as Performance management in SQLDB. He describes himself as a developer, instructor and architect who has been using SQL Server since mid-90s.
Live Event Details
September 13, 2013
9:00am - 5:00pm (PDT)
What: Fast Paced Live Virtual Session
Cost: Free
Audience: Developer, Advanced Information Workers, Database Administrators
Prerequisites: To get the most out of this event it is recommended that users have a solid knowledge base of SQL.