SQL is the language of data, and therefore the intermediary language for those who straddle the line between technology and business. Every business application needs a database and SQL is the key to working with these databases. Nick Harrison’s SQL Queries Succinctly will show you how to craft queries in SQL, from basic CRUD statements and slicing and dicing the data, to applying filters and using aggregate functions to summarize the data. You will look at solving common problems, navigating hierarchical data, and exploring the data dictionary.
Free Databases Books
An Apache open source project, Hadoop stores huge amounts of data in safe, reliable storage and runs complex queries over data in an efficient way. It is at the core of a whole host of the most popular Big Data tools. Mastering Hadoop ensures you get the best out of all these tools and better insight from your data. Hadoop Succinctly explains how Hadoop works, what goes on in the cluster, demonstrates how to move data in and out of Hadoop, and how to query it efficiently
This free ebook introduces Microsoft Power BI basics through a practical, scenario-based guided tour of the tool, showing you how to build analytical solutions using Power BI. Read the ebook to get an overview of Power BI, or dig deeper and follow along on your PC using the book’s examples. Introducing Microsoft Power BI enables you to evaluate when and how to use Power BI. Get inspired to improve business processes in your company by leveraging the available analytical and collaborative features of this environment.
Use HBase to improve your control of big data. In HBase Succinctly, author Elton Stoneman will detail what makes HBase different from other databases and teach you about its signature features. With this knowledge, you will be able to jump into big data management.
In this Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud- Preview 2 ebook, we introduce three new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TempDB configuration, query store, and Stretch Database; review several improvements to Reporting Services; and also describe AlwaysOn Availability Groups, tabular enhancements, and R integration.
Database Lifecycle Management: Achieving Continuous Delivery for Databases describes how to apply the business and technical approaches of Database Lifecycle Management (DLM) in order to make database change management processes more visible, predictable and measurable. It is being produced as a lean book, meaning that it’s being written and revised live, with continuous updates on the road to a finished and finalised version.
The nature of business today demands that companies have an online presence. In SQL on Azure Succinctly, author Parikshit Savjani shows how companies can use SQL Server on Azure to innovate their online properties without investing heavily in infrastructure. Savjani discusses the reasons behind using SQL on Azure and reviews the scenarios, considerations, and configuration design optimizations that make it a viable option for enterprise.
With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview Edition introduces you to several of these changes that you can experience for yourself in Community Technology Preview 3.2.
Mastering big data requires an aptitude at every step of information processing. Post-processing, one of the most important steps, is where you find Apache Spark frequently employed. Spark Succinctly, by Marko Švaljek, addresses Spark’s use in the ultimate step in handling big data.
Apache Cassandra is an open-source distributed database system noted for its consistency, its ability to run on commodity hardware, and its easy deployment to cloud infrastructure. With Cassandra Succinctly by Marko Švaljek, you will learn the architecture behind Cassandra that makes it a reliable system, including how hashes are used to identify where data is stored, how choosing the right replication factor can enhance or hinder performance, and how the system handles updating and deleting data.