MySQL Introduction

Hours: 32 / Access Length: 180 Days / Delivery: Online, Mentor Supported
Retail Price: $375.00

Course Overview:

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.

Students will:

  • Install MySQL and MySQL Workbench.
  • Write queries to retrieve data from one table.
  • Write queries to retrieve data from more than one table.
  • Write queries that summarize data.
  • Write queries that contain sub queries.
  • Write queries to insert, delete and update data
  • Write queries that convert from one data type to another and use functions to work with data.
  • Design a database
  • Will write SQL statements to create a database.
  • Create a final project using what they learned in the course.

Course Mentor:

Rita Harwell was born and raised in Fort Worth, Texas.  She received her Bachelor’s degree from the University of North Texas, and a Master’s degree from the University of Missouri, Columbia, Missouri.  In addition, she studied Computer Science at North Carolina State University.  Ms. Harwell has taught computer programming at Wake Technical Community College for 14 years.  She developed a passion for database programming and programmed in Visual Basic, Perl, C#, and C++ primarily developing medical software.

Mrs. Harwell’s personal passions are for horses, bicycling, and GeoCaching.

Course Outline:

Lesson 1:Getting Started

In this lesson we will install the tools we will need for this course and take a look at some background information on SQL and databases.

Lesson 2: Retrieve Data from a Single Table

In this lesson we take a look at creating basic queries to retrieve records from a single table.

Lesson 3: Retrieving Data from Two or More Tables

Now that we have the basics of creating queries using one table, we will look at how to combine data from multiple tables using INNER and OUTER JOINS and UNIONS.

Lesson 4: Summary Queries

In this lesson we will look at summarizing the data we have retrieved. This allows us to get totals and other summaries of our data.

Lesson 5: Subqueries

In this lesson we will take a look at some more complex queries - creating queries that contain other queries. These subqueries allow us to handle some complex situations, but can be complex themselves. It helps to build the queries a piece at a time.

Lesson 6: Insert, Update and Delete Data

In addition to querying existing records in a database, we can use SQL to add, update and delete records in the database. Since we will be modifying the data, these commands should be executed with care.

Lesson 7: Data Types and Functions

In this lesson we will take a look at some of the MySQL Data Types including Date, String and Numeric. We will also look at other functions we can use to help create queries or summarize data.

Lesson 8: Designing a Database

In this lesson we will look at what goes into designing a database to prepare for building databases in the next lesson. Database design is about deciding how you will use the data and also about making sure the database is going to be efficient.

Lesson 9: Creating a Database

In this lesson we will take the tables we designed in the last lesson and look at the SQL commands for creating the database and setting the options to make it work well. We will look at creating a database and data tables using both pure SQL and the visual tools.

Lesson 10: Putting it All Together

Welcome to the final lesson of the MySQL Introduction class. In this lesson you will apply what you have learned in this course to a final project. This can be a chance for you to finish the project you have been working on throughout the course or a chance to work on one you will be using in your own work.

All necessary materials are included.

System Requirements:

Internet Connectivity Requirements:
  • Cable and DSL internet connections are recommended.

Hardware Requirements:
  • Minimum Pentium 400 Mhz CPU or G3 Macintosh. 1 GHz or greater CPU recommended.
  • 256MB RAM minimum. 1 GB RAM recommended.
  • 800x600 video resolution minimum. 1025x768 recommended.
  • Speakers/Headphones to listen to Dialogue steaming audio sessions.
  • A microphone to speak in Dialogue streaming audio sessions.
Operating System Requirements:
  • Windows Vista, 7, 8, 8.1, 9, 10
  • Mac OSX 10 or higher.
  • OpenSUSE Linux 9.2 or higher.
Web Browser Requirements:
  • Google Chrome is recommended.
  • Firefox 13.x or greater.
  • Internet Explorer 6.x or greater.
  • Safari 3.2.2 or greater.
Software Requirements:
  • Adobe Flash Player 6 or greater.
  • Oracle Java 7 or greater.
  • Adobe Reader 7 or greater.
Web Browser Settings:
  • Accept Cookies
  • Disable Pop-up Blocker.

**Outlines are subject to change, as courses and materials are updated.**