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

  Introduction
  Entities and Attributes
  Relationship Basics
  Business Rules
  Relationship Fundamentals
  UIDs and Normalization
  Hierarchies & Recursive Modeling
  Changes and Historical Modeling
  Mapping
  Presenting Database Projects
  Database Programming with SQL
  SELECT and WHERE
  Intro to Functions
  Single Row Functions Part I, II
  JOINs
  Group Functions
  Subqueries
  Ensuring Quality Queries Part I
  Final Project and Exam Review
  Ensuring Quality Queries Part II
 Download detailed table of contents


Hands On Exercises

Course Completion Certificate

Live Project

Certification Exam

Suggested Next Courses


  •    Database Programming with PL/SQL