Book description
Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you’re a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases.
Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you’ll also discover how to efficiently design and manage databases to meet your needs.
You’ll also learn how to:
- Explore relational databases, including lightweight and centralized models
- Use SQLite and SQLiteStudio to create lightweight databases in minutes
- Query and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BY
- Join tables to get a more complete view of your business data
- Build your own tables and centralized databases by using normalized design principles
- Manage data by learning how to INSERT, DELETE, and UPDATE records
Publisher resources
Table of contents
- Foreword
- Preface
- 1. Why Learn SQL?
- 2. Databases
- 3. SQLite
- 4. SELECT
- 5. WHERE
- 6. GROUP BY and ORDER BY
- 7. CASE Statements
- 8. JOIN
- 9. Database Design
- 10. Managing Data
- 11. Going Forward
- A. Operators and Functions
- B. Supplementary Topics
- Index
Product information
- Title: Getting Started with SQL
- Author(s):
- Release date: February 2016
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781491938614
You might also like
book
SQL for Data Scientists
Jump-start your career as a data scientist—l earn to develop datasets for exploration, analysis, and machine …
book
SQL For Dummies, 9th Edition
Get ready to make SQL easy! Updated for the latest version of SQL, the new edition …
book
Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow, 3rd Edition
Through a recent series of breakthroughs, deep learning has boosted the entire field of machine learning. …
book
Head First SQL
Is your data dragging you down? Are your tables all tangled up? Well we've got the …