Top Computer Database Ebook Best Sellers

1

Pandas in Action - Boris Paskhaver Cover Art

Pandas in Action

Pandas in Action by Boris Paskhaver

Take the next steps in your data science career! This friendly and hands-on guide shows you how to start mastering Pandas with skills you already know from spreadsheet software. In Pandas in Action you will learn how to:     Import datasets, identify issues with their data structures, and optimize them for efficiency     Sort, filter, pivot, and draw conclusions from a dataset and its subsets     Identify trends from text-based and time-based data     Organize, group, merge, and join separate datasets     Use a GroupBy object to store multiple DataFrames Pandas has rapidly become one of Python's most popular data analysis libraries. In Pandas in Action , a friendly and example-rich introduction, author Boris Paskhaver shows you how to master this versatile tool and take the next steps in your data science career. You’ll learn how easy Pandas makes it to efficiently sort, analyze, filter and munge almost any type of data. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the technology Data analysis with Python doesn’t have to be hard. If you can use a spreadsheet, you can learn pandas! While its grid-style layouts may remind you of Excel, pandas is far more flexible and powerful. This Python library quickly performs operations on millions of rows, and it interfaces easily with other tools in the Python data ecosystem. It’s a perfect way to up your data game. About the book Pandas in Action introduces Python-based data analysis using the amazing pandas library. You’ll learn to automate repetitive operations and gain deeper insights into your data that would be impractical—or impossible—in Excel. Each chapter is a self-contained tutorial. Realistic downloadable datasets help you learn from the kind of messy data you’ll find in the real world. What's inside     Organize, group, merge, split, and join datasets     Find trends in text-based and time-based data     Sort, filter, pivot, optimize, and draw conclusions     Apply aggregate operations About the reader For readers experienced with spreadsheets and basic Python programming. About the author Boris Paskhaver is a software engineer, Agile consultant, and online educator. His programming courses have been taken by 300,000 students across 190 countries. Table of Contents PART 1 CORE PANDAS 1 Introducing pandas 2 The Series object 3 Series methods 4 The DataFrame object 5 Filtering a DataFrame PART 2 APPLIED PANDAS 6 Working with text data 7 MultiIndex DataFrames 8 Reshaping and pivoting 9 The GroupBy object 10 Merging, joining, and concatenating 11 Working with dates and times 12 Imports and exports 13 Configuring pandas 14 Visualization

2

Secrets of Access Database Development and Programming - Andrei Besedin Cover Art

Secrets of Access Database Development and Programming

Secrets of Access Database Development and Programming by Andrei Besedin

SECRETS OF ACCESS DATABASE DEVELOPMENT AND PROGRAMMING Everyone knows that few things boost the efficiency and intelligence of an organization. One of the few things is a database-driven business application such as the  Microsoft Access . Even though it might not be widely used like excel and word, it is one of the most powerful programs in the Microsoft office suite. It is a powerful way to manage your data. The Microsoft Access has completely changed industries and markets by sharpening communication, eliminating guesswork, advancing the quality and speed of work, and also delivering insights.  There are some major advantages of this tool.  •It saves money •Great development speed •They are at once familiar and user-friendly. This means the tool is easy to use •Offer great flexibility and Agility We know that nothing will boost the competitive edge or efficiency of an organization like a well-designed business application such as the MS Access. That is why we have decided to offer you our book “secrets of access database development and programming.”  It is an incredible product  with outstanding information about Access database development and programming.  When you buy this powerful short book, you stand a chance of getting lots of  benefits from it . Some of the things you will gain from this product are: •Clearly discussed “secrets of access database development and programming.” •It serves a perfect reference guide due to the great navigation index it offers •All sentences are short and precise, so it won’t take ages for you to read and understand our book •The book is informative and easy to understand However, we know that our amazing short book might not have the highest level of information. Our primary goal is to offer you a simple but robust way to manage your data by revealing to you the “secrets of access database development and programming.”  The secrets offered by our powerful short book can help you manage your data than you can imagine. Also, with the secrets, you will know the relatively simple and flexible way to create databases to store, manage, and enter data. You can save about $1000 just by making this purchase. The more you procrastinate on buying this success proven short book, the more you are vulnerable to making mistakes and wasting time when dealing with huge data. To manage your data in a simple but robust way, obtain your copy of the book with just a single click. Look at the upper right of the page and click the buy button there. Believe us; you won’t be making a mistake, rather you would be doing yourself a favor.  This is one of the best opportunities you can have to move your business forward. Don’t trash your opportunity. Purchase your copy now!

3

Practical Statistics for Data Scientists - Peter Bruce, Andrew Bruce & Peter Gedeck Cover Art

Practical Statistics for Data Scientists

Practical Statistics for Data Scientists
50+ Essential Concepts Using R and Python
by Peter Bruce, Andrew Bruce & Peter Gedeck

Statistical methods are a key part of data science, yet few data scientists have formal statistical training. Courses and books on basic statistics rarely cover the topic from a data science perspective. The second edition of this popular guide adds comprehensive examples in Python, provides practical guidance on applying statistical methods to data science, tells you how to avoid their misuse, and gives you advice on what’s important and what’s not. Many data science resources incorporate statistical methods but lack a deeper statistical perspective. If you’re familiar with the R or Python programming languages and have some exposure to statistics, this quick reference bridges the gap in an accessible, readable format. With this book, you’ll learn: Why exploratory data analysis is a key preliminary step in data scienceHow random sampling can reduce bias and yield a higher-quality dataset, even with big dataHow the principles of experimental design yield definitive answers to questionsHow to use regression to estimate outcomes and detect anomaliesKey classification techniques for predicting which categories a record belongs toStatistical machine learning methods that "learn" from dataUnsupervised learning methods for extracting meaning from unlabeled data

4

SQL - Brandon Cooper Cover Art

SQL

SQL by Brandon Cooper

How to start creating and using SQL databases, even if you have no prior programming experience. Are you looking for a more streamlined way to manage information? Do you have large volumes of data that need to be accessed through a sophisticated communication system? Could your company benefit from the advantages SQL offers? SQL, or Structured Query Language, has been around since the 80s. It has proven to be effective and efficient, making it the ideal solution for your database demands. The best part? You can learn how to program using SQL in just nine chapters. SQL introduces you to the basics of programming using comprehensive examples and step by step practice problems that set you up for success. In addition, you'll discover: How to create your very first database Clauses to help you retrieve dataData manipulation functionsThe basics of queries and subqueriesTransaction processing management Step by step instructions and walkthroughs to help you start programming right away And so much more! You don't have to be intimidated by the complexities of database management. With SQL, all your data problems can be solved.  Click "add to cart" to learn how to take advantage of the powers of SQL and learn to wield them yourself.

5

The Chief Data Officer Management Handbook - Martin Treder Cover Art

The Chief Data Officer Management Handbook

The Chief Data Officer Management Handbook Set Up and Run an Organization’s Data Supply Chain by Martin Treder

There is no denying that the 21st century is data driven, with many digital industries relying on careful collection and analysis of mass volumes of information. A Chief Data Officer (CDO) at a company is the leader of this process, making the position an often daunting one.  The Chief Data Officer Management Handbook  is here to help. With this book, author Martin Treder advises CDOs on how to be better prepared for their swath of responsibilities, how to develop a more sustainable approach, and how to avoid the typical pitfalls. Based on positive and negative experiences shared by current CDOs,  The Chief Data Officer Management Handbook  guides you in designing the ideal structure of a data office, implementing it, and getting the right people on board. Important topics such as the data supply chain, data strategy, and data governance are thoughtfully covered by Treder. As a CDO it is important to use your positioneffectively with your entire team.  The Chief Data Officer Management Handbook  allows all employees to take ownership in data collaboration. Data is the foundation of present and future tech innovations, and you could be the leader that makes the next big impact.

