MySQL Introduction

Audience

Delegates who needs to access and work with a MySQL Database

Prerequisites

There are no specific pre-requisites, although an understanding of databases in general would be useful.

Duration

3 days. Hands on.

Course Objectives

This course covers the basics of SQL as used in MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Query Browser. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are all covered. Delegates will appreciate:

• Using client programs to access a MySQL database
• Creating, altering and dropping a MySQL database
• Writing SQL statements to select data from a MySQL database
• Writing joins and subqueries
• Using SQL expressions
• Using SQL aggregate functions and scalar functions
• Inserting, updating, deleting and replacing rows
• Creating and altering tables, indexes and views
• Using transactions
• Granting and revoking access privileges on tables and views
• Exporting and importing data

Course Content

Database Concepts

Using The MySQL client

Basic SELECT
The SQL SELECT statement
Case sensitivity
Quotes
Statement terminator
Syntax conventions
The select and FROM clause
Conditions and the WHERE clause
Logical operators
The ORDER BY clause
Column aliases
Arithmetic expressions
Precedence of operators

LIMIT, UNION and Aggregate functions

Subqueries and Joins

Numeric and Character functions

Date, Time and Other Functions

Databases and Tables

Indexes and Views

Managing Data
Inserting, replacing, updating, deleting rows
The truncate statement
Transactions
Autocommit
COMMIT and ROLLBACK commands
Savepoints
Implicit commits

Access Control
Creating, Renaming and Dropping users
Granting and revoking privileges

Import and Export using SQL and command line