Next course begins April 15th

MySQL Fundamentals

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.

What you'll learn

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.

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.

Course Content

  • 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
  • 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
  • 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
  • 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

Upcoming Dates

LocationDatePrice
OnlineApril 15th, 2024₦200,000
LagosMay 13th, 2024₦300,000
LagosJune 10th, 2024₦300,000

Delivery Methods

Classroom Training

Unlock your potential with our classroom training courses. Our portfolio of business intelligence training courses are delivered by BI experts across Africa.

Online Training

Our online trainings (live instructor-led) are delivered by certified instructors and are designed to replicate a classroom experience which enables full interactions.

Onsite Training

Our onsite training team allows us to bring our skills and expertise to you. Onsite courses are developed in conjunction with you, ensuring your expectations are exceeded.

1-to-1 Training

With our one-to-one training you’ll not only receive the undivided attention of the trainer, but one-to-one training allows you to tailor the training to your specific needs.

From ₦300,000

Certification

Refreshments

Training multiple people?

Empower your teams with business intelligence training courses delivered by subject matter experts.

Apply for MySQL Fundamentals

Which date are you interested in?

Apply for MySQL Fundamentals

Which date are you interested in?