Best Desktop Database Books

Database management systems are now an indispensable tool for managing information.

1. Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Author: by Martin Kleppmann
ISBN: 978-1449373320
Published at: O'Reilly Media; 1st edition (April 18, 2017)

View on Amazon

Data is at the center of many challenges in system design today. Difficult issues need to be figured out, such as scalability, consistency, reliability, efficiency, and maintainability. In addition, we have an overwhelming variety of tools, including relational databases, NoSQL datastores, stream or batch processors, and message brokers.

What are the right choices for your application? How do you make sense of all these buzzwords? In this practical and comprehensive guide, author Martin Kleppmann helps you navigate this diverse landscape by examining the pros and cons of various technologies for processing and storing data.

Software keeps changing, but the fundamental principles remain the same. With this book, software engineers and architects will learn how to apply those ideas in practice, and how to make full use of data in modern applications. Peer under the hood of the systems you already use, and learn how to use and operate them more effectivelyMake informed decisions by identifying the strengths and weaknesses of different toolsNavigate the trade-offs around consistency, scalability, fault tolerance, and complexityUnderstand the distributed systems research upon which modern databases are builtPeek behind the scenes of major online services, and learn from their architectures


2. SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL

Author: by Walter Shields
ClydeBank Media LLC
English
251 pages

View on Amazon

“THE BEST SQL BOOK FOR BEGINNERS IN 2021 – HANDS DOWN!”*INCLUDES FREE ACCESS TO A SAMPLE DATABASE, SQL BROWSER APP, COMPREHENSION QUIZES & SEVERAL OTHER DIGITAL RESOURCES! Not sure how to prepare for the data-driven future? This book shows you EXACTLY what you need to know to successfully use the SQL programming language to enhance your career!

#1 NEW RELEASE & #1 BEST SELLER *Are you a developer who wants to expand your mastery to database management? Then you NEED this book. Buy now and start reading today! Are you a project manager who needs to better understand your development team’s needs?

A decision maker who needs to make deeper data-driven analysis? Everything you need to know is included in these pages! The ubiquity of big data means that now more than ever there is a burning need to warehouse, access, and understand the contents of massive databases quickly and efficiently.

That’s where SQL comes in. SQL is the workhorse programming language that forms the backbone of modern data management and interpretation. Any database management professional will tell you that despite trendy data management languages that come and go, SQL remains the most widely used and most reliable to date, with no signs of stopping.


3. SQL All-in-One For Dummies

Author: by Allen G. Taylor
For Dummies
English
768 pages

View on Amazon

The latest on SQL databases SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations of the SQL language and its many powerful applications.

With the ballooning amount of data out there, more and more businesses, large and small, are moving from spreadsheets to SQL databases like Access, Microsoft SQL Server, Oracle databases, MySQL, and PostgreSQL. This compendium of information covers designing, developing, and maintaining these databases.

Cope with any issue that arises in SQL database creation and management Get current on the newest SQL updates and capabilities Reference information on querying SQL-based databases in the SQL language Understand relational databases and their importance to today’s organizations SQL All-In-One For Dummies is a timely update to the popular reference for readers who want detailed information about SQL databases and queries.


4. Database Internals: A Deep Dive into How Distributed Data Systems Work

Author: by Alex Petrov
O'Reilly Media
English
376 pages

View on Amazon

When it comes to choosing, using, and maintaining a database, understanding its internals is essential. But with so many distributed databases and tools available today, it’s often difficult to understand what each one offers and how they differ. With this practical guide, Alex Petrov guides developers through the concepts behind modern database and storage engine internals.

Throughout the book, you’ll explore relevant material gleaned from numerous books, papers, blog posts, and the source code of several open source databases. These resources are listed at the end of parts one and two. You’ll discover that the most significant distinctions among many modern databases reside in subsystems that determine how storage is organized and how data is distributed.

This book examines:Storage engines: Explore storage classification and taxonomy, and dive into B-Tree-based and immutable Log Structured storage engines, with differences and use-cases for eachStorage building blocks: Learn how database files are organized to build efficient storage, using auxiliary data structures such as Page Cache, Buffer Pool and Write-Ahead LogDistributed systems: Learn step-by-step how nodes and processes connect and build complex communication patternsDatabase clusters: Which consistency models are commonly used by modern databases and how distributed storage systems achieve consistency


5. Access 2019 Bible

Author: by Michael Alexander
1119514754
Wiley
English

View on Amazon

Master database creation and management Access 2019 Bible is your, comprehensive reference to the world’s most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2019 has to offer.

Whether you’re new to Access or getting started with Access 2019, you’ll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in the book, plus trial software and a special offer from Database Creations.

Start from the beginning for a complete tutorial, or dip in and grab what you need when you need it. Access enables database novices and programmers to store, organize, view, analyze, and share data, as well as build powerful, integrable, custom database solutions but databases can be complex, and difficult to navigate.

