Querying Microsoft SQL Server Training

6/19/2015

Our July – October, 2015 newsletter was sent out last week to LRS Education Services clients. We were not surprised to see from the analytics reporting that the Querying Microsoft SQL Server course received the most page views and searches as it is one of our most popular classes!

The MS20461C – Querying Microsoft SQL Server course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 as well as Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely Database Administration, Database Development and Business Intelligence.

This course helps students prepare for Microsoft exam 70-461.  LRS Education offers FREE Microsoft exam vouchers when you enroll in any Microsoft Official Curriculum course!

Course topics covered in the MS20461C – Querying Microsoft SQL Server course include:

  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2014 Data Types
  • Using DML to Modify Data
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Table Expressions
  • Using Set Operators
  • Using Window Ranking, Offset and Aggregate Functions
  • Pivoting and Grouping Sets
  • Executing Stored Procedures
  • Programming with T-SQL
  • Implementing Error Handling
  • Implementing Transactions
  • Improving Query Performance
  • Querying SQL Server Metadata

Guaranteed to Run:  August 31 – September 4, 2015 at our Springfield, IL training facility.  Remote students can attend virtually by connecting to our live instructor-led class.  See a demonstration of our virtual platform by clicking the Virtual Learning link.

NEW TO LRS…all attending Microsoft Official Course* students will have access to their labs and class recordings for 6 months after class. Click HERE to find out more!

Click here for a list of all of our Guaranteed to Run Courses, or to search our Online Course Catalog.

Feel free to call or email me for more information!

Christopher Becher
Education Consultant
309.664.7670 ext. 6302
F  309.662.7282
E  christopher.becher@lrs.com LRS® Education Services

*Subject to availability