Relational Database Fundamentals Become a Web expert
This trusted relational database management system (RDBMS) used for data storage and logging of user data is a valuable commodity to have a skill-base in. The preferred tool for some of the world’s most recognised names such as YouTube, Google, and Facebook, it can be valuably integrated with scripting languages such as PHP, ASP, and Perl to create dynamic web content.
Outline:
- Introduction to relational database concepts
- Introduction to MySQL
- The SQL language
- Use SQL to create and manage MySQL databases
- Normalisation
- MySQL table and data types
- Use of appropriate data type
- Use of keys and indexes
- Inserting and updating records - including data import techniques (INSERT, UPDATE, LOAD)
- Handle updates to duplicate records
- Retrieve data from a MySQL database using SQL queries (SELECT statements)
- Query optimisation techniques
- Data filtering (WHERE clause)
- Group results (GROUP BY, HAVING, etc)
- Using Aggregate functions
- Work with multiple tables (JOINS)
- Use nested sub-queries
- Advanced query techniques
- Concurency and Transactions
- Stored Procedures and Triggers
- Review of MySQL functions
Qualifications:
Optional
Date and time:
4 weeks, 2 evenings per week,
6.00 p.m. - 9.00 p.m.
February 2012
6.00 p.m. - 9.00 p.m.
February 2012
Price:
£349.00
You might be eligible for one of our free courses. Click on the link to find out.
www.elatt.org.uk
