SQL Online Course

Learn the popular SQL language

WHY?

The demand for database experts is constantly growing because the data is continually increasing, and companies want to have someone who can read the necessary information from the data.

SQL is an essential skill. Anyone can learn it.

Frequently asked questions

How is the online course designed?

The course is scheduled for 6 weeks. Each module consists of one week. The first 4 days of the week are discussed, SQL, 3 days are free. In the course, we always look in the form of a video how the given area of SQL is used. Everything is step by step on specific examples. You can try the examples with me. The theory is also written in text, so there is no need to write notes.

What qualifications are needed?

The course is designed for complete beginners without prior knowledge. You do not need any special qualifications to be able to handle the material of the book. All you have to do is be interested, and the results will come.

Can I try the examples myself?

Yes, you certainly can. All you have to do is import the table structures and data that are part of the e-book into the database, and you can try everything with me. As part of the course, videos are made to proceed step by step on the examples. The video can be paused at any time. It can also be played again. The videos contain English subtitles, so it is possible to play the videos without sound, for example, in a noisy environment. 🙂

Course content

What content will you find in the online course?

The course is designed into videos, texts. In the course, we find:

Basics: SELECT, WHERE, ORDER BY, GROUP BY, HAVING, DISTINCT,

Data group: COUNT, AVG, SUM, MIN, MAX, LIKE, IN, AND, OR, LIMIT,

JOINS: JOIN, INNER JOIN, LEFT JOIN, RIGHT JOIN,

Data manipulation: CREATE TABLE, INSERT INTO, ALTER TABLE, DROP TABLE, DELETE

BONUS 1

Operators

Let’s take a look at what is often used operators within SQL.

BONUS 2

Common mistakes

When writing our questions, we do not avoid mistakes, due to which everything does not work according to our ideas. I have written down the most common mistakes you may encounter. ;)

References

As a finance analyst, I decided to learn SQL basics to be ready for an interview in the banking sector. I searched for many courses. However, I got lost as most of them were complex and took too long. Cate's e-book was a great starting point, as it only contained practical examples which I could apply straight away. Within 5 minutes, I was able to write basic functions correctly and easily understood the differences. SQL and coding are complicated, and I really appreciate how simple this e-book is written - exactly what the beginner needs to create basic tables and filter data. Also, you can easily find any function and see how the table looks visually. Definitely, a must-have for a beginner!

Vendula N.

Finance Analyst