This 2 day interactive course covers all basic aspects of MariaDB, an open source relational database. After completing this course, the participants can start using MariaDB in their work environments.
This course is approved for funding by SKILLSCONNECT.
Course reference number is CRS-N-0046756.
Course fee: SGD 725 (GST is not applicable)
Anyone with basic understanding on RDBMS.
This course does not lead to any certification.
Basic IT skills.
The course objective is to teach the participants:
Installation and configuration of MariaDB, and the commands needed to work with the database.
1 MariaDB – Introduction
2 MariaDB – Installation
3 MariaDB – Administration
4 MariaDB – PHP Syntax
5 MariaDB – Connection
6 MariaDB – Create Database
7 MariaDB – Drop Database
8 MariaDB – Select Database
9 MariaDB – Data Types
10 MariaDB – Create Tables
11 MariaDB – Drop Tables
12 MariaDB – Insert Query
13 MariaDB – Select Query
14 MariaDB – Where Clause
15 MariaDB – Update Query
16 MariaDB – Delete Query
17 MariaDB – Like Clause
18 MariaDB – Order By Clause
19 MariaDB – Join
20 MariaDB – Null Values
21 MariaDB – Regular Expression
22 MariaDB – Transactions
23 MariaDB – Alter Command
24 MariaDB – Indexes and Statistics Tables
25 MariaDB – Temporary Tables
26 MariaDB – Table Cloning
27 MariaDB – Sequences
28 MariaDB – Managing Duplicates
29 MariaDB – SQL Injection Protection
30 MariaDB – Backup Methods
Other Tools
31 MariaDB – Backup Loading Methods
| Start Date | End Date | Country | Location | Register |
|---|---|---|---|---|
| 27 June 2018 | 29 June 2018 | Singapore | ||
| 09 July 2018 | 11 July 2018 | Singapore |