/
/
/
/

Retrieve Data Using SQL

OpenClassrooms
Add to shortlist

https://www.hotcourses.com/courses-by-subject/Retrieve-Data-Using-SQL-courses/57514788/

Course description

Retrieve Data Using SQL:

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.

Learning outcomes

By the end of this course, you will be able to:

Represent data with the relational model

Manipulate data using relational algebra operations

Apply relational algebra operations using SQL

Write simple and advanced SQL queries

HOW DOES IT WORK?

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

Additional entry requirements

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

Course info

Qualification:

Certificate of Attendance

France

France qualification

This course is offered to anyone in the world, but its qualification is only relevant in this country.

Study Hours:

20 hours

Virtual help:

No attendance for this course

Course type:

Online course

Total time for completion:

No time limit

Please check with the college or instructor for the most accurate details on price

Course reviews

This course currently has no reviews.

Write a review
Add to shortlist

You might like...

Popular courses...