Scroll to top button

MCSA/MCSE - Querying Microsoft SQL Server 2012

ISBN : 9781616912253

Gain hands-on expertise in passing the Microsoft 70-461 exam with uCertify MCSA/MCSE - Querying Microsoft SQL Server 2012 course. The course covers all the objectives of Microsoft 70-461 exam and includes topics such as understanding SQL server's role, installing SQL server, querying SQL server, ERD and capacity planning, creating SQL server databases, creating tables, indexes, and views, and database concepts and terminology.

The Microsoft 70-461: Querying SQL Server 2012/2014 credential is globally recognized for validating Querying Microsoft SQL Server knowledge. The Microsoft 70-461 exam will examine the individuals' skills in creating and changing tables using T-SQL syntax, designing views, creating and changing DML triggers, querying data by using SELECT statements, implementing data types, implementing aggregate queries, querying and managing XML data, combining datasets, working with functions, modifying data by using INSERT, UPDATE, and DELETE statements, optimizing queries, managing instructions, and handling error.

Glossary of terms
Pre Assessment Questions
Full Length Tests
Post Assessment Questions

Videos and How To

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Exam related FAQs
What are the prerequisites for this exam? There are no defined pre-requisites for this certification.
What is the exam registration fee? USD 165
Where do I take the exam? Microsoft
What is the format of the exam? Active Screen, best answer, build list, case studies, drag and drop, hot area, multiple choice questions, multiple answer questions, short answer
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 700
What is the exam's retake policy?

Here are the retake policies:

  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait at least 24 hours before retaking the exam.
  • If a candidate does not achieve a passing score the second time, the candidate must wait at least 14 days before retaking the exam a third time.
  • A 14-day waiting period is also imposed for the fourth and fifth subsequent exam retakes. A candidate may not take a given exam any more than five times per year (12 months). This 12-month period starts the day of the fifth unsuccessful exam retake. The candidate is then eligible to retake the exam 12 months from that date. To take a given exam more than five times per year or to have the time between attempts waived, a candidate must submit a request and obtain prior permission from Microsoft. Requests should be sent to These requests should include the following information:
  • MCID
  • Name
  • Email
  • Exam Number
  • If a candidate achieves a passing score on an exam, the candidate cannot take the exam again. Microsoft reserves the right to make some exams available for retake. For a complete list of exams that can be retaken annually, click here.
What is the validity of the certification? Microsoft certifications have no expiration. The certification holder is certified for life unless the vendor changes its policy.
Where can I find more information about this exam? To know more about the 70-461, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?

MCSA/MCSE 70-461: Querying Microsoft SQL Server 2012/2014 certification qualifies you for a variety of exciting job roles including:

  • SQL Analyst
  • SQL Developer
  • IT Business Analyst
  • Senior Business Analyst
  • MS SQL Database Developer
  • What Is Information Technology?
  • Introduction to Databases
  • Database Servers and Applications
  • SQL Server's Role
  • Summary
  • Lesson Essentials
  • Installation Planning
  • Installing a Default Instance
  • Installing Named Instances
  • Installing to a Cluster
  • Installing Extra Features
  • Upgrading from Previous Versions
  • Validating an Installation
  • Removing an Installation
  • Summary
  • Lesson Essentials
  • Understanding the SQL Language
  • SQL Statement Types
  • SQL Syntactical Elements
  • Coding Recommendations
  • Using SELECT Statements
  • Advanced Query Techniques
  • Using DDL Statements
  • Using DCL Statements
  • Modifying Data
  • Create and modify constraints (simple statements).
  • Work with functions
  • SqlGeography Methods
  • Tuning and Optimizing Queries
  • Summary
  • Lesson Essentials
  • Relational Database Theory
  • Database Design Processes
  • Project Management for the DBA
  • Summary
  • Lesson Essentials
  • Planning a Database
  • Understanding Entity Relationship Diagramming
  • Building an ERD
  • Capacity Planning
  • Summary
  • Lesson Essentials
  • Designing for Normalization
  • Designing for Performance
  • Designing for Availability
  • Designing for Security
  • Summary
  • Lesson Essentials
  • SQL Server Databases
  • Database Storage
  • Database Options and Properties
  • Creating Databases in the GUI
  • Creating Databases with T-SQL
  • Creating Databases with PowerShell
  • Attaching and Detaching Databases
  • Database Snapshots
  • Summary
  • Lesson Essentials
  • Data Types
  • Query and manage XML data.
  • Collations
  • Table Creation Process
  • Data Partitioning
  • Summary
  • Lesson Essentials
  • Understanding Indexes
  • Creating Basic Indexes
  • Creating Advanced Indexes
  • Managing Indexes
  • Understanding Views
  • Creating Views
  • Summary
  • Lesson Essentials
  • Triggers Defined
  • Using Triggers
  • Creating Triggers
  • Understanding Stored Procedures
  • Creating Stored Procedures
  • Summary
  • Lesson Essentials
  • Certification Objectives Map
  • Installation Requirements
  • Installing SQL Server 2012 Express in Windows