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
Taught using:
Windows 7

Course provider: IT Learning Programme

Booking normally opens 30 days before the course begins.
Commences Dates Time Sessions Cost Location Status
9th week Wednesday 18 March 09:15-12:15 1 9.00 IT Services, 13 Banbury Road waiting list Add to basket

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

Frequency: Every term subject to teacher availability.