CPD-accredited courses from £39 · Instant e-certificates · 2,700+ courses
CPD-accredited certificates 020 4618 6402 Team training
Home / Courses / IT and Software / The Complete MySQL Server from Scratch: Bootcamp
CPD course All Levels

The Complete MySQL Server from Scratch: Bootcamp

4.9 (18 ratings) 5 enrolled 8h 2m of learning Updated Nov 2026
CertificateOn completion
8h 2mSelf-paced
52 lessonsOn the UISC learning portal
All LevelsNo prior training needed

Course curriculum

1 modules 52 lessons 8h 2m total
01 The Complete MySQL Server from Scratch: Bootcamp 52 lessons
  1. Introduction
  2. Course Curriculum Overview
  3. Overview of Databases
  4. MySQL Installation
  5. MySQL Workbench Installation
  6. Connecting to MySQL using Console
  7. Overview of Challenges
  8. SQL Statement Basic
  9. SELECT Statement
  10. SELECT DISTINCT
  11. Column AS Statement
  12. COUNT built-in Method usage
  13. SELECT WHERE Clause – Part One
  14. SELECT WHERE Clause – Part Two
  15. SQL ORDER BY Statement
  16. SQL Limit Clause Statement
  17. SQL Using BETWEEN with Same Column Data
  18. How to Apply IN Operator
  19. Wildcard Characters with LIKE and ILIKE
  20. Overview of GROUP BY
  21. Aggregation function SUM()
  22. Aggregation MIN() and MAX()
  23. GROUP BY – One
  24. GROUP BY – Two
  25. HAVING Clause
  26. Overview of JOINS
  27. Introduction to JOINS
  28. AS Statement table
  29. INNER Joins
  30. FULL Outer Join
  31. LEFT Outer JOIN
  32. RIGHT JOIN
  33. Union
  34. Timestamps
  35. EXTRACT from timestamp
  36. Mathematical Functions
  37. String Functions
  38. SUBQUERY
  39. Basic of Database and Tables
  40. DataTypes
  41. Primarykey and Foreignkey
  42. Create Table in SQL Script
  43. Insert
  44. Update
  45. Delete
  46. Alter Table
  47. Drop Table
  48. NOT NULL Constraint
  49. UNIQUE Constraint
  50. Creating a Database backup
  51. 10a Overview of Databases and Tables
  52. 10c Restoring a Database

About this course

The Complete MySQL Server from Scratch: Bootcamp Course teaches you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showcase your achievement in professional life. This The Complete MySQL Server from Scratch: Bootcamp Course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it.

To become successful in your profession, you must have a specific set of skills to succeed in today’s competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills.

The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease.

  • Accredited by CPD
  • Instant e-certificate
  • Fully online, interactive course with audio voiceover
  • Self-paced learning and laptop, tablet, smartphone-friendly
  • 24/7 Learning Assistance
  • Discounts on bulk purchases

Who should take the course

Anyone with a knack for learning new skills can take this The Complete MySQL Server from Scratch: Bootcamp Course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions.

Certification

Once you’ve successfully completed your course, you will immediately be sent a digital certificate. All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Accreditation

All of our courses, including this The Complete MySQL Server from Scratch: Bootcamp Course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.

Course Curriculum

The detailed curriculum outline of our The Complete MySQL Server from Scratch: Bootcamp Course is as follows:

The Complete MySQL Server from Scratch: Bootcamp

  • Course Introduction
  • SQL Environment Setup
  • SQL Statement Basics
  • GROUP BY Statements
  • JOINS
  • Advanced SQL Commands / Statements
  • Creating Database and Tables
  • Databases and Tables

Your certificate

CPD certificate — download it when you finish

Issued the moment you complete the final module. Every certificate lists the course aims and objectives, anticipated learning outcomes, the quality-assurance process — the elements required for verifiable CPD. Non-registrants can use it as CQC training evidence and for appraisals.

Aims & objectives Learning outcomes Unique certificate number

Learner ratings

4.9

Rated by 18 learners on the UISC learning portal · 5 enrolled

Common questions

Where do I take the course?

On the UISC learning portal. "Enrol now" takes you to this course there, where you pay securely, get your login and study at your own pace. Your certificate is issued there when you finish.

When can I start?

Immediately. Access opens the moment your order is confirmed and you can learn from any device, in any order, as many times as you like.

How is the course assessed?

A short multiple-choice or scenario-based assessment at the end of the course with instant results. You can retake it as many times as you need at no extra cost.

Can I enrol my whole team?

Yes. Organisations can buy multiple places on one invoice and receive a training record for every learner. Contact us for team pricing.

Keep learning

Related courses

More in IT and Software
Stock Trading
Save 86%
10 lessons
IT and Software 4h 2m

Stock Trading

16 others bought this course in the last 24 hours! Stock Trading teaches you everything on the topic thoroughly from scratch so you can achieve a professional c...

4.9 (8) 6 enrolled
£39.00 £279.00
Enrol now
£39.00 8h 2m · All Levels
Enrol now