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 |
|---|---|
| 1 | Table Assessment Guide |
| 2 | Common Database Design Solutions |
| 3 | Effective Database Design |
Similar courses to Effective Database Design
High Performance SQLiteAaron Francis
Category: Other (Backend)
Duration 15 hours 27 minutes 55 seconds
Course
SQL and PostgreSQL: The Complete Developer's GuideudemyStephen Grider
Category: Sql
Duration 22 hours 1 minute
Course
SQL - The Complete Guide (MySQL, PostgreSQL & more)Academind Pro
Category: Sql
Duration 19 hours 35 minutes 38 seconds
Course
Apache Kafka Series - Kafka Streams for Data Processingudemy
Category: Other (Backend)
Duration 4 hours 50 minutes 7 seconds
Course
Complete SQL + Databases Bootcamp: Zero to Masteryzerotomastery.io
Category: Sql, Redis
Duration 24 hours 6 minutes 52 seconds
Course
MySQL High Performance Tuning Guideudemy
Category: Sql
Duration 2 hours 49 minutes 22 seconds
Course
Database Design & Implementationamigoscode (Nelson Djalo)
Category: Sql, Other (Backend)
Duration 2 hours 7 minutes 49 seconds
Course
100 Days Of Code: The Complete Web Development Bootcamp 2024Academind Pro
Category: JavaScript, Sql, HTML, CSS, Node.js, Vue
Duration 78 hours 51 minutes 55 seconds
Course
Make a Google search engine clone: JavaScript PHP and MySQLudemy
Category: JavaScript, Sql, PHP
Duration 5 hours 47 minutes 11 seconds
Course
Fundamentals of Database Engineeringudemy
Category: Other (Backend)
Duration 26 hours 2 minutes 59 seconds
Course