This page has 0 threads | Add post

Group classroom and online training courses

Three-day fast-track Python programming course

Three days (09:30 to 16:30 UK time each day)

This course is available in the following formats (all prices exclude VAT):

Classroom (London)
£1,895

Classroom (Manchester)
£1,595

Onsite (your office)
Please ask

Online (your home)
£1,295

You can book a place on this course either online through this website, by phone, by email or by filling in our enquiry form.

You will find this course difficult if you can't tick one of the following two boxes:

You've a fair amount of previous programming experience (the language is not that important); or
You find it easy to understand nested IF functions in Excel, enjoyed maths at school or have a naturally logical mind.

Course schedule

Here are our next few Fast track Python course dates:

Dates	Times	Venue	Price (excl. VAT)
12-14 Jun	09:30-16:30	Online	£1,295	Book
12-14 Aug	09:30-16:30	Online	£1,295	Book
14-16 Oct	09:30-16:30	Online	£1,295	Book
02-04 Dec	09:30-16:30	Online	£1,295	Book
29-31 Jan	09:30-16:30	Online	£1,295	Book
Show full list of dates

Got a handful of like-minded people in your organisation? You could consider booking your own customised onsite course, whereby you get to pick the dates and venue!

Course Contents - PDF

Fast track Python - Course Contents

Our three-day fast-track Python course combines topics from our two-day Introduction to Python course and our three-day Advanced Python course, and is aimed at those who are confident that they will be able to cover material quickly. Here's how the course will typically unfold:

you'll spend the first two days learning the theory of Python programming; then
the last day putting it into practice for things like scraping websites and creating and manipulating Pandas dataframes (think Excel, but witthout the glossy user interface or speed overhead)

If you find the thought of learning something for three continuous days daunting, and have a group of 3 or more people who want training, you may prefer to book a tailored course instead (in which case you can within reason choose the venue, the topics to be covered and the course dates).

This fast-track course combines topics from the following other Wise Owl courses:

From our INTRODUCTION TO PYTHON course

Basic coding

Python variables
Testing conditions
Printing and f-strings

Visual Studio Code

Installing extension
Configuring settings
Useful short-cuts

Running and debugging

The code runner extension
Stepping through code
Setting breakpoints

Ranges and loops

WHILE loops
Breaking out of loops
Ranges of numbers

Working with modules

Installing modules using PIP
System modules (OS and SYS)
Maths functions (MATH)

Sequences

Tuples versus lists
Iterating over sequences
Slicing sequences
Joining and splitting

Manipulating lists

Adding/removing items
Sorting lists
Shallow and deep copies

Files and folders

Reading and writing
Using WITH
Looping over lines
Looping over folders using GLOB

Error handling

The try clause
Handling exceptions

Working with data types

Manipulating strings
Numbers and Booleans
The DATETIME module

From our ADVANCED PYTHON PROGRAMMING course

Working with sets

Sets versus lists
Examples of set use

Dictionaries

Key/value pairs
Retrieving items
Looping over items

Functions

Defining functions
Passing arguments
Optional arguments
Modular programming

Scraping websites

Understanding HTML
The REQUESTS module
Using BeautifulSoup

Comprehensions

List comprehensions
Generators

Working with CSV files

Reading and writing CSV files
Dictionaries using the CSV module

Working with Excel

Using OPENPYXL
Workbooks, worksheets and cells
Python for Excel or VBA?

Working with JSON

The JSON module
Loading and dumping data

Working with databases

The PYODBC module
Connections and cursors

Overview of Tkinter if time

Creating windows
Drawing forms with widgets
Assigning events

Overview of NUMPY

Shapes, ranks and data types
Slicing arrays
Array operations

Overview of Pandas

Dataframes and series
Reading/writing dataframes
Filtering, sorting and renaming
Dataframe calculations

Power BI and Python if time

Getting Python data
Python visuals using dataframes

