Querying Microsoft SQL Server 2012
Duration: 5 Days
This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.
Topics Covered In This Course
Introduction to Microsoft SQL Server 2012
Getting Started with SQL Azure
Introduction to T-SQL Querying
Writing SELECT Queries
Querying Multiple Tables
Sorting and Filtering Data
Working with SQL Server 2012 Data Types
Using Built-In Functions
Grouping and Aggregating Data
Using Table Expressions
Using Set Operators
Using Window Ranking, Offset and Aggregate Functions
Pivoting and Grouping Sets
Querying SQL Server Metadata
Executing Stored Procedures
Programming with T-SQL
Implementing Error Handling
Improving Query Performance
What You Can Expect
After completing this course, students will be able to:
Who Should Take This Course
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren?t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.
Students must have a working knowledge of relational databases, and basic knowledge of the Microsoft Windows operating system and its core functionality.
Instructor led with 50% lecture and 50% lab.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]