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.
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 Order by
Module 3: SQL Sum, Avg, Group & more
SQL Group by
Module 4: SQL Sub queries, views & projects
SQL Select Subquery
SQL Where Subquery
SQL From Subquery
SQL with other Data analytics tools
Putting it all together
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 email@example.com
Get in touch
Reach out to us using any of these channels