Computer Tutoring Logo

Cost Calculator

Training delivery
Number of students?
Laptop hire?
Offsite training?

Course price: £ *
Price per head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

 Live online  Face to face
First name:

Last name:

Email:

Tel:

Location:

Number of students:
First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.
 I would like to receive software tips and special offers

Fundamentals of Databases Using MySQL Training Course Beginners

Beginners Fundamentals of Databases Using MySQL Course 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 Fundamentals of Databases Using MySQL course, you will work with the databases using MySQL.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.

Course Duration: 1 Day

Complete Course Outline

Fundamentals of Databases Using MySQL Training Course

Familiarizing Yourself with the Fundamentals of Databases

  • Identify the Database Development Life Cycle
  • Explore the MySQL RDBMS

Creating a Preliminary Database Design

  • Analyze Database Requirements
  • Identify Key Fields
  • Create Entity Relationship Diagrams

Applying Normalization Techniques

  • Normalize Tables
  • Denormalize Tables

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

Working with Databases

  • Use SQL Compound Statements
  • Create Triggers

Managing Databases

  • Create Indexes
  • Create Views
  • Create Transactions

Administering a Database

  • Perform Database Administration
  • Perform Backup and Recovery