PROSPECTIVE STUDENTS CURRENT STUDENTS NONCREDIT STUDENTS PARENTS ALUMNI & DONORS FACULTY & STAFF COMMUNITY & BUSINESS
   APPLY NOW ABOUT MT. SAC ACADEMIC PROGRAMS RESOURCES & SERVICES ATHLETICS LIBRARY MY MTSAC MT. SAC HOME
   
 
 
CISD - Database Courses
 
   
 

 
Computer Information Systems (CIS) Course Categories:
CISB - Beginning CISM - Management CISS - Security
CISD - Database CISN - Networking CISW - Web Development
CISI - Input Processing CISP - Programming CISX - Auxiliary
  • CISD - Database Courses:      
  • CISD 11
  • CISD 14
  • CISD 21
  • CISD 31
  • CISD 32
  • CISD 40
Database Courses Banner Image
The CIS department offers these six 'Database' Courses:
  • CISD 11 - Database Management - Microsoft Access
  • CISD 14 - Advanced Database Management - Microsoft Access
  • CISD 21 - Database Management - Microsoft SQL Server
  • CISD 31 - Database Management - Oracle
  • CISD 32 - Oracle Forms and Reports
  • CISD 40 - Database Design
Click on any of the tab links above to view detailed information about a course.

Send questions or comments about this Web site to the  CIS Department's  Web Content Manager .
Use of this Web server is subject to the Mt. San Antonio College Terms of Use  and  Privacy Policy .
CISD 11 Course Image

CISD 11 - Database Management
                - Microsoft Access
                (4.0 units)
This course covers the design, creation and management of relational databases using Microsoft's Access or similar Database Management System (DBMS).   The student receives extensive hands-on instruction on a Windows-based personal computer.

Topics covered include:
  • basic database design
  • creation of tables, queries, forms, reports, data access pages, & macros
  • creation of Custom Graphical User Interface using the Switchboard Manager
       and VBA code
(54 hours lecture;  54 hours lab;  Degree appropriate, CSU)
Advisory Prerequisite:   CISB 11 - Computer Information Systems
                                    or  CISB 15 - Microcomputer Applications   or COMP 12 )

Course Measurable Objectives:

  1. Manage database tables using queries, forms, reports, data access pages, and macros.
  2. Analyze the data needs of an organization and design appropriate objects to solve specific problems.
  3. Develop and use a set of standards that will make applications consistent, easy to use and maintain.
  4. Define principles of Normalization and be able to recongize proper database design.
  5. Create a custom user interface that will make using the database easy, efficient, and attractive.
  6. Recognize proper programming syntax; be able to write simple VBA code to expand the functionality of the database.

Course Level Student Learning Outcomes:


Students completing CISD 11 - Database Management - Microsoft Access will be able to:
  1. use Microsoft Access to create a professional and user-friendly working database with little or no assistance.
  2. create effective queries that answer needed questions.
  3. create effective reports based on criteria given.
  4. create useful and professional-looking mainform/subforms using Access
Send questions or comments about this Web site to the  CIS Department's  Web Content Manager .
Use of this Web server is subject to the Mt. San Antonio College Terms of Use  and  Privacy Policy .
CISD 14 Course Image

CISD 14 - Advanced
                Database Management
                - Microsoft Access
                (4.0 units)
The student taking this course will learn advanced Access programming techniques using the Visual Basic language.  The student receives extensive hands-on instruction on a Windows-based personal computer.  Topics covered include:
  • arrays & VB Structures
  • access object model
  • DAO object model
  • ADO object model
  • event-driven programming
  • error handling
  • multi-user applications & transaction processing
  • client/server, and security issues
(54 hours lecture;  54 hours lab)
Advisory Prerequisite:   CISD 11 - Database Management - Microsoft Access
                                    or  CISP 11 - Programming in Visual Basic

Course Measurable Objectives:

  1. Analyze a business problem and produce an appropriate application design.
  2. Apply appropriate Visual Basic for applications code to add functionality to database.
  3. Use appropriate SQL statements in VBA code to create and run ad hoc queries.
  4. Integrate appropriate error handling routines to catch potential problems.
  5. Solve problems using Access Objects in collections utilizing an object-based approach.
  6. Identify multi-user and security issues in maintaining a DBMS.

Course Level Student Learning Outcomes:


Students completing CISD 14 - Advanced Database Management - Microsoft Access will:
  1. be able to apply appropriate Visual Basic for Applications code (VBA) to update Access table data.
  2. use embedded SQL statements within VBA procedures to create and run ad hoc queries for users.
Send questions or comments about this Web site to the  CIS Department's  Web Content Manager .
Use of this Web server is subject to the Mt. San Antonio College Terms of Use  and  Privacy Policy .
CISD 21 Course Image

CISD 21 - Database Management
                - Microsoft SQL Server
                  (4.0 units)
This course provides comprehensive instruction in the Structured Query Language (SQL) and transact-SQL for Microsoft's SQL Server users.  Students design a database, create database objects, view and update data, define cursors, develop program units, manage transations, and handle database security.

