MCSA: SQL Server 2012 Online Training

The exams associated with this course have been retired. However, this course still retains value as a training resource.

In this intermediate Microsoft SQL Server 2012 training, Garth Schulte prepares learners to write queries and implement data warehouses.

The 70-461, 70-462 and 70-463 exams associated with this playlist were revised in 2016, but a large percentage of this course still maps to the current exam objectives and continues to provide value as a training resource.

Though Microsoft has made it relatively easy to migrate data between SQL Server versions, many companies rely on older SQL Server versions for a number of reasons. In addition to exam preparation, this training can serve as reference material for anyone who currently manages databases or data warehouses that still live on SQL Server 2012.

For anyone who manages IT training for a company or team that still supports SQL Server 2012, this SQL Server 2012 training can be used for legacy technology training, on-boarding new systems administrators, or as part of a team training plan.

MCSA: SQL Server 2012: What You Need to Know

This MCSA: SQL Server 2012 training proceeds through the 70-461, 70-462, and 70-463 exam objectives and covers topics including:

Using Transact-SQL (T-SQL) to create and alter tables, views, constraints, and DML triggers
Implementing sub-queries, data types, aggregate queries, and error handling
Installing and configuring SQL Server
Using INSERT, UPDATE, and DELETE statements to modify data
Deploying and configuring SSIS
Configuring databases and SQL Server instances
Managing backup, restore, database security, and high availability
Implementing dimensions, fact tables, data flow, SSIS package execution, and script tasks

Who Should Take MCSA: SQL Server 2012 Training?

This MCSA: SQL Server 2012 course is valuable for new IT professionals with at least a year of experience with SQL Server 2012 and experienced systems administrators looking to validate their Microsoft skills.

New or aspiring systems administrators. Mainstream support of SQL Server 2012 may have ended in 2017, but there are plenty of data warehouses still being run by this version. This MCSA training can help system administrators design, monitor, backup, and troubleshoot SQL Server 2012.

Skill:
Microsoft SQL Server 2012: Querying (70-461)
- 1. Introduction to 70-461: Querying Microsoft SQL Server 2012
  35 mins
- 2. Creating and Altering Tables with T-SQL
  34 mins
- 3. Creating and Altering Views with T-SQL
  43 mins
- 4. Designing Views
  32 mins
- 5. Creating and Modifying Constraints
  42 mins
- 6. Creating and Modifying DML Triggers
  46 mins
- 7. Querying Data using SELECT
  58 mins
- 8. Implementing Subqueries
  33 mins
- 9. Implementing Data Types
  40 mins
- 10. Implementing Aggregates
  44 mins
- 11. Querying and Managing XML Data
  43 mins
- 12. Creating and Altering Stored Procedures
  33 mins
- 13. Modifying Data with T-SQL
  33 mins
- 14. Combining Datasets
  22 mins
- 15. Working with Functions
  42 mins
- 16. Optimizing Queries
  37 mins
- 17. Managing Transactions
  27 mins
- 18. Row-based vs. Set-based Operations
  22 mins
- 19. Implementing Error Handling
  15 mins
- 20. Solution Nugget
  33 mins
Skill:
Microsoft SQL Server 2012: Administering Databases (70-462)
- 1. Introduction to 70-462: Administering SQL Server 2012
  10 mins
- 2. Planning a SQL Server 2012 Installation
  32 mins
- 3. Installing SQL Server 2012
  39 mins
- 4. Implementing a Migration Strategy
  31 mins
- 5. Configuring SQL Server Components
  52 mins
- 6. Managing SQL Server Agent
  34 mins
- 7. Configuring and Managing Databases
  57 mins
- 8. Configuring and Managing Instances
  46 mins
- 9. Implementing a Clustered Instance
  43 mins
- 10. Identifying and Resolving Concurrency Issues
  36 mins
- 11. Troubleshooting SQL Server
  35 mins
- 12. Auditing SQL Server
  32 mins
- 13. Implementing a Backup Strategy
  38 mins
- 14. Restoring Databases
  23 mins
- 15. Implementing and Maintaining Indexes
  56 mins
- 16. Importing and Exporting Data
  27 mins
- 17. Managing Logins and Server Roles
  24 mins
- 18. Managing Users and Database Roles
  28 mins
- 19. Managing and Troubleshooting Security
  25 mins
- 20. Implementing AlwaysOn Availability Groups
  37 mins
- 21. Implementing Database Mirroring
  20 mins
