Computer Tutoring Logo
Est. 2002
Menu Button

Cost Calculator

Training Delivery
Number 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:

Num 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

Fundamentals of Databases Using MySQL 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

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

Classroom based Beginners Fundamentals of Databases Using MySQL Prices from:

If you are interested in this classroom based course but want to know the price beforehand then use the following form to calculate how much.

Training Delivery
Number Students?
Laptop hire?
Offsite training?

Course Price: £ *
Price Per Head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

Live Online Classroom
First Name:

Last Name:

Email:

Tel:

Location:

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

Computer Tutoring takes your privacy seriously and collects essential information such as your name, email, and course preferences to facilitate our services. Additionally, we use cookies to personalise your experience and for Google Ads personalisation, which helps us deliver more relevant advertising to you.

We do not share your personal data, except for specific use-cases like payment processing via PayPal and sending you updates via Mailchimp, if you've opted in for those services. Our site may also use Google Analytics to improve user experience and features links to other websites. Please be aware that Google's Privacy Policy may differ from ours.

We do not store your credit/debit card details. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.

By using our website, you consent to our use of cookies for the purposes outlined above.

For more details, please read our full Privacy Policy.