Welcome to the Python Programming module. Python is a great first programming language to learn. It's powerful, easy to write and is a real development tool, is used by professional programmers everywhere. This module will give you a good understanding of its main components.

Installing the Python programming language on a Windows 11 machine, and how to check that Python has been installed.

Installing Python and how to check that Python has been installed

Running a simple program using the IDLE interface.

Setting up IntelliJ for the first time, creating a project folder, writing and running a simple 'Hello World' program.

The old video on installing a coding editor, replaced by the Windows 11 version above.

Introduction to programming in Python, looking at storing numbers in Numeric variables

Introduction to programming in Python, looking at storing text in String variables

Getting Python to do something

Introduction to programming in Python, looking at storing dates in a date variable – Part 1

Storing dates in a date variable – Part 2

Extending what Python can do by using modules

An introduction to the standard operators in Python. These are used to make changes to your data.

Looking at coding conditional statements in Python

Looking at creating looping code in Python, to run sections of programming code repeatedly. Part 1

Continuing to look at creating looping code in Python, to run sections of programming code repeatedly. Part 2

Looking at Structured Data in Python, in this case, Lists. There are also Tuples and Arrays, but they are all very similar.

Creating an Interface program to allow users to communicate with the computer – Step 01

Creating an Interface program to allow users to communicate with the computer – Step 02

Creating an Interface program to allow users to communicate with the computer – Step 03

Creating an Interface program to allow users to communicate with the computer – Step 04

Creating an Interface program to allow users to communicate with the computer – Step 05

Creating an Interface program to allow users to communicate with the computer – Step 06

Creating an Interface program to allow users to communicate with the computer – Step 07

Creating an Interface program to allow users to communicate with the computer – Step 08

Using python to read the contents of a text file

An introduction to creating and using Classes in Python

Using the GET and TRY statements to handle exceptions

Handling GET and POST using the HTTPServer method

Output data to a text file

Well done for completing this module. You now have a good grounding in the main concepts of Python. Do you think you'll want to take it further? The concepts we've covered here are the same in 90% of the other languages out there, but there is a lot more to learn. Good luck!

Welcome to the SQL Module, where we'll cover the most important and frequently used features of SQL using the free to use Database; MySQL.

A history of how SQL and relational databases came about and some of the concepts behind them.

Downloading and installing the free community edition of MySQL under General Public Licence

An introduction to the WorkBench tool to help you navigate the various section

Creating a table in SQL by copying the structure of another table. Also a look at different Datatypes.

Adding data to the table you just created

Looking at the data in your new table by using the Select statement.

When you run a query in MySQL the Result Set can be too large. You need to add filters to return only the data that you are interested in.

Looking more complex filters and some of the issues around them

Making a change to the existing data in a record

Removing data from the database - careful now!

Manipulating text in the database by using String Functions

Manipulating numbers in the database by using Numeric Functions

Manipulating dates in the database by using Date Functions

Creating another table in the database, again by copying and adapting the structure of an existing table

Adding more data to the database. Then retrieve more data using the SQL wildcard symbols and the LIKE keyword

Retrieving data using a list of search items with the IN keyword

Placing one SQL query inside another query. The results of the inner query are then used as a filter for the outer SQL query

Joining 2 tables together to retrieve results from both

Removing a table from the database. Where you can look for help in writing SQL

Well done for reaching the end of this module. You now can say that you know SQL. But there is a lot more to know - this you think you'll continue with it? Rest assured, being able to use SQL is a skill that will help you in any career in IT.

Welcome to the Web Page module. I can't imagine a world where the internet no longer exists, it's everywhere. And the Internet is made up of billions of Web Pages; they are its basic building blocks. By the end of this module, you'll be able to create your own web pages and understand whether Web Development is something you might want to pursue.

An introduction on how Web Pages are constructed

How Browsers handle Web Pages

An introduction to HTML - Looking at existing Web Pages

An introduction to HTML - Using Notepad or IntelliJ IDEA

An introduction to HTML - creating HTML Links

An introduction to HTML - If you need Help

An introduction to HTML - writing content using HTML

An introduction to HTML - changing how the Web Page looks

An introduction to HTML - Introduction to Tables part 1

An introduction to HTML - Introduction to Tables part 2

An introduction to HTML - Introduction to Tables part 3

An introduction to HTML - Introduction to Tables part 4

