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.)

Game Feel: A Game Designer's Guide to Virtual Sensation (Morgan Kaufmann Game Design Books)
Game Feel: A Game Designer's Guide to Virtual Sensation (Morgan Kaufmann Game Design Books)
"Feel" is the essence of human-computer interaction. It is the single most important (yet often overlooked) element in games that makes the game art form unique. No other traditional art form like film, literature, music encompasses interactivity, as games do. This book bring "feel" to the forefront and gives it a proper...
Stem Cell Biology and Regenerative Medicine in Ophthalmology
Stem Cell Biology and Regenerative Medicine in Ophthalmology
In the last few decades, stem cell research has developed groundbreaking technologies to both study and treat diseases. This research has proven fruitful for the field of ophthalmology, especially in recent years. With its relative immune privilege, the eye has proven an ideal testing ground for stem cell therapies.

...
Site Investigation using Resistivity Imaging
Site Investigation using Resistivity Imaging

Subsurface investigation is the most important phase of any civil engineering construction or development activities. The geologic conditions can be extremely complex, variable, and subject to change with time; soil test borings and in-situ tests are employed to obtain subsoil information. Resistivity Imaging (RI) is a...


Digital Cultural Heritage
Digital Cultural Heritage
This book provides an overview of various application spheres and supports further innovations needed in information management and in the processes of knowledge generation. The professions, organizations and scientific associations involved are unusually challenged by the complexity of the data situation.

...
SystemC: From the Ground Up
SystemC: From the Ground Up

SystemC provides a robust set of extensions to C++ that enables rapid development of complex hardware/software systems. This book focuses on the practical uses of the language for modeling real systems. The wealth of examples and downloadable code methodically guide the reader through the finer points of the SystemC language.

This work...

Oracle Database 12c Backup and Recovery Survival Guide
Oracle Database 12c Backup and Recovery Survival Guide

A comprehensive guide for every DBA to learn recovery and backup solutions

Overview

  • A practical reference to all Oracle backup and recovery options available, making it essential to any DBA in the world
  • A valuable guide for readers on the most frequent backup and recovery scenarios they can...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy