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
0:00
/ #1: Welcome
All Course Lessons (16)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 1 | Welcome Demo | 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 |
Unlock unlimited learning
Get instant access to all 15 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.
Learn more about subscriptionBooks
Read Book Effective Database Design
| # | Title |
|---|---|
| 1 | Table Assessment Guide |
| 2 | Common Database Design Solutions |
| 3 | Effective Database Design |
Comments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
Web API From Start to Finish
Sources: iamtimcorey.com (Tim Corey)
Application Programming Interfaces (APIs) are software that send information back and forth between a program and a user. The entire web runs on APIs! They are required for mose...
17 hours 59 minutes 54 seconds
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
Node, SQL, & PostgreSQL - Mastering Backend Web Development
Sources: udemy
Become an in demand software engineer by taking this course on Node, SQL, PostgreSQL, and backend web development. As one of the most popular web development st
4 hours 59 minutes 41 seconds
The Complete 2023 Web Development Bootcamp
Sources: udemy
Welcome to the Complete Web Development Bootcamp, the only course you need to learn to code and become a full-stack web developer. With over 12,000 ratings and a 4.8 average, my...
62 hours 32 minutes 23 seconds
Ludicrous Speed Postgres
Sources: Creston Jamison
This course is dedicated to optimizing PostgreSQL performance with a focus on proper schema design and efficient database usage. It is designed for those...
12 hours 27 minutes 44 seconds