A Primer on SQL (Third Edition)

A Primer on SQL (Third Edition)

By Rahul Batra
Book Description

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.

Read Online and purchase ebooks at Leanpub

Table of Contents
  • Table of Contents
  • Preface
  • About the author
  • Acknowledgements
  • 1. An Introduction to SQL
  • 2. Getting your database ready
  • 3. Constraints
  • 4. Operations on Tables
  • 5. Writing Basic Queries
  • 6. Manipulating Data
  • 7. Organizing your data
  • 8. Doing more with queries
  • 9. Calculated Fields
  • 10. Aggregation and Grouping
  • 11. Understanding Joins
  • 12. Subqueries
  • Further Reading
  • Appendix: Major Database Management Systems
  • Glossary
    No review for this book yet, be the first to review.
      No comment for this book yet, be the first to comment
      You May Also Like
      Also Available On
      App store smallGoogle play small
      Curated Lists
      • Pattern Recognition and Machine Learning (Information Science and Statistics)
        by Christopher M. Bishop
        Data mining
        by I. H. Witten
        The Elements of Statistical Learning: Data Mining, Inference, and Prediction
        by Various
        See more...
      • CK-12 Chemistry
        by Various
        Concept Development Studies in Chemistry
        by John Hutchinson
        An Introduction to Chemistry - Atoms First
        by Mark Bishop
        See more...
      • Microsoft Word - How to Use Advanced Algebra II.doc
        by Jonathan Emmons
        Advanced Algebra II: Activities and Homework
        by Kenny Felder
        See more...
      • The Sun Who Lost His Way
        Tania is a Detective
        by Kanika G
        See more...
      • Java 3D Programming
        by Daniel Selman
        The Java EE 6 Tutorial
        by Oracle Corporation
        See more...