Business Skills – Managing and Marketing
HELP DESK AND CALL CENTRE SKILLS
Home Inspection and Maintenance
Job Readiness-Employability Skills
Simulations and Drills-non-credit
Microsoft SQL Server 2008 Implementation and Maintenance (SSMS432) Courses
Microsoft SQL Server 2008 Implementation and Maintenance (SSMS432) Course Introduction
This course provides students with the knowledge and skills necessary to implement, maintain, troubleshoot, and debug SQL Server 2008. It focuses on teaching students how to use SQL Server 2008 product features and tools related to maintaining a database.
Students should possess the knowledge and experience with implementing and administering a network operating system and experience using SQL Server.
This course prepares students to write the following Microsoft exam:
70-432: Microsoft SQL Server 2008, Implementation and Maintenance
A Student Textbook is provided for on-going reference. There is a final exam upon completion of the course. Participants who receive 75% or higher on their exam will receive a certificate.
Due to the dynamic nature of the IT industry, job success mandates that an individual not only learns the theory, but also obtains the skill to locate resources that provide answers and help to solve problems on the job. We encourage our students to develop research and study skills that will help them to make the transition from the classroom to the work environment. Independent thinking is required of anyone considering IT courses and a career in IT.
This course covers the objectives for Microsoft exam 70-432: Microsoft SQL Server 2008, Implementation and Maintenance. Passing this exam completes the requirements for the MCTS: Microsoft SQL Server 2008, Implementation and Maintenance certification.
Industry Certification Preparation
This course prepares the student to write Microsoft Exam 70-432.
Method of Delivery
Online training supported by Academy of Learning College facilitators or Online instructors.
Microsoft SQL Server 2008 Implementation and Maintenance (SSMS432) Course Breakdown
SQL Server 2008 Introduction; SQL Server 2008 Requirements and Considerations; SQL Server 2008 Installation; Preparing to Upgrade to SQL Server 2008; Upgrading to SQL Server 2008; Performing a SQL Server 2008 Installation
SQL Server 2008 Configuration; SQL Server 2008 Feature Configuration; SQL Server 2008 Database Architecture; Database Creation in SQL Server 2008; Configuring SQL Server 2008
SQL Server 2008 Database Resource Security; SQL Server 2008 Login, Schema, and User Creation; Data Encryption in SQL Server 2008; Impersonation in SQL Server 2008; Audit Access to SQL Server 2008; Creating and Auditing Logins in SQL Server 2008
SQL Server 2008 Database Integrity and File Management; Moving Database Files in SQL Server 2008; Using Database Maintenance Plans in SQL Server 2008; Managing Database Integrity and Using Maintenance Plans; SQL Server Agent Security and Operator Configuration; Configuring SQL Server Agent Jobs and Alerts; Policy-Based Management in SQL Server 2008; Using SQL Server Agent and Policy-Based Management
Managing Table Partitions in SQL Server 2008; SQL Server 2008 Data Compression in a Database; Introduction to Indexes in SQL Server 2008; Index Creation in SQL Server 2008; Managing Indexes in SQL Server 2008; Transferring Bulk Data in SQL Server 2008; Importing and Exporting Data in SQL Server 2008; Managing Tables, Indexes, and Data in SQL Server 2008
Creating Trace Files in SQL Server 2008; Tuning a Database in SQL Server 2008; Monitoring Resources in SQL Server 2008; Creating Data Collectors in SQL Server 2008; Monitoring a SQL Server 2008 Instance; Locking in a SQL Server 2008 Database; Resolving Deadlocks and Blocks in SQL Server 2008; Monitoring and Tuning SQL Server 2008 Performance
Recovery Models and Backup Types in SQL Server 2008; Performing SQL Server 2008 Database Backups; Restoring SQL Server 2008 Backups; Working with Database Snapshots in SQL Server 2008; Backing Up and Restoring a SQL Server 2008 Database
Introduction to Database Mirroring in SQL Server 2008; Database Mirroring Configuration in SQL Server 2008; SQL Server 2008 Log Shipping Configuration; Replication Configuration in SQL Server 2008; Replication Management in SQL Server 2008; High-Availability Solutions in SQL Server 2008; Failover Clustering in SQL Server 2008
- Accounting Graduate - Dharmendra's Story "It built my confidence to work in Canada."
- Healthcare Graduate - Josie's Story "Academy of Learning prepared me to work in the real world."
- Office Administration Graduate - Luz's Story "They created an incredible environment for students."
- Healthcare Graduate - Carolyn's Story "It's a very positive experience."