skip to navigation skip to content
Tue 5 Jun - Wed 6 Jun 2012
14:15, ...

Venue: Phoenix Teaching Room

Provided by: University Computing Service


Booking

Bookings cannot be made on this event (Event is in the past).


Other dates:


2012


2015


2019



Register interest
Register your interest - if you would be interested in additional dates being scheduled.


Booking / availability

MySQL: Implementing a Relational Database Design
Prerequisites

Tue 5 Jun - Wed 6 Jun 2012

Description

This beginners course equips you with the skills to implement a relational database design entity relationship diagram (ERD) into a MySQL database.

Prerequisites

A basic understanding of programming concepts would be helpful but is not required.

Sessions

Number of sessions: 3

# Date Time Venue Trainers
1 Tue 5 Jun 2012   14:15 - 17:00 14:15 - 17:00 Phoenix Teaching Room Lynn Foot,  Trainer 0838
2 Wed 6 Jun 2012   09:30 - 13:00 09:30 - 13:00 Phoenix Teaching Room Lynn Foot,  Trainer 0838
3 Wed 6 Jun 2012   14:15 - 17:00 14:15 - 17:00 Phoenix Teaching Room Lynn Foot,  Trainer 0838
Topics covered (session 1)

Part 1:

  • Connecting to and Disconnecting from the MySQL Server
  • Creating tables
  • Applying PKs and FKs
  • Inserting data
  • Modifying table structure
  • Update and delete data
  • Using LIKE, BETWEEN, and wildcards to find data
  • Querying data from one table (select)
  • Using comparison, logical and arithmetic operators
  • Concatenation of data
  • Using aliases
  • Grouping and ordering data
  • Aggregation of data: SUM AVG MIN MAX COUNT
Topics covered (session 2)

Part 2:

  • Querying data from multiple tables
  • Subqueries
  • Joins
Topics covered (session 3)

Part 3:

  • Out put data into a text file
  • Backup and restore
  • Create a database from a script
  • Create users and passwords
  • Deleting users
  • Changing passwords
  • Granting and revoking privileges
  • Download, install and configuration of MySQL Server
Format

Presentation and Practicals

System requirements

MYSQL v. 5.1 PWF Windows

Duration

Three half day sessions

Theme
Programming and Scripting

Booking / availability

Override user: