MySQL: Implementing a Relational Database Design
Thu 11 Mar - Fri 12 Mar 2010
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 | Thu 11 Mar 2010 14:15 - 17:00 | 14:15 - 17:00 | Titan Teaching Room 1, New Museums Site | Lynn Foot, Trainer 0838 |
| 2 | Fri 12 Mar 2010 09:30 - 13:00 | 09:30 - 13:00 | Titan Teaching Room 1, New Museums Site | Lynn Foot, Trainer 0838 |
| 3 | Fri 12 Mar 2010 14:15 - 17:00 | 14:15 - 17:00 | Titan Teaching Room 1, New Museums Site | 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