Computing & Internet Databases Books

SQL Server 101 Part 1: The SELECT Statement

This book is all about the SELECT statement, which is often tested in job interviews.

It is made up of SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY. We'll look at when you would use each, and how to remember the order of these clauses.

We'll then look at how you can retrieve SELECT statements, saving them as views and procedures, and creating a connection from SQL Server in Excel.

This book is for you if you want to focus on the SELECT statement quickly, or if you want a brief taster of SQL Server, to see if it is right for you.

There are six clauses to the SELECT statement:

1. The SELECT clause identifies the fields you want to retrieve,

2. The FROM clause tells SQL Server the source of the data,

3. The WHERE clause can narrow down the number of rows retrieved,

4. The results can then be summarised using the GROUP BY clause,

5. The HAVING clause can narrow down the summarised results, and

6. The ORDER BY clause then orders the final list.

We'll then encapsulate (save) the query as a view and as a stored procedure.

Finally, we'll import the results into Excel, both using copy and paste and as a live connection.

All of this, within 60 minutes. So why not start your SQL Server journey?

Linked Open Data -- Creating Knowledge Out of Interlinked Data: Results of the LOD2 Project (Lecture Notes in Computer Science)

Linked Open Data (LOD) is a pragmatic approach for realizing the Semantic Web vision of making the Web a global, distributed, semantics-based information system. This book presents an overview on the results of the research project "LOD2 -- Creating Knowledge out of Interlinked Data". LOD2 is a large-scale integrating project co-funded by the European Commission within the FP7 Information and Communication Technologies Work Program. Commencing in September 2010, this 4-year project comprised leading Linked Open Data research groups, companies, and service providers from across 11 European countries and South Korea. The aim of this project was to advance the state-of-the-art in research and development in four key areas relevant for Linked Data, namely 1. RDF data management; 2. the extraction, creation, and enrichment of structured RDF data; 3. the interlinking and fusion of Linked Data from different sources and 4. the authoring, exploration and visualization of Linked Data.

Amazon Relational Database Service (RDS) User Guide

NOTE - A new version of the Amazon Relational Database Service User Guide is available at https://www.amazon.com/dp/B07647QNMN

This is official Amazon Web Services (AWS) documentation for Amazon Relational Database Service (RDS). Amazon Relational Database Service (RDS) is a platform for running instances of MySQL, Oracle, and Microsoft SQL Server database engines, called DB Instances, in the cloud. This guide explains how to create and manage DB Instances by using the Query and SOAP programming interfaces, as well as a command-line interface. This documentation is offered for free here as a Kindle book, or you can read it online or in PDF format at http://aws.amazon.com/documentation/rds/.

Oracle Database on AWS (AWS Quick Start)

This Quick Start provides a reliable and automated way to install and configure Oracle Database 12c Enterprise Edition on AWS with high availability.

The Quick Start deploys Oracle Database into a Multi-AZ configuration on AWS with asynchronous data replication between Availability Zones. You can choose to deploy Oracle Database into a new or your existing AWS environment, and use Oracle Linux or Red Hat Enterprise Linux.

The Quick Start installs Oracle ASM for storage management, and Oracle Data Guard for database setup and replication. You can also include the Oracle Secure Backup (OSB) Cloud Module for backups. This documentation is offered for free here as a Kindle book, or you can read it online or in PDF format at https://aws.amazon.com/quickstart/.

Best Practices for Migrating MySQL Databases to Amazon Aurora (AWS Whitepaper)

October 2016

This whitepaper discusses some of the important factors affecting the performance of self-managed export/import operations in Amazon Relational Database Service (Amazon RDS) for MySQL and Amazon Aurora. Although many of the topics are discussed in the context of Amazon RDS, performance principles presented here also apply to the MySQL Community Edition found in self-managed MySQL installations.

This documentation is offered for free here as a Kindle book, or you can read it in PDF format at https://aws.amazon.com/whitepapers/.

Building Data Science Teams

As data science evolves to become a business necessity, the importance of assembling a strong and innovative data teams grows. In this in-depth report, data scientist DJ Patil explains the skills, perspectives, tools and processes that position data science teams for success.

Topics include: What it means to be "data driven." The unique roles of data scientists. The four essential qualities of data scientists. Patil's first-hand experience building the LinkedIn data science team.

DBA's Guide to NoSQL: Apache Cassandra

