Maricopa Community Colleges  CIS175EA   20014-20035 
Official Course Description: MCCCD Approval: 05/22/01
CIS175EA 20014-20035 L+L 1 Credit(s) 2 Period(s)
Introduction to Structured Query Language
Introduction to Structured Query Language. Focuses on the query operation, including data collection, grouping and multi-table queries. Prerequisites: None.
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS175EA   20014-20035 Introduction to Structured Query Language
1. Explain the relationship between a database and Structured Query Language (SQL). (I, II)
2. Write and execute basic SQL statements. (II)
3. Write and execute SQL queries. (II)
4. Demonstrate data collection procedures. (II, III)
5. Create specific search conditions. (II-IV)
6. Demonstrate procedures for querying information from specific rows. (III, IV)
7. Identify data grouping techniques. (V)
8. Use aggregate and non-aggregate functions simultaneously. (V)
9. Demonstrate procedures for selecting information from two or more tables. (VI)
10. Explain procedures for using Access. (VII)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS175EA   20014-20035 Introduction to Structured Query Language
    I. Databases
        A. Terms
        B. Concepts
          1. Design
          2. Content
        C. Types
          1. Single Table
          2. Relational
          3. Other
        D. Query Editor
      II. Structured Query Language (SQL)
          A. Concepts
          B. Language
            1. Data Manipulation
            2. Data Definition
            3. Data Control
          C. Statements
          D. Server Query Analyzer
          E. SELECT Statement
            1. Definition
            2. Use
            3. Clauses
            4. Syntax Rules
            5. Procedures
          F. Data Collection
            1. Aggregate Function
            2. Column Aliases
            3. Calculations
            4. Date Functions
        III. Specific Rows
            A. WHERE Clause
              1. Use
              2. Procedures
              3. Flexibility
            B. ORDER BY Clause
              1. Use
              2. Procedures
              3. Output Arrangement
          IV. Operators
              A. Text Search
                1. Character String
                2. Procedures
                3. LIKE Keyword
              B. Logical Operators
                1. AND Operator
                2. OR Operator
              C. Keywords
                1. IN
                2. BETWEEN
                3. BETWEEN/AND
                4. NOT
              D. NULL Value
            V. Data Grouping
                A. Aggregate Functions
                B. Non-Aggregate Functions
                C. Clauses
                  1. GROUP BY
                  2. HAVING
                  3. WHERE
                D. Super-Aggregate
                E. CUBE Operator
                F. Row Selection
                G. Limitations
              VI. Multi-Table Queries
                  A. Joins
                    1. Definition
                    2. Types
                    3. Use
                    4. Tables
                  B. Procedures
                    1. Two-Table
                    2. Table Name Aliases
                    3. Three-Table Join
                    4. Outer Join
                  C. Execution
                VII. Access
                    A. Connection
                    B. Database
                      1. Blank
                      2. Query
                    C. Data Source Name (DSN)
                    D. Query Execution
                    E. Report
                      1. Types
                      2. Procedures
                      3. Tables
                Go to Description    Go to top of Competencies    Go to top of Outline