SQL from Zero to Hero - Data Engineer Career Track

Track

Certificate

SQL from Zero to Hero

4.7+

★★★★★

2081 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 Teams

What 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.

97 chapters
9 hours
108 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.

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

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 work with such data. For this, we will get acquainted with such an operator as GROUP BY. You will also learn how to filter grouped data using the operator HAVING.

In this section, you will learn what nested subqueries are, how to create them, and how to work with them.

Nested Queries
Preview

In this section, you will learn how you can combine several tables, thus working with one common table, which will simplify the creation of queries.

In this section, you will learn how to combine several tables in different ways, in particular: INNER JOIN, LEFT JOIN, RIGHT JOIN.

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...