Introduction to MariaDB — A 3 day course

contact usEnquire about this course

Synopsis

The Introduction to MariaDB course covers the basics of the SQL language as implemented by MariaDB. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced.

Objectives

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

The delegates will practise:

Contents

Database Concepts

Using the MySQL Client with MariaDB

Basic Select

Limit, Union & Aggregate Functions

Subqueries & Joins

Numeric & Character Functions

Date, Time & Other Functions

Databases & Tables

Indexes & Views

Managing Data

Access Control

Import & Export

Publicly scheduled dates, locations, and prices

Select a date to enquire about availability of places. For dates after 13 April 2017, please call 0333 210 0140 or use our contact form to enquire about places and availability.

London — £995 (+VAT)

Manchester — £995 (+VAT)

Suitable For

Anyone who needs to access and work with a MariaDB Database or is migrating from MySQL to MariaDB.

Follow-On Courses

Prerequisites

There are no formal pre-requisites, although an understanding of databases and exposure to information technology in general would be useful.