Module overview
This module provides a foundational introduction to web development and database management. It covers essential concepts and skills, ensuring that students have a solid understanding of web technologies and client-server architecture.
Aims and Objectives
Learning Outcomes
Knowledge and Understanding
Having successfully completed this module, you will be able to demonstrate knowledge and understanding of:
- Basic JavaScript programming for creating interactive web pages
- Server-side programming with PHP and the basics of SQL for database management
- The core concepts of web development, including the responsive web design and its applications
Subject Specific Practical Skills
Having successfully completed this module you will be able to:
- Illustrate the skills to design database schemas, and to work with SQL for data manipulation
- Apply the integration of database into web applications
- Demonstrate the ability to create dynamic and interactive web pages
Syllabus
1.Introduction to Web Development
- History and evolution of the World Wide Web
- The client-server model and its applications in web development.
- HTML for structuring web content
- HTML elements and text, HTML forms
- HTML layouts, tables, iframes, and multimedia
2.Responsive Web Design
- Introduction to responsive web design
- CSS (Cascading Style Sheets) for styling web pages.
- CSS layout techniques: floats, positioning, and flexbox
- Styling text, fonts, and colors using CSS and media queries
- Introduction to Bootstrap framework
3.Interactive Web Development
- Introduction to JavaScript programming concepts
- Basics of JavaScript programming
- Variables, data types, and operators in JavaScript
- Control structures: conditionals and loops
- Functions and their role in JavaScript
4.Server-side Web Applications
- Introduction to server-side programming using PHP
- Understanding PHP datatypes, variables, arrays, sessions, conditional statements and loops
- Importance of databases in modern applications, types of databases
- Introduction to Structured Query Language (SQL)
- SQL queries for creating tables and relationships
- Basic SQL querying, data retrieval and displaying data on web pages
- CRUD (Create, Read, Update, Delete) operations using PHP and MySQL
- SQL queries to filter, sort, and join data from multiple tables
Learning and Teaching
Teaching and learning methods
Lectures, labs and guided self-study
| Type | Hours |
|---|---|
| Supervised time in studio/workshop | 48 |
| Follow-up work | 10 |
| Preparation for scheduled sessions | 10 |
| Revision | 10 |
| Lecture | 48 |
| Completion of assessment task | 24 |
| Total study time | 150 |
Resources & Reading list
Textbooks
Luke Welling, Laura Thomson (2009). PHP and MySQL Web development. Upper Saddle River, NJ: Addison-Wesley.
Lewis Coulson, Brett Jephson, Rob Larsen, Matt Park, Marian Zburlea (2019). The HTML and CSS Workshop: a New Interactive Approach to Learning HTML and CSS. Birmingham: Packt Publishing, Limited,.
Larry E Ullman (2012). PHP and MySQL for dynamic Web sites. Berkeley, CA : Peachpit Press.
Ramez Elmasri and Shamkant B Navathe (2017). Fundamentals of database systems. Harlow: Pearson Education Limited.
Jennifer Niederst Robbins (2012). Learning Web design: a beginner's guide to HTML, CSS, JavaScript, and web graphics. Beijing ; Sebastopol, CA: O'Reilly.
Assessment
Assessment strategy
(Summative) Assessment Method:
Final Examination 40%
Continuous Assessment 60%
(Referral) Assessment Method:
Examination 100%
External Repeat Assessment Method:
Examination 100%
Summative
This is how we’ll formally assess what you have learned in this module.
| Method | Percentage contribution |
|---|---|
| Continuous Assessment | 60% |
| Final Assessment | 40% |