Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
Learn how to design an efficient database and build it using SQL: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign54
If you have an idea or requirements for creating a database and don't know how to design it, this video is for you.
You can take an idea or some requirements for an application and create a database design.
In this video I will explain step by step how to do this, using an example. We start with a written description of what we want to do and end with a database design with a few tables, columns, and primary and foreign keys added.
Timestamp:
00:00 Going from an idea to designing a database
00:43 Step 1 – write it down
01:44 Step 2 – find the names
02:13 Create tables
02:54 Step 3 – add attributes
06:13 Step 4 – add relationships
08:04 Step 5 – evaluate and adjust
09:15 Standardization and next steps
Connections:
Lucidchart: https://www.lucidchart.com/pages/
Database modeling tools article: https://www.databasestar.com/data-modeling-tools/
Please take the opportunity to connect and share this video with your friends and family if you find it useful.