MySQL training
Learn MySQL for data analytics. Get familiar with MySQL workbench, relational database, SQL queries and more.
Our Learning Process
Get valuable data and business analytics skills from anywhere without breaking the bank. Physical or online classes available.
Register
Select a course from the list and register by making necessary payments
Live Classes
Join the Physical or online classes every week and take advantage of our small class size
Case Studies
Build real projects during the sessions and get familiar with the tools
Capstone Projects
Complete a project of your choice to demonstrate mastery of the tools
what is MySQL?
MySQL is an open source relational database management system (RDBMS). SQL is an abbreviation for Structured Query Language. It is widely used to manage databases and servers. As a data analyst in a large corporation, chances are that you would work on one or more MySQL databases
MySQl Training Outline
Module 1: Introduction to SQL
Introduction to SQL
Basic SQL terminologies and definition of terms
Setting up MySQL
Creating and populating a MySQL DB using DDL, DML
SQL best practice (Understanding ER diagrams and Schemas).
Loading the database with external datasets
Some Basic Queries
Module 2: SQL Select, Limit, where, operators & more
SQL Select Statement
SQL Where Statement
SQL Limit Statement
SQL Comparison Operators
SQL Logical Operators
SQL Like/in/Between
SQL AND/OR
SQL NOT
SQL Order by
Module 3: SQL Sum, Avg, Group & more
SQL Sum
SQL Min/Max
SQL Avg
SQL Group by
SQL Having
SQL Distinct
SQL Joins
SQL Union
Module 4: SQL Sub queries, views & projects
SQL Subqueries
SQL Select Subquery
SQL Where Subquery
SQL From Subquery
SQL Views
SQL with other Data analytics tools
Putting it all together
Physical Training
Learn in 4 sessions (3-4 hours each)
Introduction, Queries, Select, Union, Joins and more
Frequently Asked Questions
Get in touch with us for any enquiries you might have
MySQl is easy to learn once you have a good tutor.
You can get a data entry role in IT, Hospitality, Healthcare and more
16 hours of learning at our academy
A non IT person can learn MySQL easily as the statements can be easily understood
4 Sessions (3-4 Hours each)
you can reach us via WhatsApp on +2347055247562, via email parachcomputers@gmail.com
Get in touch
Reach out to us using any of these channels