Getting Started with SQL

· "O'Reilly Media, Inc."
4.0
2 reviews
Ebook
134
Pages
Eligible
Ratings and reviews aren’t verified  Learn More

About this ebook

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

Ratings and reviews

4.0
2 reviews

About the author

Thomas Nield (author of Getting Started with SQL) is a business consultant for Southwest Airlines in Schedule Initiatives. Early in his career, he became fascinated with technology and its role in business analytics. After becoming proficient in Java, Kotlin, Python, SQL, and reactive programming, he became an open-source contributor as well as an author/trainer for O’Reilly Media. He is passionate about sharing what he learns and enabling others with new skill sets. He enjoys making technical content relatable and relevant to those unfamiliar with or intimidated by it.Currently, Thomas is interested in data science, reactive programming, and the Kotlin language. You may find him speaking on these three subjects and how they can interconnect.

Rate this ebook

Tell us what you think.

Reading information

Smartphones and tablets
Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.
Laptops and computers
You can listen to audiobooks purchased on Google Play using your computer's web browser.
eReaders and other devices
To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Center instructions to transfer the files to supported eReaders.