HTQ Computing: Full Curriculum

Episode 1: Welcome to Your HNC Computing: What to Expect

This orientation lesson introduces you to the Pearson BTEC Higher Nationals in Computing and sets out what you can expect across both the Level 4 HNC and Level 5 HND. You will explore the 15 units that make up the qualification, understand how assessments work, and begin thinking about your own professional and academic goals. By the end of this lesson, you will have a clear picture of the journey ahead and the skills you will develop along the way.

Episode 2: Understanding Algorithms: The Building Blocks of Code

Algorithms are at the heart of every piece of software ever written, and this lesson unpacks what they actually are and why they matter. You will learn how to define a problem systematically, break it into logical steps, and represent those steps in a way that can be translated into code. From pseudocode to flowcharts, this lesson gives you the foundational tools every programmer needs before writing a single line.

Episode 3: Procedural Programming: Step-by-Step Code Execution

Procedural programming is one of the oldest and most widely used paradigms in software development, and understanding it is essential before exploring more complex approaches. This lesson walks you through how procedural code is structured, how execution flows from one instruction to the next, and how functions and procedures help organise logic into reusable chunks. You will see how languages like Python and C use procedural concepts to solve real problems.

Episode 4: Object-Oriented Programming: Classes, Objects and Inheritance

Object-oriented programming transformed the way developers build complex software, and this lesson explains why. You will explore the four core principles of OOP: encapsulation, abstraction, inheritance, and polymorphism, and learn how they enable you to model real-world entities as objects with data and behaviour. Practical examples show how these concepts come together in languages like Python and Java to create modular, maintainable code.

Episode 5: Event-Driven Programming: Responding to User Actions

Event-driven programming powers everything from graphical user interfaces to web applications, and this lesson explains how the paradigm works. You will learn what events are, how event listeners and handlers respond to user actions, and how the event loop processes input in real time. Examples from GUI frameworks and JavaScript-based web development illustrate how this approach differs from procedural and object-oriented models.

Episode 6: Implementing Algorithms in an IDE: Tools and Techniques

Writing code is one thing; writing code efficiently inside a professional development environment is another. This lesson introduces Integrated Development Environments and shows you how to implement your algorithms using the tools they provide, including code editors, debuggers, build systems, and version control integrations. You will gain practical experience putting your algorithmic thinking to work in a real IDE setup.

Episode 7: Debugging and Coding Standards: Writing Reliable Software

Every developer encounters bugs, and knowing how to find and fix them systematically is a core professional skill. This lesson covers the debugging process from error identification through to resolution, and introduces the coding standards that keep codebases readable, consistent, and maintainable. You will learn how to use debugging tools, read error messages effectively, and apply industry-standard conventions to your own code.

Episode 8: Networking Fundamentals: Principles and Protocols Explained

Networking is the invisible backbone of the modern digital world, and this lesson builds your foundational understanding of how data moves across networks. You will examine key networking principles including the OSI model and TCP/IP stack, explore protocols such as HTTP, DNS, DHCP, and FTP, and understand why these standards are essential for reliable communication between devices. This lesson sets the stage for everything that follows in the Networking unit.

Episode 9: Networking Devices: Routers, Switches and Their Roles

Networks are built from physical and virtual devices, each performing a specific role in moving data to its destination. This lesson introduces the core networking devices, including routers, switches, hubs, modems, access points, and firewalls, and explains what each one does and how they interact. You will learn how data is forwarded, filtered, and routed across different network segments to reach its intended recipient.

Episode 10: Network Topologies: Choosing the Right Architecture

The physical or logical arrangement of a network has a significant impact on its performance, reliability, and cost, and this lesson explores the most common topologies in use today. You will compare star, bus, ring, mesh, and hybrid layouts, understanding the advantages and limitations of each in different real-world scenarios. This knowledge underpins the design decisions you will make when planning networked systems.

Episode 11: Designing Efficient Networked Systems: Planning for Scale

