Database software Books

Book SynopsisBen Forta is Adobe's Senior Director of Education Initiatives and has three decades of experience in the computer industry in product development, support, training, and product marketing. He is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (including spinoff titles on MariaDB, MySQL, SQL Server T-SQL, and Oracle PL/SQL), Learning Regular Expressions, as well as books on Java, Windows, and more. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs and websites, and is a frequent lecturer and columnist on application development and Internet technologies. Ben lives in Oak Park, Michigan, with his wife, Marcy, and their children. He welcomes your email at ben@forta.com and invites you to visit his website at http://forta.com.     Table of ContentsIntroduction 1 Who Is the Teach Yourself SQL Book For? . . . . . . . . . . . . . . . . . . . . . . . . . . 1 DBMSs Covered in This Book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Conventions Used in This Book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Understanding SQL 5 Database Basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 What Is SQL? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Try It Yourself . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122 Retrieving Data 13 The SELECT Statement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 Retrieving Individual Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 Retrieving Multiple Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Retrieving All Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Retrieving Distinct Rows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Limiting Results . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Using Comments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233 Sorting Retrieved Data 25 Sorting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Sorting by Multiple Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Sorting by Column Position . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Specifying Sort Direction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 314 Filtering Data 33 Using the WHERE Clause . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 The WHERE Clause Operators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 405 Advanced Data Filtering 41 Combining WHERE Clauses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 Using the IN Operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Using the NOT Operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 496 Using Wildcard Filtering 51 Using the LIKE Operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 Tips for Using Wildcards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 587 Creating Calculated Fields 59 Understanding Calculated Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Concatenating Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 Performing Mathematical Calculations . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 688 Using Data Manipulation Functions 69 Understanding Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Using Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 789 Summarizing Data 79 Using Aggregate Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 Aggregates on Distinct Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 Combining Aggregate Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8810 Grouping Data 89 Understanding Data Grouping. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89 Creating Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90 Filtering Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91 Grouping and Sorting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94 SELECT Clause Ordering . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9711 Working with Subqueries 99 Understanding Subqueries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99 Filtering by Subquery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99 Using Subqueries as Calculated Fields . . . . . . . . . . . . . . . . . . . . . . . . . . 103 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10612 Joining Tables 107 Understanding Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107 Creating a Join . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11613 Creating Advanced Joins 117 Using Table Aliases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 Using Different Join Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118 Using Joins with Aggregate Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . 123 Using Joins and Join Conditions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12614 Combining Queries 127 Understanding Combined Queries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127 Creating Combined Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13415 Inserting Data 135 Understanding Data Insertion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135 Copying from One Table to Another . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 142 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14316 Updating and Deleting Data 145 Updating Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145 Deleting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147 Guidelines for Updating and Deleting Data . . . . . . . . . . . . . . . . . . . . . . . 149 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15017 Creating and Manipulating Tables 151 Creating Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151 Updating Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155 Deleting Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157 Renaming Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 158 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 158 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15918 Using Views 161 Understanding Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 Creating Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17019 Working with Stored Procedures 171 Understanding Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171 Understanding Why to Use Stored Procedures . . . . . . . . . . . . . . . . . . . . . 172 Executing Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173 Creating Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17820 Managing Transaction Processing 179 Understanding Transaction Processing . . . . . . . . . . . . . . . . . . . . . . . . . . 179 Controlling Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18521 Using Cursors 187 Understanding Cursors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 187 Working with Cursors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 188 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19222 Understanding Advanced SQL Features 193 Understanding Constraints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193 Understanding Indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 198 Understanding Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200 Database Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 202 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 202A Sample Table Scripts 203B SQL Statement Syntax 209C Using SQL Datatypes 215D SQL Reserved Words 221TOC, 9780135182796, 10/9/19

Read more less

Book Synopsis"To me, this has always been the defacto standard for documentation on the Spring Framework. I bought the 1st edition when it first came out as we were converting alegacy app to Spring and this book was essential in learning how the current version worked." - Tony Sweets A new edition of the classic bestseller! Spring in Action, 6th Edition covers all of the new features of Spring 5.3 and Spring Boot 2.4 along with examples of reactive programming, Spring Security for REST Services, and bringing reactivity to your databases. You'll also find the latest Spring best practices, including Spring Boot for application setup and configuration. about the technologySpring Framework makes life easier for Java developers. The latest version of Spring brings its productivity-focused approach to microservices, reactive development, and other modern application designs. With Spring Boot now fully integrated, you can start even complex projects with minimal configuration code. And in recent version of Spring, the new RSocket specification makes your application's networking symmetrical—perfect for reactive design. about the bookSpring in Action, 6th Edition guides you through Spring's core features explained in Craig Walls' famously clear style. You'll roll up your sleeves and build a secure database-backed web app step by step. Along the way, you'll explore reactive programming, microservices, service discovery, RESTful APIs, deployment, and expert best practices. The latest version of a bestseller upgraded for Spring 5.3 and Spring Boot 2.4, this new edition also covers the RSocket specification for reactive networking between applications and delves deep into essential features of Spring Security. Whether you're just discovering Spring or leveling up to Spring 5.3, this Manning classic is your ticket! what's insideBuilding reactive applicationsRelational and NoSQL databasesIntegrating via HTTP and REST-based services, and sand reactive RSocket servicesReactive programming techniquesDeploying applications to traditional servers and containersSecuring applications with Spring SecurityCovers Spring 5.2 about the authorCraig Walls is a principal software engineer at Pivotal, a member of the Spring engineering team, a popular author, and a frequent conference speaker.We interviewed Craig as a part of our Six Questions series. Check it out here.Trade Review"If you're really serious about Spring, the book should lie next to the keyboard and serve as a pillow at night." Christian Kreutzer-Beck "I've owned every version of the this book and it's still my go to for the core Spring framework. It still lives up to expectations." Tony Sweets "Great read whether you are a beginning Spring developer or an experienced developer seeking a technology upgrade." Becky Huett "Even if you've read an older edition and you think you know Spring, I guarantee you will not regret the purchase!" Conor Redmond "Spring in Action 6th Edition is a comprehensive manuscript packed dense with a wealth of extensive information and myriad of resources to help you get a solid grounding of the fundamental Spring concepts!" Iain Campbell

Read more less

Book SynopsisWith 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.

Read more less

Book SynopsisTable of ContentsPreface xix About The Author xxiii 1 Data: The New Corporate Resource 1 2 Data Modeling 16 3 The Database Management System Concept 36 4 Relational Data Retrieval: SQL 59 5 The Relational Database Model: Introduction 95 6 The Relational Database Model: Additional Concepts 127 7 Logical Database Design 145 8 Physical Database Design 185 9 Object-Oriented Database Management 229 10 Data Administration, Database Administration, and Data Dictionaries 248 11 Database Control Issues: Security, Backup and Recovery, Concurrency 268 12 The Data Warehouse 289 13 NoSQL Database Management 319 14 Blockchain 341 15 Database in the Cloud 352 16 Database Applications 363 Index I-1

Read more less

Book SynopsisThinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you’ll also discover that PostgeSQL is more than a database system—it’s an impressive application platform as well.

Read more less

Book SynopsisTeach database theory with the bestselling text on the subject Database Systems: A Practical Approach to Design, Implementation, and Management introduces the theory behind databases in a concise yet comprehensive manner. Designed for undergraduate courses, the text is accessible for non-technical readers. This title comes with a Companion Website.Table of ContentsPart 1 Background Chapter 1 Introduction to Databases Database Environment Database Architectures and the Web Part 2 The Relational Model and Languages Chapter 4 The Rational Model Chapter 5 Relational Algebra and Relational Calculus Chapter 6 SQL: Data Manipulation Chapter 7 SQL: Data Definition Chapter 8 Advanced SQL Chapter 9 Object-Relational DBMSs Part 3 Database Analysis and Design Chapter 10 Database System Development Lifecycle Chapter 11 Database Analysis and the DreamHome Case Study Chapter 12 Entity-Relationship Modeling Chapter 13 Enhanced Entity-Relationship Modeling Chapter 14 Normalization Chapter 15 Advanced Normalization Part 4 Methodology Chapter 16 Methodology – Conceptual Database Design Chapter 17 Methodology – Logical Database Design for the Relational Model Chapter 18 Methodology – Physical Database Design for Relational Databases Chapter 19 Methodology – Monitoring and Tuning the Operational System Part 5 Selected Database Issues Chapter 20 Security and Administration Chapter 21 Professional, Legal, and Ethical Issues in Data Management Chapter 22 Transaction Management Chapter 23 Query Processing Part 6 Distributed DBMSs and Replication Chapter 24 Distributed DBMSs – Concepts and Design Chapter 25 Distributed DBMSs – Advanced Concepts Chapter 26 Replication and Mobile Databases Part 7 Object DBMSs Chapter 27 Object-Oriented DBMSs – Concepts and Design Chapter 28 Object-Oriented DBMSs – Standard Systems Part 8 The Web and DBMSs Chapter 29 Web Technology and DBMSs Chapter 30 Semistructured Data and XML Part 9 Business Intelligence Chapter 31 Data Warehousing Concepts Chapter 32 Data Warehousing Design Chapter 33 OLAP Chapter 34 Data Mining Appendices References Further Reading Index

Read more less

Book SynopsisDemonstrates that since SQL code may run for 5 to 10 years, and run on different hardware, it must be fast and sound from the start. This book offers SQL best practices and relational theory that force you to focus on strategy rather than specifics.

Read more less

