0345 4506120

Introduction to MariaDB

Course Details

Name Introduction to MariaDB
Description
URL
Location:
Birmingham
Start Date:
Working Days:
Price:
£810.00 +vat
was £889.00
Availability:
Exam:
Residential:
Course ID:
507263
Offer

Overview

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.

The delegate will learn and acquire skills as follows:

  • Using client programs to access a MariaDB database
  • Creating, altering and dropping a MariaDB database
  • Writing SQL statements to select data from a MariaDB database
  • Writing joins and subqueries
  • Using SQL expressions
  • Using SQL aggregate functions and scalar functions
  • Inserting, updating, deleting and replacing rows
  • Creating and altering tables, indexes and views
  • Using transactions
  • Granting and revoking access privileges on tables and views
  • Exporting and importing data

Who will the Course Benefit?

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

Learning Objectives

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

Pre-Requisites

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

Course Content

Day 1

Course Introduction

  • Administration and course materials
  • Course structure and agenda
  • Delegate and trainer introductions

Session 1: DATABASE CONCEPTS

  • What is a database?
  • Database management systems
  • Tables, rows and columns
  • Indexes, primary keys, unique constraints and foreign keys
  • Client-Server architecture
  • Supported data types
  • Storage engines and table types
  • The Information_Schema and MySQL Databases for MariaDB
  • Exercise: Using a MariaDB Database

Session 2: USING THE MySQL CLIENT with MariaDB

  • What is the MySQL client?
  • Getting started and Logging in
  • Selecting a database
  • Client commands
  • Entering and executing SQL statements
  • Retrieving previous commands
  • Creating, editing and executing SQL files
  • Redirecting output into a file
  • Command line execution of SQL Scripts
  • Exercise:   Using the MySQL Client

Session 3: BASIC SELECT

  • The SQL SELECT statement
  • Case sensitivity
  • Quotes
  • Statement terminator
  • Syntax conventions
  • The select clause
  • The FROM clause
  • Conditions and the WHERE clause
  • Logical operators
  • The ORDER BY clause
  • Column aliases
  • Arithmetic expressions
  • Precedence of operators
  • Exercises:   Querying the sample database

Session 4: LIMIT, UNION AND AGGREGATE FUNCTIONS

  • The LIMIT clause
  • UNION
  • UNION ALL
  • Aggregate functions
  • The GROUP BY clause
  • Using Rollup with GROUP BY
  • The HAVING clause
  • Exercises:   Using Limit, Union and Aggregate Functions

Day 2

Session 5: SUBQUERIES AND JOINS

  • Subqueries
  • Cartesian products
  • Joins with original syntax
  • Table aliases
  • Natural joins
  • Join using
  • Join on
  • Multi-table joins
  • Exercises:   Using Subqueries and Joins

Session 6: NUMERIC AND CHARACTER FUNCTIONS

  • Function types
  • Testing functions
  • Numeric functions
  • Character functions
  • Exercise:   Using Numeric and Character Functions

Session 7: DATE, TIME AND OTHER FUNCTIONS

  • Date and time column types
  • Date and time formats
  • The date format function
  • Functions to return date time
  • Functions to extract components from date time
  • Date time arithmetic
  • Miscellaneous functions
  • Exercise:   Using Date, Time and other functions

Day 3:

Session 8: DATABASES AND TABLES

  • Creating a database
  • Selecting a database
  • Obtaining database metadata
  • Table properties
  • Creating tables
  • Auto_increment
  • Show create table
  • Column operations
  • Constraint operations
  • Copying tables
  • Renaming tables
  • Changing engine for tables
  • Obtaining table metadata
  • Altering tables
  • Dropping tables
  • Temporary tables
  • Memory tables
  • Exercises:   Maintaining databases and tables

Session 9: INDEXES AND VIEWS

  • What is an index?
  • Structure of an index
  • Creating an index
  • Reviewing indexes
  • Composite indexes
  • Altering a table to add an index
  • Dropping indexes
  • What is a view?
  • Creating views
  • View restrictions
  • Dropping views
  • Exercise:   Maintaining indexes and views

Session 10: MANAGING DATA

  • Inserting rows
  • Replacing rows
  • Updating rows
  • Deleting rows
  • The truncate statement
  • The COMMIT and ROLLBACK commands
  • Savepoints
  • Implicit commits
  • Exercise:   Managing data

Session 11: ACCESS CONTROL

  • Creating users
  • Renaming users
  • Dropping users
  • Granting privileges
  • Revoking privileges
  • Exercise:   Creating users, granting and revoking

Session 12: IMPORT AND EXPORT

  • Exporting using SQL
  • Importing using SQL
  • Exporting from the command line
  • Importing from the command line
  • Exercise:   Export and import data

