MySQL Training: Introduction to SQL Using MySQL Training

Course Number: SQL-170
Duration: 2 days
view class outline

SQL Using MySQL Training Overview

Accelebrate's Introduction to SQL using MySQL course is designed for students new to writing SQL queries using MySQL.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/xml_html_js.htm.

SQL Using MySQL Training Prerequisites

Experience in basic computer literacy with previous experience with command-line programs and some knowledge of database concepts is required. Some knowledge of data retrieval and reporting would be beneficial.

Hands-on/Lecture Ratio

This MySQL training class is 65% hands-on, 35% lecture, with the longest lecture segments lasting for 20 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.

SQL Using MySQL Training Materials

All SQL using MySQL training students receive comprehensive courseware and a related textbook.

Software Needed on Each Student PC

MySQL classes on the Windows platform require:

At least 2GB RAM and 10GB free hard drive space
Windows XP, Vista, or 7 with the latest service packs (or Server 2003 or 2008)
Local admin rights
MySQL Community Server 5.1.x, as freely downloaded from http://www.mysql.com/downloads/mysql/
Related lab files and databases that the students extract and install at the start of class

MySQL classes on Linux or Solaris:

At least 2GB RAM and 15GB free hard drive space
VMware Player 3.1.x, a free download from http://downloads.vmware.com/d/info/desktop_downloads/vmware_player/3_0
A virtual machine that Accelebrate would provide for download, extraction, and testing prior to class. This VM would be for Linux or Solaris and could run on Windows or Linux with VMware Player or Mac OSX with VMware Fusion.

SQL Using MySQL Training Objectives

Understand how MySQL works
Learn to use SQL to output reports with MySQL
Learn to modify MySQL data with SQL
Learn to create a simple MySQL database
Learn to create simple work with Views and Stored Procedures in MySQL
Learn to create tables in MySQL

Note: MySQL training students interested in learning how to use MySQL to build database-driven Web sites are also encouraged to consider our PHP Training: Introduction to PHP and MySQL.

SQL Using MySQL Training Outline

Relational Database Basics

Brief History of SQL
Relational Databases

Tables
Rows
Columns
Relationships
Datatypes
Primary Keys
Foreign Keys
Relational Database Management System

Popular Databases

Commercial Databases
Popular Open Source Databases
Valid Object References

SQL Statements

Database Manipulation Language (DML)
Database Definition Language (DDL)
Database Control Language (DCL)

Simple SELECTs

Introduction to the Northwind Database
Some Basics

Comments
Whitespace and Semi-colons
Case Sensitivity

SELECTing All Columns in All Rows
Exploring the Tables
SELECTing Specific Columns
SELECTing Specific Columns
Sorting Records

Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts

Sorting Results
The WHERE Clause and Operator Symbols

Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY

Using the WHERE clause to check for equality or inequality
Using the WHERE clause to check for greater or less than
Checking for NULL
Using WHERE and ORDER BY Together
The WHERE Clause and Operator Words

The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator

More SELECTs with WHERE
Checking Multiple Conditions

AND
OR
Order of Evaluation

Writing SELECTs with Multiple Conditions

Advanced SELECTs

Calculated Fields

Concatenation
Mathematical Calculations
Aliases

Calculating Fields
Aggregate Functions and Grouping

Aggregate Functions
Grouping Data
Selecting Distinct Records

Working with Aggregate Functions
Built-in Data Manipulation Functions

Common Math Functions
Common String Functions
Common Date Functions

Data Manipulation Functions

Subqueries, Joins and Unions

Subqueries
Subqueries
Joins

Table Aliases
Multi-table Joins

Using Joins
Outer Joins
Unions

UNION ALL
UNION Rules

Working with Unions

Conditional Processing with CASE

Using CASE
Working with CASE

Inserting, Updating and Deleting Records

INSERT
Inserting Records
UPDATE
DELETE
Updating and Deleting Records

Creating and Modifying Tables

Data Types
Creating Tables

NULL Values
Primary Keys
Foreign Keys

Creating Tables
Adding and Dropping Columns
Renaming Tables

SQL Server
Oracle and MySQL

Dropping Tables

Views

Creating Views
Dropping Views
Benefits of Views
Creating a View

Stored Procedures

Creating Stored Procedures
Dropping Stored Procedures
Creating a Stored Procedure
Benefits of Stored Procedures

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.