This book helps you harness the power of the database with a solid understanding of their purpose, construction, and application. Understand database objects and design systems objects Build forms, create tables, manipulate datasheets, and add data validation Use Visual Basic automation and XML Data Access Page design Exchange data with other Office applications, including Word, Excel, and more From database fundamentals and terminology to XML and Web services, this book has everything you need to maximize Access 2019 and build the database you need.


6. Data Pipelines Pocket Reference: Moving and Processing Data for Analytics

Author: by James Densmore
O'Reilly Media
English
276 pages

View on Amazon

Data pipelines are the foundation for success in data analytics. Moving data from numerous diverse sources and transforming it to provide context is the difference between having data and actually gaining value from it. This pocket reference defines data pipelines and explains how they work in today’s modern data stack.

You’ll learn common considerations and key decision points when implementing pipelines, such as batch versus streaming data ingestion and build versus buy. This book addresses the most common decisions made by data professionals and discusses foundational concepts that apply to open source frameworks, commercial products, and homegrown solutions.

You’ll learn:What a data pipeline is and how it worksHow data is moved and processed on modern data infrastructure, including cloud platformsCommon tools and products used by data engineers to build pipelinesHow pipelines support analytics and reporting needsConsiderations for pipeline maintenance, testing, and alerting


7. Practical Tableau: 100 Tips, Tutorials, and Strategies from a Tableau Zen Master

Author: by Ryan Sleeper
O'Reilly Media
English
624 pages

View on Amazon

Whether you have some experience with Tableau software or are just getting started, this manual goes beyond the basics to help you build compelling, interactive data visualization applications. Author Ryan Sleeper, one of the world’s most qualified Tableau consultants, complements his web posts and instructional videos with this guide to give you a firm understanding of how to use Tableau to find valuable insights in data.

Over five sections, Sleeperrecognized as a Tableau Zen Master, Tableau Public Visualization of the Year author, and Tableau Iron Viz Championprovides visualization tips, tutorials, and strategies to help you avoid the pitfalls and take your Tableau knowledge to the next level.

Practical Tableau sections include:Fundamentals: get started with Tableau from the beginningChart types: use step-by-step tutorials to build a variety of charts in TableauTips and tricks: learn innovative uses of parameters, color theory, how to make your Tableau workbooks run efficiently, and moreFramework: explore the INSIGHT framework, a proprietary process for building Tableau dashboardsStorytelling: learn tangible tactics for storytelling with data, including specific and actionable tips you can implement immediately


8. Excel 2016 All-in-One For Dummies (For Dummies (Computer/Tech))

Author: by Greg Harvey
For Dummies
English
816 pages

View on Amazon

Your one-stop guide to all things Excel 2016 Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft’s changes in the popular spreadsheet tool. It offers you everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basicand beyond.

In no time, your Excel skills will go from ‘meh’ to excellent. Written by expert Greg Harvey, who has sold more than 4. 5 million copies of his previous books combined and has taught and trained extensively in Microsoft Excel, this all-encompassing guide offers everything you need to get started with Excel.

From generating pivot tables and performing financial functions to performing error trapping and building and running macrosand everything in betweenthis hands-on, friendly guide makes working with Excel easier than ever before. Serves as the ideal reference for solving common questions and Excel pain points quickly and easily Helps to increase productivity and efficiency when working in Excel Fully updated for the new version of Excel Covers basic and more advanced Excel topics If working in Excel occasionally makes you want to scream, this will be the dog-eared, dust-free reference you’ll turn to again and again.


9. Neural Networks and Deep Learning: A Textbook

Author: by Charu C. Aggarwal
Springer
English
520 pages

View on Amazon

This book covers both classical and modern models in deep learning. The primary focus is on the theory and algorithms of deep learning. The theory and algorithms of neural networks are particularly important for understanding important concepts, so that one can understand the important design concepts of neural architectures in different applications.

Why do neural networks work? When do they work better than off-the-shelf machine-learning models? When is depth useful? Why is training neural networks so hard? What are the pitfalls? The book is also rich in discussing different applications in order to give the practitioner a flavor of how neural architectures are designed for different types of problems.

Applications associated with many different areas like recommender systems, machine translation, image captioning, image classification, reinforcement-learning based gaming, and text analytics are covered. The chapters of this book span three categories: The basics of neural networks: Many traditional machine learning models can be understood as special cases of neural networks.

10. Access 2016 Bible

Author: by Michael Alexander
111908654X
Wiley
English

View on Amazon

Master database creation and management Access 2016 Bible is your, comprehensive reference to the world’s most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2016 has to offer.

Whether you’re new to Access or getting started with Access 2016, you’ll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in the book, plus trial software and a special offer from Database Creations.

Start from the beginning for a complete tutorial, or dip in and grab what you need when you need it. Access enables database novices and programmers to store, organize, view, analyze, and share data, as well as build powerful, integrable, custom database solutions but databases can be complex, and difficult to navigate.

