Relational Database Design with MySQL

Course Overview

More and more organisations are finding that they need to use powerful databases either because of their emerging e-commerce needs or because they are outgrowing their simple Access or Excel data stores. MySQL is an ideal first step for them as it is not only free and very powerful but also much simpler than most other SQL products. It is thus excellent for small to medium organisations just growing into the world of databases, yet who don't have the finance or the expertise to move straight to more heavy-weight offerings. Its simple structure also provides the ideal way of introducing the complex concepts behind database design.

What You Will Learn

• The principles of relational database design
• How to use MySQL to implement your design
• Updating and querying the database
• Linking to PHP & ASP.NET Web Sites and to Java and VB.NET applications
• Administering a MySQL database

Audience

Experienced programmers or those with some exposure simple database development using tools such as Access or Excel.

Requirements

Duration

3 days

Structure

Learning Unit 1; Relational Database Concepts and Design

1.1 Fundamental data storage concepts; flat files and relational models.

1.2 Relational concepts; Tables, Rows and Columns

1.3 Logical Relational Database Design

• Entity-Relationship modelling
• Normalisation
• Database Integrity

1.4 Physical Design; adapting your model to a specific database

1.5 Advanced database concepts; locking, transactions and performance issues

1.6 The RDBMS; implementing your database design

1.7 Accessing your database; direct access, Client-Sever, n-tier architecture and middleware.

Learning Unit 2; Introduction to MySQL; implementing your design

2.1 Creating and amending your tables

2.2 Adding indexes

2.3 Creating and amending databases through mysqladmin and phpMyAdmin

2.4 Importing Data

Learning Unit 3; Querying your database

3.1 The SELECT statement, the WHERE clause, The ORDER BY clause, The GROUP BY clause

3.2 Joining Tables

3.3 Functions; single row and aggregate

Learning Unit 4; Updating your database

4.1 Insert, Update and Delete

4.2 Updating through phpMyAdmin

Learning Unit 5; Accessing your database from user applications

5.1 Web Sites

• PHP Web Pages
• ASP.NET Web Pages

5.2 Windows Applications

• Java applications and JDBC
• VB.NET applications and ODBC

Learning Unit 6; Advanced Concepts

6.1 Locking

6.2 Transaction handling

6.2 Complex queries

6.2 User-defined functions

Learning Unit 7; Installing, Configuring and Administering MySQL

7.1 Downloading and installing MySQL

7.2 Configuring MySQL

7.3 Security

• Adding users and privileges
• Verification
• Operating System level security

7.4 Optimisation

7.5 Backup and Recovery

7.6 Fixing corruptions

7.7 Transferring a database

7.8 Multiple instances of MySQL

7.9 Useful MySQL system functions

7.10 Administration using mysqladmin and phpMyAdmin

Back to Top