SQL

Take your first steps to become a fully qualified data analyst by learning how to explore large relational datasets.

Troubleshoot query performance issues, identify anti-patterns in code, and write efficient T-SQL queries

A practical guide to administer, monitor and replicate your PostgreSQL 11 database

Leverage the power of PostgreSQL 11 to build powerful database and data warehousing applications

This detailed book teaches you high availability and disaster recovery strategies and solutions available in SQL Server and helps you build highly available SQL Server to support the application needs.

Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL

Extend PostgreSQL using PostgreSQL server programming to create, test, debug, and optimize a range of user-defined functions in your favorite programming language

Find, explore, and extract big data to transform into actionable insights

Master the capabilities of PostgreSQL 11 to efficiently manage and maintain your database

Create scalable applications by taking advantage of NoSQL document databases on the cloud with .NET Core

Get unique insights from your data by combining the power of SQL Server, R and Python

Discover how you can migrate a traditional on-premise SQL server database to a cloud-based solution with Microsoft Azure. Built with database administrators in mind, this book emulates different scenarios you might come across while working with large, complex SQL database migrations and provides solutions for effectively managing the migrated databases.

Make web applications run faster by using advanced PHP, SQL and JavaScript techniques

A practical guide to administer, monitor and replicate your PostgreSQL 10 database

Leverage the power of PostgreSQL 10 to design, administer and maintain a high-performance database solution