Best Other Databases Books
Database design and modeling are some of those topics which rarely get the attention they deserve, especially at the start of the project, but once things have gone out of hand, then everybody talks about them.
1. SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL
Author: by Walter Shields
ClydeBank Media LLC
“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.
2. Password Book: Personal Internet Password Organizer, Alphabetical Order A-Z Tabs, Keeping Track of Password Username/Log in, Web Addresses, Email, … Use, Never miss your Login Details Again!
Author: by Nova Password Books
Regular expressions are an extremely powerful tool for manipulating text and data. They are now standard features in a wide range of languages and popular tools, including Perl, Python, Ruby, Java, VB. NET and C# (and any language using the .
NET Framework), PHP, and MySQL. If you don’t use regular expressions yet, you will discover in this book a whole new world of mastery over your data. If you already use them, you’ll appreciate this book’s unprecedented detail and breadth of coverage.
If you think you know all you need to know about regularexpressions, this book is a stunning eye-opener. As this book shows, a command of regular expressions is an invaluable skill. Regular expressions allow you to code complex and subtle text processing that you never imagined could be automated.
Regular expressions can save you time and aggravation. They can be used to craft elegant solutions to a wide range of problems. Once you’ve mastered regular expressions, they’ll become an invaluable part of your toolkit. You will wonder how you ever got by without them.
4. Head First SQL: Your Brain on SQL — A Learner's Guide
Author: by Lynn Beighley
You know the rudiments of the SQL query language, yet you feel you aren’t taking full advantage of SQL’s expressive power. You’d like to learn how to do more work with SQL inside the database before pushing data across the network to your applications.
You’d like to take your SQL skills to the next level. Let’s face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language.
In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You’ll learn about:Window functions, arguably the most significant enhancement to SQL in the past decade. If you’re not using these, you’re missing outPowerful, database-specific features such as SQL Server’s PIVOT and UNPIVOT operators, Oracle’s MODEL clause, and PostgreSQL’s very useful GENERATE_SERIES functionPivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result setBucketization, and why you should never use that term in Brooklyn.
6. 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
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?
7. Password & Account Number Book: Never forget the password again (Password Book) (Volume 1)
Author: by Mike Murphy
07/NOV Edition 2.0: Added The ALPHABATICAL INDEXOver time we may FORGET some PASSWORD, Bank Account Number, Keywords, Social Media, Bills or Online Account Info. It will be a BIG PROBLEM for us. This notebook is a GOOD HELPER for you to keep all your password information together and secure.
The Book Contains 60 pages 5″ x 8″Easy to carry with or lock in strongbox. Buy it and Save your passwords today! And Buy another for your friend / family who memory is not good!
8. Learning SQL: Master SQL Fundamentals
Author: by Alan Beaulieu
Updated for the latest database management systems – including MySQL 6. 0, Oracle 11g, and Microsoft’s SQL Server 2008 – this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.
Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will:Move quickly through SQL basics and learn several advanced featuresUse SQL data statements to generate, manipulate, and retrieve dataCreate database objects, such as tables, indexes, and constraints, using SQL schema statementsLearn how data sets interact with queries, and understand the importance of subqueriesConvert and manipulate data with SQL’s built-in functions, and use conditional logic in data statementsKnowledge of SQL is a must for interacting with data.
9. Backup & Recovery: Inexpensive Backup Solutions for Open Systems
Author: by W. Curtis Preston
Packed with practical, freely available backup and recovery solutions for Unix, Linux, Windows, and Mac OS X systems – as well as various databases – this new guide is a complete overhaul of Unix Backup & Recovery by the same author, now revised and expanded with over 75% new material.
Backup & Recovery starts with a complete overview of backup philosophy and design, including the basic backup utilities of tar, dump, cpio, ntbackup, ditto, and rsync. It then explains several open source backup products that automate backups using those utilities, including AMANDA, Bacula, BackupPC, rdiff-backup, and rsnapshot.
Backup & Recovery then explains how to perform bare metal recovery of AIX, HP-UX, Linux, Mac OS, Solaris, VMWare, & Windows systems using freely-available utilities. The book also provides overviews of the current state of the commercial backup software and hardware market, including overviews of CDP, Data De-duplication, D2D2T, and VTL technology.
Finally, it covers how to automate the backups of DB2, Exchange, MySQL, Oracle, PostgreSQL, SQL-Server, and Sybase databases – without purchasing a commercial backup product to do so. For environments of all sizes and budgets, this unique book shows you how to ensure data protection without resorting to expensive commercial solutions.
10. Probability: Risk Management, Statistics, Combinations and Permutations for Business
Author: by Daniel Covington
Are you someone who struggles or used to struggle with Mathematics at school? Causing you to be totally averse to the subject? If you are, do you realize that certain aspects of Mathematics can be very useful for you to know in the real world?
Whether you are retail employee or a budding entrepreneur, or really just someone looking to contribute to your place of work, you will surely encounter problems that require planning and analysis to address them. What you may not know is that, most of the time statistics, specifically probability and its concepts, will often give you an edge in identifying solutions and strategies to help you move forward with a great plan.
And you’re in luck because in this book you will get to know what probability is and more importantly, how it can help you solve the problems you encounter in your business work and day-to-day life. Specifically this book will help you:How to summarize dataMeasure variabilityLearn the core concepts of probabilityGain knowledge of probability distributions and their functionsRealize the importance of probability rules in businessBecome adept at using probabilities in life and at workIdentify the types of risk your business can faceHow to effectively manage risk using probabilityUnderstand how to use probability and statistics in businessHow to optimize your business and improve brand loyaltyLearn how to improve your customer experience and predict customer behaviorUnderstand the components of the business intelligence infrastructureGive your business an edge by learning more about probability and how it can help you.DO NOT DELAY!
11. SQL in a Nutshell: A Desktop Quick Reference Guide (In a Nutshell (O'Reilly))
Author: by Kevin Kline
For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today’s most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.
3 open source database products. You’ll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts – all packed into a succinct, comprehensive, and easy-to-use format. This book provides:Background on the Relational Database Model, including current and previous SQL standardsFundamental concepts necessary for understanding relational databases and SQL commandsAn alphabetical command reference to SQL statements, according to the SQL2003 ANSI standardThe implementation of each command by MySQL, Oracle, PostgreSQL, and SQL ServerAn alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementationsPlatform-specific functions unique to each implementationBeginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications.
13. Postfix: The Definitive Guide: A Secure and Easy-to-Use MTA for UNIX
Author: by Kyle D. Dent
Postfix is a Mail Transfer Agent (MTA): software that mail servers use to route email. Postfix is highly respected by experts for its secure design and tremendous reliability. And new users like it because it’s so simple to configure. In fact, Postfix has been adopted as the default MTA on Mac OS X.
It is also compatible with sendmail, so that existing scripts and programs continue to work seamlesslyafter it is installed. Postfix was written by well-known security expert Wietse Venema, who reviewed this book intensively during its entire development. Author Kyle Dent covers a wide range of Postfix tasks, from virtual hosting to controls for unsolicited commercial email.
While basic configuration of Postfix is easy, every site has unique needs that call for a certain amount of study. This book, with careful background explanations and generous examples, eases readers from the basic configuration to the full power of Postfix.
It discusses the Postfix interfaces to various tools that round out a fully scalable and highly secure email system. These tools include POP, IMAP, LDAP, MySQL, Simple Authentication and Security Layer (SASL), and Transport Layer Security (TLS, an upgrade of SSL).
14. Analytics: Business Intelligence, Algorithms and Statistical Analysis
Author: by Todd J. Blatt
Analytics – Business Intelligence, Algorithms and Statistical AnalysisIn today’s world, analysis has become an extremely important aspect to consider when you are thinking of starting any new line of business or even when it comes to purchasing a new house.
The unfortunate fact is that not many people know what analysis is all about. They tend to assume that each of the elements analysis, business intelligence, algorithms and statistical analysis are different entities when in reality they are all interlinked.
This book will help you gather a greater insight on all the elements. And you will gain an in-depth knowledge on each of these elements in different parts of the book; helping you to increase your knowledge and widen your horizons!
Here’s what is covered:Analytics 101 including the challenges and risksThe Types of Analytics Predictive, Descriptive and Prescriptive AnalyticsIntegrating Business and Analytics Chose the right Data and AnalyticsBusiness Analytics Technology The top emerging technologies, tools and trendsPredictive Analytics 101Exploring Data Types Associated TechniquesBusiness Intelligence 101Business Intelligence Infrastructure Benefits and how to use itHow to use the Business Intelligence InfrastructureThe Benefits of Business IntelligenceData MiningData Integration Including the Value and BenefitsData Visualization Best Algorithms for Analytics C4.
15. PHPUnit Pocket Guide: Test-Driven Development in PHP
Author: by Sebastian Bergmann
Smart web developers will tell you that the sooner you detect your code mistakes, the quicker you can fix them, and the less the project will cost in the long run. Well, the most efficient way to detect your mistakes in PHP is with PHPUnit, an open source framework that automates unit testing by running a battery of tests as you go.
The benefits of PHPUnit are significant:a reduction in the effort required to frequently test codefewer overall defectsadded confidence in your codeimproved relations with your open source teammates The only problem with this popular testing tool was its lack of documentation-until now, that is.
For this, O’Reilly went right to the source, as Sebastian Bergmann, the author of PHPUnit Pocket Guide, also happens to be PHPUnit’s creator. This little book brings together hard-to-remember information, syntax, and rules for working with PHPUnit. It also delivers the insight and sage advice that can only come from the technology’s creator.
Coverage of testing under agile methodologies and Extreme Programming (XP) is also included. The latest in O’Reilly’s series of handy Pocket Guides, this quick-reference book puts all the answers are right at your fingertips. It’s an invaluable companion for anyone interested in testing the PHP code they write for web applications.
16. The Sunflower Storage Jar: A Disguised Computer Password Book With Alphabetical Tabs – Small 4×6 Pocket Size Log Book Organizer (Altree Small Logbooks)
Author: by Altree Publishing Logbooks
A Password Book That Can Fit In Your Pocket Or Bag With a Discreet Memory Jar CoverAre you tired of forgetting the passwords of the websites you visit and the time wasted every time it happens? With this untitled and beautiful cover, all your passwords would be readily available for you, (See the security tip below!
The benefits:Your details at your fingertips in one place. Home Network InformationWiFi Password and Network IDGuest WiFi Password and Network IDSoftware License KeysNotes Pages – For convenience, we have added note pages at the end of this password logbook.
Email Log Details – If you have several email accounts, there are spaces for ten individual ones. Blank A-Z pages, should you need them, at the end of the bookTip: For added security, you would add the same special number, such as a birth date, a wedding date, etc when you type the password and not write it in your book.
It’s a perfect gift to treat yourself or anyone else you want to buy a gift for.