|
Official Course
Description: MCCCD Approval: 6-26-1990 |
|||||
|
BPC117BH
1990 Fall – 2011 Summer II |
L+L
1.0 Credit(s) 1.0 Period(s) 1.0 Load Occ |
||||
|
Database
Management: Focus - Level II |
|||||
|
Exploration
of additional components of the Focus database management program. Prerequisites: BPC117AH or CIS117AH or
permission of Instructor. |
|||||
|
Cross-References:
CIS117BH
|
|||||
Go to Competencies Go to Outline
|
MCCCD
Official Course Competencies: |
|
|
|
|
|
BPC117BH 1990
Fall – 2011 Summer II |
Database Management: Focus - Level II |
|
1.
|
Use a full complement of additional database commands and
selection tools. (I) |
|
2.
|
Access multiple files simultaneously (as supported by
specific database software.) (II) |
|
3.
|
Compose varied numerical, character, data, and logical
expressions. (III) |
|
4.
|
Present database files and their records in various
organized ways (alphabetic, numerical, by date, etc.) (IV) |
Go to Description Go to top of
Competencies
|
MCCCD
Official Course Outline: |
|
|
|
|
|
BPC117BH 1990
Fall – 2011 Summer II |
Database Management: Focus - Level II |
|
I. Additional commands and
selections II. Accessing multiple
files III. Creating varied
expressions A. Mathematical
computations B. String manipulation C. Dates and their uses D. Logical operators E. Sums, averages, counts,
and other statistics F. Functions IV. Reordering the database
A. Permanent reorganization
(sorting, etc.) B. Indexing 1. Simple indexes 2. Compound indexes C. Filtering |