Singapore University of Social Sciences

Data Programming (ICT233)

Applications Open: 01 April 2020

Applications Close: 31 May 2020

Next Available Intake: July 2020

Course Types: Modular Undergraduate Course, SkillsFuture Series

Language: English

Duration: 6 months

Fees: $1514 View More Details on Fees

Area of Interest: Science & Technology

Schemes: Alumni Continuing Education + (ACE+), Lifelong Learning Credit (L2C)

Funding: SkillsFuture


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 operationson 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