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

Course provider: IT Learning Programme

Schedule

Frequency: Every term subject to teacher availability. Express an interest in future dates for this course.