Computing & Internet Databases Books

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.

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.

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/.

The Ultimate Guide to Excel Pivot Tables

Pivot tables are one of the best or if not the best Microsoft Excel feature to help you organize, manipulate and view your data in an easy to read format. In less than 60 pages you will learn how to use this powerful tool to help you save tremendous amount of time and effort when working with Microsoft Excel.

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/.

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/.

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.

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

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/.

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.

Best Practices for Running Oracle Database on Amazon Web Services (AWS Whitepaper)

January 2018

Amazon Web Services (AWS) offers you the ability to run your Oracle Database in a cloud environment.

Running Oracle Database in the AWS Cloud is very similar to running Oracle Database in your

data center. To a database administrator or developer, there are no differences between the two

environments. However, there are a number of AWS platform considerations relating to security, storage,

compute configurations, management, and monitoring that will help you get the best out of your

Oracle Database implementation on AWS. This whitepaper provides best practices for achieving optimal

performance, availability, and reliability, and lowering the total cost of ownership (TCO) while running

Oracle Database on AWS. The target audience for this whitepaper includes database administrators,

enterprise architects, systems administrators, and developers who would like to run their Oracle

Database on AWS.

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/.

Storing and processing information

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

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.

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 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.

Learn to Use Pivot Tables in an Hour

Learn how to Use Pivot Tables in an Hour

If you are new to Excel Pivot Tables they can seem daunting and scary. This easy to follow and fully illustrated guide by the internationally renowned Excel consultant, Carl Nixon, is designed to get you up to speed quickly and easily.

You will be able to start producing your own Pivot Tables in an hour or less!

This easy guide is split in to 9 easy to digest parts.



An Introduction to Pivot Tables

Grouping Pivot Table Items

Same Pivot Table, Different Look

Multi Level Pivot Tables

Frequency Distribution in Pivot Tables

Charting with Pivot Tables

Slicing Pivot Tables with Slicers

Updating Pivot Tables

Calculated Fields and Items



FREE Accompanying File!

An accompanying spreadsheet, which helps you follow the exercises in the book, is also provided via a FREE download.

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.

The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features (The Microsoft Excel Step-By-Step Training Guide Series Book 1)

Learn the 25 most common Microsoft(R) Excel(R) Formulas & Features quickly and easily with this detailed step-by-step guide!

This book offers easy to follow examples with screenshots demonstrating how to use the 25 most common basic and intermediate Microsoft(R) Excel(R) formulas & features. The book is organized into 5 step-by-step sections, allowing you to grow your knowledge of Excel(R) at your own pace:

****Excel v2016 is now available, with 5 bonus formulas included****

Part 1 - Excel(R) Formula Fundamentals

SUM, SUBTRACTION, MULTIPLICATION, & DIVISION

AVERAGE

MIN & MAX

TODAY & NETWORKDAYS

SUMIF

Part 2 - Introduction to Pivot Tables

How to create a basic Pivot Table

Formatting Pivot Table results

Inserting Pivot Charts

Part 3 - Excel(R) Features

Data Sorting

Formula Trace

Text-To-Columns

Conditional Formatting & Filtering

Part 4 - Text Functions

LEN & TRIM

CONCATENATE & MID

PROPER, UPPER, & LOWER

Part 5 - Logic & Lookup Formulas

IF

Nested IF

VLOOKUP

Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using of Microsoft(R) Excel(R)!

SQL: Simplified SQL Programming & Database Management For Beginners. Your Step-By-Step Guide To Learning The SQL Database (SQL Series)

Learn SQL Programming And Database Management As Easy As ABC!

Do you want to learn SQL Programming in an easy and fun way?

Do you want to understand the fundamentals of managing databases without getting confused by complicated programming jargon?

If so, "Simplified SQL Programming & Database Management For Beginners. Your Step-By-Step Guide To Learning The SQL Database" by Steve Gosling is for you.

It provides the fundamental knowledge for you to start programming using SQL.

SQL is the standard database language that is powerful yet simple, flexible, portable and, most of all, integrated into numerous software applications. The current trend now is to become more digital in managing databases. And efficiency is the number one consideration in designing and building databases.

What Is So Special About This Book?

What makes this book special is its unique approach to teaching SQL programming and database management. Instead of throwing technical content at you, leaving you confused and overloaded with information, this book teaches you in jargon-free English that you will understand. Thus, allowing anyone, regardless of their experience to grasp each chapter with ease and become a confident programmer. Each section is broken down step-by-step, full of examples and ending with exercises that will give you that all needed practice.

You Will Learn The Following:

The history of SQL, its uses and applications The fundamentals of the SQL environment and the installation of SQLite The Database Objects The SQL Data Types The SQL Commands Performing Database Normalization The different Database Transactions The Database Operators Implementing Database Security Understanding Cursors, Triggers and ErrorsAnd much more!You have truly made an excellent decision by investing in this topic. So don't delay it any longer. Take this opportunity and also purchase your copy today.

Download Now!

See you inside!