Free Introduction to SQL eBook

Related tags

Database mysql sql database ebooks hacktoberfest
Overview

๐Ÿ’ก 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.

Comments
  • Feature:

    Feature:

    Is your feature request related to a problem? Please describe.

    Links to chapters are not added.

    Describe the solution you'd like

    Adding links to chapters in README.md

    Additional context

    please consider this for Hacktoberfest 2021.

    enhancement 
    opened by vibuverma 4
  • Feature: More Use cases of INSERT Clause

    Feature: More Use cases of INSERT Clause

    Hi ,

    There is a scope of improvement in the insert.md file. More use cases can be added along with examples.

    I would like to contribute for the same. Kindly assign this issue to me.

    enhancement 
    opened by vishalsharma1997 3
  • Bug: Contibuting.md is not up to date

    Bug: Contibuting.md is not up to date

    File Location/Types in Contributing.md doesn't match the current project structure will update that.

    To Reproduce

    1.Visit : This There are no translations of the book present in the repo now will change it as per the current structure.

    Expected behavior

    Current structure explanation

    Screenshots

    Additional context

    I Will work on it as part of Hacktoberfest 2021

    bug 
    opened by maneprajakta 3
  • typo correction

    typo correction

    What type of PR is this? (check all applicable)

    • [ ] โ™ป๏ธ Refactor
    • [ ] โœจ Feature
    • [x] ๐Ÿ› Bug Fix
    • [ ] ๐Ÿ‘ท Optimization
    • [ ] ๐Ÿ“ Documentation Update
    • [ ] ๐Ÿšฉ Other

    Description

    changed "If we wanted to the only the username and the email columns" to "If we wanted to retrieve only the username and the email columns"

    Related Tickets & Documents

    Added to documentation?

    • [ ] ๐Ÿ“œ readme
    • [x] ๐Ÿ™… no documentation needed

    [optional] What gif best describes this PR or how it makes you feel?

    opened by roadsql 2
  • Feature: Add

    Feature: Add "Pattern matching" to 005-select.md

    Is your feature request related to a problem? Please describe.

    The section 005-select.md would deserve a mention of basic pattern matching using LIKE and ILIKE operators.

    Describe the solution you'd like

    Add another section called "Pattern matching" to 005-select.md explaining how to use LIKE and ILIKE.

    Additional context

    enhancement 
    opened by mclbdn 2
  • adding detail of sql commnad categories and arraning order of sequence

    adding detail of sql commnad categories and arraning order of sequence

    What type of PR is this? (check all applicable)

    • [x] โ™ป๏ธ Refactor
    • [x] โœจ Feature
    • [ ] ๐Ÿ› Bug Fix
    • [ ] ๐Ÿ‘ท Optimization
    • [x] ๐Ÿ“ Documentation Update
    • [ ] ๐Ÿšฉ Other

    Description

    Related Tickets & Documents

    Added to documentation?

    • [ ] ๐Ÿ“œ readme
    • [ ] ๐Ÿ™… no documentation needed

    [optional] What gif best describes this PR or how it makes you feel?

    opened by BirajMainali 2
  • Feature: want to add about truncate table in table chapter

    Feature: want to add about truncate table in table chapter

    Is your feature request related to a problem? Please describe.

    want to add about truncate table in table chapter

    Describe the solution you'd like

    The TRUNCATE TABLE command deletes the data inside a table, but not the table itself.

    Additional context

    contributing to hacktoberfest 2021

    enhancement 
    opened by nishajha629 2
  • Feature: Want to add point How to Rename a Table in creating-tables chapter

    Feature: Want to add point How to Rename a Table in creating-tables chapter

    Is your feature request related to a problem? Please describe.

    creating-tables Chapter does not describe how to rename a table

    Describe the solution you'd like

    Add rename table point along with example

    Additional context

    Contributing as part of Hactoberest 2021

    enhancement 
    opened by maneprajakta 2
  • Feature: In Create table Chapter want to add How to create table from existing table

    Feature: In Create table Chapter want to add How to create table from existing table

    Is your feature request related to a problem? Please describe.

    Create table Chapter don't include point of How to create a new table from existing table

    Describe the solution you'd like

    I would like to add the point with an example. Syntax of it CREATE TABLE new_table AS (SELECT * FROM old_table);

    Additional context

    Want to contribute as part of Hacktoberfest 2021

    enhancement 
    opened by maneprajakta 2
  • Add 'Pattern matching' to 005-select.md

    Add 'Pattern matching' to 005-select.md

    What type of PR is this? (check all applicable)

    • [ ] โ™ป๏ธ Refactor
    • [ ] โœจ Feature
    • [ ] ๐Ÿ› Bug Fix
    • [ ] ๐Ÿ‘ท Optimization
    • [x ] ๐Ÿ“ Documentation Update
    • [ ] ๐Ÿšฉ Other

    Description

    Added LIKE and ILIKE section explaining pattern matching.

    Related Tickets & Documents

    #72

    Added to documentation?

    • [ ] ๐Ÿ“œ readme
    • [ x] ๐Ÿ™… no documentation needed

    [optional] What gif best describes this PR or how it makes you feel?

    opened by mclbdn 1
  • some typos and grammar corrections

    some typos and grammar corrections

    What type of PR is this? (check all applicable)

    • [ ] โ™ป๏ธ Refactor
    • [ ] โœจ Feature
    • [ ] ๐Ÿ› Bug Fix
    • [ ] ๐Ÿ‘ท Optimization
    • [x] ๐Ÿ“ Documentation Update
    • [ ] ๐Ÿšฉ Other

    Description

    Related Tickets & Documents

    Added to documentation?

    • [ ] ๐Ÿ“œ readme
    • [x] ๐Ÿ™… no documentation needed

    [optional] What gif best describes this PR or how it makes you feel?

    documentation enhancement hacktoberfest-accepted 
    opened by SobiJain 1
