preloader

MCP: 70-461 Querying Microsoft SQL Server 2014 Databases

We offer live, hands on performance training. Each attendee learns by doing, by performing real professional task's.

In today’s competitive world, technical certifications play an important role in advancing your career. It is a great way to validate and sharpen your technical skills, thus helping you in being more productive in your assignments. It also helps you to stand out from the crowd and get more visibility. A few months back I decided to appear the Microsoft Exam 70-461: Querying SQL Server 2012/2014 and was able to successfully pass the exam. I have been working with SQL Server for more than 10 years, but I must admit that preparing for this exam was a great experience and I got to learn so many new things which I did not get a chance to work on during my day to day work. Everyday someone in the community plans to take this certification exam and I have bumped into multiple questions in social forums and groups asking for tips and guidance to pass the 70-461 Exam. This prompted me to come up with this article and share my experience with the community and hopefully it will be helpful for anyone who is planning to take this certification.

Features:

  • Prepare for Microsoft certification exam 70-461
  • Microsoft Official Course (MOC 20461) content
  • After-course instructor coaching benefit
  • After-course Sandbox benefit to practice skills learned in class
  • Eligible to use with your Microsoft Software Assurance Training Vouchers   (SATVs)

Objectives:

  • Describe the basic architecture and concepts of Microsoft SQL Server 2014.
  • Understand the similarities and
  • differences between Transact-SQL and other computer languages.
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types
  • in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use sub-queries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions

The A+ 220-802 certification exam is based on these four objectives.

TopicsObjectivesWeightage

 

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

 

 

20–25%

 

Work with data

·         Query data by using SELECT statements

·         Implement sub-queries

·         Implement data types

·         Implement aggregate queries

·         Query and manage XML data

 

25–30%

 

Modify data

·         Create and alter stored procedures (simple statements)

·         Modify data by using INSERT, UPDATE, and DELETE statements

·         Combine datasets

·         Work with functions

20–25%

 

Troubleshoot and optimize

 

·         Optimize queries

·         Manage transactions

·         Evaluate the use of row-based operations vs. set-based operations

·         Implement error handling

 

25–30%

Test Score and time frame:

Exam Duration

120 minutes

Exam Questions

40-60

Passing Score

700 out of 1000

Have Any Question?