MySQL: Views, Indices, & Normal Forms
MySQL
| Intermediate
- 13 videos | 1h 19m 39s
- Includes Assessment
- Earns a Badge
This 13-video course explores how indexes work to speed up query execution, and how views can be used to abstract complex queries in a convenient fashion. Learners will explore advanced abstractions in MySQL, including a view, which is a virtual table, and indices. Then you will learn how to use views to build abstractions for complex and common query operations in your use case. You will examine indices, which are auxiliary data structures which are maintained by a DBMS (database management system). Next, learn how to use an index on a database to make queries fast and easy. You will examine normal forms in database design, a standard set of rules to test the design of a table. This course demonstrates how to apply the analysis of normal forms to optimize the structure of your relations, and then to use appropriate indices to speed up query execution on them. Finally, this course demonstrates first, second, and third normal forms, and how to fix violations.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this course
Define a view and enumerate applications of views
Implement views in mysql
Use views to abstract complex queries in mysql
Define a database index and enumerate advantages and disadvantages of indexing columns in a relation
View indices on an existing table and create new indices on columns
Create composite indices and drop indices -
Identify and apply the first three normal forms of database design
Evaluate the number of tables needed to appropriately store and model data
Identify and rectify violations of the first normal form in mysql
Identify violations of the second normal form in mysql
Rectify violations of the second normal form in mysql by refactoring table design
Course summary
IN THIS COURSE
-
1m 58s
-
2m 44sIn this video, you will define a view and list its applications. FREE ACCESS
-
3. Implementing Views5m 21sIn this video, you will create views in MySQL. FREE ACCESS
-
4. Working with Views7m 59sDuring this video, you will learn how to use views to abstract complex queries in MySQL. FREE ACCESS
-
5. Understanding Indices8m 49sFind out how to define a database index and enumerate advantages and disadvantages of indexing columns in a relation. FREE ACCESS
-
6. Creating Indices7m 24sDuring this video, you will learn how to view and create indices on columns. FREE ACCESS
-
7. Working with Indices5m 16sIn this video, you will learn how to create composite indices and drop indices. FREE ACCESS
-
8. Normal Forms in Database Design9m 7sDuring this video, you will learn how to identify and apply the first three normal forms of database design. FREE ACCESS
-
9. Choices in Table Design8m 13sIn this video, learn how to evaluate the number of tables needed to store and model data appropriately. FREE ACCESS
-
10. First Normal Form9m 9sIn this video, you will identify and fix violations of the First Normal Form in MySQL. FREE ACCESS
-
11. Second Normal Form7m 30sIn this video, learn how to identify violations of the Second Normal Form in MySQL databases. FREE ACCESS
-
12. Fix Violations of the Second Normal Form4m 50sIn this video, learn how to fix violations of the Second Normal Form in MySQL by refactoring table design. FREE ACCESS
-
13. Course Summary1m 20sFind out how to Course Summary.Find out how to create a Course Summary. 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.