The student receives extensive hands-on instruction on a Windows-based personal computer.

(54 hours lecture;  54 hours lab  Degree appropriate)
Advisory Prerequisite:   CISB 11 - Computer Information Systems
                                    or  CISB 15 - Microcomputer Applications

Course Measurable Objectives:

  1. Review data from single and multiple tables.
  2. Insert, update and delete data from database.
  3. Create database objects such as views.
  4. Design, create, and maintain database.
  5. Create cursors and stored program units.
  6. Manage transactions and database security.

Course Level Student Learning Outcomes:


Students completing CISD 21 - Database Management - Microsoft SQL Server will be able to:
  1. update database data using the SQL Server Data Manipulation Language commands.
  2. create a program using scripts and stored procedures.
Send questions or comments about this Web site to the  CIS Department's  Web Content Manager .
Use of this Web server is subject to the Mt. San Antonio College Terms of Use  and  Privacy Policy .
CISD 31 Course Image

CISD 31 - Database Management
                - Oracle   (4.0 units)
This course covers Oracle databse functions, concepts, and terms.  PL/SQL is used to code, test, and implement stored procedures, functions, triggers, and packages. Relational database projects will be built using PL/SQL.

The student receives extensive hands-on instruction on a Windows-based personal computer.

(54 hours lecture;  54 hours lab  Degree appropriate)
Advisory Prerequisite:   CISB 11 - Computer Information Systems

Course Measurable Objectives:

  1. Analyze business problems using relational databases.
  2. Describe Oracle database functions and commands.
  3. Write, test, and implement complex queries and subqueries to retrieve data from multiple tables.
  4. Design PL/SQL program to access database data using cursors with exception handling.
  5. Develop (write, test, and implement) stored procedures, functions, triggers, and packages using PL/SQL.

Course Level Student Learning Outcomes:


Students completing CISD 31 - Database Management - Oracle will be able to:
  1. create queries to retrieve data from multiple tables using Oracle functions, views, and scripts.
  2. use decision making statements, loops, and cursors in order to create a business application.
Send questions or comments about this Web site to the  CIS Department's  Web Content Manager .
Use of this Web server is subject to the Mt. San Antonio College Terms of Use  and  Privacy Policy .
CISD 32 Course Image

CISD 32 - Oracle Forms &
                Reports   (3.0 units)
This course covers the design, creation and implementation of interactive single forms with multiple canvases.  The student will learn how to create multiple forms and reports using PL/SQL triggers, the Object Navigator, and Oracle's Form & Report Builders.  Reports and interactive forms will use single and multiple tables in a realistic business setting.

The student receives extensive hands-on instruction on a Windows-based personal computer.

(54 hours lecture;  54 hours lab  Degree appropriate)
Advisory Prerequisite:   CISD 31 - Database Management - Oracle

Course Measurable Objectives:

  1. Analyze business problems and design appropriate Oracle interactive forms and reports.
  2. Analyze business forms and design appropriate Oracle forms and report functions and commands.
  3. Write Oracle PL/SQL trigger functions for client and database servers.
  4. Develop, write, test, debug and implement a complete Oracle Forms and Report application with PL/SQL triggers on the client and server database.
  5. Organize, classify and write Oracle application documentation.

Course Level Student Learning Outcomes:


Students completing CISD 32 - Oracle Forms and Reports will be able to:
  1. explain the differences between a Data Block form and a Control Block form.
  2. determine when to issue an Alert as opposed to a Custom Message to the user.
Send questions or comments about this Web site to the  CIS Department's  Web Content Manager .
Use of this Web server is subject to the Mt. San Antonio College Terms of Use  and  Privacy Policy .
CISD 40 Course Image

CISD 40 - Database Design
                (3.0 units)
In this course, students will:
  • analyze database needs and functions
  • create data models
  • create Entity-Relationship (E-R) diagrams
  • create UML diagrams
  • use normalization rules and principles to create properly-designed databases
  • learn basic DBA objectives and tasks
The student receives extensive hands-on instruction on a Windows-based personal computer.

(54 hours lecture;   Degree appropriate, CSU)
Advisory Prerequisite:   CISD 11 - Database Management - Microsoft Access

Course Measurable Objectives:

  1. Understand the functions of database application.
  2. Learn to apply normalization techniques to a database.
  3. Create and properly interpret both UML and E-R diagrams.
  4. Transform E-R and UML diagrams into relational designs.
  5. Evaluate the need for security and use specific techniques in securing a database.

Course Level Student Learning Outcomes:


Students completing CISD 40 - Database Design will be able to:
  1. apply normalization rules to database design.
  2. create E-R (Entity Relationship) and UML (Unified Modeling Language) diagrams for a given database scenario.
Send questions or comments about this Web site to the  CIS Department's  Web Content Manager .
Use of this Web server is subject to the Mt. San Antonio College Terms of Use  and  Privacy Policy .
 
.