Fundamentals of Databases Using MySQL:

Familiarizing Yourself with the Fundamentals of Databases
Identify the Database Development Life Cycle
Explore the MySQL RDBMS

Creating a Preliminary Database Design
Analyze Database Requirements
Identify Key Fields
Create Entity Relationship Diagrams

Applying Normalization Techniques
Normalize Tables
Denormalize Tables

Using the SQL Commands to Work with Tables
Discuss Structured Query Language (SQL)
Create Tables Using the Data Definition Language (DDL) Commands
Modify Data Using Data Manipulation Language (DML) Commands Working with
Databases

Databases
Use SQL Compound Statements
Create Triggers

Managing Databases
Create Indexes
Create Views
Create Transactions

Administering a Database
Perform Database Administration
Perform Backup and Recovery

After completing this course, students will know how to:

identify the fundamental concepts of databases and explore the MySQL RDBMS interface elements.
create a preliminary database design.
apply normalization techniques to a database.
use SQL commands to execute simple queries.
use SQL compound statements to query efficiently.
manage databases by creating views, indexes, and transactions.
administer and maintain a database.

Prerequisites

To be successful in this course, you should have some familiarity with the
Microsoft Windows environment, Microsoft Office applications, or similar office
productivity applications. The following courses or equivalent experience is
suggested: Introduction to Personal Computers: Using Windows Vista?, Windows XP
Professional: An Introduction. In addition, some experience with a programming
language such as C++ is helpful but not required.