Managing Relational Databases

Managing Relational Databases

This course is part of multiple programs.

Instructor: Shadow Farrell

Top Instructor

Access provided by Altimetrik

2,946 already enrolled

7 modules

Gain insight into a topic and learn the fundamentals.

31 reviews

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

7 modules

Gain insight into a topic and learn the fundamentals.

31 reviews

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

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

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

20 assignments¹

AI Graded see disclaimer

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is available as part of

When you enroll in this course, you'll also be asked to select a specific program.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Akamai Technologies, Inc.

There are 7 modules in this course

In Managing Relational Databases, you’ll learn about their structure, design, and use of primary and foreign key fields equipping you with foundational knowledge.

Upon completing this course, you’ll be able to: ● Master the use of Structured Query Language (SQL) and use it to analyze database structures ● Create and manage databases, tables, and records ● Conduct data analysis using basic SQL queries, conditional statements, and logical comparison ● Control output data using SQL ● Create complex queries using joins, and subqueries Throughout this course, hands-on labs will provide practical experience in working with SQL and manipulating databases. At the end of this course, you’ll complete a capstone project, allowing you to showcase the knowledge and skills you learned throughout the course.

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.

What's included

12 videos6 readings3 assignments1 discussion prompt

12 videos Total 69 minutes

Introduction to the ATA Track 5 minutes
Overview of ATA Track 1 minute
Advice for Completing the ATA 6 minutes
Databases Course Syllabus 5 minutes
Databases 8 minutes
Tables and Keys 4 minutes
Relationships 7 minutes
Structured Query Language (SQL) 5 minutes
Finding the Database Structure 10 minutes
Queries 7 minutes
Conditional Queries 3 minutes
Database Fundamentals Review 8 minutes

6 readings Total 140 minutes

README 5 minutes
Installing VirtualBox 10 minutes
Installing Ubuntu 35 minutes
Configuring the Virtual Machine to Interact with the Host Operating System 40 minutes
Setting Up the Lab Environment 30 minutes
Querying a Database 20 minutes

3 assignments Total 60 minutes

Relational Database Concepts Assessment 15 minutes
Understand SQL Practice Assessment 15 minutes
Database Fundamentals Graded Assessment 30 minutes

1 discussion prompt Total 10 minutes

Flat Databases 10 minutes

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.

What's included

9 videos2 readings3 assignments

9 videos Total 42 minutes

AND and OR Queries 6 minutes
Comparison Operators 4 minutes
Arithmetic Operators 7 minutes
Searching for a Range of Values 3 minutes
The IN Operator 3 minutes
NULL Values 2 minutes
Pattern Matching 5 minutes
Regular Expressions 6 minutes
Multiple Conditions and Complex Criteria Review 7 minutes

2 readings Total 25 minutes

Using Multiple Conditions 15 minutes
Using Patterns 10 minutes

3 assignments Total 54 minutes

Queries with Multiple Conditions Practice Assessment 10 minutes
Queries with Complex Criteria Practice Assessment 30 minutes
Multiple Conditions and Complex Criteria Graded Assessment 14 minutes

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.

What's included

7 videos7 readings4 assignments

7 videos Total 36 minutes

Date Functions 8 minutes
The DISTINCT Key Word 2 minutes
Aggregate Functions 3 minutes
Formatting Text and Numbers 4 minutes
TRIM and SUBSTR Functions 7 minutes
Concatenation 5 minutes
Working with Functions Review 8 minutes

7 readings Total 68 minutes

Functions 3 minutes
Date and Time Data Types 5 minutes
Date Functions Reference 5 minutes
Strings 5 minutes
Performing Date Calculations 30 minutes
Using Aggregate Functions 10 minutes
Manipulating String Functions 10 minutes

4 assignments Total 46 minutes

Perform Date Calculations Practice Assessment 15 minutes
Calculate Data Using Aggregate Functions Practice Assessment 1 minute
Manipulate String Values Practice Assessment 15 minutes
Working with Functions Graded Assessment 15 minutes

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.

What's included

10 videos3 readings4 assignments

10 videos Total 51 minutes

UNION Operator 3 minutes
INTERSECT and EXCEPT Operators 3 minutes
Joins 7 minutes
Multiple Table Joins 5 minutes
Self Joins 4 minutes
Data Sorting 4 minutes
Limit Results 2 minutes
GROUP BY and HAVING Clauses 4 minutes
ROLLUP Operator 6 minutes
Retrieving and Organizing Data from Multiple Tables Review 12 minutes

3 readings Total 80 minutes

Combining and Comparing the Results of Two Queries 20 minutes
Retrieving Data by Joining Tables 10 minutes
Organizing Data 50 minutes

4 assignments Total 50 minutes

Combine the Results of Two Queries Practice Assessment 10 minutes
Retrieve Data by Joining Tables Practice Assessment 10 minutes
Retrieve Data by Joining Tables Practice Assessment 15 minutes
Retrieving and Organizing Data from Multiple Tables Graded Assessment 15 minutes

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.

What's included

7 videos1 reading3 assignments

7 videos Total 42 minutes

Subqueries 5 minutes
Subqueries in WHERE Clauses 5 minutes
Subqueries in FROM Clauses 4 minutes
Correlated Subqueries 8 minutes
Existing Records 6 minutes
Nested Subqueries 5 minutes
Using Subqueries Review 8 minutes

1 reading Total 50 minutes

Using Subqueries 50 minutes

3 assignments Total 60 minutes

Advanced CSS Selectors Practice Assessment 15 minutes
Provide Alternate Layouts Practice Assessment 15 minutes
Using Subqueries Graded Assessment 30 minutes

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.