Intermediate SQL
Kurs
7418 Studenter allerede påmeldt4.6
(545)
- Gain familiarity with advanced SQL techniques like data grouping and filtering to construct complex queries.
- Understand the nuances of nested subqueries for in-depth data analysis.
- Acquire the ability to manipulate multiple database tables simultaneously through various join operations.
- Master the application of INNER JOIN, LEFT JOIN, and RIGHT JOIN for optimized data retrieval.
Utstyr bedriften din med toppmoderne teknologi Data og KI ekspertise.
Del det på sosiale medier og i din prestasjonsvurdering
Det er 4 moduler i dette kurset
This course is perfect for those who already have a basic understanding of SQL and want to delve into more advanced concepts to craft more powerful queries. Throughout the course, you will become familiar with data grouping and filtering grouped data. You will also learn how to work with multiple tables simultaneously, including how to combine them. Additionally, you will explore different types of table joins and how to apply them in practice.- GROUP BY ClauseForhåndsvisning
- Order of StatementsForhåndsvisning
- Challenge: Total Ride Time for Each Subway LineForhåndsvisning
- Average Student's Grade ChallengeForhåndsvisning
- Searching for the Top Math Students ChallengeForhåndsvisning
- HAVING ClauseForhåndsvisning
- Several Aggregate Functions in the QueryForhåndsvisning
- More Complex FilteringForhåndsvisning
- JOIN 2 TablesForhåndsvisning
- Challenge: Get Category By Product PriceForhåndsvisning
- Challenge: Get Minimum Price By CategoryForhåndsvisning
- Challenge: Get Product Amount By CategoryForhåndsvisning
- LEFT, RIGHT and INNER JOINsForhåndsvisning
- Challenge: Table JoinForhåndsvisning
- Challenge: FULL JOIN UsageForhåndsvisning
Utvalgt av studenter fra de fremragende skolene
Hvorfor folk velger Codefinity for karrieren sin

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.
Studentanmeldelser
4.8
50 anmeldelser
5
78%
4
20%
3
2%
2
0%
1
0%
Viser 3 av 50 anmeldelser
Austin Corcoran
5
Vurdert den Apr 22, 2025
Daniel Wauer
5
Vurdert den Apr 21, 2025
Walter Saunders
5
Vurdert den Apr 15, 2025
Anbefalt hvis du er interessert i å læreSQL
Omfavn fascinasjonen for teknologiske ferdigheter! Vår KI-assistent gir sanntidstilbakemelding, personlige hint og forklaringer på feil, slik at du kan lære med selvtillit.
Med arbeidsområder kan du opprette og dele prosjekter direkte på plattformen vår. Vi har forberedt maler for din bekvemmelighet
Ta kontroll over din karriereutvikling og start din vei mot å mestre de nyeste teknologiene
Reelle prosjekter løfter porteføljen din, og viser praktiske ferdigheter som imponerer potensielle arbeidsgivere




Full tilgang til katalogen
Et abonnement gir tilgang til dette kurset og hele katalogen vår av prosjekter og ferdigheter.Abonnementet ditt inkluderer også:
Ofte stilte spørsmål
Fortsatt spørsmål?
Skriv spørsmålet ditt her