MySQL for Beginners DataPilot

MySQL for Beginners — 15 Lessons

About This Course

KTECCAN (ages 10–18) will learn to create, manage, and query databases using MySQL. This course introduces relational database concepts, SQL commands, and best practices for storing and retrieving data, preparing learners for backend development and data management tasks.

What You'll Learn

Database fundamentals
SQL syntax and queries
Table creation and management
CRUD operations
Joining tables and database security

Course Curriculum

Curriculum

Lesson 1: Introduction to Databases 1 week

What is a database
Relational vs non-relational databases
Setting up MySQL

Lesson 2: SQL Basics 1 week

SELECT, FROM, WHERE
Filtering and sorting
Basic queries

Lesson 3: Creating Databases & Tables 1 week

CREATE DATABASE
CREATE TABLE
Data types

Lesson 4: Inserting Data 1 week

INSERT INTO
Inserting multiple rows
Best practices

Lesson 5: Updating & Deleting Data 1 week

UPDATE statements
DELETE statements
Data integrity considerations

Lesson 6: Selecting Data 1 week

Filtering with WHERE
Sorting with ORDER BY
LIMIT clauses

Lesson 7: Joining Tables 1 week

INNER JOIN
LEFT & RIGHT JOIN
Practical examples

Lesson 8: Aggregation & Grouping 1 week

COUNT, SUM, AVG
GROUP BY
HAVING clauses

Lesson 9: Subqueries 1 week

Using subqueries
Nested SELECT statements
Practical examples

Lesson 10: Indexes & Keys 1 week

Primary and foreign keys
Creating indexes
Data integrity

Lesson 11: Views & Stored Procedures 1 week

Creating views
Using stored procedures
Practical exercises

Lesson 12: Transactions & Security 1 week

ACID principles
COMMIT & ROLLBACK
User privileges

Lesson 13: Functions & Operators 1 week

String, numeric, date functions
Operators
Query examples

Lesson 14: Data Import & Export 1 week

Importing CSV
Exporting data
Backup best practices

Lesson 15: Final Project & Review 1 week

Building a small database application
Query practice
Presentation

Meet Your Instructor

David Johnson

Senior Game Developer & Educator

4.7 (128 reviews)

David has over 10 years of experience in game development and has taught coding to kids for the past 5 years. He specializes in making complex concepts accessible and fun for young learners.

600+

Students

12

Courses

Frequently Asked Questions

What software or tools will my child need for this course?

A PC running on at least Windows 10 or above, Visual Studio Code/Sublime Text 3, Replit, Chrome/Firefox Browser, XAMPP, MySQL WorkBench

How much time should my child dedicate to this course each week?

We recommend 1-2hrs hours per week for live sessions and an additional 1-2 hours for practice and projects. The course is designed to be flexible to accommodate school schedules.

What if my child misses a live session?

All live sessions are recorded and available for students to watch later. We also provide additional support through our online community and one-on-one help sessions.

Does my child need any prior coding experience?

No prior experience is necessary! This course is designed for complete beginners. We start with the very basics and gradually build up to more complex concepts. However, some courses have prerequisites.

What kind of support is available during the course?

Students receive support through multiple channels: live Q&A during sessions, a dedicated student community, email support, and optional one-on-one tutoring sessions if needed.

₦65000.00

Limited time offer for new students

3months of instruction
15 live sessions
2 Project-based learning
Certificate of completion
Access to student community
Lifetime access to materials

Enroll Now Chat with Us

Course Includes

15 Live Sessions

Downloadable Resources

Hands-on Projects

Completion Certificate

MySQL for Beginners