Structured Database Environments with SQL (edX)

Learn about types of data and types of databases to store data, as well as design for scalability. You’ll also learn to prepare digital data storage using the relational model, including resolving integrity constraints, and proper assignments of primary and foreign keys. In addition, you’ll construct and analyze queries to address data requirements.
By completing this course and the final exam, you will:
Demonstrate knowledge of the relational model
Build skills in SQL
Construct SQL queries
Read and develop database schemas
Apply the concept of normalization to a dataset or database
Understand how to add/export data to existing schemas and SQL joins
Learn how to troubleshoot SQL code
If you’re looking to advance your career, you should take this course if you’re interested in data analytics, data engineering, database design or business intelligence. Structured query language (SQL) is the fundamental cornerstone to extract, transact and load data necessary for analysis using a relational database.
This is the second course in the introductory, undergraduate-level offering that makes up the larger Data Management with Python and SQL MicroBachelors program. We recommend taking them in order, unless you have a background in these areas already and feel comfortable skipping ahead.

1. Scripting with Python - starting February 2021
2. Structured Database Environments with SQL - starting February 2021

This course is part of the Data Management with Python and SQL MicroBachelors.

What you'll learn

• Understanding what SQL is
• How to use SQL statements such as:

. Select
. From
. Where
. Having
. Group by
. Order by
. Max
. Min
. Count
. Count distinct
. Joins
. Import/export

• Reading schemas
• Creating database schemas
• Importing/exporting data
• Troubleshooting queries
• Modifying tables and data structures
• Analyzing SQL outputs