EdX

Structured Database Environments with SQL (edX)

Offered by Southern New Hampshire University, SNHUx,

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.

Scripting with Python - starting February 2021
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

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

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

EdX

IBM

Relational Database Basics (edX)

Statistics & Data Analysis

This course teaches you the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS). This course is an introduction to the world of relational databases. You will explore the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS), learn about relational database design, and understand how to transform source data into tables with clearly defined relationships.

Self Paced

Self-Paced

SQL MySQL PostgreSQL

EdX

KU Leuven University,KULeuvenX

How to analyze a microbiome (edX)

Sci: Biology & Life Sciences Statistics & Data Analysis

Learn common analysis techniques to make sense of microbial sequencing data. Microorganisms play a major role in the biosphere and within our bodies, but only a tiny fraction has been cultured so far. Microbiome data, that is the genetic information of microorganisms, is therefore an important window into the hidden microbial world.

Self Paced

Self-Paced

Biology Data Analysis Microbiome

Fundamentos TIC para profesionales de negocios: Programación (edX)

EdX

Universitat Politècnica de València,UPValenciaX

Fundamentos TIC para profesionales de negocios: Programación (edX)

CS: Software Engineering

¿Tienes que trabajar con las Tecnologías de la Información y te faltan conocimientos? Conoce los fundamentos de la programación software. Este curso forma parte de una serie de 5 cursos de introducción al uso de sistemas de información en las empresas que te introducirá en el apasionante mundo de las TIC.

Self Paced

Self-Paced

HTML Javascript XML

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

Analyzing and Visualizing Data with Power BI (edX)

EdX

Davidson College,DavidsonX

Analyzing and Visualizing Data with Power BI (edX)

Statistics & Data Analysis Computer Science

Step up your analytics game and learn one of the most in-demand job skills in the United States. Power BI is a robust business analytics and visualization tool from Microsoft that helps data professionals bring their data to life and tell more meaningful stores. This four-week course is a beginner's guide to working with data in Power BI and is perfect for professionals. You'll become confident in working with data, creating data visualizations, and preparing reports and dashboards.

Self Paced

Self-Paced

Data Analysis Data Visualization Power BI

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

EdX

Davidson College,DavidsonX

Introduction to SQL (edX)

Statistics & Data Analysis

In this introduction to SQL Online Course you will gain strong understanding and utilize SQL to aggregate, manipulate, analyze, and visualize data in your field. SQL (Structured Query Language) is the most commonly used language to communicate with databases and extract data for application development, reporting and analytics. It is ubiquitous for industries across the world and a vital skill for aspiring data professions to have. This course will introduce you to the SQL language and give you the skills you need to query and analyze data from complex relational databases.

Self Paced

Self-Paced

SQL Relational Databases Structured Query Language

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

EdX

IBM

SQL for Data Science (edX)

Statistics & Data Analysis Data Science

Learn how to use and apply the powerful language of SQL to better communicate and extract data from databases - a must for anyone working in the data science field. Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and extracting various data types from databases.

Self Paced

Self-Paced

Python Databases SQL

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