Introduction to MySQL — A 3-Day Course

 Open Public Course Closed In-House Course

Course Synopsis

The MySQL database has become the world's leading open source database. With consistent fast performance, high reliability and ease of use it is the open source database of choice for many organisations. This introductory course covers all the basics of MySQL.

Course Objectives

By the end of the course, delegates will be able to:

• Outline the structure of a MySQL database
• Use the MySQL Client Program and other interfaces
• Create a MySQL database
• Write SQL statements to select data from a MySQL database
• Use joins and subqueries in SQL
• Use SQL expressions and basic functions
• Insert, update, delete and replace data
• Create and alter tables, indexes and views
• Understand how privileges are controlled

Suitable For

• New or existing users of MySQL, who have little or no previous experience with a relational database management system

Course Prerequisities

A basic understanding of IT is required.

Publicly scheduled dates, locations, and prices

Contents

Client/Server Concepts

Relational Database Principles

The MySQL Client Program

Other MySQL Interfaces

Data Types

Creating Databases

The Basic SELECT Statement

Selecting Data from Multiple Tables using JOIN

Grouping and Sorting Output

Sub-queries

String, Temporal and Numeric Functions

Creating, Altering and Dropping Tables

Creating, Altering and Dropping Views

Primary and Foreign Key Constraints

Creating and Dropping Indexes

Inserting, Updating and Deleting Data

Controlling Access