Book SynopsisDive into a secure future Professionals look to Ethereum as ablockchain-based platform to develop safe applications and conduct secure transactions. It takes a knowledgeable guiding hand to understand how Ethereum works and what it does and Ethereum For Dummies provides that guidance. Written by one of the leading voices in the blockchain community and best selling author of Blockchain For Dummies, this book demystifies the workings of Ethereum and shows how it can enhance security, transactions, and investments. As an emerging application of blockchain technology, Ethereum attracts a wide swath of professionals ranging from financial pros who see it as a way to enhance their business, security analysts who want to conduct secure transactions, programmers who build apps that employ the Ethereum blockchain, or investors interested in cashing in on the rise of cryptocurrency. Ethereum For Dummies offers a starting point to all members of this audience as it provides easy-to-understand eTable of ContentsIntroduction 1 About This Book 1 Foolish Assumptions 2 Icons Used in This Book 2 Beyond the Book 2 Where to Go from Here 3 Part 1: Getting to Know Blockchain and Ethereum 5 Chapter 1: Introducing Ethereum 7 Describing Blockchain Technology 8 Introducing Ethereum 10 Exploring Ethereum’s Consensus, Mining, and Smart Contracts 11 Buying, Spending, and Trading Ether 13 Getting Started with DAO and ICO 16 Exploring the Ethereum Ecosystem 17 Delving into Development Tools 18 Building Blockchain Apps 18 Chapter 2: Learning about Blockchain 21 Exploring Distributed Applications 22 Digging into distributed processing 22 Exploring problems with distributed processing 24 Presenting some solutions to distributed processing problems 27 Examining the Bitcoin Solution to the Distributed Dilemma 28 Describing Blockchains 30 Examining blockchain details 30 Protecting blockchain visibility 31 Building Blockchains 33 Agreeing to add blocks 33 Making blocks immutable 34 Reviewing the building process 35 Keeping all blockchains consistent 35 Understanding How Blockchains and Databases Store Data Differently 36 Storing data in a traditional database 36 Storing data in a blockchain 38 Effectively Using Blockchains 39 Transferring value without trust 39 Reducing transaction costs by eliminating middlemen 39 Increasing efficiency through direct interaction 40 Maintaining complete transaction history 40 Increasing resilience through replication 41 Providing transparency 41 Chapter 3: Exploring Use Cases for Ethereum 43 Diving Into Ethereum Applications 44 Exploring Financial Services 45 Banking 46 Creating Ethereum escrow applications 48 Examining ICOs 48 Establishing Digital Identity Management 49 Managing individual and device identities 50 Reducing fraud and identity theft 50 Examining the ERC-725 standard and beyond 51 Examining Industry Applications 51 Healthcare 52 Energy 52 Supply chain 53 Enabling Effective Governance 54 Tax payment 54 Government spending 55 Voting 55 Policy development 55 Notary 56 Part 2: Setting Up Your Ethereum Development Environment 57 Chapter 4: Examining the Ethereum Ecosystem and Development Lifecycle 59 Exploring the Ethereum Blockchain Block Structure 60 Describing Smart Contracts 64 Introducing Solidity, the Language of Smart Contracts 66 Working with the Ethereum Virtual Machine 67 Fueling Your Code with Gas 68 Surveying Tools for Developing, Testing, and Deploying Ethereum Apps 69 Ethereum blockchain client 70 Development and testing blockchain 71 Compiler and testing framework 72 Source code editor/IDE 72 Describing the Ethereum Development Lifecycle 73 Introducing Smart Contract Development Tools 74 Chapter 5: Getting and Configuring Ethereum Development Tools 77 Examining Why Multiple Ethereum Development Tools are Available 78 Downloading, Installing, and Configuring All the Pieces 79 Installing the blockchain client 79 Installing the test blockchain 83 Installing the testing environment 86 Installing the IDE 91 Chapter 6: Establishing an Ethereum Wallet 95 Unlocking the Secrets of an Ethereum Wallet 96 Examining the Types of Ethereum Wallets 96 Sorting out software wallets 97 Handling hardware wallets 99 Perusing paper wallets 99 Choosing an Ethereum Wallet 100 Software wallets 100 Hardware wallets 102 Paper wallets 103 Installing MetaMask, an Ethereum Wallet 104 Part 3: Building Ethereum Distributed Blockchain Apps 107 Chapter 7: Building Your First Ethereum Apps 109 Validating Your Ethereum Development Environment 110 Creating a Truffle project 110 Editing the Truffle config file 111 Exploring the Ganache Test Environment 113 Designing Simple Smart Contracts 115 Coding Your First Smart Contract 116 Running Your First Smart Contract 118 Writing your code 118 Compiling your code 119 Deploying your code 120 Invoking your code’s functions 122 Paying as You Go 124 Chapter 8: Learning about Smart Contracts 125 Introducing Supply Chain and Common Challenges 126 Describing supply chain 126 Explaining difficulties when implementing a supply chain 127 Examining How Blockchain Can Help Resolve Supply Chain Problems 128 Describing a Blockchain Supply Chain Solution 129 Paying for supply chain services 129 Managing assets on the supply chain 130 Digging into Solidity 132 Describing Basic Smart Contract Syntax 133 Declaring valid compiler version 134 Commenting your code 134 Importing external code 135 Defining your smart contracts 135 Handling Data in Solidity 136 Learning about Computation and Gas 140 Exploring Access Modes and Visibility of Smart Contract Functions and Data 142 Controlling Execution Flow 144 Handling Errors and Exceptions 145 Chapter 9: Writing Your Own Smart Contracts with Solidity 147 Reviewing Supply Chain Design Specification 148 Payment token smart contract 149 Supply chain smart contract 150 Creating New Smart Contracts 151 ERC-20 token interface 153 ERC-20 token smart contract 154 Supply chain smart contract 155 Coding Primary Functions 157 ERC-20 token functions 157 Supply chain functions 160 Using Events 163 Defining events 165 Triggering events 166 Introducing Ownership 168 Designing for Security 170 Implementing Minimal Functionality 171 Part 4: Testing and Deploying Ethereum Apps 173 Chapter 10: Testing Ethereum Apps 175 Understanding Ethereum dApp Testing 176 Writing tests from the beginning 176 Choosing the right test blockchain 176 Learning the steps in the testing lifecycle 177 Testing for software quality 177 Deploying a dApp to a Test Ethereum Blockchain 178 Telling Truffle to use the Ganache blockchain 178 Deploying your code to the Ganache blockchain 180 Writing Tests for Ethereum dApps 181 Testing using the command line 181 Writing test cases in JavaScript 185 Logging and Handling Errors 187 Handling errors in Solidity 188 Logging activity in smart contracts 189 Fixing Bugs in a dApp 190 Chapter 11: Deploying and Maintaining Ethereum Apps 191 Test Blockchain Options versus Live Blockchains 192 Testing with the Ganache blockchain 192 Deploying your code to other test blockchains 193 Anticipating Differences in Live Environments 195 Preparing Your Configuration for Deploying to Different Networks 196 Deploying a dApp 198 Getting enough ether 199 Compiling your code 203 Deploying your code 203 Chapter 12: Integrating Non-Blockchain Apps with Ethereum 205 Comparing Blockchain and Database Storage 206 Locating control 207 Imposing data format 207 Updating data 207 Optimizing performance 208 Protecting confidentiality 208 Paying for storage 208 Providing integrity and transparency 209 Protecting resilience 209 Contrasting Execution and Flow in Blockchain dApps and Traditional Applications 210 Designing Goals for Incorporating Blockchain into an Existing Application 211 Using existing smart contracts 213 Developing your own smart contracts 213 Identifying Interface Data and Transaction Requirements 214 Creating or Modifying Contracts to Provide Data Interface 215 Testing Integrated dApps 215 Deploying Integrated dApps 216 Part 5: The Part of Tens 219 Chapter 13: Ten Free Ethereum Resources 221 Exploring Alternative Ethereum Development Frameworks 222 Managing you development with Populus 222 Exploring Ethereum blockchain containers with Cliquebait 222 Selecting a Free Integrated Development Environment 223 Developing Solidity code with Atom 223 Going online with Remix 224 Keeping it simple with EthFiddle 224 Exploring Ethereum Clients and APIs 226 Swapping your Ethereum client to Parity 226 Interacting with Ethereum by using Web3.js 226 Focusing on Wallets and Security 227 Protecting your crypto-assets in Mist 227 Securing your dApps with OpenZeppelin 228 Learning More About Developing Ethereum dApps 228 Chapter 14: Ten Design Principles for Distributed Blockchain Apps 229 Designing for Trust 230 Enforcing Consistency 230 Removing Doubt through Transparency 232 Providing Feedback, Guidance, and Setting Expectations 233 Handling Mistakes with Class 233 Designing Functions that Focus on User Actions, Not Data 234 Storing Data Based on User Actions, Not Data Structures 235 Keeping It Simple 236 Expecting Blockchain Access to Be Expensive 236 Staying Out of the User’s Way 237 Chapter 15: Top Ten Ethereum Projects 239 Predicting Future Events with Gnosis 240 Crowdsourcing Event Predictions in Augur 240 Managing Decentralized Organizations with Aragon 241 Breeding and Collecting Cryptokitties 241 Exchanging Tokens with IDEX 242 Creating Your Digital Identity with uPort 243 Sharing Your Thoughts on the Blockchain with EtherTweet 243 Searching for Jobs with EthLance 244 Using TenX to Pay with Cryptocurrency 245 Buying and Selling Computing Power with Golem 246 Index 247

Read more less

Book SynopsisAccess in easy steps has an easy-to-follow style that will appeal to anyone who wants to get more from the Microsoft Access app. Whether you're using Access in the Office 365 suite or standalone Office product, you can use this guide to learn the key features and get more out of Access. Learn how to:Optimize database design for efficiencyCreate Tables to store dataUse handy templates and get a head startMake queries to extract specific dataProduce user-friendly Forms for data entry Explore basic SQL for advanced queriesConstruct informative Reports quicklyImport and export data to Excel and Word Securely share your well-designed database and reports that'll impress your colleagues! Access in easy steps contains separate chapters on the major features of the Access app. There are complete examples that demonstrate each aspect of Access, together with screenshots that illustrate the actual output. This book neatly demonstrates the important functions of Microsoft Access in a clear and concise manner, so you can get going quickly with this popular database application.Illustrated using Access 2019.

Read more less

Book SynopsisTable of ContentsIntroduction xxxix Part I: Access Building Blocks 1 Chapter 1: An Introduction to Database Development 3 The Database Terminology of Access 3 Relational Databases 6 Access Database Objects 7 A Five-Step Design Method 9 Chapter 2: Getting Started with Access 17 The Access Welcome Screen 17 How to Create a Blank Database 18 The Access 2019 Interface 20 The Ribbon 24 The Quick Access toolbar 25 Part II: Understanding Access Tables 29 Chapter 3: Creating Access Tables 31 Table Types 31 Creating a New Table 32 Creating tblCustomers 49 Changing a Table Design 50 Understanding tblCustomers Field Properties 68 Setting the Primary Key 71 Indexing Access Tables 73 Printing a Table Design 79 Saving the Completed Table 81 Manipulating Tables 81 Adding Records to a Database Table 84 Understanding Attachment Fields 84 Chapter 4: Understanding Table Relationships 87 Building Bulletproof Databases 88 Data Normalization and Denormalization 90 Table Relationships 102 Integrity Rules 110 Keys 113 Creating relationships and enforcing referential integrity 119 Viewing all relationships 125 Deleting relationships 126 Following application-specific integrity rules 126 Chapter 5: Working with Access Tables 129 Understanding Datasheets 130 Looking at the Datasheet Window 131 Opening a Datasheet 135 Entering New Data 135 Navigating Records in a Datasheet 142 Changing Values in a Datasheet 146 Using the Undo Feature 148 Copying and Pasting Values 148 Replacing Values 149 Adding New Records 150 Deleting Records 150 Displaying Records 152 Sorting and Filtering Records in a Datasheet 160 Aggregating Data 165 Printing Records 166 Previewing Records 167 Chapter 6: Importing and Exporting Data 169 How Access Works with External Data 169 Options for Importing and Exporting 173 Exporting to External Formats 202 Chapter 7: Linking to External Data 209 Linking External Data 210 Working with Linked Tables 225 Splitting a Database 229 Part III: Working with Access Queries 237 Chapter 8: Selecting Data with Queries 239 Introducing Queries 240 Creating a Query 241 Working with Query Fields 247 Adding Criteria to Your Queries 252 Printing a Query’s Recordset 255 Saving a Query 256 Creating Multi-table Queries 256 Working with the Table Pane 261 Creating and Working with Query Joins 262 Chapter 9: Using Operators and Expressions in Access 269 Introducing Operators 269 Using Operators and Expressions in Queries 283 Entering Single-Value Field Criteria 289 Using Multiple Criteria in a Query 297 Entering Criteria in Multiple Fields 304 Chapter 10: Going Beyond Select Queries 311 Aggregate Queries 311 Action Queries 320 Crosstab Queries 336 Optimizing Query Performance 348 Part IV: Analyzing Data in Microsoft Access 353 Chapter 11: Transforming Data in Access 355 Finding and Removing Duplicate Records 355 Common Transformation Tasks 363 Chapter 12: Working with Calculations and Dates 379 Using Calculations in Your Analyses 379 Using Dates in Your Analyses 392 Chapter 13: Performing Conditional Analyses 405 Using Parameter Queries 405 Using Conditional Functions 414 The Switch function 420 Comparing the IIf and Switch functions 421 Chapter 14: The Fundamentals of Using SQL 425 Understanding Basic SQL 425 Getting Fancy with Advanced SQL Statements 430 Showing only the SELECT TOP or SELECT TOP PERCENT 433 Performing action queries via SQL statements 436 Using SQL-Specific Queries 438 Chapter 15: Subqueries and Domain Aggregate Functions 445 Enhancing Your Analyses with Subqueries 446 Domain Aggregate Functions 459 Examining the syntax of domain aggregate functions 461 Using domain aggregate functions 463 Chapter 16: Running Descriptive Statistics in Access 469 Basic Descriptive Statistics 470 Advanced Descriptive Statistics 479 Part V: Working with Access Forms and Reports 487 Chapter 17: Creating Basic Access Forms 489 Working with Form Views 489 Understanding Different Types of Forms 490 Working with Controls 503 Introducing Properties 524 Chapter 18: Working with Data on Access Forms 531 Using Form View 532 Changing Values in a Form 537 Printing a Form 544 Working with Form Properties 545 Adding a Form Header or Footer 556 Working with Section Properties 556 Changing the Layout 558 Converting a Form to a Report 562 Chapter 19: Working with Form Controls 563 Setting Control Properties 563 Creating a Calculated Control 571 Working with Subforms 572 Form Design Tips 573 Tackling Advanced Forms Techniques 576 Using the Tab Control 583 Using Dialog Boxes to Collect Information 586 Designing a Form from Scratch 589 Chapter 20: Presenting Data with Access Reports 599 Introducing Reports 599 Creating a Report, from Beginning to End 604 Creating a report with the Report Wizard 605 Banded Report Design Concepts 622 Creating a Report from Scratch 628 Improving the Report’s Appearance 651 Chapter 21: Advanced Access Report Techniques 657 Grouping and Sorting Data 658 Formatting Data 670 Adding Data 688 Adding Even More Flexibility 690 Part VI: Microsoft Access Programming Fundamentals 703 Chapter 22: Using Access Macros 705 An Introduction to Macros 705 Understanding Macro Security 709 Multi-action Macros 713 Submacros 716 Conditions 720 Temporary Variables 723 Error Handling and Macro Debugging 728 Embedded Macros 734 Macros versus VBA Statements 736 Chapter 23: Using Access Data Macros 741 Introducing Data Macros 742 Understanding Table Events 742 Using the Macro Builder for Data Macros 745 Understanding the Action Catalog 747 Creating Your First Data Macro 751 Managing Macro Objects 755 Recognizing the Limitations of Data Macros 757 Chapter 24: Getting Started with Access VBA 759 Introducing Visual Basic for Applications 760 Understanding VBA Terminology 761 Starting with VBA Code Basics 762 Creating VBA Programs 763 Modules and procedures 763 Working in the code window 770 Understanding VBA Branching Constructs 777 Working with Objects and Collections 786 Exploring the Visual Basic Editor 792 Chapter 25: Mastering VBA Data Types and Procedures 801 Using Variables 802 Working with Data Types 809 Understanding Subs and Functions 829 Creating Functions 835 Simplifying Code with Named Arguments 840 Chapter 26: Understanding the Access Event Model 843 Programming Events 844 Identifying Common Events 847 Paying Attention to Event Sequence 856 Chapter 27: Debugging Your Access Applications 865 Organizing VBA Code 866 Testing Your Applications 867 Traditional Debugging Techniques 873 Using the Access Debugging Tools 879 Trapping Errors in Your Code 893 Part VII: Advanced Access Programming Techniques 899 Chapter 28: Accessing Data with VBA 901 Working with Data 901 Understanding DAO Objects 904 Understanding ADO Objects 917 Writing VBA Code to Update a Table 923 Chapter 29: Advanced Data Access with VBA 937 Adding an Unbound Combo Box to a Form to Find Data 937 Filtering a Form 945 Chapter 30: Customizing the Ribbon 955 The Ribbon Hierarchy 955 Controls for Access Ribbons 956 Editing the Default Ribbon 961 Working with the Quick Access Toolbar 964 Developing Custom Ribbons 966 Creating a Custom Ribbon 969 The Basic Ribbon XML 977 Adding Ribbon Controls 979 Attaching Ribbons to Forms and Reports 989 Removing the Ribbon Completely 990 Chapter 31: Preparing Your Access Application for Distribution 993 Defining the Current Database Options 994 Polishing Your Application 1009 Bulletproofing an Application 1022 Chapter 32: Integrating Access with SharePoint 1039 Introducing SharePoint 1039 Understanding SharePoint Sites 1040 Sharing Data between Access and SharePoint 1043 Using SharePoint Templates 1052 Index 1055

