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

Análisis de datos empresariales con R (edX) EdX
Universidad Anáhuac,AnahuacX

Análisis de datos empresariales con R (edX)

Statistics & Data Analysis

Analiza los datos con R y R Studio aplicando nuevas técnicas para tomar decisiones orientadas a los negocios, contemplando información de diversas variables simultáneamente y sé parte de la transformación empresarial. Si tomas decisiones en tu empresa o deseas involucrarte en la ciencia de datos y el uso de tecnologías computacionales, este curso es para ti.

Self Paced
Self-Paced
Data Analysis Statistical Analysis Cluster Analysis
Details
Excel for Everyone: Core Foundations (edX) EdX
The University of British Columbia,UBCx

Excel for Everyone: Core Foundations (edX)

Statistics & Data Analysis

Learn Excel fundamentals including data wrangling, spreadsheet management, and basic data analysis. This introductory Excel course will equip you with a strong foundational knowledge of Excel to organize, analyze and work with data. You will develop essential Excel skills, such as simple data wrangling and managing spreadsheets, along with a foundational understanding of business data analysis.

Self Paced
Self-Paced
Spreadsheets Excel Data Analysis
Details
Datos para la efectividad de las políticas públicas (edX) EdX
Inter-American Development Bank - IDB,IDBx

Datos para la efectividad de las políticas públicas (edX)

Management & Leadership Economics & Finance

Este curso te ayudará a tomar el control de los datos y familiarizarte con las herramientas para utilizarlos en la planificación, gestión y evaluación de políticas publicas. En esta era de la información, los datos están disponibles en todos lados y crecen a una tasa exponencial. ¿Cómo podemos darles sentido a todos los datos y aprovecharlos en el momento de tomar decisiones?, ¿cómo los utilizamos para que nos ayuden a guiar la gestión y planificación de nuestras políticas? Tanto si eres ciudadano como planificador de políticas, deberías poder responder a estas preguntas.

Self Paced
Self-Paced
Data Data Analysis Datalogy
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
Data Science: Capstone (edX) EdX
HarvardX,Harvard University

Data Science: Capstone (edX)

Statistics & Data Analysis Data Science

Show what you’ve learned from the Professional Certificate Program in Data Science. To become an expert data scientist you need practice and experience. By completing this capstone project you will get an opportunity to apply the knowledge and skills in R data analysis that you have gained throughout the series. This final project will test your skills in data visualization, probability, inference and modeling, data wrangling, data organization, regression, and machine learning.

Self Paced
Self-Paced
Probability Machine Learning Regression
Details
Data Science: Inference and Modeling (edX) EdX
HarvardX,Harvard University

Data Science: Inference and Modeling (edX)

Statistics & Data Analysis Data Science

Learn inference and modeling, two of the most widely used statistical tools in data analysis. Statistical inference and modeling are indispensable for analyzing data affected by chance, and thus essential for data scientists. In this course, you will learn these key concepts through a motivating case study on election forecasting.

Self Paced
Self-Paced
Statistics Inference Modeling
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
Data Science: R Basics (edX) EdX
HarvardX,Harvard University

Data Science: R Basics (edX)

Statistics & Data Analysis Data Science

Build a foundation in R and learn how to wrangle, analyze, and visualize data. This course will introduce you to the basics of R programming. You can better retain R when you learn it to solve a specific problem, so you’ll use a real-world dataset about crime in the United States. You will learn the R skills needed to answer essential questions about differences in crime across the different states.

Self Paced
Self-Paced
Probability Machine Learning Inference
Details
Statistics and R (edX) EdX
HarvardX,Harvard University

Statistics and R (edX)

Sci: Biology & Life Sciences Statistics & Data Analysis

An introduction to basic statistical concepts and R programming skills necessary for analyzing data in the life sciences. We will learn the basics of statistical inference in order to understand and compute p-values and confidence intervals, all while analyzing data with R. We provide R programming examples in a way that will help make the connection between concepts and implementation.

Self Paced
Self-Paced
Statistics Data Analysis Statistical Inference
Details