Why Choose Us?

Here are some reasons to choose Wise Owl courses:

No more than 6 people per class
581 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

In addition, here are some benefits unique to classroom training:

Proper restaurant lunch included

And some benefits specific to online training:

Courseware manual posted to you in advance
Free half-hour pre-course check-up included
Our clever system means you can use our laptops (and we can see them)

What other people have said

Our thanks to everyone who agreed to share their thoughts. All of the following reviews are from the last 3 calendar years:

"This course was pitched just right for our skill levels. Pacing and content were spot on. Our trainer was approachable and fielded all of our daft questions! The venue was located perfectly for the station. Materials provided in support of the course were really good and I'll keep them as reference. I can't think of anything that I would have liked to see changed. We chose this particular course as we were wanting to do a classroom based one (and Manchester was an ideal location) and we have been with Wise Owl before."

Nathan Cain (Home Office)

"The trainer was incredibly knowledgeable and made the training an enjoyable experience. I would recommend this course and Wise Owl."

Hiten Mistry (Ultimate Products Global Sourcing (UPGS))

"I thoroughly enjoyed it! It was the first excel course I’ve ever been on that was pitched at completely the right level. The tutor was very knowledgeable and took time to answer any queries we had. She checked in with us on our existing knowledge and then built on it. The practice tasks and the materials you go away with will mean I have the ability to regain knowledge on any tasks I don’t immediately start using. The snacks were also appreciated!"

Hazel Kimmitt (AA Projects Ltd / Drees & Sommer UK Ltd)

"I thought the training was a good introduction to SQL. The trainer was obviously very experienced and I found it useful that he explained why certain aspects were important, rather than just how. He was clear and easy to understand. "

Jessica Clark (West Berkshire Council)

"Great course, very informative and kept relevant to needs of the trainees."

Aron Bourne (Ultimate Products Global Sourcing (UPGS))

There are lots more where these came from (or just refresh this page to change the quotes shown).

How our training courses work

Below are some notes on how Wise Owl courses work, to help you decide whether they're for you or not.

What you'll need

If you book on a classroom course, the only thing you need to bring to the course is ... yourself! We even provide a notepad and a suprisingly nice pen for you to take notes with.

For online training you'll need two things:

A good internet connection (otherwise you'll have a frustrating time); and
A second screen (a requirement, not a nice-to-have!)

You can see full details of our online course requirements here.

When you book a place

If you book a place on one of our courses:

For classroom courses we will send out a joining email. That's it!
For online courses we will get in touch to organise a half-hour pre-course check to iron out any connection problems before the course (rather than during it).

Whatever type of course you book, we will also send you out a reminder a few days before the course is due to take place - not that (we hope) you'll have forgotten!

What you won't need

For classroom training, you won't need a computer - we (obviously) will provide that. However, you're welcome to use your own laptop if you prefer, providing that you have the correct software installed.

For online training you will need a computer, but you won't need to have any software installed. This is because you'll use Windows Remote Desktop to connect to our computers, and these will have all of the necessary files and software installed.

The start of the course

For online courses you will be able to join up to half an hour before the course begins. This will give you time to:

familiarise yourself with the set-up;
meet your trainer; and
get to know the other delegates!

For classroom training it's always nice if people arrive a bit early too, to give people time to meet each other (and drink coffee).

You'll be given a full colour courseware manual, an exercise booklet to go with the course and a USB stick for taking course files away (we'll post all this to you for online courses).

After the course

After the course finishes you'll receive a digital certificate proving your attendance (we will gladly send a paper copy on request also).

We don't have any formal arrangement for answering questions after the course, but if you get stuck on something and email your trainer they should (and nearly always do!) respond as quickly as their training schedule allows.

Related Courses

You might like to consider these related courses:

Introduction to Python

Introduction

2 day course

Advanced Python programming

Advanced

3 day course

This page has 0 threads

Add a new post