Scheduled Dates (sort by: location | date) |
Request availability or book by selecting a date:
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview This course is designed to provide delegates with an appreciation of relational database theory sufficient to enable them to design efficient schemas for typical web applications. Audience This course is aimed primarily at web developers who need to know how to provide a website with an efficient, relational, back end database. The bulk of the work deals with conceptual and theoretical topics that are non-specific in terms of hardware or software. Practical examples are based on MS Access, MySQL, PHP and other appropriate technologies Skills Gained In this hands-on course, you will learn about relational databases and their use with web applications. Course Outline - Data storage techniques compared
- Database theory and the relational model
- Defining and modelling real world problems
- Field types: the good, bad and the ugly!
- Refining the design
- Normalisation
- Keys and Indexes - performance considerations
- SQL - the relational database query language
- Practical example
- Let the database engine do the work
- Capturing the data you need
- Practical Project - an interactive web form
How to make a booking for the RDI-W course
|
