Intermediate SQL
Kursus
90 Allerede tilmeldte studerende- 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.
Udstyr din virksomhed med banebrydende teknologi Data og KI erfaring.
Del det på sociale medier og i din præstationsvurdering
Der er 4 moduler i dette kursus
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
Udvalgt af studerende fra de allerbedste skoler
Hvorfor folk vælger Codefinity til deres karriere

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.
Studerendes anmeldelser
5.0
4 anmeldelser
5
100%
4
0%
3
0%
2
0%
1
0%
Viser 3 af 4 anmeldelser
5
Anmeldt den Jun 16, 2024
Great courses.
Davin Thomas
5
Anmeldt den Mar 24, 2024
The learning platform is very easy to use.
5
Anmeldt den Mar 21, 2024
If you want a simplified version of learning SQL in a step-by-step way, Codefinity is it!
Anbefalet, hvis du er interesseret i at læreSQL
Omfavn fascinationen for teknologiske færdigheder! Vores KI-assistent giver feedback i realtid, personlige hints og fejlforklaringer, så du trygt kan lære.
Med arbejdsområder kan du oprette og dele projekter direkte på vores platform. Vi har forberedt skabeloner til din bekvemmelighed
Tag kontrol over din karriereudvikling og start din rejse mod at mestre den nyeste teknologi
Virkelige projekter løfter din portefølje og viser praktiske færdigheder, der imponerer potentielle arbejdsgivere




Fuld adgang til kataloget
Et abonnement åbner dette kursus og hele vores katalog af projekter og færdigheder.Dit abonnement inkluderer også:
Ofte stillede spørgsmål
Har du stadig spørgsmål?
Skriv dit spørgsmål her