Scroll to top button

70-461 : MCSA/MCSE - Querying Microsoft SQL Server 2012 (Course & Lab)

70-461-complete
70-461-complete
MCSA/MCSE - Querying Microsoft SQL Server 2012 (Course & Lab)
ISBN : 978-1-61691-535-3
Gain hands-on expertise in Microsoft SQL Server certification exam with 70-461 course and performance-based labs. Performance-based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. The course and performance-based labs cover all the objectives of Microsoft 70-461 certification exam and include topics such as creating database objects; working and modifying data; troubleshooting and optimizing queries and transactions.

Here's what you will get

The Querying Microsoft SQL Server 2012 exam is part of MCSA SQL Server 2012 certification. The 70-461 exam is a required part of the certification. This exam covers 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. You have to pass 70-462 and 70-463 exams along with MCSA/MCSE Querying Microsoft SQL Server 2012 exam to achieve MCSA SQL Server 2012 certification.

 

Lessons
Lessons
12+
Exercises
283+
Quizzes
125+
Flashcards
79+
Glossary of terms
38+
TestPrep
Pre-assessment Questions
20+
Full Length Tests
5+
Post-Assessment Questions
50+
Lab
Performance based lab
62+
Video tutorials
69+
Hours
01:04+
Live Lab
live lab
13+
Video tutorials
69+
Hours
01:04+

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
Videos
21+
Minutes
49+
Exam FAQs
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? 700
What is the exam's retake policy?

Here are the retake policies:

  • If a candidate achieves a passing score on an exam, the candidate cannot take the exam again.
  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait at least 24 hours before resitting 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 for the third time. Same applies with fourth and fifth exam retakes.
  • A candidate may not take a given exam any more than five times per 12 months. This 12-month period starts the day of the fifth unsuccessful exam retake. To take a given exam more than five times per year, a candidate must submit a request and obtain prior permission from Microsoft.
Where can I find more information about this exam? To know more about the 70-461-complete, click here.
Which certification covers this exam?

Here's what you will learn

  • Overview
  • What Is Information Technology?
  • Introduction to Databases
  • Database Servers and Applications
  • SQL Server's Role
  • Summary
  • Chapter 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
  • Chapter 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
  • Chapter Essentials
  • Relational Database Theory
  • Database Design Processes
  • Project Management for the DBA
  • Summary
  • Chapter Essentials
  • Planning a Database
  • Understanding Entity Relationship Diagramming
  • Building an ERD
  • Capacity Planning
  • Summary
  • Chapter Essentials
  • Designing for Normalization
  • Designing for Performance
  • Designing for Availability
  • Designing for Security
  • Summary
  • Chapter 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
  • Chapter Essentials
  • Data Types
  • Query and manage XML data.
  • Collations
  • Table Creation Process
  • Data Partitioning
  • Summary
  • Chapter Essentials
  • Understanding Indexes
  • Creating Basic Indexes
  • Creating Advanced Indexes
  • Managing Indexes
  • Understanding Views
  • Creating Views
  • Summary
  • Chapter Essentials
  • Triggers Defined
  • Using Triggers
  • Creating Triggers
  • Understanding Stored Procedures
  • Creating Stored Procedures
  • Summary
  • Chapter Essentials
  • Certification Objectives Map
  • Installation Requirements
  • Installing SQL Server 2012 Express in Windows

Hands on Activities (Labs)

  • Database terminologies
  • filestream data type
  • Management features
  • SQL Server roles
  • Installation planning phases
  • SQL Server components
  • Using Data Access method
  • Data Write method
  • Resource Page
  • Installation Center Tasks
  • Validating the installation
  • Opening the Query Editor window
  • Retrieving All Records from a Table
  • Retrieving selected records from a table
  • Using the DISTINCT keyword
  • Using the LIKE operator
  • Using the Left Join
  • Using the GREATER THAN relational operator
  • Using the IS NOT NULL condition
  • Using the IS NULL condition
  • Using the MIN() function
  • Using the MAX() function
  • Using the AVG() function
  • Deleting a table from a database using T-SQL code
  • Inserting a record in a table of a database
  • Using the WHERE clause in a table of a database
  • Updating a record in a table of a database
  • Deleting a record from a table of a database
  • Relationship types
  • Systems Development Life Cycle
  • Database Life Cycle
  • Phases of the design model
  • Preparing the Visio environment for Entity Relationship diagramming
  • Creating the Visio Entity Relationship diagram
  • Normalizing the unnormalized model to the first normal form
  • Normalizing the first normal form to the second normal form
  • Normalizing the second normal form to the third normal form
  • Creating multiple filegroups
  • Creating the Books database in the GUI
  • Detaching the Books database in the GUI
  • Attaching the Books database in the GUI
  • Assigning collations at the column level
  • Executing a make table query
  • Adding a column to a table
  • Creating columns
  • Selecting the primary key
  • Specifying table properties and saving the table
  • Launching the Table Designer
  • Scripting the table for documentation
  • Setting the primary key
  • Creating the LastName non-clustered index
  • Creating the City non-clustered index
  • Creating an index on a column of a table of a database
  • Creating the Covering index
  • Creating the Filtered index
  • Dropping an index from a column of a table of a database
  • Disabling an index by using T-SQL Code
  • Enabling an index on a column of a table of a database using T-SQL code
  • Creating a view using T-SQL code
  • Create a trigger
  • Trigger subtypes
  • Drop a trigger

Hands on Activities (Live Labs)

  • Database terminologies
  • filestream data type
  • Management features
  • SQL Server roles
  • Installation planning phases
  • SQL Server components
  • Using Data Access method
  • Data Write method
  • Resource Page
  • Installation Center Tasks
  • Validating the installation
  • Opening the Query Editor window
  • Retrieving All Records from a Table
  • Retrieving selected records from a table
  • Using the DISTINCT keyword
  • Using the LIKE operator
  • Using the Left Join
  • Using the GREATER THAN relational operator
  • Using the IS NOT NULL condition
  • Using the IS NULL condition
  • Using the MIN() function
  • Using the MAX() function
  • Using the AVG() function
  • Deleting a table from a database using T-SQL code
  • Inserting a record in a table of a database
  • Using the WHERE clause in a table of a database
  • Updating a record in a table of a database
  • Deleting a record from a table of a database
  • Relationship types
  • Systems Development Life Cycle
  • Database Life Cycle
  • Phases of the design model
  • Preparing the Visio environment for Entity Relationship diagramming
  • Creating the Visio Entity Relationship diagram
  • Normalizing the unnormalized model to the first normal form
  • Normalizing the first normal form to the second normal form
  • Normalizing the second normal form to the third normal form
  • Creating multiple filegroups
  • Creating the Books database in the GUI
  • Detaching the Books database in the GUI
  • Attaching the Books database in the GUI
  • Assigning collations at the column level
  • Executing a make table query
  • Adding a column to a table
  • Creating columns
  • Selecting the primary key
  • Specifying table properties and saving the table
  • Launching the Table Designer
  • Scripting the table for documentation
  • Setting the primary key
  • Creating the LastName non-clustered index
  • Creating the City non-clustered index
  • Creating an index on a column of a table of a database
  • Creating the Covering index
  • Creating the Filtered index
  • Dropping an index from a column of a table of a database
  • Disabling an index by using T-SQL Code
  • Enabling an index on a column of a table of a database using T-SQL code
  • Creating a view using T-SQL code
  • Create a trigger
  • Trigger subtypes
  • Drop a trigger