Designing and Managing Databases using MySQL

Displaying courses for Great Britain [Change]

Overview

Databases constantly used in day-to-day life, whether you realise it or not. Databases keep track of bank accounts, serve webpages, store information and answer questions on daily basis. On this course you do not need any previous experience with databases, as our trainers cover the topics from first principles.

The course starts with an introduction to databases in general and how to design them from start. After learning the fundamentals, we go through how to install MySQL and how to create the database we designed. The course also takes a look at querying the database, and how to obtain information out of databases. A more technical session takes place covering how to define procedures to be stored in the database engine and invoked using SQL. You'll also explore database administration, including how to secure an installation, granting and revoking privileges, plus how to set-up server replication over several machines.

The course is taught using a series of presentations on topics, including group and individual exercises. By the end of the course, you'll be able to design and create a database, know how other users can access it and replication techniques to keep several copies of the database in-sync on different machines.

Prerequisites

  • An interest in learning about databases

  • Some experience using the command line would be useful

Please Note: If attending this course via 'Attend from Anywhere', you will need to have a dual screen set up.

Syllabus

Introduction to Databases

  • What are databases?
  • Types of Databases
  • What is MySQL?
  • Terminology

Installing MySQL

  • The MySQL Command Line Monitor
  • MySQL front ends
  • Importing databases

Designing Databases

  • Designing from data using normalisation
  • Designing from scratch
  • Choosing keys

Creating Databases

  • Create table syntax
  • Populating tables
  • Referential Integrity

Altering Data

  • Adding new data
  • Altering tables and records
  • Transaction Control

Querying Databases

  • Select statement
  • Selecting fields
  • Filtering records
  • Aliases

Joins

  • What are joins?
  • Inner Joins
  • Outer / Left / Right joins
  • SQL '89 Syntax differences

Functions

  • What are functions?
  • Aggregate functions
  • Group by and Having
  • Writing our own functions

Subqueries

  • What are subqueries?
  • Subqueries in the where clause
  • Subqueries as tables
  • Correlated Subqueries

Views

  • Using views
  • Creating Views
  • Inserting records into views

Database Administration

  • Securing a MySQL instance
  • Creating users
  • Granting and revoking privileges

Indexes

  • What is an index?
  • Default Indexes
  • Creating our own
  • BTree and Hashes

Automating MySQL and Server Replication

  • Automating start-up
  • Automating backup using cron
  • Scaling and Replicating MySQL databases

Training provider

Teaching mode: Classroom - Instructor Led
Duration: 4 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Database
Great Britain
This skill has an average salary of
£42,680
and is mentioned in
4.85%
of job ads in this area.
Database Administration
Great Britain
This skill has an average salary of
£0
and is mentioned in
0.00%
of job ads in this area.
SQL
Great Britain
This skill has an average salary of
£50,277
and is mentioned in
2.11%
of job ads in this area.
MySQL
Great Britain
This skill has an average salary of
£54,333
and is mentioned in
0.86%
of job ads in this area.