• Title: Introduction to SQL
• Author(s): Bobby Iliev
• Publisher: Unglue; eBook (MIT Licensed)
• License(s): MIT Licensed
• Paperback: N/A
• eBook: HTML and PDF
• Language: English
• ISBN-10/ASIN: N/A
• ISBN-13: N/A
• Share This:  

Book Description

SQL was, is and always will be the database language for relational database systems such as Oracle, DB2, MySQL, and Microsoft SQL Server.

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.

Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data management.

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

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

• Amazon

• SQL - The Structured Query Language
• Oracle Databases
• PostgreSQL
• Database Theory and Systems
• Microsoft SQL Server

• Introduction to SQL (Bobby Iliev)
• The Mirror Site (1) - PDF
• The Mirror Site (2) - PDF
• The Mirror Site (3) - HTML

• SQL The Complete Reference (James R. Groff, et al.)

  Get comprehensive coverage of every aspect of SQL from three leading industry experts. This one-stop guide explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications.

• SQL Performance Explained: Everything Developers Need to Know

  Starting with the basics of indexing and the WHERE clause, this book guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate.

• A Primer on SQL (Rahul Batra)

  This book is an introduction to the basics of SQL. No prior experience with SQL is necessary, but some knowledge of working with computers in general is required. It is not intended as a reference work or for a full time database administrator.

• SQL Queries Succinctly (Nick Harrison)

  This book shows you how to craft queries in SQL, from basic CRUD statements and slicing and dicing the data, to applying filters and using aggregate functions to summarize the data, solving common problems, navigating hierarchical data, etc.

• MySQL Notes for Professionals

  When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don't have the time (or expertise) to solve MySQL problems from scratch.

• Creating your MySQL Database: Design Tips and Techniques

  Written by the creator of the popular phpMyAdmin tool, this book is a short but complete guide on how to design good data structures for MySQL. Anyone uses a MySQL database backend will benefit greatly from the advice and techniques in this book.

• PostgreSQL Tutorials

  These tutorials offer readers a thorough overview of database basics, starting with an explanation of why you might need to use a PostgreSQL database, and following with a summary of what different database types have to offer when compared to alternatives like spreadsheets.

• Transact-SQL: The Building Blocks to SQL Server Programming

  This book will cover different aspects of the Transact SQL (TSQL) language. It takes the readers step by step through the TSQL language, one concept at a time. Each topic covers a particular aspect of TSQL with discussion and examples.

• Learn T-SQL Querying (Pedro Lopes, et al)

  The book will get you started with query processing fundamentals to help you write powerful, performant Transact-SQL (T-SQL) queries. You will then focus on query execution plans and learn how to leverage them for troubleshooting.