Back to articles list Articles Cookbook
7 minutes read

Stay at Home and Learn SQL for Free with LearnSQL.com

Working remotely is a dream come true for some. You ditch commuting and have more time for the people you love and the things you enjoy. For others, it's a challenge to maintain their focus when there are new distractions. It's also an opportunity to invest the few gained hours in learning something new.

Staying at home can be a time when you might find yourself busier than you've ever been, but not getting many things done, and worse, not learning what you planned to.

From 03/20/2020 LearnSQL.com is offering its full list of courses, free, to everyone until 04/20/2020. Just create a free account to unlock all of the courses. That's a lot of knowledge.

You might be tempted to jump right into the meat and potatoes of your educational feast. However, it might leave a sour taste in your mouth if you’re not sure where to start. That's why we've prepared a road map for you on how to make a smooth entry to learning SQL online in 14 days.

I want to learn. But what's next?

Although you can choose any course from our offer, whether you are a beginner or have never even had to deal with SQL, it is worth following the path we set. We have prepared a 10-point learning scheme for you. Be diligent and motivated to act and you will achieve success.

STEP 1: WATCH “WE LEARN SQL” TUTORIALS ON YOUTUBE

Let's start with the basics. First, find out what databases are and what SQL really is. Check what all the fuss is about. For some time we've been publishing short tutorials on YouTube – the We Learn SQL series. The clips feature Adrian Więch, our expert and author of many courses on LearnSQL.com. He will easily introduce you to the world of SQL.

Watch these clips first:

Remember to subscribe to our channel and give it a thumbs up if you like it. Don't be afraid to comment on our videos.

STEP 2: START FREE COURSE – SQL BASICS – DO PARTS 1, 2

We assume that you are an absolute beginner in SQL. The SQL Basics course will teach you the necessary fundamentals. We assume that you have no previous experience with SQL. You've come to the right place. The LearnSQL.com platform is the best place to learn. We offer courses in SQL and its dialects – MS SQL Server and PostgreSQL. All exercises are interactive and do not require anything more from the user than having an internet connection and a web browser – you will write code in our console. You don't need to install anything. Remember SQL is a powerful query language that lets you work with many types of data, but learning it with us in reality is pretty simple.

Navigating our platform is intuitive. In addition to the courses themselves, you have our blog at your disposal – it's worth reading – and a huge database of Cookbooks, ready-made real scenarios to be used for the challenges of everyday work.

What can you expect when doing the SQL Basics interactive course? First, you will learn how to write queries to data collected in one table. You will do exercises that will help you practice your knowledge step by step. You'll find out what the SELECT clause is and when to use WHERE writing SQL code. Sounds interesting?

STEP 3: LEARN MORE ADVANCED SQL – DO PART 3, 4

Once you master the basics, the time will come for more advanced topics. You will learn how easy it is to work with many tables using the magic of SQL JOINs. You will learn how this function works and how to apply it in business. Do you want to do calculations in SQL? Why not? Discover how to calculate, extract averages and statistics using aggregate functions.

STEP 4: BACK ON YOUTUBE

Take a break from the course and see how much you have understood from previous topics. Return to Youtube and watch these videos:

STEP 5: MORE ON JOINS

In the fifth part of the SQL Basics course you will learn even more about JOINs, exactly how to use them and what self-join is. If you would like to broaden your knowledge, it is worth watching the next episode from our series We Learn SQL #4 | SQL LEFT RIGHT and FULL JOIN.

STEP 6: GO DEEPER – SET OPERATIONS AND SUBQUERIES

In this part, we will provide you with absolutely free knowledge of how to use the GROUP BY clause, which you will be able to quickly use to create simple SQL Reports. Queries within queries? That's right! Sounds like something from the movie "Inception" with Leonardo DiCaprio? Well no. It's an interesting way to use SQL – you'll learn how to build and use subqueries.

STEP 7: TEST YOUR SKILLS

For the end of the SQL Basics course, we have prepared something that will tell you how much you can do – a well-themed quiz that will check your SQL level. If you manage to complete it, you'll get a certificate. Showing it to the boss or adding it to your LinkedIn profile guarantees career development.

It is worth noting that if you get to this stage, you will already have 129 interactive exercises with SQL done and quite a lot of topics covered. Who would have thought?

STEP 8: NEVER TOO MUCH ABOUT JOINS

Another free course we have decided to give you is SQL JOINs course. Why are we so focused on this feature? JOINs are one of the most fundamental and commonly used features of the SQL language. JOINS are an absolute must for every SQL user.

What awaits you with SQL JOINs? Cool stuff. You will learn how to select data from more than one table, how to combine tables with one query and how to use LEFT, RIGHT, and FULL JOIN correctly. We'll show you how to filter data and combine tables in non-key columns. You will also delve into the interesting topic of non-equal JOINs. If this doesn't sound encouraging enough for you, imagine something else. Until now, you had to wait for IT guys to write for you the code needed to extract data for the financial report from the database. Now you can do it yourself.

The first four parts of SQL JOINS are 75 exercises arranged properly so that you can easily go to the next stage.

Well... there will be no surprise here. To finish this course do the JOINs test and then show off your new certificate.

STEP 9: PRACTICE MAKES PERFECT

We can honestly say that this saying really makes sense. Because what’s the point of having all this knowledge if you can't put it into practice. If Michael Jordan read a lot about basketball but never threw a shot, would he become the best player in the world? That's why we give you a SQL Practice Set course for free.

Good knowledge of SQL is a hands-on experience – learning concepts is one thing, but writing good queries requires practice. You can really enjoy the gift from us because all the 88 interactive exercises are based on real-world examples. You will write queries for real business situations. Sounds nice? You will test yourself and find out what else you need to work on. The course ends with an SQL challenge. Practice your SQL skills. Write SQL queries that combine SELECT, WHERE, JOIN, GROUP BY, HAVING, ORDER BY and subqueries. Get the certificate and start planning your future career.

The SQL Practice Set is often chosen by people preparing for interviews for jobs related to SQL, such as DBA or Data Analyst. We will not pretend that the exercises are easy. They are demanding. But after completing them you will be sure that you have learned how to use SQL.

STEP 10: GROUP BY MEMBERS – JOIN “WE LEARN SQL” GROUP ON FACEBOOK

Joining our group, We Learn SQL, is a great opportunity to begin sharing your learning experiences with others. This is the perfect way to grow your SQL skills, regardless of whether you are a seasoned analyst or just starting your database adventure. Sharing our common passions and pooling our knowledge and experience is the most enjoyable and easiest path to success. We are stronger when we work together!

Summary

We know that hard times have come. But the sun always comes out after a big storm. So it's worth investing in yourself while staying at home, especially now that it won't cost you anything. Go to LearnSQL.com, and start learning today!