Calculated Systems
This content is developed in partnership with Calculated Systems
AVG Duration4h


In this learning path, we dive into the various tools and techniques available for manipulating information and data sources. We then show you how you can use this knowledge to actually solve some real-world problems.

Intended Audience

If you are trying to handle increasingly complex data sets or want to increase your knowledge as a professional data engineer, this is a great learning path to get a practical field-based understanding.

Learning Objectives

  • Learn to determine when it's appropriate to use a programmatic approach versus pure SQL.
  • How to access and manipulate your files and data sources using programming techniques available to you in languages such as Python.
  • Learn how to use regular expressions to manipulate data and solve common data issues.


  •  Familiarity with relational databases and other data formats such as CSVs and JSON.
  •  Baseline understanding of SQL

 If you don't have all of these this learning path will still benefit you, but you might not be able to follow all of the examples.  

If you have any feedback relating to this content, feel free to reach out to us at


Your certificate for this learning path

Training Content

Course - Intermediate - 30m
Wrestling with Data
A deep dive into the various tools and techniques available for manipulating information and data sources along with showing you at the end of it how you can actually solve some real-world problems.
Hands-on Lab - Intermediate - 1h
Capturing New Knowledge from Your Data
In this lab, you'll learn how to utilize SQL aggregate functions and utilize complex functions, and learn how to get complex insights from your data.
Hands-on Lab - Beginner - 1h
Handling Variable Data in DynamoDB with Grace
This lab is aimed at students with a basic understanding of Python who want to learn about schemaless data and Amazon DynamoDB.
Hands-on Lab - Beginner - 1h
Working With Complex Rest APIs
This lab will dive into understanding GET, POST, DELETE, and PATCH HTTP verbs and will teach you to use Python to interact with an REST API.
Course - Intermediate - 1h 7m
Data Wrangling with Pandas
In this course, we are going to explore techniques to permit advanced data exploration and analysis using Python, focusing on the Pandas library.
Hands-on Lab - Beginner - 30m
Constructing Regular Expression Character Classes
In this hands-on lab, you will learn about the character classes and quantifiers elements of Regular Expressions, and use them to match patterns in text.
Hands-on Lab - Beginner - 30m
Working with Special Characters and Anchors in Regular Expressions
In this hands-on lab, you will work with regular expressions, learning how to use quantifiers, anchors, and capture groups to match patterns in text.
Hands-on Lab - Beginner - 1h
Using Regular Expressions Effectively in the Real World
Regular expressions are a powerful tool for searching and manipulating text. In this hands-on lab you will learn how to use them effectively in real-world scenarios.
Exam - 25m
Knowledge Check: Wrestling Your Data
Knowledge Check: Wrestling Your Data
About the Author
Learning paths33

Calculated Systems was founded by experts in Hadoop, Google Cloud and AWS. Calculated Systems enables code-free capture, mapping and transformation of data in the cloud based on Apache NiFi, an open source project originally developed within the NSA. Calculated Systems accelerates time to market for new innovations while maintaining data integrity.  With cloud automation tools, deep industry expertise, and experience productionalizing workloads development cycles are cut down to a fraction of their normal time. The ability to quickly develop large scale data ingestion and processing  decreases the risk companies face in long development cycles. Calculated Systems is one of the industry leaders in Big Data transformation and education of these complex technologies.