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.
|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|
Frequency: Every term subject to teacher availability. Express an interest in future dates for this course.