EdX

Structured Database Environments with SQL (edX)

Offered by Southern New Hampshire University, SNHUx,
Structured Database Environments with SQL (edX)

Discover Structured Query Language (SQL) programming basics in relation to database management and data manipulation. This course can provide you with an overview of topics like joins, database schemas, database design and importing data into a database. 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.

Class Deals by MOOC List - Click here and see EdX's Active Discounts, Deals, and Promo Codes.

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
Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Analytics for Decision Making (edX) EdX
Babson College

Analytics for Decision Making (edX)

Management & Leadership Statistics & Data Analysis

Discover the foundational concepts that support modern data science and learn to analyze various data types and quality to make smart business decisions. Want to know how to avoid bad decisions with data? Making good decisions with data can give you a distinct competitive advantage in business. This statistics and data analysis course will help you understand the fundamental concepts of sound statistical thinking that can be applied in surprisingly wide contexts, sometimes even before there is any data! Key concepts like understanding variation, perceiving relative risk of alternative decisions, and pinpointing sources of variation will be highlighted.

Self Paced
Self-Paced
Data Analysis Decision Making Analytics
Details
Estadística Aplicada a los Negocios (edX) EdX
Galileo University,GalileoX

Estadística Aplicada a los Negocios (edX)

Statistics & Data Analysis

Aprende las principales herramientas y técnicas de la estadística descriptiva y la estadística inferencial para analizar e interpretar datos desde la perspectiva de negocios facilitando la toma de decisiones. Este curso proporciona una introducción al análisis de datos en base a las principales herramientas estadísticas, enfocándose en la estadística descriptiva y la estadística inferencial.

Self Paced
Self-Paced
Statistics Econometrics Data Analysis
Details
High-Dimensional Data Analysis (edX) EdX
HarvardX,Harvard University

High-Dimensional Data Analysis (edX)

Sci: Biology & Life Sciences Statistics & Data Analysis

A focus on several techniques that are widely used in the analysis of high-dimensional data. If you’re interested in data analysis and interpretation, then this is the data science course for you. We start by learning the mathematical definition of distance and use this to motivate the use of the singular value decomposition (SVD) for dimension reduction and multi-dimensional scaling and its connection to principle component analysis.

Self Paced
Self-Paced
Machine Learning Clustering Data Analysis
Details
R Data Science Capstone Project (edX) EdX
IBM

R Data Science Capstone Project (edX)

Statistics & Data Analysis

Apply various data analysis and visualization skills and techniques you have learned by taking on the role of a data scientist working with real-world data sets. In this capstone course, you will apply various data science skills and techniques that you have learned as part of the previous courses in the IBM Data Science with R or IBM Data Analytics with Excel and R Professional Certificate Programs.

Self Paced
Self-Paced
Statistics Data Analysis Linear Regression
Details
Data Processing and Analysis with Excel (edX) EdX
Rochester Institute of Technology,RITx

Data Processing and Analysis with Excel (edX)

Statistics & Data Analysis

Learn to use Excel to organize and clean data so it can be manipulated and analyzed. In this course, you will learn how to organize your data within the Microsoft Office Excel software tool. Once organized, we will discuss data cleaning. You will learn how to identify outliers and anomalies in the data, and how to identify and change data-types. Together we will develop a data analysis plan, after which we will apply analysis methods and tools, including exploratory analysis, evaluation of results, and comparison with other findings.

Self Paced
Self-Paced
Excel Data Analysis Microsoft Excel
Details
Técnicas Cuantitativas y Cualitativas para la Investigación (edX) EdX
Universitat Politècnica de València,UPValenciaX

Técnicas Cuantitativas y Cualitativas para la Investigación (edX)

Statistics & Data Analysis

El curso pretende acercar al alumno al método científico y, en concreto, cómo éste se aplica al estudio y análisis de los métodos de casos. El curso que se propone es ideal para investigadores y alumnos que se encuentren cursando trabajos de fin de grado, trabajos de fin de máster o realizando tesis, así como todos aquellos del área de la administración que quieran realizar un análisis cuantitativo o cualitativo en sus estudios.

Self Paced
Self-Paced
Research Methods Data Analysis Scientific Methods
Details
Storytelling and Persuading using Data and Digital Technologies (edX) EdX
University of Maryland, College Park,University System of Maryland - USM,USMx,UMD

Storytelling and Persuading using Data and Digital Technologies (edX)

Statistics & Data Analysis

Learn how to gain traction for your digital transformation initiatives with stories based on data that use compelling data visualizations to build a persuasive business case. Decisions made by humans are rarely made by data alone. Human decision-makers have cognitive biases, are affected by emotions, and make conceptual leaps beyond what the data may suggest.

Self Paced
Self-Paced
Data Storytelling Data Analysis
Details
Analyzing Data with R (edX) EdX
IBM

Analyzing Data with R (edX)

Statistics & Data Analysis

R is the key that opens the door between the problems you want to solve with data and the answers you need. This course walks you through the process of answering questions through data. The R programming language is purpose-built for data analysis. R is the key that opens the door between the problems you want to solve with data and the answers you need to meet your objectives.

Self Paced
Self-Paced
Data Data Analysis ANOVA
Details
Introduction to Digital Humanities (edX) EdX
HarvardX,Harvard University

Introduction to Digital Humanities (edX)

Humanities Computer Science

Develop skills in digital research and visualization techniques across subjects and fields within the humanities. This course will show you how to manage the many aspects of digital humanities research and scholarship. Whether you are a student or scholar, librarian or archivist, museum curator or public historian — or just plain curious — this course will help you bring your area of study or interest to new life using digital tools.

Self Paced
Self-Paced
Data Analysis Command Line Interface Digital Humanities
Details
Advanced Statistical Inference and Modelling Using R (edX) EdX
University of Canterbury,UCx

Advanced Statistical Inference and Modelling Using R (edX)

Sci: Mathematics Statistics & Data Analysis

Extend your knowledge of linear regression to the situations where the response variable is binary, a count, or categorical as well as to hierarchical experimental set-up. Advanced Statistical Inference and Modelling Using R is part two of the Statistical Analysis in R professional certificate. This course is directed at people who are already familiar with basic linear regression and fundamentals of statistical inference. It extends the knowledge of linear regression to the situations where the response variable is binary, a count, or categorical as well as to hierarchical experimental set-up.

Self Paced
Self-Paced
Modeling Data Analysis Linear Regression
Details