Course Brief

This course is intended for Database Professionals who perform installation, maintenance and configuration tasks as their primary areas of responsibility. They will often set up database systems and are responsible for making sure those systems operate efficiently. They also make sure that the data they store is backed up regularly, stored effectively, and that the data is secure from unauthorized access. Primary responsibilities may include but are not limited to:

 

  • Audit SQL Server instances.
  • Back up databases.
  • Configure additional SQL Server components.
  • Configure SQL Server instances.
  • Configure SQL Server services.
  • Deploy SQL Server.
  • Implement a migration strategy.
  • Implement columnstore indexes.
  • Implement contained databases.
  • Implement HADR (High-Availability and Disaster Recovery solution).
  • Import and export data.
  • Install SQL Server and related services.
  • Maintain a database.
  • Maintain indexes.
  • Manage and configure databases.
  • Manage data partitions.
  • Manage database permissions.
  • Manage database snapshots.
  • Manage logins and server roles.
  • Manage SQL Server Agent alerts.
  • Manage SQL Server Agent jobs.
  • Manage SQL Server Agent operators.
  • Manage SQL Server instances
  • Manage users and database roles.
  • Manage, create, and design log files.
  • Optimize queries.
  • Plan installation.
  • Restore databases.
  • Troubleshoot security.

 

Upon completion of this program students can move on to the Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-643) program.


  • This course is offered in 30 hours
This course is intended for Database Professionals who perform installation, maintenance and configuration tasks as their primary areas of responsibility. They will often set up database systems and are responsible for making sure those systems operate efficiently. They also make sure that the data they store is backed up regularly, stored effectively, and that the data is secure from unauthorized access. Primary responsibilities may include but are not limited to:

 

  • Audit SQL Server instances.
  • Back up databases.
  • Configure additional SQL Server components.
  • Configure SQL Server instances.
  • Configure SQL Server services.
  • Deploy SQL Server.
  • Implement a migration strategy.
  • Implement columnstore indexes.
  • Implement contained databases.
  • Implement HADR (High-Availability and Disaster Recovery solution).
  • Import and export data.
  • Install SQL Server and related services.
  • Maintain a database.
  • Maintain indexes.
  • Manage and configure databases.
  • Manage data partitions.
  • Manage database permissions.
  • Manage database snapshots.
  • Manage logins and server roles.
  • Manage SQL Server Agent alerts.
  • Manage SQL Server Agent jobs.
  • Manage SQL Server Agent operators.
  • Manage SQL Server instances
  • Manage users and database roles.
  • Manage, create, and design log files.
  • Optimize queries.
  • Plan installation.
  • Restore databases.
  • Troubleshoot security.

Champs Fleurs

There are no classes scheduled in Champs Fleurs at this time.

 

  • Microsoft Certified Solutions Associate (MCSA): SQL Server 2012

    The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification demonstrates your essential skills and breakthrough insights in developing and maintaining the next wave of mission critical environments.

    This certification qualifies you for a position as a software or database developer or database analyst.It consists of the following modules and each module is covered in 30 contact hours.


    Why Study MCSA:SQL Server with SBCS?

    • Instructors are certified, highly skilled and experienced practitioners who bring their knowledge and work experience to the classroom.
    • Course is career oriented. The curriculum was developed to meet the needs of the current marketplace.
    • The course is practical. All sessions are held in a lab and each participant has access to a computer.
    • Modern, fully equipped labs. You learn using the same hardware and software that you will encounter in the field.
    • Convenient class schedules. Classes are offered part-time at one location. This allows working individuals to balance their work and educational needs.
    • Sufficient contact hours to cover the full syllabus and prepare participants for the Microsoft exams.
    • Microsoft exams can be written at your convenience at our Champs Fleurs campus through our testing center.

    SCHEDULE & FEES

    This programme is available for Corporate Training.  Please contact us for a quotation.