For the new or veteran DBA: whether you're skeptical or enthusiastic about new types of Databases, this book contains all you need to understand about when and how to implement NoSQl technology in your internet enterprise applications.

Version-Independent Programming: Code Development Guidelines for the Windows® Operating System

This book presents a set of guidelines by which to develop applications that will run on any version of the Windows(R) operating system. This is not a manual on computer programming, but it does address the subject where necessary. The reader is presumed to be proficient in the C programming language, as this is the clear choice for such development. Simply put, this is a manual on what to do and what to avoid, in order to achieve version-independence. As more versions are released and the time between new releases is shortened, compatibility becomes increasingly important. By following these guidelines, the resulting applications will not only be compatible, they will also be more efficient. Version-independence is a specific type of performance. Achieving performance always requires attention to detail. If you are not willing to pay attention to detail, you will never achieve performance.

Cloudera Impala

Learn about Cloudera Impala--an open source project that's opening up the Apache Hadoop software stack to a wide audience of database analysts, users, and developers. The Impala massively parallel processing (MPP) engine makes SQL queries of Hadoop data simple enough to be accessible to analysts familiar with SQL and to users of business intelligence tools--and it's fast enough to be used for interactive exploration and experimentation.

SAP HANA Essentials: 5th Edition

Updated 5th Edition. New updates for SP7 features, New Big Data & Modeling Chapters, SAP HANA Enterprise Cloud and other recent developments.

SAP(R) HANA is a multi-purpose in-memory database appliance that delivers pre-installed SAP software components optimized on industry-standard hardware. Learn how SAP(R) HANA provides organizations with better insight into business operations - in "real-time" -- by analyzing all the data available and enabling them to respond to changing business conditions, no matter how rapid. SAP(R) HANA enables organizations to instantly explore and analyze all of their transactional and analytical data in real time - from virtually any data source.

This book provides readers with either business or technical backgrounds a broad overview of the architecture, tools, capabilities and use cases for SAP(R) HANA and shows how it enables organizations to analyze their business operations using huge volumes of detailed information instantly. Each chapter focuses on a specific aspect of SAP(R) HANA and includes numerous links to additional resources and technical details. Additional chapters will be added on a regular basis, so please sign up for updates or follow us on Twitter @epistemypress

Mastering Excel: Excel Apps

This lesson only applies to Excel 2013 or Office 365!

This short lesson covers Excel applications (apps). Apps are almost like the apps you find on your smartphone. In the Excel world, an app is a small, programmed interface that interacts with Excel data to extend your spreadsheet's functionality.

Excel come with two apps built by Microsoft. You will learn how to use these apps to add dynamic charts to your worksheets. There is no programming involved with these apps. They do all the work for you.

As with all my other lessons, this one comes with two follow along workbooks. One you can use to work through the exercises and the other one has the completed exercises.

Once again, if you do not have Excel 2013 or Office 365 for Windows, you will not be able to use this lesson!

Amazon Relational Database Service: User Guide

This is the official Amazon Web Services (AWS) documentation for the Amazon Relational Database Service (Amazon RDS). Amazon RDS is a platform for running DB Instances in the cloud. You can create DB instances that run Amazon Aurora, MariaDB, Microsoft SQL Server, MySQL, Oracle, and PostgreSQL. This guide explains how to create and manage DB instances. This documentation is offered for free here as a Kindle book, or you can read the documentation online or in PDF format at http://aws.amazon.com/documentation/rds/.

SQL Server with WSFC on AWS (AWS Quick Start)

This Quick Start implements a high availability solution built with Microsoft Windows Server and SQL Server running on Amazon EC2, using the AlwaysOn Availability Groups feature of SQL Server Enterprise edition. The deployment includes Windows Server Active Directory with Windows Server Failover Clustering (WSFC) and clustered SQL Server 2012 or 2014 instances on the AWS cloud. This infrastructure provides the underpinnings for many Microsoft technology-based solutions for the enterprise, including Microsoft SharePoint and .NET Framework applications.

The Quick Start includes an AWS CloudFormation template that automates the deployment. The deployment guide provides architectural considerations and configuration steps for running WSFC clusters in the AWS cloud, and instructions for configuring and testing the WSFC cluster and SQL Server AlwaysOn Availability Group. This documentation is offered for free here as a Kindle book, or you can read it online or in PDF format at https://aws.amazon.com/quickstart/.

