Grow your MySQL skills
KnowledgeHut's MySQL Online Training course takes absolute beginners through the basics of SQL, and helps them build the ability to write queries with confidence. Start with setting up a MySQL instance and the basic table operations. Then deep-dive into SQL statements and learn about analytical SQL queries. Finally, use MySQL with web-based applications to create robust applications in real-time.
Course Reference Number: C11895908
Utilise Your SkillsFuture Credit and Claim UTAP Support
Talk to a Course CounsellorSkillsFuture Credit (SFC): Singaporeans aged 25 years and above can apply for the SkillsFuture Credit to pay the course fee. Click here for more information on eligibility to claim SFC.
Union Training Assistance Programme (UTAP): UTAP is a training benefit provided to NTUC Union Members with the objective of encouraging them to upgrade with skills training by minimizing training costs. If you are an NTUC Union Member, you can get up to 50% funding (capped at $500 per year) under the Union Training Assistance Programme (UTAP). For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)
|
MySQL |
||
| Individuals | ||
- Course Fee (Before GST)
- GST (Full Course Fee, 9%)
- Course Fee + GST
Unfunded Course Fee with GST
-
Singapore Citizens & Permanent Residents
(39 years and below)
- $650.00
- $58.50
- $708.50
-
Singapore Citizens & Permanent Residents
(40 years and above)
- $650.00
- $58.50
- $708.50
* Note:
- UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
- UTAP support amount to be paid to training provider first and claimed after end of class by learner.
- Singaporeans aged 25 and above can use their SkillsFuture Credit (SFC) to pay. For more details, visit www.skillsfuture.gov.sg/credit.
MySQL
Individuals
-
Singapore Citizens & Permanent Residents
(39 years and below)
-
Course Fee (Before GST)
$650.00 -
GST (Full Course Fee, 9%)
$58.50 -
Course Fee + GST
$708.50 -
Unfunded Course Fee with GST
$708.50
-
Singapore Citizens & Permanent Residents
(40 years and above)
-
Course Fee (Before GST)
$650.00 -
GST (Full Course Fee, 9%)
$58.50 -
Course Fee + GST
$708.50 -
Unfunded Course Fee with GST
$708.50
* Note:
- UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
- UTAP support amount to be paid to training provider first and claimed after end of class by learner.
- Singaporeans aged 25 and above can use their SkillsFuture Credit (SFC) to pay. For more details, visit www.skillsfuture.gov.sg/credit.
Steps to Apply to Claim SFC and Avail UTAP
Not sure how to get started with applying for UTAP support and claiming SFC? Just follow these simple steps:
Step 1: Get enrolled
- Enrol into our MySQL Training.
Step 2: Apply for the SFC claim
- Check out KnowledgeHut’s upcoming schedules and select a workshop on a date convenient to you. An invoice will be issued to you with the fee breakdown.
- Follow this step-by-step process in the MySkillsFuture portal:
a. Login to the MySkillsFuture portal, select the course you’re enrolling into and enter course date and schedule
b. Enter the course fee payable by you (including GST) and enter the amount of credit to claim
c. Upload your invoice and click ‘Submit’
For more details on SkillsFuture Credit and the various approved skills-related courses, visit www.skillsfuture.gov.sg/credit.
Step 3: Apply for the UTAP Support
- Log in to your U Portal account to submit your UTAP application upon completion of the course.
Step 4: Enjoy your course
- Utilise your SFC credits, UTAP support, and skill up!
Need help with checking your funding eligibility?
Prerequisites
Participants must have basic knowledge of RDBMS.
What You Will Learn
1. MySQL Aspects
Deep dive into the detailed aspects of MySQL
2. Create Database
Create your own MySQL databases
3. DML & DDL
Work with DML and DDL commands
4. Analytical SQL Queries
Write analytical SQL queries such as MIN, MAX, AVG, and more
5. Multiple Data Sets
Join data from multiple data sets using JOIN, UNION, and more
6. Data Grouping
Learn the grouping of data and about clauses in SQL
7. Mathematical Functions
Use Mathematical functions for advanced calculations in a database
8. Advanced SQL Features
Solve complex database problems by using advanced SQL features
9. Framework Integration
Integrate MySQL with frameworks such as Node.js, Python, and PHP to create applications
10. Performance Optimization
Optimize the performance of your database by using indexing, trackers, and performing backups
11. Database Results
Order your database results in several forms as per the requirement of the application
12. Indexing Techniques
Optimize the performance of your database through numerous indexing techniques
13. Secure Databases
Secure your databases with the right queries
Who should attend this course?
- Database administrators
- Full-stack developers
- Backend web developers
- Developers, software engineers
- Novices who meet prerequisites
The KnowledgeHut Edge
Instructor-led Live Classroom
Interact with instructors in real-time— listen, learn, question and apply. Our instructors are industry experts and deliver hands-on learning.
Curriculum Designed by Experts
Our courseware is always current and updated with the latest tech advancements. Stay globally relevant and empower yourself with the latest tools and training.
Learn through Doing
Learn theory backed by practical case studies, exercises and coding practice. Get skills and knowledge that can be effectively applied in the real world.
Learn from Top Experts
Learn from the best in the field. Our mentors are all experienced professionals in the fields they teach.
Advance from the Basics
Learn concepts from scratch, and advance your learning through step-by-step guidance on tools and techniques.
SOLID TRACK RECORD
KnowledgeHut has empowered more than 400,000 professionals to get certified across various domains.
MySQL Course Curriculum
Learning objectives
This module introduces you to the world of MySQL, what it is, and about its benefits. Your hands-on introduction to MySQL will start with installing MySQL workbench and then creating a MySQL database that will be used throughout the course. You will then progress to understanding various data types that can be used for storing our data in MySQL. Then you will learn how to set up schema tables by using the CREATE data definition language statement. Learn the distinction between Primary Key and Foreign Key, use Primary Key to the model unique ID of your tables. Next, move to DML queries and learn about INSERT, UPDATE, and DELETE for manipulating data in the DB. Also, learn about data migration by understanding the DROP, ALTER commands. Lastly, learn about CHECK, NOT NULL, and UNIQUE constraints that could be used to add validation to the tables and columns.
Topics
- MySQL and its Use Cases
- Setup MySQL database
- Discuss data types that can be used
- Leverage CREATE TABLE DDL for setting up a schema of tables
- Using Primary Key and Foreign Key constraints
- Insert, Update and Delete for DML operations
- Alter and Drop existing tables
- Adding and examining Constraints on tables
Hands-on
- Leverage CREATE Table DDL for setting up the schema of tables, after learning its basics
- Insert, Update and Delete for DML operations, after learning about how to use Primary Key and Foreign Key constraints
Learning objectives
This module helps you investigate the more detailed aspects of MySQL. First, you will learn to use SELECT to retrieve data by primary key and use SELECT DISTINCT for removing duplicates. You will then learn to filter retrieved data by using the WHERE statement and combine WHERE with multiple conditions. Next, you will learn about using COUNT for retrieving information about the cardinality of data set in the table and leveraging LIMIT for narrowing the resulting data set to first occurrences. You will then learn how to order returned data in ascending or descending order by using ORDER BY ASC or DESC. Finally, you will learn how to use subqueries with IN to specify more complex limits and leverage BETWEEN for two conditions.
Topics
- Select and Select Distinct for removing duplicates
- Leverage Where statement to narrow resulting data set
- Count and Limit for diagnosing and controlling resulting data set
- Specify ordering of retrieved data by using ORDER BY
- Leverage sub-queries with IN and BETWEEN
Hands-on
- Count and Limit for diagnosing and controlling resulting data set, after learning about Count and Limit for diagnosing and controlling resulting data set
- Leverage sub-queries with IN and BETWEEN, after learning their basics
Learning objectives
Start by learning the concepts of MIN, MAX, and AVG for getting statistics about data. You will then learn how to use the GROUP BY statement and use it in the context of aggregating data in a customized manner. Finally, you will learn to filter grouped data by using the HAVING clause with the GROUP BY statement.
Topics
- Getting statistics about data by using MIN MAX and AVG
- leverage GROUP BY to aggregate data in a custom way
- Conditional GROUP BY statements with HAVING clause
Hands-on
- Learn how to get statistics about data by using MIN MAX and AVG, after learning the concepts
- Create conditional GROUP BY statements with HAVING clause, post a conceptual analysis
Learning objectives
This module explains the various SQL statements that are used to join data multiple datasets such as CREATE, JOINs, and more. You will start with the CREATE data definition and reference the primary key from another table to create relationships. Next, you will use INNER JOIN to fetch data from two tables that have a relation. You will use it to only fetch data that is present in both data sets. Next, you will use LEFT and RIGHT join to fetch data from two tables where data is not present in one of those data sources. And finally, you will see the use of FULL OUTER JOIN for joining data when it is not present in both datasets and leverage UNION for finding data sets.
Topics
- Creating tables using primary key references
- INNER JOIN for full joins
- LEFT and RIGHT joins for joining data
- Full Outer Join and Union
Hands-on
- Execute INNER JOIN for full joins
- Implement Full Outer Join and Union real-time
Learning objectives
Learn about advanced SQL features including mathematical functions such as ABS, MOD, FLOOR that are used to calculate data dynamically when retrieving it from tables. You will then learn how to work with text data and how to retrieve it and then move on to using Regular Expressions within SQL. Finally, you will earn how to solve complex SQL problems by using SELF JOIN and use it for multiple lookups on the same table.
Topics
- Perform advanced calculations with mathematical functions
- Operations on String and Text columns
- Leverage Self-Join when needed to join the table with itself
Hands-on
- Perform advanced calculations with mathematical functions once you’re familiar with the concepts
- Practical leveraging Self-Join when needed to join the table with itself
Learning objectives
In this module, you will learn how to use MySQL with different popularly used web applications. You will work with Node.js (Express) application, Python (Django) application, and PHP (Laravel) application and learn how they interact with MySQL.
Topics
Learning objectives
This final module covers what it takes to optimize performance on your database and keep it secure. So, you will start by making your MySQL instance secure, create secure users, and enable encryption. You will learn to use EXPLAIN to understand queries, track performance problems, and learn how to alleviate them. You will understand how to create indexes on the most useful fields, learn how to pick the proper fields for indexing, and use indexing with queries. You will also learn how to use prepared statements both for performance and security reasons and use these prepared statements from code.
Next, you will learn how to make your data safe with backup policies, using backup for recovery, and understanding which log is needed to restart the MySQL DB. Finally, you will understand the performance of complex and huge queries and learn how to decompose them into smaller ones.
Topics
- Securing MySQL
- Track Performance Problems with EXPLAIN
- Use Indexing to improve the performance of search queries
- Prepared Statements as a best MySQL query pattern
- Performing Backups and using Logs
- Decomposition of complex queries into simpler ones
Frequently Asked Questions
MySQL Online Training
The MySQL Online Training course has been thoughtfully designed to make you a skilled MySQL developer ready to take on significant data related roles in top tech companies. At the end of the course, you will be able to:
- Get started with MySQL and learn about the commands and basics
- Deep dive into the detailed aspects of MySQL
- Create your own MySQL databases
- Work with DML and DDL commands
- Write analytical SQL queries such as MIN, MAX, AVG, and more
- Join data from multiple data sets using JOIN, UNION, etc
- Learn the grouping of data and about clauses in SQL
- Use Mathematical functions for advanced calculations in a database
- Solve complex database problems by using advanced SQL features
- Integrate MySQL with frameworks such as Node.js, Python, and PHP to create applications
- Optimize the performance of your database by using indexing, trackers, and performing backups
- Order your database results in several forms as per the requirement of the application
- Optimize the performance of your database through numerous indexing techniques
- Secure your databases with the right queries
The program takes you on a learning journey from the absolute basics and concepts of MySQL, all the way up to setting up a MySQL instance and using MySQL with web-based applications to create robust applications. Whatever your level of expertise – beginner, intermediate, or expert – you will benefit from this course to hone your MySQL skills and become a confident developer.
In addition to training hours, we recommend spending about 2 hours per day every day of the training, to study, practice and achieve optimal benefits from the course.
The MySQL Online Certification course is well suited for UI Developers, Full Stack Developers, Solution Architects, developers, software engineers, and anyone interested to develop interactive user interfaces and web applications using MySQL. Novices too will benefit from this training, provided prerequisites are met.
Basic knowledge of RDBMS is required.
Software Requirements: MySQL Workbench
System Requirements: Any workstation or laptop with at least 8 GB of RAM
Yes! Upon passing the MySQL Online Training, you will receive a signed certificate of completion from KnowledgeHut. Thousands of KnowledgeHut alumni use their course certificate to demonstrate skills to employers and their networks.
More than the certificate, however, you will get to showcase your newly acquired MySQL skills by working on real-world projects and adding these to your portfolio. KnowledgeHut’s Web Development Using MySQL course is well-regarded by industry experts, who contribute to our curriculum and use our tech programs to train their own teams.
Once you have mastered MySQL, you can consider learning the following:
- Node.js
- MongoDB
SkillsFuture Credit
SkillsFuture Credit is an initiative by Singapore Government to encourage Singaporeans to upgrade their skills. Singaporeans can use this credit to pay for different training courses including our Certified Scrum Master course.
All Singaporeans aged 25 and above can apply for the SkillsFuture Credit. For more information on eligibility click here.
No, The SkillsFuture Credit is only provided to individuals to skill up.
SkillsFuture is not a cash account and you will not earn any interest from it.
You can only use the credit to offset course fees for training programs which are approved by SkillsFuture like our Certified Scrum Master training course.
As SkillsFuture is not a cash account, you cannot withdraw cash from this account and pay course fees directly to your Training Partner.
Your course fee will be directly paid to your course provider through MySkillsFuture.
You can reach out to our course counselor for assistance or follow the following steps:
- Login to MySkillsFuture
- Select course and enter course data and schedule
- Enter course fee payable including GST and enter the claim amount
- Upload invoice and click Submit.
UTAP Funding
Union Training Assistance Program (UTAP) is a training benefit provided to NTUC members to minimize training costs. As a result, they are encouraged to enhance their skills and achieve a rewarding career.
UTAP support is provided to NTUC Union members.
NTUC members can get up to 50% unfunded course fee support under UTAP support. The UTAP amount is capped at $250 for participants under 39 years and at $500 for participants above 40 years.
You can reach out to our course counsellors or Log in to your U Portal account to submit your UTAP application upon completion of the course.
The UTAP support amount is paid to the training provider first and can be claimed by the learner only upon course completion.
What learners are saying
The Agile Master's Program by KnowledgeHut exceeded my expectations. The career advancement opportunities are immense, and the increased earning potential is a major plus. The program improved my job performance and gave me greater job security. Worth every penny!
David Thompson
Managers-Software Development
Investing in KnowledgeHut's Project Management Masters Program was a wise decision. The competitive salaries and certification advantage are exceptional. The program's comprehensive curriculum and industry growth insights have given me an edge in the project management field. Ready to tackle challenging projects with confidence!
Sophia Khan
Project Analyst
 The quality of instruction and content surpassed my expectations. The
trainers were not only highly knowledgeable but also had a passion for sharing
their expertise. The case studies and capstone projects were invaluable,
allowing me to apply my knowledge to real-world scenarios. The complimentary
access to the 'Mastering CISSP' course was an added bonus, providing extensive
practice and exam preparation.Â
Mic Brown
Security Analyst
The learning system set up everything for me. I wound up working on projects I've never done and never figured I could.Â
Tyler Wilson
Full-Stack Expert
I successfully transitioned my career I am a SDE who was unhappy with my job. I took a giant leap of faith and transitioned to a Data Science career after completing KnowledgeHut’s Data Science bootcamp. I love the challenges and the paycheck! Thank you Knowledgehut for giving me the confidence that I could do it. All of you who are not too happy with your present role- there's a whole world of opportunity out there. Take the first step.
Eden Knight
Data Analyst
The learn by doing and work-like approach throughout the bootcamp resonated well. It was indeed a work-like experience.Â
Dave Nigels
Full Stack Engineer
I know from first-hand experience that you can go from zero and just get a grasp on everything as you go and start building right away.Â
Madeline R
Developer
Knowledgehut is the best platform to gather new skills. Customer support here is very responsive. The trainer was very well experienced and helped me in clearing the doubts clearly with examples.