Course Title

Fundamentals of Database Development

Course Description

The student will develop an understanding of data modeling concepts as they create 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.
• 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.

Accountability Measures, Assessments, or Evaluation Procedures

(Select from the following)

Oracle Database Administrator Certified Associate

Microsoft SQL Server 2000 Administration

• Core Exam
  

Brainbench:  (Select 1)

• Database Marketing
• Data Modeling Concepts
• SQL (ANSI) Fundamentals
  

Industry Alignments

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

Brainbench – http://www.brainbench.com

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

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