Untitled Document

MySQL Introduction

Description

This course will give students the skills they need to set up and manage a MySQL database. Students will learn the basics of designing a relational database and learn to use SQL statements to create databases, tables and manage data in the data tables. Students will create a MySQL database and will identify the types of data that can be stored in data tables. Students will use the PHPMyAdmin tool to view and manage their MySQL databases. Students will learn to write applications which use MySQL databases.

Objectives

Students will install MySQL, connect to the MySQL database application and create a database and set up users for their database.
Students will design a relational database.
Students will use MySQL commands to define a database and tables.
Students will add records to their database, edit records, delete records and select records.
Students will use MySQL functions to work with database data.
Students will explore tools, applications and programming environments that work with MySQL.
Students will work with transactions and advanced SQL queries.
Students will explore feature that are new to MySQL 5.
Students will use the MySQL Adminitrator to perform database maintenance.
Students will create a final project using what they learned in the course.

Book

MySQL Visual Quickstart Guide

Author: Larry Ullman
Publisher: Peachpit Press
ISBN: 0-321-37573-4

Lesson 1: Getting Started

Read Chapters 1 and 2

Lesson 2: Designing a Database

Chapter 3

Lesson 3: Creating a Database

Read Chapter 4

Lesson 4: Working with the Database

Read Chapter 5

Lesson 5: MySQL Functions

Read Chapter 6

Lesson 6: Using MySQL

Skim Chapters 7, 8, 9 and 12. If one of the chapters is related to how you will be using MySQL pay particular attention to it.

Lesson 7: Advanced SQL and MySQL

Read Chapter 10

Lesson 8: MySQL 5 Features

Read Chapter 11

Lesson 9: MySQL Administration

Read Chapter 13

Lesson 10: Putting it All Together

Review Chapters 1 - 13