You are here: Home instructional_framework official_framework Business and Information Technology Education SQL and PL/SQL Database Applications Development
Navigation
Log in


Need a new SSL certificate?
 

View Career Major Course

Course Information
Business and Information Technology Education
BT00041
SQL and PL/SQL Database Applications Development
120.00
The student will be able to use PL/SQL developer strategies to manipulate data.
Carrie DeMuth
405-743-5426
cdemu@okcareertech.org
Fundamentals of Database Development
Create and manage tables.

Create, maintain, and include constraints.

Write control structures.

Work with composite data types.

Understand relational databases, SQL and PL/SQL

Aggregate data using group functions.

Create views.

Create, maintain and use sequences, indexes, and public and private synonyms.

Control user access.

Declare variables.

Write advanced explicit cursors.

Write basic SQL statements.

Restrict and sort data.

Describe single row functions.

Display data from multiple tables.

Write executable statements.

Interact with the Oracle server.

Handle exceptions.

Perform Subqueries and multiple column subqueries.

Produce readable output with iSQL Plus.

Manipulate data.

Create procedures and functions.

Manage subprograms.

Create packages.

Manipulate large objects.

Create database triggers.

Manage dependencies.
(Select from the following)

Oracle Certified Associate (select one):
- Introduction to Oracle SQL
- Oracle Database 11g: Program with PL/SQL
- Program with PL/SQL

Brainbench (select one):
- Oracle PL/SQL
- Oracle PL/SQL Fundamentals
- Programming Concepts
Oracle -
http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D47311&p_org_id=1001&lang=US&source_call=

Brainbench - http://www.brainbench.com/
Oracle Internet Academy, by Oracle

Oracle University - http://education.oracle.com/

Career Cluster Resources for Information Technology -
http://www.careerclusters.org/resources/ClusterDocuments/itdocuments/ITFinal.pdf
Yes
8141
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 Developer
Information Technology Information Support and Services Database Junior Developer
Information Technology Information Support and Services Oracle Database Developer