You are here: Home instructional_framework official_framework Business and Information Technology Education Database Design and Programming
Navigation
Log in


Need a new SSL certificate?
 

View Career Major Course

Course Information
Business and Information Technology Education
BT00127
Database Design and Programming
120.00
The students will apply data modeling concepts as they develop and perform relational database queries using SQL concepts.
Carrie DeMuth
405-743-5426
cdemu@okcareertech.org
Business and Computer Technology OR Fundamentals of Technology
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
(Select from the following)

Oracle Certified Associate (select one):
- Introduction to Oracle SQL
- Oracle Database SQL Expert
- Oracle Database SQL Fundamentals I

CIW Database Specialist

Microsoft SQL Server (core exam)

Brainbench (Select one)
- SQL (ANSI) Fundamentals
- SQL (ANSI)
- Data Modeling Concepts
(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
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
Yes
8140
Yes
Yes
Yes
Career Majors That Sequence This Course
Career Cluster Pathway Career Major
Information Technology Information Support and Services Database Administrator
Information Technology Information Support and Services Database Associate
Information Technology Information Support and Services Database Business Analyst
Information Technology Information Support and Services Database Developer
Information Technology Information Support and Services Database Junior Developer
Information Technology Programming and Software Development Database Programmer
Information Technology Web and Digital Communications E-Commerce Designer
Information Technology Network Systems Network Systems and Data Communications Analyst
Information Technology Information Support and Services Oracle Database Developer
Information Technology Web and Digital Communications Web Developer
Information Technology Web and Digital Communications Webmaster