|
Official Course
Description: MCCCD Approval: 06/25/02 |
|||
|
MST244 20026-99999
|
L+L |
3 Credit(s) |
4 Period(s) |
|
Microsoft SQL Server Administration |
|||
|
Knowledge and skills required to install, configure, and administer Microsoft SQL server. Preparation for Microsoft certification examination. Prerequisites: Any MST152 course, or MST170, or permission of instructor. |
|||
|
|
|||
Go to Competencies Go to Outline
|
MCCCD Official Course Competencies: |
|
|
|
|
|
MST244 20026-99999 |
Microsoft SQL Server
Administration |
|
1. |
Install and configure SQL Server. (I) |
|
2. |
Create and configure a SQL Server database. (II) |
|
3. |
Backup and restore database. (III) |
|
4. |
Import and export data. (IV) |
|
5. |
Manage SQL Server access. (V) |
|
6. |
Implement SQL Server permissions. (VI) |
|
7. |
Monitor system performance. (VII) |
|
|
|
Go to Description Go to top of Competencies
|
MCCCD Official Course Outline: |
|
|
|
|
|
MST244 20026-99999 |
Microsoft SQL Server
Administration |
|
|
|
I. Structured Query Language (SQL) Server Overview A. Environment and components B. Relational database elements C. Installation and configuration of SQL Server D. System architecture II. SQL Server Database A. Creation B. Database options C. Filegroups D. Transaction log E. Performance III. Database Management A. Data storage optimization B. Disaster recovery C. Backup and restore D. Integrity checks IV. Populating a Database A. Importing data B. Exporting data C. Data transfer tools V. SQL Server Access Management A. Authentication process B. Authorization process C. Login management D. Access and security audit VI. SQL Server Permissions Management A. Database-specific B. Roles C. Access and permission strategy VII. Administrative Tasks A. Maintenance B. Job creation and automation C. Alert configuration D. Monitor performance E. Replication |