link Source: openclassrooms.com
list 4 sequences
assignment Level : Intermediate
chat_bubble_outline Language : English
card_giftcard 200 points
Logo My Mooc Business

Top companies choose Edflex to build in-demand career skills.

Get started
Users' reviews
-
starstarstarstarstar
0 reviews

Key Information

credit_card Free access
verified_user Fee-based Certificate
timer 20 hours in total

About the content

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.

more_horiz Read more
more_horiz Read less
report_problem

Prerequisite

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.

dns

Syllabus

Part 1 - Represent data using the relational model
1. Get the most out of this course
2. Discover the concept of the relation
3. Identify a key in a relation
4. Choose a primary key among candidate keys
5. Create links between your relations using foreign keys
6. Identify and reconfigure a redundant table
7. Create an association table
Quiz: Test your knowledge on the relational model


Part 2 - Manipulate data using relational algebra operations
1. Filter a relation using projection and restriction
2. Combine relations using set operators
3. Combine two relations using the cartesian product operation
4. Link relations using joins
5. Aggregate rows in a table
6. Understand the importance of keys for joins
Quiz: Test your knowledge on relational algebra operations

Part 3 - Execute simple SQL queries
1. Set up your work environment
2. Create a table with keys
3. Execute queries with SELECT, FROM, and WHERE clauses
4. Execute a union, a difference, and an intersection
5. Join tables with the JOIN clause
6. Aggregate your data using GROUP BY
7. Get Some Practice Executing Simple SQL Queries

Part 4 - Execute advanced SELECT Queries
1. Sort your data using ORDER BY
2. Improve your aggregations using HAVING
3. Search character strings using LIKE
4. Nest queries using IN, ALL, ANY, and EXISTS
5. Understand window functions using OVER and PARTITION BY
6. Get Some Practice Executing Advanced SQL Queries

Certificate

record_voice_over

Instructors

Kurt Schuepfer
Ph.D. from Miami University. Data Scientist. Founder and Chief Strategist at Accelerate Data Academy.

store

Content Designer

OpenClassrooms

OpenClassrooms (formerly Le site du Zéro or SdZ) is a website that offers courses about computer science and entrepreneurship. Online courses can be made both by site staff, professors of universities or colleges partner as by its members.

Today, courses are available in several formats: MOOC (Massive Open Online Course), web text, e-book, book and video. The company delivers certifications for certain courses, including one recognized by the state in partnership with IESA multimedia.

You are the designer of this MOOC?
What is your opinion on this resource ?
Content
5/5
Platform
5/5
Animation
5/5