MariaDB for Developers — A 5 day course

contact usEnquire about this course

Synopsis

This MariaDB Developers training course is designed for MariaDB Developers who have a good understanding of a MariaDB (or MySQL) database and experience of using SQL commands. The course provides further practical experience in more advanced MariaDB commands and SQL statements including Stored Routines and Triggers.

Objectives

Developers who have a basic understanding of a MariaDB (or MySQL) database and SQL commands as covered on the Introduction to MariaDB course.

The delegates will practise:

Contents

Client/Server Concepts

The MySQL Client Program for MariaDB

Data Types

Identifiers

Databases

Tables & Indexes

Querying for Data

SQL Expressions & Functions

Updating Data

Connectors

Obtaining Database Metadata

Debugging

Joins

Subqueries

Views

Import & Export

User Variables & Prepared Statements

Introduction to Stored Routines

Stored Routines - Program Logic

Stored Routines - Exception Handlers & Cursors

Procedures with Parameters

Functions

Triggers

Basic Optimizations

More About Indexes

Publicly scheduled dates, locations, and prices

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

London — £1495 (+VAT)

Suitable For

Developers who have a basic understanding of a MariaDB (or MySQL) database and SQL commands as covered on the Introduction to MariaDB course.

Follow-On Courses

Prerequisites

A working knowledge of MariaDB (or MySQL) is required. This can be gained by attendance on the Introduction to MariaDB course.