Opensource Introduction to SQL eBook 💡
Tags: sql, database, webdev, books
Published: 2021-05-18 13:32:32

This is an open-source introduction to SQL guide that will help you learn the basics of SQL and start using relational databases for your SysOps, DevOps, and Dev projects. No matter if you are a DevOps/SysOps engineer, developer, or just a Linux enthusiast, you will most likely have to use SQL at some point in your career.

The guide is suitable for anyone working as a developer, system administrator, or a DevOps engineer and wants to learn the basics of SQL.

## 📜 GitHub Project

If you enjoy the eBook, make sure to star it on [GitHub](https://github.com/bobbyiliev/introduction-to-sql)!

## 🚀 Download

To download a copy of the ebook use one of the following links:

* [Dark mode](https://github.com/bobbyiliev/introduction-to-sql/raw/main/ebook/en/export/introduction-to-sql-dark.pdf)

* [Light mode](https://github.com/bobbyiliev/introduction-to-sql/raw/main/ebook/en/export/introduction-to-sql-light.pdf)

## 📘 Chapters

* **About the book**
* **Databases**
* **MySQL**
* **Tables**
* **Basic Syntax**
* **SELECT**
* **WHERE**
* **ORDER and GROUP BY**
* **INSERT**
* **UPDATE**
* **DELETE**
* **JOIN**
* **The MySQL dump command**
* **Conclusion**

## 🌟 Sponsors

This book is made possible thanks to these fantastic companies!

### 💙 DigitalOcean

DigitalOcean is a cloud services platform delivering the simplicity developers love and businesses trust to run production applications at scale.

It provides highly available, secure, and scalable compute, storage, and networking solutions that help developers build great software faster.

Founded in 2012 with offices in New York and Cambridge, MA, DigitalOcean offers transparent and affordable pricing, an elegant user interface, and one of the largest libraries of open source resources available.

For more information, please visit [https://www.digitalocean.com](https://www.digitalocean.com) or follow [@digitalocean](https://twitter.com/digitalocean) on Twitter.

If you are new to DigitalOcean, you can get a free $100 credit and spin up your own servers via this referral link here:

[Free $100 Credit For DigitalOcean](https://m.do.co/c/2a9bba940f39)

### 👩‍💻 DevDojo

The DevDojo is a resource to learn all things web development and web design. Learn on your lunch break or wake up and enjoy a cup of coffee with us to learn something new.

Join this developer community, and we can all learn together, build together, and grow together.

[Join DevDojo](https://devdojo.com?ref=bobbyiliev)

For more information, please visit [https://www.devdojo.com](https://www.devdojo.com?ref=bobbyiliev) or follow [@thedevdojo](https://twitter.com/thedevdojo) on Twitter.

## 📹 Mini Video Course

I am planning on recording a mini video course soon based on the eBook.

## 👋 About the author

My name is Bobby Iliev, and I have been working as a Linux DevOps Engineer since 2014. I am an avid Linux lover and supporter of the open-source movement philosophy. I am always doing that which I cannot do in order that I may learn how to do it, and I believe in sharing knowledge.

I think it's essential always to keep professional and surround yourself with good people, work hard, and be nice to everyone. You have to perform at a consistently higher level than others. That's the mark of a true professional.

For more information, please visit my blog at [https://bobbyiliev.com](https://bobbyiliev.com), follow me on Twitter [@bobbyiliev_](https://twitter.com/bobbyiliev_) and [YouTube](https://www.youtube.com/channel/UCQWmdHTeAO0UvaNqve9udRw).

In case that you want to support me you can Buy Me a Coffee here:

<a href="https://www.buymeacoffee.com/bobbyiliev" target="_blank"><img src="https://www.buymeacoffee.com/assets/img/custom_images/orange_img.png" alt="Buy Me A Coffee" style="height: 41px !important;width: 174px !important;box-shadow: 0px 3px 2px 0px rgba(190, 190, 190, 0.5) !important;-webkit-box-shadow: 0px 3px 2px 0px rgba(190, 190, 190, 0.5) !important;" ></a>

## 🔥 PDF Generation Tool

The project uses [Ibis](https://github.com/themsaid/ibis/) developed by [Mohamed Said](https://github.com/themsaid).

Ibis is a PHP tool that helps you write eBooks in markdown.

## 🎨 Book Cover

The cover for this ebook was created with [Canva.com](https://www.canva.com/join/determined-cork-learn).

If you ever need to create a graphic, poster, invitation, logo, presentation – or anything that looks good — give Canva a go.

## 📖 Other books

- [Introduction to Git and GitHub](https://github.com/bobbyiliev/introduction-to-git-and-github-ebook)
- [Introduction to Bash Scripting](https://github.com/bobbyiliev/introduction-to-bash-scripting)

## 🤲 Contributing

All contributions 🍿 are more than welcome!