| CODE | CIS1044 | ||||||||||||
| TITLE | SQL for Statisticians | ||||||||||||
| UM LEVEL | 01 - Year 1 in Modular Undergraduate Course | ||||||||||||
| MQF LEVEL | 5 | ||||||||||||
| ECTS CREDITS | 2 | ||||||||||||
| DEPARTMENT | Computer Information Systems | ||||||||||||
| DESCRIPTION | The beginning of the unit is dedicated to understand the basics of relational databases and its associated terminology in use to describe data structures and data inter relationships. The unit quickly progresses to introduce the basics of SQL, a de facto standard for databases, for creating, updating and retrieving data from these data sources. After presenting basic data definition and manipulation constructs, considerable attention is given for the retrieving of data through various combinations of restrictions, and combining data from a number of data sources. SQL is also used to compute functions, sorting, categorization of data, and basic "time" series measures on these data sources. The later part shows how SQL handles unstructured data, build user defined functions, and controls interactions to a database through data driven coding. Study-unit Aims: The overall aim is for students to express basic data collection and collation operations over a data store to create the necessary structures to capture the data requirements. Furthermore properly designing databases that comprise a data store allows a student to apply a variety of pre-processing and data quality checks at source and consequently avoid creating multiple and possibly redundant data sources. This unit is using Structure Query language (SQL), a de facto database language, to meet this overall aim. SQL is an extensive and special purpose programming language for database related management, control and manipulation. Learning Outcomes: 1. Knowledge & Understanding By the end of the study-unit the student will be able to: - understand the meaning of a relational database as expressed in its structural rules (e.g. tables, keys and other constraints); - understand SQL and its main sub languages (e.g. definition, manipulation, control); - select the right SQL construct to extract the required data; - knowledge of how data quality and preprocessing procedures are deployed over data sources. 2. Skills By the end of the study-unit the student will be able to use of SQL to: - create databases and data schemas; - create tables and structural constraints (e.g. primary key and foreign keys); - use of Insert, update, delete data from a table; - query one table with various combinations of restrictions; - query more than one table with joins; - understand and code an array of relational joins (e.g. inner, outer, self); - use of unary and aggregate functions; - categorizing and sorting; - create user defined queries; - read and write data from and to external data (to database); - manipulate basic non relational structures (e.g. JSON data); - control access to a database through users and access profiles. Main Text/s and any supplementary readings: - Fundamentals of Database Systems, by Ramez Elmasri (Author), Shamkant B. Navathe (Author), Pearson, 6th Edition, 2010. - SQL Cookbook: Query Solutions and Techniques for Database Developers, by Anthony Molinaro (Author), O'Reilley, 2006. - PostgreSQL: Up and Running, by Regina O. Obe (Autor), Leo S. Hsu (Autor), O'Reilley, 2014. |
||||||||||||
| STUDY-UNIT TYPE | Lecture and Practicum | ||||||||||||
| METHOD OF ASSESSMENT |
|
||||||||||||
| LECTURER/S | Kelly Steer Joseph Vella (Co-ord.) |
||||||||||||
|
The University makes every effort to ensure that the published Courses Plans, Programmes of Study and Study-Unit information are complete and up-to-date at the time of publication. The University reserves the right to make changes in case errors are detected after publication.
The availability of optional units may be subject to timetabling constraints. Units not attracting a sufficient number of registrations may be withdrawn without notice. It should be noted that all the information in the description above applies to study-units available during the academic year 2023/4. It may be subject to change in subsequent years. |
|||||||||||||