This course of introduces students to basic relational database concepts. The course teaches students relational database terminology, as well as data modeling concepts, building Entity Relationship Diagrams (ERDs), and mapping ERDs. Oracle SQL Developer Data Modeler is utilized to build ERDs and The Structured Query Language (SQL) is used to interact with a relational database and manipulate date within the database. Oracle Application Express is utilized to provide practical, hands-on, engaging activities. Leveraging project-based learning techniques, students will create and work with projects which challenge them to design, implement, and demonstrate a database solution for a business or organization.

Course Duration : 90 hours

Prerequisites | Required

  •   General knowledge of the purpose of a database

Prerequisites | Suggested

  •   Previous experience with a database application

  Introduction to Databases
  Databases and Data Modeling
  Creating a Physical Model
  Oracle SQL Developer Data Modeler
  Mapping the Physical Model
  Exception Handling
  Introduction to SQL
  Final Project

Hands On Exercises

Course Completion Certificate

Live Project

Certification Exam

Suggested Next Courses

  •    Database Design and Programming with SQL