Scroll to top button

MCSA/MCSE - Querying Microsoft SQL Server 2012

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.

Here's what you will get

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 FAQs
What are the prerequisites for this exam? This exam is intended for 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.
What is the exam registration fee? USD 165
Where do I take the exam? Pearson VUE
What is the format of the exam? Single choice, multiple choice, drag-and-drop, active screen, build list, case studies, and 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
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

Here's what you will learn

  • 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
70-461 70-461
MCSA/MCSE - Querying Microsoft SQL Server 2012
ISBN : 9781616912253