Computing & Internet Databases Books

SQL Easy

Learn an easy introduction into SQL. Relational database design teach-by-practical-diagrams-&-examples book for developers, programmers, systems analysts and project managers who are new to relational database and client/server technologies. Also for database developers, database designers and database administrators (DBA), who know some database design, and who wish to refresh & expand their RDBMS design technology horizons. Familiarity with at least one computer programming language, Windows file system & Excel is assumed. Since the book is career advancement oriented, it has a number of 3NF database design examples with metadata explanations along with practical SQL queries (over 800 SELECT queries) and T-SQL scripts, plenty to learn indeed. Great emphasis is placed on explaining the FOREIGN KEY - PRIMARY KEY constraints among tables, the connections which make the collection of individual tables a database. The database diagrams and queries are based on historic and current SQL Server sample databases: pubs (PRIMARY KEYs 9, FOREIGN KEYs 10), Northwind (PRIMARY KEYs 13, FOREIGN KEYs 13) and the latest AdventureWorks series. Among them: AdventureWorks, AdventureWorks2008, AdventureWorks2012 (PRIMARY KEYs 71, FOREIGN KEYs 90), & AdventureWorksDW2012 (PRIMARY KEYs 27, FOREIGN KEYs 44). The last one is a data warehouse database which is the basis for multi-dimensional OLAP cubes. The book teaches through vivid database diagrams and T-SQL queries how to think in terms of sets at a very high level, focusing on set-based operations instead of loops like in procedural programming languages. In addition to quick learning, the best way to master relational database design & T-SQL programming is to type the query in your own SQL Server Management Studio Query Editor, test it, examine it, change it and study it. Wouldn't it be easier just to copy & paste it? It would, but the learning value would diminish rapidly. You need to feel relational database design and the SQL langu

Microsoft Excel Essential Hints and Tips: Fundamental Hints and Tips to Kick Start Your Excel Skills (Learn Excel Visually Journey Book 1)

Free short ebook!

This ebook is for the Excel beginner. It's a basic Excel starter ebook which will give you skills to super-charge your spreadsheet aptitude. We look at how to set up your spreadsheet, getting data into Excel, formatting your spreadsheet, a bit of display management and how to print and share your spreadsheets.

Is this ebook right for you? Will it give you the Excel help you need? Take a glimpse inside the first few pages - if you like what you see, then go ahead and buy - why not - it's free!

Learn Excel Visually

The idea of these short handy bite-size books is to provide you with what I have found to be most useful elements of Excel within my day-to-day work and life. I don't tell you about all the bells and whistles - just what you need on a daily basis. These ebooks are suitable for anyone who is looking to learn Excel and wants to increase their productivity and efficiency, both at work and home. Please bear in mind I don't cover all functionality of all areas, the point is that I strip out anything that's not useful and only highlight the functionality that I believe is useful on a daily basis. Don't buy a huge textbook which you'll never fully read, pick an ebook which is most relevant to your current learning, read it, apply it and then get on with your day.

Why is this ebook free?

A lot of the information in this ebook can be found on the internet; but not in this consolidated and concise way. As mentioned above, my desire is to teach you what you need to know, not what you don't. I only cover stuff that I have found useful in my Excel life. I want to give you some Excel tips which will get you started. If you want to learn more, I have several other ebooks on Excel training which you can take a look at. I'll leave it completely up to you.

Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud

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. In this ebook, we introduce new security features: Always Encrypted, Row-Level Security, and dynamic data masking; discuss enhancements that enable you to better manage performance and storage: TemDB configuration, query store, and Stretch Database; review several improvements to Reporting Services; and also describe AlwaysOn Availability Groups, tabular enhancements, and R integration.

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.

Building Cloud Apps with Microsoft Azure: Best Practices for DevOps, Data Storage, High Availability, and More (Developer Reference)

This ebook walks you through a patterns-based approach to building real-world cloud solutions. The patterns apply to the development process as well as to architecture and coding practices. The content is based on a presentation developed by Scott Guthrie and delivered by him at the Norwegian Developers Conference (NDC) in June of 2013 (part 1, part 2), and at Microsoft Tech Ed Australia in September 2013 (part 1, part 2). Many others updated and augmented the content while transitioning it from video to written form.

Who should read this book

Developers who are curious about developing for the cloud, are considering a move to the cloud, or are new to cloud development will find here a concise overview of the most important concepts and practices they need to know. The concepts are illustrated with concrete examples, and each chapter includes links to other resources that provide more in-depth information. The examples and the links to additional resources are for Microsoft frameworks and services, but the principles illustrated apply to other web development frameworks and cloud environments as well.

Developers who are already developing for the cloud may find ideas here that will help make them more successful. Each chapter in the series can be read independently, so you can pick and choose topics that you're interested in.

Anyone who watched Scott Guthrie's "Building Real World Cloud Apps with Windows Azure" presentation and wants more details and updated information will find that here.

Assumptions

This ebook expects that you have experience developing web applications by using Visual Studio and ASP.NET. Familiarity with C# would be helpful in places.

Amazon Redshift Database Developer Guide

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

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

Amazon DynamoDB Developer Guide

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

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!

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.

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

Visual Basic Programming By Examples

Visual Basic is one of the easiest to learn computer programming language and yet it is very powerful.

In my tutorial I used VB 6 to explain step by step how to create a simple Visual Basic Application and relatively complex one (a Patient Management system) that is using database. Patient Management application source code is explained in details.

You will learn how to design and create a database in MS Access and how to create tables and queries.

The book includes a sample application that shows how to use Windows API function.

You will learn how to convert VB program that can be run only in Visual Basic development environment to a distributable application that can be installed on any client computer.

For illustration, I included 128 screen shot images and links to video.

You will be able to download from my website complete source code for 7 Visual Basic projects including a Password Keeper, a Patient Management and a Billing Management applications.

Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2

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. In this 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 enhancement, and R integration. This book is a preview edition because it's not complete; the final edition will be available Spring of 2016.

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.

Storing and processing information

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

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.

Opening Windows (An Hour of Your Time Book 1)

Is Windows 10 a pain or a pleasure?

A waste of your time or a jewel to treasure?

If you've little idea about what you should do,

Then Opening Windows is clearly for you!

If Windows 10 appears to you dull and opaque, then you need to give Franklyn Nash An Hour of Your Time and he'll make Windows 10 crystal clear.

After half a lifetime spent in teaching and in building websites and computers, Franklyn Nash will help you demystify Windows.

No more hunting through woolly websites, fussy forums and mushy-headed magazines and finding contradictory advice. Whether you're a beginner, novice or competent you'll find an abundance of easy to understand answers here in one lucid location.

In this first book in the An Hour of Your Time series, you'll discover tips and advice about such topics as

othe two golden rules of email safety

owhat software is essential to get you started

oways to make Google Chrome even better

ohow to defeat hackers

ohow to remove cake crumbs and coffee from your keyboard

Over the years, family and friends have commented "You've helped me so much with my computer, why not write some books and share your knowledge with others?" So he did! The first one is called Opening Windows.

Information about other books in the series is available at www.anhourofyourtime.co.uk

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.

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

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

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.

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