Read more less

Book SynopsisThe book covers enhancements in Sybase ASE 15 like system admin improvements, function-based indexes, computed columns, scrollable cursor, galaxy optimizer, query plan, galaxy partitions, multiple tempdb, Mda tables, and plan viewer.

Read more less

Book SynopsisYour database is the foundation of your application. Many programmers assume it's also the bottleneck of productive software development, but with the right techniques, this doesn't have to be true. SQL Antipatterns illustrates some of the most common misconceptions and pitfalls software developers face using relational databases. This book helps you to use a database to produce the most efficient results, and turn sluggish, inflexible code and thankless late-night hours into high-quality, reliable solutions and a job well done. The SQL database programming language is the core of most software in the world, but if you're like most software developers, you're self-taught in SQL, and you know just enough to get by. As a result, you might design fragile databases that cannot scale as the business grows, write queries that produce incorrect results and not know why, or deploy applications that are vulnerable to hackers. Don't reinvent the wheel to solve problems SQL was designed to solve--this book will teach you new SQL techniques for getting your job done. Whatever platform or programming language you use, whether you're a junior programmer or a Ph.D., SQL Antipatterns will show you how to design and build databases, how to write better database queries, and how to integrate SQL programming with your application like an expert. You'll also learn the best and most current technology for full-text search, how to design code that is resistant to SQL injection attacks, and other techniques for success.

Read more less

Book SynopsisIn the modern symphony of business, each section-from the technical to the managerial-must play in harmony. Authors Ron Itelman and Juan Cruz Viotti introduce a bold methodology to synchronize your business and technical teams, transforming them into a single, high-performing unit.

Read more less

Book SynopsisLarry Ullman is a writer, Web and software developer, trainer, instructor, speaker, and consultant. He has written more than 20 books, which have sold over 400,000 copies worldwide in more than 20 languages. As his readers, students, and co-workers can attest, Larry's strength is in translating geek into English: converting the technical and arcane into something comprehensible and useful. Table of Contents Chapter 1 Introduction to PHP Chapter 2 Programming with PHP Chapter 3 Creating Dynamic Web Sites Chapter 4 Introduction to MySQL Chapter 5 Introduction to SQL Chapter 6 Database Design Chapter 7 Advanced SQL and MySQL Chapter 8 Error Handling and Debugging Chapter 9 Using PHP with MySQL Chapter 10 Common Programming Techniques Chapter 11 Web Application Development Chapter 12 Cookies and Sessions Chapter 13 Security Methods Chapter 14 Perl-Compatible Regular Expressions Chapter 15 Introducing jQuery Chapter 16 An OOP Primer Chapter 17 Example–Message Board Chapter 18 Example–User Registration Appendix A Installation

Read more less

Book SynopsisMary Anne Poatsy, Series Editor Mary Anne is a senior faculty member at Montgomery County Community College, teaching various computer application and concepts courses in face-to-face and online environments. She holds a B.A. in Psychology and Education from Mount Holyoke College and an M.B.A. in Finance from Northwestern University's Kellogg Graduate School of Management. Mary Anne has more than 12 years of educational experience. She is currently adjunct faculty at Gwynedd-Mercy College and Montgomery County Community College. She has also taught at Bucks County Community College and Muhlenberg College, as well as conducted personal training. Before teaching, she was Vice President at Shearson Lehman in the Municipal Bond Investment Banking Department. Eric Cameron Eric Cameron is a tenured Associate Professor at Passaic County Community College, where he has taught in the Computer and Information Sciences department since 2001. He holds an M.S. in Computer Science and a B.S. degree in Computer Science with minors in Mathematics and Physics, both from Montclair State University. He currently co-chairs the College's General Education committee and served as a member of the College's Academic Assessment, College Writing, and Educational Technology committees at various points. Eric has also developed degrees in Graphic Design and Medical Informatics for the College. Eric previously worked as a software engineer both as a full-time employee and contractor, most recently for ITT/Exelis (now part of Harris Corporation). This is Eric's fourth publication for Pearson, after authoring Web 2.0 and Windows 8 books in the Your Office series and co-authoring the Exploring Access 2013 text.   Jerri Williams Jerri Williams is a Senior Instructor at Montgomery County Community College in Pennsylvania. Jerri also works as an independent corporate trainer, technical editor, and content developer. She is interested in travel, cooking, movies, and tending to her colonial farmhouse. Jerri is married, and is the mother of two daughters, Holly (an Accounting graduate and full-time mother to an adorable son, Meir) and Gwyneth (a corporate defense attorney). Jerri and Gareth live in the suburbs of Philadelphia. They enjoy their home and garden, and spending time with family and good friends. Amy Rutledge Amy Rutledge is a Special Instructor of Management Information Systems at Oakland University in Rochester, Michigan. She coordinates academic programs in Microsoft Office applications and introductory management information systems courses for the School of Business Administration. Before joining Oakland University as an instructor, Amy spent several years working for a music distribution company and automotive manufacturer in various corporate roles including IT project management. She holds a B.S. in Business Administration specializing in Management Information Systems, and a B.A. in French Modern Language and Literature. She holds an M.B.A from Oakland University. She resides in Michigan with her husband, Dan and daughters Emma and Jane.   Dr. Robert T. Grauer, Creator of the Exploring Series Bob Grauer is Professor Emeritus in the Department of Computer Information Systems at the University of Miami, where he is a multiple winner of the Outstanding Teaching Award in the School of Business, most recently in 2009. He has written numerous COBOL texts and is the vision behind the Exploring Office series, with more than three million books in print. His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels. Bob Grauer has consulted for several major corporations including IBM and American Express. He received his Ph.D. in Operations Research in 1972 from the Polytechnic Institute of Brooklyn.  Table of Contents Office 2016 Common Features Access Chapter 1 Introduction to Access Chapter 2 T ables and Queries in Relational Databases Chapter 3 Using Queries to Make Decisions Chapter 4 Creating and Using Professional Forms and Reports Chapter 5 Data Validation and Data Analysis Chapter 6 Action and Specialized Queries Chapter 7 Advanced Forms and Reports Chapter 8 Get Connected Chapter 9 Fine-Tuning the Database Chapter 10 Using Macros and SQL in Access Access Introductory Capstone Exercise (Chs. 1—4) Access Comprehensive Capstone Exercise (Chs. 5—10) MICROSOFT OFFICE 2016 SPECIALIST ACCESS Glossary Index Application Capstone Exercises

Read more less

Book SynopsisAbout our authors Mary Anne Poatsy, Series Editor, Windows 10 Author, is a senior faculty member at Montgomery County Community College, teaching various computer applications and concepts courses in face-to-face and online environments. She holds a BA in psychology and education from Mount Holyoke College and an MBA in finance from Northwestern University's Kellogg Graduate School of Management. Mary Anne has over 20 years of educational experience. She has taught at Montgomery County Community College and Muhlenberg College. She also engages in corporate training. Before teaching, she was Vice President at Shearson Lehman in the Municipal Bond Investment Banking Department. Amy Rutledge, Access Author, is a special Instructor of MIS (management information systems) at Oakland University in Rochester, Michigan. She coordinates academic programs in Microsoft Office applications and introductory management informatioTable of ContentsBrief Contents OFFICE Office 365 Common Features ACCESS Introduction to Access Tables and Queries in Relational Databases Query Calculations and Expressions Basic Forms and Reports Data Validation and Data Analysis Action and Specialized Queries Advanced Forms and Reports Get Connected Fine-Tuning the Database Enhanced Database Techniques APPLICATION CAPSTONE EXERCISE Access Application Capstone Exercise

Read more less

Book SynopsisPaul McFedries is a Microsoft Access and database expert and full-time technical writer. Paul has been authoring computer books since 1991 and has nearly 100 books to his credit, which combined have sold more than 4 million copies worldwide. His titles include the Microsoft Press Publishing book Formulas and Functions for Microsoft Excel 2019, the Que Publishing books My Office 2016, My Office for iPad, Windows 10 In Depth (with coauthor Brian Knittel), and PCs for Grownups, aswell as the Wiley Publishing books Teach Yourself VISUALLY Microsoft Access and Teach Yourself VISUALLY Excel Data Analysis. Please drop by Paul's personal website at www.mcfedries.com or follow Paul on Twitter at twitter.com/paulmcf.Table of Contents 1 Manage databases Objective 1.1: Modify database structure Objective 1.2: Manage table relationships and keys Objective 1.3: Print and export data 2 Create and modify tables Objective 2.1: Create tables. Objective 2.2: Manage tables Objective 2.3: Manage table records Objective 2.4: Create and modify fields 3 Create and modify queries Objective 3.1: Create and run queries Objective 3.2: Modify queries 4 Modify forms in Layout view Objective 4.1: Configure form controls Objective 4.2: Format forms 5 Modify reports in Layout view Objective 5.1: Configure report controls Objective 5.2: Format reports

Read more less

