Design the Logical Model of Your Relational Database

Course
en
English
4 h
This content is rated 0 out of 5
Source
  • From openclassrooms.com
Conditions
  • Self-paced
  • Free Access
  • Fee-based Certificate
More info
  • 2 Sequences
  • Introductive Level

Their employees are learning daily with Edflex

  • Safran
  • Air France
  • TotalEnergies
  • Generali
Learn more

Course details

Syllabus

Part 1 - What Is a Relational Database?
1. Get the Most Out of This Course
2. Compare Relational and NoSQL Databases
3. Make Use of a Database Management System (DBMS)
4. Choose the Right Data Type
Quiz: Identify the Basics of Relational Databases

Part 2 - Design your logical model
1. Connect Your Data With a Relational Data Model
2. Identify Database Integrity Constraints
3. Build a Solid Database Foundation Through Normalization
4. Normalize to the First, Second, and Third Normal Forms
5. Put it all Together
6. Get some practice by designing an ERD
Quiz: Check What You've Learned About Structuring a Relational Database!

Certificate

Prerequisite

None.

Instructors

Victor Wilkinson
Software developer and adjunct instructor currently working on a VB6 to VB.NET software conversion for FBE Associates.

Editor

OpenClassrooms (formerly Le site du Zéro or SdZ) is a website that offers courses about computer science and entrepreneurship. Online courses can be made both by site staff, professors of universities or colleges partner as by its members.

Today, courses are available in several formats: MOOC (Massive Open Online Course), web text, e-book, book and video. The company delivers certifications for certain courses, including one recognized by the state in partnership with IESA multimedia.

Platform

OpenClassrooms (formerly Le site du Zéro or SdZ) is a website that offers courses about computer science and entrepreneurship. Online courses can be made both by site staff, professors of universities or colleges partner as by its members.

Today, courses are available in several formats: MOOC (Massive Open Online Course), web text, e-book, book and video. The company delivers certifications for certain courses, including one recognized by the state in partnership with IESA multimedia.

This content is rated 4.5 out of 5
(no review)
This content is rated 4.5 out of 5
(no review)
Complete this resource to write a review