This book helps you harness the power of the database with a solid understanding of their purpose, construction, and application. Understand database objects and design systems objects Build forms, create tables, manipulate datasheets, and add data validation Use Visual Basic automation and XML Data Access Page design Exchange data with other Office applications, including Word, Excel, and more From database fundamentals and terminology to XML and Web services, this book has everything you need to maximize Access 2016 and build the database you need.

11. Learn SQL Quickly: A Beginner’s Guide to Learning SQL, Even If You’re New to Databases (Crash Course With Hands-On Project)

Author: by Code Quickly
English
191 pages
1951791789

View on Amazon

You don’t have to go back to school in order to get ahead in today’s world Do you have a burning desire to expand your skillset but don’t have the time or care to go back to studying for the next 4+ years?

Do you feel as if you are capable of so much more, and that you should be making a bigger contribution to the world? Are you ready to learn one of the most in-demand skills of the 21st century and set yourself up for outstanding success in your career – success that will not only benefit you, but thousands, perhaps millions, of other people as well?

Or, maybe you’ve already landed your dream job and now your boss needs you to fulfill the role as quickly as possible. Whatever the case may be, learning the ins and outs of the coding universe doesn’t have to be some kind of big and complex ordeal.

The internet might be abuzz with all kinds of confusing tutorials and partial playbooks making it seem like learning to code is harder than it really is, but rest assured, this is not true. Did you know that the average individual spends $20,000 on a course that is sometimes up to 24 weeks long just to learn the basics of coding?

12. EXCELL 2021: The Complete Step-By-Step Guide to Learn How To Use Excel and its Tricks Quickly and Easily With Many Illustrations That Will Help You Understand Fast.

Author: by Harrison Harmon
B098PLNFZB
July 4, 2021
English

View on Amazon

Do you want to learn EXCEL Quickly and Easily? Do you Want to master EXCEL formulas and learns some unique tricks? Then this is THE guide you were looking for! This book is a complete step-by-step illustrated guide for all who know the importance of EXCEL and how useful it is and who are now ready to delve in and learn about EXCEL basics and what’s new in 2021.

Will teach you everything you need to know about Excel, including how and when to use it for best results. With the illustrations inside, your work will be faster and easier. By reading this book you will learn:Introduction to MS Excel Cell referencing in Excel Excel Tips and TricksDifference Between Excel Worksheet & Workbook Excel Formulas, Keyboard Shortcuts & Tricks How to Calculate Running Total?

How to Import XML File Convert XML to Excel? How to fix when Microsoft Excel doesn’t Open? Tricks to Fix Slow Excel Spreadsheets (Speed-up Excel)Reason for not working Excel Formulas and Solutions. How to Recover Unsaved Excel Files? And Much, much moreOverall, this book has a great deal of information on how to use Excel to do difficult tasks automatically.

13. Ethereum For Dummies (For Dummies (Computer/Tech))

Author: by Michael G. Solomon
For Dummies
English
272 pages

View on Amazon

Dive into a secure future Professionals look to Ethereum as a blockchain-based platform to develop safe applications and conduct secure transactions. It takes a knowledgeable guiding hand to understand how Ethereum works and what it does and Ethereum For Dummies provides that guidance.

Written by one of the leading voices in the blockchain community and best selling author of Blockchain For Dummies, this book demystifies the workings of Ethereum and shows how it can enhance security, transactions, and investments. As an emerging application of blockchain technology, Ethereum attracts a wide swath of professionals ranging from financial pros who see it as a way to enhance their business, security analysts who want to conduct secure transactions, programmers who build apps that employ the Ethereum blockchain, or investors interested in cashing in on the rise of cryptocurrency.

Ethereum For Dummies offers a starting point to all members of this audience as it provides easy-to-understand explanation of the tools and techniques of using Ethereum. Understand the fundamentals of Ethereum Build smart contracts Create decentralized applications Examine public and private chains If you need to get a grip on one of the biggest applications of blockchain technology, this book makes it easier.

14. Access 2016 For Dummies (Access for Dummies)

Author: by Laurie A. Ulrich
For Dummies
English
464 pages

View on Amazon

English
160 pages

View on Amazon

View on Amazon

DescriptionMicrosoft Excel is a spreadsheet application established by Microsoft. It is widely used in business, finance, science and education and is often considered the most powerful spreadsheet program available. One of the numerous things that brand Microsoft Excel so great is its simplicity – just like all other pieces of software developed by Microsoft, it’s user-friendly, easy to learn, and very intuitive for those with minimal programming knowledge or experience.

Microsoft Excel is used by small businesses, large corporations, schools, financial institutions and the government. It’s often the preferred spreadsheet software among businesses and organizations because it is so flexible, reliable and customizable. Microsoft Excel can be an essential tool for managing and tracking business data.

Importing or linking multiple workbooks: one of the benefits of using Excel over other spreadsheet applications is its capacity to link several spreadsheets together – this allows you to view all data in one document or spreadsheet. Advanced sorting: sort numerical and alphabetical data from a specific column with standard values or custom formats.