Do You Want to Learn Sql?

Do You Want to Learn Sql?

Learn SQL → Analyze Data → Find Insights → Solve Business Tasks.

100% HANDS-ON Learning Experience. From Anywhere.

Start FREE Lessons

SQL — is a powerful language that helps to find insights for the business in raw data.

It is used to find an effective data-driven solution. Lots of companies are seeking SQL skills from operators and analysts. The number of job openings increases every year.

Why Learn SQL?

Why Learn SQL?

SQL is still the most popular technology among developers who work with data (including data scientists, data analysts, database administrators, data engineers)

StackOverflow 2023 Survey

The estimated total pay for a Research Data Scientist in 2024 is $153,989 per year in the United States area, with an average salary of $130,401 per year

Glassdoor Data Scientist Research
...
StackOverflow 2023 Survey
...
StackOverflow 2023 Survey

Who Will Benefit From This Course

Students

This website is the right place for you to get an introduction to SQL with hands-on experience in writing SQL queries.

Beginner Data Analysts

You will learn how to work with the database and will use SQL for that.

Managers

We will show you how to analyze data to make better data-driven business decisions.

Beginner Software Developers and QA

You will understand how to write better queries that work fast and make your website much quicker.

Marketers

We will show you how to use SQL to extract data from the database for your customers' future analysis.

What Would You Learn

How to filter data, sort, group, and join multiple related tables

Write SQL queries against a sandbox database.

How to calculate business-related metrics with SQL

You will perform research and will find insights from raw data.

As a result, you would be able to work with a database, write SQL queries, analyze raw data, build custom reports, and propose business solutions based on data.

Your Learning Track

From Beginner → To Advanced → To Reporting Ninja

12 modules, 120+ interactive SQL tutorials

Your Learning Track

From Beginner → To Advanced → To Reporting Ninja

12 modules, 120+ interactive SQL tutorials

Topics You Will Learn & Practice

Topics You Will Learn & Practice

SQL Fundamentals. 6 modules, 60+ lessons

Filtering and Sorting

You will learn how to filter the data you need from a table. We will cover the WHERE clause and how it works.

String Functions

It is essential to learn CONCAT, TRIM, LEN, SUBSTRING, and other string manipulation functions. You will solve our interactive lessons to learn them all.

Date Functions

CURRENT_DATE, DATE_PART, NOW are functions to manipulate date-type values. You will learn how to use them to display the data you need.

Aggregate Functions

Lessons will teach you how to use aggregate functions to summarize data to gain more insights for your reports.

Subqueries and Nested Queries

You will learn about subqueries in the SELECT, FROM, and WHERE clauses. You will gain an understanding of when subqueries are necessary for your queries.

How to JOIN tables

Learn how to select data from multiple tables and join them to display the reports you need. We will cover INNER, OUTER, LEFT, RIGHT, CROSS joins.

Advanced SQL Topics

Advanced SQL Topics

Next level. 3 modules, 30 lessons

Common Table Expression

Learn how to break large queries into smaller ones by using Common Table Expressions (CTEs).

Hierarchy and Recursion

Use CTEs to write recursive queries to process trees and graphs in SQL. Learn how to deal with such cases by solving interactive exercises.

Analytic Functions

Also known as windowing functions or OVER functions. We will cover syntax and will show how powerful they are. You will learn how building complex aggregations could be much simpler by using ORDER BY and PARTITION BY.

Performance. Reporting. DB Structure

Performance, Reporting, DB Structure

Pro-Level. 3 modules, 30 lessons.Coming soon.

Reporting

Lessons will cover how to create Views and Stored Procedures for reporting needs.

Performance

You will learn what an index is and how to create it for a certain table.

DB Structure

You will learn database schemas, normalization and will use Data Definition Language for that.

Loading...

FAQ

What is this website?

This website is an interactive tutorial to learn SQL from Beginner to Advanced levels.

You will have hands-on experience by writing queries and solving tasks.

Every bundle has between 30 to 60 interactive exercises covering certain topics. You read materials and solve SQL assignments by writing queries.

What will I get?

You will get a full track of SQL scripting: from Beginner → to Advanced → to Reporting Ninja.

The full track includes 120+ interactive lessons with learning materials and assignments for each topic.

You will use an interactive sandbox (like above) to write SQL queries and check the results.

As I am building this product for you, my dear junior engineers, I will mentor a limited number of students for free to make sure they have good progress and experience with this website.

Can I learn in my free time?

You absolutely can. Either you have a full-time job, or you are a student — you can learn any time you want from anywhere. You can spend just about 3 hours a week making progress.

The Curriculum

Part 1 (Basics)
→ Filtering and Sorting
→ String Functions, Date Functions
→ Aggregate Functions
→ Subqueries and Nested Queries
→ How to JOIN tables
Part 2 (Advanced & Pro SQL)
→ Common Table Expression
→ Hierarchy and Recursion
→ Analytic Functions.
→ Reporting
→ Performance and DB Structure

What do I need to take these courses?

You need at least to understand what SQL is and be somewhat familiar with the concept. Everything else is on us!

Materials we will give you with each assignment will explain some theory but are focused on practice. You will practice writing SQL queries a lot as you will work on ~60 tasks on each track.

For the Advanced SQL course, you need to know SQL Fundamentals and solve much more complex tasks.

About Us

Hi, I am Akim Khalilov!

I am a software development engineer with 12 years of experience working for small to mid and enterprise-level US companies.

During my journey, I was wearing many different hats, starting from a rookie engineer and growing to a senior developer, then to a team lead, and then overseeing a team of 50 engineers. I spent about 300+ hours interviewing people in tech for different roles and mentoring a dozen people who grew on my watch and improved their skill set. I find it interesting to challenge people and see how they grow.

I've been mentoring people and helping them with C#, JavaScript, SQL, time-management, GTD, communications, and more.

With this website and interactive SQL tutorial, I want to help people gain knowledge in SQL and improve their skills by having hands-on experience in learning the language and applying it to lessons and tasks.

This is my first public product and I want it to be amazing. I am working on it iteratively and improving every day. I will create so many lessons as I can to make sure you got covered. And if it is required — I will mentor you personally so you make a progress.

I hope you will find these tutorials useful, and that will help you in learning SQL.

Feel free to drop me a message on Twitter @sstude and check my LinkedIn profile if you want to know more about my background.