Designing a network that performs well today and scales tomorrow requires careful planning and an understanding of several competing factors. This lesson walks you through the key considerations in network design, including bandwidth requirements, redundancy, latency, security, and cost, and introduces the principles that guide efficient system architecture. You will explore how professional network designers balance these demands in enterprise and SME environments.

Episode 12: Implementing Networks: Configuration and Connectivity

Theory becomes practice in this lesson as you explore how networks are actually implemented and configured. From assigning IP addresses and setting up subnets to configuring routing protocols and wireless access points, you will learn the practical steps involved in bringing a networked system to life. This lesson draws on common tools and technologies used by network engineers in the field.

Episode 13: Network Diagnostics: Troubleshooting Common Problems

When a network stops working, the ability to diagnose the problem quickly is invaluable, and this lesson gives you the tools to do just that. You will learn systematic troubleshooting approaches, explore diagnostic commands such as ping, traceroute, and nslookup, and work through common network faults including connectivity failures, misconfigured devices, and DNS issues. Real-world fault scenarios help you build confidence in your diagnostic skills.

Episode 14: Communication Skills for Computing Professionals

Being technically skilled is not enough on its own; computing professionals also need strong communication abilities to collaborate, present ideas, and manage client relationships effectively. This lesson focuses on the interpersonal and transferable communication skills that employers value most, including active listening, written communication, presentation techniques, and adapting your message to different audiences. You will reflect on your own current strengths and areas for development.

Episode 15: Critical Thinking and Reasoning in a Technical Context

Computing problems are rarely simple, and working through them requires the ability to reason carefully, question assumptions, and evaluate evidence before reaching conclusions. This lesson develops your critical thinking skills in a technical context, exploring how to analyse problems systematically, distinguish fact from opinion, and apply logical frameworks to complex challenges. These skills are essential not just for your studies but for your entire professional career.

Episode 16: Team Dynamics in Computing Projects: Collaboration and Conflict

Most computing projects involve teams, and understanding how those teams function is key to delivering successful outcomes. This lesson examines team dynamics including the stages of team development, common roles within project teams, communication patterns, and how to handle disagreement constructively. You will explore the specific challenges that arise in technical teams and consider strategies for building cohesive, high-performing groups.

Episode 17: Continuing Professional Development: Staying Ahead in Tech

Technology evolves rapidly, and professionals who fail to keep up risk being left behind. This lesson examines Continuing Professional Development as a structured approach to lifelong learning, exploring what CPD looks like in the computing industry, how professional bodies such as BCS and CITP support it, and how to create your own personal development plan. You will leave with a practical framework for taking ownership of your ongoing growth.

Episode 18: Ethics and Professional Responsibility in Computing

Computing professionals face a growing range of ethical dilemmas, from data privacy and algorithmic bias to intellectual property and environmental impact. This lesson explores the ethical responsibilities that come with working in technology, drawing on frameworks such as the BCS Code of Conduct and the ACM Ethics guidelines. You will consider real-world scenarios and develop your ability to reason through ethical challenges in a professional context.

Episode 19: Relational Database Concepts: Tables, Keys and Relationships

Relational databases are the most widely used form of data storage in the world, and this lesson introduces the core concepts that underpin their design. You will explore tables, rows, columns, primary keys, foreign keys, and the relationships between entities, gaining a clear mental model of how relational data is structured. This foundation is essential before moving on to the more advanced design and development activities in the unit.

Episode 20: Entity-Relationship Diagrams: Modelling Data Structures

Entity-Relationship diagrams are the standard tool for visualising and communicating database designs, and this lesson teaches you how to create and interpret them with confidence. You will learn the notation for entities, attributes, and relationships, explore cardinality and how to represent one-to-one, one-to-many, and many-to-many connections, and practise translating real-world scenarios into clear, accurate ER diagrams.

Episode 21: Normalisation: Eliminating Redundancy in Database Design

