EdX

SQL for Business Intelligence (edX)

Offered by Southern New Hampshire University, SNHUx,
SQL for Business Intelligence (edX)

This course covers referential integrity and structured query language (SQL). You will learn how to use SQL statements “SELECT,” “FROM,” “WHERE,” and “JOINS.” These SQL statements will help you filter, compare, and analyze the data in your database.

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

Structured Query Language (SQL) is a standardized programming language used to manage relational databases and perform various operations on their data. This is the second course in a two-part series. The second portion of the course covers referential integrity and structured query language (SQL). You will learn how to use SQL statements “SELECT,” “FROM,” “WHERE,” and “JOINS.” These SQL statements will help you filter, compare, and analyze the data in your database. You will learn how to implement basic processing functionalities to create new structured database environments and analyze the results of queries constructed to address data requirements.
This course is part of the Business Intelligence Essentials Professional Certificate.

What you'll learn

  • Generate tables in a database
  • Modify databases and tables
  • Perform database process queries
  • Apply SQL fundamentals to load and query data
  • Implement queries to address database needs
  • Analyze scripts and query outputs for data requirements
  • Utilize database best practices on queries
  • Analyze and troubleshoot SQL queries

Syllabus

Module One -Referential Integrity and the Structured Query Language
Introduction to fundamental concepts of the relational data model and properties of a table, constraints of a relational model, and basic functions and applications of SQL.

Module Two - Project Part 2/Sandbox
As part of the sandbox, setting up schemas with data types, practicing SQL, and improving skills through the project.

Module Three - SQL Continued
Introduction to classification of database management systems, including a centralized system, a homogeneous distributed system, and other database management system types.

Module Four -Complete Project/Sandbox
As part of sandbox, set-up a schema with the Airport data then a separate schema with the World data, this will help you gain extra practice and confirm your understanding of your SQL skills.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Introduction to SQL (edX) EdX
IBM

Introduction to SQL (edX)

Computer 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 Data Engineering, Data Analytics or Data Science. 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 manipulating data in databases.

Self Paced
Self-Paced
Databases SQL Programming Languages
Details
Data Warehousing and BI Analytics (edX) EdX
IBM

Data Warehousing and BI Analytics (edX)

Engineering

This course introduces you to designing, implementing and populating a data warehouse and analyzing its data using SQL & Business Intelligence (BI) tools. Today’s businesses are investing significantly in capabilities to harness the massive amounts of data that fuel Business Intelligence (BI). Working knowledge of Data Warehouses and BI Analytics tools are a crucial skill for Data Engineers, Data Warehousing Specialists and BI Analysts, making who are amongst, the most valued resources for organizations.

Self Paced
Self-Paced
SQL Analytics Business Intelligence
Details
Intermediate PostgreSQL (edX) EdX
University of Michigan,MichiganX

Intermediate PostgreSQL (edX)

Computer Science

This second course in PostgreSQL for Everybody explores a wide range of SQL techniques to aggregate and transact data in PostgreSQL.This course also explores handling, reading, and parsing data with PostgreSQL and working with text in databases with regular expressions. This course covers a wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and parsing CSV files and inserting data into a database.

Self Paced
Self-Paced
SQL CRUD PostgreSQL
Details
Introduction to Data Analytics for Managers (edX) EdX
University of Michigan,MichiganX

Introduction to Data Analytics for Managers (edX)

Management & Leadership Business

Explore data science and analyze business data with Microsoft Azure through the use of SQL, machine learning, and other statistical techniques focused on business applications. Through a combination of lectures, business case studies, and hands-on learning this course provides an introduction to data analytics techniques and their application in business.

Self Paced
Self-Paced
SQL Machine Learning Manager
Details
Modelos de Regresión Lineal y Pronósticos (edX) EdX
Tecnológico de Monterrey,TecdeMonterreyX

Modelos de Regresión Lineal y Pronósticos (edX)

Economics & Finance Business

En este curso se aplican fundamentos estadísticos y econométricos para analizar bases de datos; lo anterior, con el fin de identificar el comportamiento de variables y su relación con otras variables. En el curso también aplican técnicas básicas de pronósticos a través de diferentes metodologías. Se considera que las herramientas impartidas en este curso pueden ser de gran apoyo para los tomadores de decisiones ya que con el análisis de datos se pueden tomar decisiones más precisas y mejor fundamentadas.

Self Paced
Self-Paced
Databases Econometrics Linear Regression
Details
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
Details
Herramientas de la Inteligencia de Negocios (edX) EdX
Galileo University,GalileoX

Herramientas de la Inteligencia de Negocios (edX)

Statistics & Data Analysis

Aprende el proceso de extraer y transformar data para generar insumos y tomar decisiones. Usa software, herramientas y sistemas de apoyo. Con este curso aprenderas a tomar decisiones empresariales exitosas. Para ello, aprenderas el proceso completo desde extraer data, hasta su integracion, visualizacion, depuracion, analisis y uso. Podr as transformar data cruda en insumos para la toma de decisiones. Dominaras el uso de software, herramientas y sistemas de apoyo.

Self Paced
Self-Paced
Big Data Business Intelligence Power BI
Details
Relational Database Basics (edX) 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
Details