Effective Database Design

1h 3m 56s
English
Paid

Course description

Before I tell you everything about this program, let’s make sure it’s right for you. If you are:

  • A data analyst who occasionally creates tables for their work
  • A developer or database professional creating or designing tables for an application or system
  • A software developer working with a database and wanting to create an optimal structure that meets your requirements

You are in the right place!

The course "Effective Database Design" will provide you with a roadmap, examples, and instructions for creating a well-designed database.

Read more about the course

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.

Watch Online

Join premium to watch
Go to premium
# Title Duration
1 Welcome 01:18
2 Your Requirements 03:03
3 Creating a Diagram 02:46
4 Add Your First Table 04:09
5 Add Attributes 04:17
6 Relate Your Tables 07:48
7 Repeat These Steps 08:49
8 Considerations 05:44
9 Capture Scenarios 03:20
10 Model the Scenarios 06:38
11 Follow a Checklist 03:20
12 Create a Table 04:11
13 Write All Statements 02:54
14 Add Some Data 03:25
15 View Your Data 01:27
16 Conclusion 00:47

Books

Read Book Effective Database Design

#Title
1Table Assessment Guide
2Common Database Design Solutions
3Effective Database Design

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

PostgreSQL Fundamentals

PostgreSQL Fundamentals

Sources: bigmachine.io
You will learn the basics of SQL and work with databases using PostgreSQL as an example - and you will truly enjoy it! We will work with a real dataset...
2 hours 5 minutes 18 seconds
Learn Database Design with MySQL

Learn Database Design with MySQL

Sources: oreillymedia
Good course for starting up & covers quickly the important topics and shows for beginners what MySQL can be used for. Database design is one of the most importa
6 hours 14 minutes 51 seconds
The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

Sources: udemy
If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but compreh...
36 hours 35 minutes 57 seconds
Fundamentals of Database Engineering

Fundamentals of Database Engineering

Sources: udemy
Database Engineering is a very interesting sector in software engineering. If you are interested in learning about database engineering you have come to the rig
26 hours 2 minutes 59 seconds