This course is most suitable for programmers and web developers who are looking to expand their skills with SQL server.

Please note: this course is not suitable for MAC computers users


Course Outline
Course Code: 
100 hours - Access for 12 months
Statement of achievement
Lesson Structure: 
  1. Introduction to Databases
  2. Fundamentals of SQL
  3. Building a database with SQL
  4. Storing & Retrieving Data
  5. Advanced SQL database access methods
  6. Database Security
  7. Using SQL in applications
  8. Cursors
  9. Stored procedures
  10. Error Handling
  11. Dynamic SQL
  12. Advice & Tips
Aims - the learning objectives of the course: 
  • 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.