Save for later

Structured Database Environments with SQL

Develop the skills necessary to create structured database environments using a relational database management system (RDBMS), such as MySQL, that incorporates basic processing functionality and allows for data management, data manipulation and data analysis. 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.

Scripting with Python - starting February 2021

Structured Database Environments with SQL - starting February 2021

NOTE : While this is generally a non-credit-bearing course, you may be able to use this class with proper completion for 3 credits (1 course) toward a bachelor's degree at Southern New Hampshire University.

What you'll learn

Get Details and Enroll Now

OpenCourser is an affiliate partner of edX and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating Not enough ratings
Length 16 weeks
Effort 8 - 10 hours per week
Starts On Demand (Start anytime)
Cost $498
From Southern New Hampshire University via edX
Instructors Scott Overmyer, Ben Tasker
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science
Tags Data Analysis & Statistics

Get a Reminder

Send to:

Similar Courses

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Dynamics Engineer (Environments) $10k

Corporate Environments Designer $63k

Creative Director of Brand Environments $72k

Associate Art Director, Retail Environments $92k

Space Environments Engineer $103k

Senior Environments Analyst $117k

Senior Marketing Manager, Branded Environments and Sponsorships $118k

Sales Manager, Safety & Controlled Environments Products $125k

Database Administrator/Database Developer $127k

Project Manager, Virtual Environments $138k

Senior Database Developer/Database Administrator $144k

Senior Database Developer/Database Administrator $144k

Write a review

Your opinion matters. Tell us what you think.

Rating Not enough ratings
Length 16 weeks
Effort 8 - 10 hours per week
Starts On Demand (Start anytime)
Cost $498
From Southern New Hampshire University via edX
Instructors Scott Overmyer, Ben Tasker
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science
Tags Data Analysis & Statistics

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now