ASUx: Data Engineering

In Data Engineering, learn how to interact with databases using SQL.

Certification: Certificate of completion
Duration: 5 weeks
Price Value: $ 149
Difficulty Level: Introductory

ASUx: Data Engineering

About this Course

This course is designed to empower you with the skills needed to analyze and visualize data effectively. You'll engage with interactive videos and tackle a capstone project, where you'll apply your newly acquired knowledge to analyze a distinct data set. This hands-on project helps in building confidence and competence in handling real-world data analytics tasks.

This course is also integrated into a broader Data Analytics and Visualization Certificate program, offering a step towards professional accreditation in this field.

Course Highlights

Institution: ASUx
Subject: Data Analysis & Statistics
Level: Introductory
Prerequisites: None
Language: English
Video Transcript: English
Associated programs: Professional Certificate in Data Analytics and Visualization

What You'll Learn

Throughout this course, you will:

Understand the importance and functionality of databases in data storage.
Learn about common database structures, particularly the star schema.
Acquire techniques for joining data from multiple tables.
Develop the skills to write reporting queries and complex scripts for data processing.
Gain sufficient practice in writing SQL to analyze and evaluate databases.
Prepare to apply these skills in a business environment.

Who Should Enroll?

This course is ideal for:

Beginners to data analysis and statistics.
Professionals seeking to enhance their data handling capabilities.
Any learners interested in earning a professional certificate in Data Analytics and Visualization.

Applying Your Skills

Post completion of this course, you will be able to:

Confidently handle and analyze business data.
Influence business decisions through insights derived from data.
Improve operational efficiencies and business processes.
Pursue further academic qualifications or professional roles in data analysis and visualization.

ASUx: Data Engineering

ASUx: Data Engineering

In Data Engineering, learn how to interact with databases using SQL.

edX: Try It: Learn SQL

edX: Try It: Learn SQL

If you are looking to get into data analytics, SQL would be a great starting point.

SQL, or Structure Query Language, is used for cleaning and analyzing data stored in databases. It’s also used by some of the world’s largest companies. Gain highly-marketable skill in this free, no-risk introductory SQL course.

HarvardX: CS50's Introduction to Databases with SQL

HarvardX: CS50's Introduction to Databases with SQL

An introduction to databases using a language called SQL.

IBM: SQL for Data Science with R

IBM: SQL for Data Science with R

Build a baseline understanding about relational database concepts and learn how to apply foundational knowledge of the SQL and R languages through a series of hands-on labs to practice building and running SQL queries.

WisconsinX: SQL Fundamentals

WisconsinX: SQL Fundamentals

Learn the fundamentals of SQL and database management.

StanfordOnline: Databases: Semistructured Data

StanfordOnline: Databases: Semistructured Data

This course is one of five self-paced courses on the topic of Databases, originating as one of Stanford's three inaugural massive open online courses released in the fall of 2011. The original "Databases" courses are now all available on edx.org.

Part of the Databases series, this is a standalone course; learners seeking to develop an understanding of topics in this course do not need to take other Databases courses. This course covers the JSON and XML standards for semistructured data, along with query languages and schema declaration features for XML.

The XML Data section of this course introduces the XML model for semistructured and self-describing data, including DTDs and some features of XML Schema.
The JSON Data section of this course introduces the JSON model for human-readable structured or semistructured data.
The XPath and XQuery section of this course covers the XPath language for processing XML data, along with many features of the more advanced XQuery language.
The XSLT section of this course provides a general introduction to the XSLT rule-based language for querying and transforming XML data.

DavidsonX: Introduction to SQL

DavidsonX: Introduction to SQL

In this introduction to SQL Online Course you will gain strong underdstanding and utilize SQL to aggregate, manipulate, and analyze data in your field.

ASUx: Business Intelligence and Data Analytics

ASUx: Business Intelligence and Data Analytics

Using Excel, learn the basics of business analytics and the importance of the role to obtaining crucial information for the organization.

UMBC: Relational Database Management Systems

UMBC: Relational Database Management Systems

Learn how to create and interact with a relational database. The course includes Data Definition Language (DDL) used for database creation and Data Manipulation Language (DML) used for inserting, updating and deleting data in the database.

StanfordOnline: Databases: OLAP and Recursion

StanfordOnline: Databases: OLAP and Recursion

This course is one of five self-paced courses on the topic of Databases, originating as one of Stanford's three inaugural massive open online courses released in the fall of 2011. The original "Databases" courses are now all available on edx.org.

This course builds on concepts introduced in Databases: Relational Databases and SQL and is recommended for learners seeking to understand On-Line Analytical Processing (OLAP) and/or recursion in the SQL language.

The On-Line Analytical Processing section of this course introduces star schemas, the data cube concept, and OLAP features in relational databases including the Cube and Rollup operators.
The Recursion section of this course covers the SQL standard for queries over recursively-defined relations.