-
CISD - Database Courses:
-
CISD 11
-
CISD 14
-
CISD 21
-
CISD 31
-
CISD 32
-
CISD 40
The Busiess Division through 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 tabbed links above to view a detailed description of any given course and its Student Learning Outcome(s).
|
Send questions or comments about this Web page to the
Business Division's
Web Content Manager
.
Use of this Web server is subject to the Mt. San Antonio College
Terms of Use
and
Privacy Policy
.
|
|
|
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 Level Student Learning Outcomes:
Students completing CISD 11 - Database Management - Microsoft Access will be able to:
- use Microsoft Access to create a professional and user-friendly working database with little or no assistance.
- create effective queries that answer needed questions.
- create effective reports based on criteria given.
- create useful and professional-looking mainform/subforms using Access
|
|
NOTE:
Every effort is made to ensure the accuracy and timeliness of this information; however, students should consult
the
college catalog
for the most current and accurate information regarding degrees,
certificates, or courses.
|
|
|
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 Level Student Learning Outcomes:
Students completing CISD 14 - Advanced Database Management - Microsoft Access will:
- be able to apply appropriate Visual Basic for Applications code (VBA) to update Access table data.
- use embedded SQL statements within VBA procedures to create and run ad hoc queries for users.
|
|
NOTE:
Every effort is made to ensure the accuracy and timeliness of this information; however, students should consult
the
college catalog
for the most current and accurate information regarding degrees,
certificates, or courses.
|
|
|
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 Level Student Learning Outcomes:
Students completing CISD 21 - Database Management - Microsoft SQL Server will be able to:
- update database data using the SQL Server Data Manipulation Language commands.
- create a program using scripts and stored procedures.
|
|
NOTE:
Every effort is made to ensure the accuracy and timeliness of this information; however, students should consult
the
college catalog
for the most current and accurate information regarding degrees,
certificates, or courses.
|
|
|
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 Level Student Learning Outcomes:
Students completing CISD 31 - Database Management - Oracle will be able to:
- create queries to retrieve data from multiple tables using Oracle functions, views, and scripts.
- use decision making statements, loops, and cursors in order to create a business application.
|
|
NOTE:
Every effort is made to ensure the accuracy and timeliness of this information; however, students should consult
the
college catalog
for the most current and accurate information regarding degrees,
certificates, or courses.
|
|
|
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)
|
|
Advisory Prerequisite:
CISD 31 - Database Management - Oracle
|
Course Level Student Learning Outcomes:
Students completing CISD 32 - Oracle Forms and Reports will be able to:
- explain the differences between a Data Block form and a Control Block form.
- determine when to issue an Alert as opposed to a Custom Message to the user.
|
|
NOTE:
Every effort is made to ensure the accuracy and timeliness of this information; however, students should consult
the
college catalog
for the most current and accurate information regarding degrees,
certificates, or courses.
|
|
|
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 Level Student Learning Outcomes:
Students completing CISD 40 - Database Design will be able to:
- apply normalization rules to database design.
- create E-R (Entity Relationship) and UML (Unified Modeling Language) diagrams for a given database scenario.
|
|
NOTE:
Every effort is made to ensure the accuracy and timeliness of this information; however, students should consult
the
college catalog
for the most current and accurate information regarding degrees,
certificates, or courses.
|
|
|
|
ACADEMIC DEPARTMENTS:
ACADEMIC LINKS:
RELATED DIVISION LINKS:
|
|
