Introduction to SQL
Kurs
25562 Studenter allerede påmeldt4.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.
Utstyr bedriften din med toppmoderne teknologi Data og KI ekspertise.
Del det på sosiale medier og i din prestasjonsvurdering
Det er 5 moduler i dette kurset
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 ColumnsForhåndsvisning
- Retrieving Multiple ColumnsForhåndsvisning
- Retrieving All ColumnsForhåndsvisning
- Retrieving Distinct RowsForhåndsvisning
- Limiting ResultsForhåndsvisning
- Challenge: Find the Population of the CountriesForhåndsvisning
- Challenge: Find All CountriesForhåndsvisning
- Challenge: Find All Countries With Their IDsForhåndsvisning
- Challenge: Find Country CapitalsForhåndsvisning
- Challenge: Find the Regions in Which All Countries Are LocatedForhåndsvisning
- Sorting DataForhåndsvisning
- Challenge: Population SortForhåndsvisning
- Sorting by Multiple ColumnsForhåndsvisning
- Challenge: Dual-Sort QueryForhåndsvisning
- Specifying Sort DirectionForhåndsvisning
- Challenge: Sort the Countries by Region and CapitalForhåndsvisning
- Challenge: Sort Capitals in Descending OrderForhåndsvisning
- Challenge: Sort Countries in Ascending OrderForhåndsvisning
- Challenge: Find Countries, Their IDs, and Their PopulationsForhåndsvisning
- Challenge: Find Countries, IDs, Populations, Regions, and Sort ThemForhåndsvisning
- Challenge: Find All Continents and Sort Them in Ascending OrderForhåndsvisning
- The AVG() FunctionForhåndsvisning
- Challenge: Surface Area SelectionForhåndsvisning
- The COUNT() FunctionForhåndsvisning
- Challenge: Continental CountForhåndsvisning
- The MAX() FunctionForhåndsvisning
- The MIN() FunctionForhåndsvisning
- Challenge: Large Surface Area AverageForhåndsvisning
- The SUM() FunctionForhå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.9
50 anmeldelser
5
96%
4
2%
3
2%
2
0%
1
0%
Viser 3 av 50 anmeldelser
Lina Chioma Anaso
5
Vurdert 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
Vurdert den Apr 24, 2025
5
Vurdert den Apr 23, 2025
Very hand on, great for kinesthetic learners!
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