Maricopa Community Colleges  MST254   19982-19995 
Official Course Description: MCCCD Approval: 11/25/97
MST254 19982-19995 L+L 3 Credit(s) 4 Period(s)
Microsoft Structured Query Language (SQL) Server Level II
Knowledge and skills required to implement database design using Microsoft Structured Query Language (SQL) Server. Preparation for Microsoft certification examination. Prerequisites: MST244 or permission of instructor.
 
Course Note:Under the terms and conditions specified in the legal agreement between Microsoft Corporation and each AATP campus in the Maricopa Community College District, Microsoft requires that "all instructors of Microsoft Official Curriculum and Microsoft Approved Study Guides pass the Microsoft Certified Professional exam in the product area of the courseware being delivered."
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
MST254   19982-19995 Microsoft Structured Query Language (SQL) Server Level II
1. Integrate Windows NT and Structured Query Language (SQL) Server security. (I)
2. Design a strategy to back up and restore data. (II)
3. Implement mail, scheduling, and alerts to administer executive functions. (III)
4. Monitor replication and synchronization process. (IV)
5. Manage extensions and interfaces to SQL Server. (V)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
MST254   19982-19995 Microsoft Structured Query Language (SQL) Server Level II
    I. Implementing Structured Query Language (SQL) Server Security
        A. Windows NT and SQL Server Integrated Security
        B. Standard and mixed security
        C. Database permissions
        D. Transferring data
      II. Backing Up and Restoring System and User Databases
          A. Planning to back up your data
          B. Scheduling backups
          C. Recovery methods
          D. Restoring a user database, transaction logs, and individual tables
          E. Other methods of preventing data loss
        III. Administrative Functions
            A. Manage SQL executive functions
            B. Implement SQL mail
            C. Use task scheduling
            D. Manage alerts
            E. Monitoring and tuning SQL Server performance
          IV. Implementing SQL Server Replication
              A. Types of replication models
              B. Synchronization process
              C. Setting options on the publication and subscription servers
              D. Publishing
            V. Extensions and Interfaces to SQL Server
                A. Using and managing extended stored procedures
                B. Analyze distributed management objects
                C. Interfaces for data management
            Go to Description    Go to top of Competencies    Go to top of Outline