Data redundancy and inconsistency are two of the biggest problems in poorly designed databases, and normalisation is the process used to eliminate them. This lesson walks you through the first three normal forms, explaining the rules each one applies and the specific anomalies it resolves. You will work through practical examples, transforming a flat, unnormalised data set into a clean, normalised relational structure.

Episode 22: Building a Relational Database: SQL and Practical Development

With a solid design in place, the next step is building the database itself, and this lesson takes you through the practical process of creating tables, defining constraints, writing queries, and populating your database using SQL. You will learn the core SQL commands for data definition and manipulation, and explore how a relational database management system such as MySQL or PostgreSQL translates your design into a working system.

Episode 23: Database Testing: Verifying Against Requirements

A database that does not do what users need it to do is not fit for purpose, and this lesson focuses on how to test your database rigorously against both user requirements and system specifications. You will learn different testing approaches including functional testing, data integrity checks, and performance testing, and explore how to document your test results clearly to provide evidence of a working, reliable system.

Episode 24: Technical and User Documentation for Databases

Good documentation is what separates a professional database product from an informal prototype, and this lesson covers how to produce both technical and user-facing documentation for your database. You will learn what each type of document should contain, how to write clearly for different audiences, and how to use tools such as data dictionaries and user guides to support both developers and end users of your system.

Episode 25: Assessing IT Security Risks: Threats, Vulnerabilities and Impact

Every IT system faces threats, and the first step in managing security is understanding what those threats are. This lesson provides a structured approach to IT security risk assessment, covering common threat categories including malware, social engineering, insider threats, and physical attacks. You will learn how to assess the likelihood and impact of each risk and begin building the mindset of a security-conscious computing professional.

Episode 26: IT Security Solutions: Firewalls, Encryption and Access Controls

Once you understand the risks, the next step is knowing what tools and techniques are available to counter them. This lesson surveys the main categories of IT security solutions, including firewalls, antivirus software, intrusion detection systems, encryption, multi-factor authentication, and VPNs. You will explore how each solution works, what it protects against, and how organisations combine multiple layers of defence into a coherent security strategy.

Episode 27: Controlling Organisational IT Security: Policies and Procedures

Technical tools alone are not enough to secure an organisation; policies, procedures, and human behaviour are equally important. This lesson examines the mechanisms used to control IT security at an organisational level, including acceptable use policies, access control frameworks, security audits, and staff training programmes. You will explore how organisations implement and enforce these controls to reduce their exposure to security risks.

Episode 28: Managing Organisational Security: Governance and Compliance

Managing security in an organisation requires a strategic, governance-led approach that goes beyond day-to-day technical controls. This lesson explores security governance frameworks, the role of information security management standards such as ISO 27001, and how organisations maintain compliance with legal and regulatory requirements including GDPR. You will see how security management is structured at a senior level and understand the responsibilities involved.

Episode 29: Cyber Attack Types: From Phishing to Advanced Persistent Threats

Understanding the full range of cyber attack techniques is essential for building effective defences, and this lesson takes a detailed look at how attackers operate. From phishing and social engineering to ransomware, denial-of-service attacks, SQL injection, and Advanced Persistent Threats, you will explore each attack type, how it works, and what defenders can do to detect and prevent it. Real-world case studies bring the threats to life.

Episode 30: Defining Your Computing Project: Scope, Aims and Research Questions

Every successful computing project starts with a clearly defined scope, and this lesson guides you through the process of setting up your project for success. You will learn how to identify a suitable research topic, define your aims and objectives, formulate research questions, and articulate the boundaries of your project. This early planning work is critical for keeping your project focused and manageable throughout its lifecycle.

Episode 31: Research Methods and Data Collection for Computing Projects

Reliable data is the foundation of any credible project, and this lesson explores the range of research methods available to computing students. You will compare primary and secondary research approaches, examine data collection techniques including surveys, interviews, experiments, and literature reviews, and consider questions of validity, reliability, and ethical practice. By the end, you will be equipped to choose and apply the right methods for your project.

Episode 32: Exploring Business Requirements: Stakeholder Needs and Technical Feasibility

