Course details

MySQL: Views, Indices, & Normal Forms

MySQL: Views, Indices, & Normal Forms


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Explore how indexes work to speed up query execution, and also, how views can be used to abstract complex queries in a convenient fashion. Examine how these constructs make the most sense when applied to well-designed relations that comply with the normal forms in database design.



Expected Duration (hours)
1.3

Lesson Objectives

MySQL: Views, Indices, & Normal Forms

  • 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
  • Course Number:
    it_aplumgdj_06_enus

    Expertise Level
    Intermediate