6

Elixir in Action, Third Edition - Saša Jurić Cover Art

Elixir in Action, Third Edition

Elixir in Action, Third Edition
by Saša Jurić

Fully updated to Elixir 1.15, this authoritative bestseller reveals how Elixir tackles problems of scalability, fault tolerance, and high availability. Thousands of developers have learned to build applications in Elixir by using Saša Juric’s Elixir in Action. You’ll skip the programming basics or 101 introductions; this book builds on your existing knowledge to get you quickly writing real Elixir code. Along the way, you'll develop an appreciation for, and considerable skill in, functional and concurrent programming. Inside Elixir in Action, Third Edition you’ll find: • Updates for Elixir 1.15 • Elixir modules, functions, and type system • Functional and concurrent programming • Introduction to distributed system design • Creating deployable releases Fully updated to Elixir 1.15, this book contains new coverage of working with application configuration and the latest OTP releases. It teaches you the underlying principles and functional concepts of Elixir, and how each piece fits into the bigger picture of building production-ready systems with Elixir, Erlang, and the OTP framework. Foreword by Francesco Cesarini. About the technology With best-in-class fault tolerance and concurrency, a pragmatic approach to functional programming, and the power to operate at scale, Elixir is the perfect choice for mission-critical software. Start reading Elixir in Action , and you’ll quickly understand why Elixir creator José Valim says it “...tops the list” of Elixir books. About the book Elixir in Action, Third Edition teaches you how to create distributed applications and server-side systems using Elixir and the Erlang VM. This Third Edition from Elixir expert Saša Juric is fully updated to include the latest features of Elixir 1.15. In it, you’ll master the foundations of the language, discover how the OTP framework minimizes tedious boilerplate code, and explore numerous examples that ensure you’re learning hands-on. What's inside • Elixir modules, functions, and type system • Functional and concurrent programming • Introduction to distributed system design • Creating deployable releases About the reader For programmers comfortable with client/server applications. No experience with Elixir, Erlang, or functional programming required. About the author Saša Juric uses Elixir and Erlang to build fault-tolerant, scalable, highly concurrent systems. Technical editor on this book was Marius Butuc . Table of Contents PART 1 Functional Elixir 1 First steps 2 Building blocks 3 Control flow 4 Data abstractions PART 2 CONCURRENT ELIXIR 5 Concurrency primitives 6 Generic server processes 7 Building a concurrent system 8 Fault tolerance basics 9 Isolating error effects 10 Beyond GenServer PART 3 PRODUCTION 11 Working with components 12 Building a distributed system 13 Running the system

7

Access 2010 All-in-One For Dummies - Alison Barrows, Margaret Levine Young & Joseph C. Stockman Cover Art

Access 2010 All-in-One For Dummies

Access 2010 All-in-One For Dummies by Alison Barrows, Margaret Levine Young & Joseph C. Stockman

The all-in-one reference to all aspects of Microsoft Access 2010 If you want to learn Microsoft Access inside and out, the nine minibooks in this easy-access reference are exactly what you need. Read the book cover to cover, or jump into any of the minibooks for the instruction and topics you need most. Learn how to connect Access to SQL Server, manipulate your data locally, use nifty new features from Office 2010 such as the enhanced Ribbon, create queries and macros like a champ, and much more. From the basics to advanced functions, it’s what you need to make Access more accesssible. Shows you how to store, organize, view, analyze, and share data using Microsoft Access 2010, the database application included with Microsoft Office 2010 Includes nine minibooks that cover such topics as database design, tables, queries, forms, reports, macros, database administration, securing data, programming with Visual Basic for Applications (VBA), and using Access with the Web Helps you build database solutions that integrate with the Web and other enterprise data sources Offers plenty of techniques, tips, and tricks to help you get the most out of Access This all-in-one guide contains everything you need to start power-using Access 2010!

8

Data Science for Business - Foster Provost & Tom Fawcett Cover Art

Data Science for Business

Data Science for Business What You Need to Know about Data Mining and Data-Analytic Thinking by Foster Provost & Tom Fawcett

Written by renowned data science experts Foster Provost and Tom Fawcett, Data Science for Business introduces the fundamental principles of data science, and walks you through the "data-analytic thinking" necessary for extracting useful knowledge and business value from the data you collect. This guide also helps you understand the many data-mining techniques in use today. Based on an MBA course Provost has taught at New York University over the past ten years, Data Science for Business provides examples of real-world business problems to illustrate these principles. You’ll not only learn how to improve communication between business stakeholders and data scientists, but also how participate intelligently in your company’s data science projects. You’ll also discover how to think data-analytically, and fully appreciate how data science methods can support business decision-making. Understand how data science fits in your organization—and how you can use it for competitive advantageTreat data as a business asset that requires careful investment if you’re to gain real valueApproach business problems data-analytically, using the data-mining process to gather good data in the most appropriate wayLearn general concepts for actually extracting knowledge from dataApply data science principles when interviewing data science job candidates

9

The Model Thinker - Scott E. Page Cover Art

The Model Thinker

The Model Thinker What You Need to Know to Make Data Work for You by Scott E. Page

Work with data like a pro using this guide that breaks down how to organize, apply, and most importantly, understand what you are analyzing in order to become a true data ninja. From the stock market to genomics laboratories, census figures to marketing email blasts, we are awash with data. But as anyone who has ever opened up a spreadsheet packed with seemingly infinite lines of data knows, numbers aren't enough: we need to know how to make those numbers talk. In The Model Thinker , social scientist Scott E. Page shows us the mathematical, statistical, and computational models—from linear regression to random walks and far beyond—that can turn anyone into a genius. At the core of the book is Page's "many-model paradigm," which shows the reader how to apply multiple models to organize the data, leading to wiser choices, more accurate predictions, and more robust designs. The Model Thinker provides a toolkit for business people, students, scientists, pollsters, and bloggers to make them better, clearer thinkers, able to leverage data and information to their advantage.

10

Microsoft Office Access 2007 All-in-One Desk Reference For Dummies - Alan Simpson, Margaret Levine Young, Alison Barrows, April Wells & Jim McCarter Cover Art

Microsoft Office Access 2007 All-in-One Desk Reference For Dummies

Microsoft Office Access 2007 All-in-One Desk Reference For Dummies
by Alan Simpson, Margaret Levine Young, Alison Barrows, April Wells & Jim McCarter

Updated to cover all the latest features and capabilities of Access 2007, this resource provides new and inexperienced Access users with eight task-oriented minibooks that cover begininning to advanced-level material  Each minibook covers a specific aspect of Access, such as database design, tables, queries, forms, reports, and macros Shows how to accomplish specific tasks such as database housekeeping, security data, and using Access with the Web Access is the world's leading desktop database solution and is used by millions of people to store, organize, view, analyze, and share data, as well as to build powerful, custom database solutions that integrate with the Web and enterprise data sources

11

The Data Warehouse Toolkit - Ralph Kimball & Margy Ross Cover Art

The Data Warehouse Toolkit

The Data Warehouse Toolkit The Definitive Guide to Dimensional Modeling by Ralph Kimball & Margy Ross

Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence! The first edition of Ralph Kimball's  The Data Warehouse Toolkit  introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more. Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligence Begins with fundamental design recommendations and progresses through increasingly complex scenarios Presents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and more Draws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and more Design dimensional databases that are easy to understand and provide fast query response with  The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition .

12

FileMaker Pro Design and Scripting For Dummies - Timothy Trimble Cover Art

FileMaker Pro Design and Scripting For Dummies

