Maricopa Community Colleges  CIS275CK   20002-20036 
Official Course Description: MCCCD Approval: 11/23/99
CIS275CK 20002-20036 L+L 2 Credit(s) 3 Period(s)
Microsoft Structured Query Language Server Upgrade and Migration
Upgrade Structured Query Language (SQL) Server. Overview of architectural changes, administrative functions changes, and server components. Migrating data and databases also covered. Prerequisites: Permission of instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS275CK   20002-20036 Microsoft Structured Query Language Server Upgrade and Migration
1. Explain the changes and design goals of the new Structured Query Language (SQL) Server. (I)
2. Install and configure the upgraded SQL server. (I, II)
3. Summarize the architectural changes to the SQL server. (II)
4. Retrieve information using information schema views and system function. (III)
5. Summarize changes to the administrative functions. (IV)
6. Use administrative tools. (IV)
7. Upgrade a SQL Server. (I-V)
8. Troubleshoot a database upgrade. (IV, V)
9. Summarize SQL server components. (VI)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS275CK   20002-20036 Microsoft Structured Query Language Server Upgrade and Migration
    I. Changes to Structured Query Language (SQL) Server
        A. Performance
        B. Scalability
        C. Data Warehousing Capabilities
        D. Databases
        E. Installation and Configuration
          1. Hardware Requirements
          2. Software Requirements
          3. Options
      II. SQL Server Architecture
          A. Security
          B. Storage
          C. Memory Management
          D. Index
          E. Query Processing
        III. Transact-SQL
            A. Object Information
              1. Accessing
              2. Changes
            B. Syntax
            C. Distributed Queries
          IV. Administrative Functions
              A. Backup
              B. Restore
              C. Task Automation
              D. Data Transfer
              E. Monitor and Tune Performance
              F. Replication
            V. Upgrading SQL Server
                A. Planning
                B. Verifying
              VI. Components
                  A. Search Service
                  B. Query
                  C. On-line Analytical Processing (OLAP) Services
              Go to Description    Go to top of Competencies    Go to top of Outline