Course Title

Fundamentals of Database Development

Course Description

The student will be learn to develop relational databases and use SQL to manipulate data.

Contact

Carrie DeMuth
405-743-5426
cdemu@okcareertech.org

Knowledge and Skills

• 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.
• Analyze and manipulate data.
• Create views.
• Use their scripting & database knowledge to implement a data-driven Web site.
• Plan a Web site.
• List technical requirements of the Web site.
• List requirements needed for database.
• Build a database.
• Enter and manipulate data.
• Perform Web site 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.

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

Accountability Measures, Assessments, or Evaluation Procedures

Oracle - http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D47311&p_org_id=1001&lang=US&source_call=

Microsoft - http://www.microsoft.com/learning/

Brainbench - http://www.okcareertech.org/certify

Industry Alignments

(Select from the following)

Oracle Database Administrator Certified Associate

• Core Exam: SQL Server Administration
  

Brainbench:   (2 exams required)

• RDBMS 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

This Course Found In These Career Majors