Successful computing projects must meet both technical and business requirements, and this lesson focuses on how to identify and explore those requirements through stakeholder engagement. You will learn how to conduct requirements gathering sessions, translate business needs into technical specifications, and assess the feasibility of different technical approaches. This business-aware mindset is a key differentiator for computing professionals at all levels.

Episode 33: Project Planning Techniques: Gantt Charts, Milestones and Risk Registers

A project without a plan is a project heading for trouble, and this lesson equips you with the tools to create robust, realistic project plans. You will learn how to use Gantt charts to schedule tasks, define milestones and deliverables, identify dependencies, and build risk registers to anticipate and mitigate problems. These are the same planning techniques used by professional project managers in the technology industry.

Episode 34: Presenting Recommendations: Communicating Findings to Stakeholders

Gathering data and drawing conclusions is only valuable if you can communicate your findings persuasively to the people who need to act on them. This lesson covers the art of presenting recommendations to stakeholders, exploring how to structure reports and presentations, tailor your communication style to different audiences, and handle questions and challenges with confidence. Strong presentation skills are among the most transferable assets any computing professional can develop.

Episode 35: Introduction to Software Development Lifecycles: A Comparative Overview

Software development lifecycles provide the structured frameworks that guide how software is built from initial idea to delivered product. This lesson introduces the key SDLC models including Waterfall, Spiral, RAD, and Agile, giving you a comparative overview of their philosophies, phases, and intended use cases. Understanding these models is essential for any computing professional involved in planning or delivering software projects.

Episode 36: Waterfall vs Agile: When Each Methodology Fits

The debate between Waterfall and Agile is one of the most important in software development, and this lesson gives you the knowledge to understand both sides. You will explore the structured, plan-driven approach of Waterfall alongside the iterative, adaptive principles of Agile frameworks such as Scrum and Kanban, and consider the practical factors that determine which methodology is most appropriate for a given project. Real examples illustrate how each plays out in practice.

Episode 37: Feasibility Studies: Assessing Technical and Business Viability

Before a software project begins in earnest, it is vital to assess whether it is actually worth doing, and the feasibility study is the tool used to make that assessment. This lesson covers the different dimensions of feasibility including technical, economic, operational, and legal considerations, and shows you how to structure a feasibility report that gives stakeholders the information they need to make an informed decision. You will work through a case study to practise the process.

Episode 38: Running an SDLC in Practice: Requirements to Delivery

Understanding lifecycle models in theory is one thing; applying them in practice is another, and this lesson bridges the gap by walking you through a full SDLC from requirements gathering to deployment and review. You will see how each phase connects to the next, how deliverables are produced, and how teams manage the pressures of real-world projects including changing requirements, resource constraints, and technical challenges.

Episode 39: Software Behavioural Design: Use Cases, UML and Modelling

Software does not just need to work correctly; it needs to behave in ways that users can predict and rely on, and this lesson introduces the design techniques used to model and communicate that behaviour. You will explore use case diagrams, sequence diagrams, state machine diagrams, and other UML artefacts that help developers visualise how a system should respond to different inputs and events. These tools are central to professional software design practice.

Episode 40: Organisational Structures in the Digital Era

The digital economy has transformed the way organisations are structured and managed, and this lesson examines those changes through the lens of organisational theory. You will explore different types of organisational structures including hierarchical, flat, matrix, and network models, and consider how digital transformation is reshaping them. Understanding organisational culture and structure is essential context for any computing professional working within or alongside businesses.

Episode 41: Stakeholders in Digital Organisations: Roles, Interests and Influence

Every organisation operates within a web of stakeholders whose interests, expectations, and levels of influence vary enormously, and this lesson helps you navigate that complexity. You will explore who stakeholders are, how to map their relationships to an organisation, and how digital transformation is changing stakeholder dynamics in the modern business environment. Understanding stakeholder management is a core competency for computing professionals working on projects and products.

