Контакты/Проезд  Доставка и Оплата Помощь/Возврат
История
  +7(495) 980-12-10
  пн-пт: 10-18 сб,вс: 11-18
  shop@logobook.ru
   
    Поиск книг                    Поиск по списку ISBN Расширенный поиск    
Найти
  Зарубежные издательства Российские издательства  
Авторы | Каталог книг | Издательства | Новинки | Учебная литература | Акции | Хиты | |
 

MariaDB and MySQL Common Table Expressions and Window Functions Revealed, Daniel Bartholomew


Варианты приобретения
Цена: 3213.00р.
Кол-во:
Наличие: Поставка под заказ.  Есть в наличии на складе поставщика.
Склад Америка: Есть  
При оформлении заказа до: 2025-07-28
Ориентировочная дата поставки: Август-начало Сентября
При условии наличия книги у поставщика.

Добавить в корзину
в Мои желания

Автор: Daniel Bartholomew
Название:  MariaDB and MySQL Common Table Expressions and Window Functions Revealed
ISBN: 9781484231197
Издательство: Springer
Классификация:


ISBN-10: 1484231198
Обложка/Формат: Paperback
Страницы: 117
Вес: 0.19 кг.
Дата издания: 03.11.2017
Язык: English
Издание: 1st ed.
Иллюстрации: 13 illustrations, color; xix, 106 p. 13 illus. in color.
Размер: 154 x 234 x 13
Читательская аудитория: Professional & vocational
Основная тема: Computer Science
Ссылка на Издательство: Link
Рейтинг:
Поставляется из: Германии
Описание: 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 youll 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 Youll Learn
  • Answer business questions using simple queries that dont 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.



High Performance MySQL

Автор: Schwartz Baron
Название: High Performance MySQL
ISBN: 1449314287 ISBN-13(EAN): 9781449314286
Издательство: Wiley
Рейтинг:
Цена: 8235.00 р.
Наличие на складе: Поставка под заказ.

Описание: High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL`s full power. Learn how to design schemas, indexes, queries, and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential.

Beginning MySQL Database Design and Optimization

Автор: Chad Russell; Jon Stephens
Название: Beginning MySQL Database Design and Optimization
ISBN: 1590593324 ISBN-13(EAN): 9781590593325
Издательство: Springer
Рейтинг:
Цена: 5449.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание:

Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically achieved using a database. If you're building or maintaining any significant application and are using MySQL, this book is for you. For open source and other types of projects, the MySQL database is a very popular choice: it's free, fast, robust, and scalable, and it runs on all of the major platforms, allowing maximum use of available hardware resources. But it's easy to disregard MySQL's speed and other advantages if your database design is inefficient. Needlessly duplicating data, using improper types for columns, overloading a single table where multiple tables should be used, failing to leverage the calculation features of MySQL, and making multiple queries instead of an efficient single query are some of the common mistakes.

Beginning MySQL Database Design and Optimization shows you how to identify, overcome, and avoid gross inefficiencies. It demonstrates how to maximize the many data manipulation features that MySQL includes. This book explains how to include tests and branches in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. You'll also learn about some features new to MySQL 4.1 and 5.0 like subqueries, stored procedures, and views, all of which will help you build even more efficient applications.

PHP and MySQL Recipes

Автор: Kromann
Название: PHP and MySQL Recipes
ISBN: 1484206061 ISBN-13(EAN): 9781484206065
Издательство: Springer
Рейтинг:
Цена: 5589.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание: This book is a source of instant solutions, including countless pieces of useful code that you can copy and paste into your own applications, giving you answers fast and saving you hours of coding time. You can also use this book as a reference to the most important aspects of the latest PHP scripting language, including the vital functions you know and love from previous versions of PHP, as well as the functions introduced in PHP 7.PHP and MySQL Recipes: A Problem-Solution Approach supplies you with complete code for all of the common coding problems you are likely to face when using PHP and MySQL together in your day-to-day web application development. This invaluable guide includes over 200 recipes and covers numerous topics. What you hold in your hands is the answer to all your PHP 7 needs. Furthermore, this book explains the PHP functionality in detail, including the vastly improved object-oriented capabilities and the new MySQL database extension. PHP and MySQL Recipes will be a useful and welcome companion throughout your career as a web developer, keeping you on the cutting edge of PHP development, ahead of the competition, and giving you all the answers you need, when you need them.What You'll LearnHow to work with arrays, dates and times, strings, files and directories, and dynamic imagingHow to write regular expressions in PHPHow to use the variables and functions found in PHPHow to do web development using PHP, including the creation of forms

Who This Book Is For
This reference is for experienced PHP and MySQL programmers and web developers who have at least some PHP and MySQL programming experience.
Expert PHP and MySQL

Автор: Marc Rochkind
Название: Expert PHP and MySQL
ISBN: 1430260076 ISBN-13(EAN): 9781430260073
Издательство: Springer
Рейтинг:
Цена: 7685.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание:

  1. Project Organization
  2. Requirements
  3. Platforms and Tools
  4. The Database
  5. Application Structure
  6. Security, Forms, and Error Handling
  7. Reports and Other Outputs
  8. Data Conversion
MySQL Workbench Data Modeling and Development

Автор: McLaughlin Michael
Название: MySQL Workbench Data Modeling and Development
ISBN: 0071791884 ISBN-13(EAN): 9780071791885
Издательство: McGraw-Hill
Рейтинг:
Цена: 8578.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание: The only Oracle Press guide to MySQL Workbench explains how to design and model MySQL databases.


ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru
   В Контакте     В Контакте Мед  Мобильная версия