Follow-On Courses

    • MariaDB for Developers
    • MariaDB Database Administration
    • PHP Programming & MariaDB for Web Development

Notes:

  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Birmingham - Quayside Tower

Description:

The Centre is open from 8:30am and is located on the 4th floor of the Quayside Tower. When you enter the building, proceed to the lifts.  The lifts are located beyond the front desk, on the left around the corner. On the 4th floor the Highbury Apprenticeships reception is located to your right.  Once you have registered, you will be directed to the refectory area where refreshments will be available for you. The instructor will call you into the room about 9:30am.

Note: Please be cautious if you take any hot or cold drinks to the training room - this is to protect your own health and safety as well as the equipment.

Amenities

Disabled Access

Quayside Tower has step free access, the lifts will take you to the Highbury Apprenticeships floor where again there are no steps.  If you are attending a course at the centre and will be using a wheelchair please notify us before your attendance and we make sure the staff will be ready to assist if needed.  A disabled access toilet is also available.

Toilets

Male, female and disabled WCs are located on the floor.

Lunch

Luncheon vouches will be provided on each day of the training. There is a selection of shops/restaurant within 5-10 min walk where the vouchers can be used.

Location:

Broad Street
Birmingham
B1 2HF

 

Directions:

Our training facilities in Birmingham are easily accessible from all major routes in and out of Birmingham and only 15 minutes walk or a short bus ride from Birmingham New Street Rail Station.  Birmingham Snow Hill Station is also nearby.

Travelling by Foot

From New Street Train Station

Exit into New Street follow sign for Victoria Square. At the square keep left and walk onto Paradise Street.

Turn right towards Fletchers Walk, walk under the dual carriageway. Turn right and walk along Paradise Circus.

Turn left into Broad Street and walk past the Hyatt Hotel (on your left) and The International Convention Centre on your right.

The entrance to Quayside Tower is on your left and next door to the Highlight Comedy Club and the Risa restaurant, the entrance is almost opposite to The Brasshouse.

Enter through the tinted glass doors and report to the reception desk at the 4th floor.

From Snow Hill Train Station

Exit Snow Hill station onto Livery Street. Turn right onto Edmund Street.

Carry on until you pass Birmingham City Council on your right and Birmingham Museum and Art Gallery on your left. Turn left and carry on until you reach Paradise Street. Turn right onto Paradise Street.

Turn right towards Fletchers Walk, walk under the dual carriageway. Turn right and walk along Paradise Circus.

Turn left into Broad Street and walk past the Hyatt Hotel (on your left) and The International Convention Centre on your right.

The entrance to Quayside Tower is on your left and next door to the Highlight Comedy Club and the Risa restaurant, the entrance is almost opposite to The Brasshouse.

Enter through the tinted glass doors and report to the reception desk at the 4th floor.


Travelling by Car

From the M5 / south and west

From Junction 3 M5 and from Dudley/Halesowen take the A456 Hagley Road.

Continue along the A456 until you reach Five Ways – move over to the right and take the underpass into Broad Street.

After about 100 metres at the first main traffic lights turn left into Sheepcote Street.

After about 50 metres at the roundabout turn right into Brindley Place where there is a multi-storey pay car park.

Exit the car park onto Brunswick Street, turn right and walk towards Central Square.

Cross the square and proceed onto Oozells Street.

At the end turn left onto Broad Street. Quayside Tower is on your right.

From M6 Junction 6 and Sutton Coldfield

Take the Aston Expressway A38M towards the City Centre.

Go over the flyover into St Chad’s Queensway and through the underpass.

As you leave the underpass move off to the left and do not enter the next underpass.

Continue across the traffic lights top Paradise Queensway.

Take the second exit, following signs to the ICC.

Carry straight on up Broad Street, pass the Hyatt Hotel (on your left) until the second set of traffic lights.

Turn right into Sheepcote Street.

After about 50 metres at the roundabout turn right into Brindley Place where there is a multi-storey pay car park.

Exit the car park onto Brunswick Street, turn right and walk towards Central Square.

Cross the square and proceed onto Oozells Street.

At the end turn left onto Broad Street. Quayside Tower is on your right.


Travelling by Bus

From New Street Train Station

Walk east towards Bullring Link, turn left at Bullring Link, turn right towards Smallbrook Queensway and right again onto Smallbrook Queensway.

Walk about 7 minutes and turn right onto Suffolk Street Queensway.

Walk to bus stop “Alexandra Theatre” (Stop SF1), take bus no. 22, 23, 24 or 29 and go two stops.

Get off at bus stop “Brindley Place” (Stop BR3), turn left and walk for about 1 minute you will reach Quayside Tower where Highbury Apprenticeships  is based on the 4th floor.


Travelling by Air

From Birmingham International Airport take a train to New Street Station.

Our Customers Include