You are here: Home instructional_framework official_framework Business and Information Technology Education Fundamentals of Database Development
Navigation
Log in


Need a new SSL certificate?
 

View Career Major Course

Course Information
Business and Information Technology Education
BT00040
Fundamentals of Database Development
120.00
The student will develop an understanding of data modeling concepts as they create relational databases and use SQL to manipulate data.
Carrie DeMuth
405-743-5426
cdemu@okcareertech.org
Business and Computer Technology OR Fundamentals of Technology
Develop a logical model using business requirements.

Identify entities, attributes, and relationships.

Identify primary, foreign, and artificial keys.

Normalize a database model.

Implement a logical model into a physical database using SQL.

Run a query.

Create a table.

Select data.

Join tables.

Create permissions.

Enter, manipulate, and analyze data.

Create views.

Use scripting & database knowledge to implement a data-driven website.

Plan a website and list technical requirements.

Build a database and list requirements needed.

Perform website analysis.

Manipulate data elements

Manage, analyze, and report on interrelated elements.

Implement queries and reports to provide access to critical system information.

Descript relational and object relational database designs.

Retrieve data using the SQL SELECT statement.

Use Arithmetic and Concatenation operators in SQL statements.

Restrict and sort data.

Use single row functions to customize reports.

Report aggregated data using the group functions.

Display data from multiple tables.

Use Sub queries to solve queries.

Use the SET operators

Use DDL statements to create and manage tables.

Create Schema objects.

Manage objects with Data Dictionary views.

Control user access.

Manage Schema objects and large data sets.

Generate reports by grouping related data.

Manage data in different time zones.

Search data using advanced Sub queries.
(Select from the following)

Oracle Certified Associate

Microsoft SQL Server 2000 Administration
- Core Exam

Brainbench: (Select one)
- RDBMS Concepts
- MS Access
- Database Marketing
Oracle University - http://education.oracle.com/

Brainbench - http://www.brainbench.com/

Microsoft - http://www.microsoft.com/learning/
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
8139
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 Information Support and Services Oracle Database Developer