Oracle SQL Revealed

Oracle SQL Revealed

Tagline: Learn about analytic functions, the model clause, row pattern matching, and other powerful features in Oracle SQL Table of Contents Part I: Features and Theory Chapter 1: Joins Chapter 2: Query Transformations Chapter 3: Analytic Functions Chapter 4: Aggregate Functions Chapter 5: Hierarchical Queries: Connect by Chapter…

MySQL Connector/Python Revealed

MySQL Connector/Python Revealed

Move data back and forth between database and application. The must-have knowledge in this book helps programmers learn how to use the official driver, MySQL Connector/Python, by which Python programs communicate with the MySQL database. This book takes you from the initial installation of the connector through basic…

R Machine Learning By Example

R Machine Learning By Example

Data science and machine learning are some of the top buzzwords in the technical world today. From retail stores to Fortune 500 companies, everyone is working hard to making machine learning give them data-driven insights to grow their business. With powerful data manipulation features, machine learning packages, and…

SQL for IBM i

SQL for IBM i

This book aims to give IBM i technical users basic to intermediate SQL knowledge and tools they can use to get more out of the IBM i database. The book can be useful to veteran IBM i programmers, who have RPG and COBOL roots, system administrators looking to…

PostgreSQL High Availability Cookbook, Second Edition

PostgreSQL High Availability Cookbook, 2nd Edition

Key Features Create a PostgreSQL cluster that stays online even when disaster strikes Avoid costly downtime and data loss that can ruin your business Updated to include the newest features introduced in PostgreSQL 9.6 with hands-on industry-driven recipes Book Description Databases are nothing without the data they store….

Practical Enterprise Data Lake Insights

Practical Enterprise Data Lake Insights

Use this practical guide to successfully handle the challenges encountered when designing an enterprise data lake and learn industry best practices to resolve issues. When designing an enterprise data lake you often hit a roadblock when you must leave the comfort of the relational world and learn the…

Modern Data Access with Entity Framework Core

Modern Data Access with Entity Framework Core

C# developers, here’s your opportunity to learn the ins-and-outs of Entity Framework Core, Microsoft’s recently redesigned object-relational mapper. Benefit from hands-on learning that will teach you how to tackle frustrating database challenges, such as workarounds to missing features in Entity Framework Core, and learn how to optimize the…

Introducing the MySQL 8 Document Store

Introducing the MySQL 8 Document Store

Learn the new Document Store feature of MySQL 8 and build applications around a mix of the best features from SQL and NoSQL database paradigms. Don’t allow yourself to be forced into one paradigm or the other, but combine both approaches by using the Document Store. MySQL 8…