Foundations for Big Data Analysis with SQL (Coursera)

Offered by Cloudera,
Foundations for Big Data Analysis with SQL (Coursera)

In this course, you'll get a big-picture view of using SQL for big data, starting with an overview of data, database systems, and the common querying language (SQL). Then you'll learn the characteristics of big data and SQL tools for working on big data platforms. You'll also install an exercise environment (virtual machine) to be used through the specialization courses, and you'll have an opportunity to do some initial exploration of databases and tables in that environment.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

By the end of the course, you will be able to
• distinguish operational from analytic databases, and understand how these are applied in big data;
• understand how database and table design provides structures for working with data;
• appreciate how differences in volume and variety of data affects your choice of an appropriate database system;
• recognize the features and benefits of SQL dialects designed to work with big data systems for storage and analysis; and
• explore databases and tables in a big data platform.
To use the hands-on environment for this course, you need to download and install a virtual machine and the software on which to run it. Before continuing, be sure that you have access to a computer that meets the following hardware and software requirements:
• Windows, macOS, or Linux operating system (iPads and Android tablets will not work)
• 64-bit operating system (32-bit operating systems will not work)
• 8 GB RAM or more
• 25GB free disk space or more
• Intel VT-x or AMD-V virtualization support enabled (on Mac computers with Intel processors, this is always enabled;
on Windows and Linux computers, you might need to enable it in the BIOS)
• For Windows XP computers only: You must have an unzip utility such as 7-Zip or WinZip installed (Windows XP’s built-in unzip utility will not work)

What You Will Learn

  • Distinguish operational from analytic databases, and understand how these are applied in big data
  • Understand how database and table design provides structures for working with data
  • Appreciate how differences in volume and variety of data affects your choice of an appropriate database system
  • Recognize the features and benefits of SQL dialects designed to work with big data systems for storage and analysis

Course 1 of 3 in the Modern Big Data Analysis with SQL Specialization.

Syllabus

WEEK 1
Data and Databases
In this week, you'll get an overview of this Specialization and of Course 1. Then you'll learn about database systems and the distinction between operational and analytic databases.

WEEK 2
Relational Databases and SQL

WEEK 3
Big Data

WEEK 4
SQL Tools for Big Data Analysis

WEEK 5
Introduction to the Hands-On Environment

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Media ethics & governance (Coursera) Coursera
University of Amsterdam

Media ethics & governance (Coursera)

This course explores some of the basic theories, models and concepts in the field of media ethics. We will introduce influential ethical theories and perspectives, explore changing societal demands and expectations of media creation and media use, and we will elaborate on existing ethical norms for media professionals. After following this course, you will be able to reflect on ethical dilemmas and develop a well-substantiated argumentation for ethical decision making in a variety of media-related contexts.

Dec 14th 2026
4 Weeks
Security and Privacy for Big Data - Part 2 (Coursera) Coursera
EIT Digital

Security and Privacy for Big Data - Part 2 (Coursera)

This course sensitizes regarding privacy and data protection in Big Data environments. You will discover privacy preserving methodologies, as well as data protection regulations and concepts in your Big Data system. By the end of the course, you will be ready to plan your next Big Data project successfully, ensuring that all privacy and data protection related issues are under control.

Dec 14th 2026
1 Week
Combining and Analyzing Complex Data (Coursera) Coursera
University of Maryland, College Park

Combining and Analyzing Complex Data (Coursera)

In this course you will learn how to use survey weights to estimate descriptive statistics, like means and totals, and more complicated quantities like model parameters for linear and logistic regressions. Software capabilities will be covered with R® receiving particular emphasis. The course will also cover the basics of record linkage and statistical matching—both of which are becoming more important as ways of combining data from different sources. Combining of datasets raises ethical issues which the course reviews. Informed consent may have to be obtained from persons to allow their data to be linked. You will learn about differences in the legal requirements in different countries.

Dec 14th 2026
4 Weeks
Bioinformatic Methods I (Coursera) Coursera
University of Toronto

Bioinformatic Methods I (Coursera)

Large-scale biology projects such as the sequencing of the human genome and gene expression surveys using RNA-seq, microarrays and other technologies have created a wealth of data for biologists. However, the challenge facing scientists is analyzing and even accessing these data to extract useful information pertaining to the system being studied. This course focuses on employing existing bioinformatic resources – mainly web-based programs and databases – to access the wealth of data to answer questions relevant to the average biologist, and is highly hands-on.

Dec 14th 2026
5-12 Weeks
Assessing Health Program Delivery (Coursera) Coursera
Johns Hopkins University

Assessing Health Program Delivery (Coursera)

This course provides in-depth knowledge about implementation strength, quality of care, and service utilization, which are essential components of health program delivery. This course is primarily aimed at implementers, managers, funders, and evaluators of health programs in low- and middle-income settings (LMISs) targeting women and children, and undergraduate and graduate students in health-related fields.

Dec 14th 2026
5-12 Weeks
Relational Database Implementation and Applications (Coursera) Coursera
Illinois Tech

Relational Database Implementation and Applications (Coursera)

In today's data-driven world, the ability to work with relational databases is an essential skill for professionals in various fields. This course is designed to equip you with the knowledge and practical skills needed to become proficient in database management and application development. Whether you are pursuing a career as a database administrator, software developer, or data analyst, this course provides you with a strong foundation to excel in your chosen field.

Dec 14th 2026
5-12 Weeks
Analysis and Interpretation of Large-Scale Programs (Coursera) Coursera
Johns Hopkins University

Analysis and Interpretation of Large-Scale Programs (Coursera)

This course is for implementers, managers, funders, and evaluators of health programs targeting women and children in low- and middle-income countries as well as undergraduate and graduate students in health-related fields. Course participants will learn how to 1) transform quantitative components of an evaluation measurement plan into a sound analysis plan to address the evaluation questions, 2) conduct quantitative analyses of primary or secondary surveys or other available data, 3) interpret the meaning of the analysis results and their implications, and 4) disseminate the evaluation findings to program implementers, local and global stakeholders.

Dec 14th 2026
5-12 Weeks
Serverless Data Processing with Dataflow: Develop Pipelines (Coursera) Coursera
Google Cloud

Serverless Data Processing with Dataflow: Develop Pipelines (Coursera)

In this second installment of the Dataflow course series, we are going to be diving deeper on developing pipelines using the Beam SDK. We start with a review of Apache Beam concepts. Next, we discuss processing streaming data using windows, watermarks and triggers. We then cover options for sources and sinks in your pipelines, schemas to express your structured data, and how to do stateful transformations using State and Timer APIs.

Dec 14th 2026
3 Weeks
Football: More than a Game (Coursera) Coursera
University of Edinburgh

Football: More than a Game (Coursera)

Explore the world of football (soccer), the money, the rivalries, the trends, the past, the present, the men’s game, the women's game and the real issues. Whether you love it, hate it or try to ignore it – join us as we go behind the scenes to examine why football is more than just a game.

Dec 14th 2026
5-12 Weeks
SQL: A Practical Introduction for Querying Databases (Coursera) Coursera
IBM

SQL: A Practical Introduction for Querying Databases (Coursera)

Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and manipulating data in databases. A working knowledge of databases and SQL is a must for anyone who wants to start a career in Data Engineering, Data Warehousing, Data Analytics, Data Science or Business Intelligence. The purpose of this course is to help you learn and apply foundational and intermediate knowledge of the SQL language, and become familiar with many relational database (RDBMS) concepts along the way.

Dec 14th 2026
5-12 Weeks