Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
MariaDB and MySQL Common Table Expressions and Window Functions Revealed

Buy

Walk away from old-fashioned and cumbersome query approaches and answer your business intelligence questions through simple and powerful queries built on common table expressions (CTEs) and window functions. These new features in MariaDB and MySQL help you to write queries without having to wade through a quagmire of brittle self-joins and other crazy techniques from the past. Your queries will generate correct results, be more readable and less brittle in the face of unexpected data, and you’ll be able to adapt them quickly in the face of changing business requirements.

MariaDB and MySQL Common Table Expressions and Window Functions Revealed introduces and explains CTEs and window functions, newly available in MariaDB 10.2 and MySQL 8.0, and helps you understand why and how every MariaDB and MySQL database programmer should learn and apply these features in their daily work. CTEs and especially window functions enable easy solutions to many query challenges that in prior releases have been difficult and sometimes impossible to surmount. Mastering these features opens the door to query solutions that are more robust, execute faster, and are easier to maintain over time than prior solutions using older techniques. The book:
  • Takes you step-by-step through the workings of common table expressions and window functions
  • Provides easy-to-follow examples of the new syntax
  • Helps you answer business questions faster and easier than ever

What You'll Learn

  • Answer business questions using simple queries that don’t break in the face of unexpected data
  • Avoid writing queries that are a difficult-to-maintain quagmire of self-joins and nested subqueries
  • Recognize situations that call for window functions, and learn when to use these features
  • Reduce the need for performance-robbing self-joins
  • Simplify and speed the execution of analytical queries
  • Create queries that finish in seconds instead of hours
Who This Book Is For


Database administrators and application developers who want to quickly get up to speed on important features in MariaDB and MySQL for writing business intelligence queries. Any developer writing SQL against MariaDB and MySQL databases will benefit tremendously from the knowledge and techniques this book provides. 
(HTML tags aren't allowed.)

Oracle PL/SQL for DBAs
Oracle PL/SQL for DBAs

PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between...

OCP: Oracle 10g New Features for Administrators Study Guide : Exam 1Z0-040 (Certification Study Guide)
OCP: Oracle 10g New Features for Administrators Study Guide : Exam 1Z0-040 (Certification Study Guide)

Here's the book you need to prepare for Oracle's 10g upgrade exam, Oracle Database 10g: New Features for Administrators (1Z0-040). This Study Guide was developed to meet the exacting requirements of...

The Oracle Hacker's Handbook: Hacking and Defending Oracle
The Oracle Hacker's Handbook: Hacking and Defending Oracle

Knowledge is power, and the power can be yours

While Oracle continues to improve the security features of its product, it still has a long way to go. David Litchfield has devoted years to relentlessly searching out the flaws in this ubiquitous database system and creating defenses against them. Now he offers you...


Mathematical Aspects Of Quantum Computing 2007 (Kinki University Series on Quantum Computing)
Mathematical Aspects Of Quantum Computing 2007 (Kinki University Series on Quantum Computing)
This volume contains lecture notes and poster contributions presented at the summer school “Mathematical Aspects of Quantum Computing”, held from 27 to 29 August, 2007 at Kinki University in Osaka, Japan. The aims of this summer school were to exchange and share ideas among researchers working in various fields of quantum computing...
MySQL High Availability: Tools for Building Robust Data Centers
MySQL High Availability: Tools for Building Robust Data Centers

Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. MySQL has several features that can help you protect your system from outages, whether it's running on hardware, virtual machines, or in the cloud. MySQL High Availability explains how to...

Expert Oracle Application Express
Expert Oracle Application Express

Expert Oracle Application Express brings you groundbreaking insights into developing with Oracle’s enterprise-level, rapid-development tool from some of the best practitioners in the field today. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database....

©2021 LearnIT (support@pdfchm.net) - Privacy Policy