Modules
The school modules I have completed. Each card leads to its own page with what I learned, code examples and the key takeaways.
Automating Processes with a Scripting Language
Automating recurring tasks with Python scripts: data structures, control flow, functions, file handling and error handling.
Analysing and Modelling Data
From raw data to a clean model: analysing data in Excel, ER diagrams, the relational model, keys and normalisation up to 3NF.
Creating Databases and Inserting Data
Building MySQL databases: tables and data types, inserting and importing data, SELECT queries, joins, aggregation and foreign keys.
Realising the Frontend of an Interactive Web Application
Building an interactive web frontend with HTML, CSS and JavaScript: the DOM, events, JSON, CRUD over fetch() and client-side validation.
Implementing the Backend of an Application
A secure PHP backend without a framework: PDO, prepared statements, password hashing, sessions, validation and transactions.
Application Development with Java
Java fundamentals from problem analysis to working code: data types, control structures, methods, conventions and debugging.
Object-Oriented Programming
Thinking in objects: classes, encapsulation, relationships, ArrayList, inheritance, abstract classes, polymorphism and Comparable.
Designing and Implementing User Interfaces
Planning before building: user flows, wireframes, style guide and prototype in Figma, then components, forms and accessibility in HTML and CSS.