-
Author Rajsekhar Bhamidipati , Abhinav Khandelwal
Data management and analytics simplified with TeradataAbout This BookTake your understanding of Teradata to the next level and build efficient data warehousing applications for your organizationCovers recipes on data handling, warehousing, advanced querying and the....
Release Date 2018/02 -
SQL Server 2017 Machine Learning Services with R
Author Julie Koesmarno , Tomaz Kastrun
Develop and run efficient R scripts and predictive models for SQL Server 2017About This BookLearn how you can combine the power of R and SQL Server 2017 to build efficient, cost-effective data science solutionsLeverage the capabilities of R Services to perform adva....
Release Date 2018/02 -
Author Karthik Appigatla
Design and administer enterprise-grade MySQL 8 solutionsAbout This BookStore, retrieve, and manipulate your data using the latest MySQL 8 featuresPractical recipes on effective administration in MySQL, with a focus on security, performance tuning, troubleshooting, ....
Release Date 2018/01 -
SQL Server 2017 Administrator's Guide
Author Vladimír Mužný , Marek Chmel
Implement and administer successful database solution with SQL Server 2017About This BookMaster the required skills to successfully set up, administer, and maintain your SQL Server 2017 database solutionDesign and configure, manage, and secure a rock-solid SQL serv....
Release Date 2017/12 -
Learning PostgreSQL 10 - Second Edition
Author Andrey Volkov , Salahaldin Juba
Leverage the power of PostgreSQL 10 to build powerful database and data warehousing applications.About This BookBe introduced to the concept of relational databases and PostgreSQL, one of the fastest growing open source databases in the worldLearn client-side and s....
Release Date 2017/12 -
Db2 Skeleton Cloning: Protecting Your Production Environment
Author Tim Willging , Paul Bartak
IBM Db2® for z/OS® is well known as the gold-standard information steward. Deep synergy with the z/OS operating system and System Z platform provides support for the highest transaction volumes with the ultimate levels of availability. Just like any high-performanc....
Release Date 2017/11 -
Author Mikiya Okuno , Jesper Wisborg Krogh
Create and run a real-time, highly-available, and high-redundancy version of the world's most popular open-source database, MySQL. You will understand the advantages and disadvantages of the MySQL NDB Cluster solution, and when MySQL NDB Cluster is the right choic....
Release Date 2017/11 -
MariaDB and MySQL Common Table Expressions and Window Functions Revealed
Author Daniel Bartholomew
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 ....
Release Date 2017/11 -
PostgreSQL: Up and Running, 3rd Edition
Author Leo S. Hsu , Regina O. Obe
Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you’ll also discover that PostgeSQL is more th....
Release Date 2017/11 -
Adjustment Computations, 6th Edition
Author Charles D. Ghilani
The definitive guide to bringing accuracy to measurement, updated and supplementedAdjustment Computations is the classic textbook for spatial information analysis and adjustment computations, providing clear, easy-to-understand instruction backed by real-world prac....
Release Date 2017/10 -
The Biml Book: Business Intelligence and Data Warehouse Automation
Author Cathrine Wilhelmsen , Benjamin Weissman , Raymond Sondak , Reeves Smith , Simon Peck
Learn Business Intelligence Markup Language (Biml) for automating much of the repetitive, manual labor involved in data integration. We teach you how to build frameworks and use advanced Biml features to get more out of SQL Server Integration Services (SSIS), Trans....
Release Date 2017/10 -
SQL Server 2016 High Availability Unleashed (includes Content Update Program)
Author Raju Shreewastava , Paul Bertucc
Book + Content Update ProgramSQL Server 2016 High Availability Unleashed provides start-to-finish coverage of SQL Server’s powerful high availability (HA) solutions for your traditional on-premise databases, cloud-based databases (Azure or AWS), hybrid databases (o....
Release Date 2017/07 -
IBM Db2: Investigating Automatic Storage Table Spaces and Data Skew
Author Zachary Hoggard , George Wangelien
The scope of this IBM® Redpaper™ publication is to provide a high-level overview of automatic storage table spaces, table space maps, table space extent maps, and physically unbalanced data across automatic storage table space containers (that is, data skew). The o....
Release Date 2017/07 -
Building Custom Tasks for SQL Server Integration Services
Author Andy Leonard
Learn to build custom SSIS tasks using Visual Studio Community Edition and Visual Basic. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you’ve already spent on licensing SQL Server. If you a....
Release Date 2017/07 -
IBM DB2 Web Query for i: The Nuts and Bolts
Author Kevin Trisko , Lin Su , Kathryn Steinbrink , Simona Pacchiarini , Doug Mack , Mike Ca
AbstractBusiness Intelligence (BI) is a broad term that relates to applications that analyze data to understand and act on the key metrics that drive profitability in an enterprise. Key to analyzing that data is providing fast, easy access to it while delivering it....
Release Date 2017/05 -
Author Hans-Jurgen Schonig
Master the capabilities of PostgreSQL 9.6 to efficiently manage and maintain your databaseAbout This BookYour one-stop guide to mastering the advanced concepts in PostgreSQL with easeMaster query optimization, replication, and high availability with PostgreSQLExten....
Release Date 2017/05 -
Author Tomasz Nycz , Michal Mackiewicz , Dominik Mikiewicz
Write efficient GIS applications using PostGIS - from data creation to data consumptionAbout This BookLearn how you can use PostGIS for spatial data analysis and manipulationOptimize your queries and build custom functionalities for your GIS applicationA comprehens....
Release Date 2017/05 -
Tabular Modeling in Microsoft SQL Server Analysis Services, Second Edition
Author Alberto Ferrari , Marco Russo
Build agile and responsive business intelligence solutionsCreate a semantic model and analyze data using the tabular model in SQL Server 2016 Analysis Services to create corporate-level business intelligence (BI) solutions. Led by two BI experts, you will learn how....
Release Date 2017/04 -
Exam Ref 70-761 Querying Data with Transact-SQL, First Edition
Author Itzik Ben-Gan
Prepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critic....
Release Date 2017/03 -
PostgreSQL High Performance Cookbook
Author Dinesh Kumar , Chitij Chauhan
Get to know effective ways to improve PostgreSQL’s performance and master query optimization, and database monitoring.About This BookPerform essential database tasks such as benchmarking the database and optimizing the server’s memory usageLearn ways to improve que....
Release Date 2017/03 -
SQL Server 2016 Developer's Guide
Author William Durkin , Miloš Radivojević , Dejan Sarka
Get the most out of the rich development capabilities of SQL Server 2016 to build efficient database applications for your organizationAbout This BookUtilize the new enhancements in Transact-SQL and security features in SQL Server 2016 to build efficient database a....
Release Date 2017/03 -
Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports
Author Christopher Finlan , Riccardo Muti , Paul Turley
Optimize reporting and BI with Microsoft SQL Server 2016Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a cle....
Release Date 2017/02 -
PostgreSQL High Availability Cookbook - Second Edition
Author Shaun M. Thomas
Master over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQLAbout This BookCreate a PostgreSQL cluster that stays online even when disaster strikesAvoid costly downtime and data loss that can ruin your businessU....
Release Date 2017/02 -
IBM PowerVC Version 1.3.2 Introduction and Configuration
Author Martin Parrella , Javier Bazan Lazcano
IBM® Power Virtualization Center (IBM® PowerVC™) is an advanced, enterprise virtualization management offering for IBM Power Systems™. This IBM Redbooks® publication introduces IBM PowerVC and helps you understand its functions, planning, installation, and setup.IB....
Release Date 2017/01 -
Tabular Modeling with SQL Server 2016 Analysis Services Cookbook
Author Derek Wilson
Expert tabular modeling techniques for building and deploying cutting-edge business analytical reporting solutionsAbout This BookBuild and deploy Tabular Model projects from relational data sourcesLeverage DAX and create high-performing calculated fields and measur....
Release Date 2017/01 -
Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes, Second Edition
Author Ben Forta
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book’s 30 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of Microsoft SQL ....
Release Date 2016/12 -
IBM DB2 12 for z/OS Technical Overview
Author Acacio Ricardo Gomes Pessoa , Tammie Dang , Meg Bernal
IBM® DB2® 12 for z/OS® delivers key innovations that increase availability, reliability, scalability, and security for your business-critical information. In addition, DB2 12 for z/OS offers performance and functional improvements for both transactional and analyti....
Release Date 2016/12 -
Author Teddy Sudewo , Teresa Missawa , Octavio Ferreira , Bill White
For more than 50 years, IBM® mainframes have supported an extraordinary portion of the world’s computing work, providing centralized corporate databases and mission-critical enterprise-wide applications. IBM z™ Systems, the latest generation of the IBM distinguishe....
Release Date 2016/11 -
Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition, 4th Edition
Author Brian Larson
Distribute Actionable, Timely BI with Microsoft® SQL Server® 2016 and Power BIDrive better, faster, more informed decision making across your organization using the expert tips and best practices featured in this hands-on guide. Delivering Business Intelligence wit....
Release Date 2016/11 -
Pro SQL Server Internals, Second Edition
Author Dmitri Korotkevitch
Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work "under the hood," and how they communicate with each other. The detailed knowledge helps in implementing and maintaining high-throughput databas....
Release Date 2016/11