Effective Database Design

1h 3m 56s
English
Paid

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 Effective Database Design

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

Read Book Effective Database Design

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

Similar courses to Effective Database Design

SQL - MySQL for Data Analytics and Business Intelligence

SQL - MySQL for Data Analytics and Business Intelligenceudemy

Category: Sql
Duration 9 hours 22 minutes 55 seconds
Apache Flink

Apache Flinkrockthejvm.com

Category: Other (Backend)
Duration 8 hours 31 minutes 38 seconds
Fundamentals of Backend Communications and Protocols

Fundamentals of Backend Communications and Protocolsudemy

Category: Other (Backend)
Duration 15 hours 35 minutes 37 seconds
Make a Google search engine clone: JavaScript PHP and MySQL

Make a Google search engine clone: JavaScript PHP and MySQLudemy

Category: JavaScript, Sql, PHP
Duration 5 hours 47 minutes 11 seconds
Streaming Databases

Streaming Databasesoreillymedia

Category: Other (Backend)
Duration
Complete SQL + Databases Bootcamp: Zero to Mastery

Complete SQL + Databases Bootcamp: Zero to Masteryzerotomastery.io

Category: Sql, Redis
Duration 24 hours 6 minutes 52 seconds
DuckDB - The Ultimate Guide

DuckDB - The Ultimate Guideudemy

Category: Other (Backend)
Duration 5 hours 56 minutes 13 seconds
Clean Code: Writing Code for Humans

Clean Code: Writing Code for Humans pluralsight

Category: Other (Backend), Other (Frontend)
Duration 3 hours 10 minutes 36 seconds
Learn Database Design with MySQL

Learn Database Design with MySQLoreillymedia

Category: Sql
Duration 6 hours 14 minutes 51 seconds