Oracle Database Concepts & Design Fundamentals

Oracle Database Concepts & Design Fundamentals

This course gives students the design tools necessary to create effective and efficient databases.  Both logical and physical design is covered.  Various database management systems are studied. 

Course Outline

Database Systems

  • Explain difference between data and information
  • Explain the importance of database design
  • Explain the role, advantages, and types of databases
  • Explain history of file system data processing
  • Explain problems with file system data processing
  • Explain database systems including environment, functions, and management

Data Models

  • Explain data modeling and data models
  • Explain the importance of data models
  • List and explain the basic building blocks of data models
  • Explain how business rules evolve into data model components
  • List and explain various data models including hierarchical, relational, entity relationship, object-oriented, object/relational, and XML
  • List and explain the degrees of data abstraction including external, conceptual, internal, and physical model

Relational Database Model

  • Explain the logical view of data
  • Explain the role of keys
  • Explain integrity rules
  • List and explain relational set operators
  • Explain the role of the data dictionary and the system catalog
  • List and explain the 1:M, 1:1, M:N relationships
  • Explain data redundancy
  • Explain the role of indexes
  • Design a database/tables using keys, relationships, avoiding data redundancy, and indexes.

Entity Relationship Modeling

  • List and explain all the entities in the entity relationship model (ERM)
  • Develop an entity relationship diagram
  • Explain database design challenges

 

Course Enquiry