Intermediate SQL
Kurs
90 Studenter redan inskrivna- 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.
Utrusta ditt företag med banbrytande Data och AI kompetens.
Dela det på sociala medier och vid din prestationsutvärdering
Det finns 4 moduler i denna kurs
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 ClauseFörhandsgranska
- Order of StatementsFörhandsgranska
- Challenge: Total Ride Time for Each Subway LineFörhandsgranska
- Average Student's Grade ChallengeFörhandsgranska
- Searching for the Top Math Students ChallengeFörhandsgranska
- HAVING ClauseFörhandsgranska
- Several Aggregate Functions in the QueryFörhandsgranska
- More Complex FilteringFörhandsgranska
- JOIN 2 TablesFörhandsgranska
- Challenge: Get Category By Product PriceFörhandsgranska
- Challenge: Get Minimum Price By CategoryFörhandsgranska
- Challenge: Get Product Amount By CategoryFörhandsgranska
- LEFT, RIGHT and INNER JOINsFörhandsgranska
- Challenge: Table JoinFörhandsgranska
- Challenge: FULL JOIN UsageFörhandsgranska
Valt av studenter från de allra bästa skolorna
Varför folk väljer Codefinity för sin karriär

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.
Studentomdömen
5.0
4 omdömen
5
100%
4
0%
3
0%
2
0%
1
0%
Visar 3 av 4 omdömen
5
Recenserad den Jun 16, 2024
Great courses.
Davin Thomas
5
Recenserad den Mar 24, 2024
The learning platform is very easy to use.
5
Recenserad den Mar 21, 2024
If you want a simplified version of learning SQL in a step-by-step way, Codefinity is it!
Rekommenderas om du är intresserad av att lära digSQL
Omfamna fascinationen för tekniska färdigheter! Vår AI-assistent ger feedback i realtid, personliga tips och felanalyser, vilket gör att du kan lära dig med självförtroende.
Med Arbetsytor kan du skapa och dela projekt direkt på vår plattform. Vi har förberett mallar för din bekvämlighet
Ta kontroll över din karriärutveckling och inled din resa mot att bemästra de senaste teknologierna
Verkliga projekt lyfter din portfölj och visar praktiska färdigheter för att imponera på potentiella arbetsgivare




Full tillgång till katalogen
Ett abonnemang öppnar denna kurs och hela vår katalog av projekt och färdigheter.Ditt abonnemang inkluderar även:
Vanliga frågor
Har du fler frågor?
Formulera din fråga här