M10774 Querying Microsoft SQL Server 2012

Level
Logo Focus on Training

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Focus on Training offers this product as a default in the following regions: N/A

Description

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.

  • Write SELECT Queries
  • Query Multiple Tables
  • Use Built-In Functions
  • Use Subqueries
  • Execute Stored Procedures
  • Use Set Operators
  • Implement Error Handling
  • Implementing Transactions
  • Use Table Expressions
  • Sort and Filter Data
  • Use Window Ranking, Offset and Aggregate Functions
  • Query SQL Server Metadata
  • Program with T-SQL
  • Improve Query Performance

This 5-day instructor led course …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Microsoft SQL Server, PL/SQL, Microsoft ProClarity, Client - Server, and Oracle.

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.

  • Write SELECT Queries
  • Query Multiple Tables
  • Use Built-In Functions
  • Use Subqueries
  • Execute Stored Procedures
  • Use Set Operators
  • Implement Error Handling
  • Implementing Transactions
  • Use Table Expressions
  • Sort and Filter Data
  • Use Window Ranking, Offset and Aggregate Functions
  • Query SQL Server Metadata
  • Program with T-SQL
  • Improve Query Performance

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. Many of the exercises in this course are SQL Azure enabled.

The Beta version of this course (10774AB) utilizes pre-release software in the virtual machine for the labs. Microsoft SQL Server 2012 Release Candidate 0 (RC0) is used in this course. Many of the exercises in this course are SQL Azure enabled.

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.