Book SynopsisElena Rakhimov has more than 20 years of experience in software architecture and development in a wide spectrum of enterprise and business environments ranging from nonprofit organizations to Wall Street to her current position with a prominent consulting company. Her determination to stay hands-on notwithstanding, Elena managed to excel in the academic arena, having taught relational database programming at Columbia University's highly esteemed Computer Technology and Applications program. She was educated in database analysis and design at Columbia University and in applied mathematics at Baku State University in Azerbaijan.Table of ContentsPreface xvii Introduction to PL/SQL New Features in Oracle 21c xxiiiChapter 1 PL/SQL Concepts 1 Lab 1.1: PL/SQL Architecture 2 PL/SQL Architecture 2 PL/SQL Block Structure 5 How PL/SQL Gets Executed 9 Lab 1.2: PL/SQL Development Environment 10 Getting Started with SQL Developer 10 Getting Started with SQL*Plus 13 Executing PL/SQL Scripts 14 Lab 1.3: PL/SQL: The Basics 18 DBMS_OUTPUT.PUT_LINE Statement 18 Substitution Variable Feature 21 Summary 25Chapter 2 PL/SQL Language Fundamentals 27 Lab 2.1: PL/SQL Language Components 27 PL/SQL Variables 29 PL/SQL Reserved Words 31 Delimiters 32 Literals in PL/SQL 33 Lab 2.2: Anchored Data Types 33 Lab 2.3: Scope of a Variable, Block, Nested Blocks, and Labels 35 Scope of a Variable 35 Nested Blocks and Labels 36 Summary 38Chapter 3 SQL in PL/SQL 39 Lab 3.1: SQL Statements in PL/SQL 39 Initializing Variables with the SELECT INTO Statement 40 Using DML Statements in a PL/SQL Block 41 Using a Sequence in a PL/SQL Block 43 Lab 3.2: Transaction Control in PL/SQL 44 The COMMIT, ROLLBACK, and SAVEPOINT Statements 44 The SET TRANSACTION Statement 47 Summary 48Chapter 4 Conditional Control: IF Statements 49 Lab 4.1: IF Statements 50 IF-THEN Statements 50 IF-THEN-ELSE Statements 52 Lab 4.2: ELSIF Statements 55 Lab 4.3: Nested IF Statements 59 Logical Operators 61 Summary 62Chapter 5 Conditional Control: CASE Statements 65 Lab 5.1: CASE Statements 65 CASE Statements 66 Searched CASE Statements 68 Lab 5.2: CASE Expressions 74 Lab 5.3: NULLIF and COALESCE Functions 78 NULLIF Function 78 COALESCE Function 80 Summary 82Chapter 6 Iterative Control: Part I 85 Lab 6.1: Simple Loops 86 EXIT Statement 87 EXIT WHEN Statement 91 Lab 6.2: WHILE Loops 92 Using WHILE Loops 92 Terminating the WHILE Loop Prematurely 95 Lab 6.3: Numeric FOR Loops 97 Using the IN Option in the Loop 100 Using the REVERSE Option in the Loop 103 Using Iteration Controls in the Loop 104 Terminating the Numeric FOR Loop Prematurely 108 Summary 109Chapter 7 Iterative Control: Part II 111 Lab 7.1: CONTINUE Statement 111 Using the CONTINUE Statement 112 Using the CONTINUE WHEN Statement 116 Lab 7.2: Nested Loops 119 Using Nested Loops 119 Using Loop Labels 120 Summary 122Chapter 8 Error Handling and Built-in Exceptions 125 Lab 8.1: Handling Errors 125 Lab 8.2: Built-in Exceptions 128 Summary 133Chapter 9 Exceptions 135 Lab 9.1: Exception Scope 135 Lab 9.2: User-Defined Exceptions 139 Lab 9.3: Exception Propagation 143 Re-raising Exceptions 148 Summary 149Chapter 10 Exceptions: Advanced Concepts 151 Lab 10.1: RAISE_APPLICATION_ERROR 151 Lab 10.2: EXCEPTION_INIT Pragma 155 Lab 10.3: SQLCODE and SQLERRM 157 Summary 160Chapter 11 Introduction to Cursors 161 Lab 11.1: Types of Cursors 162 Implicit Cursor 162 Explicit Cursor 164 Lab 11.2: Table-Based and Cursor-Based Records 171 Table-Based Records 172 Cursor-Based Records 174 Lab 11.3: Cursor FOR Loops 175 Lab 11.4: Nested Cursors 177 Summary 179Chapter 12 Advanced Cursors 181 Lab 12.1: Parameterized Cursors 181 Lab 12.2: Cursor Variables and Expressions 186 Cursor Variables 187 Cursor Expressions 193 Lab 12.3: FOR UPDATE Cursors 196 Summary 199Chapter 13 Triggers 201 Lab 13.1: What Triggers Are 201 Database Trigger 202 BEFORE Triggers 205 AFTER Triggers 210 Autonomous Transaction 211 Lab 13.2: Types of Triggers 213 Row and Statement Triggers 213 INSTEAD OF Triggers 215 Summary 219Chapter 14 Mutating Tables and Compound Triggers 221 Lab 14.1: Mutating Tables 221 Lab 14.2: Compound Triggers 223 Summary 228Chapter 15 Collections 229 Lab 15.1: PL/SQL Tables 230 Associative Arrays 231 Nested Tables 233 Collection Methods 236 Lab 15.2: Varrays 240 Lab 15.3: Multidimensional Collections 245 Lab 15.4: Collection Iteration Controls and Qualified Expressions 247 Collection Iteration Controls 247 Qualified Expressions 251 Summary 258Chapter 16 Records 259 Lab 16.1: User-Defined Records 259 User-Defined Records 260 Qualified Expressions with Records 262 Record Compatibility 263 Lab 16.2: Nested Records 265 Lab 16.3: Collections of Records 268 Summary 271Chapter 17 Native Dynamic SQL 273 Lab 17.1: EXECUTE IMMEDIATE Statements 274 EXECUTE IMMEDIATE Statement 275 Lab 17.2: OPEN FOR, FETCH, and CLOSE Statements 283 Summary 287Chapter 18 Bulk SQL 289 Lab 18.1: FORALL Statements 290 FORALL Statements 290 SAVE EXCEPTIONS Option 294 INDICES OF Option 296 VALUES OF Option 297 Lab 18.2: The BULK COLLECT Clause 299 Lab 18.3: Binding Collections in SQL Statements 308 Binding Collections with EXECUTE IMMEDIATE Statements 308 Binding Collections with OPEN FOR, FETCH, and CLOSE Statements 314 Summary 318Chapter 19 Procedures 319 Lab 19.1: Creating Nested Procedures 320 Nested Procedures 320 Parameter Modes 321 Forward Declaration 326 Lab 19.2: Creating Stand-Alone Procedures 327 Summary 330Chapter 20 Functions 331 Lab 20.1: Creating Nested Functions 331 Lab 20.2: Creating Stand-Alone Functions 336 Summary 340Chapter 21 Packages 341 Lab 21.1: Creating Packages 341 Creating a Package Specification 342 Creating a Package Body 343 Lab 21.2: Package Instantiation and Initialization 348 Package Instantiation and Initialization 349 Package State 351 Lab 21.3: SERIALLY_REUSABLE Packages 351 Summary 356Chapter 22 Stored Code Advanced Concepts 357 Lab 22.1: Subprogram Overloading 357 Lab 22.2: Result-Cached Functions 363 Lab 22.3: Invoking PL/SQL Functions from SQL Statements 366 Invoking Functions in SQL Statements 367 Using Pipelined Table Functions 368 Using SQL Macros 370 Summary 375Chapter 23 Object Types in Oracle 379 Lab 23.1: Object Types 380 Creating Object Types 381 Using Object Types with Collections 385 Lab 23.2: Object Type Methods 388 Using Constructor Methods 389 Using Member Methods 392 Using Static Methods 393 Comparing Objects 393 Summary 398Chapter 24 Storing Object Types in Tables 399 Lab 24.1: Storing Object Types in Relational Tables 400 Lab 24.2: Storing Object Types in Object Tables 403 Lab 24.3: Type Evolution 405 Summary 410Chapter 25 Dynamic SQL with the DBMS_SQL Package 411 Lab 25.1: Generating Dynamic SQL with the DBMS_SQL Package 412 Summary 420Appendix A PL/SQL Formatting Guide 421 Case 421 Whitespace 421 Naming Conventions 422 Comments 423Appendix B Student Database Schema 425 Table and Column Descriptions 425 9780138062835 TOC 4/20/2023

Read more less

Book SynopsisTable of ContentsChapter 1 | K201 IntroductionMicrosoft AccessChapter 2 | Access IntroductionChapter 3 | Importing Data, Keys, and RelationshipsChapter 4 | Data Types and Basic Field SettingsChapter 5 | Data Entry, Lookup Fields, and Field PropertiesChapter 6 | Basic Select Query Design, Criteria, and Total RowChapter 7 | Concatenation, Calculated Fields, and Aggregate FunctionsChapter 8 | Parameter Query and Query on QueriesChapter 9 |Query Wizard, and Action QueriesChapter 10 | The IIF Function and Intro to FormsChapter 11 | Mulitple Page and Navigation FormsMicrosoft ExcelChapter 12 | The Power of ExcelChapter 13 | Cell Referencing and Named RangesChapter 14 | Conditional Aggregate and Date FunctionsChapter 15 | Financial AnalysisChapter 16 | Logical FunctionsChapter 17 | Compound Nested IFsChapter 18 | Data Retrieval: VLOOKUP, HLOOKUP, MATCHChapter 19 | Data Retrieval: INDEX and MATCHChapter 20 | Spreadsheet Models and Data TablesChapter 21 | Data ValidationChapter 22 | Working with Text DataChapter 23 | Tables and ChartsChapter 24 | PivotTable and Power View ReportsAppendixBox at IUQuery GuideReports in AccessAutomating Tasks with Macros

Read more less

Book SynopsisThis new, advanced supplement to the 16-group program described in The Adolescent Self provides advanced exercises and techniques for adolescents who have mastered those taught in the original PRISM Workbook.

Read more less

Book Synopsis

Read more less

Book SynopsisThis text provides information on creating effective Web applications with ColdFusion MX, a powerful tool for rapid Web site development. Beginning with the basics, it moves on to advanced topics, providing examples of common Web application tasks.Table of Contents1. Introducing ColdFusion What Is ColdFusion?ColdFusion Architecture Getting Started with ColdFusion 2. ColdFusion Basics Getting Started Datatypes Variables Expressions Writing Output Conditional Processing LoopingIncluding Other Templates 3. Passing Data Between Templates Passing Parameters Via URL Passing Data Using Forms Dealing with Nonexistent Parameters 4. Database Basics Configuring Data Sources Introducing cfquery A Quick SQL Primer Retrieving and Displaying Data Sorting Query Results Grouping Output Looping Over a Query Result Set Formatting Techniques 5. Maintaining Database Records Inserting RecordsUpdating Existing Records Deleting Records 6. Complex Datatypes Lists Arrays Structures Query Objects 7. Maintaining State Setting Up the Web Application Framework Using Shared Scope Variables Br owser Redirection Portal Example 8. Security Security Basics Implementing Security from Scratch Taking Advantage of ColdFusion MX's New Security Framework 9. Error and Exception Handling Basic Exception Handling Custom Exception Handling Rethrowing Exceptions Error Handling Within the Web-Application Framework Server-Wide Error Handling 10. Dynamic Form Controls Combining HTML and CFML Form Controls Basic Input Controls Textual Input A Selection Control SlidersGrids Trees Preserving Input Custom Controls 11. Advanced Database Techniques Display TechniquesDrilldown Queries Query Caching Advanced SQL Query of Queries Calling Stored Procedures Transaction Processing 12. Manipulating Files and Directories Working with Directories Dealing with Files Performing FTP Operations Executing Command-Line Programs 13. Working with Email Sending Email Dealing with Undeliverable Email Retrieving MessagesBuilding a Web-Based Email Client 14. Interacting with Other Web Servers Using HTTP Retrieving Information Parsing Data Generating Static HTML Pages Posting Information cfhttp Considerations 15. Interfacing with LDAP-Enabled Directories LDAP Basics Querying an LDAP Directory Modifying LDAP Entries Modifying the Distinguished Name 16. Working with the Verity Search Interface Creating Collections Populating Collections Searching Collections The Verity Search Language Updating Collections Maintaining Collections Advanced Techniques 17. Graphing and Charting Creating a Simple Graph Working with Dates Charting Dynamic Data Charting Multiple Data Series Drilling Down on Graph Data Saving Charts to a Variable Working with the Chart Cache 18. Regular Expressions in ColdFusion Regular-Expre ssion Syntax Finding Strings Replacing Strings Back references Useful Regular Expressions Regular Expression Tester 19. Scripting Scripting Syntax Writing Output Flow Control and Looping Error and Exception Handling 20. User-Defined Functions UDF Basics Calling User-Defined Functions Advanced Topics Function Libraries Script-Based UDFs 21. Creating Custom Tags Getting Started Calling Custom Tags (Part Contents).