Owner
Bobby Iliev
DevOps Engineer | Laravel enthusiast | Avid Linux lover
Bobby Iliev
GitHub https://sql.bobby.sh
A simple UI client for most SQL Engines written in Electron. It is compatible with Windows, Mac, Ubuntu / Debian and Redhat. It supports most dialects of RMBDs like MySQL, Microsoft SQL Server, Postgres, SQLite and has limited supports for Cassandra, MongoDB and Redis.

sqlui-native sqlui-native is a simple UI client for most SQL Engines written in Electron. It is compatible with most desktop OS's and support most dia

Sy Le 49 Jan 1, 2023
Connect to private Google Cloud SQL instance through Cloud SQL Auth Proxy running in Kubernetes.

โ›… google-cloud-sql A CLI app which establishes a connection to a private Google Cloud SQL instance and port-forwards it to a local machine. Connection

Dinko Osrecki 10 Oct 16, 2022
An easy-to-use multi SQL dialect ORM tool for Node.js

Sequelize Sequelize is a promise-based Node.js ORM tool for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server. It features solid transaction s

Sequelize 27.3k Jan 4, 2023
ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap, Ionic, React Native, NativeScript, Expo, and Electron platforms and can be used

null 30.1k Jan 3, 2023
Lovefield is a relational database for web apps. Written in JavaScript, works cross-browser. Provides SQL-like APIs that are fast, safe, and easy to use.

Lovefield Lovefield is a relational database written in pure JavaScript. It provides SQL-like syntax and works cross-browser (currently supporting Chr

Google 6.8k Jan 3, 2023
An SQL-friendly ORM for Node.js

Objection.js Objection.js is an ORM for Node.js that aims to stay out of your way and make it as easy as possible to use the full power of SQL and the

Vincit 6.9k Jan 5, 2023
AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

Please use version 1.x as prior versions has a security flaw if you use user generated data to concat your SQL strings instead of providing them as a

Andrey Gershun 6.1k Jan 9, 2023
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server & SQLite

Prisma Quickstart โ€ข Website โ€ข Docs โ€ข Examples โ€ข Blog โ€ข Slack โ€ข Twitter โ€ข Prisma 1 What is Prisma? Prisma is a next-generation ORM that consists of the

Prisma 28k Jan 2, 2023
An adapter-based ORM for Node.js with support for mysql, mongo, postgres, mssql (SQL Server), and more

Waterline is a next-generation storage and retrieval engine, and the default ORM used in the Sails framework. It provides a uniform API for accessing

Balderdash 5.4k Jan 4, 2023
Microsoft SQL Server client for Node.js

node-mssql Microsoft SQL Server client for Node.js Supported TDS drivers: Tedious (pure JavaScript - Windows/macOS/Linux, default) Microsoft / Contrib

null 2.1k Jan 4, 2023
TypeScript clients for databases that prevent SQL Injection

Safe From HTML Injection Using tagged template literals for queries, e.g. db.query(sql`SELECT * FROM users WHERE id=${userID}`); makes it virtually im

Forbes Lindesay 478 Dec 21, 2022
Conjure SQL from GraphQL queries ๐Ÿง™๐Ÿ”ฎโœจ

Sqlmancer Conjure SQL from your GraphQL queries ?? ?? โœจ โš ๏ธ This project is currently on hiatus. I am hoping to resume working on Sqlmancer once I have

Daniel Rearden 132 Oct 30, 2022
A simple url shorter API built with nodejs running on Kubernetes in Google Cloud, using PostgreSQL for storage and cloud sql proxy.

Simple URL Shorter - Google Cloud - Kubernetes A simple url shorter API built with nodejs running on Kubernetes in Google Cloud, using PostgreSQL for

null 3 Nov 25, 2021
Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application

Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application

DbGate 2k Dec 30, 2022
Postgres SQL RCE.js

Postgres-SQLi-RCE.js PostgreSQL Large Objects and UDF (User Defined Functions) RCE exploit re-written in javascript, for easy chaining with XSS Methdo

Amit 1 Jan 20, 2022
A web SQL interface to your Stripe account using Datasette.

Datasette, Stripe and tdog Or: Stripe Sigma Alternative Datasette is a web GUI for exploring SQLite datasets. Stripe handles online payments. Sigma is

Table Dog 20 Nov 27, 2022
Run SPARQL/SQL queries directly on Virtuoso database with connection pool support.

?? virtuoso-connector Package that allows you to create a direct connection to the Virtuoso database and run queries on it. Connection can be used to

Tomรกลก Dvoล™รกk 6 Nov 15, 2022
Database driven code generation for ts-sql-query

ts-sql-codegen This utility generates table mapper classes for ts-sql-query by inspecting a database through tbls. While it is possible to use ts-sql-

Lorefnon 12 Dec 12, 2022
Validate and auto-generate TypeScript types from raw SQL queries in PostgreSQL.

SafeQL Write SQL Queries With Confidence โ€ข Get started Install I would first recommend follow the instructions in the documentation. npm install --sav

null 747 Dec 28, 2022