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 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