Description
Move from basic Python scripts to maintainable applications using Jupyter, regular expressions, structured data, automated tests and well-designed classes.
About this course
This course takes you from writing basic Python to working the way a professional Python developer does. You will use Jupyter Notebook, write regular expressions, read and store data in SQLite, CSV, JSON and XML, test and debug your code, and design classes with object-oriented programming. By the end you will build and test a multi-file application that reads, cleans and stores real data.
Who it is for
This course is for working developers, analysts, QA automation engineers and IT staff who already script in Python and now need to write larger programs that others can maintain.
Prerequisites
Comfortable writing basic Python: strings, lists, tuples, dictionaries, loops, conditionals and functions
An introductory Python course or equivalent work experience
Requirements
Works on Windows, macOS or Linux
Python 3 and Jupyter Notebook (both free)
A code editor such as Visual Studio Code (free)
What you will be able to do
- You will be able to use Jupyter Notebook to explore code and data, and know when to move notebook code into a reusable module.
- You will be able to write regular expressions with the re module to validate, search and extract fields from messy text.
- You will be able to read and write CSV, JSON and XML data and store records in SQLite with parameterized queries.
- You will be able to write unittest test cases with setUp and tearDown and step through failures with the Python debugger.
- You will be able to design classes that use properties, inheritance, class and static methods, and abstract base classes.
Syllabus
Jupyter Notebook as a working environment 1.5 hours
Notebooks and cell modes, Markdown cells, Magic commands, Getting help in a notebook, Moving code from notebooks into modules.
Expressive Python 2 hours
Lambda functions, Advanced comprehensions, The collections module (defaultdict, Counter), Sorting with key functions, Mutable and immutable objects, Modules and packages.
Regular expressions 2 hours
Regular expression syntax, The re module, Groups, search, findall and sub, Validating and extracting fields.
Working with data 3 hours
Virtual environments, SQLite with parameterized queries, CSV with DictReader and DictWriter, JSON and XML, Getting data from the web.
Testing and debugging 2 hours
The unittest module, setUp and tearDown, Timing code for performance, Stepping through failures with the debugger.
Classes and objects in depth 2 hours
Properties and private attributes by convention, Documenting classes, Inheritance and extending methods, Static and class methods, Abstract classes, How decorators work.
Capstone 1.5 hours
Parsing a text source, Storing results in SQLite, Modeling records with classes, Passing test suite.
Coaching sessions 1 hour
One-on-one or small-group coaching, scheduled with your coach.
How it is delivered
How you learn
On-demand asynchronous training with online support, plus 1 hour of coaching.
Live or in person
Live online or in-person sessions are available for an additional fee. Email admissions@wecancodeit.org for details.
TechCred
Eligible credential
Advanced Python 3 Programming
Reimbursement applies only to the credential approved in your TechCred application, so use the exact credential name shown on this page.
Funding
Ohio's TechCred program may reimburse eligible Ohio employers up to $1,000 per person, per credential, and up to $30,000 per application, for eligible costs such as tuition and certification costs.
TechCred's maximum is $1,000 per person, per credential, toward this price.
Timeline
The current application period opens at 9:00 a.m. on October 1, 2026 and closes at 3:00 p.m. on October 30, 2026.
Training must start no earlier than the first day of the application period and be completed within 12 months of the award date.
What we provide
For each learner, We Can Code IT provides an itemized per-person invoice that shows the exact credential name, and a certificate that shows the learner's name, the credential and the date earned (or the vendor's exam record for certifications). We can also send a written quote to include with your TechCred application.
Pricing is the same for all customers, whether or not you use TechCred.
We Can Code IT is an independent training provider. Being listed as an eligible TechCred provider is not an endorsement by the State of Ohio and does not guarantee funding. The Ohio Department of Development makes all TechCred decisions, so check the state's current program guidelines before you apply. Program details: the State of Ohio’s TechCred page.
Enroll your team
One or a few learners
Choose the number of seats, add the course to your cart and check out.
A group, or a written quote
Send the form below for group enrollment or a written quote to include with your TechCred application. We reply within one business day. You can also email admissions@wecancodeit.org.
We Can Code IT, LLC, 26300 Cedar Rd, Suite 1105, Beachwood, OH 44122. Registered with the Ohio State Board of Career Colleges and Schools, Registration No. 15-03-2064T.