Virtual and Classroom Training - All our courses are available virtually. We have also started a safe return to classroom training. Click here to learn more.

MySQL Database Introduction

1 Day Course
course icon

Course Information

Overview

Storing and accessing data are part of a person's day-to-day activities. One of the most efficient and powerful ways of managing data is by using databases. Information can be stored, linked, and managed using a database application such as MySQL 5.1. In the MySQL Database Fundamentals course, you will work with the databases using MySQL.

Objectives

  • You will work with databases by identifying the fundamental concepts of databases, creating a preliminary database design, applying normalization techniques, and familiarizing yourself with relational database management systems. Using various SQL commands, indexes, and views, you can work with and modify data efficiently within a database. Using features such as Enterprise Monitor and MySQL Administrator, you can manage users and administer and monitor a database.

Target Student

This course is designed for people who are familiar with the Windows environment and any Office productivity application, and who wish to acquire competency in performing basic database operations and administration using the MySQL RDBMS or various similar SQL-based RDBMS products. The other student profile would be IT systems managers who will be working within a MySQL RDBMS-based enterprise IT department and need to interact in a productive manner with MySQL RDBMS technical professionals. It can also be used by students who wish to gain familiarity with database system terminologies and usage so as to pursue a career as a MySQL RDBMS technical professional.

Prerequisites

To be successful in this course, you should have some familiarity with the Microsoft Windows environment, Microsoft Office applications, or similar office productivity applications

Course Outline

1. Familiarizing Yourself with the Fundamentals of Databases
  • Identify the Database Development Life Cycle
  • Explore the MySQL RDBMS
2. Creating a Preliminary Database Design
  • Analyze Database Requirements
  • Identify Key Fields
  • Create Entity Relationship Diagrams
3. Applying Normalization Techniques
  • Normalize Tables
  • Denormalize Tables
4. Using the SQL Commands to Work with Tables
  • Discuss Structured Query Language (SQL)
  • Create Tables Using the Data Definition Language (DDL) Commands
  • Modify Data Using Data Manipulation Language (DML) Commands
5. Working with Databases
  • Use SQL Compound Statements
  • Create Triggers
6. Managing Database
  • Create Indexes
  • Create Views
  • Create Transactions
7. Administering a Database
  • Perform Database Administration
  • Perform Backup and Recovery

Private Courses

We can arrange your own private MySQL course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

What Our Clients Think

This has been by far one of the most useful and well planned/executed training courses I have ever attended. For this to have been achieved remotely just adds to how impressive it was managed.

Trevor Stratton - Lincolnshire County Council

The trainer was very through and very helpful. The course was delivered superbly and I'm very pleased.

David O'Hara - Multibrands UK

Very informative course, very useful tips on how to work with SQL Management Studio. A lot of SQL quirks explained, a lot of good examples.

Magdalena Piekarska - Veolia

Really good course. lots of hands on practice and clear explanations.

fiona dawe - Covetrus Global Software Services

The trainer was an amazing lecturer and the vba course was very usefull and well structured. Thank you.

Veronika Panton - Haven Power

As usual a first class training course.

Wendy Thomas - Aldi Stores Ltd

Related Courses

Introduction Programming 2 Days

You will learn how to build a MySQL database-driven Web application using the PHP scripting language.

Database Introduction 1 Day
Learn key concepts together with basic database operations and administration using the MySQL RDBMS.
SQL Introduction - Intermediate 3 Days
Learn the essentials of writing Structured Query Language (SQL) commands to access, create and modify data within a MySQL database.