img

Database Design with MySQL Training Course

Database Design with MySQL

  • $200.00
  • 5 hours
  • Beginner
  • Instructor Led Online Training
  • Database Design with MySQL training 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.

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.
  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
A photo of Younus

Younus Kazi

Younus has over 18 years experiences in working and teaching IT in both public and private organisations. His specialities include Web design, development, software development and project management. He graduated from London Metropolitan University in Computing and Information Systems. He is also a Microsoft Certified Application Developer (MCAD).

A photo of Jayan

Jayan Karmacharya

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.

Shares

Customers Also Bought

Subscribe To Our Onlinesletter

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor

Copyright © 2022 LAIT.training. Owned by the E4Academy Ltd. All rights reserved.