Coursera

Managing Relational Databases (Coursera)

Offered by Akamai Technologies, Inc.,
Managing Relational Databases (Coursera)

Students will learn about the structure and design of relational databases including primary and foreign key fields, one-to-many and one-to-one relationships. Students will learn about the Structured Query Language (SQL) and use SQL to examine the database structure. They will also learn to create and manage databases, tables, and records. The focus of the course is on data analysis.

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

Students will start with basic SQL queries then learn to add conditional statements, and logical, comparison and arithmetic operators. Students will learn to query for a range of values, and to use pattern matching and regular expressions. Then they will progress to using multiple conditions, and complex criteria, adding functions to create calculated fields, retrieve unique records and aggregate data. Then students will learn to query multiple tables using joins, creating complex queries using subqueries, nested subqueries, and subqueries in the WHERE and FROM clauses. Students will use SQL to control the output of data including parsing text and numbers, grouping results and using ROLLUP. Students will perform labs that give practical experience and then they will complete a capstone project to demonstrate mastery of course objectives.
This course can be applied to multiple Specializations or Professional Certificates programs. Completing this course will count towards your learning in any of the following programs:

What You Will Learn
Students will learn to create and manage relational databases, and to use SQL for data analysis and reporting.

Syllabus

WEEK 1
Database Fundamentals
In this module, you will learn about the concepts behind databases and relational database. You will explore the structure of a relational database and SQL, the language used to manage relational databases. Then you will master the skills to create queries using the SELECT statement including conditional queries, logical operations, comparison and arithmetic operators. Finally you will explore more complex criteria that can be used to search for ranges and with pattern matching.
Multiple Conditions and Complex Criteria
In this module you will learn how to create queries with multiple criteria using the key words AND and OR. You will also learn to create queries using more complex criteria involving comparison and arithmetic operators, searching for ranges of values, handling NULL values, and finally incorporating pattern matching and regular expressions.

WEEK 2
Working with Functions
In this module, you will learn about functions and date and time data types. You will learn to use date and aggregate functions to extract and analyze data. You will also learn to format dates, strings and numbers so they can be used for reporting and analysis.
Retrieving and Organizing Data from Multiple Tables
In this module, you will learn how to combine multiple queries together using UNION, INTERSECT and EXCEPT. Then you will learn how to combine data from multiple tables using joins. You will learn the four types of joins and then explore using them with multiple tables and for self-joins. Finally, you will organize data using ORDER BY, GROUP BY, and ROLLUP.

WEEK 3
Using Subqueries
In this module, you will learn how to use subqueries, which are queries contained inside of other queries. You will learn how and when to use subqueries in the WHERE and FROM clauses. You will also learn about correlated subqueries and subqueries used to test for the existence of records. Finally you will learn how to create nested subqueries for situations where just one subquery won't get the data you need.
Manipulating Table Data
In this module, you will learn how to create databases, tables and fields. You will learn to insert new records, update existing records, and delete records that are no longer needed.

WEEK 4
Database Fundamentals Capstone
In this module you will demonstrate mastery of the course objectives.

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

Related Courses

IBM Data Analyst Capstone Project (Coursera) Coursera
IBM

IBM Data Analyst Capstone Project (Coursera)

Statistics & Data Analysis Data Science

In this course you will apply various Data Analytics skills and techniques that you have learned as part of the previous courses in the IBM Data Analyst Professional Certificate. You will assume the role of an Associate Data Analyst who has recently joined the organization and be presented with a business challenge that requires data analysis to be performed on real-world datasets. You will undertake the tasks of collecting data from multiple sources, performing exploratory data analysis, data wrangling and preparation, statistical analysis and mining the data, creating charts and plots to visualize data, and building an interactive dashboard.

Jun 22nd 2026
5-12 Weeks
SQL Data Analysis Microsoft Excel
Details
AWS Cloud Technical Essentials (Coursera) Coursera
AWS

AWS Cloud Technical Essentials (Coursera)

CS: Information & Technology

Are you in a technical role and want to learn the fundamentals of AWS? Do you aspire to have a job or career as a cloud developer, architect, or in an operations role? If so, AWS Cloud Technical Essentials is an ideal way to start. This course was designed for those at the beginning of their cloud-learning journey - no prior knowledge of cloud computing or AWS products and services required!

Jun 23rd 2026
5-12 Weeks
Cloud Databases Cloud Computing
Details
Foundations for Big Data Analysis with SQL (Coursera) Coursera
Cloudera

Foundations for Big Data Analysis with SQL (Coursera)

Statistics & Data Analysis Data Science

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.

Jun 22nd 2026
5-12 Weeks
Databases SQL Big Data
Details
Relational Database Support for Data Warehouses (Coursera) Coursera
University of Colorado System

Relational Database Support for Data Warehouses (Coursera)

Statistics & Data Analysis Data Science

Relational Database Support for Data Warehouses is the third course in the Data Warehousing for Business Intelligence specialization. In this course, you'll use analytical elements of SQL for answering business intelligence questions. You'll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, we'll also delve into storage architectures, scalable parallel processing, data governance, and big data impacts. In the assignments in this course, you can use either Oracle or PostgreSQL.

Jun 22nd 2026
5-12 Weeks
Databases SQL Big Data
Details
Databases and SQL for Data Science with Python(Coursera) Coursera
IBM

Databases and SQL for Data Science with Python(Coursera)

Statistics & Data Analysis Data Science

Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. A working knowledge of databases and SQL is a must if you want to become a data scientist. The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL language. It is also intended to get you started with performing SQL access in a data science environment.

Jun 22nd 2026
4 Weeks
Programming Python Databases
Details
SQL for Data Science with R (Coursera) Coursera
IBM

SQL for Data Science with R (Coursera)

Statistics & Data Analysis Data Science

Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. A working knowledge of databases and SQL is a must if you want to become a data scientist. The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL and R languages. It is also intended to get you started with performing SQL access in a data science environment.

Jun 22nd 2026
5-12 Weeks
SQL Data Science R Programming
Details
Introduction to Structured Query Language (SQL) (Coursera) Coursera
University of Michigan

Introduction to Structured Query Language (SQL) (Coursera)

CS: Software Engineering CS: Programming

In this course, you'll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql Database. You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you'll learn to model many-to-many relationships like those needed to represent users, roles, and courses.

Jun 22nd 2026
4 Weeks
SQL PHP MySQL
Details
Database Design and Basic SQL in PostgreSQL (Coursera) Coursera
University of Michigan

Database Design and Basic SQL in PostgreSQL (Coursera)

CS: Software Engineering

In this course you will learn more about the historical design of databases and the use of SQL in the PostgreSQL environment. Using SQL techniques and common commands (INSERT INTO, WHERE, ORDER BY, ON DELETE CASCADE, etc) will enable you to create tables, column types and define the schema of your data in PostgreSQL. You will learn about data modeling and how to represent one-to-many and many-to-many relationships in PostgreSQL.

Jun 22nd 2026
Self-Paced
Databases SQL CRUD
Details