|
After taking this course, the learner will be able to use the principles of database design, including normalization and use of forms. They will also be able to use MySQL to create relational databases, and perform searches on those databases.
Objectives:
After completing this course, students will be able to:
- Normalize a database into First, Second and Third Normal Forms
- Create and populate a database in MySQL
- Search a database using joins, groupings, and FULLTEXT searches
- Change the search engine type of a table
- Create indexes to improve the ability to search a database
Topics:
- Normalization, keys, and relationships
- First Normal Form
- Second Normal Form
- Third Normal Form
- Creating and populating the database
- Performing joins
- Grouping selected results
- Creating indexes
- Using different table types
- Performing basic FULLTEXT searches
- Performing Boolean FULLTEXT searches
- Optimizing the database
|
