Learning SQL: Generate, Manipulate, and Retrieve Data, Edition 3

Name: Learning SQL: Generate, Manipulate, and Retrieve Data, Edition 3
Rating: 3.25 (4 reviews)

Alan Beaulieu

Mar 2020 · "O'Reilly Media, Inc."

3.2

4 reviews

Ebook

380

Pages

Eligible

Ratings and reviews aren’t verified Learn More

Switch to the audiobook

About this ebook

As data floods into your company, you need to put it to work right away—and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You’ll find new chapters on SQL and big data, analytic functions, and working with very large databases.

Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous illustrations and annotated examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you’ll quickly discover how to put the power and flexibility of this language to work.

Move quickly through SQL basics and several advanced features
Use SQL data statements to generate, manipulate, and retrieve data
Create database objects, such as tables, indexes, and constraints with SQL schema statements
Learn how datasets interact with queries; understand the importance of subqueries
Convert and manipulate data with SQL’s built-in functions and use conditional logic in data statements

Ratings and reviews

3.2

4 reviews

Kathe Friedrich

October 15, 2024

This book is a must-have for anyone looking to learn SQL, the powerful language used to interact with databases. The authors do a fantastic job of breaking down complex concepts into easy-to-understand terms, making it accessible to beginners and experienced programmers alike. The book is packed with practical examples and exercises that will help you solidify your understanding of SQL. Whether you're a data analyst, data scientist, or software developer, Learning SQL is a valuable resource that

A Google user

October 15, 2024

This book is a must-have for anyone looking to learn SQL, the powerful language used to interact with databases. The authors do a fantastic job of breaking down complex concepts into understandable terms, making it accessible to both beginners and experienced programmers. The book is packed with practical examples and exercises that will help you solidify your understanding of SQL.

David O'Donovan (Davey D)

December 7, 2024

It's possibly a great book but already in chapter 1 there is a false direction that really bothers me. It states a customers first and last name should be used to find the customers id and then use this if to find the account number. Even after describing the limitation of the customer table having repeat first and last names it still gives this false guidance. The account Id is what should be used as the starting point. The first and last name can be taken from the customer table but to be honest they should be put the name with the account id and in this example there is no advantage to a customer table. Disappointing.

About the author

Alan Beaulieu has been designing, building, and implementing custom database applications for over 25 years. He is the author of Learning SQL and Mastering Oracle SQL (O’Reilly), and has written an online course on SQL for the University of California. He currently runs his own consulting company that specializes in database design and development in the fields of Financial Services and Telecommunications. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters.

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.

Report illegal content