Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Instructor-led Classroom Adult Training in Singapore - Modular Fast Track Skill-Based Trainings

MariaDB Database Training

MariaDB Server is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com and Google.

MariaDB turns data into structured information in a wide array of applications, ranging from banking to websites. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases.

MariaDB is developed as open source software and as a relational database it provides an SQL interface for accessing data. The latest versions of MariaDB also include GIS and JSON features.

Course Highlights:

  • Writing queries
  • Creating and updating databases and tables
  • Using MariaDB built-in functions
  • Sorting and filtering data
  • Updating tables with triggers
  • Working with subselects and views
  • Creating and using a stored function

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Course Code: C912

Course Booking

$298.00 (GST-exclusive)
$318.86(GST-inclusive)

Course Date

Course Time

* Required Fields

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.


Training Grant and Subsidy

All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website www.skillsfuture.sg/credit to choose from the courses available on the SkillsFuture Credit course directory

Course Details

Module 1 Get Ready

  • What is SQL?
  • Why Use MariaDB
  • Download MariaDB
  • MariaDB Command Line

Module 2: Terminology

  • Database/Schema
  • Table
  • Column/Field
  • Row/Record

Module 3: Data Types

  • INT 
  • DECIMAL
  • VARCHAR
  • CHAR
  • TEXT
  • DATE, TIME & YEAR
  • TIMESTAMP & DATETIME
  • ENUM
  • SET
  • NULL
  • Character Set

Module 4 Basic Queries

  • Database
  • Tables
  • Create 
  • Read 
  • Update
  • Delete

Module 5 Functions

  • Math Functions
  • Date/Time Functions
  • String Functions
  • Operators
  • Group By

Module 6: Advanced Queries

  • Inserting & Deleting Records
  • Joining Table

Module 7 Relational Database

  • Relational Database Concept
  • Foreign Key

Who Should Attend

  • Website administrators
  • Web developers

Prerequisite

Prerequsite

This is a beginner course. No SQL or programming lanange knowledge is required.

Software Requirement

Please down and install& MariaDB from the link below

https://mariadb.org/download/

Trainers

MySQL TrainerTruman Ng graduated with Bachelor Degree in Electrical Engineering from NUS in year 2002. He designed Artificial Intelligence (AI) controller for DC-DC Power Convertor by using Fuzzy Logic and Neural Network (NN) as his university Final Year Project.

Truman has over 15 years project experiences across Database & Web Design, PLC machinery, Data Center Design , Structure Cabling System(SCS) and Enterprise Network Design and Implementation. He used to be a network architect for Hewlett Packard, working with a group of virtual team from the US in handling network design and projects in the States.

Truman is the founder of Nexplore (S) Pte Ltd. He provides solutions of Cloud SaaS, IaaS & PaaS and Software Defined Network (SDN), VoIP and Internet Security. He was engaged by Huawei Global Training Center to provide 60+ consultations and trainings for Internet Service Providers(ISP) from Malaysia, Singapore, Brunei, Philipines, Australia, Poland, Iran, South Africa, Swaziland, Cote Dlvoire, Syria, Uzbekistan, New Zealand and countries over the world.
As achievement, Truman has successfully completed 100+ IT network projects for Bank, Hotel and Factory within 5 years.
Truman is certified in PMP, Cisco CCNP, CCIP, CCDP, HP Ase and Huawei HCNP, HCIE R&S, HCNA Cloud, HCNA Security, etc.

MySOL TrainerTu Anqi is a scholar and dean’s lister with double degree in Business and Computer Science at NTU. Her areas of expertise lies in Python, R Programming, MySQL, Keras, Numpy, Pandas and Matplotlib. She has been working as a Data Analyst at ViSenze Pte Ltd, a visual search and recognition startup. Having strong interests in computer vision, data analytics and machine learning, she has competed and won the top rankings in several data competitions and hackathons. As the current Technical Director of NTU Open Source Society, she conducts regular workshops related to data analytics and data science

