Think Career in IT
Think Steps......

IT Training from the masters

MCSA SQL Server 2012 (Microsoft Certified Solutions Associated)

The skills for your professional career, SQL Server certification will qualify you for a position as a database developer or database analyst. Prove you have the core technical skills required to build a sustainable career in IT.

MCSA SQL Server 2012 (Microsoft Certified Solutions Associated)
Course Details:
  • Querying Microsoft SQL Server 2012 (70-461)
  • Administering Microsoft SQL Server 2012 Databases (70-462)
  • Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463)
Microsoft SQL Server Training Details:
Querying Microsoft SQL Server 2012 (70-461)
  • Create and alter tables using T-SQL syntax.
  • Create and modify constraints (simple statements).
  • Create and alter DML triggers.
  • Query data by using SELECT statements.
  • Query and manage XML data.
  • Create and alter stored procedures (simple statements).
  • Modify data by using INSERT, UPDATE and DELETE statements.
  • Combine datasets
  • Work with functions.
  • Optimise queries.
  • Manage transactions.
  • Evaluate the use of row-based operations vs. set-based operations
  • Implement error handling
Administering Microsoft SQL Server 2012 Databases (70-462)
  • Install SQL Server and related services.
  • Implement a migration strategy.
  • Configure additional SQL Server components.
  • Manage SQL Server Agent.
  • Manage and configure databases.
  • Implement an SQL Server clustered instance.
  • Identify and resolve concurrency problems.
  • Collect and analyse troubleshooting data.
  • Configure and maintain a backup restore database strategy
  • Implement and maintain indexes
  • Import and export data
  • Import and export data
  • Manage users and database roles permission.
  • Troubleshoot security.
  • Implement database mirroring
Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463)
  • Design and implement dimensions and fact table.
  • Define connection managers.
  • Design and implement data flow.
  • Manage SSIS package execution
  • Implement script tasks in SSIS
  • Implement package logic by using SSIS variables and parameters
  • Implement script components in SSIS
  • Install and maintain SSIS components
  • Implement auditing, logging and event handling
  • Deploy SSIS solutions
  • Configure SSIS security settings
  • Install and maintain data quality services
  • Implement master data management solutions
  • Create a data quality project to clean data.

Courses