Track
Certificate
SQL from Zero to Hero
4.0+
★★★★★
★★★★★
2 reviews
Beginner
Today we will learn how to manage large datasets and analyse real data.
SQL
Boost your Tech Skills!
with up to 55% off
What you'll get with our subscription:
Access to 85+ top-rated courses
AI-driven Learning
Workspaces for practicing your skills
Personalized study tracks
Certificates of completion
Training 2 or more people?
Get your team access to Codefinity courses anytime, anywhere.
Try Codefinity TeamsWhat you will learn
- 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.
- 101 chapters
- 10 hours
- 112 tasks
Trusted by employees of leading companies
Learning track content
Module 1 / Introduction to SQL
In this section, we will learn how to use the SQL SELECT statement to get a single table column, multiple table columns, and all table columns. We will also find out how to return unique values.
- Retrieving Individual ColumnsPreview
- Retrieving Multiple ColumnsPreview
- Retrieving All ColumnsPreview
- Retrieving Distinct RowsPreview
- Limiting ResultsPreview
- Challenge: Find the Population of the CountriesPreview
- Challenge: Find All CountriesPreview
- Challenge: Find All Countries With Their IDsPreview
- Challenge: Find Country CapitalsPreview
- Challenge: Find the Regions in Which All Countries Are LocatedPreview
In this section, we will learn how to sort retrieved data using the ORDER BY clause. This clause, which must be the last in the SELECT statement, can be used to sort data on one or more columns as needed.\n
- Sorting DataPreview
- Challenge: Population SortPreview
- Sorting by Multiple ColumnsPreview
- Challenge: Dual-Sort QueryPreview
- Specifying Sort DirectionPreview
- Challenge: Sort the Countries by Region and CapitalPreview
- Challenge: Sort Capitals in Descending OrderPreview
- Challenge: Sort Countries in Ascending OrderPreview
- Challenge: Find Countries, Their IDs, and Their PopulationsPreview
- Challenge: Find Countries, IDs, Populations, Regions, and Sort ThemPreview
- Challenge: Find All Continents and Sort Them in Ascending OrderPreview
In this section, we will learn how to filter returned data using the SELECT statement’s WHERE clause. We will learn how to test for equality, inequality, more and less significant than value ranges, and NULL values.
In this section, we will learn how to combine WHERE clauses with the AND and OR operators. We will also find out how the NOT operator works.\n\n\n
In this section, we will learn what the SQL aggregate functions are and how to use them to summarize table data.
Module 2 / Intermediate SQL
In this section, you will learn how to group and manage data effectively. We will introduce the GROUP BY operator for grouping data. Additionally, you will learn how to filter grouped data using the HAVING operator.
You will learn about nested subqueries, how to create them, and how to use them effectively.
Here, you will learn how to combine multiple tables, allowing you to work with a unified table and simplify query creation.
Learn the fundamentals of Data Definition Language (DDL) and Data Manipulation Language (DML) in SQL, including how to create, modify, and delete database objects, as well as how to insert, update, and delete data within tables.
Module 3 / Relational Database and Normalization
This section dives into the world of relational and non-relational databases, teaching you how to visually represent database structures.
We'll dive deep into relational databases, giving you a thorough understanding of essential concepts. This includes topics like foreign keys, various ON DELETE options, and the different types of relationships.
Ready to build a database? This section will hone your skills, emphasizing the importance of a well-structured database for peak performance. Here, you'll grasp the fundamental principles of crafting user-friendly databases.
Module 4 / Advanced Techniques in SQL
Now we explore the basic principles of ACID (Atomicity, Consistency, Isolation, Durability) in database management. Learn how these principles ensure reliable transactions by guaranteeing complete operations, keeping data consistent, isolating concurrent transactions, and ensuring permanent data storage.
Explore how to enhance the efficiency of your SQL queries through index optimization. Delve into the significance of indexes in database performance, learning how to design, implement, and utilize them effectively. Discover strategies for choosing the appropriate indexes, understanding their impact on query execution plans, and optimizing query performance through index selection and utilization.
This section explores pivotal topics such as Triggers, Window Functions, and DCL (Data Control Language), offering comprehensive insights into their implementation and optimization strategies. Furthermore, it navigates the landscape of NoSQL DBMS, providing a thorough understanding of its architecture, advantages, and practical applications.
Requirements
- A computer with a browser - all browsers are supported.
- Your enthusiasm to enhance your tech skills.
- Everything else needed to start learning and practicing is already included in this course.
Over 200,000 5-star ratings and counting
Ruslan Kravchuk
The main thing is to learn and not give up
The material is good, there is a lot to learn, all in order to become better and the main thing is to learn what you want....
Matteo Comune
Thanks to them I'm learning a lot…
Thanks to them I'm learning a lot faster because they help you to understand everything from scratch. It's the best website that helps people with no background in IT...
Yuliana Cadavid
great course for beginners
great course for beginners, they test your knowledge in every lesson...
Elpunzon
I am enjoying my Codefinity experience…
I am enjoying my Codefinity experience learning Python. The self-paced way of learning is great because I can fit it into my schedule...
Alexandru Alexandru
Is nice to learn from codefinity
Is nice to learn from codefinity. Its easy and have good examples on what I learned here...
jacob Templet
Easy to follow along with and provides...
Easy to follow along with and provides challenge in my every day life. The challenge keeps me wanting to learn day after day...
Elan
Codefinity is a comprehensive learning…
Codefinity is a comprehensive learning tool to help you develop your skills as a software engineer or data scientist. The exercises are fun and a good way to sharpen your skills...
Thibault
First time learning how to code
First time learning how to code and successfully doing so with codefinity - thank you...
Adrien Morel
Well designed for total beginners
Well designed for total beginners, incremental progress and makes me feel confident....
_Gracy
it's simply perfectly well explained
it's simply perfectly well explained! so far I have not experienced any difficulty because everything is so well managed...
Ruslan Kravchuk
The main thing is to learn and not give up
The material is good, there is a lot to learn, all in order to become better and the main thing is to learn what you want....
Matteo Comune
Thanks to them I'm learning a lot…
Thanks to them I'm learning a lot faster because they help you to understand everything from scratch. It's the best website that helps people with no background in IT...
Yuliana Cadavid
great course for beginners
great course for beginners, they test your knowledge in every lesson...
Elpunzon
I am enjoying my Codefinity experience…
I am enjoying my Codefinity experience learning Python. The self-paced way of learning is great because I can fit it into my schedule...
Alexandru Alexandru
Is nice to learn from codefinity
Is nice to learn from codefinity. Its easy and have good examples on what I learned here...
jacob Templet
Easy to follow along with and provides...
Easy to follow along with and provides challenge in my every day life. The challenge keeps me wanting to learn day after day...
Elan
Codefinity is a comprehensive learning…
Codefinity is a comprehensive learning tool to help you develop your skills as a software engineer or data scientist. The exercises are fun and a good way to sharpen your skills...
Thibault
First time learning how to code
First time learning how to code and successfully doing so with codefinity - thank you...
Adrien Morel
Well designed for total beginners
Well designed for total beginners, incremental progress and makes me feel confident....
_Gracy
it's simply perfectly well explained
it's simply perfectly well explained! so far I have not experienced any difficulty because everything is so well managed...
Data Engineer
Certificate of Completion
Showcase your newly acquired skills. You've earned it
Discover more
Learning tracks
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/d4422c28-3406-45be-9601-fb4d33cf925c_4a16c2fa5cc6459aa0094aa05ad94d8e.svg?w=3840&q=75)
6 Курсів
228 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/1405dfcf-fa1e-4094-899a-1add3eba08bf_caf3040dc1ab4e0eb206c221d6b40c20.svg?w=3840&q=75)
5 Курсів
3 Проєктів
120 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/0f08b309-40cc-4b92-b8d9-e3a6efee248b_90957fa182d540cf9ba53e147e88129f.svg?w=3840&q=75)
6 Курсів
168 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/194aaf6c-90bb-44aa-b43a-e25d124129ad_016eea3407b144218270827af2b44e19.svg?w=3840&q=75)
1 Курс
1 Проєкт
0 Task
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/53e86cd9-a6a2-4ede-9153-1b31d316dbb5_a19f9257fcb24f338fa613f87a127f19.svg?w=3840&q=75)
8 Курсів
2 Проєктів
177 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/59a6dd2a-a382-44ab-a755-d4ad36717c6d_0986b481e4844ac988bc3ddeffbf0ee8.svg?w=3840&q=75)
5 Курсів
268 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/50fb1bf9-83da-462b-964c-3702225d90fe_792551dc61a941058eb8e9a77484d6f5.svg?w=3840&q=75)
5 Курсів
222 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/b5bf0093-706d-442b-a550-72151f522d3c_7f34eb34924448e98eaa6f9c69df12ee.svg?w=3840&q=75)
5 Курсів
119 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/83adfdc2-805f-43dc-90ae-e1a8457cffe3_c56a6b07c6ca483c88e5eb6c94923ecc.svg?w=3840&q=75)
6 Курсів
261 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/7a38d39e-734f-4192-9f87-17a8e676d03a_f94a6fdfc8a84cdab9a5538ad25a21a0.svg?w=3840&q=75)
6 Курсів
94 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/dfe241e5-41d7-4c85-89d6-8330650d343a_f66c83dbe3784089b8c1d73852e2b69a.svg?w=3840&q=75)
6 Курсів
150 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/images/d9e7a541-abc4-4046-822b-d1e4c5bfc4e3_TrackImage.png.png?w=3840&q=75)
1 Курс
0 Task
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/images/984ace60-012d-487e-94c8-563525e32014_abc.jpg.jpg?w=3840&q=75)
1 Проєкт
0 Task
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/b2c742d8-c283-496d-9601-3c2948afdf89_334522fa2ab24309a000b2d8e55fbe5f.svg?w=3840&q=75)
6 Курсів
176 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/ef24a2d5-ac8b-49ef-a334-c25c1f7b49cb_e4ff93729b0e4360b9845e2eabd4e3cc.svg?w=3840&q=75)
6 Курсів
162 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/94187f23-8cf5-4353-91e5-eeb64b3f8975_d0861586e2c145ca9ddbc3ecf315d9c5.svg?w=3840&q=75)
2 Курсів
80 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/537571cf-fdbb-450b-b2b0-15f7fda4fe1f_e165291172fc46a99ccd5fd07538ea87.svg?w=3840&q=75)
3 Курсів
85 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/7e054398-7d03-4ac3-8820-e35b262b9d8b_51e7c26032274953be2c336f66f309fd.svg?w=3840&q=75)
3 Курсів
123 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/8ed777ee-bb5a-4fb3-a56a-6054218ace00_111c29e9214b4c9a947d2a06b3652d78.svg?w=3840&q=75)
7 Курсів
283 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/0491d658-5c3e-4851-8458-fedaa7c7fe28_9b721df791304a9aa47ec9749f8d1438.svg?w=3840&q=75)
5 Курсів
107 Завдань
Лише для Ultimate![track image](https://staging-content-cdn.codefinity.com/files/c361cd03-f7db-46ae-9e77-e2dd55346f68_17fa8556b64c47fd820bab058cf6587c.svg?w=3840&q=75)
4 Курсів
126 Завдань![](https://cdnstaging.codefinity.com/staging/d7b376ffc99b66e9e63a3d190fbb0fb24142f40b/_next/static/media/dark-arrow-in-circle-right.32533171.svg)
Learning tracks
трек
Web Developer from Zero to Hero
Базовий
4.0
(4)
трек
Foundations of Machine Learning
Просунутий
5.0
(1)
трек
Python from Zero to Hero
Базовий
4.0
(3)
трек
TEST TRACK 1
Базовий
4.0
(334)
трек
Preparation for Data Science
Середній
5.0
(3)
трек
Java Essentials
Базовий
3.0
(1)
трек
Frontend Development Foundations
Середній
5.0
(2)
трек
Become a React Developer
Середній
трек
Full Stack Web Development
Базовий
5.0
(1)
трек
С++ for Beginners
Базовий
трек
Python Data Analysis and Visualization
Базовий
5.0
(1)
трек
![track image](https://staging-content-cdn.codefinity.com/images/d9e7a541-abc4-4046-822b-d1e4c5bfc4e3_TrackImage.png.png?w=3840&q=75)
Test track with rating
Просунутий
4.0
(4)
трек
![track image](https://staging-content-cdn.codefinity.com/images/984ace60-012d-487e-94c8-563525e32014_abc.jpg.jpg?w=3840&q=75)
TEST E2E TRACK BEGINNER
Базовий
трек
Become a Django Developer
Просунутий
трек
Flask for Dummies
Середній
5.0
(1)
трек
Deep Learning Odyssey
Просунутий
трек
Python: Beyond Intermediate
Базовий
4.0
(3)
трек
Game Development with Unity
Базовий
5.0
(1)
трек
Web Development with C#
Базовий
3.5
(2)
трек
Skilled Python BackEnd Developer
Просунутий
4.0
(3)
трек
Web & Cloud Fundamentals
Базовий
4.5
(2)
Become a Database Management expert
Interactive exercises
Learning videos
AI-assistant on all courses
Workspaces for designing your own projects
Ready to get started?
ProBest intro offer | UltimateA complete experience to kickstart your career | |
---|---|---|
85+ Top-Rated courses | ||
Completion certificates | ||
Early access to new courses | ||
20+ hands-on Real-world projects | ||
Personalized study tracks | ||
Unlimited workspaces | ||
Boost your Tech Skills!
with up to 55% off
What you'll get with our subscription:
Access to 85+ top-rated courses
AI-driven Learning
Workspaces for practicing your skills
Personalized study tracks
Certificates of completion
Training 2 or more people?
Get your team access to Codefinity courses anytime, anywhere.
Try Codefinity Teams