Managing Relational Databases

Akamai Technologies, Inc. via Coursera

Go to Course: https://www.coursera.org/learn/akamai-databases

Introduction

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

Syllabus

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.

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.

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.

Database Fundamentals Capstone

In this module you will demonstrate mastery of the course objectives.