Featured Programs
Experiential Learning Opportunities
Claim up to $1,000 in flight credits!
Get up to $1,000 in flight credits or grants toward study or internship programs abroad when you apply by January 01, 2025. See our Official Rules for full details.
Database Systems I
University of Galway - Full Curriculum Program
Galway, Ireland
Dates: 8/30/22 - 12/18/22
Database Systems I
OVERVIEW
CEA CAPA Partner Institution: University of Galway
Location: Galway, Ireland
Primary Subject Area: Computer Information Systems
Instruction in: English
Course Code: CT230
Transcript Source: Partner Institution
Course Details: Level 200
Recommended Semester Credits: 2.5
Contact Hours: 36
DESCRIPTION
This module is an introductory course to Database Systems that introduces students to database systems theory and development. It provides the student with knowledge of database systems and SQL programming.
Learning Outcomes
1.Define and explain terms, concepts and components of Database Systems
2.Identify the theoretical and practical issues in the storage, manipulation, organisation and indexing of large quantities of data
3.Program a database management system for database creation and manipulation
4.Use Relational Algebra for relational database retrieval
5.Program using SQL for relational database retrieval and manipulation
6.Describe important properties of relations and integrity constraints.
7.Specify functional dependencies and differentiate between relations in 1st Normal Form, 2NF, 3NF. Apply the process of normalization
8.Define and explain the process of query processing and optimisation. Apply query optimisation heuristics to develop a query tree that represents an efficient evaluation strategy for a given query.
Learning Outcomes
1.Define and explain terms, concepts and components of Database Systems
2.Identify the theoretical and practical issues in the storage, manipulation, organisation and indexing of large quantities of data
3.Program a database management system for database creation and manipulation
4.Use Relational Algebra for relational database retrieval
5.Program using SQL for relational database retrieval and manipulation
6.Describe important properties of relations and integrity constraints.
7.Specify functional dependencies and differentiate between relations in 1st Normal Form, 2NF, 3NF. Apply the process of normalization
8.Define and explain the process of query processing and optimisation. Apply query optimisation heuristics to develop a query tree that represents an efficient evaluation strategy for a given query.