Database Design with MySQL course

Database Design with MySQL

$200.00
5 hours
Beginner
Instructor Led Online Training

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:

How many hours you want book?

Booking for how many people?

Here is the total cost of booking:

Price per person for this course:

Preferred Dates and Times

Any other information

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

Introduction of Database
- Data model
- Relational Model
- Relational Keys
- Integrity Constraints
Introduction of MySQL
- Why MySQL?
- Working with MYSQL Using phpMyAdmin
- Installation
- Types of tables
- Datatypes and attributes
- Security
- Users
SQL: DDL
- CREATE
- ALTER
- DROP
- TRUNCATE
SQL: DML
- INSERT
- UPDATE
- DELETE
- SELECT
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
Indexes and Constraints
- Introduction to Indexes
- Introduction to Constraints
- Primary Keys
- Foreign Keys
- Unique Constraints
Joining Multiple Tables
- Simple Join
- Outer Join
- Inner Join
- Self Join
Subquery
- Introduction to subqueries
- Using subqueries
- Subqueries and joins
Views
- Introduction to Views
- Creating views
- Updating views
Back Up and Restore
- Backup MySQL Databases
- Restoring a MySQL dump

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).

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.

Database Design with MySQL Training Course