What is MySQL?

MySQL is one of the world’s most popular database management systems based on Structured Query Language (SQL). It is an open-source and reliable database, compatible with large web applications and online publishing providers. MySQL allows simple and cost-effective management of large amounts of information.

About the course
 
The course introduces MySQL to beginners without prior knowledge about SQL. Learners will be able to identify its features and uses, understand relational database basics, and build a database by the final training day. Beginners can easily use it and gain advanced skills within a few weeks.
 

Audience:
Data Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 4 Days, 32 Academic Hours

Course Syllabus:

Day 1
Introduction to MySQL

• Course Goals
• Course Lesson Map
• Classroom Environment
• MySQL Overview
• MySQL Community Resources
• MySQL Client/Server Model
• MySQL Connectors
• Installation of the MySQL server
• Starting and stopping the MySQL server
• Using the MySQL client
• MySQL Workbench
• Querying Table Data
• The SELECT Statement
• Query Data From An Application
• Troubleshooting Problems
• Data Types
• Data Types as Part of Database Design
• Numeric Data Types
• Temporal Data Type
• String Data Types
• Character Set and Collation Support
• Data Type Considerations
• The Meaning Of NULL

Day 2
Functions, Queries

• Functions in MySQL Expressions
• Using Functions
• String Functions
• Date And Time Functions
• Numeric Functions
• Aggregate Functions
• Spaces in Function Names
• RANK Window Functions
• Joins and Unions
• Querying Multiple Tables
• Joining Tables with SELECT
• Inner Joins
• Outer Joins
• Table Name Aliases
• Combining Multiple Queries with UNION
• Subqueries
• Nesting Queries
• Writing Simple Subqueries
• Writing Complex Subqueries

Day 3
Creating Databases and Tables

• Creating a Database
• Creating a Table
• Showing How a Table Was Created
• Column Options
• Table Options
• Copying an Existing Table Structure
• Confirming the Creation of a New Table
• Copying an Existing Table Structure
• Creating a Temporary Table
• Indexes, Keys, and Constraints
• Deleting Databases and Tables
• Adding, Removing and Modifying Table Columns
• Adding, Removing and Modifying Indexes and Constraints
• Modifying Table Data
• Inserting Records
• Replacing Existing Records
• Updating Existing Records
• Deleting Records
• Exporting and Importing A Script
• Multistatement Transactions
• Modifying Data From An Application

 
Day 4
Securing Your Database

• Layers of Security
• Creating Users
• Creating Roles
• Assigning Privileges to Users And/Or Roles
• Creating Views to Control Access
• Backing Up Your Database
• Importance Of Backups
• Creating a Backup
• Options for Backup
• Restoring a Backup
• JSON
• JSON Use Cases
• Retrieving Data From JSON Columns
• Creating a JSON Column
• Inserting Data Into a JSON Column
• Updating a JSON Column
• Conclusion
• Course Goals
• Resources
• Evaluation

Our international certified trainers have highly experienced Microsoft Power BI practitioners who have real-world expertise.

I – Laptops will be provided for all candidates with pre-installed

II – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of a place on the course).

For more information on our training, please enquire using the form above or call +2348103382376