Maricopa Community Colleges  MST244   20004-20015 
Official Course Description: MCCCD Approval: 05/23/00
MST244 20004-20015 L+L 3 Credit(s) 4 Period(s)
Microsoft Structured Query Language (SQL) Server Level I
Knowledge and skills required to install, configure, and administer Microsoft Structured Query Language (SQL) server. Preparation for Microsoft certification examination. Prerequisites: MST150, or MST152, 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:
 
MST244   20004-20015 Microsoft Structured Query Language (SQL) Server Level I
1. Analyze system architecture. (I)
2. Manage databases and transaction logs. (II)
3. Format, calculate, and manipulate query results. (III)
4. Design data integrity. (IV)
5. Compare the advantages and disadvantages of using indexes. (V)
6. Modify data through views. (VI)
7. Execute Structured Query Language (SQL) Server programming features. (VII)
8. Implement stored procedures and triggers. (VIII)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
MST244   20004-20015 Microsoft Structured Query Language (SQL) 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