MySQL Database Development: Database Design Fundamentals
MySQL
| 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 relationships
Define the standards used in tables for data storage, such as removing duplicates, breaking down fields, and the use of primary keys
Define the standards used in column design and properties, such as auto increment columns, default and null values, and modifying size and format
Use mysql workbench to determine table and column properties
Define table relationships in a database, including one-to-many, one-to-one, and many-to-many
Describe database normalization and identify the various levels of normalization -
Describe the normalization process through each level of the normal forms
Identify the benefits achieved through the normalization process
Describe what full stack development is and the various tasks a developer would perform in each area
Describe the components of a full stack environment and how each component interacts
Describe the most common software stacks available that employ mysql
Describe the overall structure of a rdbms and the fsd environment
IN THIS COURSE
-
5m 53sAfter completing this video, you will be able to describe the key components of a RDBMS, including table structure, keys, and relationships. FREE ACCESS
-
6m 51sDuring this video, you will learn how to define standards for data storage in tables, such as removing duplicates, breaking down fields, and using primary keys. FREE ACCESS
-
3. Column Design Concepts5m 37sIn this video, you will learn about the standards used in column design, such as auto increment columns, default and null values, and modifying size and format. FREE ACCESS
-
4. Table and Column Properties8m 38sIn this video, you will learn how to use MySQL Workbench to determine table and column properties. FREE ACCESS
-
5. Relationships4m 2sDuring this video, you will learn how to define table relationships in a database, including one-to-many, one-to-one, and many-to-many relationships. FREE ACCESS
-
6. Normalization5m 36sUpon completion of this video, you will be able to describe database normalization and identify the various levels of normalization. FREE ACCESS
-
7. Normal Forms7m 56sAfter completing this video, you will be able to describe the normalization process through each level of the normal forms. FREE ACCESS
-
8. Benefits of Database Normalization5m 24sIn this video, find out how to identify the benefits achieved through the normalization process. FREE ACCESS
-
9. What is Full Stack Development (FSD)?3m 16sUpon completion of this video, you will be able to describe what Full Stack Development is and the various tasks a developer would perform in each area. FREE ACCESS
-
10. Anatomy of a Full Stack Environment2m 59sAfter completing this video, you will be able to describe the components of a full stack environment and how each component interacts. FREE ACCESS
-
11. FSD and MySQL3m 36sAfter completing this video, you will be able to describe the most common software stacks that employ MySQL. FREE ACCESS
-
12. Exercise: Database Design and FSD Concepts5m 22sUpon completion of this video, you will be able to describe the overall structure of a RDBMS and the FSD environment. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
