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.

The delegate will learn and acquire skills as follows:

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

Notes:

MariaDB for Developers Training Course

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

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

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

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

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 

  • 06 August
  • 08 October
  • 10 December
  • 18 February 19


Additional Resourcing

If you have a number of delegates to train then this course can be conducted on your premises or at a venue of your choice as a Closed event. Closed courses can be tailored to meet the specific needs of your business and can prove to be cost effective, convenient and relevant.

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: Jun 14, 2018
telephone: 020 7600 6116   All registered trademarks are acknowledged
email: sales@stayahead.com   Copyright © StayAhead Training Ltd
Call us on 020 7600 6116