70-461 Querying Microsoft SQL Server 2012

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

SQL Server database managers, implementers, system engineers, and developers will benefit from this 70-461 Querying Microsoft SQL Server 2012 course. This latest SQL 2012 course is designed for anyone who wants to test their query writing skills and expertise.

This course provides knowledge and understanding for some of these important job functions:

  1. Apply built-in scalar functions
  2. Apply ranking functions
  3. Combine datasets
  4. Creates and alters
  5. Design T-SQL stored procedures, views
  6. Implementing aggregate queries, error handling, sequence generation, and data types
  7. Manage transactions
  8. Modify data by using INSERT, UPDATE, DELETE and MERGE statements
  9. Optimizing queries
  10. Query data using SELECT statements and Managing XML data
  11. OUTPUT clause to return data


This learning course provides the knowledge for the 70-461 Exam on Queries on Microsoft SQL Server 2012:

  1. Create Database Objects
  2. Create and alter tables using T-SQL syntax (simple statements).
  3. Create and alter views (simple statements).
  4. Design views.
  5. Create and modify constraints (simple statements).
  6. Create and alter DML triggers.
  7. Work with Data
  8. Query data by using SELECT statements.
  9. Implement sub-queries.
  10. Implement data types.
  11. Implement aggregate queries.
  12. Query and manage XML data.
  13. Modify Data
  14. Create and alter stored procedures (simple statements).
  15. Modify data by using INSERT, UPDATE, and DELETE statements.
  16. Combine datasets.
  17. Work with functions.
  18. Troubleshoot & Optimize
  19. Optimize queries.
  20. Manage transactions.
  21. Evaluate the use of row-based operations vs. set-based operations.
  22. Implement error handling.

We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.


Who this course is for:

  1. SQL Server database administrators, system engineers, and developers with two or more years of experience, who are seeking to validate their skills and knowledge in writing queries.
Show More

What Will You Learn?

  • -This course will prepare you to pass the exam Microsoft 70-461 Querying SQL Server 2012
  • -Earning an MCSA: SQL Server certification will qualify you for a position as a database developer or database analyst.

Course Content

70-461 Querying Microsoft SQL Server 2012

  • Introducing SQL Server 2012
  • Advanced SELECT Statements
  • SQL Server Data Types and Functions
  • Grouping and Aggregating Data
  • SET Operators Grouping and Windows Functions
  • Modifying Data in SQL Server
  • Programming with T SQL
  • Retrieving SQL Metadata and Improving SQL Performance
  • Window functions in SQL Server
  • Generating XML from SQL Server tables
  • Loading XML Documents
  • Using XQuery to Query XML Data
  • MSSQL – Understanding Isolation Level by Example (Read Uncommitted)
  • MSSQL – Understanding Isolation Level By Example (Repeatable Read)
  • MSSQL – Understanding Isolation Level By Example (Serializable)
  • MSSQL – Understanding Isolation Level By Example (Snapshot)
  • MSSQL – Difference Between Dirty Read and Phantom Read
  • Exam 461: Querying Microsoft SQL Server 2012

Student Ratings & Reviews

No Review Yet
No Review Yet