Microsoft, Cisco, VMWare, CompTIA, and Technical Courses

Learning MySQL
One Day - Instructor-led

MySQL, the most popular open-source database, offers the power of a relational database in a package that's easy to set up and administer. In this one day class you will learn how to set up and design an effective database, create powerful queries using SQL, and important house-keeping tasks such as backups and recovery.

Audience

Any person with basic computer skills, familiar with concepts related to database structure and terminology, and wants to use MySQL to query databases.

Prerequisites

Before attending this course, students must have:

  • Taken the Windows XP Level 1 course or have the basic skills and knowledge of Windows applications

Course Outline

Lesson 1: Installing MySQL

  • Installation Choices
  • Using the Command-Line Interface
  • Using the Text Editor

Lesson 2: Using the MySQL Monitor

  • Starting the Monitor
  • Style, Case, and Semicolons
  • The Monitor Help
  • Running the Monitor in Batch Mode
  • Options

Lesson 3: Database Basics

  • Developing a Database
  • The Database Design Process
  • The Entity Relationship Model
  • Using Tools for Database Design

Lesson 4: Database Structures

  • Creating Tables
  • Altering Structures
  • Deleting Structures

Lesson 5: SQL Basics

  • Select
  • Insert
  • Edit
  • Delete

Lesson 6: Backup and Recovery

  • Dumping a Database as SQL Statements
  • Loading Data from an SQL Dump File
  • Scheduling Backups
  • Checking and Repairing Corrupted Tables