stone_river

Microsoft 70-461: Querying SQL Server 2012


  • flag Stone_River
  • student All Levels
  • database eLearning
  • earth English
  • clock 196

Covered topics:

  • Apply built-in scalar functions
  • Apply ranking functions
  • Combine datasets
  • Creates and alters
  • Design T-SQL stored procedures^ views
  • Implementing aggregate queries^ error handling^ sequence generation and data types
  • Manage transactions
  • Modify data by using INSERT^ UPDATE^ DELETE and MERGE statements
  • Optimizing queries
  • Query data using SELECT statements and Managing XML data
  • OUTPUT clause to return data
  • Create Database Objects
  • Create and alter tables using T-SQL syntax (simple statements).
  • Create and alter views (simple statements).
  • Design views.
  • Create and modify constraints (simple statements).
  • Create and alter DML triggers.
  • Work with Data
  • Query data by using SELECT statements.
  • Implement sub-queries.
  • Implement data types.
  • Implement aggregate queries.
  • Query and manage XML data.
  • Modify Data
  • Create and alter stored procedures (simple statements).
  • Modify data by using INSERT^ UPDATE^ and DELETE statements.
  • Combine datasets.
  • Work with functions.
  • Troubleshoot & Optimize
  • Optimize queries.
  • Manage transactions.
  • Evaluate the use of row-based operations vs. set-based operations.
  • Implement error handling.

Description

This course is intended for SQL Server database administrators^ implementers^ system engineers^ and developers. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries.