SQL Intermédiaire
Course
100500 Learners Already enrolled4.6
(528)
- Familiarisez-vous avec des techniques SQL avancées telles que le regroupement et le filtrage des données pour construire des requêtes complexes.
- Comprenez les subtilités des sous-requêtes imbriquées pour une analyse approfondie des données.
- Acquérez la capacité de manipuler simultanément plusieurs tables de base de données grâce à diverses opérations de jointure.
- Maîtrisez l'utilisation de INNER JOIN, LEFT JOIN et RIGHT JOIN pour une récupération de données optimisée.
Equip your business with cutting-edge Data and AI expertise.
Share it on social media and in your performance review
There are 6 modules in this course
Ce cours est parfait pour ceux qui possèdent déjà une compréhension de base de SQL et souhaitent explorer des concepts plus avancés pour élaborer des requêtes plus performantes. Au cours du programme, vous vous familiariserez avec le regroupement des données et le filtrage des données groupées. Vous apprendrez également à travailler simultanément avec plusieurs tables, y compris leur combinaison. De plus, vous découvrirez différents types de jointures de tables et comment les appliquer en pratique.- Clause GROUP BYPreview
- Ordre des InstructionsPreview
- Défi : Temps Total de Trajet pour Chaque Ligne de MétroPreview
- Défi de la Moyenne des Notes des ÉtudiantsPreview
- Recherche des Meilleurs Étudiants en Mathématiques DéfiPreview
- Clause HAVINGPreview
- Plusieurs Fonctions d'Agrégation dans la RequêtePreview
- Filtrage Plus ComplexePreview
Chosen by students of top schools
Why people choose Codefinity for their career

Kwizera Mugisha
The teaching methodology at Codefinity is excellent, and I particularly appreciate how it has prepared me to handle real-world coding problems. Currently, I am delving into Node.js and eagerly anticipate building full-stack projects that integrate all the knowledge I have gained.

Sherry Barnes-Fox
My first course was 4 hours, I did it in a few days, "nugget-style. The instructions are very clear and easy to understand. There is even a hint to help you get the answer, and if you still cannot get the answer, then you can display the answer. I love the learning style that is used, it engages me.

Bill Wagner
I have really liked the browser-based lessons that allow me to code within the lesson. The RUN button allows me to test the code I write before submitting for a grade.

Stephanie Chan
As I went through the first course of the Python track, I liked the way the course was lay out (in easy and digestible modules) with little exercises at the end of each concept.

Daniel Chinea
I have gained a lot of practical and logical thinking skills, along with patience for myself and confidence in myself that I can learn programming.

Steve Bruening
The learning was progressive and made it easy to follow along and make progress. I could feel my skills increasing and building on each other as the course went along.
Learner reviews
4.7
50 reviews
5
74%
4
22%
3
4%
2
0%
1
0%
Showing 3 of 50 reviews
Andreas Jäger
4
Reviewed on Feb 26, 2025
Arnold Cunningham
5
Reviewed on Feb 25, 2025
Kevin McGraw
5
Reviewed on Feb 25, 2025
Recommended if you're interested in learning SQL
Embrace the fascination of Tech Skills! Our AI-assistant provides real-time feedback, personalized hints, and error explanations, empowering you to learn with confidence.
With Workspaces, you can create and share projects directly on our platform. We've prepared templates for your convenience
Take control of your career development and commence your path into mastering the latest technologies
Real-world projects elevate your portfolio, showcasing practical skills to impress potential employers




Full catalog access
One subscription opens up this course and our entire catalog of projects and skills.Your subscription also includes:
Frequently asked questions
Still have questions?
Write your question here