Episode 42: Digital-Led Management: Leadership in Technology-Driven Businesses

Technology-driven organisations require leaders who understand not just the business but also the digital tools and systems that power it. This lesson explores what digital-led management looks like in practice, examining how senior leaders in technology companies balance strategic vision with operational execution. You will consider how digital capabilities are changing leadership styles, decision-making processes, and the skills required to lead effectively in the modern economy.

Episode 43: Motivation and Performance in Digital Teams

Building high-performing digital teams requires an understanding of what motivates people and how behaviour influences outcomes. This lesson draws on established motivation theories including Maslow, Herzberg, and Vroom and applies them to the context of technology teams and remote working environments. You will explore how managers can create conditions that drive performance, engagement, and job satisfaction in computing-focused organisations.

Episode 44: Digital Transformation: Managing Organisational Change

Digital transformation is one of the most significant challenges facing organisations today, requiring them to rethink processes, culture, and strategy simultaneously. This lesson examines what drives digital transformation, how organisations manage the change process, and what the most common obstacles to success look like. Drawing on real-world examples from industries including retail, finance, and healthcare, you will explore what it takes to lead a successful transformation programme.

Episode 45: Introduction to Computing Research Methodologies

Rigorous research is the foundation of credible computing scholarship, and this lesson introduces the methodological landscape you will need to navigate for your Level 5 research project. You will explore the philosophical underpinnings of research including positivism, interpretivism, and pragmatism, and see how these inform the choice of research design. Understanding research methodology at this level will strengthen every aspect of your project from design through to discussion.

Episode 46: Quantitative vs Qualitative Research: Choosing Your Approach

One of the most fundamental decisions in any research project is whether to take a quantitative, qualitative, or mixed-methods approach, and this lesson unpacks the trade-offs involved. You will explore the strengths and limitations of each paradigm, consider how the nature of your research question should guide your choice, and examine examples of computing research that has used each approach effectively. This lesson gives you the conceptual clarity to make an informed decision for your own project.

Episode 47: Conducting Computing Research: Data Collection and Analysis

With a methodology in place, the work of actually collecting and analysing data begins, and this lesson takes you through that process in detail. You will explore a range of data collection methods suitable for computing research including surveys, structured interviews, system logs, experiments, and literature analysis, and learn how to apply appropriate analytical techniques to make sense of what you find. Rigour, transparency, and ethical practice are central themes throughout.

Episode 48: Communicating Research Outcomes: Reports, Presentations and Artefacts

Research findings are only valuable if they reach the right audience in an accessible and compelling form, and this lesson focuses on the communication of your outcomes. You will learn how to structure a research report, write an abstract, present findings visually, and prepare a conference-style presentation or practical artefact. Clear, honest, and well-evidenced communication is a hallmark of professional computing research.

Episode 49: Reflecting on Research: Critical Evaluation of Methods and Findings

Critical self-reflection is what distinguishes a good researcher from a great one, and this lesson develops your ability to evaluate your own research process honestly and constructively. You will explore frameworks for reflective practice, consider what went well and what you would do differently, and examine how the methodological choices you made affected the validity and reliability of your findings. This reflective mindset will serve you throughout your professional career.

Episode 50: The Role of Data in Modern Business Processes

Data has become one of the most valuable assets in modern business, but its role in supporting business processes is often poorly understood. This lesson examines how organisations collect, store, process, and use data to inform decisions, streamline operations, and create value for customers. You will explore the distinction between data and information, and consider how different types of business data flow through key processes in organisations of all sizes.

Episode 51: Data Ethics and Governance: Implications of How We Use Information

The widespread use of data brings with it serious ethical and legal responsibilities, and this lesson examines those implications in depth. You will explore the principles of data protection legislation including GDPR, consider issues of consent, transparency, and data minimisation, and examine real cases where organisations have faced consequences for mishandling data. Developing a strong ethical compass around data use is an essential part of professional practice in computing.

Episode 52: Data Science Tools and Technologies: An Applied Overview