Read more less

Book Synopsis

Read more less

Book SynopsisThis 2-in-1 Training Kit delivers preparation plus practice for Microsoft Exam 70-462. Ace your exam prep - and enhance your job skills - with hands-on lessons, practice tests, and other resources.

Read more less

Book SynopsisThe Benchmark Series is designed to develop a mastery skill level in Microsoft Word, Excel, Access, and PowerPoint. Its graduated, three-level instructional approach moves students to analyse, synthesise, and evaluate information. Multi-part, projects-based exercises build skill mastery with activities that require independent problem solving.

Read more less

Book SynopsisWith the Benchmark Series, students learn Microsoft Access, including how to use the data-rich management software to track, report, and share information. This courseware teaches students how to create and modify tables, perform queries, and plan and publish database information to achieve a mastery skill level of Access.

Read more less

Book Synopsis

Read more less

Book SynopsisA must-have guide for the latest updates to the new release of Reporting Services SQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions.Table of ContentsFOREWORD xxxv INTRODUCTION xxxvii PART I: GETTING STARTED CHAPTER 1: INTRODUCING REPORTING SERVICES 3 CHAPTER 2: REPORTING SERVICES INSTALLATION AND ARCHITECTURE 23 CHAPTER 3: CONFIGURING SHAREPOINT INTEGRATION 69 PART II: REPORT DESIGN CHAPTER 4: BASIC REPORT DESIGN 95 CHAPTER 5: REPORT LAYOUT AND FORMATTING 123 CHAPTER 6: DESIGNING DATA ACCESS 143 CHAPTER 7: ADVANCED REPORT DESIGN 189 CHAPTER 8: CHART REPORTS 229 PART III: BUSINESS INTELLIGENCE REPORTING CHAPTER 9: BI SEMANTIC MODELS 251 CHAPTER 10: REPORTING WITH ANALYSIS SERVICES 263 CHAPTER 11: OLAP REPORTING ADVANCED TECHNIQUES 295 PART IV: ENABLING USER REPORTING CHAPTER 12: TABULAR MODELS 349 CHAPTER 13: VISUAL ANALYTICS WITH POWER VIEW 373 CHAPTER 14: REPORT BUILDER SOLUTION STRATEGIES 445 PART V: SOLUTION PATTERNS CHAPTER 15: MANAGING REPORT PROJECTS 463 CHAPTER 16: REPORT SOLUTIONS, PATTERNS, AND RECIPES 483 PART VI: ADMINISTERING REPORTING SERVICES CHAPTER 17: CONTENT MANAGEMENT 525 CHAPTER 18: INTEGRATING REPORTS WITH SHAREPOINT 559 CHAPTER 19: NATIVE MODE SERVER ADMINISTRATION 581 PART VII: REPORTING SERVICES CUSTOM PROGRAMMING CHAPTER 20: INTEGRATING REPORTS INTO CUSTOM APPLICATIONS 619 CHAPTER 21: USING EMBEDDED AND REFERENCED CODE 681 CHAPTER 22: EXTENDING REPORTING SERVICES 697 PART VIII: APPENDIXES APPENDIX A: T-SQL COMMAND SYNTAX REFERENCE 758 APPENDIX B: T-SQL SYSTEM VARIABLES AND FUNCTIONS 779 APPENDIX C: MDX REFERENCE 803 INDEX 829

Read more less

Book SynopsisFind the right big data solution for your business or organization Big data management is one of the major challenges facing business, industry, and not-for-profit organizations.Table of ContentsIntroduction 1 About This Book 2 Foolish Assumptions 2 How This Book Is Organized 3 Part I: Getting Started with Big Data 3 Part II: Technology Foundations for Big Data 3 Part III: Big Data Management 3 Part IV: Analytics and Big Data 4 Part V: Big Data Implementation 4 Part VI: Big Data Solutions in the Real World 4 Part VII: The Part of Tens 4 Glossary 4 Icons Used in This Book 5 Where to Go from Here 5 Part I: Getting Started with Big Data 7 Chapter 1: Grasping the Fundamentals of Big Data 9 The Evolution of Data Management 10 Understanding the Waves of Managing Data 11 Wave 1: Creating manageable data structures 11 Wave 2: Web and content management 13 Wave 3: Managing big data 14 Defining Big Data 15 Building a Successful Big Data Management Architecture 16 Beginning with capture, organize, integrate, analyze, and act 16 Setting the architectural foundation 17 Performance matters 20 Traditional and advanced analytics 22 The Big Data Journey 23 Chapter 2: Examining Big Data Types 25 Defining Structured Data 26 Exploring sources of big structured data 26 Understanding the role of relational databases in big data 27 Defining Unstructured Data 29 Exploring sources of unstructured data 29 Understanding the role of a CMS in big data management 31 Looking at Real-Time and Non-Real-Time Requirements 32 Putting Big Data Together 33 Managing different data types 33 Integrating data types into a big data environment 34 Chapter 3: Old Meets New: Distributed Computing 37 A Brief History of Distributed Computing 37 Giving thanks to DARPA 38 The value of a consistent model 39 Understanding the Basics of Distributed Computing 40 Why we need distributed computing for big data 40 The changing economics of computing 40 The problem with latency 41 Demand meets solutions 41 Getting Performance Right 42 Part II: Technology Foundations for Big Data 45 Chapter 4: Digging into Big Data Technology Components 47 Exploring the Big Data Stack 48 Layer 0: Redundant Physical Infrastructure 49 Physical redundant networks 51 Managing hardware: Storage and servers 51 Infrastructure operations 51 Layer 1: Security Infrastructure 52 Interfaces and Feeds to and from Applications and the Internet 53 Layer 2: Operational Databases 54 Layer 3: Organizing Data Services and Tools 56 Layer 4: Analytical Data Warehouses 56 Big Data Analytics 58 Big Data Applications 58 Chapter 5: Virtualization and How It Supports Distributed Computing 61 Understanding the Basics of Virtualization 61 The importance of virtualization to big data 63 Server virtualization 64 Application virtualization 65 Network virtualization 66 Processor and memory virtualization 66 Data and storage virtualization 67 Managing Virtualization with the Hypervisor 68 Abstraction and Virtualization 69 Implementing Virtualization to Work with Big Data 69 Chapter 6: Examining the Cloud and Big Data 71 Defining the Cloud in the Context of Big Data 71 Understanding Cloud Deployment and Delivery Models 72 Cloud deployment models 73 Cloud delivery models 74 The Cloud as an Imperative for Big Data 75 Making Use of the Cloud for Big Data 77 Providers in the Big Data Cloud Market 78 Amazon’s Public Elastic Compute Cloud 78 Google big data services 79 Microsoft Azure 80 OpenStack 80 Where to be careful when using cloud services 81 Part III: Big Data Management 83 Chapter 7: Operational Databases 85 RDBMSs Are Important in a Big Data Environment 87 PostgreSQL relational database 87 Nonrelational Databases 88 Key-Value Pair Databases 89 Riak key-value database 90 Document Databases 91 MongoDB 92 CouchDB 93 Columnar Databases 94 HBase columnar database 94 Graph Databases 95 Neo4J graph database 96 Spatial Databases 97 PostGIS/OpenGEO Suite 98 Polyglot Persistence 99 Chapter 8: MapReduce Fundamentals 101 Tracing the Origins of MapReduce 101 Understanding the map Function 103 Adding the reduce Function 104 Putting map and reduce Together 105 Optimizing MapReduce Tasks 108 Hardware/network topology 108 Synchronization 108 File system 108 Chapter 9: Exploring the World of Hadoop 111 Explaining Hadoop 111 Understanding the Hadoop Distributed File System (HDFS) 112 NameNodes 113 Data nodes 114 Under the covers of HDFS 115 Hadoop MapReduce 116 Getting the data ready 117 Let the mapping begin 118 Reduce and combine 118 Chapter 10: The Hadoop Foundation and Ecosystem 121 Building a Big Data Foundation with the Hadoop Ecosystem 121 Managing Resources and Applications with Hadoop YARN 122 Storing Big Data with HBase 123 Mining Big Data with Hive 124 Interacting with the Hadoop Ecosystem 125 Pig and Pig Latin 125 Sqoop 126 Zookeeper 127 Chapter 11: Appliances and Big Data Warehouses 129 Integrating Big Data with the Traditional Data Warehouse 129 Optimizing the data warehouse 130 Differentiating big data structures from data warehouse data 130 Examining a hybrid process case study 131 Big Data Analysis and the Data Warehouse 133 The integration lynchpin 134 Rethinking extraction, transformation, and loading 134 Changing the Role of the Data Warehouse 135 Changing Deployment Models in the Big Data Era 136 The appliance model 136 The cloud model 137 Examining the Future of Data Warehouses 137 Part IV: Analytics and Big Data 139 Chapter 12: Defining Big Data Analytics 141 Using Big Data to Get Results 142 Basic analytics 142 Advanced analytics 143 Operationalized analytics 146 Monetizing analytics 146 Modifying Business Intelligence Products to Handle Big Data 147 Data 147 Analytical algorithms 148 Infrastructure support 148 Studying Big Data Analytics Examples 149 Orbitz 149 Nokia 150 NASA 150 Big Data Analytics Solutions 151 Chapter 13: Understanding Text Analytics and Big Data 153 Exploring Unstructured Data 154 Understanding Text Analytics 155 The difference between text analytics and search 156 Analysis and Extraction Techniques 157 Understanding the extracted information 159 Taxonomies 160 Putting Your Results Together with Structured Data 160 Putting Big Data to Use 161 Voice of the customer 161 Social media analytics 162 Text Analytics Tools for Big Data 164 Attensity 164 Clarabridge 165 IBM 165 OpenText 165 SAS 166 Chapter 14: Customized Approaches for Analysis of Big Data 167 Building New Models and Approaches to Support Big Data 168 Characteristics of big data analysis 168 Understanding Different Approaches to Big Data Analysis 170 Custom applications for big data analysis 171 Semi-custom applications for big data analysis 173 Characteristics of a Big Data Analysis Framework 174 Big to Small: A Big Data Paradox 177 Part V: Big Data Implementation 179 Chapter 15: Integrating Data Sources 181 Identifying the Data You Need 181 Exploratory stage 182 Codifying stage 184 Integration and incorporation stage 184 Understanding the Fundamentals of Big Data Integration 186 Defining Traditional ETL 187 Data transformation 188 Understanding ELT — Extract, Load, and Transform 189 Prioritizing Big Data Quality 189 Using Hadoop as ETL 191 Best Practices for Data Integration in a Big Data World 191 Chapter 16: Dealing with Real-Time Data Streams and Complex Event Processing 193 Explaining Streaming Data and Complex Event Processing 194 Using Streaming Data 194 Data streaming 195 The need for metadata in streams 196 Using Complex Event Processing 198 Differentiating CEP from Streams 199 Understanding the Impact of Streaming Data and CEP on Business 200 Chapter 17: Operationalizing Big Data 201 Making Big Data a Part of Your Operational Process 201 Integrating big data 202 Incorporating big data into the diagnosis of diseases 203 Understanding Big Data Workflows 205 Workload in context to the business problem 206 Ensuring the Validity, Veracity, and Volatility of Big Data 207 Data validity 207 Data volatility 208 Chapter 18: Applying Big Data within Your Organization 211 Figuring the Economics of Big Data 212 Identification of data types and sources 212 Business process modifications or new process creation 215 The technology impact of big data workflows 215 Finding the talent to support big data projects 216 Calculating the return on investment (ROI) from big data investments 216 Enterprise Data Management and Big Data 217 Defining Enterprise Data Management 217 Creating a Big Data Implementation Road Map 218 Understanding business urgency 218 Projecting the right amount of capacity 219 Selecting the right software development methodology 219 Balancing budgets and skill sets 219 Determining your appetite for risk 220 Starting Your Big Data Road Map 220 Chapter 19: Security and Governance for Big Data Environments 225 Security in Context with Big Data 225 Assessing the risk for the business 226 Risks lurking inside big data 226 Understanding Data Protection Options 227 The Data Governance Challenge 228 Auditing your big data process 230 Identifying the key stakeholders 231 Putting the Right Organizational Structure in Place 231 Preparing for stewardship and management of risk 232 Setting the right governance and quality policies 232 Developing a Well-Governed and Secure Big Data Environment 233 Part VI: Big Data Solutions in the Real World 235 Chapter 20: The Importance of Big Data to Business 237 Big Data as a Business Planning Tool 238 Stage 1: Planning with data 238 Stage 2: Doing the analysis 239 Stage 3: Checking the results 239 Stage 4: Acting on the plan 240 Adding New Dimensions to the Planning Cycle 240 Stage 5: Monitoring in real time 240 Stage 6: Adjusting the impact 241 Stage 7: Enabling experimentation 241 Keeping Data Analytics in Perspective 241 Getting Started with the Right Foundation 242 Getting your big data strategy started 242 Planning for Big Data 243 Transforming Business Processes with Big Data 244 Chapter 21: Analyzing Data in Motion: A Real-World View 245 Understanding Companies’ Needs for Data in Motion 246 The value of streaming data 247 Streaming Data with an Environmental Impact 247 Using sensors to provide real-time information about rivers and oceans 248 The benefits of real-time data 249 Streaming Data with a Public Policy Impact 249 Streaming Data in the Healthcare Industry 251 Capturing the data stream 251 Streaming Data in the Energy Industry 252 Using streaming data to increase energy efficiency 252 Using streaming data to advance the production of alternative sources of energy 252 Connecting Streaming Data to Historical and Other Real-Time Data Sources 253 Chapter 22: Improving Business Processes with Big Data Analytics: A Real-World View 255 Understanding Companies’ Needs for Big Data Analytics 256 Improving the Customer Experience with Text Analytics 256 The business value to the big data analytics implementation 257 Using Big Data Analytics to Determine Next Best Action 257 Preventing Fraud with Big Data Analytics 260 The Business Benefit of Integrating New Sources of Data 262 Part VII: The Part of Tens 263 Chapter 23: Ten Big Data Best Practices 265 Understand Your Goals 265 Establish a Road Map 266 Discover Your Data 266 Figure Out What Data You Don’t Have 267 Understand the Technology Options 267 Plan for Security in Context with Big Data 268 Plan a Data Governance Strategy 268 Plan for Data Stewardship 268 Continually Test Your Assumptions 269 Study Best Practices and Leverage Patterns 269 Chapter 24: Ten Great Big Data Resources 271 Hurwitz & Associates 271 Standards Organizations 271 The Open Data Foundation 272 The Cloud Security Alliance 272 National Institute of Standards and Technology 272 Apache Software Foundation 273 Oasis 273 Vendor Sites 273 Online Collaborative Sites 274 Big Data Conferences 274 Chapter 25: Ten Big Data Do’s and Don’ts 275 Do Involve All Business Units in Your Big Data Strategy 275 Do Evaluate All Delivery Models for Big Data 276 Do Think about Your Traditional Data Sources as Part of Your Big Data Strategy 276 Do Plan for Consistent Metadata 276 Do Distribute Your Data 277 Don’t Rely on a Single Approach to Big Data Analytics 277 Don’t Go Big Before You Are Ready 277 Don’t Overlook the Need to Integrate Data 277 Don’t Forget to Manage Data Securely 278 Don’t Overlook the Need to Manage the Performance of Your Data 278 Glossary 279 Index 295

