Introduction to SQL
Kurs
25562 Studenter redan inskrivna4.8
(1689)
- Understand how to extract individual, multiple and all columns from databases.
- Understand the process of sorting and filtering retrieved data to extract meaningful insights.
- Develop abilities in advanced data filtering, using operators and functions to refine queries.
- Become skilled in applying aggregate functions like COUNT, AVG, MAX, MIN, and SUM to analyze data sets.
Utrusta ditt företag med banbrytande Data och AI kompetens.
Dela det på sociala medier och vid din prestationsutvärdering
Det finns 5 moduler i denna kurs
This course is perfect for beginners ready to explore the world of SQL. Whether you're just starting out in database management or aiming to use SQL for your application development projects, this course covers the essentials. You'll quickly learn how to leverage the full potential of SQL, from querying and managing data to seamlessly integrating it into real-world applications. By the end of the course, you'll have the confidence and skills to solve practical problems with SQL and enhance your development process.- Retrieving Individual ColumnsFörhandsgranska
- Retrieving Multiple ColumnsFörhandsgranska
- Retrieving All ColumnsFörhandsgranska
- Retrieving Distinct RowsFörhandsgranska
- Limiting ResultsFörhandsgranska
- Challenge: Find the Population of the CountriesFörhandsgranska
- Challenge: Find All CountriesFörhandsgranska
- Challenge: Find All Countries With Their IDsFörhandsgranska
- Challenge: Find Country CapitalsFörhandsgranska
- Challenge: Find the Regions in Which All Countries Are LocatedFörhandsgranska
- Sorting DataFörhandsgranska
- Challenge: Population SortFörhandsgranska
- Sorting by Multiple ColumnsFörhandsgranska
- Challenge: Dual-Sort QueryFörhandsgranska
- Specifying Sort DirectionFörhandsgranska
- Challenge: Sort the Countries by Region and CapitalFörhandsgranska
- Challenge: Sort Capitals in Descending OrderFörhandsgranska
- Challenge: Sort Countries in Ascending OrderFörhandsgranska
- Challenge: Find Countries, Their IDs, and Their PopulationsFörhandsgranska
- Challenge: Find Countries, IDs, Populations, Regions, and Sort ThemFörhandsgranska
- Challenge: Find All Continents and Sort Them in Ascending OrderFörhandsgranska
- The AVG() FunctionFörhandsgranska
- Challenge: Surface Area SelectionFörhandsgranska
- The COUNT() FunctionFörhandsgranska
- Challenge: Continental CountFörhandsgranska
- The MAX() FunctionFörhandsgranska
- The MIN() FunctionFörhandsgranska
- Challenge: Large Surface Area AverageFörhandsgranska
- The SUM() FunctionFö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
4.9
50 omdömen
5
96%
4
2%
3
2%
2
0%
1
0%
Visar 3 av 50 omdömen
Lina Chioma Anaso
5
Recenserad den Apr 24, 2025
I truly appreciate Codeinfinity for the detailed course material provided and well structured platform designed to aid all level of learning.
Samuel Dagostino
5
Recenserad den Apr 24, 2025
5
Recenserad den Apr 23, 2025
Very hand on, great for kinesthetic learners!
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