An introduction to HTML - introducing Inline Blocks

An introduction to HTML - Formatting Inline Blocks

Downloading the FTP software

Setting up the FTP software to connect your PC to a Web Page

Using the FTP software to transfer content from your PC to a Web Page

Installing PHP

Check that PHP is installed

Setting up the php.ini file

Creating a PHP connection file containing Servername, Username, Password and Database

Using the connection file to connect to the Database

Using the IntelliJ IDEA editor for PHP

Using PHP to code an HTML table onto a Web Page

Creating an Input Form in PHP for the Web Page

Creating a SQL Query, within PHP, to display filtered database content on an HTML Web Page

Well done for reaching the end of this module. So what do you think about HTML and CSS and even creating some web code? Is this something you want to take further - there's a lot more to learn, but you've given yourself a good grounding in the fundamentals. Whatever you decide to do - Good Luck!

Welcome to the Mobile App module. The world will change more in the next 5 years than it did in the last 10. Whatever happens, the ability to create apps for mobile devices will be an important component. In this module, you'll learn the fundamental skills needed to create Android apps.

Installing the Hedgehog version of Android Studio on Windows 11. Includes creating your first project

Downloading and Installing Android Studio - this will take some time

Setting up Android Studio and creating a new Project.

An introduction to some of the windows and features within Android Studio

Creating the fundamental Mobile App, something that outputs 'Hello World'

What to do if Android Studio is not giving you the results you expect

Displaying the content, communicating with the user

Create an interaction by pairing the Toast pop-up with an 'on-click' event

Using Intent to open a second activity

Setting up the look and functions of the Mobile App

Entering text into the first activity, and then displaying that text in the second activity

How to set up a database in a Mobile App

How to set up a database in a Mobile App, continued.

Tidying up the content, layout and code to create a more portable solution

Tidying up more of the code, and using a more professional approach

Creating a new EditText by copying and pasting the XML to extend the functionality of our Mobile App

Inserting another record into the SQLite database

Things to consider when deploying the app

Well done for reaching the end of this module. So what do you think about Java? It's a different approach to programming - do you like it? It takes a bit of getting used to - but after a bit, Object-Oriented Programming begins to click. To be honest, I relied on the auto-complete a lot at the beginning, but after a while you find you use the same 100 or so structures again and again, so it becomes second nature. Good luck!

Welcome to the General IT module, where we'll look at general Computer Science, Computing Fundamentals, Graphical User Interfaces, Servers, Computer Viruses, and some advice on jobs and the future of IT.

Outline of the fundamental components and concepts in programming; Variables, Data structure, Control Structures and Functions.

The steps a PC goes through when it starts up

How a computer can communicate with an external device such as a printer

Why security is important and how secure are your passwords

One method that networks use to establish a connection

How computers move data around within their own circuits

Why data is stored on disks in the way it is.

Looking at Bits and Bytes

How hard disks work

Looking at USBs and the different ways they work

Computing has been around longer than you might think

Looking at the lives of the first two people who worked in IT

How are Passwords encrypted

Looking at how a Firewall can be used to protect networked computers by restricting access to one heavily guarded location

If you can tell someone how to make a cup of tea, then you too can program

How programs are tested.

The different methods of backing up data

How Operating Systems have come about and how they work

An introduction to the different types of Application Software

Learning about the fundamentals of User Interface Design and some of the history

How the computer manages images

How computers interact with users by listening for events

How Printers, Computer Mice, Flat Screens and Keyboards work and interact with your PC

Design is more important than some people think

How Servers manage requests and looking at different types of Servers

How Local Area Networks came about, how they manage data and what they do when data collisions occur.

How to say hello to a Sever

The way modern Server Farms manage things going wrong, by creating a safety net; the Fail-Over Server.

How to move information between multiple machines and around the World Wide Web

Scary - different types of computer viruses, their history and why you need to protect yourself against them.

Some of the methods anti-virus software uses to recognise a computer virus

Focussing on a particular virus

Looking at a type of 'virus' that works with email

Different types of virus attack

How organisations bring down hackers and stop attacks

Cleaning PC's once they have been attacked

General IT - how projects should be managed - more hopeful than realistic

A description of the main programming languages out there

An introduction to some of the job roles people do in IT

A look at the promise of the Internet of Things, when everything becomes connected