Special Offers | My Account | Log In
  0 items in your cart

Search: Boson Sites | Products
Microsoft > MCSA > MCSA: SQL Server 2012 Training

Upcoming Dates:

Don’t see the date you want? Contact us.
Price: $4875

Call 813-925-0700 (opt 2) to request this class.

MCSA: SQL Server 2012 Training

Class Delivery Methods
Request a private class

Contact Us:

813-925-0700 (opt 2)
877-333-EXAM (opt 2)
FAX: 813-925-3957
EMAIL: Boson Training

Full Course List

Request More Information

MCSA: SQL Server 2012 Training

About This IT Training:

Exam Numbers: 70-461, 70-462, 70-463
Certifications: MCSA
Single-User License  

This course prepares you for:
  • Microsoft Certified Solutions Associate: SQL Server 2012

MCSA: SQL Server 2012 Training

The nine-day MCSA: SQL Server 2012 Training covers all aspects of SQL Server 2012 including query, administration and data warehousing. This training course incorporates the Microsoft SQL Server 2012 Databases course and the Implementing a Data Warehouse with Microsoft SQL Server 2012 course. This training course is a combination of hands-on learning and lectures on focused materials mapped to exam objectives.

While attending this training course, you will take exams to test and certify for the Microsoft Certified Solutions Associate: SQL Server 2012 official certification.

What’s Included

  • Comprehensive study materials, including official Microsoft courseware
  • On-site certification testing with three examination vouchers and up to three retake vouchers that are valid for one year from original class date

Boson Training Class Guarantee

All of our Cisco and Microsoft courses come with our Boson Training Class Guarantee, which means if you don't pass, you can attend the class again for no charge. Learn more.

MCSA: SQL Server 2012 Training Course Content

  • Write SELECT queries
  • Query multiple tables
  • Use built-in functions
  • Use subqueries
  • Execute stored procedures
  • Use set operators
  • Implement error handling
  • Implement transactions
  • Use table expressions
  • Sort and filter data
  • Use window ranking, offset and aggregate functions
  • Query SQL Server metadata
  • Program with T-SQL
  • Improve query performance
  • Plan and install SQL Server
  • Create SQL Server Backups
  • Restore SQL Server databases
  • Use the import/export wizards and explain how they relate to SSIS
  • Work with SQL Server security models, logins and users
  • Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles
  • Work with permissions and the assignment of permissions
  • Work with SQL Server Audit
  • Work with SQL Server Agent, jobs and job history
  • Implement SQL Server agent security, proxy accounts and credentials
  • Configure database mail, alerts and notifications
  • Create database maintenance plans
  • Work with SQL Profiler and SQL Trace stored procedures
  • Introduce DMVs and the configuration of data collection
  • Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications
  • Troubleshoot SQL Server databases
  • Describe data warehouse concepts and architecture considerations
  • Select an appropriate hardware platform for a data warehouse
  • Design and implement a data warehouse
  • Implement Data Flow in an SSIS Package
  • Implement Data Flow in an SSIS Package
  • Debug and Troubleshoot SSIS packages
  • Implement an SSIS solution that supports incremental DW loads and changing data
  • Integrate cloud data into a data warehouse ecosystem infrastructure
  • Implement data cleansing by using Microsoft Data Quality Services
  • Implement Master Data Services to enforce data integrity at source
  • Extend SSIS with custom scripts and components
  • Deploy and Configure SSIS packages
  • Describe how information workers can consume data from the data warehouse

Related Products

Practice Lab for Microsoft 70-461
Practice Lab for Microsoft 70-462
Practice Lab for Microsoft 70-463
MCSA: SQL 2014 with MCSE: Data Platform Training

Be the first to review this product. If you have used this product, you can review it on your account page. You must be logged in to review products.