|
Course Development Guide |
|
October 1, 2007
Course Title
Database Design and Programming
Course Description
The students will apply data modeling concepts, including attributes and keys; entities; implementation and model notations; normalization; relationships; and uses and benefits. Students will also develop and perform relational database queries using SQL concepts.
Contact
Carrie DeMuth
405-743-5426
cdemu@okcareertech.org
| OCAS Codes | OHLAP Credit | Course Length | Prerequisites |
|---|---|---|---|
|
8507
|
Yes |
120 Hours
120 hours is based on a Carnegie unit, which accounts for 175 forty-five (45) minute class periods per school year. |
Web Scripting Foundations or Fundamentals of Database Development desired, but not required |
Knowledge and Skills
Data Modeling Concepts:
-
Attributes and keys
-
Implementation and model notations
-
Entities
-
Normalization
-
Relationships
-
Uses and benefits
SQL (ANSI):
-
SQL queries
-
SQL data definition (DDL)
-
SQL data modification
-
Relational database and SQL basics
-
Advanced grouping and totaling
-
Advanced SQL queries
-
Using SQL DML
Brainbench - http://www.brainbench.com
Accountability Measures, Assessments, or Evaluation Procedures
(Select from the following)
Brainbench - http://www.okcareertech.org/certify
CIW - Certified Internet Web Professional - http://www.ciwcertified.com/
Oracle - http://www.oracle.com/
Microsoft - http://www.microsoft.com/learning/
Industry Alignments
(Select from the following)
Oracle Database Administrator Certified Associate
CIW Database Specialist
Microsoft SQL Server 2000 Certification (required core exams)
Brainbench (2 exams required)
-
Data Modeling Concepts
-
SQL (ANSI)
Curriculum Resources
-
Oracle Internet Academy, by Oracle
-
Concepts of Database Management 5th Edition, by Pratt & Adamski
- Career Cluster Resources for Information Technology -http://www.careerclusters.org/resources/ClusterDocuments/itdocuments/ITFinal.pdf