Maricopa Community Colleges  MST254   20026-20045 
Official Course Description: MCCCD Approval: 05/28/02
MST254 20026-20045 L+L 3 Credit(s) 4 Period(s)
Microsoft SQL Server Design and Implementation
Knowledge and skills required to design and implement databases using Microsoft SQL server. Preparation for Microsoft certification examination. Prerequisites: Any MST152 course, or MST170, or permission of instructor.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
MST254   20026-20045 Microsoft SQL Server Design and Implementation
1. Develop a logical data model. (I)
2. Create a SQL Server database. (II)
3. Retrieve and modify data. (III)
4. Manipulate data using database objects. (IV)
5. Create and implement tuning and optimization strategies. (V)
6. Design a database security plan. (VI)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
MST254   20026-20045 Microsoft SQL Server Design and Implementation
    I. Database Design
        A. Database components
        B. Planning
        C. System requirements
        D. Logical data model
      II. Databases and Tables
          A. Database considerations
          B. Database objects
          C. Growth strategies
          D. Table characteristics
        III. Data Management
            A. Retrieve
            B. Modify
            C. Filter
            D. Summarize
            E. Output format
          IV. Business Logic Enforcement
              A. User-defined functions
              B. Stored procedures
              C. Transactions
              D. Triggers
              E. Views
            V. Data Access
                A. Transactions
                B. Locks
                C. Query processor operations
                D. Optimization
                E. Indexing strategies
              VI. Database Security
                  A. Physical security
                  B. Network protocol security
                  C. Domain security
                  D. Local computer security
                  E. SQL Server security
              Go to Description    Go to top of Competencies    Go to top of Outline