Maricopa Community Colleges  CIS275CI   20014-20016 
Official Course Description: MCCCD Approval: 06/26/01
CIS275CI 20014-20016 L+L 3 Credit(s) 4 Period(s)
System Administration for Microsoft Structured Query Language Server 7.0
Microsoft (MS) Structured Query Language (SQL) Server 7.0 system administration. Covers installation, configuration, security issues, database files and replication as well as backing-up, restoring and transferring data. Prerequisites: CIS105.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS275CI   20014-20016 System Administration for Microsoft Structured Query Language Server 7.0
1. Describe a Microsoft (MS) Structured Query Language (SQL) server including its architecture, security and database. (I)
2. Install an SQL Server using the Server Setup program. (II)
3. Configure an SQL Server. (II)
4. Assign login accounts and permissions to database user accounts and roles. (III)
5. Manage various database files. (IV)
6. Back up user and system databases. (V)
7. Practice restoring databases. (VI)
8. Create and schedule jobs. (VII)
9. Identify and describe the tools for transferring data in MS SQL Server 7.0. (VIII)
10. Explain the importance of monitoring the SQL Server. (IX)
11. Maintain and monitor the SQL Server. (IX)
12. Identify various methods to distribute data. (X)
13. Explain how to plan and set up replication. (X)
14. Monitor and troubleshoot SQL Server replication using tools, system stored procedures and system tables. (X)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS275CI   20014-20016 System Administration for Microsoft Structured Query Language Server 7.0
    I. Structured Query Language (SQL) Server Overview
        A. Definition
        B. Server Architecture
        C. Server Security
        D. Server Database
        E. Working With SQL Server
      II. Installation and Configuring
          A. Hardware and Software Requirements
          B. Installation Options
          C. Server Setup Program
          D. Verifying Installation
          E. Preparing to Use Server
          F. Troubleshooting
        III. Managing Security
            A. Authentication Mode
            B. Assigning Logins to Users and Roles
            C. Assigning Permissions to Users and Roles
            D. Planning Security
            E. Managing Application Security
          IV. Managing Database Files
              A. Database Overview
              B. Working With Databases
              C. Modifying Databases
              D. Managing Databases on Multiple Disks
              E. Capacity Planning
              F. Performance Considerations
            V. Backing Up Databases
                A. Preventing Data Loss
                B. SQL Server Backup
                C. When to Backup
                D. Performing Backups
                E. Types of Methods
                F. Planning a Backup Strategy
                G. Performance Consideration
              VI. Restoring Databases
                  A. SQL Server Recovery Process
                  B. Preparing to Restore
                  C. Restoring Backups
                  D. Restoring From Different Backup Types
                  E. Using a Standby SQL Server
                  F. Restoring Damaged System Databases
                VII. Automating Administrative Tasks
                    A. Reasons to Automate
                    B. SQL Server Automation
                    C. Automating Routine Maintenance Tasks
                    D. Creating Alerts
                    E. Troubleshooting
                    F. Establishing a Multiserver Environment
                    G. Publishing Database Data on the Web
                  VIII. Transferring Data
                      A. Overview
                      B. Tools
                      C. Data Transformation Services (DTS)
                      D. Transferring Data with DTS
                    IX. Monitoring and Maintaining
                        A. Why Monitor
                        B. Tools
                          1. Microsoft (MS) Event Viewer
                          2. SQL Server Performance Monitor
                          3. SQL Server Current Activity Window
                          4. Transact-SQL
                          5. SQL Server Profiler
                          6. SQL Server Query Analyzer
                        C. Flight Recorder
                        D. Maintenance
                      X. Replication
                          A. Overview
                            1. Distributed Data
                            2. Agents
                            3. Types
                            4. Physical Models
                          B. Planning and Setting Up Replication
                            1. Planning
                            2. Configuring Network Security Access
                            3. Preparing the Server
                            4. Publishing
                            5. Subscribing
                            6. Performance Considerations
                          C. Managing Replication
                            1. Monitoring
                            2. Troubleshooting
                            3. Replicating Heterogeneous Environments
                            4. Publishing on the Internet
                      Go to Description    Go to top of Competencies    Go to top of Outline