MySQL Database for Beginners

London Academy of IT

Short course

Online

Save 50%
£ 75 VAT inc.

The best Other Database courses

See all

See all

Description

  • Type

    Short course

  • Level

    Beginner

  • Methodology

    Online

  • Class hours

    4h

Get 20% discount by using the promo code: EMAG195

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

Facilities

Location

Start date

Online

Start date

NovemberEnrolment now closed
DecemberEnrolment now closed

About this course

Important information: London Academy of IT will offer classroom-based learning when the UK lockdown is over and safe to do so.

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.

Certification: Certificate of Completion will be provided after completing the course

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • MySQL
  • Database
  • SQL
  • Database training
  • PC training
  • Beginners
  • Computer
  • IT
  • IT courses
  • London

Teachers and trainers (1)

Jayan Karmacharya

Jayan Karmacharya

Tutor

Jayan is an Experienced Web Developer and IT tutor with over 10 years of experience in Server side programming, front-end development, database design, web server management and, IT instruction. Having Master of Science in Information Technology Degree and Microsoft certified Programming in HTML5 with JavaScript and CSS3

Course programme

  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

Additional information

Please contact us or visit London Academy of IT website to view full course outline, dates, time and for enrolment.

See related categories

MySQL Database for Beginners

£ 75 VAT inc.

The best Other Database courses

See all

See all