- 22. Implementing Replication
  34 mins
- 23. Virtual Lab Solution Nugget
  33 mins
Skill:
Microsoft SQL Server 2012: Implementing a Data Warehouse (70-463)
- 1. Introduction to 70-463: Implementing a Data Warehouse with SQL Server 2012
  21 mins
- 2. Designing and Implementing Dimensions
  45 mins
- 3. Designing and Implementing Fact Tables
  35 mins
- 4. Introduction to SSIS and Connection Managers
  54 mins
- 5. Designing Data Flow
  35 mins
- 6. Implementing Data Flow
  46 mins
- 7. Managing SSIS Package Execution
  34 mins
- 8. Implementing Script Tasks
  31 mins
- 9. Designing Control Flow
  22 mins
- 10. Implementing Control Flow
  47 mins
- 11. Implementing Package Logic
  44 mins
- 12. Data Loading Options
  48 mins
- 13. Implementing Script Components
  38 mins
- 14. Troubleshooting Data Integration Issues
  32 mins
- 15. Installing and Maintaining SSIS Components
  22 mins
- 16. Implementing Auditing, Logging and Event Handlers
  21 mins
- 17. Deploying SSIS Solutions
  26 mins
- 18. Configuring SSIS Security
  24 mins
- 19. Installing and Maintaining Data Quality Services
  24 mins
- 20. Implementing Data Quality Services
  29 mins
- 21. Implementing Master Data Services
  23 mins
- 22. Virtual Lab Solution Nugget
  47 mins

No Transcript Available

Introduction to 70-461: Querying Microsoft SQL Server 2012

Access all premium content with a free week!

Start a free week

Course overview

38 HOURS OF TRAINING

3 SKILLS

65 VIDEOS

3 VIRTUAL LABS

0 PRACTICE EXAMS

Garth Schulte

Nugget trainer since 2002

Read the full bio

What is it like to train with us?

Our learners say it best.

Helps me learn the skills I need when I need them

THOMAS S. | SYSTEMS ENGINEER & CONSULTANT

Read Reviews

Microsoft MCSA: SQL Server 2012/2014 FAQs: Cost, Training, Value

What's the underlying technology on the MCSA: SQL Server 2012/2014?

The key technologies on the MCSA: SQL Server 2012/2014 were writing and managing SQL queries, administering databases and implementing data warehouses -- all with SQL Server 2012/2014. The MCSA: SQL Server 2012/2014 was a Microsoft certification designed to prove that an administrator had deep familiarity and knowledge with SQL Server 2012/2014, the enterprise database management system.

Are the 70-461, 70-462, and 70-463 certification exams retired?

Yes, 70-461, 70-462, and 70-463 -- the three certification exams for the MCSA: SQL Server 2012/2014 -- are all retired. Don't go looking for the replacement exams, though, because you won't find them. Although SQL Server 2012/2014 is still a perfectly good database system for enterprise networks, Microsoft retired the certification. You can no longer take 70-461, 70-462, or 70-463, and there will not be any replacements for them.

Is the MCSA: SQL Server 2012/2014 still valid?

No, the MCSA: SQL Server 2012/2014 is not still valid. Microsoft retired the MCSA: SQL Server 2012/2014 at the same time they retired all the other MCSA certifications and certifying exams. The MCSA: SQL Server 2012/2014 is no longer valid because Microsoft decided to realign the objectives of its certification program to focus on the responsibilities a person might have in a certain job role, rather than mastery of one single piece of technology.

What certification replaces MCSA: SQL Server 2012/2014?

There is no certification that replaces MCSA: SQL Server 2012/2014. The MCSA: SQL Server 2012/2014 certification has no replacement because Microsoft retired the entire series of MCSA certifications when they decided the certifications were too specific and narrowly focused. Depending on what you need it for, the Microsoft 365 Certified series of certifications might be a certification that could replace the MCSA: SQL Server 2012/2014 for you.

Is this MCSA: SQL Server 2012/2014 training still valuable?

Yes, this MCSA: SQL Server 2012/2014 is definitely still valuable for certain administrators and even developers. This MCSA: SQL Server 2012/2014 training was designed to help learners pass the 70-461, 70-462, and 70-463 exams. Those were challenging exams that tested familiarity with querying, administering and implementing data warehouses with SQL Server 2012/2014. You can't earn the cert, but if you need training in doing those things, this training is very valuable.

Oracle Database SQL Certified Associate (1Z0-071)

SQL for Data Practitioners