skip to navigation skip to content
Thu 2 May - Fri 3 May 2019
14:00, ...

Venue: University Information Services, Roger Needham Building, Ely Training Room 1

Provided by: University Information Services


Booking

Bookings cannot be made on this event (Event is completed).


Other dates:


2016


2017


2019



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 2 May - Fri 3 May 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: 2

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

Related courses
Themes

Booking / availability