SQL Programming

Certificate

Course Details

Course Code	LL_ISQLP_S
Level	7
Duration	1 year
Credits	20
Method of Delivery	Online
Campus Locations	Donegal – Letterkenny
Mode of Delivery	Part Time

How to Apply

How to Apply

Course Overview

This module will allow the learner to assimilate a relational database environment and extract data on single and multiple tables using SQL. In addition, the learner will manipulate data results using aggregate functions, grouping and sorting.

The learning outcomes enable learners to evaluate the relational model and the relational integrity rules, define, create, alter and delete tables and data, and write SQL commands for single-table data manipulation. Learners will also retrieve data from multiple tables, implement Inner, Outer, Left and Right joins, and apply aggregate functions, grouping, sorting and pattern matching to support effective data analysis.

Course Details

Year 1

Semester	Module Details	Credits	Mandatory / Elective
1	SQL Programming This module will allow the learner to assimilate a relational database environment and extract data on single and multiple tables using SQL. In addition, the learner will manipulate data results using aggregate functions, grouping and sorting. Learning Outcomes 1. Evaluate the relational model and the relational integrity rules 2. Define, create, alter and delete tables and data. 3. Write SQL commands for data manipulation of single 4. Retrieve data from multiple tables 5. Implement Inner, Outer, Left and Right Joins 6. Apply Aggregate Functions, Groups, Sorting and Pattern Matching	10	Mandatory
2	Advanced SQL Programming This module presents a detailed examination and practice of the advanced usage and functionality of SQL and T-SQL in an enterprise database environment using a suitable relational database management system. Learning Outcomes 1. Write complex SQL and T-SQL queries to retrieve information to aid business decisions 2. Implement T- SQL functions to support the display of a resultant data set 3. Devise appropriate ways to store and index data 4. Formulate triggers, stored procedures 5. Import and Export data using multiple data formats	10	Mandatory

Download a prospectus

Undergraduate Prospectus Online, Flexible & Professional Development Prospectus

Entry Requirements

A full Level 5 qualification in any discipline with at least 3 years appropriate industry experience

or
Be a mature learner preferably with appropriate industry experience

Fees

This course is funded by the Micro-credential Learner Fee Subsidy 2026 programme and fees are subsidised at 80% for all eligible learner categories. Eligible learners can expect to pay €200 for this programme as part of this initiative.

Further information on fees