Go back to the main page

Table of contents

• Databases, Networks and the Web
  • Professor(s)
  • Topics covered
  • Assessment
  • Mock exam
  • Module specification
  • Reading list for this course
  • Past exams
  • Syllabus
  • Resources
    • Kinks to be aware of
    • Notes
    • Websites

---

Databases, Networks and the Web

In this module, you will learn theory and practical skills focused on the modern web, internet and client-server applications. You will learn about relational database systems, mainly from a development perspective, emphasising issues related to data modelling and database implementation in SQL. You will learn how to model data in a database, retrieve data from the database and provide access to data through dynamic websites. In particular, you will learn about the Relational Model, Query processing, and socket architectures to enable communication.

Professor(s)

• Dr. Elaheh Homayounvala

Topics covered

• Networking concepts
• Building Simple socket clients and servers
• Building an HTTP server
• Generating web pages from data using templates
• Relational Databases
• Querying a database
• Representing data in a database
• Representing data in a database pt 2
• Revision of HTML and CSS
• Building a dynamic website

Assessment

One two hour unseen written examination and coursework (Type I)

Mock exam

See the binary-assets repository.

Module specification

• Module specification (September 2020)

Reading list for this course

• Reading list for this course

Past exams

See past exams here.

Syllabus

• Syllabus PDF (September 2020)

Resources

Kinks to be aware of

• List of reported errors and bugs with the module.

Notes

• Visit this page of world-class/notes.

Websites

• SQL Zoo - for interactive SQL practice problems