Maricopa Community Colleges  CIS275CG   19994-20036 
Official Course Description: MCCCD Approval: 03/23/99
CIS275CG 19994-20036 L+L 3 Credit(s) 4 Period(s)
Microsoft Structured Query Language Server Level I
Knowledge and skills required to install, configure, and administer Microsoft (MS) Structured Query Language (SQL) server. Covers databases, indexes, views, stored procedures, and triggers. System architecture and programming features also covered. Prerequisites: CIS192 or permission of instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS275CG   19994-20036 Microsoft Structured Query Language Server Level I
1. Install and configure an Structured Query Language (SQL) Server. (I)
2. Analyze system architecture. (I)
3. Manage databases and transaction logs. (II)
4. Format, calculate, and manipulate query results. (III)
5. Design data integrity. (IV)
6. Compare the advantages and disadvantages of using indexes. (V)
7. Modify data through views. (VI)
8. Execute SQL Server programming features. (VII)
9. Implement stored procedures and triggers. (VIII)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS275CG   19994-20036 Microsoft Structured Query Language Server Level I
    I. Structured Query Language (SQL) Server Overview
        A. SQL Server administrative tools
        B. Relational database elements
        C. Installing and configuring SQL Server
        D. System architecture
      II. Managing Databases
          A. Types of database devices
          B. Creating and dropping databases
          C. Modifying databases and transaction logs
        III. Transact SQL Querying
            A. Retrieving data from a table
            B. Formatting, calculating, and manipulating query results
            C. Adding, updating, and deleting data
            D. Using subqueries
          IV. Designing Data Integrity
              A. Types of data integrity
              B. Using constraints to enforce data integrity
              C. Creating and querying identity columns
              D. Using defaults and rules to enforce data integrity
            V. Indexes
                A. Advantages and disadvantages of using indexes
                B. Types of indexes
                C. Maintaining indexes
              VI. Views
                  A. Creating and dropping views
                  B. View options
                  C. Modifying data through views
                  D. Altering and dropping the underlying tables
                VII. SQL Server Programming Features
                    A. Executing batches
                    B. Creating branching and looping queries
                    C. Ensuring database consistency and concurrency
                  VIII. Stored Procedures and Triggers
                      A. Creating and executing stored procedures
                      B. Creating and nesting triggers
                      C. Enforcing data integrity
                  Go to Description    Go to top of Competencies    Go to top of Outline