BookFronter
Getting Started With SQL by Thomas Nield

Getting Started With SQL

A Hands-on Approach for Beginners

Thomas Nield

O'Reilly Media · Print & ebook · March 29, 2016

Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully.

Database AdministrationSQL & DatabasesData Modeling
Buy on Amazon

We earn from qualifying purchases.

Who it’s for
A hands-on introduction connects SQL fundamentals with the everyday work of shaping business data.
Themes
SQL querying and data transformation, Relational database design
Genres
SQL & Databases, Database Administration, Data Modeling

Nearest books

Matched by what the books are about, then ordered by what their readers also loved. Most of these share its genres: SQL & Databases and Database Administration.

  1. SQL for DummiesAllen G. Taylor74% matchAlso shares Data Modeling
  2. Practical SQL, 2nd EditionAnthony DeBarros76% match
  3. Introduction to Machine Learning With PythonAndreas C. Müller, Sarah Guido50% match
  4. SQL in 24 Hours, Sams Teach YourselfRyan Stephens77% matchAlso shares Data Modeling
  5. Learn SQL in a Month of LunchesJeff Iannucci74% match
  6. SQL for Data AnalysisCathy Tanimura72% match
  7. MySQL Crash CourseRick Silva70% match
  8. SQL All-in-one for DummiesAllen G. Taylor, Richard Blum69% match

Start with three books, and this one can be the first.

Members get a new edition every morning: a route out from their books to essays, research and talks, with the reason for each.

Start with this book

About this book

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.

Continue reading

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

SQL, Made Practical

A hands-on introduction connects SQL fundamentals with the everyday work of shaping business data.

Come here for

  • Practice querying and transforming data with core SQL statements
  • Explore SQLite without setting up a database server

Expect

  • Exercises to try at home
  • A grounding in joins, database design, and managing records

Where it sits

SQL & Databases97%
Database Administration55%
Data Modeling36%

Percentages are BookFrontier’s reading of the book.

Publisher categories

  • Data Science
  • Database Administration
  • Data Mining
  • Programming Basics
Show all 5 publisher categories
  • SQL & Databases
Authors
Thomas Nield
Publisher
O'Reilly Media
Published
March 29, 2016
Format
Print & ebook
Theme
SQL querying and data transformation · Relational database design
Reading lane
Data Science