40 days to design and create a small oracle database

Welcome To Our Relational Database Concepts And Data Modeling Class!

This course provides the foundation you need for a career in oracle database administration.

In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy.

As you develop these skills, you will use Oracle to execute SQL statements and a database diagramming tool such as the ER Assistant or SQL developer data modeler to create ERDs.

 

 

Start Here

Week 1: Intro To Relational Databases

Week 2: Data Modelling Using The Entity Relational (ER) Model

Week 3: Normalization

Week 4: Creating Your Oracle Database

Week 5: Tools You Will Use

Week 6: Query Formulation And DDL Statements

ERD Conversion And Refinement Process

Final Hands-On Lab Project

Bonus