Read more less

Book SynopsisOptimize reporting and BI with Microsoft SQL Server 2016 Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach.Table of ContentsINTRODUCTION xxix PART I: GETTING STARTED CHAPTER 1: INTRODUCING REPORTING SERVICES 3 Who Uses Reporting Services? 4 Information Workers and Data Analysts 5 Information Consumers 6 Business Managers and Leaders 6 Software Developers 6 System Administrators 7 Dashboards, Reports, and Applications 7 Application Integration 7 Business Intelligence and Analytics Solutions 10 Mobile Reports and KPIs 11 Report Tool Choices 14 Simple Report Design 15 IT-Designed Reports 16 User-Designed Reports 16 Server-Based Reports 17 Report Data Sources 18 Enterprise Scale 19 Optimizing Performance 19 Performance 20 Summary 20 CHAPTER 2: WHAT’S NEW IN SQL SERVER 2016 REPORTING SERVICES? 23 Report Builder and Designer Enhancements 25 Modern Browser Rendering 26 Parameter Layout Control 26 Updated RDL Specifi cation 27 Mobile Reports 28 KPIs 30 Native Printing Control 31 PowerPoint Rendering 31 Integrated and Improved Web Portal 31 New Charts and Visual Enhancements 32 Standardized, Modern Browser Rendering 33 Power BI Dashboard Pinning 33 Summary 36 CHAPTER 3: REPORTING SERVICES INSTALLATION AND ARCHITECTURE 39 What’s Changed in SQL Server 2016? 41 The Basic Installation 41 Installing Reporting Services 42 Installing the Reporting Services Samples, Exercises, and SQL Server Databases 56 The Enterprise Deployment 57 SQL Server Editions 58 Default and Named Instances 58 Topology 60 Modes 61 Installation Options 61 The Reporting Life Cycle 63 Authoring 63 Management 63 Delivery 64 Reporting Services Tools 64 Report Builder 64 Web Portal 64 SharePoint Libraries and Web Parts 64 Reporting Services Confi guration Manager 65 SQL Server Management Applications 65 Command-Line Utilities 65 HTML Viewer 66 Report Viewer Control 66 Reporting Services Web Service 67 Reporting Services Windows Service 68 HTTP.SYS and the HTTP Listener 69 The Security Sublayer 69 Web Portal and the Web Service 70 Core Processing 71 Service Management 71 WMI and the RPC Interface 72 Reporting Services Processors and Extensions 73 The Report Processor 74 Data Processing Extensions 75 Report Items 76 Rendering Extensions 77 The Scheduling and Delivery Processor 80 Delivery Extensions 80 Reporting Services Application Databases 80 ReportServer 80 ReportServerTempDB 82 Summary 82 PART II: BASIC REPORT DESIGN CHAPTER 4: REPORT LAYOUT AND FORMATTING 87 Using Report Design Tools 88 Understanding Report Data Building Blocks 89 Data Sources 89 Datasets 90 Data Regions 90 Report Items 93 Samples and Exercises 93 Preparing the Report Data 96 Designing the Report Layout 100 Reviewing the Report 104 Setting Formatting Properties 105 Validating Report Design and Grouping Data 108 Summary 112 CHAPTER 5: DATA ACCESS AND QUERY BASICS 113 Database Essentials 114 Relational Database Concepts 114 What’s a Sequel? 114 Data Source Management 115 Embedded and Shared Data Sources 115 Datasets and Fields 119 Embedded and Shared Datasets 120 Exercises 120 Authoring a Query with SQL Server Management Studio 120 Add the Query to the Report Dataset 124 Design the Report Body 128 Enhance the Parameter 131 Using Multiple Parameter Values 134 Summary 138 CHAPTER 6: GROUPING AND TOTALS 139 SQL Server Data Tools 140 Getting Started 140 Getting Started with Sample Reports Projects 144 Report Groups 150 Adding Totals to a Table or Matrix Report 153 Expression Basics 154 Introducing Aggregate Functions and Totals 155 Sorting 155 Exercise 158 Design the Dataset Query 158 Design and Lay Out a Table Report 160 Add Summary Totals and Drill-Down 163 Aggregate Detail Row Summaries 167 Create Parameter List 168 Summary 171 PART III: ADVANCED AND ANALYTIC REPORTING CHAPTER 7: ADVANCED REPORT DESIGN 175 Pagination and Flow Control 176 Headers and Footers 178 Tablix Headers and Detail Cells 182 Designing the Page Headers 182 Composite Reports and Embedded Content 187 Unlocking the Textbox 187 Padding and Indenting 188 Embedded Formatting 189 Designing Master/Detail Reports 195 Repeating Data Regions: Table, Matrix, and List 196 Groups and Dataset Scope 200 More Aggregate Functions and Totals 200 Designing Subreports 203 Federating Data with a Subreport 205 Navigating Reports 208 Creating a Document Map 209 Exercises 210 Exercise 1: Create a Report Template 210 Exercise 2: Create a Report from the Template with Dynamic Expressions 215 Summary 219 CHAPTER 8: GRAPHICAL REPORT DESIGN 221 Visual Design Principles 222 Keep Charts Simple 222 Properties, Oh My! 223 The Fashion of Visualization 223 Visual Storytelling 224 Perspective and Skewing 224 Chart Types 225 Chart Type Summary 225 Column and Stacked Charts 228 Area and Line Charts 229 Pie and Doughnut Charts 229 Bubble and Stock Charts 233 New Chart Types 233 The Anatomy of a Chart 235 Multiple Series, Axes, and Areas 237 Exercises 240 Exercise 1: Creating and Styling a Simple Chart 240 Exercise 2: Creating a Multi-series Chart 245 Useful Properties and Settings 248 Summary 249 CHAPTER 9: ADVANCED QUERIES AND PARAMETERS 251 T-SQL Queries and Parameters 252 Parameter Lists and Multi-select 252 Cascading Parameters 257 Arranging Parameters in the Parameter Bar 259 Managing Long Parameter Lists 259 All Value Selection 261 Handling Conditional Logic 264 MDX Queries and Parameters 266 Single-Valued Parameter 270 Multi-Valued Parameter 270 Date Value Ranges 271 Summary 275 CHAPTER 10: REPORTING WITH ANALYSIS SERVICES 277 Analysis Services for Reporting 278 Using Reporting Services with Analysis Services Data 279 Working with Multidimensional Expression Language 280 MDX: Simple or Complex? 280 Building Queries with the MDX Query Designer 281 Modifying an MDX Query 293 Adding Nonadditive Measures 302 When to Use the Aggregate Function 304 MDX Properties and Cube Formatting 305 Drill-Through Reports 307 Parameter Safety Precautions 308 Best Practices and Provisions 308 Summary 309 CHAPTER 11: SSAS REPORTING ADVANCED TECHNIQUES 311 Building a Dynamic Cube Browser with SSRS 312 Cube Dynamic Rows 312 Cube Dynamic Rows Anatomy 313 Cube Dynamic Rows Summary 322 Cube Dynamic Rows Expanded 324 MDX Query Modifi cations 324 Design Surface Modifi cations 325 Cube Restricting Rows 326 Designing the Report 326 Cube Metadata 332 Designing the Report 332 Adding Other Cube Metadata 336 Cube Browser 342 Anatomy of the Reports 342 Behind the Scenes 346 Final Thoughts 362 Summary 364 CHAPTER 12: EXPRESSIONS AND ACTIONS 365 Basic Expressions Recap 365 Using the Expression Builder 367 Calculated Fields 369 Conditional Expressions 371 The IIF() Function 372 Using Custom Code 375 Using Custom Code in a Report 376 Links and Drill-Through Reports 378 Reporting on Recursive Relationships 381 Actions and Report Navigation 385 Summary 392 PART IV: SOLUTION PATTERNS CHAPTER 13: REPORT PROJECTS AND CONSOLIDATION 397 SSDT Solutions and Projects 398 Project Structure and Development Phases 399 Shared Datasets and Data Sources 401 Key Success Factors 402 Report Specifi cations 403 Report Template 406 Version Control 407 Setting Up Version Control 408 Getting the Latest Version 408 Viewing a Report’s History 409 Restoring a Previous Version of a Report 409 Setting Check-out and Check-in Policies 409 Applying Labels 409 Synchronizing Content 409 Deploying an Individual Report 410 Deploying a Suite of Reports 410 Checking for Build Errors 410 Excluding a Report from a Deployment 410 Managing Server Content 410 Checking the Deployment Location 411 Managing Content in Native Mode 412 Managing Content in SharePoint 413 Report Builder and Self-Service Reporting Strategies 414 Report Builder and Semantic Model History 415 Planning a Self-Service Reporting Environment 416 You Need a Plan 416 Design Approaches and Usage Scenarios 416 Defi ne Ownership 417 Data Governance 418 Data Source Access and Security 419 User Education 419 Data Source and Query Options 421 User Report Migration Strategies 425 Review 425 Consolidate 426 Design 426 Test 426 Maintain 426 Summary 427 CHAPTER 14: REPORT SOLUTIONS, PATTERNS, AND RECIPES 429 Super Reports 430 Working with the Strengths and Limitations of the Reporting Services Architecture 431 Seeking the Excel Export Holy Grail 431 Report Recipes: Building on Basic Skills 435 Dashboard Solution Data Sources and Datasets 436 KPI Scorecard 437 Gauges 441 Interactive Sparkline and Chart 443 Thumbnail Map with Drill-Through Navigation 450 Summary 456 PART V: REPORTING SERVICES CUSTOM PROGRAMMING CHAPTER 15: INTEGRATING REPORTS INTO CUSTOM APPLICATIONS 461 URL Access 462 URL Syntax 463 Accessing Reporting Services Objects 463 Reporting Services URL Parameters 469 Passing Report Information Through the URL 474 Programmatic Rendering 477 Common Scenarios 478 Rendering Through Windows 479 Rendering to the Web 502 Using the ReportViewer Control 509 Embedding a Server-Side Report in a Windows Application 512 Summary 519 CHAPTER 16: EXTENDING REPORTING SERVICES 521 Extension Through Interfaces 524 What Is an Interface? 524 Interface Language Differences 524 A Detailed Look at Data Processing Extensions 527 Creating a Custom Data Processing Extension 529 The Scenario 530 Creating and Setting Up the Project 530 Creating the DataSetConnection Object 533 Creating the DataSetParameter Class 542 Implementing IDataParameter 543 Creating the DataSetParameterCollection Class 545 Creating the DataSetCommand Class 547 Creating the DataSetDataReader Object 562 Installing the DataSetDataProcessing Extension 566 Testing DataSetDataExtension 569 Summary 572 PART VI: MOBILE REPORT SOLUTIONS CHAPTER 17: INTRODUCING REPORTING SERVICES MOBILE REPORTS 575 The Mobile Report Experience and Business Case 576 Report Drill-Through Navigation 579 When to Use Mobile Reports 579 Connection and Dataset Design Basics 581 Introducing Mobile Report Publisher 581 Layout View 582 Data View 582 Dashboard Settings 583 Preview 583 Visual Control Categories 584 Navigators 585 Summary 592 CHAPTER 18: IMPLEMENTING A MOBILE REPORT WITH DESIGN-FIRST DEVELOPMENT 593 Design-First Mobile Report Development Exercise 593 Add Visual Controls 598 Preview the Mobile Report 601 Add Data to the Report 602 Apply Mobile Layouts and Color Styling 613 Test the Completed Mobile Report from the Server 616 Summary 620 CHAPTER 19: MOBILE REPORT DESIGN PATTERNS 623 Key Performance Indicators 623 The Thing About KPIs 630 You Need Goals 630 Time-Series Calculations and Time Grain 631 Creating a Time-Series Mobile Report 632 Lay Out the Report Using Design-First Report Development 633 Add Data and Set Control Data Properties 635 Set Color Palette and Mobile Device Layouts 642 Server Access and Live Mobile Connectivity 647 Summary 650 CHAPTER 20: ADVANCED MOBILE REPORT SOLUTIONS 653 Designing a Chart Data Grid Mobile Report 653 Exercise: Chart Data Grid 654 Exercise: Adding a Drill-Through Mobile Report 662 Exercise: Adding a Drill-Through Paginated Report 666 Getting Serious with Maps 671 Summary 676 PART VII: ADMINISTERING REPORTING SERVICES CHAPTER 21: CONTENT MANAGEMENT 679 Using Web Portal 680 Content Management Activities 683 Folders 684 Shared Data Sources 685 Reports 688 Report Resources 694 Shared Schedules 695 Site and Content Security 696 Site Security 697 Item-Level Security 697 Site Branding 707 Content Management Automation 710 The RS Utility 710 Reporting Services Scripts 713 Summary 714 CHAPTER 22: SERVER ADMINISTRATION 715 Security 716 Account Management 717 System-Level Roles 721 Surface Area Management 723 Backup and Recovery 724 Application Databases 725 Encryption Keys 727 Confi guration Files 730 Other Items 730 Monitoring 731 Setup Logs 731 Windows Application Event Logs 731 Trace Logs 732 Execution Logs 735 Performance Counters 736 Server Management Reports 741 Confi guration 742 Memory Management 742 URL Reservations 743 E-mail Delivery 745 Rendering Extensions 747 My Reports 749 Summary 751 INDEX 753

