SQL for the Web

Overview

This SQL for the Web course from Warnborough College is most suitable for programmers and web developers who are looking to expand their skills with SQL server. Similar concepts can be used and applied to the open source MySQL.

On successful completion of the course you should be able to do the following:

• Understand the concept of relational databases.

• Understand the fundamentals of SQL.

• Build and maintain a database with SQL.

• Define how to store data in a database using SQL.

• Understand advanced and more efficient ways of working with databases in SQL.

• Keep databases secure with SQL.

• Understand how to use SQL in real world applications.

• Define how to use cursors to work with data in a database.

• Understand how to re-use common code and develop efficient database driven applications with the use of stored procedures.

• Define the benefits of error handling and how to implement it.

• Define how dynamic SQL works in applications.