Maricopa Community Colleges  CIS275CF   19994-20036 
Official Course Description: MCCCD Approval: 03/23/99
CIS275CF 19994-20036 L+L 3 Credit(s) 4 Period(s)
Microsoft Structured Query Language Server Level II
Knowledge and skills required to implement database design using Microsoft (MS) Structured Query Language (SQL) Server. Covers data storage and restoration, administrative functions, replication and synchronization process. Prerequisites: CIS275CG or permission of instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS275CF   19994-20036 Microsoft Structured Query Language Server Level II
1. Integrate Windows NT and Structured Query Language (SQL) Server security. (I)
2. Identify various recovery methods. (II)
3. Design a strategy to back up and restore data. (II)
4. Implement mail, scheduling, and alerts to administer executive functions. (III)
5. Identify types of replication models. (IV)
6. Monitor replication and synchronization process. (IV)
7. Explain extended stored procedures. (V)
8. Manage extensions and interfaces to SQL Server. (V)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS275CF   19994-20036 Microsoft Structured Query Language 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