TRY FOR FREE ENROL NOW
ENROL NOW

Course Highlights

Live and interactive sessions with personalized guidance from experienced web development experts.

Learn at your own pace with 31 on-demand videos, 7 sets of flashcards, and 7 interactive eBooks.

Guided hands-on exercises help you gain confidence and get productive from the get-go.

Test your subject matter comprehension with auto-graded assessments and reinforce your learning with recall quizzes.

While you learn, build, and deploy real-world projects that you can speak about in job interviews.

Benefit from the limitless educational possibility that comes with lifetime access. The entire courseware and all the features of our immersive learning experience platform will remain at your fingertips for whenever you wish to refresh concepts and clear your doubts.

Immersive Learning

LEARN BY DOING

Build real-world projects in a preconfigured development editor inbuilt into your learning space and practice with guided hands-on exercises.

GET MICRO “WORK-LIKE” EXPERIENCES

Work-like scenarios bring in purpose, autonomy, and context to get you project-ready and experience how it is to work in tech.

GAIN INSIGHTS. DRIVE OUTCOMES.

Advanced insights help you achieve skill-based outcomes from our state-of-the-art immersive learning experience platform.

Develop the skills to move fast and stay ahead.

Outcome-Driven-Learning

Outcome-driven Learning​

Achieve skill-based outcomes from our state-of-the-art immersive learning experience platform.​

Advanced-Analytics

Advanced Insights​

Get a quantified view of your team’s skills and put the right people on the right jobs.​​

Work-like-Experiences

“Work-like” Experiences​

Contextual learning crafted around real-world problem-solving in tech companies.​​

Blended-Learning

Blended Learning​

Get the best of both worlds with live instructor-led training and the flexibility of e-learning.​

Training-by-Practitioners

Training by Practitioners​

Learn from the real-world experience of globally renowned and accredited industry experts.​

Outcome-Driven-Learning

Outcome-driven Learning​

Achieve skill-based outcomes from our state-of-the-art immersive learning experience platform.​

Advanced-Analytics

Advanced Insights​

Get a quantified view of your team’s skills and put the right people on the right jobs.​​

Work-like-Experiences

“Work-like” Experiences​

Contextual learning crafted around real-world problem-solving in tech companies.​​

Blended-Learning

Blended Learning​

Get the best of both worlds with live instructor-led training and the flexibility of e-learning.​

Training-by-Practitioners

Training by Practitioners​

Learn from the real-world experience of globally renowned and accredited industry experts.​

prerequisites

Prerequisites

  • Basic knowledge of RDBMSs

Course Schedules

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:

  • MySQL Application with Node.js (Express)
  • MySQL Application with Python (Django)
  • MySQL Application with PHP (Laravel)

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

For the final capstone project, you are required to build a Database for the store which sells products to only its elite members from different parts of the world. You need to create Table schemas for – stock, purchase, products available and store members. Making use of Primary Key and Foreign key concepts you will reference these tables with each other. In this process, you will learn how to JOIN tables, use GROUP BY, ORDER-BY and aggregate functions to get the desired results required by the store manager.

corporate-training

Enterprise

Empower your tech teams to drive results

Talk to a Learning Advisor to help you build tech skills where you need it.

SKILL UP YOUR TEAMS

Frequently Asked Questions

The MySQL workshop at KnowledgeHut is delivered through PRISM, our immersive learning experience platform, via two modes of delivery:  

Blended learning:  

  • Get the best of both worlds with live and interactive instructor-led training sessions along with the convenience and flexibility of self-paced learning.  
  • Listen, learn, ask questions, and get all your doubts clarified from your instructor, who is an experienced practitioner.  
  • You also get to collaborate and learn from the experience of your peers in real-world simulations and activities. 

On-Demand Self-Learning:  

Learn conveniently at your own pace, whenever and wherever you choose. Spend as much time as you need to on areas or topics that you find most difficult, pausing and replaying relevant segments of video as often as you need to. Benefit from the limitless educational possibility that comes with lifetime access. The entire courseware and all the features of our immersive learning experience platform will remain at your fingertips whenever you wish to refresh concepts and clear your doubts. 

The MySQL course is delivered by leading practitioners who bring current best practices and case studies from their experience to the live and interactive training sessions. The instructors are industry-recognized experts with more than 10 years of experience in MySQL and database management. 

Not only will they impart knowledge of the fundamentals and advanced concepts, but they will also provide end-to-end mentorship and hands-on guidance on real-world projects. 

Our workshops are structured in three parts – pre-workshop, workshop and post-workshop – to provide you with a completely immersive learning experience. This tried and tested workshop structure has worked well with thousands of engineers we’ve helped upskill over the years. 

  1. Pre-workshop: Take our diagnostic assessment before the workshop and benchmark your skill levels at the start of the course. This allows you to map and demonstrate your skills learning progression as you reach the end of the course.  
  2. Workshop: Join the live and interactive instructor-led sessions right from within PRISM, our immersive learning experience platform with a state-of-the-art intelligent coding environment. Experience immersive learning with cloud labs, guided hands-on exercises, assignments, auto-graded assessments, recall quizzes, real-world projects and much more. 
  3. Post-workshop: We don’t just impart skills but also want to make sure that you implement them post the course. To help you with this, we are always in touch with you through newsletters, webinars or next version trainings. Some post-training deliverables lined-up for you are: 
  • Practice Labs 
  • Instructor-led session recordings 
  • Project assistance with mentor 
  • Access to alumni network 
  • Continued social learning with discussion forums, group messenger and one-to-one messaging. 
  • Additional workshops on advanced level concepts 
  • Regular emails, blogs, articles, emails, newsletters, tutorials and other such rich informational content. 

