COMP08168 2019 Advanced Databases

General Details

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
2019 - Full Academic Year 2019-20
End Term
9999 - The End of Time
Author(s)
Una LEstrange, Colm Davey
Programme Membership
SG_KCOMP_L08 201900 Higher Diploma in Science in Computing SG_KCMPU_L08 202000 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

One assessment (20%) will be given out on week 4. Learners will sit either an on-site or remote proctored exam on week 9 (30%) and one final project will be provided from week 10 onwards (50%).

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 Continuous Assessment Assignment 20 % Week 4 1,2
2 On Site assessment Continuous Assessment Open Book Exam 30 % Week 9 2,3
3 Create and interrogate relational and non-relational data via multiple DBs. Project Individual Project 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
Laboratory Practical 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 4 Weekly 4.00
Independent Learning Not Specified Self-directed learning 3 Weekly 3.00
Total Online Learning Average Weekly Learner Contact Time 4.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

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

"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