Data science is a rapidly evolving field with a rich ecosystem of tools and technologies, and this lesson gives you a comprehensive overview of the landscape. You will explore programming languages and libraries including Python, R, pandas, and scikit-learn, examine data engineering tools and platforms, and consider how cloud computing is changing the way data science work is done. This lesson equips you to navigate the tools available and choose the right ones for specific tasks.

Episode 53: Applying Data Science Techniques to Business Problems

Understanding data science techniques in theory is one thing; applying them to real business problems is another, and this lesson bridges that gap. You will work through the application of core data science methods including data cleaning, exploratory analysis, machine learning classification, and predictive modelling to realistic business scenarios. By the end of this lesson, you will have a clearer sense of how data science delivers value in practice.

Episode 54: Data Visualisation and Storytelling for Business Decisions

Data alone does not drive decisions; it is the clear and compelling presentation of data that influences action, and this lesson focuses on the art and science of data visualisation. You will explore principles of effective chart design, examine tools including Tableau, Power BI, and Python's matplotlib and seaborn libraries, and practise constructing visualisations that tell a clear story. Effective data storytelling is a highly valued skill in every sector that uses data.

Episode 55: Traditional vs Agile Systems Analysis: Comparing Methodologies

Systems analysts have a range of methodologies to choose from, and understanding which to apply in which context is a critical professional skill. This lesson provides a detailed comparison of traditional structured methodologies such as SSADM and Waterfall with agile systems analysis approaches, examining the assumptions, processes, and outputs of each. You will develop the analytical framework needed to evaluate methodologies critically and justify your choices in professional settings.

Episode 56: Conducting a Systems Feasibility Study: What Makes a Project Viable?

Before any system is built, there must be a credible case for building it, and the feasibility study is the document that makes that case. This lesson takes you through the process of producing a professional feasibility study for a proposed system, covering technical feasibility, economic justification, operational viability, legal compliance, and scheduling considerations. You will see how each dimension of feasibility contributes to an overall recommendation for or against proceeding.

Episode 57: Systems Analysis Methodologies: SSADM, DSDM and Beyond

Systems analysis has a rich history of structured methodologies, and this lesson examines some of the most significant ones in depth. You will explore SSADM, Structured Systems Analysis and Design Method, alongside DSDM, Dynamic Systems Development Method, and consider how each approach handles requirements gathering, process modelling, and system specification. Understanding these methodologies contextualises the broader evolution of systems thinking in computing.

Episode 58: Designing Systems to Meet Requirements: From Concept to Blueprint

A system that meets user needs is built from a well-thought-out design, and this lesson walks you through the design process from initial concept to detailed specification. You will learn how to translate requirements into architectural decisions, produce data flow diagrams and system models, and document your design in a way that guides the development team. Good system design is the difference between a project that succeeds and one that fails at the implementation stage.

Episode 59: User Requirements and System Specifications: Getting It Right

Getting requirements right is one of the hardest challenges in systems development, and this lesson explores the techniques that help analysts elicit, document, and validate what users actually need. You will compare requirements elicitation methods including interviews, workshops, observation, and prototyping, and learn how to express requirements clearly in both functional and non-functional terms. Accurate requirements specifications lay the groundwork for every subsequent design and development decision.

Episode 60: Network Management Concepts: Monitoring, Performance and Availability

Managing a network involves far more than just keeping it running; it means actively monitoring performance, maintaining availability, and planning for capacity over time. This lesson introduces the core concepts of network management including fault management, configuration management, performance monitoring, security management, and accounting management. You will see how these disciplines come together in a unified network operations strategy.

Episode 61: Planning and Designing a Managed Network Infrastructure

Planning a managed network begins with a clear understanding of the organisation's requirements and constraints, and this lesson guides you through that planning process. You will explore how to gather and interpret network requirements, select appropriate architectures and technologies, design for redundancy and resilience, and document your plans in a form that supports implementation. Professional network planning is a structured, methodical discipline that this lesson brings to life.