A unique feature of our MySQL course is the highly engaging, immersive learning you experience. You get to learn, practice, assess, get insights on your learning, and personalize your learning journey. 

  • LEARN: Engaging self-learning videos, smart flashcards, interactive eBooks and recall quizzes help reinforce your learning. You also get to maximize your learning potential with collaborative social learning via discussion forums and group and one-to-one messaging. 
  • PRACTICE: Access our Playground Labs during and after the course. Guided hands-on exercises will help you gain confidence and get productive from day one. 
  • ASSESS: Assess your skills at every stage with a variety of questions ranging from multiple choice to code-based, completely auto-graded by the system. Assignments and projects within our inbuilt and intelligent development environment give you micro “work-like” experiences. Test your subject matter comprehension through diagnostic, module level and final assessments. 
  • GET INSIGHTS: Based on your performance in the assessments, assignments, and projects, you gain deep insights on your progress, which help you identify areas you are good at and where you need to improve. All you need to do is follow recommendations and enhance your skill proficiency from where you are to where you want to get.  

PRISM is KnowledgeHut’s state-of-the-art learning experience platform. PRISM is designed to provide a highly engaging, immersive learning experience with you at the center of the learning. Key features of the platform include: 

  1. PRISM supports all types of courses, including on-demand self-paced learning, blended learning, and live virtual classes.  
  2. Learners can watch videos, join live sessions directly, and even book 1 - 1 mentoring sessions with expert instructors easily, using a single dashboard. 
  3. Integrated Practice Environment runs directly in the user’s browser, offering a complete set of development tools to allow learners to practice what they’ve learned.  
  4. Feature-rich videos with detailed explanations are augmented by flash cards, interactive e-reading content and quick recall quizzes designed to strategically reinforce learning.  
  5. Diagnostic assessments give learners valuable insights into their understanding and knowledge before they begin the course, allowing them to map and demonstrate their skills learning progression as they reach the end of the course.  
  6. Learners get micro work-like experiences from auto-graded projects that help them learn on the job, much like developers in leading tech companies.  
  7. Integrated Cloud Labs allow students to instantly spin up dedicated cloud server environments like virtual machines with full access to set up and develop software and code. This one-click development environment offers desktop-class development capabilities and 100% flexibility.   
  8. Social Learning tools include a discussion board that features questions posted by other learners on the system and responses by both mentors and learners. Additionally, one-to-one and group messaging is also available.  
  9. Full-Featured adaptive assessments are available to organizations to create and administer assessments and online tests utilizing both pre-built and custom question banks.  
  10. Comprehensive reports give both organizations and learners a deep and thorough insight into skills progression. 
  11. Learners get “work-like” experiences through production-grade experiences while performing micro-credential assignments and building real-world projects.  

Our MySQL workshops are currently held online and anyone with a stable internet from anywhere across the world can benefit from this to skill up in MySQL. 

Schedules for our upcoming workshops in MySQL can be found here - https://www.knowledgehut.com/database/mysql/schedule  

Yes, Cloud/Practice Labs in a preconfigured development editor inbuilt into your learning space will be available for your guided hands-on exercises, assignments and practice during and post the training.  

The playground labs are low-friction sandbox environments, offering the ability to get started without any installations in your local system. We have tried hard to ensure that practice labs simulate the developer experience. These in-browser solutions feature environments for working with all kinds of platforms including operating systems, coding languages, and more. 

The goal is to provide you with sandbox environments where you can feel free to run any command and experiment without the guidelines of a typical lab. The end goal is to increase the amount of practical, real-world experience you gain to get you completely work-ready on course completion. 

You will be granted 200 to 300 hours of access to the Cloud labs where you can perform all your assignments and projects including the capstone project.  

Post the training, you will retain access to the platform, the learning material and any unutilized hours on the Cloud labs. The entire courseware and all the features of the platform, along with the unutilized hours will be available to you for life.  

Should you need additional hours of practice on the Cloud labs, these will be available for purchase as well. 

We currently use the Zoom platform for video conferencing and will soon be adding more integrations with Webex and Microsoft Teams. However, all the sessions and the recordings will be available right from within our learning platform. Learners will not need to wait for any notifications or links or install any additional software.  

You will receive a registration link from PRISM to your e-mail id. You will have to set your password, log in to our Immersive Learning Experience platform and start your learning journey.  

Yes, there are other participants who actively participates in the class remotely.  They can attend online training from office, home, or any other suitable place. 

In case of any queries, our support team is available to you 24/7 via the Help and Support section on PRISM. You can also reach out to your workshop manager on your workshop group messenger. 

