MySQL Database Development: Database Design Fundamentals
MySQL 8.0
| Beginner
- 12 Videos | 1h 5m 11s
- Includes Assessment
- Earns a Badge
A database is only as good as its initial design. Explores RDBMS design fundamentals, such as table design, normalization, and relationships. Full Stack Development and how MySQL fits into the FDS landscape is also covered.
WHAT YOU WILL LEARN
-
describe the key components of a RDBMS, including table structure, keys, and relationshipsdefine the standards used in tables for data storage, such as removing duplicates, breaking down fields, and the use of primary keysdefine the standards used in column design and properties, such as auto increment columns, default and null values, and modifying size and formatuse MySQL Workbench to determine table and column propertiesdefine table relationships in a database, including one-to-many, one-to-one, and many-to-manydescribe database normalization and identify the various levels of normalization
-
describe the normalization process through each level of the normal formsidentify the benefits achieved through the normalization processdescribe what Full Stack Development is and the various tasks a developer would perform in each areadescribe the components of a full stack environment and how each component interactsdescribe the most common software stacks available that employ MySQLdescribe the overall structure of a RDBMS and the FSD environment
IN THIS COURSE
-
1.RDBMS Essentials5m 53sUP NEXT
-
2.Table Design Concepts6m 51s
-
3.Column Design Concepts5m 37s
-
4.Table and Column Properties8m 38s
-
5.Relationships4m 2s
-
6.Normalization5m 36s
-
7.Normal Forms7m 56s
-
8.Benefits of Database Normalization5m 24s
-
9.What is Full Stack Development (FSD)?3m 16s
-
10.Anatomy of a Full Stack Environment2m 59s
-
11.FSD and MySQL3m 36s
-
12.Exercise: Database Design and FSD Concepts5m 22s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.