Episode 62: Configuring and Setting Up Network Systems: Hands-On Approaches

Network configuration is where design meets reality, and this lesson takes you through the practical process of setting up and configuring network systems. You will explore how to configure routers, switches, VLANs, wireless networks, and firewall rules, and examine the commands and interfaces used in common network operating systems. Hands-on configuration skills are among the most sought-after abilities in the networking profession.

Episode 63: Network Protocols and Standards: SNMP, ICMP and Compliance

Standards and protocols are the common language that makes networks interoperable, and this lesson examines the key ones used in network management. You will explore SNMP, Simple Network Management Protocol, ICMP, the Internet Control Message Protocol, and related standards, understanding how each contributes to the ability to monitor, control, and troubleshoot networks. Compliance with these standards is a practical requirement in professional network environments.

Episode 64: Network Management Tools: Security Monitoring and Threat Detection

Modern networks are managed and secured using a range of specialist tools, and this lesson introduces the most important ones. You will explore network monitoring platforms, log management systems, vulnerability scanners, and intrusion detection and prevention tools, examining how they work and how they are used together to maintain network security and performance. Understanding these tools is essential for anyone working in network operations or IT security.

Episode 65: Types of Database Management Systems: Relational, NoSQL and NewSQL

The database landscape has expanded enormously beyond traditional relational systems, and this lesson gives you a comprehensive overview of the different types of DBMS available today. You will compare relational databases with NoSQL systems including document stores, key-value stores, graph databases, and column-family stores, and explore emerging NewSQL platforms. Understanding this diversity equips you to choose the right database technology for any given scenario.

Episode 66: Designing a DBMS Using the Relational Model: Advanced Techniques

Designing a database at the Level 5 HND stage requires a deeper level of rigour and sophistication than the foundational work covered in Unit 4. This lesson revisits the relational model with fresh eyes, exploring advanced design concepts including complex key structures, referential integrity, transaction management, and concurrency control. You will apply these concepts to the design of a more complex database system that reflects real enterprise requirements.

Episode 67: Developing a Database Management System: Platform Selection and Build

Choosing the right platform for your DBMS is as important as the design itself, and this lesson explores how to make that decision and execute the development effectively. You will compare platforms including MySQL, PostgreSQL, Microsoft SQL Server, MongoDB, and Oracle, consider the factors that influence platform selection, and work through the process of building a functioning DBMS from your design specifications. Platform knowledge is a practical asset in any computing career.

Episode 68: Database Administration: User Management, Backups and Recovery

Database administration is a specialised and highly valued computing discipline, and this lesson introduces its core responsibilities. You will explore user account management and access control, backup and recovery strategies, database security hardening, and the routine maintenance tasks that keep a DBMS running reliably. Understanding database administration gives you a rounded perspective on the full lifecycle of a database system in production.

Episode 69: Query Optimisation and Performance Tuning in DBMS

A slow query can bring a busy application to its knees, and knowing how to identify and fix performance bottlenecks is an essential database skill. This lesson explores query optimisation techniques including indexing strategies, query execution plans, and the use of stored procedures and views to improve efficiency. You will also consider how database design decisions made early in a project can have lasting effects on performance at scale.

Episode 70: IoT Fundamentals: Architecture, Devices and Connectivity

The Internet of Things is reshaping industries from agriculture to healthcare, and this lesson provides the foundational understanding you need to engage with it as a developer. You will explore IoT architecture including edge devices, gateways, cloud platforms, and applications, examine the connectivity protocols that link them such as MQTT, CoAP, and HTTP, and consider the software design implications of working with resource-constrained, always-connected devices.

Episode 71: Planning an IoT Application: Requirements, Sensors and Data Flows

Turning an IoT concept into a working application starts with a well-structured plan, and this lesson guides you through that planning process. You will learn how to define the purpose and scope of an IoT application, identify the sensors and actuators required, map out the data flows between devices and cloud services, and produce a specification that can guide development. Solid planning is the foundation of a successful IoT build.

