skip to navigation skip to content
Thu 21 Nov - Fri 22 Nov 2019
14:00, ...
Venues:

Provided by: University Information Services


Booking
This course is full - Add me to the waiting list

Other dates:

No more events

[ Show past events ]



Register interest
Register your interest - if you cannot make any of the currently scheduled dates and would be interested in additional dates being scheduled.


Booking / availability

MySQL: Implementing a Relational Database Design
BeginnersPrerequisites

Thu 21 Nov - Fri 22 Nov 2019

Description

This beginners course equips you with the skills to implement a relational database design entity relationship diagram (ERD) into a MySQL database. Please be prepared for a fast paced course, but the materials provided can be used for consolidation after the course.

Target audience
  • All current University members (departments and colleges)
  • Further details regarding eligibility criteria are available
Prerequisites

Confident general computer skills. A basic understanding of programming concepts would be helpful but is not required.

Sessions

Number of sessions: 4

# Date Time Venue Trainer
1 Thu 21 Nov   14:00 - 17:00 14:00 - 17:00 University Information Services, Roger Needham Building, Ely Training Room 1 map Lynn Foot
2 Thu 21 Nov   14:00 - 17:00 14:00 - 17:00 University Information Services, Roger Needham Building, Ely Training Room 2 map Lynn Foot
3 Fri 22 Nov   09:30 - 13:00 09:30 - 13:00 University Information Services, Roger Needham Building, Ely Training Room 1 map Lynn Foot
4 Fri 22 Nov   09:30 - 13:00 09:30 - 13:00 University Information Services, Roger Needham Building, Ely Training Room 2 map Lynn Foot
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:

  • Subqueries
  • Querying data from multiple tables through joins
  • Input data from, and output data to a text file
  • Backup and restore
  • Create users and granting privileges
  • Remote login
Format

Presentation, demonstrations and Practicals

Taught using

MYSQL v. 5.6.11 on MCS Windows

Duration

Two half day sessions, please note that you will not have time in class to complete all the exercises therefore you may want to complete them outside of the teaching sessions

Themes

Booking / availability