MySQL TrainerChia Wei Kang is a MOE registered instructor. He has over 6 years of development experience in both Android and Web applications. He is a passionate Software Engineer with a vast array of knowledge in many different frontend and backend languages, and databases. His specialization is in the field of Software Engineering and Database. Wei Kang is currently working on his startup, Geboto, which provides chatbot solutions for Hotel and F&B.

MySQL TrainerVetrivel Samidurai is a Professional Sr Software Engineer from Singapore, developed lot of web applications, e-commerce websites and web portals. He has more than 5 year hands on lab experience of the following technologies HTML, CSS, Javascript, jQuery, Angular JS, React JS, PHP, MySql, Magento, RESTAPI, Payment gateway integration etc. He has led the back end development team in few companies

MySQL TrainerVedavathi Mulupuri did Master of Technology in Software Engineering from NUS in the year 2010. She has around 15 plus years of teaching and industry experience in Singapore and India in the field of programming, Production support, Requirements Analysis and Engineering related modules. She has worked in various industries like Defense, Oil and Gas, Aviation and IT Services. She has complete Software Development Life Cycle (SDLC) experience and worked in HCL Insys, Reliance Global Energy Services, Invensys India Pte. Ltd., Zen Technologies etc..

Vedavathi has experience as IT Trainer in Singapore Infocomm Technology Programmes. She is certified in IT Infrastructure Library ITIL V 3 Foundation in IT Service Management, Certified Business Analysis professional CBAP from International Institute of Business Analysis IIBA and has Professional Diploma in Mobile Wireless Solutions from ISS/NUS etc.

MySQL TrainerYu Jin is a passionate Information Systems undergraduate in SMU possessing a myriad of skills from the IT industry. A Financial Informatics diploma holder, Yu Jin's journey in the world of IT started when he realised the need to pick up on various technical skills in the fast-paced modern world we are in today. He is a knowledgeable individual, with experienced in Python, Java, PHP, ASP.NET, MySQL, etc. As a curious individual, he is constantly pursuing proficiency in new skills to keep himself up to date

MySQL TrainerSundari has more than 10 years of experience in Software Training and Development. She initiated her career as a Trainer and worked in various companies, developing and nurturing client relationships. She is passionate about training and to impart her knowledge to others and always eager to learn more.

Area of expertise:

  • Data Warehousing - SAP BI 7.0
  • Reporting Tools - BEx Query Designer, BEx Analyzer, Web Analyzer, Web Application Designer, BEx Report Designer and Dash Boards
  • Language - Visual C++ (6.0), C#(.Net), C, C++, Java and also in SAP ABAP/4, SD, FI
  • Operating Systems - Windows10, 7, 2000.NT, 98, XP, MS-DOS, Unix
  • Databases - Oracle 9i/8i, SQL Server and MS-Access
  • GUI - Visual Basic 6.0, Power Builder 5.0, Developer 2000 
  • Java-script, HTML5, CS6, Dreamweaver, MS-Office.

She is currently pursuing Masters in Business (ERP Systems) in Victoria University, Australia. She has completed her Bachelors in Computer Science in Bharathiar University, India and Professional Diploma in SAP Business Intelligence in Victoria University, Australia - Lithan Hall Academy, Singapore. She is certified in SAP BI 7.0 (TBW45_70) and Oracle 9i PL/SQL Developer from Oracle Corp U.S. Also certified in ACTA (Advanced Certificate in training and assessment) from WDA Singapore.

MySQL TrainerLisa Lee has her degree in Finance at the Illinois Institute of Technology. Prior to returning to Singapore, she worked as a financial analyst in a US-start up that sells business intelligence to dental offices. She was on the winning team for the Chicago Quantitative Alliance (CQA) Investment Challenge in 2015.Her core specialisation skills are R, Python, Machine Learning, Statistical Analysis, and Data Visualisation in Tableau and Qliksense. She currently works as a Data Science Instructor at a local university.

MySQL TrainerPeter Goh is the Technology Evangelist at Disruptive Digital, a full-service digital agency based in Singapore, offering innovative & effective web and native mobile application development. He specializes in bleeding edge software development and have more than 10 years' experience in developing customized applications for desktop, web and mobile platforms. He has extensive domain knowledge in .Net and Java programming, iOS development and has helped many to create e-commerce web sites on Amazon AWS and Microsoft Azure

MySQL TrainerKen Hiong has over 20 years of work experience in the healthcare and pharmaceutical industry holding various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning.

He graduated with a degree in Pharmacy and holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide.

He is an expert Excel user and has a keen interest in scripting and web development with practical knowledge of HTML, Javascript, CSS, PHP, MySQL, WordPress, VBA, amongst others. Applying these tools at work, he had simplified many work methodologies, improved data analysis and business reporting processes, achieved higher productivity and enhanced quality outcomes. He is an advocate of lifelong learning.

MySQL TrainerDr. Alfred Ang is the founder of Tertiary Courses. He is a serial entrepreneur. He founded OSWeb2Design Singapore Pte Ltd in 2007 offering web development, e-commerce store development, graphics design, ebook publishing, mobile apps development, and digital marketing services. He established the first online gardening store in Singapore, Eco City Hydroponics Pte Ltd in 2000, offering a wide range of gardening products such as seeds, plant nutrients, hydroponics kits etc. Eco City Hydroponics has become the most popular and successful gardening store in Singapore. He founded Tertiary Infotech Pte Ltd in 2012 and transformed the business to a training platform, Tertiary Courses in 2014. Tertiary Courses offers a wide range of SkillsFuture courses for PMETs to upgrade their skills and knowledge. He also established Tertiary Courses Malaysia in 2016. He also founded Tertiary Robotics in 2015 offering Arduino, Raspberry Pi, Microbit and Robotics products

Dr. Alfred Ang earned his Ph.D. from National University of Singapore in 2000, majoring in Electrical and Electronics Engineering. He also completed an online MBA course with U21 Global based in Australia. He obtained his B.Sc (Hons) from National University of Singapore in 1992, majoring in Physics. He topped his Physics cohort for 3 consecutive years and funded his degree study with Book price, awards and tuition. He has worked in Defence, Electronics and Semiconductor Industries. His current interests include Machine Learning, Deep Learning, Artificial Intelligence, Internet of Things, Robotics and Programming.

Dr. Alfred Ang was Distinguished Toastmasters (DTM) and Senior Member of IEEE. He has published more than 20 peer reviewed papers and co-inventors for more than 20 inventions.

MySQL  TrainerAriff is a recent Graduate from Murdoch University in BSc in Business Information System and Management (Double Major). He is a MOE Registered Instructor teaching in most of the Information Technology and Multimedia aspects such as Web programmer, Mobile App Developer, Video director and editor, and game development and design (PC and Mobile). Besides Information Technology and Multimedia, he is also giving entrepreneurship, leadership workshops and motivation speech training.

He has a strong passion in IT and gaming design been since 2005. He is currently doing games design for his own project and continues to teach and share his knoweledge. He still hungers for new skills to keep himself up to date as technology continues to change.

Write Your Own Review

You're reviewing: MariaDB Database Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha

Tags

Use spaces to separate Subjects. Use single quotes (') for phrases.

You May Be Interested In These Courses

MySQL Essential Training

MySQL Essential Training

14 Review(s)
$298.00 (GST-exclusive)
$318.86(GST-inclusive)
Database Training with Microsoft Access

Database Training with Microsoft Access

5 Review(s)
$298.00 (GST-exclusive)
$318.86(GST-inclusive)
Neo4j Graph Database Essential Training

Neo4j Graph Database Essential Training

2 Review(s)
$298.00 (GST-exclusive)
$318.86(GST-inclusive)