EdX

Introduction to SQL (edX)

Offered by IBM,
Introduction to SQL (edX)

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.

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

A working knowledge of databases and SQL is necessary for anyone who wants to start a career in Data Engineering, Data Analytics or Data Science. The purpose of this course is to introduce relational database (RDBMS) concepts and help you learn and apply foundational and intermediate knowledge of the SQL language.
You will start with performing basic Create, Read, Update and Delete (CRUD) operations using CREATE, SELECT, INSERT, UPDATE and DELETE statements. You will then learn to filter, order, sort, and aggregate data. You will also work with functions, perform sub-selects and nested queries, as well as access multiple tables in the database.
The emphasis in this course is on hands-on, practical learning. As such, you will work with real database systems, use real tools, and real-world datasets. You will create a database instance in the cloud. Through a series of hands-on labs, you will practice building and running SQL queries. At the end of the course you will apply and demonstrate your skills with a final project.
The SQL skills you learn in this course will be applicable to a variety of RDBMSes such as MySQL, PostgreSQL, IBM Db2, Oracle, SQL Server and others.
No prior knowledge of databases, SQL or programming is required, however some basic data literacy is beneficial.
This course is part of the following programs:

What you'll learn
"After completing this course, a learner will be able to...

  • Perform basic SQL operations using SELECT, INSERT, UPDATE & DELETE statements
  • Create a database instance in the cloud
  • Create tables and load data
  • Query data using string patterns and ranges
  • Sort and group data in result sets
  • Invoke built-in database functions such as MIN(), MAX(), AVG(), etc.
  • Work with various datatypes including INTEGER, CHAR, VARCHAR, DATE, TIME, TIMESTAMP

Compose nested queries and join data in multiple tables __

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

Related Courses

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
Advanced Database Queries (edX) EdX
New York University,NYUx

Advanced Database Queries (edX)

Computer Science

Learn the fundamentals of interacting with relational database management systems, including issuing advanced queries that return complicated results sets. This course is a continuation of the basic concepts, organization, and implementation models taught in the Introduction to Databases course, with an emphasis on the relational model. Among the topics covered are the development of advanced queries that utilize aggregation, subqueries and built-in functions.

Self Paced
Self-Paced
Databases SQL Queries
Details
Introducción a SQL y bases de datos relacionales (edX) EdX
Universitat Politècnica de València,UPValenciaX

Introducción a SQL y bases de datos relacionales (edX)

CS: Software Engineering

Conoce las bases de datos relaciones y aprende SQL, el lenguaje estándar usado en el software empresarial que te permitirá consultarlas y extraer de ellas la información que necesites. El mayor activo de las empresas actuales son sus datos, datos que, mayoritariamente se alojan en bases de datos relacionales en línea. Prácticamente todos los sistemas de gestión de bases de datos relacionales utilizados en la actualidad utilizan SQL como herramienta para manipular y consultar los datos que contienen.

Self Paced
Self-Paced
Databases SQL Relational Databases
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
SQL for Data Science (edX) 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
Details