Retrieve Data Using SQL

Retrieve Data Using SQL

Prime
课程
en
英语
20 时
此内容评级为 0/5

Confirmation of resource completion may take up to 24 hours for this editor.

来源
  • 由Kurt Schuepfer创建
  • 来自https://openclassrooms.com
状况
  • 自定进度
更多信息
  • 28 序列
  • 等级 介绍
  • 从19 二月 2019开始

Confirmation of resource completion may take up to 24 hours for this editor.

Their employees are learning daily with Edflex

  • Safran
  • Air France
  • TotalEnergies
  • Generali
Learn more

课程详情

教学大纲

  • Represent data using the relational model
    • Get the most out of this course
    • Discover the concept of the relation
    • Identify a key in a relation
    • Choose a primary key among candidate keys
    • Create links between your relations using foreign keys
    • Identify and reconfigure a redundant table
    • Create an association table
    • Test your knowledge on the relational model
  • Manipulate data using relational algebra operations
    • Filter a relation using projection and restriction
    • Combine relations using set operators
    • Combine two relations using the cartesian product operation
    • Link relations using joins
    • Aggregate rows in a table
    • Understand the importance of keys for joins
    • Test your knowledge on relational algebra operations
  • Execute simple SQL queries
    • Set up your work environment
    • Create a table with keys
    • Execute queries with SELECT, FROM, and WHERE clauses
    • Execute a union, a difference, and an intersection
    • Join tables with the JOIN clause
    • Aggregate your data using GROUP BY
    • Get Some Practice Executing Simple SQL Queries
  • Execute advanced SELECT Queries
    • Sort your data using ORDER BY
    • Improve your aggregations using HAVING
    • Search character strings using LIKE
    • Nest queries using IN, ALL, ANY, and EXISTS
    • Understand window functions using OVER and PARTITION BY
    • Get Some Practice Executing Advanced SQL Queries

先决条件

没有。

讲师

Kurt Schuepfer

编辑

La mission d’OpenClassrooms est de rendre l’éducation accessible. Nous sommes une école 100% en ligne qui permet à des milliers d’individus partout dans le monde de développer leurs compétences professionnelles et de se former aux métiers de demain.

OpenClassrooms est entreprise à mission (loi Pacte) depuis 2018, et a obtenu la certification B Corp en 2021.

此内容评级为 4.5/5
(没有评论)

What did you think of this course?