To install SQL Server with other Windows servers on AWS in a single deployment, see the Quick Start for Microsoft servers at https://aws.amazon.com/quickstart/architecture/microsoft-servers/.

Amazon DynamoDB Developer Guide

NOTE - A new version of the Amazon DynamoDB Developer Guide is available at https://www.amazon.com/dp/B0763ZV7JG

This is official Amazon Web Services (AWS) documentation for Amazon DynamoDB. Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. This guide explains how to create and manage databases in DynamoDB by using the AWS SDKs for Java, Microsoft .NET, and PHP, as well as the AWS Management Console, a browser-based graphical user interface for interacting with the service. This documentation is offered for free here as a Kindle book, or you can read it online or in PDF format at http://aws.amazon.com/documentation/dynamodb/.

Big Data Now: Current Perspectives from O'Reilly Radar

This collection represents the full spectrum of data-related content we've published on O'Reilly Radar over the last year. Mike Loukides kicked things off in June 2010 with "What is data science?" and from there we've pursued the various threads and themes that naturally emerged. Now, roughly a year later, we can look back over all we've covered and identify a number of core data areas:

Data issues -- The opportunities and ambiguities of the data space are evident in discussions around privacy, the implications of data-centric industries, and the debate about the phrase "data science" itself.

The application of data: products and processes - A "data product" can emerge from virtually any domain, including everything from data startups to established enterprises to media/journalism to education and research.

Data science and data tools -- The tools and technologies that drive data science are of course essential to this space, but the varied techniques being applied are also key to understanding the big data arena.

The business of data - Take a closer look at the actions connected to data -- the finding, organizing, and analyzing that provide organizations of all sizes with the information they need to compete.

Amazon Redshift Database Developer Guide

NOTE - A new version of the Amazon Redshift Database Developer Guide is available at https://www.amazon.com/dp/B07647QQXY

This is official Amazon Web Services (AWS) documentation for Amazon Redshift. Amazon Redshift is an enterprise-level, petabyte scale, fully managed data warehousing service. This guide focuses specifically on using Amazon Redshift to create and manage a data warehouse. If you work with databases as a designer, software developer, or administrator, it gives you the information you need to design, build, query, and maintain the relational databases that make up your data warehouse. This documentation is offered for free here as a Kindle book, or you can read it online or in PDF format at http://aws.amazon.com/documentation/redshift/.

Storing and processing information

This 3-hour free course discussed the main ways in which organisational data is managed, prior to decision-making activity.

The Evolution of Data Products

This report examines the important shifts in data products. Drawing from diverse examples, including iTunes, Google's self-driving car, and patient monitoring, author Mike Loukides explores the "disappearance" of data, the power of combining data, and the difference between discovery and recommendation. Looking ahead, the analysis finds the real changes in our lives will come from products and companies that reveal data results, not the data itself.

The Culture of Big Data

Technology does not exist in a vacuum. In the same way that a plant needs water and nourishment to grow, technology needs people and process to thrive and succeed. Culture (i.e., people and process) is integral and critical to the success of any new technology deployment or implementation.

Big data is not just a technology phenomenon. It has a cultural dimension. It's vitally important to remember that most people have not considered the immense difference between a world seen through the lens of a traditional relational database system and a world seen through the lens of a Hadoop Distributed File System.This paper broadly describes the cultural challenges that accompany efforts to create and sustain big data initiatives in an evolving world whose data management processes are rooted firmly in traditional data warehouse architectures.

Take Control of PDFpen 7

Learn how to create and manipulate PDFs with PDFpen 7 and PDFpen for iPad & iPhone

PDF serves as a universal document format for all manner of forms, statements, and receipts. And, whether you've moved a lot of your documents into the cloud or not, you've probably noticed that more and more "paper" is coming your way as PDF files.

But, even as PDFs unstuff our filing cabinets and shrink the piles in our physical inboxes, we need to learn new skills to edit and manage PDFs effectively. Many Mac users have turned to Smile's affordable PDFpen app to help them sign PDF forms, handle scanned documents, edit PDFs, create PDFs, and even export PDFs to other file formats. With Take Control of PDFpen 7, you'll learn how to do all these tasks and more on a Mac with PDFpen or PDFpenPro, or on the go with PDFpen for iPad & iPhone.

