• Stars
    star
    344
  • Rank 122,755 (Top 3 %)
  • Language
    HTML
  • License
    MIT License
  • Created over 3 years ago
  • Updated about 2 months ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

Free Introduction to SQL eBook

πŸ’‘ Introduction to SQL

This is an open-source introduction to SQL guide that will help you to 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.

πŸš€ Download

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

πŸ“˜ Chapters

🌟 Sponsors

Thanks to these fantastic companies that made this book possible!

πŸ“Š Materialize

The Streaming Database for Real-time Analytics.

Materialize is a reactive database that delivers incremental view updates. Materialize helps developers easily build with streaming data using standard SQL.

πŸ’™ 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 or follow @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 provided below:

Free $100 Credit For DigitalOcean

πŸ‘©β€πŸ’» DevDojo

The DevDojo is a resource to learn all things related to web development and web design. Learn while 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

For more information, please visit https://www.devdojo.com or follow @thedevdojo on Twitter.

πŸ•ΈοΈ Web Page

A web page showcasing the eBook:

Introduction to SQL

The web page was built using Tails, a new kick-ass drag-and-drop TailwindCSS page builder!

DigitalOcean App Platform

This will be hosted on the DigitalOcean App Platform.

We will utilize the "Deploy to DigitalOcean" Button to deploy to the App Platform:

Deploy to DO

πŸ“Ή Mini Video Course

Coming soon

πŸ’» Interactive training

You can follow the interactive training online here:

Interactive SQL training

The training was built with Katacoda. You can find the Katacoda repository here.

For more information on how to use Katacoda make sure to follow the steps from this tutorial here:

How to Use Katacoda to Create Highly Engaging Training Tutorials

πŸ‘‹ 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 keen on doing what I cannot do in order to 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, follow me on Twitter @bobbyiliev_ and YouTube.

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

Buy Me A Coffee

πŸ”₯ PDF Generation Tool

The project uses Ibis developed by Mohamed Said.

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

🎨 Book Cover

The cover for this ebook was created with Canva.com.

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

πŸ”— Links

πŸ“– Other eBooks

🀲 Contributing

If you are contributing 🍿 please read the contributing file before submitting your pull requests.

More Repositories

1

introduction-to-bash-scripting

Free Introduction to Bash Scripting eBook
HTML
4,203
star
2

introduction-to-git-and-github-ebook

Free Introduction to Git and GitHub eBook
HTML
776
star
3

101-linux-commands-ebook

101 Linux commands Open-source eBook
Python
702
star
4

introduction-to-docker-ebook

Free Introduction to Docker eBook
HTML
266
star
5

laravel-tips-and-tricks-ebook

Free Laravel Tips eBook
HTML
173
star
6

materialize-tutorials

Materialize is a streaming database for real-time analytics. This is a collection of Materialize demos and tutorials.
Python
83
star
7

bash-ssl-checker-tool

This is a very simple bash script that you could use to gain general information for the SSL certificate of a certain domain name. It is based on the functionality of the popular https://sslshopper.com website, but it's a command line tool.
Shell
47
star
8

quick_access_logs_summary

This is a BASH script which will quickly summarize your access logs and provide you with very useful information like:
Shell
30
star
9

cloudflare-ddos-protection

You can use this CLI script to enable and disable the CloudFlare DDOS protection for your website automatically based on the CPU load of your server.
Shell
24
star
10

github-activity-bash-script

Shell
17
star
11

cloudflare-ai-worker-demo

TypeScript
15
star
12

cpanel-toolkit

Simple cPanel Terminal ToolKit that would help you manage and troubleshoot issues with your server easily via SSH
Shell
14
star
13

simple-reviews-and-rating-system

PHP
12
star
14

cf-url-shortener

URL Shortener Cloudflare function that uses Upstash Redis and Kafka along with https://materialize.com
JavaScript
12
star
15

bobbyiliev

10
star
16

ibis-build-action

GitHub Action to run ibis builds on merge
HTML
10
star
17

katacoda

8
star
18

tutorials

Blog posts by me πŸš€
5
star
19

laravel-digitalocean-1-click

Packer build scripts for the Laravel image on the DigitalOcean Marketplace 1-clicks.
Blade
4
star
20

ssh-2FA

This is a simple bash script that works as a 2FA for Shell access, you can use it on shared hosting platforms where you do not have root/sudo access
Shell
3
star
21

SyntropyNet-Minecraft

PHP
3
star
22

laravel-nginx-server-block

3
star
23

pfx-ssl-converter

This is a very simplified PHP form that would convert your SSL certificate into a .pfx format. This would save you time as you will not have to save the files on your PC and then execute the super long openssl command, nor would you need to use a third party service like sslshopper to convert your files.
PHP
3
star
24

terraform-aws-kafka-privatelink

HCL
2
star
25

materialize-sql-exporter-demo

Materialize + Prometheus SQL Exporter + Grafana
2
star
26

materialize-dbt-action

Shell
2
star
27

serverless-hello-wolrd-node

JavaScript
2
star
28

wordpress-fun

A simple BASH script that would help you test your WordPress troubleshooting skills
2
star
29

autossl-cpanel-checker

This is a short script that would loop though All of the domain names on your server, check if their A record is pointing to the server and if so check their SSL status. Then you would get a email if there are any SSL certificates that are about to expire in 'n' number of days. This is just an example, you can modify it so that it would match your needs.
Shell
2
star
30

mz-http-logs

Self-contained demo using Materialize to parse server logs for a mock e-commerce site, and extracting some business insights from them.
Python
2
star
31

kill-sleeping-mysql-processes

This is a simple bash script that would kill any MySQL connections that have been sleeping longer than 'x' amount of time.
Shell
1
star
32

snake-game-event-streaming

JavaScript
1
star
33

materialize-dbt-actions-demo

1
star
34

climateclock

Blade
1
star
35

cf-geoip

Geo IP Lookup Cloudflare Worker Service
JavaScript
1
star