If you miss a class, you can access the class recordings from PRISM at any time. At the beginning of every session, there will also be a 10-12 minute recapitulation of the previous class.  

Unlimited number of attempts are permitted for quizzes. Assignments can be retaken for the specified number of attempts. 

Should you have any more questions, please email us on support@knowledgehut.com and we will be happy to get back to you. 

At KnowledgeHut, we always strive to maintain the highest standards of quality, so that your learning experience with us is beyond reproach. However, if for any reason your expectations are not met, please note our Cancellations and Refund policy as follows: 

  • Cancellation: In case you are unable to attend the course and want a refund prior to the course commencement date, we will be happy to give you back the full amount. 
  • Withdrawal: If you want to discontinue within the first two hours, we will still proceed with the 100% refund, absolutely no questions asked! 
  • Transfer: However, once you have completed 50% of the training, you will not be eligible for any refund. If for any reason you are unable to continue the course after having completed 50% of the training, we would be happy to accommodate you in a different batch of the same course, at no cost. 

Note: All refunds will be credited back to your account within 10-15 business days of the refund request. 

Yes, you can switch your start date with prior notice of at least 24 hrs and subject to availability in the desired batch. 

Yes, we have a 100% money-back guarantee in line with our Cancellations and Refund policy as follows: 

  • Cancellation: In case you are unable to attend the course and want a refund prior to the course commencement date, we will be happy to give you back the full amount. 
  • Withdrawal: If you want to discontinue within the first two hours, we will still proceed with the 100% refund, absolutely no questions asked! 
  • Transfer: However, once you have completed 50% of the training, you will not be eligible for any refund. If for any reason you are unable to continue the course after having completed 50% of the training, we would be happy to accommodate you in a different batch of the same course, at no cost. 

Note: All refunds will be credited back to your account within 10-15 business days of the refund request. 

Yes, we have scholarships available for students and veterans with grants that can vary up to 50% of the course fees. 

To avail scholarships, please get in touch with us at support@knowledgehut.com. The team shall send across the forms and instructions to you. Based upon the responses and answers that we receive, our panel of experts take a decision on the Grant. The entire process could take about 7 to 15 days

By registering in groups, you can save up to 30% on the course fees. The discount you can avail will depend on your group size. 

  • 2 to 4 learners: 20% discount 
  • Above 4 learners: 30% discount 

Yes, installment options are available for payment of course fees. To avail the installment option, please get in touch with us at support@knowledgehut.com. The team will explain how the instalments work and provide timelines for your case. 

Usually, the number of installments vary from 2 to 3, but the full amount must be paid before you complete the course. 

VIEW MORE

What Learners are saying

  • 5/5

Apr, 2020

The KnowledgeHut course covered all concepts from basic to advanced. My trainer was very knowledgeable and I really liked the way he mapped all concepts to real world situations. The tasks done during the workshops helped me a great deal to add value to my career. I also liked the way the customer support was handled, they helped me throughout the process.

Nathaniel Sherman

Hardware Engineer.

verified-learner
Verified Learner
  • 5/5

Apr, 2020

KnowledgeHut is a great platform for beginners as well as experienced professionals who want to get into the data science field. Trainers are well experienced and participants are given detailed ideas and concepts.

Merralee Heiland

Software Developer.

verified-learner
Verified Learner
  • 3/5

Jun, 2020

I would like to thank the KnowledgeHut team for the overall experience. My trainer was fantastic. Trainers at KnowledgeHut are well experienced and really helpful. They completed the syllabus on time, and also helped me with real world examples.

Elyssa Taber

IT Manager.

verified-learner
Verified Learner
  • 5/5

Apr, 2020

Everything was well organized. I would definitely refer their courses to my peers as well. The customer support was very interactive. As a small suggestion to the trainer, it will be better if we have discussions in the end like Q&A sessions.

Steffen Grigoletto

Senior Database Administrator

verified-learner
Verified Learner
  • 5/5

Jan, 2020

I would like to extend my appreciation for the support given throughout the training. My special thanks to the trainer for his dedication, and leading us through a difficult topic. KnowledgeHut is a great place to learn the skills that are coveted in the industry.

Raina Moura

Network Administrator.

verified-learner
Verified Learner
  • 5/5

May, 2020

The teaching methods followed by Knowledgehut is really unique. The best thing is that I missed a few of the topics, and even then the trainer took the pain of taking me through those topics in the next session. I really look forward to joining KnowledgeHut soon for another training session.

Archibold Corduas

Senior Web Administrator

verified-learner
Verified Learner
  • 5/5

Aug, 2020

The hands-on sessions helped us understand the concepts thoroughly. Thanks to Knowledgehut. I really liked the way the trainer explained the concepts. He was very patient and well informed.

Anabel Bavaro

Senior Engineer

verified-learner
Verified Learner
  • 5/5

Feb, 2020

I was impressed by the way the trainer explained advanced concepts so well with examples. Everything was well organized. The customer support was very interactive.

Estelle Dowling

Computer Network Architect.

verified-learner
Verified Learner
VIEW MORE
Course Advisor
View Schedules