Querying Microsoft SQL Server 2012

CC004615D: Querying Microsoft SQL Server 2012 (5-Day Class. $2,500.00 per student)

(Microsoft 70-461 Exam Prep)

Please contact us for 2015 dates or to schedule a private session for your group

 

Description

 

Students will learn 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; Database Administration, Database Development and Business Intelligence.

Audience: This course is intended for Database Administrators, Database Developers, Quality Assurance users, Business Analysts, Report writers, Business Intelligence users and others who want a foundation in Microsoft’s implementation of SQL

 

Prerequisite

Elementary or Basic working knowledge of Databases and Windows operating systems

Topics Covered

  • Introduction to Sql Server 2008
  • Introduction to T-SQL Querying
  • Writing SQL SELECT queries
  • Querying multiple tables
  • Sorting and Filtering Data
  • Working with Data Types
  • Using Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Table Expressions
  • Using SET Operators
  • Querying SQL Metadata
  • Executing Stored Procedures
  • Implementing Error Handling
  • Implementing Transactions
  • Improving Performance
  • Hands on Workshop

Cancellation Policy

We understand that things come up. However, when you register for a class, a spot will be reserved for you! You will receive a full refund if you cancel a week before the training class. 80% of the class fees will be refunded if a cancellation occurs more than 3 days from the day of the class and within a week. Cancellations within 3 days of the class will trigger a 50% refund.