FileMaker Pro Design and Scripting For Dummies by Timothy Trimble

Get the scoop on designing databases for Mac and Windows Use FileMaker Pro design and scripting to quickly, easily build databases that solve real problems FileMaker Pro has grown up, and it's better than ever! This easy-to-use guide shows you how to design a great FileMaker application, build a database that works, add the functionality you need, populate your database, and venture into programming with ScriptMaker. You'll find out how to share and protect your database, too. Discover how to * Build a layout that works * Create custom triggers and calculated fields * Generate reports automatically * Manage security * Publish your database on the Web * Embed pictures, sound, and video

13

FileMaker 12 In Depth - Jesse Feiler Cover Art

FileMaker 12 In Depth

FileMaker 12 In Depth by Jesse Feiler

FileMaker® 12 In Depth Do more in less time! FileMaker 12 In Depth is the most comprehensive, coherent, and practical guide to creating professional-quality solutions with the newest versions of FileMaker! Drawing on his unsurpassed real-world experience as a FileMaker user, consultant, and developer, Jesse Feiler helps you gain practical mastery of today’s newest, most advanced FileMaker tools and features. •      Use themes to build solutions for FileMaker Pro on Windows and OS X, FileMaker Go on iOS, and Instant Web Publishing •      Get the most out of new container field technology •      Quickly become a FileMaker 12 power user •      Make the most of FileMaker fields, tables, layouts, and parts •      Iteratively design reliable, high-performance FileMaker relational databases •      Work with relationships, including self-joins and cross-product relationships •      Write calculation formulas and use functions •      Use event-driven scripts to make databases more interactive •      Build clear and usable reports, publish them, and incorporate them into workflows •      Secure applications with user accounts, privileges, file-level access, network security, and authentication •      Use FileMaker’s Web Viewer to access live web-based data •      Convert systems from older versions of FileMaker, and troubleshoot successfully •      Share, exchange, export, and publish data via SQL and XML •      Instantly publish databases on the web, and use advanced Custom Web Publishing techniques •      Trigger automated behaviors whenever specific events occur •      Extend FileMaker’s functionality with plug-ins •      Set up, configure, tune, and secure FileMaker Server All In Depth books offer •     Comprehensive coverage with detailed solutions •     Troubleshooting help for tough problems you can’t fix on your own •     Outstanding authors recognized worldwide for their expertise and teaching style Learning, reference, problem-solving... the only FileMaker 12 book you need!

14

SQL in 30 Pages - U.Q. Magnusson Cover Art

SQL in 30 Pages

SQL in 30 Pages by U.Q. Magnusson

For those of you who need to quickly ramp up on SQL, but have no time to plow through a 600-page tome, this is for you. SQL in 30 Pages is a brief e-booklet of fewer than 4,000 words, designed to get you into SQL as fast as possible, as easily as possible. There is no bull in this Micro-Manual by popular online teacher U.Q. Magnusson. From the very first page you will learn about the basic concepts of SQL, including the command-line interface, the CRUD operations (Create, Read, Update, and Delete), multiple tables, functions, data types, and indexing. Simple yet comprehensive examples follow as you zip through, and each is explained in pithy detail.

15

Blockchain Basics - Daniel Drescher Cover Art

Blockchain Basics

Blockchain Basics A Non-Technical Introduction in 25 Steps by Daniel Drescher

In 25 concise steps, you will learn the basics of blockchain technology. No mathematical formulas, program code, or computer science jargon are used.No previous knowledge in computer science, mathematics, programming, or cryptography is required. Terminology is explained through pictures, analogies, and metaphors.. This book bridges the gap that exists between purely technical books about the blockchain and purely business-focused books. It does so by explaining both the technical concepts that make up the blockchain and their role in business-relevant applications. What You Will Learn: What the blockchain is Why it is needed and what problem it solves Why there is so much excitement about the blockchain and its potential Major components and their purpose How components work and interact Limitations, why they exist, and what has been done to overcome them Major application scenarios

16

FileMaker 12 Developers Reference - Bob Bowers, Steve Lane, Scott Love & Dawn Heady Cover Art

FileMaker 12 Developers Reference

FileMaker 12 Developers Reference Functions, Scripts, Commands, and Grammars by Bob Bowers, Steve Lane, Scott Love & Dawn Heady

The new FileMaker 12 allows you to build unparalleled databases for a wide variety of devices, from Windows and Mac desktops to iPhones and iPad. With 10 million registered customers, FileMaker's users are "average Joes" who are knowledge workers, subject matter experts, and business users from all walks of life. The community extends well beyond the pool of professional software developers. FileMaker's legendary ease-of-use has led to its wide adoption and has allowed non-programmers an avenue into creating sophisticated software solutions. FileMaker 12 Developer’s Reference will serve to help bridge the gaps in these people's understanding of FileMaker's hundreds of calculation functions, script steps, and operations. They know FileMaker, they've used it for years, but they need a quick reference, immediately accessible while not interrupting their work on screen. There is no other book like this on the market. All FileMaker books include information on calculation formulas, scripting, etc., but none have expressly focused on giving readers one simple thing: a quick reference to be used in conjunction with their programming efforts. Some books teach, others explain, still others explore specific in-depth topics. This book will appeal to the entire FileMaker Pro community and be a great extension of their library. This edition is updated for the many new features coming with FileMaker 12, including the product's design functionality and the file format, and a new section dedicated to FileMaker Go, which is the iOS client.

17

Access 2010 Bible - Michael R. Groh Cover Art

Access 2010 Bible

Access 2010 Bible by Michael R. Groh

The expert guidance you need to get the most out of Access 2010 Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you'll appreciate the thorough attention to database fundamentals and terminology. If you're familiar with earlier versions, you can jump right into Access 2010 enhancements such as the new Access user interface and wider use of XML and Web services. Takes you under the hood of Microsoft Access 2010, the database application included with Microsoft Office 2010 Explores the latest enhancements, such as a new user interface and wider use of XML and Web services; also, how to exchange data with Word, Excel, PowerPoint, and other Office apps Covers how to create tables, manipulate datasheets, and work with multiple tables Explains the seven database objects and how to use a seven-step design method to build a database tailored to your needs Shows you how to build forms, use Visual Basic and the VBA Editor, automate query parameters, create functions and subroutines, use XML to create data access pages, and more Includes a CD with all source code from the book and working examples, plus bonus shareware, freeware, trial, demo and evaluation programs that work with or enhance Microsoft Office You’ll want to keep this soup-to-nuts Access reference close at hand! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

18

Data Warehousing For Dummies - Thomas C. Hammergren Cover Art

Data Warehousing For Dummies

Data Warehousing For Dummies by Thomas C. Hammergren

Data warehousing is one of the hottest business topics, and there’s more to understanding data warehousing technologies than you might think. Find out the basics of data warehousing and how it facilitates data mining and business intelligence with Data Warehousing For Dummies, 2nd Edition. Data is probably your company’s most important asset, so your data warehouse should serve your needs. The fully updated Second Edition of Data Warehousing For Dummies helps you understand, develop, implement, and use data warehouses, and offers a sneak peek into their future. You’ll learn to: Analyze top-down and bottom-up data warehouse designs Understand the structure and technologies of data warehouses, operational data stores, and data marts Choose your project team and apply best development practices to your data warehousing projects Implement a data warehouse, step by step, and involve end-users in the process Review and upgrade existing data storage to make it serve your needs Comprehend OLAP, column-wise databases, hardware assisted databases, and middleware Use data mining intelligently and find what you need Make informed choices about consultants and data warehousing products Data Warehousing For Dummies, 2nd Edition also shows you how to involve users in the testing process and gain valuable feedback, what it takes to successfully manage a data warehouse project, and how to tell if your project is on track. You’ll find it’s the most useful source of data on the topic!

