Microsoft SQL Server 2017 on Linux 
by Benjamin Nevarez
This comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear coverage of both Linux and SQL Server and complete explanations of the lat...
Price: $29.93 | Publisher: McGraw-Hill | Release: 2018
by Alex Reprintsev
Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be able to take advantage of Oracle's power in implementing business logic, thereby maximizing return from your company's investment in Oracle Database products.Important features and aspects of SQL covered in this book include the model clause, row pattern matching, analytic and agg...
Price: $28.40 | Publisher: Apress | Release: 2018
Beginning Backup and Restore for SQL Server
by Bradley Beard
Be guided through the techniques to back up and restore databases and files in SQL Server. Multiple techniques are presented for ensuring the integrity and consistency of database backups, as well as the reliability and manageability of restoring from backups. In today's data-driven world, the most important asset that a company has is its data. Data recovery strategies can be wide ranging; from the pr...
Price: $26.76 | Publisher: Apress | Release: 2018
by Philip Seamark
Attention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of the DAX language to solve common data modeling challenges.Beginning DAX with Power BI teaches key concepts such as mapping techniques from SQL to DAX, filtering, grouping, joining, pivoting, and using temporary tables, all aimed at the SQL professional. Joi...
Price: $23.70 | Publisher: Apress | Release: 2018
by Hien Luu
Develop applications for the big data landscape with Spark and Hadoop. This book also explains the role of Spark in developing scalable machine learning and analytics applications with Cloud technologies. Beginning Apache Spark 2 gives you an introduction to Apache Spark and shows you how to work with it.Along the way, you'll discover resilient distributed datasets (RDDs); use Spark SQL for structured ...
Price: $25.33 | Publisher: Apress | Release: 2018
MySQL Connector/Python Revealed
by Jesper Wisborg Krogh
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 query execution, then through more advanced topics, error handing, and troubleshooting. The...
Price: $24.27 | Publisher: Apress | Release: 2018
SQL Server 2017 Query Performance Tuning
by Grant Fritchey
Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.This book covers the latest in performance optimization features and techniques and is ...
Price: $53.39 | Publisher: Apress | Release: 2018
SQL Server Advanced Data Types
by Peter A. Carter
Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for operations and data transformations that have previously required third-party software and all the associated licensing and development costs. Benefit through a better understanding of what can be done inside ...
Price: $28.60 | Publisher: Apress | Release: 2018
by Bob Ward
Get SQL Server up and running on the Linux operating system and containers. No database professional managing or developing SQL Server on Linux will want to be without this deep and authoritative guide by one of the most respected experts on SQL Server in the industry. Get an inside look at how SQL Server for Linux works through the eyes of an engineer on the team that made it possible.Microsoft SQL Server ...
Price: $30.90 | Publisher: Apress | Release: 2018
Securing SQL Server, 2nd Edition
by Peter A. Carter
Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy for your database enterprise. This new edition covers threat analysis, common attacks and countermeasures, and provides an introduction to compliance that is useful for meeting regulatory requirements such as the GDPR. The multi-layered approach in this book helps ensure that a single breach does not lead...
Price: $29.47 | Publisher: Apress | Release: 2018