Scroll to top button

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

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 by 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 will you 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 Administering Microsoft SQL Server 2012 Databases and Implementing a Data Warehouse with SQL Server 2012 exams along with MCSA/MCSE Querying Microsoft SQL Server 2012 exam to achieve MCSA SQL Server 2012 certification.

 

Lessons
12+
Exercises
283+
Quizzes
125+
Flashcards
79+
Glossary of terms
38+
Pre-assessment Questions
20+
Full Length Tests
5+
Post-Assessment Questions
50+
Performance based lab
62+
Video tutorials
69+
Hours
01:04+
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.

Videos
21+
Minutes
49+
Exam FAQs
What is the exam registration fee? USD 165
Where do I take the exam? Pearson VUE and Prometric
What is the format of the exam? Linear, multiple-choice, fact-based, and so on.
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
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 will you 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

Copyright © 2002-2017 uCertify / All Rights Reserved.