MySQL: Implementing a Relational Database Design BeginnersPrerequisites
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.
- All current University members (departments and colleges)
- Further details regarding eligibility criteria are available
Confident general computer skills. A basic understanding of programming concepts would be helpful but is not required.
Number of sessions: 2
# | Date | Time | Venue | Trainers | |
---|---|---|---|---|---|
1 | Thu 4 May 2017 14:00 - 17:00 | 14:00 - 17:00 | University Information Services, Roger Needham Building, Ely Training Room 1 | map | Lynn Foot, Lynda Stratford |
2 | Fri 5 May 2017 09:30 - 13:00 | 09:30 - 13:00 | University Information Services, Roger Needham Building, Ely Training Room 1 | map | Lynn Foot, Lynda Stratford |
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
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
Presentation, demonstrations and Practicals
MYSQL v. 5.6.11 on MCS Windows
Two half day sessions
Booking / availability