RoozegareNo
Courses
ST207 Databases
0.5

Availability

This course is available on the BSc in Actuarial Science and BSc in Mathematics, Statistics and Business. This course is available with permission as an outside option to students on other programmes where regulations permit and to General Course students.

Course Content

This course is available on the BSc in Actuarial Science and BSc in Mathematics, Statistics and Business. This course is available with permission as an outside option to students on other programmes where regulations permit and to General Course students.

Course Teaching

20 hours of lectures and 15 hours of seminars in the MT. Students are required to use their own laptops and install Python on their laptops.? Students not having a laptop of their own, which can be used for the purpose of the course, will be offered to use personal computers available in seminar rooms.

Formative

Students will be expected to produce 10 exercises in the MT. A set of exercises will be given in each teaching week.

Indicative

Essential Reading:?? R. Elmasri and S. B. Navathe. Fundamentals of Database Systems, 7th Edition (Global Edition), Pearson, 2017. P. Lake and P. Crowther. Concise Guide to Databases: a practical introduction. Springer, Undergraduate Topics in Computer Science, 2013. J. Hellerstein and M. Stonebraker, Readings in Database Systems, 4th Edition, Morgan Kaufmann Series in Data Management Systems, 2005, http://www.redbook.io/ Additional Reading:? R. Ramakrishnan and J. Gerhke, Database Management Systems, 3rd Edition (International Edition), McGraw-Hill, 2002. C. J. Date, An Introduction to Database Systems, 8th Edition, Pearson, 2003. J. Leskovec, A. Rajaraman and J. Ullman, Mining of Massive Datasets, 3rd Edition, Cambridge University Press, 2018, http://www.mmds.org/ A. Meier and M. Kaufmann. SQL & NoSQL Databases: models, languages, consistency options and architectures for big data management. Springer Vieweg, 2019. K. Chodorow. MongoDB: the definitive guide. 2nd Edition, O?Reilly Media, 2013. I. Robinson and J. Webber and E. Eifrem. Graph Databases. O?Reilly, 2013.

Assessment

Coursework (40%) in the MT. Project (60%). Students are required to hand in solutions to 4 sets of exercises, each accounting for 10% of the final assessment.? The project will require solving a practical task involving data model design, loading of data into a database, and querying the imported data in the database.

27 result
Undergraduate
BA History
UBHY2 | UCAS Code: UCAS Code V146
Starting 2022
Undergraduate
BSc Actuarial Science
UBACT2 | UCAS Code: UCAS Code N321
Starting 2022
Undergraduate
BSc Econometrics and Mathematical Economics
UBEM | UCAS Code: UCAS Code L140
Starting 2022
Undergraduate
BSc Economic History
UBEH | UCAS Code: UCAS Code V300
Starting 2022
Undergraduate
BSc Economic History and Geography
UBEHGY | UCAS Code: UCAS Code V3L7
Starting 2022
Undergraduate
BSc Economics
UBEC | UCAS Code: UCAS Code L101
Starting 2022
Undergraduate
BSc Economics and Economic History
UBECEH | UCAS Code: UCAS Code VL31
Starting 2022
Undergraduate
BSc Finance
UBFI | UCAS Code: UCAS Code N300
Starting 2022
Undergraduate
BSc Financial Mathematics and Statistics
UBFIMAST | UCAS Code: UCAS Code GN13
Starting 2022
Undergraduate
BSc History and Politics
UBPOLHY | UCAS Code: UCAS Code LV21
Starting 2022
Undergraduate
BSc International Relations and History
UBIRHY | UCAS Code: UCAS Code VL12
Starting 2022
Undergraduate
BSc International Social and Public Policy
UBISPP | UCAS Code: UCAS Code L400
Starting 2022
Undergraduate
BSc International Social and Public Policy and Economics
UBISPPEC | UCAS Code: UCAS Code LLK1
Starting 2022
Undergraduate
BSc International Social and Public Policy with Politics
UBISPPPOL | UCAS Code: UCAS Code LL42
Starting 2022
Undergraduate
BSc Mathematics and Economics
UBMAEC | UCAS Code: UCAS Code GL11
Starting 2022
Undergraduate
BSc Mathematics with Economics
UBMAWEC | UCAS Code: UCAS Code G1L1
Starting 2022
Undergraduate
BSc Mathematics, Statistics and Business
UBMSB | UCAS Code: UCAS Code G0N0
Starting 2022
Undergraduate
BSc Philosophy and Economics
UBPHEC | UCAS Code: UCAS Code LV15
Starting 2022
Undergraduate
BSc Philosophy, Logic and Scientific Method
UBPHS3 | UCAS Code: UCAS Code V503
Starting 2022
Undergraduate
BSc Philosophy, Politics and Economics
UBPHPOLEC | UCAS Code: UCAS Code L0V0
Starting 2022
Undergraduate
BSc Politics
UBPOL | UCAS Code: UCAS Code L230
Starting 2022
Undergraduate
BSc Politics and Economics
UBPOLEC | UCAS Code: UCAS Code LL12
Starting 2022
Undergraduate
BSc Politics and International Relations
UBPOLIR | UCAS Code: UCAS Code L290
Starting 2022
Undergraduate
BSc Politics and Philosophy
UBPOLPH | UCAS Code: UCAS Code LV25
Starting 2022
Undergraduate
BSc Psychological and Behavioural Science
UBPBS | UCAS Code: UCAS Code C800
Starting 2022
Undergraduate
BSc Sociology
UBSO2 | UCAS Code: UCAS Code L301
Starting 2022
Undergraduate
LLB Bachelor of Laws
UBLL | UCAS Code: UCAS Code M100
Starting 2022