INSTG018 Introduction to Programming and Database Querying

This module uses JavaScript (ECMAscript) to introduce the fundamental principles of procedural computer programming and scripting languages. It reinforces these concepts by practical application in the context of automated web browser and document manipulation. Fundamental programming topics include data types, operators, variables, flow control via selection and iteration, arrays and objects, functional abstraction, methods and constructors, abstract data types and pattern matching. Applications include manipulation of web browsers and documents, dynamic generation of web content, and form verification via regular expressions. The module concludes with a brief introduction to SQL querying of relational databases.

Learning outcomes: Upon successful completion of this course, you will have an understanding of the basic principles of procedural computer programming. You will be able to apply this knowledge in order to embed scripts within HTML documents to affect behaviour of web browsers and document content and appearance, and to generate HTML-based web content dynamically. You will be able to write scripts to perform simple form verification using pattern matching and regular expressions. You will have a basic understanding of relational databases and be able to write SQL queries in order to update and retrieve data sets from such databases.

Assessment: Assessment by coursework only.

Compulsory for: MSc Information Science.

Optional for: MA Archives and Records Management, MA Library and Information Studies, MA Publishing, MA/MSc Digital Humanities, MA in Electronic Communication & Publishing, MRes in Library, Archive & Information Studies. This module is also available for short course students.

Prerequisites: There are no formal prerequisites for this module, although a basic understanding of HTML and basic computer and I.T. literacy are assumed.

Taught by: Rob Miller

Timetable: Thursdays 2-5pm in Term 1
Session 1 - Introduction, Overview and Programming Fundamentals
Session 2 - Boolean Expressions and Conditional Statements
Session 3 - Loops and Repeat Statements
Session 4 - Objects and Arrays
Session 5 - Functions, Methods and Constructors
Session 6 - Lab Exercise Question and Answer Session
Session 7 - Form Input and HTML Output
Session 8 - Regular expressions
Session 9 - SQL and MySQL
Session 10 - More SQL and MySQL

Books:

  • JavaScript For The World Wide Web, 8th or 9th Edition (Visual QuickStart Guide), by Tom Negrino and Dori Smith, pub. Peachpit Press 2011/2014, ISBN-10: 0-321-77297-0 / ISBN-10: 0-321-99670-4 [ www.peachpit.com ]
  • JavaScript: The Definitive Guide, 6th Edition, by David Flanagan, pub. O'Reilly and Associates 2011, ISBN-10: 0-596-80552-7 [ shop.oreilly.com/product/9780596805531.do ]

Online Resources:

Further information for students currently taking this module

Page last modified on 20 aug 14 13:48