Managing Relational Databases (Coursera)

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

SQL for Data Science Capstone Project (Coursera) Coursera
University of California, Davis

SQL for Data Science Capstone Project (Coursera)

Data science is a dynamic and growing career field that demands knowledge and skills-based in SQL to be successful. This course is designed to provide you with a solid foundation in applying SQL skills to analyze data and solve real business problems. Whether you have successfully completed the other courses in the Learn SQL Basics for Data Science Specialization or are taking just this course, this project is your chance to apply the knowledge and skills you have acquired to practice important SQL querying and solve problems with data. You will participate in your own personal or professional journey to create a portfolio-worthy piece from start to finish.

Nov 30th 2026
4 Weeks
Programming and Application Foundations (Coursera) Coursera
Illinois Tech

Programming and Application Foundations (Coursera)

This course introduces the students to the creation and deployment of modern, standards-compliant web pages written in HTML, CSS, and JavaScript in the context of the client-server architecture of the web. The course also covers the fundamentals of programming in a modern programming language, basic data modeling, database design, implementation, and administration of single-user and shared multi-user database applications using a contemporary relational database management system.

Dec 7th 2026
5-12 Weeks
SQL for Security Specialist (Coursera) Coursera
Codio

SQL for Security Specialist (Coursera)

This course is designed specifically for SQL Security Specialists with a focus on PostgreSQL. It assumes a solid foundation in SQL and guides learners through advanced topics specific to PostgreSQL. You'll explore crucial concepts, such as complex queries, performance optimization, and database administration tasks unique to PostgreSQL.

Dec 7th 2026
3 Weeks
Desenvolvimento Ágil com Java Avançado (Coursera) Coursera
Instituto Tecnológico de Aeronáutica

Desenvolvimento Ágil com Java Avançado (Coursera)

Neste curso, assumimos que você já sabe projetar e desenvolver programas mais complexos em Java, graças às boas práticas e princípios orientados a objetos e TDD exercitados nos cursos anteriores; mas você talvez não se sinta ainda confortável em projetar programas para Web e com dados armazenados em banco de dados, bem como em aplicar conceitos mais avançados de Java. O objetivo deste curso é enriquecer sua experiência com conceitos avançados de Java, programação de aplicações Web e acesso a banco de dados no contexto de modelagem ágil.

Nov 30th 2026
4 Weeks
Building Web Applications in Django (Coursera) Coursera
University of Michigan

Building Web Applications in Django (Coursera)

In this course, you will learn how Django communicates with a database through model objects. You will explore Object-Relational Mapping (ORM) for database access and how Django models implement this pattern. We will review the Object-Oriented (OO) pattern in Python. You will learn basic Structured Query Language (SQL) and database modeling, including one-to-many and many-to-many relationships and how they work in both the SQL and Django models. You will learn how to use the Django console and scripts to work with your application objects interactively.

Nov 30th 2026
4 Weeks
Amazon Aurora Service Introduction (Coursera) Coursera
Edureka

Amazon Aurora Service Introduction (Coursera)

Welcome to the Amazon Aurora Service Introduction course, where you'll embark on a journey to acquire practical expertise in Aurora databases and harness the power of Amazon Web Services (AWS) for efficient data management. Throughout this short course, you'll explore the industry-specific applications of Aurora and delve into database fundamentals.

Dec 7th 2026
1 Week
Getting Started with Apache Cassandra (Coursera) Coursera
Whizlabs

Getting Started with Apache Cassandra (Coursera)

The “Getting Started with Cassandra” course is designed to help you gain knowledge of the Cassandra database system. You will learn architecture as well as how to design, build and use Cassandra databases. This training course helps you develop your skills and knowledge in Cassandra. Cassandra is a NoSQL database that has the traits of a distributed, open-source, and decentralized database or storage system. It can support the management of excessively massive amounts of structured data without a single point of failure, thereby resulting in the provision of highly available services.

Dec 7th 2026
3 Weeks
Big Data Analysis with Scala and Spark (Scala 2 version) (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Big Data Analysis with Scala and Spark (Scala 2 version) (Coursera)

Manipulating big data distributed over a cluster using functional concepts is rampant in industry, and is arguably one of the first widespread industrial uses of functional ideas. This is evidenced by the popularity of MapReduce and Hadoop, and most recently Apache Spark, a fast, in-memory distributed collections framework written in Scala. In this course, we'll see how the data parallel paradigm can be extended to the distributed case, using Spark throughout.

Dec 7th 2026
4 Weeks
Web Application Technologies and Django (Coursera) Coursera
University of Michigan

Web Application Technologies and Django (Coursera)

In this course, you'll explore the basic structure of a web application, and how a web browser interacts with a web server. You'll be introduced to the Hypertext Transfer Protocol (HTTP) request/response cycle, including GET/POST/Redirect. You'll also gain an introductory understanding of Hypertext Markup Language (HTML), as well as the overall structure of a Django application.

Nov 30th 2026
5-12 Weeks
Introduction to Software, Programming, and Databases (Coursera) Coursera
IBM

Introduction to Software, Programming, and Databases (Coursera)

There are many types of software and understanding software can be overwhelming. This course aims to help you understand more about the types of software and how to manage software from an information technology (IT) perspective. This course will help you understand the basics of software, cloud computing, web browsers, development and concepts of software, programming languages, and database basics.

Dec 7th 2026
5-12 Weeks
AWS Cloud Practitioner Essentials (Coursera) Coursera
AWS

AWS Cloud Practitioner Essentials (Coursera)

Welcome to AWS Cloud Practitioner Essentials. If you’re new to the cloud, whether you’re in a technical or non-technical role such as finance, legal, sales, marketing, this course will provide you with an understand of fundamental AWS Cloud concepts to help you gain confidence to contribute to your organization’s cloud initiatives. This course is also the starting point to prepare for your AWS Certified Cloud Practitioner certification whenever it’s convenient for you.

Nov 30th 2026
5-12 Weeks