This book is a tutorial on writing effective queries with the latest SQL standards and database applications. It shows how to create reliable queries for current SQL-based databases, from simple data selection and filtering to joining multiple tables and modifying sets of data. In this new edition author John L. Viescas has updated this hands-on classic with more advanced techniques. In two brand-new chapters, he shows how to perform complex calculations on groups for sophisticated reporting, and how to partition data into windows for more flexible aggregation.
<ASIN:0134858336>
Author: John L. Viescas Publisher: Addison Wesley Date: Apr 2018 Pages: 960 ISBN: 978-0134858333 Print: 0134858336 Kindle: B079G27STM Audience: Developers working with data Level: intermediate Category: Database
- Getting started: understanding what relational databases are, and ensuring that your database structures are sound
- SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE
- Summarizing and grouping data with GROUP BY and HAVING clauses
- Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries
- Modifying data sets with UPDATE, INSERT, and DELETE statements
- Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more
- NEW! Using advanced GROUP BY keywords to create subtotals, roll-ups, and more
- NEW! Applying window functions to answer more sophisticated questions, and gain deeper insight into your data
Click graphic for more information
Related Reviews
For more Book Watch just click.
Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.
To have new titles included in Book Watch contact BookWatch@i-programmer.info
Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.
Query Store for SQL Server 2019 (Apress)
Author: Tracy Boggiano & Grant Fritchey Publisher: Apress Pages: 234 ISBN: 978-1484250037 Print: 1484250036 Kindle: B07YNL3X4X Audience: SQL Server DBAs and Devs Rating: 4 Reviewer: Ian Stirk
This book aims to use Query Store to improve your SQL Server queries, how does it fare?
|
Functional Design (Addison-Wesley)
Author: Robert C. Martin Publisher: Addison-Wesley Date: September 2023 Pages: 384 ISBN: 978-0138176396 Print: 0138176396 Kindle: B0CGHQKGYG Audience: General Rating: 4.5 Reviewer: Kay Ewbank
This book sets out to explain the principles, patterns and practices of functional design, and why functional prog [ ... ]
| More Reviews |
|