A Primer on SQL
A Primer on SQL
About the Book
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. My purpose of writing this was to provide a gentle tutorial on the syntax of SQL, so that the reader is able to recognize the parts of queries they encounter and even be able to write simple SQL statements and queries themselves. The book however is not intended as a reference work or for a full time database administrator since it does not have an exaustive topic coverage.
- About the author
1. An Introduction to SQL
- 1.1 SQL Commands Classification
- 1.2 Explaining Tables
2. Getting your database ready
- 2.1 Using Ingres
- 2.2 Using SQLite
- 2.3 Creating your own database
- 2.4 Table Creation
- 2.5 Inserting data
- 2.6 Writing your first query
- 3.1 Selective fields INSERT
- 3.2 Primary Key Constraint
- 3.3 Unique Key Constraint
- 3.4 Differences between a Primary Key and a Unique Key
4. Operations on Tables
- 4.1 Dropping Tables
- 4.2 Creating new tables from existing tables
- 4.3 Modifying tables
- 4.4 Verifying the result in Ingres
- 4.5 Verifying the result in other DBMS’s
- 4.6 Showing table information in SQLite
5. Writing Basic Queries
- 5.1 Selecting a limited number of columns
- 5.2 Ordering the results
- 5.3 Ordering using field abbreviations
- 5.4 Putting conditions with WHERE
- 5.5 Combining conditions
6. Manipulating Data
- 6.1 Inserting NULL’s
- 6.2 Inserting data into a table from another table
- 6.3 Updating existing data
- 6.4 Deleting data from tables
7. Organizing your data
- 7.1 Normalization
- 7.2 Atomicity
- 7.3 Repeating Groups
- 7.4 Splitting the table
8. Doing more with queries
- 8.1 Counting the records in a table
- 8.2 Column Aliases
- 8.3 Order of execution of SELECT queries
- 8.4 Using the LIKE operator
9. Calculated Fields
- 9.1 Mathematical calculations
- 9.2 String operations
- 9.3 Literal Values
10. Aggregation and Grouping
- 10.1 Aggregate Functions
- 10.2 Using DISTINCT with COUNT
- 10.3 Using MIN to find minimum values
- 10.4 Grouping Data
- 10.5 The HAVING Clause
11. Understanding Joins
- 11.1 What is a Join?
- 11.2 Alternative Join Syntax
- 11.3 Resolving ambiguity in join columns
- 11.4 Cross Joins
- 11.5 Self Joins
- 12.1 Types of subqueries
- 12.2 Using subqueries in INSERT statements
- Further Reading
- Appendix: Major Database Management Systems
The Leanpub 45-day 100% Happiness Guarantee
Within 45 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers), EPUB (for phones and tablets) and MOBI (for Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Algebra-Driven DesignSandy Maguire
A how-to field guide on building leak-free abstractions and algebraically designing real-world applications.
Production HaskellMatt Parsons
Are you excited about Haskell, but don't know where to begin? Are you thrilled by the technical advantages, but worried about the unknown pitfalls? This book has you covered.
Machine Learning EngineeringAndriy Burkov
"If you intend to use machine learning to solve business problems at scale, I'm delighted you got your hands on this book."
—Cassie Kozyrkov, Chief Decision Scientist at Google
"Foundational work about the reality of building machine learning models in production."
—Karolis Urbonas, Head of Machine Learning and Science at Amazon
The Hundred-Page Machine Learning BookAndriy Burkov
Everything you really need to know in Machine Learning in a hundred pages.
Ansible for DevOpsJeff Geerling
Ansible is a simple, but powerful, server and configuration management tool. Learn to use Ansible effectively, whether you manage one server—or thousands.
OpenIntro StatisticsDavid Diez, Christopher Barr, Mine Cetinkaya-Rundel, and OpenIntro
A complete foundation for Statistics, also serving as a foundation for Data Science.
Leanpub revenue supports OpenIntro (US-based nonprofit) so we can provide free desk copies to teachers interested in using OpenIntro Statistics in the classroom and expand the project to support free textbooks in other subjects.
More resources: openintro.org.
Cloud StrategyGregor Hohpe
While most enterprises are moving to the cloud these days, many initiatives are driven by wishes or promises rather than a sound strategy. Harvested from half a decade of cloud migrations, this book shares frameworks, strategies, and anecdotes for a structured and decision-centric path to cloud success.
Sockets and PipesType Classes
Sockets and Pipes is not an introduction to Haskell; it is an introduction to writing software in Haskell. Using a handful of everyday Haskell libraries, this book walks through reading the HTTP specification and implementing it to create a web server.
C++ Best PracticesJason Turner
Level up your C++, get the tools working for you, eliminate common problems, and move on to more exciting things!
Practical FP in Scala: A hands-on approachGabriel Volpe
A practical book aimed for those familiar with functional programming in Scala who are yet not confident about architecting an application from scratch.
Together, we will develop a purely functional application using the best libraries in the Cats ecosystem, while learning about design patterns and best practices.
The Node.js Bundle
3 BooksThis bundle combines three bestselling Leanpub Node.js books into a package that gives you everything you need to get started with developing Node.js applications at an unbeatable price.
The Tester's Library
8 BooksThe Tester's Library consists of eight five-star books that every software tester should read and re-read. As bound books, this collection would cost over $200. Even as e-books, their price would exceed $80, but in this bundle, their cost is only $49.99. Here are the books, and why they should be in your library: Perfect Software and Other...
11 BooksIn this bundle, you will find 10 different agile books. They are about different aspects of being agile. - finding a job - doing coding dojo's - Retrospectives - Personal kanban - a non-typical coaching book and even a book that gives you an insight in the lives of some agile people.
WTFlop 6M + HU - Beta Bundle
Fifty Quick Ideas
3 BooksGet all three books for the price of two! Fifty Quick Ideas books are full of practical, real-world techniques that you can use to improve teamwork, build better products and build them in a better way.
Growing Agile: Coach's Guide Series
4 BooksThis bundle provides a collection of training and workshop plans for a variety of agile topics. The series is aimed at agile coaches, trainers and ScrumMasters who often find themselves needing to help teams understand agile concepts. Each book in the series provides the plans, slides, handouts and activity instructions to run a number of...
Marionette.js A to Z
Complete Scala Bundle
3 BooksScala is a general-purpose programming language and it's getting extremely popular these days. Some say that learning Scala could be a challenging task. My experience, however, suggests that this is actually a myth that has very little to do with reality. With the right approach, learning Scala can be easy, fun and rewarding.The first book from...
Build A Better Backbone App
3 BooksThe best way to learn new development skills is through experience, but that takes time you don't have.Get the best of both worlds with this bundle: you'll learn how to produce modern web applications by learning from experienced developers like Derick Bailey and David Sulc. BackboneJS is one of the favorite tools on the web today, but it...