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

(70-461-complete) / ISBN: 9781616915353
This course includes
Lessons
TestPrep
Lab
LiveLab (Add-on)
Share
$279.99
Are you an instructor?
Request free evaluation copy

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

Gain hands-on expertise in MCSA SQL Server 2012 certification exam with 70-461 complete course with 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 the 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
  • 12+ Lessons
  • 228+ Exercises
  • 123+ Quizzes
  • 79+ Flashcards
  • 37+ Glossary of terms
Test Preps
  • 50+ Pre Assessment Questions
  • 50+ Post Assessment Questions
Lab
  • 58+ Performance lab
  • 69+ Video tutorials
  • 01:04+ Hours
LiveLab (Add-on)
  • 13+ livelab
  • 69+ Video tutorials
  • 01:04+ Hours
Video Lessons
  • 21+ Videos
  • 49+ Minutes
Here's what you will learn
Download Course Outline
  • 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

Hands on Activities (Labs)

  • Installation planning phases
  • SQL Server Components
  • 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 Model 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 FirstName 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 a 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

  • Installation planning phases
  • SQL Server Components
  • 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 Model 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 FirstName 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 a 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
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?
×