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

Apply via Springboard How to Apply

Apply via Springboard 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