Short course on MySQL Course level: Beginner
Total Duration: 5 Hours
Certification: Certificate of Completion will be provided after completing the course

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.

Skills Required

No existing knowledge of SQL or MySQL is required. You should have basic computing knowledge.

Course Dates, Prices & Enrolment

DatesPriceEnrol
24 Apr 2017 - 24 Apr 2017
Monday
£120Enrol Now
28 May 2017 - 28 May 2017
Sunday
£120Enrol Now
30 May 2017 - 01 Jun 2017
Tuesday & Thursday
£120Enrol Now
19 Jun 2017 - 19 Jun 2017
Monday
£120Enrol 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 Tutor

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?