Data

Retrieve Data Using SQL

In this course, you will learn how to represent data using the relational model and apply relational algebra concepts to SQL, the world's most popular query language to query databases.

Moyenne

20 heures

Ce cours en libre accès vous intéresse ?

Commencer

Data is everywhere. In fact, it is at the heart of newer disciplines such as Data Science and Data Analysis. Data is often organized in tables containing rows and columns.

In this course, you will learn how to manipulate those tables using relational algebra operators, and apply these theoretical concepts to a very common language, SQL (Structured Query Language), which is used to interact with… relational databases!

This course will enable you to formalize the concepts you use naturally in SQL, so that you can apply them to other languages (such as Python or R). It will also offer tips on using SQL to build increasingly complex queries.

SQL is required knowledge for Data Analysts, so let's dive in!

Objectifs pédagogiques

Represent data with the relational model
Manipulate data using relational algebra operations

Prérequis

Familiarity with variable types (whole number integer: decimal, float, character string, Boolean, date).

If you are unfamiliar with this vocabulary, we highly recommend taking the following course: Think like a computer: understanding the logic of programming.