70-461-v2 ISBN: 978-1-64459-034-8
Querying Microsoft SQL Server 2012/2014 (70-461)
Kick start your prep for the MCSA 70-461 exam with the Querying Microsoft SQL Server 2012/2014 (70-461) course and lab. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS. The SQL training course and lab completely cover the 70-461 exam objectives and provide an understanding of topics such as creating database objects; working and modifying data; troubleshooting and optimizing queries and transactions, and more.
Beginner Self-paced · 1 year access 4.5/5 (104 Reviews)
43 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / About
About This Course
Target Career Roles
- Systems Analyst
- Systems Engineer
- Desktop Technician
- Help Desk Technician
- Systems Administrator
- Technical Support Engineer
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
8 Interactive Lessons · 31 topics01 Introduction 2 topics +
- About SQL Server 2012/2014
- About Transact-SQL (T-SQL)
02 Managing Tables and Views 6 topics · 11 LiveLab +
- Creating Tables
- Modifying Existing Tables
- Understanding Indexes
- Understanding Views
- Partitioning Tables and Indexes
- Summary
11 LiveLab in this lesson — see the labs panel →
03 Creating Constraints and Triggers 4 topics · 7 LiveLab +
- Creating and Modifying Constraints
- Understanding Triggers
- Modifying Triggers
- Summary
7 LiveLab in this lesson — see the labs panel →
04 Working with Data 6 topics · 13 LiveLab +
- Using SELECT Statements
- Implementing Subqueries
- Implementing Data Types
- Implementing Aggregate Queries
- Managing XML Data
- Summary
13 LiveLab in this lesson — see the labs panel →
05 Modifying Data 5 topics · 6 LiveLab +
- Understanding Stored Procedures
- Using DML Statements
- Combining Datasets
- Working with Functions
- Summary
6 LiveLab in this lesson — see the labs panel →
06 Troubleshooting and Optimizing Queries 5 topics · 6 LiveLab +
- Tuning and Optimizing Queries
- Managing Transactions
- Evaluating Operations
- Implementing Error Handling
- Summary
6 LiveLab in this lesson — see the labs panel →
07 Appendix A 2 topics +
- Installing Microsoft SQL Server 2014 Management Studio
- Connecting to the Server
08 Appendix B 1 topics +
- 70-461 Exam Objectives
Hands-On Labs Our edge
43 LiveLabs- Creating a Table
- Adding a New Column in a Table
- Deleting a Column from a Table
- Deleting a Table
- Modifying a Column in a Table
- Creating a Clustered Index
- Creating a Non-Clustered Index
- Deleting an Index
- Creating a Filtered Index
- Creating an Indexed View
- Creating a View
- Creating a Primary Key Constraint
- Creating a Foreign Key Constraint
- Creating a Unique Constraint
- Dropping a Constraint
- Creating a DML Trigger
- Creating a DDL Trigger
- Using INSTEAD OF Trigger
- Using Logical Operators
- Using the SELECT statement
- Retrieving Specific Columns
- Using Calculated Columns
- Limiting Rows
- Using the LIKE Operator
- Using the BETWEEN Clause
- Using the PIVOT Operator
- Using Appropriate Data Types
- Using Subqueries
- Using the Analytic Function
- Working with Ranking Functions
- Using the XML Data Type
- Creating a Stored Procedure
- Adding New Data
- Updating a Record in a Table
- Removing a Record from the Table
- Combining Data Sets
- Using User-Defined Functions
- Displaying the Estimated Execution Plan
- Using SET STATISTICS IO
- Using the DECLARE and SET statements
- Using the BEGIN, COMMIT, and ROLLBACK TRANSACTION Statements
- Evaluating Operations
- Implementing Error Handling
03 / Exam details
Querying Microsoft SQL Server 2012/2014 (70-461) Details
Kick start your prep for the MCSA 70-461 exam with the Querying Microsoft SQL Server 2012/2014 (70-461) course and lab. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS. The SQL training course and lab completely cover the 70-461 exam objectives and provide an understanding of topics such as creating database objects; working and modifying data; troubleshooting and optimizing queries and transactions, and more.
04 / Reviews
104 verified learner reviews
3M+ happy customers · 50+ countries
The 70-461 exam study guide covers all the objectives of 70-461 exam and includes topics such as creating database objects; working and modifying data; troubleshooting and optimizi...ng queries and transactions. I strongly recommend taking this training as it exposes you to even more information than needed to succeed in a data related position.
05 / FAQs
Questions before you start
Prepare for Querying Microsoft SQL Server 2012/2014 (70-461)
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 43 LiveLab included
- Certificate of completion
No credit card required