This course engages students to analyze complex business scenarios and create a data model—a conceptual representation of an organization’s information. Participants implement their database design by creating a physical database using SQL. Basic SQL syntax and the rules for constructing valid SQL statements are reviewed. This course culminates with a project that challenges students to design, implement, and demonstrate a database solution for a business or organization.

Course Duration : 180 hours

Prerequisites | Required

  •   Ease with using a computer
  •   General knowledge of databases and query activity

Prerequisites | Suggested

  •   None

  Entities and Attributes
  Relationship Basics
  Business Rules
  Relationship Fundamentals
  UIDs and Normalization
  Hierarchies & Recursive Modeling
  Changes and Historical Modeling
  Presenting Database Projects
  Database Programming with SQL
  Intro to Functions
  Single Row Functions Part I, II
  Group Functions
  Ensuring Quality Queries Part I
  Final Project and Exam Review
  Ensuring Quality Queries Part II

Hands On Exercises

Course Completion Certificate

Live Project

Certification Exam

Suggested Next Courses

  •    Database Programming with PL/SQL