• Home
uCertify Logo
  • Login or Signup
    • Help & Support
    • Accessibility
    • Testimonials
  • Powered by uCertify
  • Request Demo
  • Hello GuestLogin or Signup
  • Feedback & Support
    • Support
    • Keyboard Shortcuts
    • Send Feedback
Scroll to top button

Querying Microsoft SQL Server 2012/2014 (70-461)

(70-461-v2) / ISBN: 9781644590348
This course includes
Lessons
TestPrep
LiveLab
Mentoring (Add-on)
70-461-v2 : Querying Microsoft SQL Server 2012/2014 (70-461)
Share
Try This Course
4 Rating 1 Review
Are you an instructor?
Request a free evaluation copy

Querying Microsoft SQL Server 2012/2014 (70-461)

Gain hands-on experience to pass the MCSA 70-461 exam with the Querying Microsoft SQL Server 2012/2014 (70-461) course and lab. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS. The SQL training course and lab completely cover the Microsoft SQL certification 70-461 exam objectives and provide an understanding of topics such as creating database objects; working and modifying data; troubleshooting and optimizing queries and transactions, and more.
Here's what you will get

The Querying Microsoft SQL Server 70-461 exam is a part of the MCSA SQL Server 2012 certification. The MCSA SQL Server 70-461 exam validates expertise in creating and altering tables using T-SQL syntax, querying and managing XML data, modifying data by using INSERT, UPDATE and DELETE commands, and so on. The MCSA 70-461is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience.

Lessons
  • 8+ Lessons
  • 50+ Quizzes
  • 50+ Flashcards
  • 50+ Glossary of terms
TestPrep
  • 50+ Pre Assessment Questions
  • 2+ Full Length Tests
  • 50+ Post Assessment Questions
  • 100+ Practice Test Questions
Lab
  • 43+ Performance lab
  • 23+ Video tutorials
Here's what you will learn
Download Course Outline
Lesson 1: Introduction
  • About SQL Server 2012/2014
  • About Transact-SQL (T-SQL)
Lesson 2: Managing Tables and Views
  • Creating Tables
  • Modifying Existing Tables
  • Understanding Indexes
  • Understanding Views
  • Partitioning Tables and Indexes
  • Summary
Lesson 3: Creating Constraints and Triggers
  • Creating and Modifying Constraints
  • Understanding Triggers
  • Modifying Triggers
  • Summary
Lesson 4: Working with Data
  • Using SELECT Statements
  • Implementing Subqueries
  • Implementing Data Types
  • Implementing Aggregate Queries
  • Managing XML Data
  • Summary
Lesson 5: Modifying Data
  • Understanding Stored Procedures
  • Using DML Statements
  • Combining Datasets
  • Working with Functions
  • Summary
Lesson 6: Troubleshooting and Optimizing Queries
  • Tuning and Optimizing Queries
  • Managing Transactions
  • Evaluating Operations
  • Implementing Error Handling
  • Summary
Appendix A
  • Installing Microsoft SQL Server 2014 Management Studio
  • Connecting to the Server
Appendix B
  • 70-461 Exam Objectives

Hands on Activities (Performance Labs)

Managing Tables and Views

  • Creating a Table
  • Adding a New Column in a Table
  • Deleting a Column from a Table
  • Deleting a Table
  • Modifying a Column in a Table
  • Creating a Clustered Index
  • Creating a Non-Clustered Index
  • Deleting an Index
  • Creating a Filtered Index
  • Creating an Indexed View
  • Creating a View

Creating Constraints and Triggers

  • Creating a Primary Key Constraint
  • Creating a Foreign Key Constraint
  • Creating a Unique Constraint
  • Dropping a Constraint
  • Creating a DML Trigger
  • Creating a DDL Trigger
  • Using INSTEAD OF Trigger

Working with Data

  • Using Logical Operators
  • Using the SELECT statement
  • Retrieving Specific Columns
  • Using Calculated Columns
  • Limiting Rows
  • Using the LIKE Operator
  • Using the BETWEEN Clause
  • Using the PIVOT Operator
  • Using Appropriate Data Types
  • Using Subqueries
  • Using the Analytic Function
  • Working with Ranking Functions
  • Using the XML Data Type

Modifying Data

  • Creating a Stored Procedure
  • Adding New Data
  • Updating a Record in a Table
  • Removing a Record from the Table
  • Combining Data Sets
  • Using User-Defined Functions

Troubleshooting and Optimizing Queries

  • Displaying the Estimated Execution Plan
  • Using SET STATISTICS IO
  • Using the DECLARE and SET statements
  • Using the BEGIN, COMMIT, and ROLLBACK TRANSACTION Statements
  • Evaluating Operations
  • Implementing Error Handling
Exam FAQs
What are the prerequisites for this exam? There are no technical prerequisites for this certification.
What is the exam registration fee? USD 165
Where do I take the exam? Pearson VUE
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? The passing score varies from exam to exam and is provided on the score report.
What is the exam's retake policy?

General Microsoft Certification exam retake policy

  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam. At that time, candidates can log onto their certification dashboard and reschedule the exam themselves.
  • 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 between the third and fourth attempts and fourth and fifth attempts.
  • A candidate may not take a given exam any more than five times per year (12 months). This 12-month period starts from the first attempt. The candidate is eligible to retake the exam 12 months from the date of their first attempt.
  • To take a given exam more than five times per year or to have the time between attempts waived, a candidate must have experienced one of the errors listed below and request an exception from Microsoft. Requests should be sent to mlsecure@microsoft.com. These requests must include the following information:
    • Candidate ID
    • First/Last Name
    • Email associated with your Candidate ID
    • Exam Registration ID
    • Exam Number
    • Description of error
    • Pearson VUE case number

Exam retake exceptions will be granted for the following reasons:

  • Failure due to lab crash
  • Failure due to Internet connectivity issues
  • Failure due to equipment failure
What is the validity of the certification? For life
Where can I find more information about this exam? To know more about the , click here.
What are the career opportunities after passing this exam?
  • Systems Analyst
  • Systems Engineer
  • Desktop Technician
  • Help Desk Technician
  • Systems Administrator
  • Technical Support Engineer
Customer Testimonials
Christian Udeochu
The 70-461 exam study guide covers all the objectives of 70-461 exam and includes topics such as creating database objects; working and modifying data; troubleshooting and optimizing queries and transactions. I strongly recommend taking this training as it exposes you to even more information than needed to succeed in a data related position.

Show more

×
uc logo for app downloadDownload our uCertify App [lms_setting_placeholder: This filed is used to set the LMS settings.

Share with your friends and colleagues

We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept