Crs 580
Database Application Development with MySQL
This is an entry level course for MySQL application
developers. It covers the fundamentals of relational
database theory and design and the use of the Data Manipulation
Language (DML) features of SQL to retrieve, delete and update
information, and the Data Definition Language (DDL) features of SQL
create databases, tables and indexes
The course includes an introductory discussion (with demonstrations) of how MySQL is used in
Web applications, and how it can be accessed from
programming languages such as Perl, Java, PHP and Python and C.
ODBC and JDBC data access are described.
|
Course outline
Introduction to MySQL
- The uses of databases
- The advantages of databases over files
- The history of MySQL
- Overview of obtaining and installing MySQL on Linux, Unix and Windows
machines
Connecting to MySQL
- TCP/IP - Client/Server
- Command line utilities
- Graphical clients
- ODBC and JDBC
- Web interfaces
The Relational Model
- Relational Algebra
- Tables, Rows and Columns
- Keys
- Relationships
- Relational Operations
- Transactions
- SQL-92 features not supported by MySQL
Structured Query Language - SQL
- Data definition
- Inserting rows
- Updating rows
- Deleting rows
- Queries
- Joins
- Ordering
- Grouping
- Limiting
- Altering a table
Design and Normalisation
- Requirements and Design specifications
- Entity Relation(ER) diagrams (and their UML equivalents)
- Reasons for Normalising
- First, Second and Third Normal Forms
- Boyce-Codd Normal Form
- Fourth Normal Form
- Denormalisation
Overview of Ways of implementing MySQL Clients
- C programs and the MySQL C API
- Java programs and JDBC
- VBScript and ODBC
- PHP, Perl, Python
- C++ and the MYSQL++ API
- Visual Basic and ODBC
Data Analysis and Reporting with MySQL - an overview
- importing MySQL query results into spreadsheets
- Querying a MySQL database from Access
- Creating reports using MySQL and Crystal Reports
Using MySQL to store and organise images and documents - an
introduction
- How MySQL handles binary large objects
- Strategies for classifying images
- Strategies for classifying documents
- Example case studies
|
Intended Audience
The course is FTT's main, hands on, introductory course to Relational Databases.
It is suitable for anyone that has a basic understanding of
computers who wishes to understand relational databases and how they work.
It is especially useful for Web designers who will be implementing
database driven web applications and who need to understand Relational
Database technology from scratch.
The course will use MySQL, running on either Windows 2000, Solaris
or Linux. It is generic in the sense that it does not depend on any
particular operating system and that it concentrates on the most
commonly used standard parts of SQL.
|
Practical Work
About 50% of the course time will be allocated to practical exercises.
The exercises will be built around a specific case study ... and so will
cover the entire process from design, to database implementation, to
application development.
Attendees will be given a CD containing the compiled and source code
for the most recent stable release of MySQL, as well as a collection
of applications that enhance the usefulness of MySQL. The course exercises and
solutions, plus further exercises (without solutions -- though these
can be requested via email .... on presentation of evidence that a
serious attempt to tackle them has been made) will also be on the CD.
- Identifying the entities, attributes and relationships for a given
business application
- Carry out the normalisation to third normal form of a database
that is (partly) in second normal form
- Interact with a pre-built database using SQL - both
retrieving and modifying the data
- Adding new tables to the database and populating them with data
- Writing pseudo code to enforce referential data integrity constraints
- Implementing simple reporting applications
|