Singapore University of Social Sciences

Data Programming

CET Course | SkillsFuture Claimable Course

Data Programming (ICT233)

Synopsis

This course introduces students to the language (that is, protocol) adopted in the communication between a web server and client (browser), called the HyperText Transport Protocol (HTTP). Students will learn to write a program to talk HTTP with web servers to download web pages from the World Wide Web (WWW). By understanding the format of the web pages in HyperText Markup Language (HTML), the information in the web pages can be extracted in the form of an object. Students then learn how to design traditional database and store the information of the objects using the Object-Relational Mapping (ORM) method. Students will also learn how to Create, Read, Update and Destroy (CRUD) records of a database system. A data structure, DataFrame, will be introduced so that CRUD operations on information can be performed through a programming language.

Level: 2
Credit Units: 5
Presentation Pattern: Every semester

Topics

  • How to retrieve web page information
  • HyperText Transport Protocol (HTTP)
  • How to structure and store web page information in an object
  • HTML parsing and regular expressions
  • How to store object information in a database
  • Basic data modeling
  • Object-Relational Mapping (ORM)
  • How to exchange data between processes
  • Data exchange format (XML-based) and processing
  • Database file processing
  • CRUD on table structure
  • DataFrame data structure

Learning Outcome

  • Analyse HTTP for information retrieval
  • Design parsing methods to extract information from web pages
  • Apply Object-Relational Mapping between information in an object and a database
  • Compose query languages to retrieve information from a database
  • Develop programme to perform CRUD operations on database information
  • Formulate communication methods for exchanging information over the WWW
Back to top
Back to top