Short course on MySQL Course Price: £125.00 excl. VAT (£150.00 incl. VAT)
Total Duration: 5 Hours
Course level: Beginner
Delivery Method: Instructor Led Classroom 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

Training MethodDatesPrice (incl. VAT) 
Classroom Training 24 Jun 2019 - 24 Jun 2019
Monday
£150Enrol Now
Classroom Training 16 Sep 2019 - 16 Sep 2019
Monday
£150Enrol Now
  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. SQL: DCL
    • COMMIT
    • ROLLBACK
  6. JOIN
  7. SUBQUERY

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.

Save Money with Packages

SAVE more than 15% by booking this course with other related courses as shown below:

Web Design Immersive

£780 (save £150)

This package combines
Find out more & book now

Newsletter Sign-up

Have a Question?