MCSA/MCSE - Querying Microsoft SQL Server 2012 (Course & Lab)
(70-461-complete)
/ ISBN: 9781616915353
This course includes
Lessons
TestPrep
Lab
LiveLab (Add-on)
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.
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
- 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
| 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 |
| Which certification covers this exam? |
×