MySQL: Implementing a Relational Database Design Prerequisites
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.
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
Events available