Managing Relational Databases

Managing Relational Databases

This course is part of multiple programs.

Instructor: Shadow Farrell

Top Instructor

What you'll learn

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

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

20 assignments

Taught in English

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

Learn more about Coursera for Business

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.

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

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 videosTotal 68 minutes

Introduction to the ATA Track5 minutesPreview module
Overview of ATA Track1 minute
Advice for Completing the ATA6 minutes
Databases Course Syllabus5 minutes
Databases7 minutes
Tables and Keys4 minutes
Relationships6 minutes
Structured Query Language (SQL)4 minutes
Finding the Database Structure10 minutes
Queries6 minutes
Conditional Queries2 minutes
Database Fundamentals Review7 minutes

6 readingsTotal 140 minutes

README5 minutes
Installing VirtualBox10 minutes
Installing Ubuntu35 minutes
Configuring the Virtual Machine to Interact with the Host Operating System40 minutes
Setting Up the Lab Environment30 minutes
Querying a Database20 minutes

3 assignmentsTotal 60 minutes

Database Fundamentals Graded Assessment30 minutes
Relational Database Concepts Assessment15 minutes
Understand SQL Practice Assessment15 minutes

1 discussion promptTotal 10 minutes

Flat Databases10 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 videosTotal 41 minutes

AND and OR Queries6 minutesPreview module
Comparison Operators3 minutes
Arithmetic Operators6 minutes
Searching for a Range of Values2 minutes
The IN Operator3 minutes
NULL Values2 minutes
Pattern Matching4 minutes
Regular Expressions5 minutes
Multiple Conditions and Complex Criteria Review6 minutes

2 readingsTotal 25 minutes

Using Multiple Conditions15 minutes
Using Patterns10 minutes

3 assignmentsTotal 54 minutes

Multiple Conditions and Complex Criteria Graded Assessment14 minutes
Queries with Multiple Conditions Practice Assessment10 minutes
Queries with Complex Criteria Practice Assessment30 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 videosTotal 35 minutes

Date Functions7 minutesPreview module
The DISTINCT Key Word1 minute
Aggregate Functions3 minutes
Formatting Text and Numbers3 minutes
TRIM and SUBSTR Functions6 minutes
Concatenation4 minutes
Working with Functions Review 7 minutes

7 readingsTotal 68 minutes

Functions3 minutes
Date and Time Data Types5 minutes
Date Functions Reference5 minutes
Strings5 minutes
Performing Date Calculations30 minutes
Using Aggregate Functions10 minutes
Manipulating String Functions10 minutes

4 assignmentsTotal 46 minutes

Working with Functions Graded Assessment15 minutes
Perform Date Calculations Practice Assessment15 minutes
Calculate Data Using Aggregate Functions Practice Assessment1 minute
Manipulate String Values Practice Assessment15 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 videosTotal 50 minutes

UNION Operator3 minutesPreview module
INTERSECT and EXCEPT Operators3 minutes
Joins7 minutes
Multiple Table Joins4 minutes
Self Joins3 minutes
Data Sorting3 minutes
Limit Results1 minute
GROUP BY and HAVING Clauses4 minutes
ROLLUP Operator6 minutes
Retrieving and Organizing Data from Multiple Tables Review11 minutes

3 readingsTotal 80 minutes

Combining and Comparing the Results of Two Queries20 minutes
Retrieving Data by Joining Tables10 minutes
Organizing Data50 minutes

4 assignmentsTotal 50 minutes

Retrieving and Organizing Data from Multiple Tables Graded Assessment15 minutes
Combine the Results of Two Queries Practice Assessment10 minutes
Retrieve Data by Joining Tables Practice Assessment10 minutes
Retrieve Data by Joining Tables Practice Assessment15 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 videosTotal 41 minutes

Subqueries4 minutesPreview module
Subqueries in WHERE Clauses4 minutes
Subqueries in FROM Clauses4 minutes
Correlated Subqueries8 minutes
Existing Records6 minutes
Nested Subqueries5 minutes
Using Subqueries Review7 minutes

1 readingTotal 50 minutes

Using Subqueries50 minutes

3 assignmentsTotal 60 minutes

Using Subqueries Graded Assessment30 minutes
Advanced CSS Selectors Practice Assessment15 minutes
Provide Alternate Layouts Practice Assessment15 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.