Course: CIS276DC First Term: 2018 Fall
Final Term: Current
Final Term: 2019 Summer
|
Lec + Lab 3 Credit(s) 4 Period(s) 4 Load
Credit(s) Period(s)
Load
Subject Type: OccupationalLoad Formula: T |
MCCCD Official Course Competencies | |||
---|---|---|---|
1. Demonstrate an understanding of data analysis involved in relational databases. (I)
2. Develop an Entity Relationship Diagram (ERD) to optimize a database`s design. (I) 3. Demonstrate an understanding of database server installation and configuration. (II) 4. Demonstrate the ability to use SQL and the client interface tools. (III, IV, V) 5. Demonstrate the ability to add/manage users and authentication. (IV) 6. Create database objects. (IV, V) 7. Create a new Oracle database. (VI) 8. Implement a backup/restore strategy. (VI) | |||
MCCCD Official Course Competencies must be coordinated with the content outline so that each major point in the outline serves one or more competencies. MCCCD faculty retains authority in determining the pedagogical approach, methodology, content sequencing, and assessment metrics for student work. Please see individual course syllabi for additional information, including specific course requirements. | |||
MCCCD Official Course Outline | |||
I. Database Architecture
A. Entity identification B. Model relationships and identify attributes C. Normalization D. Primary and foreign keys E. Table structure F. Data types II. Installation A. System requirements B. Preparation for installation of database management system software C. Preparation for installation of client software III. Using SQL A. Retrieving data 1. Select 2. From 3. Where 4. Order by 5. Joining tables B. Summarizing data 1. Aggregate functions 2. Group by 3. Having C. Subqueries D. Data manipulation 1. Inserting 2. Updating 3. Deleting 4. Transactions IV. Creating and Managing Database Objects A. Tables B. Sequences C. Constraints D. Indexes E. Views F. User and role management 1. Create users and roles 2. Granting privileges to users and roles V. Introduction to Programming A. Language structure B. Using variables C. Controlling program flow D. Creating and managing stored procedures, functions and triggers VI. Database Administration A. Authentication and encryption B. Starting and stopping the database management system software C. Creating and removing a database 1. Physical implementation a. Configuration files b. Data files c. Log files d. Pages 2. Deletion D. Using the Data Dictionary E. Maintaining a database F. Backup and restore | |||
MCCCD Governing Board Approval Date: 2/27/2007 |