Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights Paperback / softback - 2023
by Mark Simon
- New
- Paperback
A$55.19
A$19.30
Delivery to USA
Standard delivery: 14 to 21 days
More delivery options
Standard delivery: 14 to 21 days
Details
- Title Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
- Author Mark Simon
- Binding Paperback
- Condition New
- Pages 454
- Volumes 1
- Language ENG
- Publisher Apress
- Publication date 2023-09-05
- Illustrated Yes
- Features Illustrated
- Bookseller's Inventory # A9781484296844
- ISBN 9781484296844 / 1484296842
- Weight 1.8 lbs (0.82 kg)
- Dimensions 10 x 7 x 0.96 in (25.40 x 17.78 x 2.44 cm)
- Category Computers - Data Base Management
- Quantity available 1
About The Saint Bookstore Merseyside, United Kingdom
Biblio member since 2018
The Saint Bookstore specialises in hard to find titles & also offers delivery worldwide for reasonable rates.
Reader reviews for Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Write a review for this book
Important Terms and Guidelines
- Please focus on the book’s content and context. Also, add any personal comments as to how you enjoyed the book. Substantiate your likes and dislikes. You may make comparisons to other books.
- Reviews must be at least 140 characters in length.
- Please do not reveal critical plot elements.
- This is not a help line. Contact customer support if you need help.
Your review must not include:
- Obscenities, discriminatory language, or other insulting language not suitable for public domain
- Advertisements, “spam” content, or references to other products, offers or websites.
- Email addresses, URLs, phone numbers, physical addresses or other contact information.
- Overly critical comments about other reviews or reviewers
- Time-sensitive material (i.e. promotional tours, seminars, lectures, etc.)
- Availability, price, or alternative ordering/shipping information
From the publisher
From the rear cover
Learn to write SQL queries to select and analyze data, and improve your ability to manipulate data. This book will help you take your existing skills to the next level.
Author Mark Simon kicks things off with a quick review of basic SQL knowledge, followed by a demonstration of how efficient SQL databases are designed and how to extract just the right data from them. You'll then learn about each individual table's structure and how to work with the relationships between tables. As you progress through the book, you will learn more sophisticated techniques such as using common table expressions and subqueries, analyzing your data using aggregate and windowing functions, and how to save queries in the form of views and other methods. This book employs an accessible approach to work through a realistic sample, enabling you to learn concepts as they arise to improve parts of the database or to work with the data itself.
After completing this book, you will have a more thorough understanding of database structure and how to use advanced techniques to extract, manage, and analyze data.
You will:
- Gain a stronger understanding of database design principles, especially individual tables
- Understand the relationships between tables
- Utilize techniques such as views, subqueries, common table expressions, and windowing functions