19

Using FileMaker Bento, Enhanced Edition - Jesse Feiler Cover Art

Using FileMaker Bento, Enhanced Edition

Using FileMaker Bento, Enhanced Edition by Jesse Feiler

*** This USING FileMaker Bento book is enhanced with 4 hours of FREE step-by-step VIDEO TUTORIALS and AUDIO SIDEBARS! *** FileMaker Bento is a product from FileMaker, which is owned by Apple. Designed to bring FileMaker's database expertise to users of Mac OS X Leopard and later, it integrates data from iPhoto, iCal, Mail, and Address Book with databases that you can create from your own data as well as data imported from other sources. USING FileMaker Bento is a media-rich learning experience designed to help new users master FileMaker Bento quickly, and get the most out of it, fast! EVERY chapter has multiple video and audio files integrated into the learning material which creates interactive content that works together to teach everything mainstream FileMaker Bento users need to know. You'll Learn How to: Synchronize with the Bento iPhone and iPad apps Share Data with other Bento Users Use Built-in Bento Libraries for Address Book, iCal, and Apple Mail Examples of Topics Covered in VIDEO TUTORIALS, which Walk You Through Tasks You've Just Got to See! Applying a New Theme to a Form Setting Up iPhone Synchronization with iTunes Importing Data by Pasting into Table View Examples of Topics Covered in AUDIO SIDEBARS, which Deliver Insights Straight From the Experts! How, When, and Why to Use Form Tools Working with Address Book Groups and Smart Collections Getting the Most out of Data Integration Please note that due to the incredibly rich media included in your Enhanced eBook, you may experience longer download times. Please be patient while your product is delivered. This Enhanced eBook has been developed to match the Apple Enhanced eBook specifications and may not perform on other devices or reader applications.

20

Database Design for Mere Mortals - Michael Hernandez Cover Art

Database Design for Mere Mortals

Database Design for Mere Mortals A Hands-On Guide to Relational Database Design by Michael Hernandez

The #1 Easy, Commonsense Guide to Database Design! Michael J. Hernandez’s best-selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he’s made this hands-on, software-independent tutorial even easier, while ensuring that his design methodology is still relevant to the latest databases, applications, and best practices. Step by step, Database Design for Mere Mortals ® , Third Edition, shows you how to design databases that are soundly structured, reliable, and flexible, even in modern web applications. Hernandez guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You’ll learn practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules. Coverage includes Understanding database types, models, and design terminology Discovering what good database design can do for you—and why bad design can make your life miserable Setting objectives for your database, and transforming those objectives into real designs Analyzing a current database so you can identify ways to improve it Establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views Ensuring the appropriate level of data integrity for each application Identifying and establishing business rules Whatever relational database systems you use, Hernandez will help you design databases that are robust and trustworthy. Never designed a database before? Settling for inadequate generic designs? Running existing databases that need improvement? Start here.

21

Python Machine Learning - Sebastian Raschka Cover Art

Python Machine Learning

Python Machine Learning by Sebastian Raschka

Unlock deeper insights into Machine Leaning with this vital guide to cutting-edge predictive analytics About This Book • Leverage Python’s most powerful open-source libraries for deep learning, data wrangling, and data visualization • Learn effective strategies and best practices to improve and optimize machine learning systems and algorithms • Ask – and answer – tough questions of your data with robust statistical models, built for a range of datasets Who This Book Is For If you want to find out how to use Python to start answering critical questions of your data, pick up Python Machine Learning – whether you want to get started from scratch or want to extend your data science knowledge, this is an essential and unmissable resource. What You Will Learn • Explore how to use different machine learning models to ask different questions of your data • Learn how to build neural networks using Pylearn 2 and Theano • Find out how to write clean and elegant Python code that will optimize the strength of your algorithms • Discover how to embed your machine learning model in a web application for increased accessibility • Predict continuous target outcomes using regression analysis • Uncover hidden patterns and structures in data with clustering • Organize data using effective pre-processing techniques • Get to grips with sentiment analysis to delve deeper into textual and social media data In Detail Machine learning and predictive analytics are transforming the way businesses and other organizations operate. Being able to understand trends and patterns in complex data is critical to success, becoming one of the key strategies for unlocking growth in a challenging contemporary marketplace. Python can help you deliver key insights into your data – its unique capabilities as a language let you build sophisticated algorithms and statistical models that can reveal new perspectives and answer key questions that are vital for success. Python Machine Learning gives you access to the world of predictive analytics and demonstrates why Python is one of the world’s leading data science languages. If you want to ask better questions of data, or need to improve and extend the capabilities of your machine learning systems, this practical data science book is invaluable. Covering a wide range of powerful Python libraries, including scikit-learn, Theano, and Pylearn2, and featuring guidance and tips on everything from sentiment analysis to neural networks, you’ll soon be able to answer some of the most important questions facing you and your organization. Style and approach Python Machine Learning connects the fundamental theoretical principles behind machine learning to their practical application in a way that focuses you on asking and answering the right questions. It walks you through the key elements of Python and its powerful machine learning libraries, while demonstrating how to get to grips with a range of statistical models.

22

Crystal Reports 10 For Dummies - Allen G. Taylor Cover Art

Crystal Reports 10 For Dummies

Crystal Reports 10 For Dummies by Allen G. Taylor

Would you read information presented like this? No. It’s just not natural. Sometimes presentation is almost as important as content. When you create a report, the goal is to provide information for readers in a format they can readily understand. Crystal Reports 10 For Dummies, the latest version of the most popular report writer in the world, shows you how to create simple or sophisticated reports, turning data into interactive, actionable reports that convey what’s happening in your business. You can progress cover-to-cover or use the index to find out how to: Give your reports more pizzazz by using the correct fonts, color, drop shadows, graphic elements, and more Integrate elements from multiple, non-database sources Group sort, total result sets, cross-tab reports, and add formulas, charts, or maps Print reports Use customized Business Views gleaned from the same information to provide each reader with information he or she needs to know without spilling all the beans, sales figures, marketing information, or whatever Present multi-dimensional data in OLAP (Online Analytical Processing) cubes Get ideas from sample reports on the companion Web site Written by Allen G. Taylor, nationally known lecturer, teacher, and author of over 20 books, including Database Development for Dummies, Crystal Reports 10 For Dummies makes it crystal clear how to: Store your information securely in Crystal Repository Use Crystal Analysis 10 to display OLAP data so you and your report’s readers can analyze the information in an online environment Use Crystal Enterprise to put Crystal Reports online for viewing by hundreds or thousands of people in your organization Whether you want to dazzle your company’s CEO and shareholders, motivate the sales force, or simply share database information cogently, with Crystal Reports 10 For Dummies you not only make your point, you an impression. When your reports look professional, you look professional.

23

Blockchain For Dummies - Tiana Laurence Cover Art

Blockchain For Dummies

Blockchain For Dummies by Tiana Laurence

