Web Development II module (GA22008)
CQF Level 8 module introducing server-side web development using PHP and SQL, with practical experience building database-driven web applications
Web Development II moves beyond front-end technologies to focus on server-side web development at SCQF Level 8.
You will be introduced to SQL, including data query language (DQL), functions, joins, and data manipulation and definition language (DML/DDL) statements.
The module then covers PHP programming, including variables, data types, functions, and superglobals, and shows you how to use PHP to interact with databases and build simple web applications.
Assessment draws on the work-based learning ethos of the Graduate Apprenticeship, with tasks designed to be work-based, work-related, or project-based wherever possible.
What you will learn
In this module, you will:
- Write SQL queries using DQL, functions, and joins to retrieve and manipulate data
- Use DML and DDL statements to manage database structure and content
- Write PHP scripts using variables, data types, functions, and superglobals
- Interact with relational databases using PHP to create dynamic web content
- Build simple web applications combining server-side scripting and database integration
By the end of this module, you will be able to:
- Understand and use server-side programming languages including PHP and SQL
- Demonstrate an ability to use core server-side web technologies to build database-driven applications
- Develop and apply problem-solving, communication, time-management, self-assessment, and independent study skills
Assignments / assessments
Application Implementation - Coursework (70%)
- Assessment is entirely by coursework, which may be work-based, work-related, or standard project work.
- Tasks draw on the server-side web development skills developed throughout the module, including PHP programming and SQL database interaction. Students are expected to design and implement a web-application.
Application Report - Coursework (30%)
- Assessment is entirely by coursework, which may be work-based, work-related, or standard project work.
- Students are expected to write a report about the application developed in the first assignment.
This module does not have a final exam.
Teaching methods / timetable
- Tutorial sessions introducing concepts through demonstrations and examples
- SQL Concepts
- Server-side Scripting with PHP
- Connecting PHP to a database
- Async Requests (AJAX, Fetch)
- Practical coding sessions where students develop skills by solving coding problems with academic support