Course Details and Schedule

Structured Query Language (SQL) is a programming language designed for managing data held in a relational database management system (RDBMS). This 3-hour course will cover the basic concepts of SQL. For example, you will learn how to create, delete or amend tables and queries. We will also discuss more complicated concepts like advanced queries and database migration. All these concepts will be explained by several examples using the MySQL database. This includes the use of phpMyAdmin as a tool.

See below for course schedule

Key topics
  • Introduction to SQL
  • Installation guide to use MySQL
  • Setting up SQL
  • Creating tables and queries
  • Manipulating data
  • Advanced queries
  • Database migration
Course information
Intended audience General database developers and web creators interested in web-based database manipulation
Prior knowledge Databases: Concepts of database design. In addition, PHP or a similar web-based language is a plus for students interested in web-based database manipulation
Resources A course book must be purchased when you attend the course (included in the Cost below)
Software XAMPP for Windows
Format Presentation with practical exercises
Where next? More in the series of Database courses. PHP and JavaScript courses for interested web developers
Tags:
Taught using:
Windows 7

Course provider: IT Learning Programme

Schedule
Booking normally opens 30 days before the course begins.
Commences Dates Time Sessions Cost Location Status
6th week Wednesday 19 November 14:00-17:00 1 9.00 IT Services, 13 Banbury Road Booking opens October 20th 2014 Email me when booking opens

Can't make any of these dates? Express an interest in future dates for this course.

Frequency: Every term subject to teacher availability.