Scroll to top button

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

ISBN : 9781616915353
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.

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
228+
Quizzes
123+
Flashcards
79+
Glossary of terms
37+
TestPrep
Pre Assessment Questions
50+
Full Length Tests
4+
Post Assessment Questions
50+
Lab
Performance lab
58+
Video tutorials
69+
Hours
01:04+
LiveLab (Add-on Component)
livelab
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+
  • 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
  • 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 (LiveLab)

  • 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
×