|
Course Development Guide |
|
May 1, 2008
Course Title
Database Design and Programming
Course Description
The students will apply data modeling concepts as they 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. |
Business, Marketing and IT Core |
Knowledge and Skills
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
Accountability Measures, Assessments, or Evaluation Procedures
(Select from the following)
Oracle Database Administrator Certified Associate
CIW Database Specialist
Microsoft SQL Server (required core exam)
Brainbench (Select 1)
-
SQL (ANSI)
- RDBMS Concepts
Industry Alignments
(Select from the following)
CIW – Certified Internet Web Professional – http://www.ciwcertified.com/
Oracle – http://www.oracle.com/
Microsoft – http://www.microsoft.com/learning/
Brainbench – http://www.brainbench.com
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
This Course Found In These Career Majors
Cluster: Information Technology
Pathway: Interactive Media
Career Major:
Webmaster
Career Major:
Web Administrator
Career Major:
Web Developer
Career Major:
E-Commerce Designer
Pathway: Programming and Software Development
Career Major:
Database Programmer
Pathway: Information Support and Services
Career Major:
Database Developer
Career Major:
Database Administrator
Career Major:
Database Associate