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

Streaming Databases

Streaming Databases

Sources: oreillymedia
Real-time applications are becoming the norm. However, for the model to function properly, it is necessary to obtain data in real time...
Zero To Shipped

Zero To Shipped

Sources: Kitze
Feeling intimidated by fullstack development? Wondering how can some developers ship a functional app in one day? This engaging video course demystifies and simplifies the proce...
24 hours 38 minutes 44 seconds
Apache Flink

Apache Flink

Sources: rockthejvm.com
Apache Flink is a distributed system and computational engine for stateful big data streaming. That was a mouthful. In plain English, Flink is an library that allows you to proc...
8 hours 31 minutes 38 seconds
Fundamentals of Backend Engineering

Fundamentals of Backend Engineering

Sources: udemy
Backend engineering is an art. During my 18 years career working with and building backend applications, I discovered that certain communication design patterns
16 hours 53 minutes 4 seconds