BE—02 — Back-end & data
MySQL & MySQLi
Where the data lives. Pairs directly with the PHP course — take them together if you can.
- LevelIntermediate
- Length3 weeks
- FormatLive, one-on-one or group
- WherePort Harcourt or online
Who it's for
Is this the right course for you?
Anyone storing data — and anyone who has ever been nervous about a live database.
What you need before starting
Basic PHP or another programming language.
What's included
- MySQL locally
- A database client
- A practice dataset to break and fix
- Live sessions, not recorded video
- Exercises between every session
- A channel where you can paste an error and get an answer
- Your project in your own GitHub
- A certificate on completion
The syllabus
Everything we cover, in order
Sessions build on each other. Nothing is introduced before you have what it depends on.
-
01
Designing tables and choosing column types
-
02
SELECT, INSERT, UPDATE, DELETE in anger
-
03
Joins across related tables
-
04
Indexes and why a query suddenly gets slow
-
05
Prepared statements, and how SQL injection actually happens
-
06
Transactions for operations that must not half-finish
-
07
Backups, and testing that you can restore one
How it runs
From enquiry to certificate
Send the form
Tell us the course, the format you want and when you're free. We reply within one business day with dates and the fee.
Setup session
Before session one we get your machine working — editor, runtime, accounts. Nobody loses a week to installation problems.
Live sessions
3 weeks of scheduled live teaching, with exercises in between and a channel for questions that can't wait.
Project and certificate
You finish the project, it goes into your own GitHub, and you get a certificate. Strong work also gets a reference from us.
Take it further
What people usually take next
Ready to start MySQL & MySQLi?
The form takes two minutes. Nothing is charged at this stage, and we'll tell you honestly if a different course would suit you better.