Read more less

Book SynopsisEasy steps to practical databases People who really know how to build, populate, and simplify databases are few and far between. Access 2019 For Dummies is here to help you join the ranks of office heroes who possess these precious skills. This book offers clear and simple advice on how to build and operate databases as well as create simple forms, import data from outside sources, query databases for information, and share knowledge in reports. In short, it's the book that holds all the secrets behind the mysteries of Access! Build effective databases from the ground upSimplify your data entry with forms and tablesWrite queries that produce answers to your data questionsSimplify input with forms There's no time like the present to get your hands on the insight that database beginners need to become Access gurus.Table of ContentsIntroduction 1 About This Book 1 Foolish Assumptions 2 Icons Used in This Book 2 Where to Go from Here 3 Part 1: Basic Training 5 Chapter 1: Access 2019 Basic Training 7 What Is Access Good For, Anyway? 8 Building big databases 8 Creating databases with multiple tables 9 Databases with user forms 12 Databases that require special reporting 13 What’s New in Access 2019? 16 Reach Out with SharePoint 17 How Access Works and How You Work with it 18 Opening Access 18 Selecting a starting point 19 Now What? 23 Chapter 2: Navigating the Access Workspace 25 Diving Right In 27 Working with Onscreen Tools in Access 29 Clicking tabs 30 Using buttons 31 The File tab and Quick Access tools 31 Accessing panes, panels, and context-sensitive tools 33 Customizing the Access Workspace 34 Repositioning the Quick Access Toolbar 34 Adding buttons to the Quick Access Toolbar 35 Removing buttons from the Quick Access Toolbar 37 Minimizing the Ribbon 37 Working with ScreenTips 38 Mousing Around 41 Navigating Access with the Alt Key 41 Chapter 3: Database Basics 43 Database Lingo 43 Data, no matter how you pronounce it 44 Fields of dreams (or data) 44 Records 45 Tables 45 The database 45 Field Types and Uses 46 Choosing Between Flat and Relational Databases 51 Isolationist tables 51 Tables that mix and mingle 52 Building a Database 53 Adding and Removing Tables 57 One more, please 57 Oops, I didn’t mean to do that 59 Part 2: Getting it All on the Table 61 Chapter 4: Sounds Like a Plan 63 Planning Your Database Tables 63 Reviewing fields 64 Determining data types 64 The new normal 66 Understanding normal forms 66 Normalizing your tables 67 Building Tables in Design View 70 Creating fields 70 Setting data types 72 Chapter 5: Table Tune Ups 75 The Primary Key to Success 76 The lowdown on primary keys 76 Creating a primary key 77 Making Tables Get Along 79 Rules of relationships 79 Relationship types 80 Building Table Relationships 82 The Relationships window 82 Table relationships 83 Indexing for Faster Queries 87 Creating your own index 88 Adding and removing indexes 91 Chapter 6: Remodeling Your Data 93 Opening a Table for Editing 94 Inserting Records and Fields 97 Adding a record 97 Inserting a field 98 Deleting a field 101 Modifying Field Content 102 Name-Calling 103 Renaming fields 104 Renaming a table 106 Turn Uh-Oh! into Yee-Hah! 108 Chapter 7: Types, Masks, and Triggers 109 Access Table Settings 110 Field Data Formats 112 Text fields 113 Number and currency fields 115 Date/time fields 118 Yes/No fields 119 Gaining Control of Data Entry 121 You really need to put a mask on those fields 121 To require or not to require 128 Making your data toe the line with validation 129 Give Your Fingers a Mini Vacation by Default 131 Part 3: Data Management Mania 133 Chapter 8: A Form for All Reasons 135 Generating Forms 135 Keeping it simple: Form tools 137 Granting most wishes: The Form Wizard 139 Customizing Form Parts 143 Taking the Layout view 143 The theme’s the thing 145 Managing form controls 145 Managing Data in Form View 150 Navigating and finding records 150 Saving, clearing, and deleting 151 Chapter 9: Importing and Exporting Data 153 Retrieving Data from Other Sources 154 Translating data formats 154 Importing and linking 157 Hit the Road, Data 162 Export formats 162 Exporting table or query data 163 Exporting a report to PDF 165 Chapter 10: Automatically Editing Data 167 Please Read This First! 167 Creating Consistent Corrections 170 Using Queries to Automate the Editing Process 173 Looking for duplicate records 173 Running the Find Duplicates Query Wizard 174 Chapter 11: Access and the Web 179 How Access Works with the Web 179 Understanding Office 365 180 Connect Office 365 to Access 2019 181 Your data and the cloud 182 Upload your Access desktop data to the cloud 183 Click! Using Hyperlinks in your desktop Access database 186 Adding a Hyperlink field to your desktop database table 187 Fine-tuning your hyperlinks 188 Testing links 190 Part 4: The Power of Questions 191 Chapter 12: Finding, Filtering, and Sorting Your Data — Fast 193 Using the Find Command 194 Finding anything fast 194 Shifting Find into high gear 196 Sorting Alphabetically and Numerically 199 Sorting by a single field 199 Sorting on more than one field 200 Fast and Furious Filtering 201 Filtering by a field’s content 202 Filter by selection 203 Filter by Form 204 Unfiltering Filter by Form 207 Filter by excluding selection 207 Chapter 13: I Was Just Asking for Answers 209 Simple (Yet Potent) Filter and Sort Tools 210 Filter things first 210 Fact-finding with fun, fast filtering 213 Here’s the “advanced” part 214 Select Queries 220 Solid relationships are the key to getting it all (from your tables) 221 Running the Query Wizard 221 Getting Your Feet Wet with Ad Hoc Queries 227 Adding the finishing touches 230 Saving the query 231 Running your query 233 Chapter 14: I Want These AND Those OR Them 235 Working with AND and/or OR 236 Data from here to there 237 Using multiple levels of AND 238 Establishing criteria with OR 239 Combining AND with OR and OR with AND 240 Chapter 15: Number Crunching with the Total Row 243 Say Hello to the Total Row 243 Adding the Total Row to Your Queries 245 Working Out the Total Row 246 Putting it together with Group By 247 Well, that certainly sums it up 248 Counting, the easy way 250 Narrowing the results with Where 251 Creating Your Own Top-Ten List 252 Choosing the Right Field for the Summary Instruction 254 Chapter 16: Express Yourself with Formulas 255 A Simple Calculation 256 Complex Calculations 258 Calculate ’til you drop! 259 Using one calculation in another 259 Using parameter queries to ask for help 261 “Adding” words with text formulas 262 Hooray for Expression Builder 264 Chapter 17: Take Charge with Action Queries 269 Easy Update 270 Add Records in a Flash 274 Quick Cleanup 277 Part 5: Simple and Snazzy Reporting 281 Chapter 18: Fast and Furious Automatic Reporting 283 Quick and Not-S0-Dirty Automatic Reporting 284 Creating a quick, one-table report 285 Starting the Report Wizard 289 Previewing Your Report 294 Zooming in and out and all around 295 Pop goes the menu 297 Beauty Is Only Skin (Report) Deep 298 The Print Options tab 298 The Page tab 300 The Columns tab 301 Chapter 19: Professionally Designed Reports Made Easy 303 Report Repairs 304 Report Organization 305 Structural devices 306 Page breaks 308 Formatting Stuff 310 Adding color 313 Relocation, relocation, relocation 314 One size does not fit all 316 Spaced-out controls 317 Borderline beauty 318 Tweaking your text 321 Sneaking a Peek 323 Getting a Themes Makeover 324 Adding More Design Elements 325 Drawing lines 325 Pretty as a picture 326 Adding a logo 327 Chapter 20: Groups and Page Breaks, Headers and Footers 329 A Place for Everything and Everything in Its Place 330 Layout basics 330 Sections 332 Grouping your records 335 So you want more? 338 Customizing Properties 338 Controlling report and page headings 341 Adjusting individual sections 343 Itemized adjustments 344 Chapter 21: Mailings to the Masses 351 Massive Mailings with the Label Wizard 351 Part 6: The Parts of Tens 359 Chapter 22: Ten Common Problems 361 That’s Just Not Normal 362 You Type 73.725, but it Changes to 74 363 The Words They Are A-Changing 363 Was There and Now It’s Gone 364 Undo 365 Search for the missing record 365 Backup recovery 365 You Run a Query, but the Results Aren’t What You Expect 366 The Dreaded Parameter Dialog Box 367 The Slowest Database in Town 368 Your Database File Is as Big as a House 369 You Get a Mess When Importing Your Spreadsheet 371 We’re Sorry; Your Database File Is Corrupt 371 Chapter 23: Ten Uncommon Tips 373 Document Everything as Though One Day You’ll Be Questioned by the FBI 374 Keep Your Fields as Small as Possible 375 Use Number Fields for Real Numbers 376 Validate Your Data 376 Use Understandable Names to Keep Things Simple 377 Delete with Great Caution 377 Backup, Backup, Backup 377 Think, Think, and Think Again 378 Get Organized and Stay Organized 378 There’s No Shame in Asking for Help 379 Appendix A: Getting Help 381 Index 383