Unravel the mysteries of blockchains   Blockchain technologies are disrupting some of the world’s biggest industries. Blockchain For Dummies provides a fast way to catch up with the essentials of this quickly evolving tech. Written by an author involved in founding and analyzing blockchain solutions, this book serves to help those who need to understand what a blockchain can do (and can't do). This revised edition walks you through how a blockchainsecurely records data across independent networks. It offers a tour of some of the world’s best-known blockchains, including those that power Bitcoin and other cryptocurrencies. It also provides a glance at how blockchain solutions are affecting the worlds of finance, supply chain management, insurance, and governments. Get a clear picture of what a blockchain can do Learn how blockchains rule cryptocurrency and smart contracts Discover current blockchains and how each of them work Test blockchain apps Blockchain has become the critical buzzword in the world of financial technology and transaction security — and now you can make sense of it with the help of this essential guide.

24

Python for Data Analysis - Wes McKinney Cover Art

Python for Data Analysis

Python for Data Analysis by Wes McKinney

Get the definitive handbook for manipulating, processing, cleaning, and crunching datasets in Python. Updated for Python 3.10 and pandas 1.4, the third edition of this hands-on guide is packed with practical case studies that show you how to solve a broad set of data analysis problems effectively. You'll learn the latest versions of pandas, NumPy, and Jupyter in the process. Written by Wes McKinney, the creator of the Python pandas project, this book is a practical, modern introduction to data science tools in Python. It's ideal for analysts new to Python and for Python programmers new to data science and scientific computing. Data files and related material are available on GitHub. Use the Jupyter notebook and IPython shell for exploratory computingLearn basic and advanced features in NumPyGet started with data analysis tools in the pandas libraryUse flexible tools to load, clean, transform, merge, and reshape dataCreate informative visualizations with matplotlibApply the pandas groupby facility to slice, dice, and summarize datasetsAnalyze and manipulate regular and irregular time series dataLearn how to solve real-world data analysis problems with thorough, detailed examples

25

MySQL 5 Essentials - Neil Smyth Cover Art

MySQL 5 Essentials

MySQL 5 Essentials Understanding MySQL Database Creation and Administration by Neil Smyth

MySQL 5 Essentials is intended to teach the basics of using the MySQL relational database management system (RDBMS) to create and manage databases. It is ideal for those unfamiliar with both databases in general and MySQL in particular. Topics covered include the basics of relational databases, MySQL installation on Linux and Windows systems, an overview of the MySQL administration tools, database security and detailed tutorials on using SQL to create, manage and retrieve data.

26

The Definitive Guide to DAX - Alberto Ferrari & Marco Russo Cover Art

The Definitive Guide to DAX

The Definitive Guide to DAX Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI by Alberto Ferrari & Marco Russo

This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX’s remarkable power and flexibility, this no-compromise “deep dive” is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handlingUnderstand evaluation contexts and the CALCULATE and CALCULATETABLE functionsPerform time-based calculations: YTD, MTD, previous year, working days, and moreWork with expanded tables, complex functions, and elaborate DAX expressionsPerform calculations over hierarchies, including parent/child hierarchiesUse DAX to express diverse and unusual relationshipsMeasure DAX query performance with SQL Server Profiler and DAX Studio

27

Definitive Guide to DAX, The - Marco Russo & Alberto Ferrari Cover Art

Definitive Guide to DAX, The

Definitive Guide to DAX, The Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel by Marco Russo & Alberto Ferrari

Now expanded and updated with modern best practices, this is the most complete guide to Microsoft’s DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens under the hood when you run a DAX expression, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX’s remarkable capabilities? This no-compromise “deep dive” is exactly what you need. Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel ·         Master core DAX concepts, including calculated columns, measures, and calculation groups ·         Work efficiently with basic and advanced table functions ·         Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions ·         Perform time-based calculations ·         Use calculation groups and calculation items ·         Use syntax of variables (VAR) to write more readable, maintainable code ·         Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters ·         Master advanced optimization techniques, and improve performance in aggregations ·         Optimize data models to achieve better compression ·         Measure DAX query performance with DAX Studio and learn how to optimize your DAX 

28

FileMaker & You, Volume 1 - Michael Rocharde Cover Art

FileMaker & You, Volume 1

FileMaker & You, Volume 1 Advanced FileMaker™ Techniques for Beginners to Intermediate + by Michael Rocharde

Learning FileMaker™ is a lifelong journey and, along the way, we come up with better ways of doing things. We learn to adapt and think outside the box. Written primarily for the novice to intermediate (and especially in-house) developers this book teaches by the use of case studies and walks you through the process of solving each.  With lots of videos, expert level tips and tricks plus sample files that you can tear down, this is an essential resource for anybody wanting to reduce their learning curve. Michael Rocharde has been a full-time professional FileMaker developer since 1987 and he's been writing about FileMaker since the mid-1990s. This is his 2nd book on FileMaker; the first one was published in April 2012 and has sold over 1000 copies in 23 countries.

29

Microsoft Power BI For Dummies - Jack A. Hyman Cover Art

Microsoft Power BI For Dummies

Microsoft Power BI For Dummies by Jack A. Hyman

Reveal the insights behind your company’s data with Microsoft Power BI  Microsoft Power BI allows intuitive access to data that can power intelligent business decisions and insightful strategies. The question is, do you have the Power BI skills to make your organization’s numbers spill their secrets?  In  Microsoft Power BI For Dummies , expert lecturer, consultant, and author Jack Hyman delivers a start-to-finish guide to applying the Power BI platform to your own firm’s data. You’ll discover how to start exploring your data sources, build data models, visualize your results, and create compelling reports that motivate decisive action.  Tackle the basics of Microsoft Power BI and, when you’re done with that, move on to advanced functions like accessing data with DAX and app integrations  Guide your organization’s direction and decisions with rock-solid conclusions based on real-world data  Impress your bosses and confidently lead your direct reports with exciting insights drawn from Power BI’s useful visualization tools  It’s one thing for your company to have data at its disposal. It’s another thing entirely to know what to do with it.  Microsoft Power BI For Dummies  is the straightforward blueprint you need to apply one of the most powerful business intelligence tools on the market to your firm’s existing data.  

30

Cool Infographics - Randy Krum Cover Art

Cool Infographics

Cool Infographics Effective Communication with Data Visualization and Design by Randy Krum

Make information memorable with creative visual design techniques Research shows that visual information is more quickly and easily understood, and much more likely to be remembered. This innovative book presents the design process and the best software tools for creating infographics that communicate. Including a special section on how to construct the increasingly popular infographic resume, the book offers graphic designers, marketers, and business professionals vital information on the most effective ways to present data. Explains why infographics and data visualizations work Shares the tools and techniques for creating great infographics Covers online infographics used for marketing, including social media and search engine optimization (SEO) Shows how to market your skills with a visual, infographic resume Explores the many internal business uses of infographics, including board meeting presentations, annual reports, consumer research statistics, marketing strategies, business plans, and visual explanations of products and services to your customers With Cool Infographics , you'll learn to create infographics to successfully reach your target audience and tell clear stories with your data.

31

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes - Ben Forta Cover Art

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes by Ben Forta

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through 10-minute lessons, you’ll learn everything you need to know to take advantage of Microsoft SQL Server’s T-SQL language. This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, XML, and much more. You’ll learn what you need to know methodically, systematically, and simply–in highly focused lessons designed to make you immediately and effortlessly productive. Tips point out shortcuts and solutions Cautions help you avoid common pitfalls Notes explain additional concepts, and provide additional information 10 minutes is all you need to learn how to… Use T-SQL in the Microsoft SQL Server environment Construct complex T-SQL statements using multiple clauses and operators Filter data so you get the information you need quickly Retrieve, sort, and format database contents Join two or more related tables Make SQL Server work for you with globalization and localization Create subqueries to pinpoint your data Automate your workload with triggers Create and alter database tables Work with views, stored procedures, and more  Register your book at www.samspublishing.com/register to download examples and source code from this book.

32

Effective Data Storytelling - Brent Dykes Cover Art

Effective Data Storytelling

Effective Data Storytelling How to Drive Change with Data, Narrative and Visuals by Brent Dykes

Master the art and science of data storytelling—with frameworks and techniques to help you craft compelling stories with data. The ability to effectively communicate with data is no longer a luxury in today’s economy; it is a necessity. Transforming data into visual communication is only one part of the picture. It is equally important to engage your audience with a narrative—to tell a story with the numbers. Effective Data Storytelling will teach you the essential skills necessary to communicate your insights through persuasive and memorable data stories. Narratives are more powerful than raw statistics, more enduring than pretty charts. When done correctly, data stories can influence decisions and drive change. Most other books focus only on data visualization while neglecting the powerful narrative and psychological aspects of telling stories with data. Author Brent Dykes shows you how to take the three central elements of data storytelling—data, narrative, and visuals—and combine them for maximum effectiveness. Taking a comprehensive look at all the elements of data storytelling, this unique book will enable you to: Transform your insights and data visualizations into appealing, impactful data stories Learn the fundamental elements of a data story and key audience drivers Understand the differences between how the brain processes facts and narrative Structure your findings as a data narrative, using a four-step storyboarding process Incorporate the seven essential principles of better visual storytelling into your work Avoid common data storytelling mistakes by learning from historical and modern examples Effective Data Storytelling: How to Drive Change with Data, Narrative and Visuals is a must-have resource for anyone who communicates regularly with data, including business professionals, analysts, marketers, salespeople, financial managers, and educators.

33

Data Science from Scratch - Joel Grus Cover Art

Data Science from Scratch

Data Science from Scratch First Principles with Python by Joel Grus

Data science libraries, frameworks, modules, and toolkits are great for doing data science, but they’re also a good way to dive into the discipline without actually understanding data science. With this updated second edition, you’ll learn how many of the most fundamental data science tools and algorithms work by implementing them from scratch. If you have an aptitude for mathematics and some programming skills, author Joel Grus will help you get comfortable with the math and statistics at the core of data science, and with hacking skills you need to get started as a data scientist. Today’s messy glut of data holds answers to questions no one’s even thought to ask. This book provides you with the know-how to dig those answers out.

34

Access 2010 Programmer's Reference - Teresa Hennig, Rob Cooper, Geoffrey L. Griffith & Jerry Dennison Cover Art

Access 2010 Programmer's Reference

Access 2010 Programmer's Reference by Teresa Hennig, Rob Cooper, Geoffrey L. Griffith & Jerry Dennison

A comprehensive guide to programming for Access 2010 and 2007   Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements. With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic. Access 2010 Programmer's Reference is a comprehensive guide to the best-of-breed techniques for programming Access applications. Coverage Includes: Introduction to Microsoft Access 2010 New Features Upgrading and Converting to Access 2010 Macros in Access 2010 Using the VBA Editor VBA Basics Using VBA in Access Creating Classes in VBA Extending VBA with APIs Working with the Windows Registry Using DAO to Access Data Using ADO to Access Data Using SQL with VBA Using VBA to Enhance Forms Enhancing Reports with VBA Customizing the Ribbon Customizing the Office Backstage Working with Office 2010 Working with SharePoint Working with .NET Building Client-Server Applications with Access The Access 2010 Templates Access Runtime Deployment Database Security Access 2010 Security Features

35

Mathletics - Wayne L. Winston, Scott Nestler & Konstantinos Pelechrinis Cover Art

Mathletics

Mathletics How Gamblers, Managers, and Fans Use Mathematics in Sports, Second Edition by Wayne L. Winston, Scott Nestler & Konstantinos Pelechrinis

How to use math to improve performance and predict outcomes in professional sports Mathletics reveals the mathematical methods top coaches and managers use to evaluate players and improve team performance, and gives math enthusiasts the practical skills they need to enhance their understanding and enjoyment of their favorite sports—and maybe even gain the outside edge to winning bets. This second edition features new data, new players and teams, and new chapters on soccer, e-sports, golf, volleyball, gambling Calcuttas, analysis of camera data, Bayesian inference, ridge regression, and other statistical techniques. After reading Mathletics , you will understand why baseball teams should almost never bunt; why football overtime systems are unfair; why points, rebounds, and assists aren’t enough to determine who’s the NBA’s best player; and more.

36

SQL in 10 Minutes a Day, Sams Teach Yourself - Ben Forta Cover Art

SQL in 10 Minutes a Day, Sams Teach Yourself

SQL in 10 Minutes a Day, Sams Teach Yourself by Ben Forta

Just the parts of SQL you need to know from simple data retrieval to the use of SQL joins, subqueries, stored procedures, cursors, triggers, and table constraints Designed for anyone interacting with databases, this SQL book methodically, systematically, and simply teaches you in lessons that each take 10 minutes or less to complete. Lessons include SQL statements, including complex SQL statements using multiple clauses and operators Data management: retrieve, sort, and format database contents, including inserting, updating, and deleting Data analytics: Pinpoint the data you need using a variety of filtering techniques and aggregate functions to summarize data Tables: create, alter, and join database tables Views Stored procedures Expert trainer and popular author Ben Forta created this book for most of us who just need to learn SQL and do not need to understand database design and normalization to relational database theory and administrative concerns. Each lesson includes Full-color code examples to help you understand how SQL statements are structured Tips that point out shortcuts and solutions Cautions to help you avoid common pitfalls Notes that explain additional concepts, and provide additional information

37

SQL Programming & Database Management For Absolute Beginners SQL Server, Structured Query Language Fundamentals: "Learn - By Doing" Approach And Master SQL - William Sullivan Cover Art

SQL Programming & Database Management For Absolute Beginners SQL Server, Structured Query Language Fundamentals: "Learn - By Doing" Approach And Master SQL

SQL Programming & Database Management For Absolute Beginners SQL Server, Structured Query Language Fundamentals: "Learn - By Doing" Approach And Master SQL by William Sullivan

SQL Made Easy- The Ultimate Step by Step Guide To Success Do you want to learn SQL programming without the complicated explanations? Do you want to understand how to manage databases without all the confusion? Well than, this is your go to guide to help you master SQL programming in no time!  This book breaks down the fundamentals elements that are essential to make you proficient in SQL programming and database management. By the end of this book you will be confident enough to take on any problems that encompass SQL.  SQL software can be complex, but a powerful tool if used with the right understanding. In this book you will discover how SQL is simple, flexible, portable and most of all well integrated to various database applications.  The demand for SQL professionals is  HUGE and the opportunities are endless! Learn how to easily master it  and land yourself high grade paying jobs or free-lance work.  Entry level positions in the US can easily earn $90,000+ USD salary. - That's almost six figures! The demand for these desirable skill sets are high, so become familiar with SQL ASAP.  What Sets This Book Apart From The Rest? This is most comprehensive and detailed book out for beginners to use. Complicated subject matter is simplified in an easy to read  structured fashion that increases the knowledge retention and real world application capacity for any reader. Normal SQL books on the market can be expensive, but, this book gives you so much immense value and is far superior than any book out there for beginners. Why not start off at an affordable price? Don't miss out on this opportunity! What You'll Learn SQL and its uses Data definition language statements Detailed keywords, statements, commands and functions, and how to put them to use in specific or altered ways Data query language statements How to use each formula in real life situations Transactional control commands Terminology, syntax and expressions Understanding Cursors, Triggers and Errors And, much, much more The amount of value you receive is immense and the return on investment is exponential. Make the greatest investment in yourself by starting yourself off the right way today From the examples, images, and step by step guide instructions you can have the assurance that you will be on the right path to mastery and long term success in SQL programming and database management. What are you waiting for? Take advantage this opportunity while you still can. Grab your copy now!

38

Using Microsoft Access 2010, Enhanced Edition - Alison Balter Cover Art

Using Microsoft Access 2010, Enhanced Edition

Using Microsoft Access 2010, Enhanced Edition by Alison Balter

*** This USING Microsoft Access 2010 book is enhanced with 4.5 hours of FREE step-by-step VIDEO TUTORIALS and AUDIO SIDEBARS!  ***  Microsoft Access 2010 is a relational database perfect for any collection of information that allows you to create tables, queries, forms, reports, macros, and modules for that data.        USING Microsoft Access 2010 is a media-rich learning experience designed to help new users master Microsoft Access 2010 quickly, and get the most out of it, fast!  EVERY chapter has multiple video and audio files integrated into the learning material which creates interactive content that works together to teach everything mainstream Microsoft Access 2010 users need to know.  You’ll Learn How to: -          Manipulate Data with Databases and Tables -          Use Queries to Retrieve the Data You Need -          Use Forms to Enter and Edit Table Data -          Use Reports to Print Information  -          Create Your own Tables and Databases -          Relate the Information in Your Database -          Enhance the Databases you Build -          Build Powerful Forms or Reports -          Automate Your Database with Macros -          Share Data with other Applications -          Work with Web Databases Examples of Topics Covered in VIDEO TUTORIALS, which Walk You Through Tasks You’ve Just Got to See! -          Filtering Form Data -          Adding Fields to Queries -          The Basics of Creating and Running a Macro   Examples of Topics Covered in AUDIO SIDEBARS, which Deliver Insights Straight From the Experts! -          Updatability of Query Results -          Uses for Forms -          Building Queries Based on Multiple Tables Please note that due to the incredibly rich media included in your Enhanced eBook, you may experience longer download times. Please be patient while your product is delivered. This Enhanced eBook has been developed to match the Apple Enhanced eBook specifications for the iPad and may not render well on older iPhones or iPods or perform on other devices or reader applications.

39

MySQL Pocket Reference - George Reese Cover Art

MySQL Pocket Reference

MySQL Pocket Reference SQL Functions and Utilities by George Reese

To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly. Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains: How to configure MySQL, such as setting the root passwordMySQL data types, including numerics, strings, dates, and complex typesSQL syntax, commands, data types, operators, and functionsArithmetic, comparison and logical operatorsAggregate and general functionsStored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggersYou don't have time to stop and thumb through an exhaustive reference when you're hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the MySQL Pocket Reference is the book you want to have.

40

The Numerati - Stephen Baker Cover Art

The Numerati

The Numerati by Stephen Baker

Learn how the crisis over digital privacy and manipulation evolved in this “utterly fascinating” look at the growth of data mining and analysis ( Seattle Post-Intelligencer ).   Award-winning journalist Stephen Baker traces the rise of the “global math elite”: computer scientists who invent ways to not only record our behavior, but also to predict and alter it. Nowadays, we don’t need to be online to create a digital trail; we do it simply by driving through an automated tollbooth or shopping with a credit card. As massive amounts of information are collected, sifted, and analyzed, we all become targets of those who want to influence everything from what we buy to how we vote.   Clear and “highly readable,” The Numerati is a look at the origins of our present-day world, the possibilities of the future, and those who—whether with good or bad intentions—profile us as workers, consumers, citizens, or potential terrorists ( The Wall Street Journal ).    

41

The Data Warehouse Lifecycle Toolkit - Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy & Bob Becker Cover Art

The Data Warehouse Lifecycle Toolkit

The Data Warehouse Lifecycle Toolkit by Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy & Bob Becker

A thorough update to the industry standard for designing, developing, and deploying data warehouse and business intelligence systems The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. In that time, the data warehouse industry has reached full maturity and acceptance, hardware and software have made staggering advances, and the techniques promoted in the premiere edition of this book have been adopted by nearly all data warehouse vendors and practitioners. In addition, the term "business intelligence" emerged to reflect the mission of the data warehouse: wrangling the data out of source systems, cleaning it, and delivering it to add value to the business. Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. The authors understand first-hand that a data warehousing/business intelligence (DW/BI) system needs to change as fast as its surrounding organization evolves. To that end, they walk you through the detailed steps of designing, developing, and deploying a DW/BI system. You'll learn to create adaptable systems that deliver data and analyses to business users so they can make better business decisions.

42

Developing Analytic Talent - Vincent Granville Cover Art

Developing Analytic Talent

Developing Analytic Talent Becoming a Data Scientist by Vincent Granville

Learn what it takes to succeed in the the most in-demand tech job Harvard Business Review calls it the sexiest tech job of the 21st century. Data scientists are in demand, and this unique book shows you exactly what employers want and the skill set that separates the quality data scientist from other talented IT professionals. Data science involves extracting, creating, and processing data to turn it into business value. With over 15 years of big data, predictive modeling, and business analytics experience, author Vincent Granville is no stranger to data science. In this one-of-a-kind guide, he provides insight into the essential data science skills, such as statistics and visualization techniques, and covers everything from analytical recipes and data science tricks to common job interview questions, sample resumes, and source code. The applications are endless and varied: automatically detecting spam and plagiarism, optimizing bid prices in keyword advertising, identifying new molecules to fight cancer, assessing the risk of meteorite impact. Complete with case studies, this book is a must, whether you're looking to become a data scientist or to hire one. Explains the finer points of data science, the required skills, and how to acquire them, including analytical recipes, standard rules, source code, and a dictionary of terms Shows what companies are looking for and how the growing importance of big data has increased the demand for data scientists Features job interview questions, sample resumes, salary surveys, and examples of job ads Case studies explore how data science is used on Wall Street, in botnet detection, for online advertising, and in many other business-critical situations Developing Analytic Talent: Becoming a Data Scientist is essential reading for those aspiring to this hot career choice and for employers seeking the best candidates.

43

Fundamentals of Data Engineering - Joe Reis & Matt Housley Cover Art

Fundamentals of Data Engineering

Fundamentals of Data Engineering by Joe Reis & Matt Housley

Data engineering has grown rapidly in the past decade, leaving many software engineers, data scientists, and analysts looking for a comprehensive view of this practice. With this practical book, you'll learn how to plan and build systems to serve the needs of your organization and customers by evaluating the best technologies available through the framework of the data engineering lifecycle. Authors Joe Reis and Matt Housley walk you through the data engineering lifecycle and show you how to stitch together a variety of cloud technologies to serve the needs of downstream data consumers. You'll understand how to apply the concepts of data generation, ingestion, orchestration, transformation, storage, and governance that are critical in any data environment regardless of the underlying technology. This book will help you: Get a concise overview of the entire data engineering landscapeAssess data engineering problems using an end-to-end framework of best practicesCut through marketing hype when choosing data technologies, architecture, and processesUse the data engineering lifecycle to design and build a robust architectureIncorporate data governance and security across the data engineering lifecycle

44

Designing Data Visualizations - Noah Iliinsky & Julie Steele Cover Art

Designing Data Visualizations

Designing Data Visualizations Representing Informational Relationships by Noah Iliinsky & Julie Steele

Data visualization is an efficient and effective medium for communicating large amounts of information, but the design process can often seem like an unexplainable creative endeavor. This concise book aims to demystify the design process by showing you how to use a linear decision-making process to encode your information visually. Delve into different kinds of visualization, including infographics and visual art, and explore the influences at work in each one. Then learn how to apply these concepts to your design process. Learn data visualization classifications, including explanatory, exploratory, and hybridDiscover how three fundamental influences—the designer, the reader, and the data—shape what you createLearn how to describe the specific goal of your visualization and identify the supporting dataDecide the spatial position of your visual entities with axesEncode the various dimensions of your data with appropriate visual properties, such as shape and colorSee visualization best practices and suggestions for encoding various specific data types

45

Storytelling with Data - Cole Nussbaumer Knaflic Cover Art

Storytelling with Data

Storytelling with Data Let's Practice! by Cole Nussbaumer Knaflic

Influence action through data! This is not a book. It is a one-of-a-kind immersive learning experience through which you can become—or teach others to be—a powerful data storyteller. Let’s practice! helps you build confidence and credibility to create graphs and visualizations that make sense and weave them into action-inspiring stories. Expanding upon best seller storytelling with data ’s foundational lessons, Let’s practice! delivers fresh content, a plethora of new examples, and over 100 hands-on exercises. Author and data storytelling maven Cole Nussbaumer Knaflic guides you along the path to hone core skills and become a well-practiced data communicator. Each chapter includes: ● Practice with Cole: exercises based on real-world examples first posed for you to consider and solve, followed by detailed step-by-step illustration and explanation ● Practice on your own: thought-provoking questions and even more exercises to be assigned or worked through individually, without prescribed solutions ● Practice at work: practical guidance and hands-on exercises for applying storytelling with data lessons on the job, including instruction on when and how to solicit useful feedback and refine for greater impact The lessons and exercises found within this comprehensive guide will empower you to master—or develop in others—data storytelling skills and transition your work from acceptable to exceptional. By investing in these skills for ourselves and our teams, we can all tell inspiring and influential data stories!

46

The Data Warehouse ETL Toolkit - Ralph Kimball & Joe Caserta Cover Art

The Data Warehouse ETL Toolkit

The Data Warehouse ETL Toolkit Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data by Ralph Kimball & Joe Caserta

Cowritten by Ralph Kimball, the world's leading data warehousing authority, whose previous books have sold more than 150,000 copies Delivers real-world solutions for the most time- and labor-intensive portion of data warehousing-data staging, or the extract, transform, load (ETL) process Delineates best practices for extracting data from scattered sources, removing redundant and inaccurate data, transforming the remaining data into correctly formatted data structures, and then loading the end product into the data warehouse Offers proven time-saving ETL techniques, comprehensive guidance on building dimensional structures, and crucial advice on ensuring data quality

47

Teach Yourself VISUALLY Access 2010 - Faithe Wempen Cover Art

Teach Yourself VISUALLY Access 2010

Teach Yourself VISUALLY Access 2010 by Faithe Wempen

The visual way to get up to speed on Access 2010 It's one thing to gain access to Access. It's another thing entirely to figure out how to do all the things you want to do in Access, because the software is not all that intuitive. This full-color guide clearly shows you how to get the most out of Access 2010, including how to enter new records; create, edit, and design tables and forms; organize, analyze, and share data; generate concise reports; and much more. With pages of step-by-step instructions, graphics, and helpful advice, this is the visual learner's Access book-keep this on your desk and flip to what you need, any time! Explores the very latest features, functions, and tools of Access 2010, a database software tool that is part of the new Microsoft Office 2010 Teaches you how to enter new records and create, edit, and design tables and forms Explains how to organize, analyze, and share data; generate concise reports; add smart tags to tables, save backup copies of your data; and more Demonstrates through step-by-step instructions and numerous, full-color screen shots and graphics, so you can see exactly how to perform tasks This unparalleled book contains everything you need to know to use Access 2010 effectively.

48

HBase: The Definitive Guide - Lars George Cover Art

HBase: The Definitive Guide

HBase: The Definitive Guide Random Access to Your Planet-Size Data by Lars George

If you're looking for a scalable storage solution to accommodate a virtually endless amount of data, this book shows you how Apache HBase can fulfill your needs. As the open source implementation of Google's BigTable architecture, HBase scales to billions of rows and millions of columns, while ensuring that write and read performance remain constant. Many IT executives are asking pointed questions about HBase. This book provides meaningful answers, whether you’re evaluating this non-relational database or planning to put it into practice right away. Discover how tight integration with Hadoop makes scalability with HBase easierDistribute large datasets across an inexpensive cluster of commodity serversAccess HBase with native Java clients, or with gateway servers providing REST, Avro, or Thrift APIsGet details on HBase’s architecture, including the storage format, write-ahead log, background processes, and moreIntegrate HBase with Hadoop's MapReduce framework for massively parallelized data processing jobsLearn how to tune clusters, design schemas, copy tables, import bulk data, decommission nodes, and many other tasks

49

Crystal Reports 2008 For Dummies - Allen G. Taylor Cover Art

Crystal Reports 2008 For Dummies

Crystal Reports 2008 For Dummies by Allen G. Taylor

A report is only useful if those who receive it understand what it means. Knowing how to use Crystal Reports gives you the edge in producing reports from your database that really are crystal clear. Crystal Reports 2008 For Dummies is a quick and easy guide to get you going with the latest version of this bestselling report-writing software. In fact, it’s so popular that previous editions have made it a bestseller too. Crystal Reports 2008 For Dummies gives you just what you should know to produce the reports you’ll need most often, including how to: Pull specific information from your database, sort and group it, and find the details you need Use dynamic or cascading prompts Troubleshoot and print reports and save time with templates View reports on your LAN Write formulas to retrieve specific information Create and update OLAP reports Format reports, control page breaks, and even add graphics or Flash files Enhance your reports with charts and maps Use Crystal Reports in the enterprise There’s also a companion Web site with sample reports from the book and links to sites with more related information. With Crystal Reports 2008 For Dummies by your side, you’ll soon be able to create reports from simple to spectacular, whenever the need arises.

50

R for Everyone - Jared P. Lander Cover Art

R for Everyone

R for Everyone Advanced Analytics and Graphics by Jared P. Lander

Statistical Computation for Programmers, Scientists, Quants, Excel Users, and Other Professionals Using the open source R language, you can build powerful statistical models to answer many of your most challenging questions. R has traditionally been difficult for non-statisticians to learn, and most R books assume far too much knowledge to be of help. R for Everyone is the solution. Drawing on his unsurpassed experience teaching new users, professional data scientist Jared P. Lander has written the perfect tutorial for anyone new to statistical programming and modeling. Organized to make learning easy and intuitive, this guide focuses on the 20 percent of R functionality you’ll need to accomplish 80 percent of modern data tasks. Lander’s self-contained chapters start with the absolute basics, offering extensive hands-on practice and sample code. You’ll download and install R; navigate and use the R environment; master basic program control, data import, and manipulation; and walk through several essential tests. Then, building on this foundation, you’ll construct several complete models, both linear and nonlinear, and use some data mining techniques. By the time you’re done, you won’t just know how to write R programs, you’ll be ready to tackle the statistical problems you care about most. COVERAGE INCLUDES • Exploring R, RStudio, and R packages • Using R for math: variable types, vectors, calling functions, and more • Exploiting data structures, including data.frames, matrices, and lists • Creating attractive, intuitive statistical graphics • Writing user-defined functions • Controlling program flow with if, ifelse, and complex checks • Improving program efficiency with group manipulations • Combining and reshaping multiple datasets • Manipulating strings using R’s facilities and regular expressions • Creating normal, binomial, and Poisson probability distributions • Programming basic statistics: mean, standard deviation, and t-tests • Building linear, generalized linear, and nonlinear models • Assessing the quality of models and variable selection • Preventing overfitting, using the Elastic Net and Bayesian methods • Analyzing univariate and multivariate time series data • Grouping data via K-means and hierarchical clustering • Preparing reports, slideshows, and web pages with knitr • Building reusable R packages with devtools and Rcpp • Getting involved with the R global community

Books

Ebook Charts

Apple Books Ebook Best Sellers

Fiction Ebook Best Sellers

Non-Fiction Ebook Best Sellers

iTunes Audio Book Charts

Audiobook Best Sellers

iTunes Music Charts

Most Popular Music Charts

iTunes Movie Charts

Top Movies

iTunes TV Charts

Top Television Shows

iTunes iOS App Charts

Top iPhone Apps

Top iPad & iPad Mini Apps

International iTunes Charts