Short course on MySQL Regular Course Price: £300.00   
Total Duration: 10 Hours
Course level: Beginner
Delivery Method: Instructor Led Online Training
Certification: Certificate of Completion will be provided after completing the course

Course Overview:

MySQL is one of the most popular database management system. You will learn how to install MySQL and create a database from scratch from this instructor led, hands-on classroom based training. Our MySQL Database for Beginners course covers all the basics syntax and SQL statements to create, insert, update, delete data and manage tables.

This course is also very useful for the Web Developer to build MySQL database driven websites. It is also a prerequisite course to attend our PHP courses.

Following topics are included in this course:

  • Introduction of Database
  • Introduction of MySQL
  • SQL: DDL
  • SQL: DML
  • SQL: DCL
  • JOIN
  • SUBQUERY


Skills Required

No existing knowledge of SQL or MySQL is required. You should have basic experience of using computers and web browsers. This includes:
  • able to use keyboard and mouse
  • know how to create, save, move and rename files

If you do not have basic computer and Internet skills then we highly recommend you to attend our Computer Basics for Absolute Beginners course before attending this course.

Course Dates, Prices & Enrolment

There is no set date for this course. Please complete the booking request form below.

Full Course Outline

  1. Introduction of Database
    • Data model
    • Relational Model
    • Relational Keys
    • Integrity Constraints
  2. Introduction of MySQL
    • Why MySQL?
    • Working with MYSQL Using phpMyAdmin
    • Installation
    • Types of tables
    • Datatypes and attributes
    • Security
    • Users
  3. SQL: DDL
    • CREATE
    • ALTER
    • DROP
    • TRUNCATE
  4. SQL: DML
    • INSERT
    • UPDATE
    • DELETE
    • SELECT
  5. Querying Data with SELECT
    • Basic SELECT statement
    • Using WHERE clause
    • Using IN operator
    • Using BETWEEN clause
    • Using NOT
    • Logical operators
    • Using Wildcards
    • Using Functions
    • ORDER BY
    • GROUP BY
    • HAVING
  6. Indexes and Constraints
    • Introduction to Indexes
    • Introduction to Constraints
    • Primary Keys
    • Foreign Keys
    • Unique Constraints
  7. Joining Multiple Tables
    • Simple Join
    • Outer Join
    • Inner Join
    • Self Join
  8. Subquery
    • Introduction to subqueries
    • Using subqueries
    • Subqueries and joins
  9. Views
    • Introduction to Views
    • Creating views
    • Updating views
  10. Back Up and Restore
    • Backup MySQL Databases
    • Restoring a MySQL dump

Booking Request

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

  • book a course on different dates
  • book for a group of delegates
  • book corporate training
  • book a customised training
  • book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:

You must need to Register / Sign In first to submit this booking request form.

Course Tutors

The course instructor is a Global Technocrat with years of extensive experience in Teaching, setting up and heading Business Operations, Corporate Planning, Projects in the IT sector in both Domestic and International Markets.

Newsletter Sign-up

Have a Question?