- Criado por Kurt Schuepfer
- De https://openclassrooms.com
Retrieve Data Using SQL
Prime
Curso
en
Inglês
20 h
Este conteúdo é classificado como 0 de 5
Confirmation of resource completion may take up to 24 hours for this editor.
- Individualizado
- 28 sequências
- Introductive Level
- Começa em 19 fevereiro 2019
Detalhes do curso
Programa de Estudos
- 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
Pré-requisito
Nenhum.
Instrutores
Kurt Schuepfer
Editor
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.
Este conteúdo é classificado como 4.5 de 5
(nenhuma revisão)Este conteúdo é classificado como 4.5 de 5
(nenhuma revisão)