MCSA: SQL Server 2012 DBA Certification

Program Overview |Instructors |Curriculum |Certification |Who should do this course? |FAQ |Calendar

Program Overview

Montreal College is an official IT Academy for Microsoft certifications. In its close collaboration, the college offers official Microsoft curriculum to help you master the skills and prepare for the official certification exams.
MCSA: Microsoft SQL Server 2012 DBA Certification will lead you to become a database developer or a database analyst.

It has the following three programs:
1) Querying Microsoft SQL Server 2012
2) Administering Microsoft SQL Server 2012 Database
3) Implementing a Data Warehouse with Microsoft SQL Server 2012

Instructors

You call them instructors, we call them your Mentors!

They are the catalysts under whose supervision and arm’s length support our students are empowered to accomplish expertise in advanced technology. We boast of enterprising and talented resources with proven track records who are working in tandem with our goal to provide inspiring and enduring technical learning experience to our students.

Curriculum

1) Querying Microsoft SQL Server 2012

  • Describe the basic architecture and concepts of Microsoft SQL Server 2014.
  • Understand the similarities and differences between Transact-SQL and other computer languages.
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions

2) Administering Microsoft SQL Server 2012 Database

  • Describe core database administration tasks and tools.
  • Install and configure SQL Server 2014.
  • Configure SQL Server databases and storage.
  • Plan and implement a backup strategy.
  • Restore databases from backups.
  • Import and export data.
  • Monitor SQL Server.
  • Trace SQL Server activity.
  • Manage SQL Server security.
  • Audit data access and encrypt data.
  • Perform ongoing database maintenance.
  • Automate SQL Server maintenance with SQL Server Agent Jobs.
  • Configure Database Mail, alerts and notifications.

3) Implementing a Data Warehouse with Microsoft SQL Server 2012

  • 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 Control Flow in an SSIS Package.
  • Debug and Troubleshoot SSIS packages.
  • Implement an ETL solution that supports incremental data extraction.
  • Implement an ETL solution that supports incremental data loading.
  • Implement data cleansing by using Microsoft Data Quality Services.
  • Implement Master Data Services to enforce data integrity.
  • Extend SSIS with custom scripts and components.
  • Deploy and Configure SSIS packages.
  • Describe how BI solutions can consume data from the data warehouse.

Certification

Certificate of participation for “SQL Server 2012 DBA ” and equipped to give  “MCSA: SQL Server Solutions Associate”

Who should do this course?

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. It is for database professionals who need to create and support a data warehousing solution. Also, for individuals who administer and maintain SQL Server databases.

FAQ

Calendar

  • Session one
    05 November 2016
    21 10 16
    Apply
  • Session two
    21 January 2017
    23 12 16
    Apply
  • Session three
    08 July 2017
    26 05 17
    Apply