E-book SQL in 14 days

Learn the popular SQL language, ElastAlert

WHY?

3Debook

 

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 e-book designed?

We always summarize the given SQL clause theoretically, explain what it is for, how it is used, and examples of solutions.​

What qualifications are needed?

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

E-book content​​

What content will you find in the e-book?

I have written the individual chapters here so that you know what you will learn in the e-book:

 

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

bonus_3D

SQL summary

 

From my experience, I know that reading the material in a comprehensive e-book is one thing, but when creating our queries, we want to save time and welcome a summary. That’s why I wrote SQL training especially for you.

You can look into it and save time.

BONUS 2

DDL 

 

You don’t have to think about what tables you will create and how you will fill them with data. I did it for you. 

In this bonus, you will find everything you need to play with your data in one place.

 

creatingtables_3D

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