Effective Database Design

By the end of this program, you will receive:

• A good understanding of the "entity-relationship" diagram: Learn to create such a diagram for database design using a course example or your own database.
• A database project based on your requirements: Create a database following good practices and techniques.
• Validation of your project: Learn how to validate your project for different scenarios and make changes if necessary.
• Conversion of the project into SQL queries: Learn to write SQL queries to create tables based on your project to start working with the database.

What's inside the course "Effective Database Design":

• Module 1: Introduction
  • You will learn how to determine database requirements and create an "entity-relationship" diagram.
• Module 2: Database Design
  • Translate requirements into a database project: add tables, attributes, and establish relationships between tables.
• Module 3: Project Testing
  • Verify the project by creating scenarios and analyzing their compliance with the requirements.
• Module 4: SQL Conversion
  • Use the project to create an SQL script for table creation and data insertion.