Skip to content
learning path

The Basics of Data Management, Data Manipulation and Data Modelling

Beginner
Up to 12h 2m
3,059
4.8/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
3
1
COURSE
Beginner
35m 14s
Working With Data Sets
This lesson focuses on understanding common data formats and interfaces. It explores some common data formats that you'll encounter as a data engineer.
HANDS-ON LAB
Beginner
Up to 1h
Acquiring and Storing Data in Python
This lab is aimed at students, with a moderate understanding of Python, who want to understand how to query an API, manipulate the data and store that data into a database with a more advanced schema.
COURSE
Beginner
1h 6m
Introduction to SQL
In this Lesson, you will learn how to read and write data using structures created with the language SQL.
HANDS-ON LAB
Beginner
Up to 8h
SQL Language
In this lab, you will complete a series of exercises that cover all the important components of the language and allow you to practice your SQL.
HANDS-ON LAB
Beginner
Up to 1h
Run Your First SQL Queries
In this Lab, you will practice the basics of SQL by connecting to a Microsoft SQL Server instance and then creating, managing and viewing data using a combination of user interface tools and SQL queries.
EXAM
Up to 20m
Knowledge Check: Introduction to Databases - Working with Datasets
Knowledge Check: Introduction to Databases - Working with Datasets

Take this course to get the basics of everything data-related. Learn about data sources, data formats, databases, and SQL.

This course focuses on understanding common data formats and interfaces. It explores some common data formats that you'll encounter as a data engineer and you'll get a deep understanding of the pros and cons of storing your data in different ways. You'll also learn how data sets can be accessed and viewed differently if you were to just simply store it in a different fashion. After that, we'll move on to SQL, starting with a brief overview and history of the SQL standard. You'll then learn how to read and write data using structures created with the language SQL. 

This course comes complete with hands-on labs so that you can put your newly-acquired knowledge into practice, and also includes a final exam, so you can assess your understanding of the topics covered.

If you have any feedback relating to this course, please contact us at support@cloudacademy.com. 

Learning Objectives

  • Learn about different data sources and formats, and how to model your data
  • Get acquainted with the common data formats — CSV, XML, and JSON — as well as specialized data formats
  • Learn about databases and how to exchange data between applications
  • Recognize and explain the structured query language
  • Understand how to read and write SQL commands

Intended Audience

  • Aspiring data engineers
  • Anyone looking to gain a practical, hands-on understanding of data modeling and for those who might want to change how they're storing their data

Prerequisites

To get the most out of this course, you should have a basic understanding of computing services and a high-level understanding of databases. Knowledge of what a CSV and a JSON are would also be beneficial.

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,208
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
Development
Databases
Python