Retrieve Data Using SQL

Retrieve Data Using SQL
at
OpenClassrooms
Overview

Skills you will learn

More about this course

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 a required knowledge for Data Analysts, so let's dive in!

Part #1 - Represent data using the relational model

Part #2 - Manipulate data using relational algebra operations

Part #3 - Execute simple SQL queries

Part #4 - Execute advanced SELECT Queries

Kurt Schuepfer

Designation : PhD from Miami University. Data Scientist. Founder and Chief Strategist at Accelerate Data Academy.

Eligibility criteria Up Arrow Icon

Prerequisites 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 .

Conditional Offer Up Arrow Icon