MariaDB for Developers

5 days training for £1,495 exc. VAT   

Call StayAhead Training on 020 7600 6116 to book your place now quoting course code: MARD


S5

MariaDB for Developers Course Overview

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.

Skills Gained

The delegate will acquire knowledge in all, and practise in some, of the following:

Who will the Course Benefit?

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

Course Objectives

To provide the skills needed to write more advanced queries and database maintenance statements on a MariaDB database.

Requirements

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

Pre-Requisite Courses

Follow-On Courses

NOTE: Course technical content is subject to change without notice.


MariaDB for Developers Training Course

View Course Contents - DAY 1

Course Introduction

Session 1: CLIENT/SERVER CONCEPTS

Session 2: THE MYSQL CLIENT PROGRAM FOR MariaDB

Session 3: DATA TYPES

Session 4: IDENTIFIERS

Session 5: DATABASES


MariaDB for Developers Training Course

View Course Contents - DAY 2

Session 6: TABLES AND INDEXES

Session 7: QUERYING FOR DATA

Session 8: SQL EXPRESSIONS AND FUNCTIONS

Session 9: UPDATING DATA

Session 10: CONNECTORS


MariaDB for Developers Training Course

View Course Contents - DAY 3

Session 11: OBTAINING DATABASE METADATA

Session 12: DEBUGGING

Session 13: JOINS

Session 14: SUBQUERIES

Session 15: VIEWS


MariaDB for Developers Training Course

View Course Contents - DAY 4

Session 16: IMPORT AND EXPORT

Session 17: USER VARIABLES AND PREPARED STATEMENTS

Session 18: INTRODUCTION TO STORED ROUTINES

Session 19: STORED ROUTINES - PROGRAM LOGIC

Session 20: STORED ROUTINES - EXCEPTION HANDLERS & CURSORS


MariaDB for Developers Training Course

View Course Contents - DAY 5

Session 21: PROCEDURES WITH PARAMETERS

Session 22: FUNCTIONS

Session 23: TRIGGERS

Session 24: BASIC OPTIMIZATIONS

Session 25: MORE ABOUT INDEXES


Pre-Requisite Courses


Follow-On Courses


Venues and Dates

  Barbican (London) Training Centre 

  • 11 December
  • 22 January 18
  • 05 March 18
  • 23 April 18
  • 11 June 18


Additional Resourcing

We can also run the course onsite at a location of your choice.

StayAhead Virtual Courses available There are options to take this as a Virtual course. Please contact us to discuss your specific requirements and to arrange a date to run this course as a virtual event to suit your schedule.


 
StayAhead Training Ltd  http://www.stayahead.com   Publication Date: Nov 5, 2017
telephone: 020 7600 6116   All registered trademarks are acknowledged
email: sales@stayahead.com   Copyright © StayAhead Training Ltd
Call us on 020 7600 6116