Database software Books
O'Reilly Media MySQL Pocket Reference 2e
Book SynopsisMySQL contains so many features that no administrator or programmer can memorize all the functions. This book is a useful on-the-job companion, organized to help you find the statements you need at work. It gives you reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure.
£10.79
O'Reilly Media Access 2007 The Missing Manual
Book Synopsis
£20.99
O'Reilly Media Access 2007 for Starters
Book SynopsisHelps you learn how to design databases, maintain them, search for valuable nuggets of information, and build attractive forms for data entry.Table of ContentsThe Missing Credits Introduction What You Can Do with Access The New Face of Access 2007 About This Book One:. Storing Information in Tables Chapter 1. Creating Your First Database Understanding Access Databases Getting Started Saving and Opening Access Databases The Navigation Pane Chapter 2. Building Smarter Tables Understanding Data Types Design View Access Data Types The Primary Key Six Principles of Database Design Chapter 3. Mastering the Datasheet: Sorting, Searching, Filtering, and More Datasheet Customization Datasheet Navigation Printing the Datasheet Chapter 4. Blocking Bad Data Data Integrity Basics Input Masks Validation Rules Lookups Chapter 5. Linking Tables with Relationships Relationship Basics Using a Relationship More Exotic Relationships Relationship Practice Two:. Manipulating Data with Queries Chapter 6. Queries That Select Records Query Basics Creating Queries Queries and Related Tables Query Power: Calculated Fields and Text Expressions Calculated Fields Chapter 7. Queries That Update Records Understanding Action Queries Update Queries Append Queries Delete Queries Three:. Printing Reports and using forms Chapter 8. Creating Reports Report Basics Printing, Previewing, and Exporting a Report Formatting a Report Filtering and Sorting a Report Chapter 9. Creating Simple Forms Form Basics Creating a Simple Form Using a Form Sorting and Filtering in a Form The Form Wizard Four:. Sharing access with the rest of the world Chapter 10. Importing and Exporting Data Case for Importing and Exporting Using the Clipboard Import and Export Operations Index
£13.59
Pearson Education (US) SQL Server 2016 High Availability Unleashed
Book Synopsis
£27.74
Microsoft Press,U.S. Training Kit Exam 70462 Administering Microsoft
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.
£47.71
EMC Paradigm,US Benchmark Series Microsoft Access 2019 Levels 12
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.
£93.60
EMC Paradigm,US Benchmark Series Microsoft Access 2019 Level 2
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.
£67.60
IEEE Computer Society Press,U.S. Parallel Database Techniques
Book Synopsis
£72.86
Intellect Books Building a Deductive Database
Book SynopsisThis text illustrates the main issues and concepts behind deductive databases through the description of a real system. The text covers all related topics from basic theory to its coupling with a known database management system and its implementation on a commerical multiprocessor.Table of ContentsPreface vii 1 The Logic-Based Approach to Knowledge Bases 1 1.1 Declarative Programming 1 1.2 Logic Programming 2 1.3 Knowledge-Based Systems 3 1.4 Modeling a Knowledge-Based System 4 1.5 Interfacing a Deductive Component to a Database 6 1.6 Controlling Recursive Inference 10 2 Mixed Top-Down, Bottom-Up Execution 11 2.1 A General Interpreter for Logic Programs 13 2.2 Reducing Horn Clauses 18 2.3 Architectural Aspects 32 2.4 The Unification Process 36 2.5 Variable Analysis 39 2.6 Performance Aspects 41 3 Structures 59 3.1 Handling Structures in the Inference Mechanism 60 3.2 Handling Structures in the Database 61 4 Recursion 73 4.1 General Breadth Search Strategy for Solving Recursive Clauses 74 4.2 Linear Horn Clauses without Function Symbols 76 4.3. Linear-Recursive Horn Clauses with Structured Arguments 92 4.4 Summary 108 5 Sharing Relations 111 5.1 The Trash Concept 112 5.2 Implementation Aspects 117 5.3 Deterministic Programs 122 54 Sharing Relations in the Presence of Recursive Clauses 124 6 Semantic Aspects 141 6.1 A Declarative Language and its I/O Restrictions 142 6.2 The Logical Cut 144 6.3 Negation 146 6.4 Built-in Predicates 148 7 Building a Deductive Database with a Relational DBMS 157 7.1 Ingres 158 7.2 Software Architecture 159 7.3 The EDB Stack 159 7.4 Recursion 166 8 Parallel Processing of Deductive Databases 175 8.1 Parallelizing Logic Programs 175 8.2 Implementation of OR parallelism 178 8.3 Analyzing Performance on a Sequent Symmetry 182 Appendix: IISProlog User's Manual 189 Glossary 251 References 253 Author Index 261 Subject Index 265
£20.42
O'Reilly Media CockroachDB The Definitive Guide
Book SynopsisIn this hands-on guide, software developers, architects, and DevOps/SRE teams will learn how to use CockroachDB to create applications that scale elastically and provide seamless delivery for end users while remaining indestructible.
£63.99
John Wiley & Sons Inc Professional Microsoft SQL Server 2012 Reporting
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
£36.09
John Wiley & Sons Inc Beginning Microsoft SQL Server 2012 Programming
Book SynopsisGet up to speed on the extensive changes to the newest release of Microsoft SQL Server The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server.Table of ContentsINTRODUCTION xxv CHAPTER 1: RDBMS BASICS: WHAT MAKES UP A SQL SERVER DATABASE? 1 An Overview of Database Objects 2 SQL Server Data Types 13 SQL Server Identifiers for Objects 19 Summary 21 CHAPTER 2: LEARNING THE TOOLS OF THE TRADE 23 Getting Help with Books Online 24 SQL Server Configuration Manager 25 SQL Server Management Studio 31 SQL Server Data Tools (formerly BIDS) 43 SQL Server Integration Services (SSIS) 44 SQL Server Reporting Services (SSRS) 45 SQL Server Analysis Services (SSAS) 45 Bulk Copy Program (BCP) 46 SQL Server Profiler 46 sqlcmd 46 PowerShell 47 Summary 47 CHAPTER 3: THE FOUNDATION STATEMENTS OF T-SQL 49 Getting Started with a Basic SELECT Statement 50 Adding Data with the INSERT Statement 76 Changing What You’ve Got with the UPDATE Statement 84 The DELETE Statement 87 Summary 88 CHAPTER 4: JOINS 91 Combining Table Data with JOINs 92 Selecting Matching Rows with INNER JOIN 93 Retrieving More Data with OUTER JOIN 102 Seeing Both Sides with FULL JOINs 115 Understanding CROSS JOINs 117 Exploring Alternative Syntax for Joins 118 Stacking Results with UNION 121 Summary 125 CHAPTER 5: CREATING AND ALTERING TABLES 129 Object Names in SQL Server 130 The CREATE Statement 134 The ALTER Statement 155 The DROP Statement 164 Using the GUI Tool 165 Summary 171 CHAPTER 6: KEYS AND CONSTRAINTS 175 Types of Constraints 176 Constraint Naming 178 Key Constraints 179 CHECK Constraints 197 DEFAULT Constraints 199 Disabling Constraints 201 Rules and Defaults — Cousins of Constraints 206 Triggers for Data Integrity 210 Choosing What to Use 210 Summary 211 CHAPTER 7: ADDING MORE TO YOUR QUERIES 213 What Is a Subquery? 214 Building Correlated Subqueries 218 Derived Tables 225 Using Common Table Expressions (CTEs) 228 Using the EXISTS Operator 232 Mixing Data Types: CAST and CONVERT 236 Synchronizing Data with the MERGE Command 239 Gathering Affected Rows with the OUTPUT Clause 243 Through the Looking Glass: Windowing Functions 246 One Chunk at a Time: Ad Hoc Query Paging 251 Performance Considerations 252 CHAPTER 8: BEING NORMAL: NORMALIZATION AND OTHER BASIC DESIGN ISSUES 257 Understanding Tables 258 Keeping Your Data “Normal” 258 Understanding Relationships 270 Diagramming Databases 279 Denormalization 291 Beyond Normalization 291 Drawing Up a Quick Example 293 Summary 302 CHAPTER 9: SQL SERVER STORAGE AND INDEX STRUCTURES 305 SQL Server Storage 306 Understanding Indexes 308 Creating, Altering, and Dropping Indexes 323 Choosing Wisely: Deciding Which Index Goes Where and When 331 Maintaining Your Indexes 345 Summary 350 CHAPTER 10: VIEWS 353 Creating Simple Views 354 Editing Views with T-SQL 367 Dropping Views 367 Creating and Editing Views in the Management Studio 367 Auditing: Displaying Existing Code 371 Protecting Code: Encrypting Views 373 About Schema Binding 374 Making Your View Look like a Table with VIEW_METADATA 375 Indexed (Materialized) Views 375 Indexing an Aggregate View 378 Summary 381 CHAPTER 11: WRITING SCRIPTS AND BATCHES 383 Understanding Script Basics 384 Grouping Statements into Batches 399 Running from the Command Prompt: sqlcmd 405 Dynamic SQL: Using the EXEC Command 409 Using Control-of-Flow Statements 415 Summary 431 CHAPTER 12: STORED PROCEDURES 435 Creating the Sproc: Basic Syntax 436 Changing Stored Procedures with ALTER 438 Dropping Sprocs 438 Parameterizing Sprocs 438 More on Dealing with Errors 448 What a Sproc Offers 468 Extended Stored Procedures (XPs) 472 A Brief Look at Recursion 472 Debugging 475 Understanding .NET Assemblies 484 When to Use Stored Procedures 485 Summary 486 CHAPTER 13: USER-DEFINED FUNCTIONS 489 What a UDF Is 489 UDFs Returning a Scalar Value 491 UDFs That Return a Table 496 Debugging User-Defined Functions 506 Using .NET in a Database World 507 Summary 507 CHAPTER 14: TRANSACTIONS AND LOCKS 509 Understanding Transactions 509 How the SQL Server Log Works 514 Understanding Locks and Concurrency 518 Setting the Isolation Level 527 Dealing with Deadlocks (aka “a 1205”) 531 Summary 534 CHAPTER 15: TRIGGERS 537 What Is a Trigger? 538 ON 540 WITH ENCRYPTION 540 FOR|AFTER 540 The FOR|AFTER versus the INSTEAD OF Clause 541 NOT FOR REPLICATION 543 AS 543 Using Triggers for Data Integrity Rules 543 Dealing with Requirements Sourced from Other Tables 544 Using Triggers to Check the Delta of an Update 545 Using Triggers for Custom Error Messages 547 Other Common Uses for Triggers 548 Other Trigger Issues 548 Triggers Can Be Nested 548 Triggers Can Be Recursive 549 Triggers Don’t Prevent Architectural Changes 549 Triggers Can Be Turned Off without Being Removed 550 Trigger Firing Order 550 INSTEAD OF Triggers 552 Performance Considerations 552 Triggers Are Reactive Rather Than Proactive 552 Triggers Don’t Have Concurrency Issues with the Process That Fires Them 553 Using IF UPDATE() and COLUMNS_UPDATED 553 Keep It Short and Sweet 556 Don’t Forget Triggers When Choosing Indexes 556 Try Not to Roll Back within Triggers 556 Dropping Triggers 556 Debugging Triggers 557 Summary 558 CHAPTER 16: A BRIEF XML PRIMER 561 XML Basics 562 What SQL Server Brings to the Party 577 A Brief Word on XSLT 610 Summary 613 CHAPTER 17: BUSINESS INTELLIGENCE FUNDAMENTALS 615 What Is Business Intelligence? 616 Those Who Forget History: The Data Warehouse 619 Dimensional Modeling: Why Be Normal? 624 ETLs 637 Making Your Data Actionable: BI Reporting Techniques 642 Summary 647 CHAPTER 18: BI STORAGE AND REPORTING RESOURCES 649 SQL Server Analysis Services, or How I Learned to Stop Worrying and Love the Cube 661 Building Your First Cube 663 Self-Service BI: User Tools 675 Summary 678 CHAPTER 19: REPORTING FOR DUTY, SIR! A LOOK AT REPORTING SERVICES 681 Reporting Services 101 682 Understanding the SSRS Report Lifecycle 683 Understanding the Reporting Services Architecture 684 Building Simple Report Models 686 Report Server Projects 711 Summary 717 CHAPTER 20: GETTING INTEGRATED WITH INTEGRATION SERVICES 719 Understanding the Problem 720 Using the Import/Export Wizard to Generate Basic Packages 720 Examining Package Basics 727 Executing Packages 738 A Final Word on Packages 745 Summary 745 CHAPTER 21: PLAYING ADMINISTRATOR 747 Scheduling Jobs 748 Logins and Users 760 Backup and Recovery 764 Index Maintenance 770 Policy Based Management 774 Automating Administration Tasks with PowerShell 775 Summary 779 APPENDIX: ANSWERS TO EXERCISES 783 INDEX 807 ONLINE APPENDICES BONUS APPENDIX 1: SYSTEM FUNCTIONS 1 BONUS APPENDIX 2: VERY SIMPLE CONNECTIVITY EXAMPLES 69
£26.34
John Wiley & Sons Inc Big Data For Dummies
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
£20.79
John Wiley & Sons Inc Professional Microsoft SQL Server 2016 Reporting
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
£34.00
John Wiley & Sons Inc Access 2019 For Dummies
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
£20.79
John Wiley & Sons Inc Using Excel for Business and Financial Modelling
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
£56.70
John Wiley & Sons Inc Oracle Database Programming with Visual Basic.Net
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
£62.06
John Wiley & Sons Inc Access For Dummies
Book SynopsisTable of ContentsIntroduction 1 Part 1: Basic Training 5 Chapter 1: Access Basic Training 7 Chapter 2: Navigating the Access Workspace 25 Chapter 3: Database Basics 43 Part 2: Getting It All on the Table 63 Chapter 4: Sounds Like a Plan 65 Chapter 5: Table Tune-Ups 77 Chapter 6: Remodeling Your Data 95 Chapter 7: Types, Masks, and Triggers 111 Part 3: Data Management Mania 135 Chapter 8: A Form for All Reasons 137 Chapter 9: Importing and Exporting Data 157 Chapter 10: Automatically Editing Data 171 Chapter 11: Access and the Web 183 Part 4: The Power of Questions 197 Chapter 12: Finding, Filtering, and Sorting Your Data — Fast 199 Chapter 13: I Was Just Asking for Answers 215 Chapter 14: I Want These AND Those OR Them 241 Chapter 15: Number Crunching with the Total Row. 249 Chapter 16: Express Yourself with Formulas 263 Chapter 17: Take Charge with Action Queries 277 Part 5: Simple and Snazzy Reporting. 289 Chapter 18: Fast and Furious Automatic Reporting 291 Chapter 19: Professionally Designed Reports Made Easy 313 Chapter 20: Groups and Page Breaks, Headers and Footers 341 Chapter 21: Mailings to the Masses 363 Part 6: The Part of Tens 371 Chapter 22: Ten Common Problems 373 Chapter 23: Ten Uncommon Tips 385 Appendix A: Getting Help 393 Index 395
£19.99
Springer-Verlag Berlin and Heidelberg GmbH & Co. KG Pro SQL Server 2008 Administration
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?
£29.62
Bloomsbury Publishing Plc Librarians Guide to Online Searching
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.
£50.00
O'Reilly Media FileMaker Pro 12 The Missing Manual
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.
£26.99
O'Reilly Media MySQL High Availability
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.
£29.99
O'Reilly Media Access 2013 The Missing Manual
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.
£29.99
O'Reilly Media Access 2010 The Missing Manual
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.
£23.99
O'Reilly Media FileMaker Pro 11 The Missing Manual
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.
£23.99
APress Getting Started with SQL and Databases
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
£43.99
O'Reilly Media Getting Started with Impala
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.
£19.19
O'Reilly Media Oracle PLSQL Language Pocket Reference 5E
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
£13.59
O'Reilly Media Cloud Native DataCenter Networking
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.
£39.74
Taylor & Francis Inc Developing Essbase Applications
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.
£114.00
Microsoft Press,U.S. Exam Ref 70-765 Provisioning SQL Databases
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
£23.59
O'Reilly Media Oracle Performance Tuning
Book SynopsisThe books in O'Reilly's Oracle series are authoritative -- they tell the whole story about complex topics, ranging from performance tuning to the use of packages in PL/SQL to new technologies like Power Objects. And they're independent; they're alternatives for readers who need to know how products and features really work. They're packed with real-world advice and techniques from practitioners in the field, and they come with disks containing code you can use immediately in your own applications. O'Reilly is the alternative for Oracle people who need to solve problems -- and solve them now. Performance tuning is crucial in any modern relational database management system. Too many organizations respond to Oracle performance problems by throwing money at these problems -- by buying larger and more expensive computers or by hiring expert consultants. But there's a lot you can do on your own to increase dramatically the performance of your existing system. Whatever version of Oracle you're running -- from Version 6 to Oracle8, proper tuning can save your organization a huge amount of money in additional equipment, extra memory, and hardware upgrades. The first edition of Oracle Performance Tuning became a classic for programmers, managers, database administrators, system administrators, and anyone who cares about improving the performance of an Oracle system. This second edition contains 400 pages of updated material updating on Oracle features, incorporating advice about disk striping and mirroring, RAID, client-server, distributed databases, MPPS, SMPs, and other architectures. It also includes chapters on parallel server, parallel query, backup and recovery, the Oracle Performance Pack, and more.Table of ContentsPreface. I: Overview. 1. Introduction to Oracle Performance Tuning Why Tuning? Who Tunes? When Do You Tune? A Look at Recent Versions How Much Tuning Is Enough? 2. What Causes Performance Problems? Problems with Design and Development Problems with System Resources Memory Problems and Tuning Disk I/O Problems and Tuning CPU Problems and Tuning Network Problems and Tuning. II: Tuning for Managers and Planners. 3. Planning and Managing the Tuning Process Managing the Problem of Response Time Managing the Problem of Long-Running Jobs Managing the Workload in Your System Making the Decision to Buy More Equipment Management Checkpoints Performance Hints for Managers. 4. Defining System Standards Selecting a Common Design Methodology Selecting Your Software Selecting Your Hardware Setting Up Screen and Report Templates Using Modular Programming Techniques Defining System Libraries Enforcing Program Version Control Establishing Documentation Standards Establishing Database Environment Standards Security Standards Performance Standards. III: Tuning for Designers and Analysts. 5. Designing for Performance Common Design Problems Choosing an Architecture Tuning Your Data Model Tuning Indexes Testing the Data Model for Performance Denormalizing a Database Constraints Triggers Packages, Procedures, and Functions Designing a Very Large Database Application Miscellaneous Design Considerations. IV: Tuning for Programmers. 6. Tuning SQL SQL Standards The SQL Optimizer SQL Tuning Common Sense in SQL SQL Performance Tips and Hints Using Indexes to Improve Performance SQL Tuning Alternatives Identifying Poor SQL Statements Adjusting SQL Statements Over Time. 7. Tuning PL/SQL PL/SQL and SQL What Does PL/SQL Offer? PL/SQL Limitations PL/SQL Coding Standards Tuning PL/SQL Exploiting the Power of PL/SQL Oracle PL/SQL Function Extensions. 8. Selecting a Locking Strategy What Is Locking? Releasing Locks Avoiding the Dreaded Deadlock Locking Considerations for Oracle Features Overriding the Default Locking Strategy Internal Lock Contention Lock Detection Scripts. V: Tuning for Database Administrators. 9. Tuning a New Database Steps in Setting Up a Database Tuning Memory Tuning Disk I/O Creating the Database Creating the Tablespaces Creating Rollback Segments Creating Tables Creating Indexes Creating Views Creating Users INIT.ORA Parameter Summary Creating Very Large Databases. 10. Diagnostic and Tuning Tools MONITOR: Monitoring System Activity Tables SQL_TRACE: Writing a Trace File TKPROF: Interpreting the Trace File EXPLAIN PLAN: Explaining the Optimizer's Plan ORADBX: Listing Events ANALYZE: Validating and Computing Statistics UTLBSTAT.sql and UTLESTAT.sql: Taking Snapshots Other Oracle Scripts Some Scripts of Our Own Oracle Performance Manager. 11. Monitoring and Tuning an Existing Database Identifying Untuned Application Code Tuning Memory Tuning Disk I/O Avoiding Contention. 12. Tuning Parallel Server Introduction to Parallel Server Parallel Server Architecture Parallel Server Locking Parallel Server Design Parallel Server Database Tuning Instances INIT.ORA Parameters Ongoing Tuning. 13. Tuning Parallel Query Introduction to Parallel Query PQO Design Considerations Constructing Your Database for PQO INIT.ORA Parameters Ongoing Tuning of Query Servers Creating Indexes in Parallel Using PQO to Speed Data Loads Performing Parallel Recovery 14. Tuning Database Backup and Recovery The DBA's Responsibility Backing Up the Database Preparing to Recover the Database Recovering the Database. VI: Tuning for System Administrators 15. Tuning Long-Running Jobs Correctly Sizing Tables and Indexes Exploiting Array Processing Optimizing INIT.ORA Parameters Disk Tuning Running Jobs in Parallel DBA Tuning for Long-Running Jobs Creating Overnight Extract Tables Index Operations Using PL/SQL to Speed Up Updates Inline Functions Minimizing the Number of Updates Tuning EXPORT and IMPORT Utilities. 16. Tuning in the Client-Server Environment What Is Client-Server? Network Topology Where Should You Put the Network Hardware? Client-Server Performance Issues Tuning Precompilers for Client-Server Tuning the Network Itself Tuning SQL*Net Client-Server: Adapting It in the Real World 17. Capacity Planning About Capacity Planning What Do You Need to Test? Capacity Planning Checklist 18. Tuning for Specific Systems UNIX-Specific Tuning VMS-Specific Tuning VII: Appendixes A. Summary of New Features Oracle7.0 Features Oracle7.1 Features Oracle7.2 Features Oracle7.3 Features B. Hot Tuning Tips Questions from Planners and Managers Questions from Analysts and Designers Questions from Programmers Questions from Database Administrators Questions from System Administrators C. Tuning Oracle Financials Introduction to Financials Tuning Installing Oracle Financials Database-Level Tuning Upgrading Oracle Financials Concurrent Request Processing Archiving and Purging The GL Optimizer Developer Utilities Financials Tips Resources for Financials Developers D. Oracle Performance Pack Oracle Performance Manager Oracle Lock Manager Oracle Topsessions Oracle Tablespace Manager Oracle Expert and Oracle Trace E. Tuning Oracle Forms 4.0 and 4.5 GUI Tips General Tips F. Tuning Case Studies Case Study Database 1 Case Study Database 2 G. Dynamic Performance Tables Index
£47.99
O'Reilly Media Oracle Database Administration: Essential
Book SynopsisOracle database administration requires a vast amount of information and an ability to perform a myriad of tasks--from installation to tuning to network troubleshooting to overall daily administration. Oracle provides many tools for performing these tasks; the trick is knowing what tool is right for the job, what commands you need to issue (and when), and what parameters and privileges you need to set. And, as every DBA knows, you need to know how do all this under pressure, while you face crisis after crisis. This book provides a concise reference to the enormous store of information an Oracle DBA needs every day (as well as what's needed only when disaster strikes). It's crammed full of quick-reference tables, task lists, and other summary material that both novice and expert DBAs will use time and time again. It covers the commands and operations new to Oracle8, but also provides Oracle7 information for sites still running earlier versions. Oracle Database Administration provides two types of material: DBA tasks--chapters summarizing how to perform critical DBA functions: installation, performance tuning, preventing data loss, networking, security and monitoring, auditing, query optimization, and the use of various Oracle tools and utilities DBA reference--chapters providing a quick reference to the Oracle instance and database, the initialization (INIT.ORA) parameters, the SQL statements commonly used by DBAs, the data dictionary tables, the system privileges and roles, and the SQL*Plus, Export, Import, and SQL*Loader syntax The book also includes a resource summary with references to additional books, Web sites, and other online and offline resources of special use to Oracle DBAs. Oracle Database Administration is the single essential reference you'll turn to again and again. If you must choose only one book to use at the office, keep at home, or carry to a site you're troubleshooting, this will be that book.Trade Review'If you want a good, solid, practical reference guide covering both Oracle 7 and 8, look no further.' Dave Rutlidge, Cvu, February 2001Table of ContentsPreface. I. DBA Tasks. 1. Introduction Oracle Database Administration Oracle Architecture Software Options Configuration Planning. 2. Installation Media Selection The Oracle Installer Installable Components Dependencies Pre-Installation Checklist Critical Decisions Post-Installation Tasks. 3. Maximizing Oracle Performance Configuration and Tuning-What's the Difference? Achieving Maximum Performance Configuring the Operating System Configuring Oracle Sizing and Configuring Database Objects Tuning Oracle. 4. Preventing Data Loss Types of Backups Database Backup Database Recovery Automated Utilities Practice Scenarios. 5. Oracle Networking Oracle Network Architecture Oracle Names MultiProtocol Interchange Connecting to Non-Oracle Databases Oracle Network Manager Oracle Net8 Assistant Manual Network Configuration Sample SQL*Net Files SQL*Net Troubleshooting. 6. Security and Monitoring Security Monitoring. 7. Auditing About Auditing Forms of the AUDIT Statement Audit Trail Views and Lookup Tables Establishing an Audit Policy Maintaining the Audit Trail Row-Level Auditing. 8. Query Optimization Types of Queries Types of Join Access Paths Determining the Access Plan Cost-Based Optimizer Rule-Based Optimizer. 9. Oracle Tools About the Tools SQL*Plus Oracle Server Manager SQLDBA Oracle Network Manager SQL*Loader Oracle Enterprise Manager Third-Party Tools. II. DBA Reference. 10. The Oracle Instance Elements of the Instance About Processes About Memory Structures. 11. The Oracle Database Types of Database Files Oracle Tablespaces Disk Allocation. 12. Initialization Parameters Dynamically Modifiable Parameters Platform-Specific Parameters Summary of Initialization Parameters Parameters Used Only in Oracle7 Parameters New in Oracle8. 13. SQL Statements for the DBA SQL Commands by Task SQL Command Syntax. 14. The Oracle Data Dictionary Static Data Dictionary Views Dynamic Performance Data Dictionary Views. 15. System Privileges and Initial Roles Actions, Privileges, and Roles System Privileges Initial Roles Initial Users. 16. Tools and Utilities SQL*Plus Export Import SQL*Loader. Appendix: Resources for the DBA
£23.99
O'Reilly Media Oracle8i Internal Servies for Waits; Latches;
Book SynopsisThis concise book contains detailed information about Oracle internals -- information that's not readily available to Oracle customers. It lays a foundation for advanced performance tuning of the Oracle database. Based on Oracle8i release 8.1, the book describes many of the secrets of Oracle's internal services: data structures, algorithms, and undocumented Oracle system statistics. Main topics include: Waits - how Oracle processes communicate via semaphores, and how to use the Oracle wait statistics to identify the source of performance problems. Latches - how they keep multiple processes from inspecting protected data structures at the same time, and how to examine and control latch behavior and statistics. Locks - how they work with latches to protect data structures (locks allow multiple sessions to share resources in some cases), and how locks affect performance. There is also a detailed discussion of instance locks, which are used in parallel server environments. Memory - how Oracle uses memory (e.g., the various elements of the System Global Area), and how Oracle dynamically allocates and manages memory. Oracle8i Internal Services is aimed especially at administrators and developers who need detailed internal information to do advanced performance tuning. The book will expand your repertoire of tuning solutions and troubleshooting techniques by explaining how you can use Oracle's hidden parameters and undocumented system statistics to best advantage. NOTE: The author has collected the scripts he has developed for tuning and analysis into a toolkit (known as APT, for Advanced Performance Tuning). These scripts access the Oracle X$ tables directly and provide information not otherwise available. The scripts are available to readers for free from the O'Reilly web site.Table of ContentsPreface. 1. Introduction The Oracle Kernel Layers The Kernel Services. 2. Waits Semaphores Wait Statistics Reference. 3. Latches Latches and Locks Parent and Child Latches Latch Gets Advanced Latching Control Reference. 4. Locks Lock Usage Lock Modes Enqueue Locks Row Cache Enqueues Library Cache Locks and Pins DML Locks Buffer Locks Sort Locks Reference. 5. Instance Locks The Lock Manager Global Locks PCM Instance Locks Other Instance Locks Reference. 6. Memory The SGA The Shared Pool Process Memory Reference Index
£15.99
O'Reilly Media Oracle PL/SQL Programming: Developer's Workbook
Book SynopsisHowever excellent they are, most computer books are inherently passive--readers simply take in text without having any opportunity to react to it. The Oracle PL/SQL Developer's Workbook is a different kind of animal! It's designed to engage you actively, to get you solving programming problems immediately, and to help you apply what you've learned about PL/SQL--and in the process deepen your knowledge of the language. By tackling the exercises in this workbook, you'll find yourself moving more rapidly along the learning curve to join the growing ranks of PL/SQL experts. The Oracle PL/SQL Developer's Workbook is a companion to Steven Feuerstein's bestselling Oracle PL/SQL Programming and his other PL/SQL books from O'Reilly. It contains a carefully constructed set of problems and solutions that will test your language skills and help you become a better developer--both with PL/SQL and with other languages. Exercises are provided at three levels: beginner, intermediate, and expert. The workbook exercises cover all the major features of PL/SQL, including those new to Oracle8i (e.g., Java and web features, autonomous transactions, and bulk binds). You'll find chapters on: *Basic language elements--variables, naming, loops, conditional and sequential control, exception handling, and records. *Data structures--index-by tables, nested tables, variables arrays (VARRAYs), and object technology. *Database interaction--cursors, DML and transaction management, cursor variables, and native dynamic SQL *Program construction--procedures, functions, blocks, packages, database triggers, and calling PL/SQL functions in SQL. *Built-in functionality--the character, date, conversion, numeric, and miscellaneous functions, and the DBMS_SQL, DBMS_PIPE, DBMS_OUTPUT, UTL_FILE, and DBMS_JOB built-in packages. *Miscellaneous topics--using Java with PL/SQL, external programs, PL/SQL web development, tuning PL/SQL, and PL/SQL for DBAs.Table of Contents1. Declaring Variables and Naming Elements 2. Loops 3. Conditional and Sequential Control 4. Exception Handling 5. Records 6. Index-by Tables 7. Nested Tables 8. Variable Arrays 9. Object Technology 10. Cursors 11. DML and Transaction Management 12. Cursor Variables 13. Native Dynamic SQL 14. Procedures, Functions, and Blocks 15. Packages 16. Triggers 17. Calling Functions in SQL 18. Character Functions 19. Date Functions 20. Conversion, Numeric, and Miscellaneous Functions 21. DBMS_SQL Built-in Package 22. DBMS_PIPE Built-in Package 23. DBMS_OUTPUT Built-in Package 24. UTL_FILE Built-in Package 25. DBMS_JOB Built-in Package 26. Using Java with PL/SQL 27. External Procedures 28. PL/SQL Web Development 29. Tuning PL/SQL 30. PL/SQL for DBAs
£32.99
O'Reilly Media Oracle SQL*Loader: The Definitive Guide: Loading
Book SynopsisDespite the wide availability and use of SQL*Loader, few Oracle DBAs and developers know how powerful it really is. This book describes all of SQL*Loader's functions, including how to construct the necessary control files, load different types of data, and get the best performance. It covers the newest SQL*Loader features in 2001 - the loading of large object (LOB) columns and the new object types (nested tables, varying arrays, and object tables).Trade Review'Wow the title hits it bulls-eye - The Definitive Guide. - A humongous effort went into the book and the examples. It's another one for the desk, always to hand. Bravo Well Done" plomax@oriole.comTable of ContentsPreface. 1. Introduction to SQL*Loader The SQL*Loader Environment A Short SQL*Loader Example SQL*Loader's Capabilities Issues when Loading Data Invoking SQL*Loader. 2. The Mysterious Control File Syntax Rules The LOAD Statement Command-Line Parameters in the Control File Placing Data in the Control File. 3. Fields and Datatypes Field Specifications Datatypes. 4. Loading from Fixed-Width Files Common Datatypes Encountered Specifying Field Positions Handling Anomalous Data Concatenating Records Nesting Delimited Fields. 5. Loading Delimited Data Common Datatypes Encountered Example Data Using Delimiters to Identify Fields Common Issues with Delimited Data Concatenating Records Handling Nested Fields. 6. Recovering from Failure Deleting and Starting Over Restarting a Conventional Path Load Restarting a Direct Path Load. 7. Validating and Selectively Loading Data Handling Rejected Records Selectively Loading Data. 8. Transforming Data During a Load Using Oracle's Built-in SQL Functions Writing Your Own Functions Passing Data Through Work Tables Using Triggers Performing Character Set Conversion. 9. Transaction Size and Performance Issues Transaction Processing in SQL*Loader Commit Frequency and Load Performance Commit Frequency and Rollback Segments Performance Improvement Guidelines. 10. Direct Path Loads What is the Direct Path? Performing Direct Path Loads Data Saves Loading Data Fields Greater than 64K UNRECOVERABLE Loads Parallel Data Loading. 11. Loading Large Objects About Large Objects Considerations when Loading LOBs Loading Inline LOBs Loading LOBs from External Data Files Loading BFILEs. 12. Loading Objects and Collections Loading Object Tables and Columns Loading Collections Using NULLIF and DEFAULTIF with an Object or a Collection. Index
£23.99
Manning Publications Hadoop in Practice
Book Synopsis
£47.49
Pearson Education Mondrian in Action Open source business analytics
Book Synopsis
£43.44
Manning Publications PostGIS in Action
Book Synopsis DESCRIPTION PostGIS is an open source spatial database extender for PostgreSQL. It equals or surpasses proprietary alternatives, allowing the creations of location-aware queries with just a few lines of SQL code, and provides a back-end for mapping, raster analysis, and routing applications with minimal effort. PostGIS in Action, Second Edition teaches readers of all levels to write spatial queries that solve real-world problems. After covering the background in vector, raster and topology based GIS, it quickly moves into analyzing, viewing, and mapping data. The book shows how to optimize queries for maximum speed, simplify geometries for greater efficiency, analyze rasters, vectorize rasters, better manage data utilizing topologies, and create custom functions for applications. It covers PostGIS 2.0 and 2.1 series, PostgreSQL 9.1- 9.3 features and shows how to integrate with other GIS tools. RETAIL SELLING POINTS Comprehensive coverage of PostGIS Applies PostGIS to real-world problems Significant updates to the first edition AUDIENCE Familiarity with relational database concepts is helpful but not required. This book is for programmers, GIS and DB practitioners, scientists, researchers, educators, and engineers. ABOUT THE TECHNOLOGY PostGIS (pronounced post-jis) is a spatial database extender for the PostgreSQL open source relational database management system. It’s the most powerful open source spatial database engine. It also adds to PostgreSQL several spatial data types and over 300 functions for working with these spatial types.
£46.72
Manning Publications PostGIS in Action, Third Edition
Book SynopsisPostGIS in Action, Third Edition teaches you to solve real-world geodata problems. It first gives you a background in vector-, raster-, and topology-based GIS and then quickly moves into analyzing, viewing, and mapping data. You'll learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions for your own applications. You'll also learn how to apply your existing GIS knowledge to PostGIS and integrate with other GIS tools. Fully updated to the latest versions of PostGIS and PostgreSQL, this Third Edition covers new PostGIS features including Foreign Data Wrappers, Database as a Service, parallelization of queries, and new JSON and Vector Tiles functions that help in creating web mapping applications. Key Features · An introduction to spatial databases · Geometry, geography, raster, and topology spatial types, · functions, and queries · Applying PostGIS to real-world problems · Extending PostGIS to web and desktop applications · Updated for PostGIS 3 and PostgreSQL 12 For readers familiar with relational databases and basic SQL. About the technology Processing location and topology data requires specialized know-how. PostGIS is a free spatial database extender for PostgreSQL that delivers the features and firepower you need to take on nearly any geodata task. With it, you can easily create location-aware queries in just a few lines of SQL code and build the back end for a mapping, raster analysis, or routing application with minimal effort. Regina Obe and Leo Hsu are database consultants and authors. Regina is a member of the PostGIS core development team and the Project Steering Committee.
£55.56
Manning Publications Learn dbatools in a Month of Lunches
Book SynopsisAn effective DBA is an efficient DBA. And if you work with SQL Server, dbatools is a lifesaver. With over 500 commands, this free and open source PowerShell module has the horsepower to automate just about every task you can imagine—and then some! Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective—and efficient—than you ever thought possible. Learn dbatools in a Month of Lunches is a practical hands-on guide to automating SQL Server with PowerShell and the awesome dbatools module. You'll master techniques you can immediately put into practice, from daily duties like backups and restores right through to performing security audits. Stabilize and standardize your SQL server environment, and simplify your tasks by building automation, alerting, and reporting with this powerful tool. Each lesson delivers another skill that you can use to speed through your core tasks as a SQL Server DBA! About the TechnologyWant to automate tasks for thousands of SQL servers at once? Want to migrate an entire SQL server using just the command line? dbatools can do all that—and more. A free and open source PowerShell module, dbatools offers over 500 commands for automating SQL Server from the command line. Boasting advanced options unavailable in official tools, dbatools makes it easy to automate tasks including mass exports for simplified disaster recovery, tempdb configuration, and improving an instance's security posture.Trade Review"This is an excellent resource to use for advancing your skills with advanced administration for SQL servers, regardless of the number of servers you are administering." Joseph Houghes "A great book that holds your hand on the journey from a beginner who has never used dbatools all the way to an expert!" Paul Broadwith "If you have not heard of dbatools, prepare to make managing your SQL Server infrastructure easier with the combination of it and PowerShell!" Wayne Mather "One of, if not THE best, technical books I have read, this book brings joy and life to automating DBA tasks through PowerShell, so much fun." Ben McNamara "This book and dbatools are a very serious game changer for doing automation, get out of the dark ages and look at these tools!" Steve Atchue "This book is a must for a busy SQL Server database professional." Arthur Zubarev
£51.49
Pearson Education Learn SQL in a Month of Lunches
Book SynopsisJeff Iannucci is a Senior Consultant with Straight Path Solutions. For over 20 years, he has worked extensively with SQL and relational databases to solve critical business needs in sectors such as health care, finance, retail sales, and government. He loves sharing his knowledge and enthusiasm for SQL as a blogger, speaker, and video course author.
£35.09
Technics Publications LLC Growing Business Intelligence: An Agile Approach
Book SynopsisHow do we enable our organisations to enjoy the often significant benefits of BI and analytics, while at the same time minimising the cost and risk of failure? In this book, I am not going to try to be prescriptive; I wont tell you exactly how to build your BI environment. Instead, I am going to focus on a few core principles that will enable you to navigate the rocky shoals of BI architecture and arrive at a destination best suited for your particular organisation. Some of these core principles include: Have an overarching strategy, plan, and roadmap. Recognise and leverage your existing technology investments. Support both data discovery and data reuse. Keep data in motion, not at rest. Separate information delivery from data storage. Emphasise data transparency over data quality. Take an agile approach to BI development. This book will show you how to successfully navigate both the jungle of BI technology and the minefield of human nature. It will show you how to create a BI architecture and strategy that addresses the needs of all organisational stakeholders. It will show you how to maximise the value of your BI investments. It will show you how to manage the risk of disruptive technology. And it will show you how to use agile methodologies to deliver on the promise of BI and analytics quickly, succinctly, and iteratively. This book is about many things. But principally, its about success. The goal of any enterprise initiative is to succeed and to derive benefit -- benefit that all stakeholders can share in. I want you to be successful. I want your organisation to be successful. This book will show you how. This book is for anyone who is currently or will someday be working on a BI, analytics, or Big Data project, and for organisations that want to get the maximum amount of value from both their data and their BI technology investment. This includes all stakeholders in the BI effort -- not just the data people or the IT people, but also the business stakeholders who have the responsibility for the definition and use of data. There are six sections to this book: In Section I, What Kind of Garden Do You Want?, we will examine the benefits and risks of Business Intelligence, making the central point that BI is a business (not IT) process designed to manage data assets in pursuit of enterprise goals. We will show how data, when properly managed and used, can be a key enabler of several types of core business processes. The purpose of this section is to help you define the particular benefit(s) you want from BI. In Section II, Building the Bones, we will talk about how to design and build out the hardscape (infrastructure) of your BI environment. This stage of the process involves leveraging existing technology investments and iteratively moving toward your desired target state BI architecture. In Section III, From the Ground Up, we explore the more detailed aspects of implementing your BI operational environment. In Section IV, Weeds, Pests and Critters, we talk about the myriad of things that can go wrong on a BI project, and discuss ways of mitigating these risks. In Section V, The Sustainable Garden, we talk about how to create a BI infrastructure that is easy and inexpensive to maintain. Finally, Section VI presents a case study illustrating the principles of this book, as applied to a fictional manufacturing company (the Blue Moon Guitar Company).
£36.79
Nova Science Publishers Inc SQL Server 2014: A Step by Step Guide to Learning
Book Synopsis
£159.74
M.L. Humphrey Access 2019 Intermediate
Book Synopsis
£999.99
No Starch Press,US Mysql Crash Course: A Hands-on Introduction to
Book SynopsisThis complete guide to all things MySQL will take readers from the absolute basics of creating a table to the complexities of managing an entire database. Learn to build efficient databases through interesting examples, exercises, and three hands-on projects creating databases for weather, voter, and salary data. The book leads readers through all of MySQL's intricacies, without the technical jargon. It's designed to help build confidence in creating simple databases and tables before learning more advanced concepts, including how to update and delete data, work with multiple tables, and avoid common mishaps. By the end of the book, readers will be database management pros, who know how to carry out comprehensive data projects with ease.Trade Review“A fantastic resource for anyone who wants to learn about MySQL . . . and an excellent refresher for more seasoned developers.”—Scott Stroz, MySQL Developer Advocate“Understand not just the 'what,' but the 'why' behind MySQL development."—Steven Sian, Web and Mobile Application Developer"If you’re looking to learn MySQL (and specifically 8.0) quickly and efficiently, Rick Silva’s [MySQL Crash Course] is the perfect resource. With its practical approach, clear examples, and step-by-step guidance, as [a] developer, this book will help you master MySQL!" —Frédéric Descamps, MySQL Architect at Oracle and technical reviewer of MySQL Crash CourseTable of ContentsAcknowledgmentsIntroductionPART I: GETTING STARTEDChapter 1: Installing MySQL and ToolsChapter 2: Creating Databases and TablesPART II: SELECTING DATA FROM A MYSQL DATABASEChapter 3: Introduction to SQLChapter 4: MySQL Data TypesChapter 5: Joining Database TablesChapter 6: Performing Complex Joins with Multiple TablesChapter 7: Comparing ValuesChapter 8: Calling Built-in MySQL FunctionsChapter 9: Inserting, Updating, and Deleting DataPART III: DATABASE OBJECTSChapter 10: Creating ViewsChapter 11: Creating Functions and ProceduresChapter 12: Creating TriggersChapter 13: Creating EventsPART IV: ADVANCED TOPICSChapter 14: Tips and TricksChapter 15: Calling MySQL from Programming LanguagesPART V: PROJECTSChapter 16: Building a Weather DatabaseChapter 17: Tracking Changes to Voter Data with TriggersChapter 18: Protecting Salary Data with ViewsAfterwordIndex
£33.74
In Easy Steps Limited Access 2016 in Easy Steps
Book SynopsisAccess 2016 in easy steps neatly demonstrates the important functions of Access 2016 in a clear and concise manner, so you can get going quickly with this popular database application. Areas covered include:Optimizing database designCreating Tables to store data in formatted fieldsUsing handy templates to give you a head startDefining relationships between dataImporting and exporting of dataMaking queries to extract specific dataProducing Forms for data entryConstructing Reports for data presentationSharing your database to impress your colleagues!Whether you're upgrading to Access 2016 or new to the database concept, use this guide to learn the key features constructively and get more out of Access 2016 in easy steps!
£11.99
Packt Publishing Limited MySQL for Python Database Access Made Easy
£39.99
