MySQL: Views, Indices, & Normal Forms

MySQL    |    Intermediate
  • 13 videos | 1h 19m 39s
  • Includes Assessment
  • Earns a Badge
Rating 4.8 of 85 users Rating 4.8 of 85 users (85)
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 44s
    In this video, you will define a view and list its applications. FREE ACCESS
  • Locked
    3.  Implementing Views
    5m 21s
    In this video, you will create views in MySQL. FREE ACCESS
  • Locked
    4.  Working with Views
    7m 59s
    During this video, you will learn how to use views to abstract complex queries in MySQL. FREE ACCESS
  • Locked
    5.  Understanding Indices
    8m 49s
    Find out how to define a database index and enumerate advantages and disadvantages of indexing columns in a relation. FREE ACCESS
  • Locked
    6.  Creating Indices
    7m 24s
    During this video, you will learn how to view and create indices on columns. FREE ACCESS
  • Locked
    7.  Working with Indices
    5m 16s
    In this video, you will learn how to create composite indices and drop indices. FREE ACCESS
  • Locked
    8.  Normal Forms in Database Design
    9m 7s
    During this video, you will learn how to identify and apply the first three normal forms of database design. FREE ACCESS
  • Locked
    9.  Choices in Table Design
    8m 13s
    In this video, learn how to evaluate the number of tables needed to store and model data appropriately. FREE ACCESS
  • Locked
    10.  First Normal Form
    9m 9s
    In this video, you will identify and fix violations of the First Normal Form in MySQL. FREE ACCESS
  • Locked
    11.  Second Normal Form
    7m 30s
    In this video, learn how to identify violations of the Second Normal Form in MySQL databases. FREE ACCESS
  • Locked
    12.  Fix Violations of the Second Normal Form
    4m 50s
    In this video, learn how to fix violations of the Second Normal Form in MySQL by refactoring table design. FREE ACCESS
  • Locked
    13.  Course Summary
    1m 20s
    Find 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.

YOU MIGHT ALSO LIKE

Book Job Ready SQL
Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Course Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Using Business Etiquette to Increase Your Professionalism
Rating 4.5 of 3027 users Rating 4.5 of 3027 users (3027)
Course MySQL: Transactions, Savepoints, & Locks
Rating 4.5 of 44 users Rating 4.5 of 44 users (44)
Course MySQL: Creating & Updating Tables
Rating 4.7 of 171 users Rating 4.7 of 171 users (171)