Classes Course
Place:
London
Price:
Duration:
2 Days
Start:
09/02/2009 other dates
See course programme
| Requirements |
Click on one of the dates below to book a course.
|
| Price |
£550 + VAT
|
| Getting started | |
| Overview of MySQL Installation Directories and files installed The relational model Normalisation SQL overview | |
| MySQL and SQL essentials | |
| Column type
overview Numeric column type String column type Date and time The MySQL Client program Creating tables Retrieving Data from tables SQL SELECT FROM SQL WHERE SQL LIKE, AND and OR Numerical operators String operators Wildcards Introduction to MySQL Functions | |
| Database manipulation | |
| Creating advanced
queries SQL HAVING SQL GROUP BY Working with multiple tables Types of join SQL INSERT SQL REPLACE SQL UPDATE SQL DELETE Importing data Working with indexes | |
| Using functions | |
| Overview of functions Overview of operators Conditional functions String functions Date and time functions | |
| Where | London, United House, North Road, Islington see map |
| When | Start: 09/02/2009 Finish: 10/02/2009 See calendar |
| Where | London, United House, North Road, Islington see map |
| When | Start: 07/05/2009 Finish: 08/05/2009 See calendar |
| Where | London, United House, North Road, Islington see map |
| When | Start: 27/07/2009 Finish: 28/07/2009 See calendar |
| Where | London, United House, North Road, Islington see map |
| When | Start: 26/10/2009 Finish: 27/10/2009 See calendar |