SQL Server 2012 certification provides essential skills needed to develop and maintain mission-critical Microsoft SQL Server 2012 environments. MCSA: SQL Server 2012 certification is the initial step towards earning an MCSE: Data Platform certification or an MCSE: Business Intelligence certification.

Learn about:

  • Optimize and tune queries
  • Create and alter stored procedures
  • Create and alter indexes
  • Maintain database integrity
  • Optimize indexing strategies
  • Create and alter tables
  • Maintain indexes
  • Create and modify constraints
  • Create and alter views
  • Create and alter user-defined functions (UDFs)
  • Control execution plans
  • Work with XML data
  • Implement full-text search
  • Troubleshoot security
  • Write automation scripts
  • Troubleshoot performance issues
  • Create visualizations of data by using Power View
  • Implement reporting solutions
  • Create data mining solutions
  • Implementing multidimensional databases
  • Creating tabular semantic data models

Prerequisites

This course is aimed for professionals with experience working with relational databases, and at least one year of hands-on experience working in a SQL Server environment.

MCSA SQL Server 2012 Track:

Next Steps