Ayrshire College homepage
Back to all courses

SQL Programming - Beginners (ONLINE)

This course isn’t currently open for applications, but you can still register your interest.

  • Qualifications Other Programmes
  • SCQF Level SCQF Level 5
  • Study mode Professional Learning
  • Campus Ayr
  • Start date August 2025
More information

Attendance / Duration

1 Day (9:30am - 4:00pm) ONLINE

Overview

This 1 day online course provides an introduction to SQL programming and covers the fundamentals of querying relational databases.

Cost

£180

Enquiry

For further information or to be added to our waiting list for future course dates please email engage@ayrshire.ac.uk

What's Involved?

SQL (Structured Query Language) is a programming language designed for managing and manipulating relational databases. It’s used by many organizations to manage their data and extract valuable insights. This course provides an introduction to SQL programming and covers the fundamentals of querying relational databases.

This course is suitable for those who want to learn the basics of SQL programming.

Note: Although a SQL Server is required for this course, these skills translate almost seamlessly with other SQL databases. This course focuses on the DML subset of SQL.

Course Content

  • Understand the basics of SQL syntax.
  • Understanding the basics of database schemas and models.
  • Query databases to retrieve data.
  • Filter, sort, and aggregate data.
  • Join multiple tables to extract valuable insights.
  • Understand database normalisation.
  • Understand how to use SQL in various applications.
Course System Requirements:
  • SQL Server Developer Edition installed.
  • SSMS Installed.
  • Data Required for this course will be provided during the course.