Episode 72: Developing an IoT Application: Platforms, Protocols and Prototyping

Developing an IoT application involves combining hardware, firmware, connectivity, and software in ways that require careful coordination, and this lesson takes you through the development process step by step. You will explore popular IoT development platforms including Arduino, Raspberry Pi, and cloud IoT services, examine the role of MQTT and REST APIs in connecting devices to backends, and work through the practical challenges of building a functioning IoT prototype.

Episode 73: Evaluating IoT Applications: Performance, Security and Usability

Building an IoT application is only the beginning; evaluating its performance, security, usability, and reliability is where you demonstrate professional rigour. This lesson introduces the evaluation frameworks and testing approaches appropriate for IoT systems, covering functional testing, load testing, security assessments, and user experience evaluation. You will learn how to document your evaluation findings clearly and use them to drive iterative improvement.

Episode 74: IoT Integration Challenges: Interoperability, Scalability and Standards

IoT systems rarely exist in isolation; they must integrate with existing IT infrastructure, third-party services, and other IoT ecosystems, and that integration is rarely straightforward. This lesson examines the most significant integration challenges in IoT including interoperability between different standards and platforms, scalability from prototype to production, data management at scale, and the security risks that arise at integration points. Understanding these challenges is essential for anyone designing real-world IoT solutions.

Episode 75: Technical Challenges for Digital Sustainability: Scope and Scale

The technology sector is one of the largest contributors to global energy consumption and carbon emissions, and this lesson establishes the scope of the sustainability challenge facing computing professionals. You will explore the environmental impact of digital infrastructure including data centres, devices, and networks, examine the specific technical challenges involved in reducing that impact, and consider why sustainability must become a core concern for the profession as a whole.

Episode 76: Cross-Disciplinary Collaboration for Sustainable Technology

Achieving meaningful progress on digital sustainability requires computing professionals to work alongside colleagues from other disciplines including engineering, environmental science, business, and policy. This lesson explores what cross-disciplinary collaboration looks like in practice, examining how different professional perspectives contribute to sustainability solutions and how computing specialists can communicate effectively with non-technical partners. Collaboration across boundaries is increasingly a defining characteristic of sustainable innovation.

Episode 77: Sustainable Software and Hardware: Green Computing Techniques

Green computing encompasses a range of techniques for reducing the environmental impact of software and hardware, and this lesson surveys the most effective ones. You will explore energy-efficient coding practices, hardware lifecycle management, server virtualisation and consolidation, cloud computing's sustainability trade-offs, and the emerging field of sustainable software engineering. Practical techniques are illustrated with real-world examples from organisations that have made measurable progress.

Episode 78: Calculating Carbon Footprint: Measuring Digital Environmental Impact

You cannot manage what you cannot measure, and calculating the carbon footprint of digital systems is a critical first step in any sustainability strategy. This lesson introduces the methods and tools used to measure the environmental impact of IT operations, from device energy consumption to data centre power usage effectiveness and the carbon intensity of electricity grids. You will work through a structured approach to calculating and reporting digital carbon footprints.

Episode 79: Energy-Efficient Data Centres and Cloud Infrastructure

Data centres consume vast amounts of energy, and the choices made in designing and operating them have significant environmental consequences. This lesson examines the approaches being taken to reduce data centre energy use, including advanced cooling systems, renewable energy procurement, server efficiency improvements, and the concept of Power Usage Effectiveness as a key performance metric. Cloud infrastructure and its sustainability profile are also explored in depth.

Episode 80: Building a Sustainable Digital Future: Strategy, Policy and Action

This final lesson brings together everything you have learned about digital sustainability and looks forward to the challenges and opportunities that lie ahead. You will examine how industry, government, and the technology profession are working together to build a more sustainable digital future through standards, policy frameworks, and technical innovation. By the end of this lesson, you will have a clear sense of how your own career can contribute to a more sustainable world, and the practical knowledge to begin making that contribution.