Blog

Books to learn SQL

When it comes to learning SQL, we often resort to searching Google, although it is true that most of us who do it already have knowledge of the language and have even mastered it.

But what happens when you don’t know the language? Well, training only with Internet searches is usually tedious and in many cases leads to poor learning of the basics.

In order to achieve a logical and quality learning process, without forgetting the bases of this fantastic language that is SQL, I have compiled the top 3 books in Spanish to learn SQL.

Content

  • Learn SQL in a weekend
  • SQL book for beginners
  • The SQL reference book

Learn SQL in a weekend

I’m going to start by recommending a book totally aimed at newcomers to SQLis called: “Learn SQL in a weekend: The Definitive Course on Creating and Querying Databases”.

As its title already indicates, it is a book focused on quick learning through examples (more than 100) and exercises. Its objective is none other than to teach you the SQL language in a basic and clear way so that with a few hours of dedication you can defend yourself in its use.

It’s a short book with only 124 pages, but which are more than enough to teach you how to deal with SQL quickly.

This is not a book for people who already know SQL, as it covers each and every SQL statement and does not delve into more advanced topics. In other words, if you want a book to carry out an SQL project without having a clue, this is your SQL book.

The complete table of contents is as follows:

  • PREAMBLE
  • CHAPTER 1.1 – INTRODUCTION
  • CHAPTER 1.2 – WHAT IS A RELATIONAL DATABASE?
  • CHAPTER 1.3 – PREPARING THE ENVIRONMENT
  • CHAPTER 1.4 – WHAT CAN I SAVE IN A DATABASE?
  • CHAPTER 1.5 – YOUR FIRST DATABASE
  • CHAPTER 1.6 – CREATION OF TABLES
  • CHAPTER 1.7 – SAVE AND CONSULT INFORMATION
  • CHAPTER 1.8 – SUMMARY OF THE FIRST DAY
  • CHAPTER 2.1 – THE SQL LANGUAGE
  • CHAPTER 2.2 – CREATE, ALTER AND DROP TABLE
  • CHAPTER 2.3 – INSERT INTO
  • CHAPTER 2.4 – USE OF PRIMARY KEY
  • CHAPTER 2.5 – BASIC SELECT
  • CHAPTER 2.6 – SELECT + WHERE
  • CHAPTER 2.7 – JOIN
  • CHAPTER 2.8 – UNION AND EXCEPT
  • CHAPTER 2.9 – UPDATE AND DELETE
  • CHAPTER 2.10 – SUMMARY OF THE SECOND DAY
  • CHAPTER 3.1 – FUNCTIONS
  • CHAPTER 3.2 – GROUP BY
  • CHAPTER 3.3 – SUBQUERIES
  • CHAPTER 3.4 – VIEWS
  • CHAPTER 3.5 – OUTER JOIN
  • CHAPTER 3.6 – OPERATIONS WITH DATETIME
  • CHAPTER 3.7 – FINAL PROJECT

Finally, remind you that the book is entirely in Spanish.

SQL book for beginners

“SQL. The fundamentals of language (with corrected exercises) – 2nd edition“it’s a fantastic sql book for beginners without prior knowledge of SQL or with very basic knowledge and who want to master the SQL language learning by doing and with exercises.

The book is made up of 420 pages fully translated into Spanish.

Its second edition is from this same year (2018) and brings corrections and updates on its first version of 2014.

All the exercises that you will find inside are carried out on the Oracle and Mysql platforms, which assures you a good background since they are the two most used database managers worldwide.

You can download all the exercises from their website at the address specified in the book. In this way you will work with real data and with databases very similar to those you will find in the real world.

I think it’s a “must have” for anyone who wants to learn with organized and quality content and get adequate training.

The SQL reference book

With its 384 pages and fully in Spanishthis SQL book from the publishing house (of course) O’Reilly y Anaya Multimedia is a work destined to be a reference on your shelf.

With this book we climb one more step in relation to the depth of learning and content, and that is that it is the book that every SQL professional should read at least once.

It’s a book for those already started in SQL programming, since it can be somewhat difficult to understand if you do not have the adequate bases. It is not that we recommend it for experts, but for users who have gone through books like the previous 2 on the list.

Among its strengths stands out:

  • very well organized
  • Good writing
  • simple to understand
  • With examples appropriate to the level and elaborated.
  • Each concept is explained in a concise and practical way

Leave a Reply