When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Certificate?

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Managing Relational Databases

Ends tomorrow! Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now

Managing Relational Databases

This course is part of multiple programs.

Instructor: Shadow Farrell

Top Instructor

3,502 already enrolled

Included with

Learn more

7 modules

Gain insight into a topic and learn the fundamentals.

35 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.

35 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

91%

of learners achieved a positive career outcome

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.

Module details

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 69 minutes

Introduction to the ATA Track5 minutes
Overview of ATA Track1 minute
Advice for Completing the ATA6 minutes
Databases Course Syllabus5 minutes
Databases8 minutes
Tables and Keys4 minutes
Relationships7 minutes
Structured Query Language (SQL)5 minutes
Finding the Database Structure10 minutes
Queries7 minutes
Conditional Queries3 minutes
Database Fundamentals Review8 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 42 minutes

AND and OR Queries6 minutes
Comparison Operators4 minutes
Arithmetic Operators7 minutes
Searching for a Range of Values3 minutes
The IN Operator3 minutes
NULL Values2 minutes
Pattern Matching5 minutes
Regular Expressions6 minutes
Multiple Conditions and Complex Criteria Review7 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 36 minutes

Date Functions8 minutes
The DISTINCT Key Word2 minutes
Aggregate Functions3 minutes
Formatting Text and Numbers4 minutes
TRIM and SUBSTR Functions7 minutes
Concatenation5 minutes
Working with Functions Review 8 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 51 minutes

UNION Operator3 minutes
INTERSECT and EXCEPT Operators3 minutes
Joins7 minutes
Multiple Table Joins5 minutes
Self Joins4 minutes
Data Sorting4 minutes
Limit Results2 minutes
GROUP BY and HAVING Clauses4 minutes
ROLLUP Operator6 minutes
Retrieving and Organizing Data from Multiple Tables Review12 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 42 minutes

Subqueries5 minutes
Subqueries in WHERE Clauses5 minutes
Subqueries in FROM Clauses4 minutes
Correlated Subqueries8 minutes
Existing Records6 minutes
Nested Subqueries5 minutes
Using Subqueries Review8 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.