Introduction to MySQL

Duration: 
3 days
Codes: 
STA-MYSI

Overview

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

Audience

Delegates who need to access and work with a MySQL Database.

Skills Gained

To provide the skills needed to create and alter a MySQL database and query and modify data held within such a database.

Prerequisites

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

Course Outline

Database Concepts

Using the MySQL Client

  • Basic SELECT
  • 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
  • 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

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.