Koncocoo

Best Microsoft Access Database Guides

Access 2013 Bible
Explains how to create tables, manipulate datasheets, and work with multiple tables Teaches you how to apply the seven-step design method to build databases that are tailored to your needs Covers building forms with wizards, creating bound and unbound forms, and adding data validation Shows you ways to automate query parameters, create functions and subroutines, and add programmed error routines Features a bonus website with content that contains all source code from the book as well as bonus shareware, freeware, trial, demo, and evaluation programs. Learn to create effective tables, powerful analytic queries, robust applications with Access forms, and attractive Access reports while gaining insight on topics like SharePoint® integration and Visual Basic programming. Get a solid grounding in database fundamentals Use Access to analyze large amounts of data Turn your data into attractive PDF-style reports and outputs Automate redundant reporting and analysis using Access macros Build powerful departmental applications with Access forms Save time and increase productivity with Access VBA Integrate or publish your data on SharePoint sites Follow along with downloadable examples and database files from the book.
Reviews
"This book was all encompassing it covered everything I needed to learn about Access and gave examples and files from their website that shows you exactly how to construct a database with Access."
"Obviously, the program has changed a great deal since I last looked at it, but this book is so clearly written it very quickly brings you up to speed when you have a solid understanding of what databases do and the theory behind them."
"I remembered the Access book I had relied on most in the 90s – the Access Bible."
"Thin glossy pages - you can see the text, on the next two pages, with an annoying glare - like an annual parts catalog/phone book.. Font - appears to be a normal size, but compacted, with low contrast between upper and lower case sizes. Graphics are awful - need a magnifying glass to read the examples, and even then, it looks like dot matrix print."
"I know a lot about Access basics but being the OCD perfectionist that I am, I decided to start from page 1 (well, page "ix" to be exact LOL) just in case there are little tidbits about the basics that might help me out along the way. I've never been formally trained with regards to databases or the theory of database design. I'm currently trying to learn enough to build a database to track my family finances."
"Users who are new to Access will find it very helpful as well as users who are familiar with earlier versions of Access as there are a lot of changes and enhanced abilities."
"They lack of color and contrast in the application make it tiring to use, however that is no excuse for publishing this book with unreadable figures."
Find Best Price at Amazon
Exploring Microsoft Office Access 2016 Comprehensive (Exploring for Office 2016 Series)
With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know. Digital badges lets students showcase their Microsoft Office or Computer Concepts competencies, keeping them motivated and focused on their future careers. Mary Anne Poatsy, Series Editor, Windows 10 Author Mary Anne is a senior faculty member at Montgomery County Community College, teaching various computer application and concepts courses in face-to-face and online environments. Eric Cameron, Access Author Eric Cameron is a tenured Associate Professor at Passaic County Community College, where he has taught in the Computer and Information Sciences department since 2001. Jerri Williams, Access Author Jerri Williams is a Senior Instructor at Montgomery County Community College in Pennsylvania.
Reviews
"Very well organized and helpful guide to Access."
"The book is very good but the MyITLab that goes with it is buggy."
"Most Access books are too focused on Microsoft Access and neglect larger database issues. This book does fall into those traps at times, but I am giving it 4 stars because it is not quite as bad as others on those points."
"This is an expensive textbook when bought brand new and it doesn't come with a MyITLab access code, which teachers will require."
Find Best Price at Amazon
Access 2010: The Missing Manual
You'll learn all the secrets of this powerful database program so you can use your data in creative ways -- from creating product catalogs and publishing information online to producing invoices and reports. Five Touchstones to Understanding Access Let’s face it--learning the tricks and techniques of database design can be a bit of a slog. Most people are familiar with tables , the grid-like grouping of data that stores your information (for example, lists of items you own, friends you have, or products you sell through your small business). The other key ingredients are queries (customized search routines that pull out the information you need at the drop of a hat), reports (similar to queries, but nicely formatted and ready for printing), forms (windows that make it easy to review and edit the data in your tables), and macros and modules (miniature programs that can do just about anything—from updating 10,000 records at once to firing off an email). The database designer has the responsibility of laying out the tables, building the queries, and knocking together some nice reports and forms (assuming you want all those features). To become an Access expert, you must first learn to design a logical, consistent set of tables and add the relationships that link them together. Next, you must learn to build the other types of objects--queries, forms, and reports--that make it easier to perform common tasks. At some point, while tackling this second stage, you’ll run into a challenge that forces you to step up to the third level of Access mastery: macros . For example, you can use macros to build buttons that send emails, start printouts, make updates, or just take you around your database. Using VB code, you can do almost anything, from validating a credit card to leading a customer through an order process (two examples that are discussed in Access 2010: The Missing Manual ). And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.
Reviews
"I haven't actually used this book yet but I have the 2007 version and it was awesome."
"This Manual is very useful for the serious Access user.."
"Good start if you like learning from books, however i think there are better material online for free."
"Gave it 4 stars because, even though I was an applications programmer for 15 years, some sophisticated areas were not explained so that I could understand them."
"The Missing Manual books are wonderful."
"Since the changes to program navigation [ribbons] I find this book to be a great help."
"This book is laid out well and fairly easy to use - something I can't say for all software manuals."
"I had extensive experience with the older version and crystal reports which gives me an understanding of databases."
Find Best Price at Amazon