Read more less

Book SynopsisA hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. Provides the perfect mix of practice and theory Helps you become a DIY Excel modelling specialist Includes updates for Excel 2019/365 and Excel for Table of ContentsPreface xi Chapter 1 What is Financial Modelling? 1 What’s the Difference Between a Spreadsheet and a Financial Model? 3 Types and Purposes of Financial Models 5 Tool Selection 6 What Skills Do You Need to Be a Good Financial Modeller? 17 The “Ideal” Financial Modeller 23 Summary 27 Chapter 2 Building a Model 29 Model Design 29 The Golden Rules for Model Design 31 Design Issues 32 The Workbook Anatomy of a Model 33 Project Planning Your Model 36 Model Layout Flowcharting 37 Steps to Building a Model 39 Information Requests 47 Version-Control Documentation 49 Summary 50 Chapter 3 Best-Practice Principles of Modelling 51 Document Your Assumptions 51 Linking, Not Hardcoding 52 Enter Data Only Once 53 Avoid Bad Habits 53 Use Consistent Formulas 53 Format and Label Clearly 54 Methods and Tools of Assumptions Documentation 55 Linked Dynamic Text Assumptions Documentation 62 What Makes a Good Model? 65 Summary 67 Chapter 4 Financial Modelling Techniques 69 The Problem with Excel 69 Error Avoidance Strategies 71 How Long Should a Formula Be? 76 Linking to External Files 78 Building Error Checks 81 Circular References 85 Summary 90 Chapter 5 Using Excel in Financial Modelling 91 Formulas and Functions in Excel 91 Excel Versions 94 Handy Excel Shortcuts 100 Cell Referencing Best Practices 104 Named Ranges 107 Basic Excel Functions 110 Logical Functions 114 Nesting Logical Functions 117 Summary 125 Chapter 6 Functions for Financial Modelling 127 Aggregation Functions 127 LOOKUP Functions 139 Nesting Index and Match 150 OFFSET Function 153 Regression Analysis 158 Choose Function 164 Working with Dates 165 Financial Project Evaluation Functions 171 Loan Calculations 177 Summary 183 Chapter 7 Tools for Model Display 185 Basic Formatting 185 Custom Formatting 186 Conditional Formatting 191 Sparklines 195 Bulletproofing Your Model 199 Customising the Display Settings 203 Form Controls 210 Summary 226 Chapter 8 Tools for Financial Modelling 227 Hiding Sections of a Model 227 Grouping 233 Array Formulas 234 Goal Seeking 240 Structured Reference Tables 242 PivotTables 245 Macros 254 Summary 263 Chapter 9 Common Uses of Tools in Financial Modelling 265 Escalation Methods for Modelling 265 Understanding Nominal and Effective (Real) Rates 270 Calculating a Cumulative Sum (Running Totals) 274 How to Calculate a Payback Period 275 Weighted Average Cost of Capital (WACC) 278 Building a Tiering Table 282 Modelling Depreciation Methods 286 Break-Even Analysis 295 Summary 300 Chapter 10 Model Review 301 Rebuilding an Inherited Model 301 Improving Model Performance 312 Auditing a Financial Model 317 Summary 323 Appendix: QA Log 323 Chapter 11 Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling 325 What are the Differences Between Scenario, Sensitivity, and What-If Analyses? 326 Overview of Scenario Analysis Tools and Methods 328 Advanced Conditional Formatting 337 Comparing Scenario Methods 340 Adding Probability to a Data Table 350 Summary 351 Chapter 12 Presenting Model Output 353 Preparing an Oral Presentation for Model Results 353 Preparing a Graphic or Written Presentation for Model Results 355 Chart Types 358 Working with Charts 367 Handy Charting Hints 374 Dynamic Named Ranges 376 Charting with Two Different Axes and Chart Types 382 Bubble Charts 384 Creating a Dynamic Chart 387 Waterfall Charts 391 Summary 395 About the Author 397 About the Website 399 Index 403

Read more less

Book SynopsisOracle Database Programming with Visual Basic.NET Discover a detailed treatment of the practical considerations and applications of Oracle database programming with Visual Basic 2019 Oracle Database Programming with Visual Basic.NET: Concepts, Designs, and Implementations delivers a comprehensive exploration of the foundations of Oracle database programming using Visual Basic.NET. Using Visual Basic.NET 2019, Visual Studio.NET 2019, and Oracle 18c XE, the book introduces the Oracle database development system, Oracle SQL Developer and Modeler, and teaches readers how to implement a sample database solution. The distinguished author also demonstrates the use of dotConnect for Oracle to show readers how to create an effective connection to an Oracle 18c XE database. The current versions of the .NET framework, ASP.NET, and ASP.NET 4.7 are also explored and used to offer readers the most up to date web database programming techniques available today. The book provides practical example p

Read more less

Book SynopsisPro SQL Server 2008 Administration is critical for database administrators seeking in-depth knowledge on administering SQL Server 2008. This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server. Introduces new administration features of SQL Server 2008 Shows how to manage a SQL Server 2008 database at professional level Provides guidance on performance optimization Table of Contents New Feature Overview Pre-Installation Considerations Choosing a High Availability Solution Installing Microsoft SQL Server 2008 Upgrading to Microsoft SQL Server 2008 Post Installation Multi-Server Administration Managing Security within the Database Engine Administering Database Objects Indexing for Performance Managing Backups Restore and Recovery Strategies Automating Routine Maintenance Monitoring Your Server Auditing SQL Server Managing Query Performance Secrets to Excelling as a Professional DBA What's Next?

Read more less

Book SynopsisUpdates the premier textbook for students and librarians needing to know the landscape of current databases and how to search them.Librarians need to know of existing databases, and they must be able to teach search capabilities and strategies to library users.

Read more less

Book SynopsisFileMaker Pro 12: The Missing Manual is the clear, thorough, and accessible guide to the latest version of this popular desktop database program. This book shows you how use FileMaker to make information work for you -- print a catalog, plan your retirement, or run a small business.

Read more less

Book SynopsisServer bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it's running on hardware, virtual machines, or in the cloud.

Read more less

Book SynopsisUnlock the secrets of Access 2013 and discover how to use your data in creative ways. With this book's easy step-by-step instructions, you'll learn how to build and maintain a full-featured database and even turn it into a web app.

Read more less

Book SynopsisAccess is the most complex and intimidating application in Microsoft Office. This book helps you learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. It lets you discover the pre-built databases which can be customized to fit your needs.

Read more less

Book SynopsisMake information work for you with the FileMaker Pro 11 desktop database and FileMaker Pro 11: The Missing Manual. This book helps you get started, build your database, and produce results, whether you're running a business, pursuing a hobby, or planning your retirement.

Read more less

Book SynopsisLearn the basics of writing SQL scripts. Using Standard SQL as the starting point, this book teaches writing SQL in various popular dialects, including PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle, and SQLite. The book starts with a general introduction to writing SQL and covers the basic concepts. Author Mark Simon then covers database principles, and how database tables are designed. He teaches you how to filter data using the WHERE clause, and you will work with NULL, numbers, dates, and strings. You will also understand sorting results using the ORDER BY clause, sorting by calculated columns, and limiting the number of results. By the end of the book, you will know how to insert and update data, and summarize data with aggregate functions and groups. Three appendices cover differences between SQL dialects, working with tables, and a crash course in PDO. What You Will LearnFilter, sort, andcalculate dataSummarize data with aggregate functionsModify data with insert, uTable of ContentsThe appendix will include: Notes on using SQL with PHP “Cultural Notes” - a description of some of the sample data Major Differences between DBMSs Setting up the Sample Database

Read more less

Book SynopsisThe best practices in this practical guide help you design database schemas that not only interoperate with other Hadoop components, and are convenient for administers to manage and monitor, but also accommodate future expansion in data size and evolution of software capabilities.

Read more less

Book SynopsisThe fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c. Whether you're a developer or database administrator, when you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration

Read more less

Book SynopsisWhether you're pursuing a multitenant private cloud, a network for running machine learning, or an enterprise data center, author Dinesh Dutt takes you through the steps necessary to design a data center that's affordable, high capacity, easy to manage, agile, and reliable.

Read more less

Book SynopsisMaintaining the advanced technical focus found in Developing Essbase Applications, this second volume is another collaborative effort by some of the best and most experienced Essbase practitioners from around the world.Developing Essbase Applications: Hybrid Techniques and Practices reviews technology areas that are much-discussed but still very new, including Exalytics and Hybrid Essbase. Covering recent improvements to the Essbase engine, the book illustrates the impact of new reporting and analysis tools and also introduces advanced Essbase best practices across a variety of features, functions, and theories.Some of this book's chapters are in the same vein as the previous volume: hardware, engines, and languages. Others cover new ground with Oracle Business Intelligence Enterprise Edition, design philosophy, benchmarking concepts, and multiple client tools. As before, these subjects are covered from both the technical and best practice perspectives.Trade Review"I enjoyed the first book because it was a collection of best practices, tips, tricks, and mini-guides. ... Reading this book, I was happy to find a wider representation of topics: brand new, forward-looking features like Hybrid Aggregation Mode; popular product offerings such as Exalytics and Oracle Business Intelligence Enterprise Edition integrations; topics relevant to many existing implementations; and even a representation of partner products."—Gabby Rubin, Senior Director, Product Management, Oracle Business AnalyticsTable of ContentsIntroduction. Essbase on Exalytics and the "Secret Sauce". Hybrid Essbase: Evolution or Revolution? The Young Person’s Guide to Essbase Cube Design. Essbase Performance and Load Testing. Utilizing Structured Query Language to Enhance Your Essbase Experience. Copernicus Was Right: Integrating Oracle Business Intelligence and Essbase. Managing Spreadsheets (and Essbase) Through Dodeca. Smart View Your Way.

Read more less

Book SynopsisPrepare for Microsoft Exam 70-765–and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Implement SQL in Azure • Manage databases and instances • Manage storage This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills Provisioning SQL Databases About the Exam Exam 70-765 focuses on skills and knowledge for provisioning, upgrading, and configuring SQL Server; managing databases and files; and provisioning, migrating, and managing databases in the Microsoft Azure cloud. About Microsoft Certification Passing this exam as well as Exam 70-764: Administering a SQL Database Infrastructure earns you MCSA: SQL 2016 Database Administration certification, qualifying you for a position as a database administrator or infrastructure specialist. See full details at: microsoft.com/learning Table of ContentsIntroduction Chapter 1 Implement SQL in Azure Skill 1:1: Deploy a Microsoft Azure SQL Database Skill 1:2: Plan for SQL Server installation Skill 1:3: Deploy SQL Server instances Skill 1:4: Deploy SQL Server databases to Azure virtual machines Chapter 2 Manage databases and instances Skill 2.1: Configure secure access to Microsoft Azure SQL databases Skill 2.2: Configure SQL Server performance settings Skill 2.3: Manage SQL Server instances Chapter 3 Manage Storage Skill 3.1: Manage SQL Storage Skill 3.2: Perform database maintenance

Read more less

Book Synopsis

Read more less