Beplugged Tech — home
All courses
Oracle

MySQL for Application Development

Three days on MySQL for developers and analysts: database design, writing efficient queries, stored procedures, user management, backup and replication. MySQL is the database behind most web applications and many business systems; this course teaches it from the application developer's perspective.

Duration
3 days
Level
Beginner
Delivery
In Pretoria, at your offices, or live online
Group size
Individuals or whole teams
What you will learn
  • Design normalised database schemas for applications
  • Write efficient SELECT, INSERT, UPDATE and DELETE statements
  • Use joins, indexes and EXPLAIN to optimise queries
  • Create stored procedures and triggers for business logic
  • Manage users, backups and basic replication
Course outline
  1. 1Database design. Requirements to tables: normalisation, keys, relationships and ER diagrams.
  2. 2SQL queries and manipulation. SELECT, joins, subqueries, INSERT, UPDATE, DELETE and transactions.
  3. 3Stored procedures, indexes and performance. Creating stored procedures, triggers, indexes and reading EXPLAIN output.
Who it is for

Web developers, application developers and analysts who build on or query MySQL databases.

Before you start

Some programming experience. No prior database experience needed.

How the training runs
  • In person in Pretoria, South Africa; at your offices anywhere; or live online on Microsoft Teams or Google Meet.
  • International delegates are welcome in Pretoria — we arrange invitation letters for visa applications and recommend hotels near the venue.
  • Run for your team only, on dates that suit you, with examples from your own work; or join an open course.
  • Hands-on throughout: learners practise each step on their own device, not just watch.
  • A certificate of completion that can be verified online.
Questions
Where is the training held?

At your offices anywhere in South Africa or at our training centre in Pretoria. For international delegates, we arrange training in Pretoria with joining instructions and hotel recommendations. Live online delivery on Microsoft Teams or Google Meet is also available.

Do you train organisations outside South Africa?

Yes. We work with organisations across Africa and beyond. International delegates can attend in person in Pretoria, South Africa, or join live online. We arrange invitation letters for visa applications and handle all logistics.

Can the course be run for our team only?

Yes. Most courses are run in-house for one organisation, on dates that suit you, with examples from your own work. Larger teams are split into groups.

What do learners receive?

A Beplugged Tech certificate of completion that anyone can verify online. Where a course prepares for a certification exam (Certiport, Microsoft, Oracle, Google), the exam can be arranged at our testing centre or through the certification body.

How do we book, and what does it cost?

Send the enquiry form on this page with the number of people and your preferred dates. We reply within one working day with dates, the full outline and a quote.

Related courses