Advanced Certificate in Python Programming

• HTML and CSS Refresher Overview
• Introduction to HTML
• Creating a HTML Hello World Page
• Understanding HTML Elements
• Working with HTML Attributes
• Creating Lists and Tables
• Applying HTML Styles
• Formatting HTML Content
• Using HTML Classes
• Creating Hyperlinks
• Creating HTML Forms
• Creating HTML Buttons
• Using Iframes
• HTML Style Guide
• HTML Refresher Summary
• HTML Refresher Quiz

• Introduction to CSS
• Understanding CSS Syntax
• Working with CSS Selectors
• Understanding the CSS Box Model
• Styling Text with CSS
• Styling Fonts with CSS
• Working with Icons
• Styling Links
• Styling Lists and Tables
• Transforming and Positioning Elements
• Using Important in CSS
• Using CSS Math Functions
• Using CSS Variables
• Creating Responsive Designs with Media Queries
• Using Flexbox
• CSS Refresher Summary
• CSS Refresher Quiz
• Introduction to Advanced Python Programming

• Front-End Project Demonstration
• Setting Up the Front-End Project
• Creating the Page Layout
• Placing Page Elements
• Adding Assets and Icons
• Adding the Product Card Content
• Filling the Comparison Table
• Styling the Front-End Project
• Bringing the Front-End Project Together
• Reviewing the Finished Front-End Project

• Introduction to Flask
• Working with Routes and Templates
• Managing Static Files
• Using the Request Object and HTTP Methods
• Using Template Inheritance
• Handling Form Data
• Working with Cookies and Sessions
• Using Redirects, Errors and Flash Messages
• Working with Flask Extensions
• Sending Mail with Flask
• Using Flask-WTF
• Using SQLAlchemy
• Deploying Flask Applications
• Flask Back-End Summary

• Full-Stack Project Introduction and Demo
• Setting Up the Project Folder Structure
• Creating a Flask Application
• Linking Static Files
• Creating the Application Database
• Setting Up Flask Login
• Building Login Functionality
• Creating Application Forms
• Creating User and Product Methods
• Creating Product Routes
• Adding Flash Messages
• Full-Stack Project Wrap-Up

• Recursion Part 1
• Recursion Part 2
• Recursion Part 3
• Complexity Analysis Part 1
• Complexity Analysis Part 2
• Sorting with Selection Sort
• Sorting with Bubble Sort
• Sorting with Insertion Sort
• Understanding Divide and Conquer Algorithms
• Implementing Recursive Merge Sort
• Analysing Merge Sort Complexity
• Implementing Iterative Merge Sort

• Installing NumPy and Using Key Functions
• Understanding NumPy Broadcasting
• Using NumPy Statistical Functions

• Installing Pandas and Getting Started
• Working with Series, Mutability and Dictionaries
• Working with Series and NumPy
• Using Statistical Functions, loc and iloc
• Filtering DataFrames
• Slicing DataFrames and Using GroupBy
• Using GroupBy, Pivot and Sorting Methods
• Comparing Pivot and Melt Methods
• Combining Data with Concat and Merge Part 1
• Combining Data with Concat and Merge Part 2
• Grouping by Weekday and Resampling
• Using String and Replace Methods
• Using Reindex, Query, Dropna and Fillna
• Reviewing Views, Selection and Slicing
• Using Shift, iat and Sub Methods
• Pandas Recap Part 1
• Pandas Recap Part 2
• Creating Visualisations with Seaborn Part 1
• Creating Visualisations with Seaborn Part 2
• Advanced Python Course Conclusion
• Final Course Message

You should be comfortable with variables, loops, functions and files. If that describes you, you are ready. If not, Python Programming covers exactly those foundations.

Yes. Flask is a third of the course: module 4 covers routes, templates, forms, sessions, email and SQLAlchemy on their own, and module 5 uses all of it to build one application with accounts and a database.

No. Python, Flask, SQLite, NumPy, pandas and Seaborn are all free, and nothing in the course needs an account with anybody. The Flask mail lesson describes sending through a Gmail account, which you can watch without setting one up.

Yes. It sits in the Python Programming Bundle alongside Python Programming, which is the better value if you want the full path from zero.

There is a 7-day money-back guarantee on every course. If you start and find you need the foundations first, we refund you and you can begin with Python Programming instead.

Eight modules and 106 lessons, about 22 hours of video, with written notes and key takeaways under every one and an interactive question on 62 of them. Eight checkpoints of eight questions each and a twenty-question final assessment at 80%. The modules are: an HTML refresher, a CSS refresher, a front-end project, Flask, a full-stack Flask application, algorithms and complexity, NumPy, and pandas with Seaborn.

Partly, and it is worth knowing before you buy. The first three modules are 44 of the 106 lessons and contain no Python: a refresher on HTML, a refresher on CSS, and a front-end project built with both. They are different recordings from the OBA Certificate in HTML & CSS rather than the same ones, so it is a second pass over similar ground. Nothing gates the later modules, so if you already have that material you can start at module 4 and lose nothing.

No. No project files, images or datasets ship with this course. The front-end project uses three images that were never delivered, and any square PNG stands in for them; the pandas lessons use the Titanic passenger list and an air-quality file, both of which are freely available and take a minute to find. Nothing in the course depends on having the exact files the presenter used.

Testing, packaging, type hints, asynchronous Python and building or consuming an API. Quicksort is mentioned and never taught, and the databases work stops at storing and reading back a handful of rows with SQLAlchemy and SQLite. If databases are where you want to go next, the OBA Certificate in SQL is the course for it.