Storytelling with DataCole Nussbaumer Knaflic
The most popular and best selling computer database books at the Apple iBookstore.
Chart of the top computer database ebook best sellers was last updated:
Storytelling with DataCole Nussbaumer Knaflic
Don't simply show your data—tell a story with it! Storytelling with Data teaches you the fundamentals of data visualization and how to communicate effectively with data. You'll discover the power of storytelling and the way to make data a pivotal point in your story. The lessons in this illuminative text are grounded in theory, but made accessible through numerous real-world examples—ready for immediate application to your next graph or presentation. Storytelling is not an inherent skill, especially when it comes to data visualization, and the tools at our disposal don't make it any easier. This book demonstrates how to go beyond conventional tools to reach the root of your data, and how to use your data to create an engaging, informative, compelling story. Specifically, you'll learn how to: Understand the importance of context and audience Determine the appropriate type of graph for your situation Recognize and eliminate the clutter clouding your information Direct your audience's attention to the most important parts of your data Think like a designer and utilize concepts of design in data visualization Leverage the power of storytelling to help your message resonate with your audience Together, the lessons in this book will help you turn your data into high impact visual stories that stick with your audience. Rid your world of ineffective graphs, one exploding 3D pie chart at a time. There is a story in your data— Storytelling with Data will give you the skills and power to tell it!
Deep Learning IllustratedJon Krohn
"The authors’ clear visual style provides a comprehensive look at what’s currently possible with artificial neural networks as well as a glimpse of the magic that’s to come." – Tim Urban, author of Wait But Why Fully Practical, Insightful Guide to Modern Deep Learning Deep learning is transforming software, facilitating powerful new artificial intelligence capabilities, and driving unprecedented algorithm performance. Deep Learning Illustrated is uniquely intuitive and offers a complete introduction to the discipline’s techniques. Packed with full-color figures and easy-to-follow code, it sweeps away the complexity of building deep learning models, making the subject approachable and fun to learn. World-class instructor and practitioner Jon Krohn–with visionary content from Grant Beyleveld and beautiful illustrations by Aglaé Bassens–presents straightforward analogies to explain what deep learning is, why it has become so popular, and how it relates to other machine learning approaches. Krohn has created a practical reference and tutorial for developers, data scientists, researchers, analysts, and students who want to start applying it. He illuminates theory with hands-on Python code in accompanying Jupyter notebooks. To help you progress quickly, he focuses on the versatile deep learning library Keras to nimbly construct efficient TensorFlow models; PyTorch, the leading alternative library, is also covered. You’ll gain a pragmatic understanding of all major deep learning approaches and their uses in applications ranging from machine vision and natural language processing to image generation and game-playing algorithms. Discover what makes deep learning systems unique, and the implications for practitioners Explore new tools that make deep learning models easier to build, use, and improve Master essential theory: artificial neurons, training, optimization, convolutional nets, recurrent nets, generative adversarial networks (GANs), deep reinforcement learning, and more Walk through building interactive deep learning applications, and move forward with your own artificial intelligence projects Register your book for convenient access to downloads, updates, and/or corrections as they become available. See inside book for details.
Fundamentals of Data EngineeringJoe 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
Refactoring DatabasesScott W. Ambler
Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems. Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design–without changing semantics. You’ll learn how to evolve database schemas in step with source code–and become far more effective in projects relying on iterative, agile methodologies. This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments. The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase. Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost–and build database systems capable of evolving smoothly, far into the future.
Healthcare Analytics Made SimpleVikas “Vik” Kumar
Add a touch of data analytics to your healthcare systems and get insightful outcomes Key Features Perform healthcare analytics with Python and SQL Build predictive models on real healthcare data with pandas and scikit-learn Use analytics to improve healthcare performance Book Description In recent years, machine learning technologies and analytics have been widely utilized across the healthcare sector. Healthcare Analytics Made Simple bridges the gap between practising doctors and data scientists. It equips the data scientists' work with healthcare data and allows them to gain better insight from this data in order to improve healthcare outcomes. This book is a complete overview of machine learning for healthcare analytics, briefly describing the current healthcare landscape, machine learning algorithms, and Python and SQL programming languages. The step-by-step instructions teach you how to obtain real healthcare data and perform descriptive, predictive, and prescriptive analytics using popular Python packages such as pandas and scikit-learn. The latest research results in disease detection and healthcare image analysis are reviewed. By the end of this book, you will understand how to use Python for healthcare data analysis, how to import, collect, clean, and refine data from electronic health record (EHR) surveys, and how to make predictive models with this data through real-world algorithms and code examples. What you will learn Gain valuable insight into healthcare incentives, finances, and legislation Discover the connection between machine learning and healthcare processes Use SQL and Python to analyze data Measure healthcare quality and provider performance Identify features and attributes to build successful healthcare models Build predictive models using real-world healthcare data Become an expert in predictive modeling with structured clinical data See what lies ahead for healthcare analytics Who this book is for Healthcare Analytics Made Simple is for you if you are a developer who has a working knowledge of Python or a related programming language, although you are new to healthcare or predictive modeling with healthcare data. Clinicians interested in analytics and healthcare computing will also benefit from this book. This book can also serve as a textbook for students enrolled in an introductory course on machine learning for healthcare.
The Data Warehouse ToolkitRalph 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 .
Access 2016: Up To SpeedR.M. Hyttinen
The Access 2016: Up To Speed guide helps you to get up and running quickly with the world's most popular database program. This handy step-by-step guide is written from scratch, starting with basic Access and database topics and moving on to more advanced features of application, designed to help you to become more productive more quickly. Though comprehensive, the information in this book is presented in a clear, consise manner with screenshots providing helpful visual guidance all along the way. In no time at all you're be creating, storing and managing databases, creating forms, generating reports, updating data using queries, maintaining databases and much more. Some of the topics include: Understanding Databases Using Database Templates The Access Environment A Look at Tables, Forms, Queries and Reports Creating a Table using Application Parts Entering Data into a Table Adding New Fields to a Table Creating a Table from Scratch Setting a Primary Key Rearranging, Inserting and Deleting Fields Setting Validation Rules Formatting Fields Creating an Input Mask Creating a Lookup Field Creating & Modifying a Value List Creating Calculated Fields Creating Multiple Primary Keys Creating Multiple Field Values Editing & Formatting Table Data Importing Excel Data into an Existing Table Importing a Text File into a New Table Selecting, Sorting and Deleting Records Finding and Replacing Data Filtering Data Creating a Query in Design View Adding Criteria to a Query Sorting Data in a Query Using the Query Wizard Creating Multi-Table Queries Using Calculations in Queries Changing Query Properties Creating a Totals Query Creating a Parameter Query Prompting for Dates Creating a Find Duplicates Query Using the Form Wizard Adding Controls to a Form Moving and Sizing Controls Creating a Calculated Control Changing Control Properties Changing Form Properties Changing the Tab Order Adding a Lookup Control Creating a Basic Report Using the Report Wizard Using the Label Wizard Adding Controls to a Report Sorting and Grouping Data Applying Conditional Formatting Edit Sorting and Grouping Levels in a Report Creating and Updating Database Relationships Enforcing Referential Integrity Creating a Macro Creating & Using a Macro Group The AutoExec Macro Creating an AutoKeys Macro Creating a Make-Table Query Creating an Append Query Creating an Update Query Creating a Delete Query Creating a SQL Query Importing Data Linking Data Exporting Data Exporting Data to a Microsoft Word Mail Merge Using Compact and Repair Changing Database Properties Backing up a Database Splitting a Database Setting a Database Password ....and more
Fundamentals of Data VisualizationClaus O. Wilke
Effective visualization is the best way to communicate information from the increasingly large and complex datasets in the natural and social sciences. But with the increasing power of visualization software today, scientists, engineers, and business analysts often have to navigate a bewildering array of visualization choices and options. This practical book takes you through many commonly encountered visualization problems, and it provides guidelines on how to turn large datasets into clear and compelling figures. What visualization type is best for the story you want to tell? How do you make informative figures that are visually pleasing? Author Claus O. Wilke teaches you the elements most critical to successful data visualization. Explore the basic concepts of color as a tool to highlight, distinguish, or represent a valueUnderstand the importance of redundant coding to ensure you provide key information in multiple waysUse the book’s visualizations directory, a graphical guide to commonly used types of data visualizationsGet extensive examples of good and bad figuresLearn how to use figures in a document or report and how employ them effectively to tell a compelling story
Python for Finance CookbookEryk Lewinson
Solve common and not-so-common financial problems using Python libraries such as NumPy, SciPy, and pandas Key Features Use powerful Python libraries such as pandas, NumPy, and SciPy to analyze your financial data Explore unique recipes for financial data analysis and processing with Python Estimate popular financial models such as CAPM and GARCH using a problem-solution approach Book Description Python is one of the most popular programming languages used in the financial industry, with a huge set of accompanying libraries. In this book, you'll cover different ways of downloading financial data and preparing it for modeling. You'll calculate popular indicators used in technical analysis, such as Bollinger Bands, MACD, RSI, and backtest automatic trading strategies. Next, you'll cover time series analysis and models, such as exponential smoothing, ARIMA, and GARCH (including multivariate specifications), before exploring the popular CAPM and the Fama-French three-factor model. You'll then discover how to optimize asset allocation and use Monte Carlo simulations for tasks such as calculating the price of American options and estimating the Value at Risk (VaR). In later chapters, you'll work through an entire data science project in the financial domain. You'll also learn how to solve the credit card fraud and default problems using advanced classifiers such as random forest, XGBoost, LightGBM, and stacked models. You'll then be able to tune the hyperparameters of the models and handle class imbalance. Finally, you'll focus on learning how to use deep learning (PyTorch) for approaching financial tasks. By the end of this book, you'll have learned how to effectively analyze financial data using a recipe-based approach. What you will learn Download and preprocess financial data from different sources Backtest the performance of automatic trading strategies in a real-world setting Estimate financial econometrics models in Python and interpret their results Use Monte Carlo simulations for a variety of tasks such as derivatives valuation and risk assessment Improve the performance of financial models with the latest Python libraries Apply machine learning and deep learning techniques to solve different financial problems Understand the different approaches used to model financial time series data Who this book is for This book is for financial analysts, data analysts, and Python developers who want to learn how to implement a broad range of tasks in the finance domain. Data scientists looking to devise intelligent financial strategies to perform efficient financial analysis will also find this book useful. Working knowledge of the Python programming language is mandatory to grasp the concepts covered in the book effectively.
Hands-On Data Analysis with PandasStefanie Molin
Get to grips with pandas—a versatile and high-performance Python library for data manipulation, analysis, and discovery Key Features Perform efficient data analysis and manipulation tasks using pandas Apply pandas to different real-world domains using step-by-step demonstrations Get accustomed to using pandas as an effective data exploration tool Book Description Data analysis has become a necessary skill in a variety of positions where knowing how to work with data and extract insights can generate significant value. Hands-On Data Analysis with Pandas will show you how to analyze your data, get started with machine learning, and work effectively with Python libraries often used for data science, such as pandas, NumPy, matplotlib, seaborn, and scikit-learn. Using real-world datasets, you will learn how to use the powerful pandas library to perform data wrangling to reshape, clean, and aggregate your data. Then, you will learn how to conduct exploratory data analysis by calculating summary statistics and visualizing the data to find patterns. In the concluding chapters, you will explore some applications of anomaly detection, regression, clustering, and classification, using scikit-learn, to make predictions based on past data. By the end of this book, you will be equipped with the skills you need to use pandas to ensure the veracity of your data, visualize it for effective decision-making, and reliably reproduce analyses across multiple datasets. What you will learn Understand how data analysts and scientists gather and analyze data Perform data analysis and data wrangling in Python Combine, group, and aggregate data from multiple sources Create data visualizations with pandas, matplotlib, and seaborn Apply machine learning (ML) algorithms to identify patterns and make predictions Use Python data science libraries to analyze real-world datasets Use pandas to solve common data representation and analysis problems Build Python scripts, modules, and packages for reusable analysis code Who this book is for This book is for data analysts, data science beginners, and Python developers who want to explore each stage of data analysis and scientific computing using a wide range of datasets. You will also find this book useful if you are a data scientist who is looking to implement pandas in machine learning. Working knowledge of Python programming language will be beneficial.
97 Things Every Data Engineer Should KnowTobias Macey
Take advantage of today's sky-high demand for data engineers. With this in-depth book, current and aspiring engineers will learn powerful real-world best practices for managing data big and small. Contributors from notable companies including Twitter, Google, Stitch Fix, Microsoft, Capital One, and LinkedIn share their experiences and lessons learned for overcoming a variety of specific and often nagging challenges. Edited by Tobias Macey, host of the popular Data Engineering Podcast, this book presents 97 concise and useful tips for cleaning, prepping, wrangling, storing, processing, and ingesting data. Data engineers, data architects, data team managers, data scientists, machine learning engineers, and software engineers will greatly benefit from the wisdom and experience of their peers. Topics include: The Importance of Data Lineage - Julien Le DemData Security for Data Engineers - Katharine JarmulThe Two Types of Data Engineering and Data Engineers - Jesse AndersonSix Dimensions for Picking an Analytical Data Warehouse - Gleb MezhanskiyThe End of ETL as We Know It - Paul SingmanBuilding a Career as a Data Engineer - Vijay KiranModern Metadata for the Modern Data Stack - Prukalpa SankarYour Data Tests Failed! Now What? - Sam Bail
Pandas in ActionBoris 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
Access 2010 All-in-One For DummiesAlison 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!
The Model ThinkerScott 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.
Microsoft Office Access 2007 All-in-One Desk Reference For DummiesAlan 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
Access 2013 All-in-One For DummiesAlison Barrows, Joseph C. Stockman & Allen G. Taylor
Get started with the new Access 2013 with this impressive all-in-one reference! Microsoft Access allows you to store, organize, view, analyze, and share data; the new release enables you to build even more powerful, custom database solutions that integrate with the web and enterprise data sources. This compilation of nine indispensible minibooks is exactly what you need to get up to speed on the latest changes to Access. This easy-to-understand resource provides both new and experienced Access users with invaluable advice for connecting Access to SQL Server, manipulating data locally, getting up to speed on the latest features of Access 2013, creating queries and macros, and much more. From the basics to advanced functions, this book is what you need to make Access more accessible. Shows you how to store, organize, view, analyze, and share data using Access 2013 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 solutions Offers plenty of techniques, tips, and tricks to help you get the most out of Access This all-in-one guide offers you access to all things Access 2013!
FileMaker Pro Design and Scripting For DummiesTimothy 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
SQL in 10 Minutes, Sams Teach YourselfBen Forta
Sams Teach Yourself SQL in 10 Minutes, Fourth Edition New full-color code examples help you see how SQL statements are structured 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. 10 minutes is all you need to learn how to... Use the major SQL statements Construct complex SQL statements using multiple clauses and operators Retrieve, sort, and format database contents Pinpoint the data you need using a variety of filtering techniques Use aggregate functions to summarize data Join two or more related tables Insert, update, and delete data Create and alter database tables Work with views, stored procedures, and more Table of Contents 1 Understanding SQL 2 Retrieving Data 3 Sorting Retrieved Data 4 Filtering Data 5 Advanced Data Filtering 6 Using Wildcard Filtering 7 Creating Calculated Fields 8 Using Data Manipulation Functions 9 Summarizing Data 10 Grouping Data 11 Working with Subqueries 12 Joining Tables 13 Creating Advanced Joins 14 Combining Queries 15 Inserting Data 16 Updating and Deleting Data 17 Creating and Manipulating Tables 18 Using Views 19 Working with Stored Procedures 20 Managing Transaction Processing 21 Using Cursors 22 Understanding Advanced SQL Features Appendix A: Sample Table Scripts Appendix B: Working in Popular Applications Appendix C : SQL Statement Syntax Appendix D: Using SQL Datatypes Appendix E: SQL Reserved Words
FileMaker 12 In DepthJesse 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!
SQL in 30 PagesU.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.
Oracle 11g For DummiesChris Zeis, Chris Ruel & Michael Wessler
Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle. This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You’ll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running in tiptop form. Oracle 11g For Dummies covers: The building blocks behind the database engine as well as Oracle’s physical and logical structures Hardware, software, system, and storage requirements for implementation How to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX Daily and intermittent tasks necessary to keep your database running properly How to assess potential threats to your database, configure Oracle Recovery Manager, and set up backup and recovery procedures When to use online, offline, controlfile, and archivelog backups Troubleshooting methodology and how to use Oracle database logs and other diagnostic utilities Different ways to manage your database How to automate jobs with the Oracle Scheduler Using SQL in Oracle, and a great deal more Completely up to date for the newest release of Oracle, Oracle 11g For Dummies will give you both the information and the confidence to set up and maintain an Oracle database for your organization.
FileMaker 12 Developers ReferenceBob Bowers
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.
Access 2010 BibleMichael 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.
Data Warehousing For DummiesThomas 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!
Blockchain BasicsDaniel 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
Microsoft SQL Server 2008 All-in-One Desk Reference For DummiesRobert D. Schneider & Darril Gibson
If you’re in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you’ll find what’s new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You’ll discover how to: Build and maintain tables Design a database and communicate with it Retrieve, analyze, and report data Build solid, robust database applications Use the SQL Server Optimizer and Query Designer Navigate SQL Server with Visual Studio Develop useful reports with the Report Builder and Report Designer Create Business Intelligence solutions with Business Intelligence Development Studio Configure your server and perform major administrative tasks To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks: Essential Concepts Designing and Using Databases Interacting With Your Data Database Programming Reporting Services Analysis Services Performance Tips and Tricks Database Administration Appendixes Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!
Using FileMaker Bento, Enhanced EditionJesse 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.
Tableau For DummiesMolly Monsey & Paul Sochan
Make your data work for you! Tableau For Dummies brings order to the chaotic world of data. Understanding your data and organizing it into formats and visualizations that make sense to you are crucial to making a real impact on your business with the information that's already at your fingertips. This easy-to-use reference explores the user interface, and guides you through the process of connecting your data sources to the software. Additionally, this approachable, yet comprehensive text shows you how to use graphs, charts, and other images to bring visual interest to your data, how to create dashboards from multiple data sources, and how to export the visualizations that you have developed into multiple formats that translate into positive change for your business. The mission of Tableau Software is to grant you access to data that, when put into action, will help you build your company. Learning to use the data available to you helps you make informed, grounded business decisions that can spell success for your company. Navigate the user interface to efficiently access the features you need Connect to various spreadsheets, databases, and other data sources to create a multi-dimensional snapshot of your business Develop visualizations with easy to use drag and drop features Start building your data with templates and sample workbooks to spark your creativity and help you organize your information Tableau For Dummies is a step-by-step resource that helps you make sense of the data landscape—and put your data to work in support of your business.
Python Machine LearningSebastian 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.
Database Design for Mere MortalsMichael J. 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.
Crystal Reports 10 For DummiesAllen 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.
MySQL 5 EssentialsNeil 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.
Blockchain For DummiesTiana 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.
The Definitive Guide to DAXAlberto 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
Cool InfographicsRandy 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.
FileMaker & You, Volume 1Michael 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.
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 MinutesBen 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.
Microsoft SQL Server 2008 R2 UnleashedRay Rankins
This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. It presents start-to-finish coverage of SQL Server’s core database server and management capabilities, plus complete introductions to Integration, Reporting, and Analysis Services, application development, and much more. Four expert SQL Server administrators, developers, and consultants have packed this book with real-world information, tips, guidelines, and samples drawn from their own extensive experience creating and managing complex database solutions. Writing for intermediate-to-advanced-level SQL Server professionals, they focus on the product’s most complex and powerful capabilities, and its newest tools and features. For example, you’ll find invaluable information on administering SQL Server more efficiently, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning performance. The accompanying CD-ROM contains an extraordinary library of practical tools and information including sample databases and all code examples. Whether you’re responsible for SQL Server 2008 analysis, design, implementation, support, administration, or troubleshooting, no other book offers you this much value. Understand the Microsoft SQL Server 2008 environment, R2’s newest features, and each edition’s capabilities Manage SQL Server 2008 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell Efficiently manage security, users, backup/restore, replication, Database Mail, and database objects—from tables and indexes to stored procedures and triggers Increase availability with clustering, database mirroring, and other features Use new Policy-Based Management to centrally configure and operate SQL Server throughout the organization Use SQL Server Profiler to capture queries and identify bottlenecks Improve performance by optimizing queries, design more effective databases, and manage workloads with the new Resource Governor Develop applications using SQL Server 2008’s enhancements to T-SQL and SQLCLR, .NET integration, LINQ to SQL, XML, and XQuery Make the most of Analysis Services, Integration Services, and Reporting Services—especially Microsoft’s new R2 reporting improvements Improve data security using Column-level and Transparent Data Encryption CD-ROM includes: 15 additional chapters Code samples, scripts, and databases utilized within the book Free version of SQL Shot (performance & tuning software)
SQL Programming & Database Management For Absolute Beginners SQL Server, Structured Query Language Fundamentals: "Learn - By Doing" Approach And Master SQLWilliam 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!
Access 2010 Programmer's ReferenceTeresa 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
SysML DistilledLenny Delligatti
The Systems Modeling Language (SysML) extends UML with powerful systems engineering capabilities for modeling a wider spectrum of systems and capturing all aspects of a system’s design. SysML Distilled is the first clear, concise guide for everyone who wants to start creating effective SysML models. (Drawing on his pioneering experience at Lockheed Martin and NASA, Lenny Delligatti illuminates SysML’s core components and provides practical advice to help you create good models and good designs. Delligatti begins with an easy-to-understand overview of Model-Based Systems Engineering (MBSE) and an explanation of how SysML enables effective system specification, analysis, design, optimization, verification, and validation. Next, he shows how to use all nine types of SysML diagrams, even if you have no previous experience with modeling languages. A case study running through the text demonstrates the use of SysML in modeling a complex, real-world sociotechnical system. Modeled after Martin Fowler’s classic UML Distilled, Delligatti’s indispensable guide quickly teaches you what you need to know to get started and helps you deepen your knowledge incrementally as the need arises. Like SysML itself, the book is method independent and is designed to support whatever processes, procedures, and tools you already use. Coverage Includes Why SysML was created and the business case for using it Quickly putting SysML to practical use What to know before you start a SysML modeling project Essential concepts that apply to all SysML diagrams SysML diagram elements and relationships Diagramming block definitions, internal structures, use cases, activities, interactions, state machines, constraints, requirements, and packages Using allocations to define mappings among elements across a model SysML notation tables, version changes, and sources for more information
Using Microsoft Access 2010, Enhanced EditionAlison 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.
MySQL Pocket ReferenceGeorge 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.
Developing Analytic TalentVincent 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.
The Data Warehouse Lifecycle ToolkitRalph 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.
Data Science from ScratchJoel 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.
Definitive Guide to DAX, TheMarco Russo
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
Designing Data VisualizationsNoah 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
Teach Yourself VISUALLY Access 2010Faithe 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.
HBase: The Definitive GuideLars 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