COMP08168 2023 Advanced Databases
Full Title
Advanced Databases
Transcript Title
Advanced Databases
Code
COMP08168
Attendance
N/A %
Subject Area
COMP - Computing
Department
COEL - Computing & Electronic Eng
Level
08 - NFQ Level 8
Credit
05 - 05 Credits
Duration
Semester
Fee
€
Start Term
2023 - Full Academic Year 2023-24
End Term
9999 - The End of Time
Author(s)
Una LEstrange
Programme Membership
SG_KCMPU_L08 202300 Higher Diploma in Science in Computing
Description
The module Advanced Databases introduces the learner to advanced database concepts such as stored procedures, views and advanced table joins and functions. The learner will also be introduced to NoSQL and will comprehend the various types of data and how they can be interrogated.
Learning Outcomes
On completion of this module the learner will/should be able to;
1.
Develop advanced table joins, stored procedures and views
2.
Develop SQL queries utilising multiple functions
3.
Describe the need for storing semi-structured and unstructured data with appropriate use cases
4.
Develop solutions for storing and processing non-relational data
Teaching and Learning Strategies
Short videos will be used to explain concepts. Learners will be set weekly tasks and encouraged to work via Moodle.
Module Assessment Strategies
There will be a number of timed quizzes given during the semester.
There will three open book exercises to be completed and one final project.
Repeat Assessments
One repeat project covering all learning outcomes will be provided.
Module Dependencies
Prerequisites
COMP08159 201900 Information Systems
Indicative Syllabus
Develop advanced table joins, stored procedures and views
- Advanced table joins
- Stored procedures, views
- Declaring and assigning variables
- Cross-database queries
- Transactions and distributed databases
Develop SQL queries utilising multiple functions
- String (concat, replace, reverse)
- Math (ceiling, count exp)
- Date (datediff, datepart, getdate)
- Cast, convert
Describe the need for storing semi-structured and unstructured data with appropriate use cases
- The evolution of data storage and type
- Limitations of the relational database approach
- Review NoSQL database solutions (key-value, document, graph etc.)
- Mechanisms for storing very large data sets (data lakes)
Develop solutions for storing and processing non-relational data
- Programmatically communicate with a NoSQL database
- Gets, puts, listing, scans and queries
- Interact with a database programmatically
- Advantages of a fully managed cloud database solution
- Streams and serverless compute triggers
Coursework & Assessment Breakdown
Coursework & Continuous Assessment
100 %
Coursework Assessment
| Title | Type | Form | Percent | Week | Learning Outcomes Assessed | |
|---|---|---|---|---|---|---|
| 1 | Stored procedures / views | Coursework Assessment | Assignment | 20 % | Week 4 | 1,2 |
| 2 | Quiz and open book assesment | Coursework Assessment | Open Book Exam | 30 % | Week 9 | 2,3 |
| 3 | Quiz and assignment on NoSQL databases. | Project | Assignment | 50 % | OnGoing | 1,2,3,4 |
Full Time Mode Workload
| Type | Location | Description | Hours | Frequency | Avg Workload |
|---|---|---|---|---|---|
| Lecture | Lecture Theatre | Lecture | 1 | Weekly | 1.00 |
| Practical / Laboratory | Computer Laboratory | Lab practical | 3 | Weekly | 3.00 |
| Independent Learning | Not Specified | Self-directed learning | 3 | Weekly | 3.00 |
Total Full Time Average Weekly Learner Contact Time 4.00 Hours
Online Learning Mode Workload
| Type | Location | Description | Hours | Frequency | Avg Workload |
|---|---|---|---|---|---|
| Lecture | Online | Lecture | 1 | Weekly | 1.00 |
| Practical / Laboratory | Online | Video Workshop | 2 | Weekly | 2.00 |
| Independent Learning | Not Specified | Self-directed learning | 3 | Weekly | 3.00 |
Total Online Learning Average Weekly Learner Contact Time 3.00 Hours
Required & Recommended Book List
Recommended Reading
2016-06-29 Murach's SQL Server 2016 for Developers Mike Murach & Associates
ISBN 1890774960 ISBN-13 9781890774967
2016-06-29 Murach's SQL Server 2016 for Developers Mike Murach & Associates
ISBN 1890774960 ISBN-13 9781890774967
If you're an application developer, or you're training to be one, this 2016 edition of Murach's classic SQL Server book is made for you. To start, it presents the SQL statements that you need to retrieve and update the data in a database. These are the SQL statements that you'll use every day. Then, it shows you how to design a database, how to implement that design, and how to work with database features like views, scripts, stored procedures, functions, triggers, transactions, security, XML data, BLOB data with FILESTREAM storage, and the CLR integration feature. The result? You'll be able to create database applications that are thoroughly professional. You'll be familiar with the DBA-related issues that let you work far more effectively than most of your colleagues. And you'll have a handy reference at your side to answer questions and handle new challenges as they come up.
Recommended Reading
2014-09 Sams Teach Yourself NoSQL with MongoDB in 24 Hours Pearson Education
ISBN 9780672337130 ISBN-13 0672337134
2014-09 Sams Teach Yourself NoSQL with MongoDB in 24 Hours Pearson Education
ISBN 9780672337130 ISBN-13 0672337134
"Now, in just 24 lessons of one hour or less, you can learn how to leverage MongoDB's immense power. Each short, easy lesson builds on all that's come before, teaching NoSQL concepts and MongoDB techniques from the ground up."--
Module Resources
Journal Resources
None
URL Resources
aws.amazon.com/dynamodb
https://www.mongodb.com/
Other Resources
NA
Additional Information
NA