Register Now

Working with MariaDB [ 2 DAYS]

Course Code : HDB02G

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      

  • RDBMS Terminology      
  • MARIA Database        

2  MariaDB – Installation               

3  MariaDB – Administration      

  • Creating a User Account        
  • The Configuration File         
  • Administration Commands        

4  MariaDB – PHP Syntax        

5  MariaDB – Connection        

  • MYSQL Binary       
  • PHP Connection Script        

6  MariaDB – Create Database        

  • mysqladmin Binary      
  • PHP Create Database Script       

7  MariaDB – Drop Database        

  • mysqladmin Binary      
  • PHP Drop Database Script        

8  MariaDB – Select Database         

  • The Command Prompt        
  • PHP Select Database Script        

9  MariaDB – Data Types        

  • Numeric Data Types         
  • Date and Time Data Types        
  • String DataTypes        

10  MariaDB – Create Tables       

  • The Command Prompt        
  • PHP Create Table Script        
  • MariaDB

11  MariaDB – Drop Tables      

  • The Command Prompt        
  • PHP Drop Table Script        

12  MariaDB – Insert Query       

  • The Command Prompt        
  • PHP Insertion Script          

13  MariaDB – Select Query       

  • The Command Prompt        
  • PHP Select Script       

14  MariaDB – Where Clause      

  • The Command Prompt        
  • PHP Scripts Using Where Clause        

15  MariaDB – Update Query      

  • The Command Prompt        
  • PHP Update Query Script        

16  MariaDB – Delete Query       

  • The Command Prompt        
  • PHP Delete Query Script       

17  MariaDB – Like Clause        

  • The Command Prompt        
  • PHP Script Using Like Clause       

18  MariaDB – Order By Clause         

  • The Command Prompt        
  • PHP Script Using Order By Clause        

19  MariaDB – Join      

  • The Command Prompt        
  • PHP Script Using JOIN         

20  MariaDB – Null Values        

  • NULL Operators        
  • Sorting NULL Values         
  • NULL Functions        
  • Inserting NULL Values         

21  MariaDB – Regular Expression       

22  MariaDB – Transactions       

  • Structure of a Transaction        

23  MariaDB – Alter Command         

  • Using ALTER to Modify Columns        
  • Using ALTER to Modify Tables        
  • MariaDB

24  MariaDB – Indexes and Statistics Tables       

  • Create an Index        
  • Drop an Index       
  • Rename an Index       
  • Managing Indexes      
  • Table Statistics         

25  MariaDB – Temporary Tables        

  • Create a Temporary Table        
  • Administration         
  • Drop a Temporary Table       

26  MariaDB – Table Cloning       

27  MariaDB – Sequences        

  • Installating the Sequence Engine        
  • Creating Sequence       

28  MariaDB – Managing Duplicates        

  • Strategies and Tools         
  • Using INSERT       
  • Using DISTINCT        
  • Using INSERT IGNORE         

29  MariaDB – SQL Injection Protection      

30  MariaDB – Backup Methods       

  • Backup Tools        
  • Using THE SELECT INTO OUTFILE Statement       
  • Using CONNECT in Backups       

Other Tools         

31  MariaDB – Backup Loading Methods     

  • Using LOAD DATA       
  • Using MYSQLIMPORT         
  • Using MYSQLDUMP          

 

Pl contact
Singapore


Start Date End Date Country Location Register
27 June 2018 29 June 2018 Singapore
09 July 2018 11 July 2018 Singapore