Skip to content
learning path

Wrestling with Data

Intermediate
Up to 6h 32m
1,206
5/5
Enroll
Enhance your skill setDevelop essential skills for thriving in real-world scenarios.
Stay focused, stay committedBoost your learning journey by enrolling: stay focused, consistent and achieve your goals with ease.
Earn a certificate of completionShow your skills and build your credibility when you include them in your resume and LinkedIn profile.

Training content

2
6
1
COURSE
Intermediate
Duration: 30 minutes and 13 seconds
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
Duration: Up to 1 hour and 15 minutes
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
Duration: Up to 1 hour
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
Duration: Up to 1 hour
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
Duration: 1 hour and 7 minutes
Data Wrangling with Pandas
In this lesson, we are going to explore techniques to permit advanced data exploration and analysis using Python, focusing on the Pandas library.
HANDS-ON LAB
Beginner
Duration: Up to 30 minutes
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
Duration: Up to 30 minutes
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.
See all

In this course, 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 course 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.

Prerequisites

  •  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 course 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 support@cloudacademy.com.

Your certificate for this learning path
Calculated Systems
This content is developed in partnership with Calculated Systems
Learn more

About the Author

Avatar
Calculated Systems, opens in a new tab
Training Provider
Students
32,724
Labs
31
Courses
13
Learning paths
42

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.

Covered Topics

SQL
Databases
Development
Python