SQL Queries for Mere Mortals, 4th Ed (Addison Wesley)
SQL Queries for Mere Mortals, 4th Ed (Addison Wesley)
Wednesday, 25 April 2018

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

SQL Queries For Mere Mortals, 3e

 

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.

 

Banner
 


C# 7 and .NET Core: Modern Cross-Platform Development 2e

Author: Mark J Price
Publisher: Packt Publishing
Pages:594
ISBN: 978-1787129559
Print:1787129551
Kindle:B01N8UG78Q
Audience: Intermediate C# programmers
Rating: 3
Reviewer:Mike James

C# 8 is already being previewed and .NET Core 2 is out. Now is a good time to learn C#.



C Programming Absolute Beginner's Guide (3e)

Authors: Greg Perry & Dean Miller
Publisher: Que
Pages: 352
ISBN: 978-0789751980
Print: 0789751984
Kindle: B00EANJ09U
Audience: Complete beginners
Rating: 4.5
Reviewer: Mike James

C a language for the absolute beginner! Can a book that uses C take you on the journey to become a programmer?


More Reviews

 
 

   
Banner
RSS feed of all content
I Programmer - full contents
Copyright © 2018 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.