Ayrshire College homepage
Back to all courses

SQL Programming - Beginners (ONLINE)

  • Qualifications Other Programmes
  • SCQF Level SCQF Level 5
  • Study mode August 2026 Courses
  • Campus Ayr
  • Start date October 2026
Apply Now
More information

Attendance / Duration

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

Overview

Start Date: Monday 19 October 2026. This 1 day online course provides an introduction to SQL programming and covers the fundamentals of querying relational databases.

Cost

£185

Enquiry

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

Course Dates

  • Monday, 19 October 2026 (09:00 - 16:00)

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 database architecture and different types of databases.
  • Understand the basics of database schemas and models.
  • Understand the different types of SQL statements.
  • Query databases to retrieve data.
  • Filter, sort, and aggregate data.
  • Understand and use different types of joins.
  • Understand different types of database constraints.
  • Understand database normalisation.
  • Understand basic date, number and string functions.
  • Understand the basics of database indexes.
  • Understand basic user management including how to create users.
Course System Requirements:
  • SQL Server Developer Edition installed.
  • SSMS Installed.
  • Data Required for this course will be provided during the course.