The book begins with a guide to purchasing options: PDFpen versus PDFpenPro, from Smile versus the Mac App Store, and the advantages of the iOS version. Next, you'll meet PDFpen with an overview of the PDF format and a tour of the interface.

Compatibility? PDFpen 7 works with OS X 10.10 Yosemite; we also have Take Control of PDFpen 6 for users of older versions of OS X.

With those preliminaries out of the way, you'll learn how to:

Add and remove pages, and combine pages from multiple files into one PDF.Mark up a PDF with highlights, comments, professional editing marks, and more.Edit a PDF by fixing typos, adding text, formatting text, and redacting confidential text. Scan a document into a PDF, and make the text editable with OCR.View and work directly with OCRed text in the OCR layer (PDFpenPro only)Add clickable links, page numbers, and images.Make a clickable table of contents (PDFpenPro only).Reduce the file size with a Quartz filter.Password-protect a PDF. And (PDFpenPro only), prevent others from printing or editing a PDF. Turn a PDF into a formatted Microsoft Word document, or (PDFpenPro only) export it in Excel or PowerPoint format. And, you'll find directions for working with forms:

Fill out forms with ease.Add a handwritten signature -- in the iOS versions, you can write with a stylus!Print just form entries on a pre-printed form.Create an interactive PDF form for both Mac and Windows (PDFpenPro only) that can collect data and send it to you via email or the Web.That's not all! The book also covers how to:

Work with PDFs in PDFpen for iPad & iPhone.Get your PDFs into and out of PDFpen in iOS via iCloud Drive, iTunes, Dropbox, and Open In.Print a PDF with its annotations appearing at the end.Store frequently used items (like a logo or signature) in the PDFpen Library.Turn a Web site into a multi-page PDF (PDFpenPro only).An appendix describes the useful AppleScripts that ship with PDFpen.

This ebook was created in collaboration with Smile, with PDFpen's developers tech editing the book.

Take Control of PDFpen 8

Juggle your PDFs easily with PDFpen 8!

These days, an ever-increasing amount of "paper" -- contracts, tax forms, bills, reports, and more -- comes into our lives as PDF files. We generate this virtual paper too, since it's so much easier to save a document as a PDF and send it to a colleague via email than it is to print and send via fax or mail. To read, edit, and manipulate all these PDFs, you need appropriate tools and skills.

Given the high price of Adobe Acrobat DC Pro, many Mac users have turned to Smile's affordable PDFpen apps to help them sign PDF forms, handle scanned documents, make changes in existing PDFs, create new PDFs from a variety of sources, and even export PDFs to other file formats. With Take Control of PDFpen 8, you'll learn how to do all these tasks and more on your Mac with PDFpen or PDFpenPro or on the go with PDFpen for iPad & iPhone.

Members of Take Control's sister publication, TidBITS, can save 20% on all Smile products purchased through the Smile cart, including PDFpen 8 and PDFpenPro 8. To learn more, visit the Membership Benefits page. To access the coupon code, make sure you've logged in and click through from the Your Member Benefits page.

Take Control of PDFpen 8 begins with a guide to purchasing options: PDFpen versus PDFpenPro, from Smile versus the Mac App Store, and the advantages of the iOS version. Next, you'll meet PDFpen with an overview of the PDF format and a tour of the interface.

With the basics out of the way, highlights of what you'll learn to do include:

Add and remove pages, and combine pages from multiple files into one PDF.Mark up a PDF with highlights, comments, editing marks, and more.Edit a PDF by fixing typos, adding text, formatting text, and redacting confidential text. Scan a document into a PDF, and make the text editable with OCR.View and work with OCRed text in the OCR layer (PDFpenPro only)Add clickable links, page numbers, and images.Make a clickable table of contents (PDFpenPro only).Password-protect a PDF. And (PDFpenPro only), prevent others from printing or editing a PDF. Turn a PDF into a formatted Microsoft Word document, or (PDFpenPro only) export it in Excel or PowerPoint format. And, you'll find directions for working with PDF forms:

Fill out forms with ease.Add a handwritten signature.Apply a digital signing certificate.Print just form entries on a pre-printed form.Create an interactive PDF form (PDFpenPro only) that can collect data and send it to you via email or the Web. You can add an interactive signature field, which makes it easy for the form to be signed online.An appendix describes the useful AppleScripts that ship with PDFpen.

This ebook was created in collaboration with Smile, with PDFpen's developers tech editing the book.