Best Other Databases

SQL Cookbook: Query Solutions and Techniques for Database Developers (Cookbooks (O'Reilly))
How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques The technique of walking a string , which allows you to use SQL to parse through the characters, words, or delimited elements of a string. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." SQL is particular passion of Anthony's, and he's become known as the go-to guy among his clients when it comes to solving difficult SQL query problems.
Reviews
"Excellent book for references."
"Over the last couple of years I have been learning SQL for data analysis and collection."
"I find this very useful for many small SQL snippet that I need to write from time to time as I am not a programmer but rather someone who queries data from time-to-time."
"useful handbook for a quick lookup."
"concise and accurate refresher for multiple SQL dialects."
"A must have for any serious SQL developer or SQL Admin's collection."
"It is definitely a classic for SQL developers."
"You won't find SQL tricks ala Celko's books, but sometimes all you want is help on your day to day."
Find Best Price at Amazon

Best Oracle Databases

Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c
Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing code Understand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION and UDF pragma, BEQUEATH CURRENT_USER for views, and new conditional compilation directives Take advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilities Optimize PL/SQL performance with features like the function result cache and Oracle utilities such as PL/Scope and the PL/SQL hierarchical profiler Build modular, easy-to-maintain PL/SQL applications using packages, procedures, functions, and triggers. Steven Feuerstein is considered to be one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). At home with his family in Houston, Texas, Bill's current nonbillable titles include Webmaster for his neighborhood civic club, "IT Guy" for his son's Boy Scout troop, and Eucharistic Adoration Coordinator for his church.
Reviews
"Oracle's website has a ton of great information, but having a book like this with examples and further explanations comes in very handy when getting exposed to/learning PL/SQL."
"This book is awesome."
"Love this book, it's been my go to reference for years."
"All Feuersteins books are five star."
"What could anyone say other than this book should be required reading for anyone that needs to use PL/SQL."
"amazing, lots of coding examples and really great utility."
Find Best Price at Amazon

Best Relational Databases

Understanding DB2: Learning Visually with Examples
Understanding DB2: Learning Visually with Examples, Second Edition, is the easiest way to master the latest versions of DB2 and apply their full power to your business challenges. Written by four IBM DB2 experts, this book introduces key concepts with dozens of examples drawn from the authors' experience working with DB2 in enterprise environments. Thoroughly updated for DB2 9.5, it covers new innovations ranging from manageability to performance and XML support to API integration. Understanding DB2 teaches DB2 V8.2 visually, step by step, with dozens of examples and case studies drawn from the authors' unsurpassed experience as DB2 consultants at IBM. For those preparing for certification, this book also contains over a hundred sample questions crafted by the authors to reflect the content and format of the IBM DB2 UDB Database Administration Certification exams, with answers and detailed explanations. Raul F. Chong, DB2 on Campus Program Manager at the IBM Toronto Laboratory, is a DB2 Certified Solutions Expert in administration and application development with ten years of experience in DB2. He has helped customers resolve DB2 migration, performance, and design issues; developed new DB2 solutions; taught DB2 workshops; contributed to DB2 exam tutorials; and was the lead author of the first edition of Understanding DB2 . He is the coauthor of Advanced DBA Certification Guide and Reference for DB2 Universal Database for Linux, UNIX, and Windows , DB2 UDB for Windows , and the first edition of Understanding DB2 .
Reviews
"This is a good reference book for a DBA (or a wanna-be DBA)."
"Nonetheless, this is a good book to start learning DB2."
"You can found official community eBooks on 10 and IBM Data Studio online."
"I love this book and recommend it to anyone looking for the DB2 book to buy."
"Not alot of DB2 books out there (unlike Oracle), but the one's I have read are either very old or geared towards mainframes."
"The diagrams and tables are used effectively to clarify concepts."
"Can't wait to begin learning about db2 databases."
"Beware."
Find Best Price at Amazon

Best MySQL Guides

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (5th Edition)
Easy visual approach uses demonstrations and real-world examples to guide you step by step through advanced techniques for dynamic Web development using PHP and MySQL. Larry Ullman is a writer, Web and software developer, trainer, instructor, speaker, and consultant.
Reviews
"Much, much more is covered by the 'tutorial' bit of the book, and there's also a number of case-study-style projects after it. A number of common projects are built up on the assumption you've read the rest of the book and know what you're doing, and the code itself (downloadable from the author's webpage) is very useful as a starting point for your own projects. There are regular giveaways of new books, all the code samples are collected there, there's detailed errata collected by the author himself, and most useful of all, there's a forum where the author and other readers of the book can help you with your coding struggles."
"My only real complaint is the use of XHTML instead of HTML 5, a consequence of when the book was published."
"good price and quick shipping."
"This book is a great way to get started with PHP, it builds a good foundation and helps grasp difficult concepts in an easy to follow way."
"But the most intriguing chapter of this book i think it's the introductory chapter about object-oriented programming (ch 16), concise but enough appealing in order to awake interest in the OOP and make me order the third book of the PHP series, PHP Advanced, which deals in much more detail with this subject."
"Recommend for the beginner and the experienced reader who wants to touch back to basics."
"It's rare that I feel this way about a technical book, but every time I pick this book up and read a bit more, I am more and more glad I chose this book over some of the others."
Find Best Price at Amazon

Best Data Processing

Don't Make Me Think, Revisited: A Common Sense Approach to Web Usability (3rd Edition) (Voices That Matter)
If you’ve read it before, you’ll rediscover what made Don’t Make Me Think so essential to Web designers and developers around the world. Steve Krug (pronounced "kroog") is best known as the author of Don't Make Me Think: A Common Sense Approach to Web Usability , now in its second edition with over 350,000 copies in print.
Reviews
"This book is for anyone who owns a website, builds websites, manages websites others have built, or manages people who build and/or manage websites."
"As the subtitle, "A Common Sense Approach", and Krug's consultancy's name, "Advanced Common Sense" ([...]) convey, many great design considerations today involve some simple approaches to dramatically improve your web user experiences."
"This should be required reading by ALL marketing execs, ALL web designers and developers, ALL graphic designers, ALL product designers and inventors, and ALL copywriters."
"That fact makes this book a good read for anybody who is involved in any aspect of a websites operation, Web Developer, Marketing, Sales and Management (from mid level to upper level)."
"Many of the ideas and resources in the book have been incredibly valuable to me in my work, and it's almost always the first book I recommend to anyone asking questions about User Experience related topics."
"Unlike a boring text book, Krug makes the book really fun with helpful (yet obvious) examples that bring some concepts to life."
"Krug breaks the issues of usable web design into simple, digestible form for anyone who depends on a website for promotion or income."
"This book was on the "suggested" reading lists for an interface design class that I took in college."
Find Best Price at Amazon

Best Data Mining

The Elements of Statistical Learning: Data Mining, Inference, and Prediction, Second Edition (Springer Series in Statistics)
This major new edition features many topics not covered in the original, including graphical models, random forests, ensemble methods, least angle regression & path algorithms for the lasso, non-negative matrix factorisation, and spectral clustering. Almost all of the chapters are revised.… The Material is nicely reorganized and repackaged, with the general layout being the same as that of the first edition.… If you bought the first edition, I suggest that you buy the second editon for maximum effect, and if you haven’t, then I still strongly recommend you have this book at your desk. … the book may also be of interest to a theoretically inclined reader looking for an entry point to the area and wanting to get an initial understanding of which mathematical issues are relevant in relation to practice. … this is a welcome update to an already fine book, which will surely reinforce its status as a reference.” (Gilles Blanchard, Mathematical Reviews, Issue 2012 d). You can flip the book open to any page, read a sentence or two and be hooked for the next hour or so.” (Peter Rabinovitch, The Mathematical Association of America, May, 2012).
Reviews
"In addition to having excellent and correct mathematical derivations of important algorithms The Elements of Statistical Learning is fairly unique in that it actually uses the math to accomplish big things. This hard use of isomorphism allows amazing results such as Figure 3.15 (which shows how Least Angle Regression differs from Lasso regression, not just in algorithm description or history: but by picking different models from the same data) and section 3.5.2 (which can separate Partial Least Squares' design CLAIM of fixing the x-dominance found in principle components analysis from how effective it actually is as fixing such problems). Unlike some lesser machine learning books the math is not there for appearances or mere intimidating typesetting: it is there to allow the authors to organize many methods into a smaller number of consistent themes."
"A good book in this area."
"While no book I have seen covers every data mining methodology available, this one has the strongest coverage I have seen in additive models, non-linear regression, and CART/MART (regression/classification trees)."
"Good book, help me build a systematic knowledge on statistics and machine learning. Of course, you may need some basic knowledge before reading it if you are novice."
"This book is basically the bible for statistical learning."
"This book is an excellent survey of the huge area of statistics / computer science called statistical learning."
"I'm a machine learning person, and this book provides pretty thorough state-of-art and up-to-date (relatively well) summary of statistical methods being used in lots of pattern classification fields."
"I have a PhD in Math and more particularly stochastic processes and everytime I open this book I can't quite understand what the content is."
Find Best Price at Amazon

Best Data Warehousing

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence! Fully updated with fresh insights and best practices, this book provides clear guidelines for designing dimensional models—and does so in a style that serves the needs of those new to data warehousing as well as experienced professionals. Practical design techniques—both basic and advanced—for dimension and fact tables 14 case studies, including retail sales, electronic commerce, customer relationship management, procurement, inventory, order management, accounting, human resources, financial services, healthcare, insurance, education, telecommunications, and transportation Sample data warehouse bus matrices for 12 case studies Dimensional modeling pitfalls and mistakes to avoid Enhanced slowly changing dimension techniques type 0 through 7 Bridge tables for ragged variable depth hierarchies and multivalued attributes Best practices for Big Data analytics Guidelines for collaborative, interactive design sessions with business stakeholders An overview of the Kimball DW/BI project lifecycle methodology Comprehensive review of extract, transformation, and load (ETL) systems and design considerations The 34 ETL subsystems and techniques to populate dimension and fact tables.
Reviews
"still a goto reference when starting new data warehouse projects."
"A very good book, complete, and updated."
"A few editorial / typo mistakes and more practical big data examples away from 5 stars."
"I was pleasantly surprised to see how much of the content here has been updated to incorporate paradigm shifts and new technologies, while still holding to the well-defined and well-proven Business Dimensional Lifecycle techniques."
"This is a clear and thoughtful book."
"This book really helped me understand Business Intelligence and Data Warehouse strategies."
Find Best Price at Amazon

Best Data Modeling & Design

Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems
Peer under the hood of the systems you already use, and learn how to use and operate them more effectively Make informed decisions by identifying the strengths and weaknesses of different tools Navigate the trade-offs around consistency, scalability, fault tolerance, and complexity Understand the distributed systems research upon which modern databases are built Peek behind the scenes of major online services, and learn from their architectures.
Reviews
"I highly recommend this book for any software engineer."
"Great theoretical overview, not enough practical material to justify the name "designing"."
"I've been looking forward to this book since I pre-ordered it last year. I've been working on this field on and off for the past few years."
"He dives deep into subjects like Btrees, LSM trees, SSTables, and concepts that would normally seem foreign, but because of the author's understanding he breaks it down into tangible bits. By reading this book, you get a clear understanding of real world big data architecture and the drawbacks of things like sharding, replication, lag as well as solutions."
"After that book, you can read the free article "Distributed Systems for Fun and Profit" and you are good to go for this amazing book :D."
"He starts from a functional 4 lines code to build a database to the way how one can interpret and implement concurrency, serializability, isolation and linearizability (the latter for distributed systems). That said, if you ever worked on data systems, especially across paradigms (IMS -> RDBMS -> NoSQL -> Map-Reduce -> Spark -> Streaming -> Polyglot), this book is pretty much only resource out there to tie the "loose ends" and paint a coherent narrative."
Find Best Price at Amazon

Best SQL

SQL in 10 Minutes, Sams Teach Yourself (4th Edition)
Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job. Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know–starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints. You'll learn methodically, systematically, and simply–in 22 short, quick lessons that will each take only 10 minutes or less to complete. With the Fourth Edition of this worldwide bestseller, the book has been thoroughly updated, expanded, and improved. Lessons now cover the latest versions of IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base. And new full-color SQL code listings help the beginner clearly see the elements and structure of the language. Construct complex SQL statements using multiple clauses and operators. He is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes , spinoff titles on MySQL and SQL Server T-SQL, ColdFusion Web Application Construction Kit and Advanced ColdFusion Application Development (both published by Adobe Press), Sams Teach Yourself Regular Expressions in 10 Minutes , as well as books on Flash, Java, Windows, and other subjects.
Reviews
"great quick ref for daily sql users or someone who is just starting to learn."
"), people looking for a book about databases (this book only goes into the basic SQL stuff, though it does mention a couple good practices for database structure), anyone who wants an in-depth book about SQL (it really does just cover the basics). In short, this book is for newbies who need to learn SQL quickly: just the basics, an intro into more advanced topics, it's very user friendly, easy to follow, and you can get through it in an afternoon if need be."
"This is a brilliantly colored guide that takes you step-by-step through the basic of learning SQL."
"Mr. Forta navigates effortlessly through the deeper constructs of SQL, illuminating such oddities as the the Cartesian Product with the same ease that he describes time-saving techniques like JOINS and SUBQUERIES."
"However, in practice, this is the first book I turn to when I need a quick reference for basic/intermediate SQL use."
"The Kindle versions also helpful because I don't have to carry the book with me everywhere."
"I don't really write review on product but today I decided to do that because this book is on point."
"Not good."
Find Best Price at Amazon
Home > Best Books > Best Computers & Technology > Best Databases & Big Data > Best Microsoft Access Database Guides