Programming for Data Science with Python
Learn the four everyday tools of a data team, SQL, Python with pandas, the command line and Git, and how they work together.
$2,395.00
Learn the four everyday tools of a data team, SQL, Python with pandas, the command line and Git, and how they work together.
$2,395.00
Learn the four everyday tools of a data team, SQL, Python with pandas, the command line and Git, and how they work together.
This course introduces the four tools data teams use every day: SQL, Python with NumPy and pandas, the command line, and Git with GitHub. You will see how they fit into one workflow, from pulling data out of a database to sharing finished work. By the end you will query a database with SQL, clean and summarize the result in a Python script, run that script from the terminal, and keep your project under version control on GitHub.
This course is for analysts, reporting staff, business intelligence and operations staff who work in spreadsheets today and need to start working with databases, scripts and shared code.
Comfortable with spreadsheets and basic descriptive statistics
No prior SQL or Git experience needed
Some exposure to any programming language is helpful but not required
Works on Windows, macOS or Linux
Python 3 with NumPy and pandas (free)
A SQL database for practice, such as PostgreSQL (free)
Git and a free GitHub account
A terminal (built into macOS and Linux; on Windows, a terminal such as Git Bash)
Navigating folders, Working with files, Pipes and redirection, Running Python scripts from the terminal.
SELECT, FROM and WHERE, Logical operators, JOINs and when to use each type, COUNT, SUM, MIN and MAX, CASE, dates and NULLs.
Subqueries, Common table expressions, Window functions (RANK, NTILE, LAG, LEAD), Partitions.
Data types, Control flow, Functions, Reading files, Handling errors.
Arrays and broadcasting, Series and DataFrames, Loading data, Handling missing values, Descriptive statistics.
Configuring Git, init, clone, status, log and diff, Commits and .gitignore, Branches, merges and conflicts, Undoing changes, Pushing to GitHub.
Querying a database, Analysis in a pandas script, Running from the terminal, Publishing to GitHub.
One-on-one or small-group coaching, scheduled with your coach.
On-demand asynchronous training with online support, plus 2 hours of coaching.
Live online or in-person sessions are available for an additional fee. Email admissions@wecancodeit.org for details.
Programming for Data Science with Python
Reimbursement applies only to the credential approved in your TechCred application, so use the exact credential name shown on this page.
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.
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.
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.
Choose the number of seats, add the course to your cart and check out.
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.
