20–24 Sessions 10–12 Weeks 2–3 Hrs / Session Level 1 (Website Dev with AI) or Equivalent

This is Level 2 of the Web Programming series. In Level 1 you learned to build complete, responsive, static websites using HTML, CSS, Bootstrap, and JavaScript. This course turns those static sites into real, dynamic web applications. You will learn how a server, a database, and a browser talk to each other — and you will build that entire chain yourself using PHP, MySQL (via phpMyAdmin), and an introduction to SQL Server as a more powerful database backend — all while continuing to use AI coding assistants to write, explain, debug, and speed up your code.

Click Here to Enroll
Part 1 — From Static Sites to Full-Stack Applications

Module 1: What Makes an Application "Full-Stack"?

  • Recap: what Level 1 covered (static front-end only)
  • Static websites vs. dynamic web applications
  • The client-server model: browser, web server, database
  • How a form submission travels from HTML → PHP → MySQL → back to the browser
  • Overview of the tools used in this course: PHP, MySQL, phpMyAdmin, SQL Server
  • How AI coding assistants will be used across the whole stack, not just the front-end

Module 2: Setting Up Your Full-Stack Development Environment

  • Installing a local server environment (XAMPP/WAMP, or IIS + PHP as an alternative)
  • Installing and configuring MySQL
  • Installing and configuring phpMyAdmin
  • Setting up your code editor (VS Code) with an AI coding assistant
  • Creating your first PHP-enabled project folder and testing it locally

Module 3: Git & Version Control Basics

  • Why version control matters, even for solo projects
  • Installing Git and creating a repository
  • Basic commands: init, add, commit, status, log
  • Using a remote repository (e.g., GitHub) to back up and share your project
  • Using AI to explain a Git error or suggest the right command
Part 2 — Databases with MySQL & phpMyAdmin

Module 4: Introduction to Relational Databases

  • What is a database, and why applications need one
  • Tables, rows, columns, and data types
  • Introduction to the phpMyAdmin interface
  • Creating your first database and table through phpMyAdmin

Module 5: SQL Basics — Reading & Writing Data

  • SELECT, WHERE, ORDER BY, LIMIT — retrieving and filtering data
  • INSERT, UPDATE, DELETE — modifying data safely
  • Running and testing queries directly in phpMyAdmin's SQL tab
  • Using AI to write and explain SQL queries from a plain-language request

Module 6: Table Relationships & Database Design

  • Primary keys and foreign keys
  • One-to-many and many-to-many relationships explained
  • Designing a simple relational schema (e.g., Customers, Products, Orders)
  • Basic JOIN queries to combine data from multiple tables
  • Using AI to review and improve a database schema design
Part 3 — PHP: Back-End Programming

Module 7: PHP Basics

  • What is PHP, and how it runs on a web server
  • Embedding PHP inside HTML, .php file basics
  • Variables, data types, and operators
  • Using AI to explain unfamiliar PHP syntax

Module 8: PHP — Logic & Control

  • Conditional statements: if, else, elseif
  • Loops: for, while, foreach
  • Writing and calling functions
  • Arrays and associative arrays
  • Practicing prompts like "write a PHP function to validate a phone number"

Module 9: PHP Forms — Getting Data from Users

  • Handling form submissions with $_GET and $_POST
  • Validating and sanitizing user input (security basics)
  • Displaying submitted data back to the user
  • Using AI to review form-handling code for common mistakes

Module 10: Connecting PHP to MySQL

  • Introduction to MySQLi and PDO for database connections
  • Writing a secure database connection script
  • Running SELECT queries from PHP and displaying results in an HTML table
  • Using prepared statements to prevent SQL injection
  • Using AI to troubleshoot database connection errors
Part 4 — Full CRUD & Front-End Integration

Module 11: Building CRUD Functionality — Create & Read

  • Building a form to insert data into the database (Create)
  • Displaying database records dynamically on a webpage (Read)
  • Styling the data display with Bootstrap tables/cards
  • Using AI to generate a starting CRUD template, then customizing it

Module 12: Building CRUD Functionality — Update & Delete

  • Building edit forms that load existing data for editing
  • Updating records in the database
  • Deleting records safely, with confirmation prompts
  • Using JavaScript to add a "confirm before delete" interaction

Module 13: Connecting Front-End Design to Back-End Logic

  • Structuring a multi-page PHP application (reusable header/footer includes)
  • Passing data between pages (forms, URL parameters, sessions)
  • Styling dynamic PHP-generated content with Bootstrap and custom CSS
  • Adding JavaScript for smoother interactions (search filters, live validation)
  • Using AI to help connect a front-end form cleanly to a back-end PHP script

Module 14: Searching, Filtering & Displaying Data

  • Building a search feature using SQL WHERE clauses and PHP
  • Adding filters and sorting options to a data table
  • Pagination basics for larger data sets
  • Using AI to optimize a slow or overly complex query
Part 5 — Authentication, Security & SQL Server

Module 15: Sessions, Login & Basic Authentication

  • What are sessions and cookies, and why applications need them
  • Building a registration and login system
  • Password handling basics: hashing passwords (never storing plain text)
  • Restricting page access to logged-in users only
  • Using AI to explain and strengthen basic authentication logic

Module 16: Web Application Security Basics

  • Common vulnerabilities: SQL injection, cross-site scripting (XSS)
  • Using prepared statements and input sanitization consistently
  • Basic role-based access ideas (e.g., admin vs. regular user)
  • Using AI to review code for common security mistakes (without relying on it blindly)

Module 17: Introduction to SQL Server as a Backend

  • Why and when to consider SQL Server over MySQL (bigger applications, enterprise environments)
  • Overview of installing/accessing a SQL Server instance
  • Connecting PHP to SQL Server (drivers and connection basics)
  • Comparing MySQL and SQL Server syntax differences at a basic level
  • Using AI to help translate a MySQL query into SQL Server syntax

Module 18: Working with Both Databases in Practice

  • Running basic CRUD operations against a SQL Server-backed table
  • Understanding when a project might use MySQL vs. SQL Server
  • Basic data migration concepts (moving/exporting data between systems)
  • Using AI to assist with comparing and adapting schema between MySQL and SQL Server
Part 6 — Full-Stack Project & Course Wrap-Up

Module 19: Final Project — Complete Full-Stack Web Application

  • Planning a real-world mini application (e.g., a customer/order management system, or a simple booking system)
  • Designing the database schema (MySQL, with an optional SQL Server variant)
  • Building all front-end pages with HTML, CSS, Bootstrap, and JavaScript
  • Building the full back-end with PHP: forms, validation, and complete CRUD functionality
  • Adding login/session-based authentication and basic access control
  • Using Git to track progress throughout the build
  • Using AI coding assistants throughout — always reviewed and understood, never blindly copy-pasted

Module 20: Testing, Deployment & Course Wrap-Up

  • Basic testing: checking forms, queries, and edge cases for errors
  • Basics of deploying a PHP/MySQL application to shared hosting (overview)
  • Recap of the full stack covered: HTML, CSS, Bootstrap, JavaScript, PHP, MySQL, phpMyAdmin, SQL Server
  • Readiness check: the full-stack skills now in place before moving to Level 3 (Accounting & ERP with AI Agents)
  • Final project presentation and feedback
  • Q&A session and course completion certificate/assessment (optional)