Database software Books
O'Reilly Media Fundamentals of Data Engineering
Book SynopsisWith this practical book, you'll learn how to plan and build systems to serve the needs of your organization and customers by evaluating the best technologies available through the framework of the data engineering lifecycle.
£47.99
Pearson Education (US) SQL Server 2016 High Availability Unleashed
Book Synopsis
£27.74
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
£22.09
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
O'Reilly Media PostegreSQL Up and Running 3e
Book SynopsisThinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you’ll also discover that PostgeSQL is more than a database system—it’s an impressive application platform as well.
£28.79
O'Reilly Media Oracle PLSQL Programming
Book SynopsisLike its predecessors, this 6th edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 12c.
£47.99
In Easy Steps Limited Access in easy steps: Illustrating using Access
Book SynopsisAccess in easy steps has an easy-to-follow style that will appeal to anyone who wants to get more from the Microsoft Access app. Whether you're using Access in the Office 365 suite or standalone Office product, you can use this guide to learn the key features and get more out of Access. Learn how to:Optimize database design for efficiencyCreate Tables to store dataUse handy templates and get a head startMake queries to extract specific dataProduce user-friendly Forms for data entry Explore basic SQL for advanced queriesConstruct informative Reports quicklyImport and export data to Excel and Word Securely share your well-designed database and reports that'll impress your colleagues! Access in easy steps contains separate chapters on the major features of the Access app. There are complete examples that demonstrate each aspect of Access, together with screenshots that illustrate the actual output. This book neatly demonstrates the important functions of Microsoft Access in a clear and concise manner, so you can get going quickly with this popular database application.Illustrated using Access 2019.
£11.39
Pearson Education (US) PHP and MySQL for Dynamic Web Sites
Book SynopsisLarry Ullman is a writer, Web and software developer, trainer, instructor, speaker, and consultant. He has written more than 20 books, which have sold over 400,000 copies worldwide in more than 20 languages. As his readers, students, and co-workers can attest, Larry's strength is in translating geek into English: converting the technical and arcane into something comprehensible and useful. Table of Contents Chapter 1 Introduction to PHP Chapter 2 Programming with PHP Chapter 3 Creating Dynamic Web Sites Chapter 4 Introduction to MySQL Chapter 5 Introduction to SQL Chapter 6 Database Design Chapter 7 Advanced SQL and MySQL Chapter 8 Error Handling and Debugging Chapter 9 Using PHP with MySQL Chapter 10 Common Programming Techniques Chapter 11 Web Application Development Chapter 12 Cookies and Sessions Chapter 13 Security Methods Chapter 14 Perl-Compatible Regular Expressions Chapter 15 Introducing jQuery Chapter 16 An OOP Primer Chapter 17 Example–Message Board Chapter 18 Example–User Registration Appendix A Installation
£35.14
Pearson Education (US) Oracle PLSQL by Example
Book SynopsisElena Rakhimov has more than 20 years of experience in software architecture and development in a wide spectrum of enterprise and business environments ranging from nonprofit organizations to Wall Street to her current position with a prominent consulting company. Her determination to stay hands-on notwithstanding, Elena managed to excel in the academic arena, having taught relational database programming at Columbia University's highly esteemed Computer Technology and Applications program. She was educated in database analysis and design at Columbia University and in applied mathematics at Baku State University in Azerbaijan.Table of ContentsPreface xvii Introduction to PL/SQL New Features in Oracle 21c xxiiiChapter 1 PL/SQL Concepts 1 Lab 1.1: PL/SQL Architecture 2 PL/SQL Architecture 2 PL/SQL Block Structure 5 How PL/SQL Gets Executed 9 Lab 1.2: PL/SQL Development Environment 10 Getting Started with SQL Developer 10 Getting Started with SQL*Plus 13 Executing PL/SQL Scripts 14 Lab 1.3: PL/SQL: The Basics 18 DBMS_OUTPUT.PUT_LINE Statement 18 Substitution Variable Feature 21 Summary 25Chapter 2 PL/SQL Language Fundamentals 27 Lab 2.1: PL/SQL Language Components 27 PL/SQL Variables 29 PL/SQL Reserved Words 31 Delimiters 32 Literals in PL/SQL 33 Lab 2.2: Anchored Data Types 33 Lab 2.3: Scope of a Variable, Block, Nested Blocks, and Labels 35 Scope of a Variable 35 Nested Blocks and Labels 36 Summary 38Chapter 3 SQL in PL/SQL 39 Lab 3.1: SQL Statements in PL/SQL 39 Initializing Variables with the SELECT INTO Statement 40 Using DML Statements in a PL/SQL Block 41 Using a Sequence in a PL/SQL Block 43 Lab 3.2: Transaction Control in PL/SQL 44 The COMMIT, ROLLBACK, and SAVEPOINT Statements 44 The SET TRANSACTION Statement 47 Summary 48Chapter 4 Conditional Control: IF Statements 49 Lab 4.1: IF Statements 50 IF-THEN Statements 50 IF-THEN-ELSE Statements 52 Lab 4.2: ELSIF Statements 55 Lab 4.3: Nested IF Statements 59 Logical Operators 61 Summary 62Chapter 5 Conditional Control: CASE Statements 65 Lab 5.1: CASE Statements 65 CASE Statements 66 Searched CASE Statements 68 Lab 5.2: CASE Expressions 74 Lab 5.3: NULLIF and COALESCE Functions 78 NULLIF Function 78 COALESCE Function 80 Summary 82Chapter 6 Iterative Control: Part I 85 Lab 6.1: Simple Loops 86 EXIT Statement 87 EXIT WHEN Statement 91 Lab 6.2: WHILE Loops 92 Using WHILE Loops 92 Terminating the WHILE Loop Prematurely 95 Lab 6.3: Numeric FOR Loops 97 Using the IN Option in the Loop 100 Using the REVERSE Option in the Loop 103 Using Iteration Controls in the Loop 104 Terminating the Numeric FOR Loop Prematurely 108 Summary 109Chapter 7 Iterative Control: Part II 111 Lab 7.1: CONTINUE Statement 111 Using the CONTINUE Statement 112 Using the CONTINUE WHEN Statement 116 Lab 7.2: Nested Loops 119 Using Nested Loops 119 Using Loop Labels 120 Summary 122Chapter 8 Error Handling and Built-in Exceptions 125 Lab 8.1: Handling Errors 125 Lab 8.2: Built-in Exceptions 128 Summary 133Chapter 9 Exceptions 135 Lab 9.1: Exception Scope 135 Lab 9.2: User-Defined Exceptions 139 Lab 9.3: Exception Propagation 143 Re-raising Exceptions 148 Summary 149Chapter 10 Exceptions: Advanced Concepts 151 Lab 10.1: RAISE_APPLICATION_ERROR 151 Lab 10.2: EXCEPTION_INIT Pragma 155 Lab 10.3: SQLCODE and SQLERRM 157 Summary 160Chapter 11 Introduction to Cursors 161 Lab 11.1: Types of Cursors 162 Implicit Cursor 162 Explicit Cursor 164 Lab 11.2: Table-Based and Cursor-Based Records 171 Table-Based Records 172 Cursor-Based Records 174 Lab 11.3: Cursor FOR Loops 175 Lab 11.4: Nested Cursors 177 Summary 179Chapter 12 Advanced Cursors 181 Lab 12.1: Parameterized Cursors 181 Lab 12.2: Cursor Variables and Expressions 186 Cursor Variables 187 Cursor Expressions 193 Lab 12.3: FOR UPDATE Cursors 196 Summary 199Chapter 13 Triggers 201 Lab 13.1: What Triggers Are 201 Database Trigger 202 BEFORE Triggers 205 AFTER Triggers 210 Autonomous Transaction 211 Lab 13.2: Types of Triggers 213 Row and Statement Triggers 213 INSTEAD OF Triggers 215 Summary 219Chapter 14 Mutating Tables and Compound Triggers 221 Lab 14.1: Mutating Tables 221 Lab 14.2: Compound Triggers 223 Summary 228Chapter 15 Collections 229 Lab 15.1: PL/SQL Tables 230 Associative Arrays 231 Nested Tables 233 Collection Methods 236 Lab 15.2: Varrays 240 Lab 15.3: Multidimensional Collections 245 Lab 15.4: Collection Iteration Controls and Qualified Expressions 247 Collection Iteration Controls 247 Qualified Expressions 251 Summary 258Chapter 16 Records 259 Lab 16.1: User-Defined Records 259 User-Defined Records 260 Qualified Expressions with Records 262 Record Compatibility 263 Lab 16.2: Nested Records 265 Lab 16.3: Collections of Records 268 Summary 271Chapter 17 Native Dynamic SQL 273 Lab 17.1: EXECUTE IMMEDIATE Statements 274 EXECUTE IMMEDIATE Statement 275 Lab 17.2: OPEN FOR, FETCH, and CLOSE Statements 283 Summary 287Chapter 18 Bulk SQL 289 Lab 18.1: FORALL Statements 290 FORALL Statements 290 SAVE EXCEPTIONS Option 294 INDICES OF Option 296 VALUES OF Option 297 Lab 18.2: The BULK COLLECT Clause 299 Lab 18.3: Binding Collections in SQL Statements 308 Binding Collections with EXECUTE IMMEDIATE Statements 308 Binding Collections with OPEN FOR, FETCH, and CLOSE Statements 314 Summary 318Chapter 19 Procedures 319 Lab 19.1: Creating Nested Procedures 320 Nested Procedures 320 Parameter Modes 321 Forward Declaration 326 Lab 19.2: Creating Stand-Alone Procedures 327 Summary 330Chapter 20 Functions 331 Lab 20.1: Creating Nested Functions 331 Lab 20.2: Creating Stand-Alone Functions 336 Summary 340Chapter 21 Packages 341 Lab 21.1: Creating Packages 341 Creating a Package Specification 342 Creating a Package Body 343 Lab 21.2: Package Instantiation and Initialization 348 Package Instantiation and Initialization 349 Package State 351 Lab 21.3: SERIALLY_REUSABLE Packages 351 Summary 356Chapter 22 Stored Code Advanced Concepts 357 Lab 22.1: Subprogram Overloading 357 Lab 22.2: Result-Cached Functions 363 Lab 22.3: Invoking PL/SQL Functions from SQL Statements 366 Invoking Functions in SQL Statements 367 Using Pipelined Table Functions 368 Using SQL Macros 370 Summary 375Chapter 23 Object Types in Oracle 379 Lab 23.1: Object Types 380 Creating Object Types 381 Using Object Types with Collections 385 Lab 23.2: Object Type Methods 388 Using Constructor Methods 389 Using Member Methods 392 Using Static Methods 393 Comparing Objects 393 Summary 398Chapter 24 Storing Object Types in Tables 399 Lab 24.1: Storing Object Types in Relational Tables 400 Lab 24.2: Storing Object Types in Object Tables 403 Lab 24.3: Type Evolution 405 Summary 410Chapter 25 Dynamic SQL with the DBMS_SQL Package 411 Lab 25.1: Generating Dynamic SQL with the DBMS_SQL Package 412 Summary 420Appendix A PL/SQL Formatting Guide 421 Case 421 Whitespace 421 Naming Conventions 422 Comments 423Appendix B Student Database Schema 425 Table and Column Descriptions 425 9780138062835 TOC 4/20/2023
£46.79
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
Manning Publications Spring in Action
Book Synopsis"To me, this has always been the defacto standard for documentation on the Spring Framework. I bought the 1st edition when it first came out as we were converting alegacy app to Spring and this book was essential in learning how the current version worked." - Tony Sweets A new edition of the classic bestseller! Spring in Action, 6th Edition covers all of the new features of Spring 5.3 and Spring Boot 2.4 along with examples of reactive programming, Spring Security for REST Services, and bringing reactivity to your databases. You'll also find the latest Spring best practices, including Spring Boot for application setup and configuration. about the technologySpring Framework makes life easier for Java developers. The latest version of Spring brings its productivity-focused approach to microservices, reactive development, and other modern application designs. With Spring Boot now fully integrated, you can start even complex projects with minimal configuration code. And in recent version of Spring, the new RSocket specification makes your application's networking symmetrical—perfect for reactive design. about the bookSpring in Action, 6th Edition guides you through Spring's core features explained in Craig Walls' famously clear style. You'll roll up your sleeves and build a secure database-backed web app step by step. Along the way, you'll explore reactive programming, microservices, service discovery, RESTful APIs, deployment, and expert best practices. The latest version of a bestseller upgraded for Spring 5.3 and Spring Boot 2.4, this new edition also covers the RSocket specification for reactive networking between applications and delves deep into essential features of Spring Security. Whether you're just discovering Spring or leveling up to Spring 5.3, this Manning classic is your ticket! what's insideBuilding reactive applicationsRelational and NoSQL databasesIntegrating via HTTP and REST-based services, and sand reactive RSocket servicesReactive programming techniquesDeploying applications to traditional servers and containersSecuring applications with Spring SecurityCovers Spring 5.2 about the authorCraig Walls is a principal software engineer at Pivotal, a member of the Spring engineering team, a popular author, and a frequent conference speaker.We interviewed Craig as a part of our Six Questions series. Check it out here.Trade Review"If you're really serious about Spring, the book should lie next to the keyboard and serve as a pillow at night." Christian Kreutzer-Beck "I've owned every version of the this book and it's still my go to for the core Spring framework. It still lives up to expectations." Tony Sweets "Great read whether you are a beginning Spring developer or an experienced developer seeking a technology upgrade." Becky Huett "Even if you've read an older edition and you think you know Spring, I guarantee you will not regret the purchase!" Conor Redmond "Spring in Action 6th Edition is a comprehensive manuscript packed dense with a wealth of extensive information and myriad of resources to help you get a solid grounding of the fundamental Spring concepts!" Iain Campbell
£43.19
John Wiley & Sons Inc Fundamentals of Database Management Systems
Book SynopsisTable of ContentsPreface xix About The Author xxiii 1 Data: The New Corporate Resource 1 2 Data Modeling 16 3 The Database Management System Concept 36 4 Relational Data Retrieval: SQL 59 5 The Relational Database Model: Introduction 95 6 The Relational Database Model: Additional Concepts 127 7 Logical Database Design 145 8 Physical Database Design 185 9 Object-Oriented Database Management 229 10 Data Administration, Database Administration, and Data Dictionaries 248 11 Database Control Issues: Security, Backup and Recovery, Concurrency 268 12 The Data Warehouse 289 13 NoSQL Database Management 319 14 Blockchain 341 15 Database in the Cloud 352 16 Database Applications 363 Index I-1
£74.66
Pearson Education Limited Database Systems A Practical Approach to Design
Book SynopsisTeach database theory with the bestselling text on the subject Database Systems: A Practical Approach to Design, Implementation, and Management introduces the theory behind databases in a concise yet comprehensive manner. Designed for undergraduate courses, the text is accessible for non-technical readers. This title comes with a Companion Website.Table of ContentsPart 1 Background Chapter 1 Introduction to Databases Database Environment Database Architectures and the Web Part 2 The Relational Model and Languages Chapter 4 The Rational Model Chapter 5 Relational Algebra and Relational Calculus Chapter 6 SQL: Data Manipulation Chapter 7 SQL: Data Definition Chapter 8 Advanced SQL Chapter 9 Object-Relational DBMSs Part 3 Database Analysis and Design Chapter 10 Database System Development Lifecycle Chapter 11 Database Analysis and the DreamHome Case Study Chapter 12 Entity-Relationship Modeling Chapter 13 Enhanced Entity-Relationship Modeling Chapter 14 Normalization Chapter 15 Advanced Normalization Part 4 Methodology Chapter 16 Methodology – Conceptual Database Design Chapter 17 Methodology – Logical Database Design for the Relational Model Chapter 18 Methodology – Physical Database Design for Relational Databases Chapter 19 Methodology – Monitoring and Tuning the Operational System Part 5 Selected Database Issues Chapter 20 Security and Administration Chapter 21 Professional, Legal, and Ethical Issues in Data Management Chapter 22 Transaction Management Chapter 23 Query Processing Part 6 Distributed DBMSs and Replication Chapter 24 Distributed DBMSs – Concepts and Design Chapter 25 Distributed DBMSs – Advanced Concepts Chapter 26 Replication and Mobile Databases Part 7 Object DBMSs Chapter 27 Object-Oriented DBMSs – Concepts and Design Chapter 28 Object-Oriented DBMSs – Standard Systems Part 8 The Web and DBMSs Chapter 29 Web Technology and DBMSs Chapter 30 Semistructured Data and XML Part 9 Business Intelligence Chapter 31 Data Warehousing Concepts Chapter 32 Data Warehousing Design Chapter 33 OLAP Chapter 34 Data Mining Appendices References Further Reading Index
£63.25
The Pragmatic Programmers SQL Antipatterns
Book SynopsisYour database is the foundation of your application. Many programmers assume it's also the bottleneck of productive software development, but with the right techniques, this doesn't have to be true. SQL Antipatterns illustrates some of the most common misconceptions and pitfalls software developers face using relational databases. This book helps you to use a database to produce the most efficient results, and turn sluggish, inflexible code and thankless late-night hours into high-quality, reliable solutions and a job well done. The SQL database programming language is the core of most software in the world, but if you're like most software developers, you're self-taught in SQL, and you know just enough to get by. As a result, you might design fragile databases that cannot scale as the business grows, write queries that produce incorrect results and not know why, or deploy applications that are vulnerable to hackers. Don't reinvent the wheel to solve problems SQL was designed to solve--this book will teach you new SQL techniques for getting your job done. Whatever platform or programming language you use, whether you're a junior programmer or a Ph.D., SQL Antipatterns will show you how to design and build databases, how to write better database queries, and how to integrate SQL programming with your application like an expert. You'll also learn the best and most current technology for full-text search, how to design code that is resistant to SQL injection attacks, and other techniques for success.
£26.59
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
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
BPB Publications Querying Databricks with Spark SQL: Leverage SQL
Book Synopsis
£31.34
Mike Murach & Associates Inc. Murach's SQL Server 2022 for Developers
Book Synopsis
£51.84
Pearson Education (US) MOS Study Guide for Microsoft Access Expert Exam
Book SynopsisPaul McFedries is a Microsoft Access and database expert and full-time technical writer. Paul has been authoring computer books since 1991 and has nearly 100 books to his credit, which combined have sold more than 4 million copies worldwide. His titles include the Microsoft Press Publishing book Formulas and Functions for Microsoft Excel 2019, the Que Publishing books My Office 2016, My Office for iPad, Windows 10 In Depth (with coauthor Brian Knittel), and PCs for Grownups, aswell as the Wiley Publishing books Teach Yourself VISUALLY Microsoft Access and Teach Yourself VISUALLY Excel Data Analysis. Please drop by Paul's personal website at www.mcfedries.com or follow Paul on Twitter at twitter.com/paulmcf.Table of Contents 1 Manage databases Objective 1.1: Modify database structure Objective 1.2: Manage table relationships and keys Objective 1.3: Print and export data 2 Create and modify tables Objective 2.1: Create tables. Objective 2.2: Manage tables Objective 2.3: Manage table records Objective 2.4: Create and modify fields 3 Create and modify queries Objective 3.1: Create and run queries Objective 3.2: Modify queries 4 Modify forms in Layout view Objective 4.1: Configure form controls Objective 4.2: Format forms 5 Modify reports in Layout view Objective 5.1: Configure report controls Objective 5.2: Format reports
£17.09
Pearson Education (US) SQL in 10 Minutes a Day Sams Teach Yourself
Book SynopsisBen Forta is Adobe's Senior Director of Education Initiatives and has three decades of experience in the computer industry in product development, support, training, and product marketing. He is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (including spinoff titles on MariaDB, MySQL, SQL Server T-SQL, and Oracle PL/SQL), Learning Regular Expressions, as well as books on Java, Windows, and more. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs and websites, and is a frequent lecturer and columnist on application development and Internet technologies. Ben lives in Oak Park, Michigan, with his wife, Marcy, and their children. He welcomes your email at ben@forta.com and invites you to visit his website at http://forta.com. Table of ContentsIntroduction 1 Who Is the Teach Yourself SQL Book For? . . . . . . . . . . . . . . . . . . . . . . . . . . 1 DBMSs Covered in This Book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Conventions Used in This Book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Understanding SQL 5 Database Basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 What Is SQL? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Try It Yourself . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122 Retrieving Data 13 The SELECT Statement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 Retrieving Individual Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 Retrieving Multiple Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Retrieving All Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Retrieving Distinct Rows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Limiting Results . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Using Comments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233 Sorting Retrieved Data 25 Sorting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Sorting by Multiple Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Sorting by Column Position . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Specifying Sort Direction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 314 Filtering Data 33 Using the WHERE Clause . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 The WHERE Clause Operators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 405 Advanced Data Filtering 41 Combining WHERE Clauses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 Using the IN Operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Using the NOT Operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 496 Using Wildcard Filtering 51 Using the LIKE Operator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 Tips for Using Wildcards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 587 Creating Calculated Fields 59 Understanding Calculated Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Concatenating Fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 Performing Mathematical Calculations . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 688 Using Data Manipulation Functions 69 Understanding Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Using Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 789 Summarizing Data 79 Using Aggregate Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 Aggregates on Distinct Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 Combining Aggregate Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8810 Grouping Data 89 Understanding Data Grouping. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89 Creating Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90 Filtering Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91 Grouping and Sorting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94 SELECT Clause Ordering . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9711 Working with Subqueries 99 Understanding Subqueries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99 Filtering by Subquery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99 Using Subqueries as Calculated Fields . . . . . . . . . . . . . . . . . . . . . . . . . . 103 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10612 Joining Tables 107 Understanding Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107 Creating a Join . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11613 Creating Advanced Joins 117 Using Table Aliases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 Using Different Join Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118 Using Joins with Aggregate Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . 123 Using Joins and Join Conditions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12614 Combining Queries 127 Understanding Combined Queries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127 Creating Combined Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13415 Inserting Data 135 Understanding Data Insertion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135 Copying from One Table to Another . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 142 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14316 Updating and Deleting Data 145 Updating Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145 Deleting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147 Guidelines for Updating and Deleting Data . . . . . . . . . . . . . . . . . . . . . . . 149 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15017 Creating and Manipulating Tables 151 Creating Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151 Updating Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155 Deleting Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157 Renaming Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 158 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 158 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15918 Using Views 161 Understanding Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 Creating Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169 Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17019 Working with Stored Procedures 171 Understanding Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171 Understanding Why to Use Stored Procedures . . . . . . . . . . . . . . . . . . . . . 172 Executing Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173 Creating Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17820 Managing Transaction Processing 179 Understanding Transaction Processing . . . . . . . . . . . . . . . . . . . . . . . . . . 179 Controlling Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18521 Using Cursors 187 Understanding Cursors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 187 Working with Cursors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 188 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19222 Understanding Advanced SQL Features 193 Understanding Constraints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193 Understanding Indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 198 Understanding Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200 Database Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 202 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 202A Sample Table Scripts 203B SQL Statement Syntax 209C Using SQL Datatypes 215D SQL Reserved Words 221TOC, 9780135182796, 10/9/19
£22.49
O'Reilly Media The Art of SQL
Book SynopsisDemonstrates that since SQL code may run for 5 to 10 years, and run on different hardware, it must be fast and sound from the start. This book offers SQL best practices and relational theory that force you to focus on strategy rather than specifics.
£35.19
O'Reilly Media Unifying Business Data and Code
Book SynopsisIn the modern symphony of business, each section-from the technical to the managerial-must play in harmony. Authors Ron Itelman and Juan Cruz Viotti introduce a bold methodology to synchronize your business and technical teams, transforming them into a single, high-performing unit.
£39.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.
£39.37
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.
£999.99
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
£22.09
Springer International Publishing AG SQL and NoSQL Databases: Modeling, Languages,
Book SynopsisThis textbook offers a comprehensive introduction to relational (SQL) and non-relational (NoSQL) databases. The authors thoroughly review the current state of database tools and techniques and examine upcoming innovations.In the first five chapters, the authors analyze in detail the management, modeling, languages, security, and architecture of relational databases, graph databases, and document databases. Moreover, an overview of other SQL- and NoSQL-based database approaches is provided. In addition to classic concepts such as the entity and relationship model and its mapping in SQL database schemas, query languages or transaction management, other aspects for NoSQL databases such as non-relational data models, document and graph query languages (MQL, Cypher), the Map/Reduce procedure, distribution options (sharding, replication) or the CAP theorem (Consistency, Availability, Partition Tolerance) are explained.This 2nd English edition offers a new in-depth introduction to document databases with a method for modeling document structures, an overview of the document-oriented MongoDB query language MQL as well as security and architecture aspects. The topic of database security is newly introduced as a separate chapter and analyzed in detail with regard to data protection, integrity, and transactions. Texts on data management, database programming, and data warehousing and data lakes have been updated. In addition, the book now explains the concepts of JSON, JSON schema, BSON, index-free neighborhood, cloud databases, search engines and time series databases.The book includes more than 100 tables, examples and illustrations, and each chapter offers a list of resources for further reading. It conveys an in-depth comparison of relational and non-relational approaches and shows how to undertake development for big data applications. This way, it benefits students and practitioners working across the broad field of data science and applied information technology.Table of Contents- 1. Database Management. - 2. Database Modeling. - 3. Database Languages. - 4. Database Security. - 5. System Architecture. - 6. Post-relational Databases. - 7. NoSQL Databases.
£49.49
BPB Publications Certified Kubernetes Application Developer (CKAD)
Book Synopsis
£999.99
John Wiley & Sons Inc Ethereum For Dummies
Book SynopsisDive into a secure future Professionals look to Ethereum as ablockchain-based platform to develop safe applications and conduct secure transactions. It takes a knowledgeable guiding hand to understand how Ethereum works and what it does and Ethereum For Dummies provides that guidance. Written by one of the leading voices in the blockchain community and best selling author of Blockchain For Dummies, this book demystifies the workings of Ethereum and shows how it can enhance security, transactions, and investments. As an emerging application of blockchain technology, Ethereum attracts a wide swath of professionals ranging from financial pros who see it as a way to enhance their business, security analysts who want to conduct secure transactions, programmers who build apps that employ the Ethereum blockchain, or investors interested in cashing in on the rise of cryptocurrency. Ethereum For Dummies offers a starting point to all members of this audience as it provides easy-to-understand eTable of ContentsIntroduction 1 About This Book 1 Foolish Assumptions 2 Icons Used in This Book 2 Beyond the Book 2 Where to Go from Here 3 Part 1: Getting to Know Blockchain and Ethereum 5 Chapter 1: Introducing Ethereum 7 Describing Blockchain Technology 8 Introducing Ethereum 10 Exploring Ethereum’s Consensus, Mining, and Smart Contracts 11 Buying, Spending, and Trading Ether 13 Getting Started with DAO and ICO 16 Exploring the Ethereum Ecosystem 17 Delving into Development Tools 18 Building Blockchain Apps 18 Chapter 2: Learning about Blockchain 21 Exploring Distributed Applications 22 Digging into distributed processing 22 Exploring problems with distributed processing 24 Presenting some solutions to distributed processing problems 27 Examining the Bitcoin Solution to the Distributed Dilemma 28 Describing Blockchains 30 Examining blockchain details 30 Protecting blockchain visibility 31 Building Blockchains 33 Agreeing to add blocks 33 Making blocks immutable 34 Reviewing the building process 35 Keeping all blockchains consistent 35 Understanding How Blockchains and Databases Store Data Differently 36 Storing data in a traditional database 36 Storing data in a blockchain 38 Effectively Using Blockchains 39 Transferring value without trust 39 Reducing transaction costs by eliminating middlemen 39 Increasing efficiency through direct interaction 40 Maintaining complete transaction history 40 Increasing resilience through replication 41 Providing transparency 41 Chapter 3: Exploring Use Cases for Ethereum 43 Diving Into Ethereum Applications 44 Exploring Financial Services 45 Banking 46 Creating Ethereum escrow applications 48 Examining ICOs 48 Establishing Digital Identity Management 49 Managing individual and device identities 50 Reducing fraud and identity theft 50 Examining the ERC-725 standard and beyond 51 Examining Industry Applications 51 Healthcare 52 Energy 52 Supply chain 53 Enabling Effective Governance 54 Tax payment 54 Government spending 55 Voting 55 Policy development 55 Notary 56 Part 2: Setting Up Your Ethereum Development Environment 57 Chapter 4: Examining the Ethereum Ecosystem and Development Lifecycle 59 Exploring the Ethereum Blockchain Block Structure 60 Describing Smart Contracts 64 Introducing Solidity, the Language of Smart Contracts 66 Working with the Ethereum Virtual Machine 67 Fueling Your Code with Gas 68 Surveying Tools for Developing, Testing, and Deploying Ethereum Apps 69 Ethereum blockchain client 70 Development and testing blockchain 71 Compiler and testing framework 72 Source code editor/IDE 72 Describing the Ethereum Development Lifecycle 73 Introducing Smart Contract Development Tools 74 Chapter 5: Getting and Configuring Ethereum Development Tools 77 Examining Why Multiple Ethereum Development Tools are Available 78 Downloading, Installing, and Configuring All the Pieces 79 Installing the blockchain client 79 Installing the test blockchain 83 Installing the testing environment 86 Installing the IDE 91 Chapter 6: Establishing an Ethereum Wallet 95 Unlocking the Secrets of an Ethereum Wallet 96 Examining the Types of Ethereum Wallets 96 Sorting out software wallets 97 Handling hardware wallets 99 Perusing paper wallets 99 Choosing an Ethereum Wallet 100 Software wallets 100 Hardware wallets 102 Paper wallets 103 Installing MetaMask, an Ethereum Wallet 104 Part 3: Building Ethereum Distributed Blockchain Apps 107 Chapter 7: Building Your First Ethereum Apps 109 Validating Your Ethereum Development Environment 110 Creating a Truffle project 110 Editing the Truffle config file 111 Exploring the Ganache Test Environment 113 Designing Simple Smart Contracts 115 Coding Your First Smart Contract 116 Running Your First Smart Contract 118 Writing your code 118 Compiling your code 119 Deploying your code 120 Invoking your code’s functions 122 Paying as You Go 124 Chapter 8: Learning about Smart Contracts 125 Introducing Supply Chain and Common Challenges 126 Describing supply chain 126 Explaining difficulties when implementing a supply chain 127 Examining How Blockchain Can Help Resolve Supply Chain Problems 128 Describing a Blockchain Supply Chain Solution 129 Paying for supply chain services 129 Managing assets on the supply chain 130 Digging into Solidity 132 Describing Basic Smart Contract Syntax 133 Declaring valid compiler version 134 Commenting your code 134 Importing external code 135 Defining your smart contracts 135 Handling Data in Solidity 136 Learning about Computation and Gas 140 Exploring Access Modes and Visibility of Smart Contract Functions and Data 142 Controlling Execution Flow 144 Handling Errors and Exceptions 145 Chapter 9: Writing Your Own Smart Contracts with Solidity 147 Reviewing Supply Chain Design Specification 148 Payment token smart contract 149 Supply chain smart contract 150 Creating New Smart Contracts 151 ERC-20 token interface 153 ERC-20 token smart contract 154 Supply chain smart contract 155 Coding Primary Functions 157 ERC-20 token functions 157 Supply chain functions 160 Using Events 163 Defining events 165 Triggering events 166 Introducing Ownership 168 Designing for Security 170 Implementing Minimal Functionality 171 Part 4: Testing and Deploying Ethereum Apps 173 Chapter 10: Testing Ethereum Apps 175 Understanding Ethereum dApp Testing 176 Writing tests from the beginning 176 Choosing the right test blockchain 176 Learning the steps in the testing lifecycle 177 Testing for software quality 177 Deploying a dApp to a Test Ethereum Blockchain 178 Telling Truffle to use the Ganache blockchain 178 Deploying your code to the Ganache blockchain 180 Writing Tests for Ethereum dApps 181 Testing using the command line 181 Writing test cases in JavaScript 185 Logging and Handling Errors 187 Handling errors in Solidity 188 Logging activity in smart contracts 189 Fixing Bugs in a dApp 190 Chapter 11: Deploying and Maintaining Ethereum Apps 191 Test Blockchain Options versus Live Blockchains 192 Testing with the Ganache blockchain 192 Deploying your code to other test blockchains 193 Anticipating Differences in Live Environments 195 Preparing Your Configuration for Deploying to Different Networks 196 Deploying a dApp 198 Getting enough ether 199 Compiling your code 203 Deploying your code 203 Chapter 12: Integrating Non-Blockchain Apps with Ethereum 205 Comparing Blockchain and Database Storage 206 Locating control 207 Imposing data format 207 Updating data 207 Optimizing performance 208 Protecting confidentiality 208 Paying for storage 208 Providing integrity and transparency 209 Protecting resilience 209 Contrasting Execution and Flow in Blockchain dApps and Traditional Applications 210 Designing Goals for Incorporating Blockchain into an Existing Application 211 Using existing smart contracts 213 Developing your own smart contracts 213 Identifying Interface Data and Transaction Requirements 214 Creating or Modifying Contracts to Provide Data Interface 215 Testing Integrated dApps 215 Deploying Integrated dApps 216 Part 5: The Part of Tens 219 Chapter 13: Ten Free Ethereum Resources 221 Exploring Alternative Ethereum Development Frameworks 222 Managing you development with Populus 222 Exploring Ethereum blockchain containers with Cliquebait 222 Selecting a Free Integrated Development Environment 223 Developing Solidity code with Atom 223 Going online with Remix 224 Keeping it simple with EthFiddle 224 Exploring Ethereum Clients and APIs 226 Swapping your Ethereum client to Parity 226 Interacting with Ethereum by using Web3.js 226 Focusing on Wallets and Security 227 Protecting your crypto-assets in Mist 227 Securing your dApps with OpenZeppelin 228 Learning More About Developing Ethereum dApps 228 Chapter 14: Ten Design Principles for Distributed Blockchain Apps 229 Designing for Trust 230 Enforcing Consistency 230 Removing Doubt through Transparency 232 Providing Feedback, Guidance, and Setting Expectations 233 Handling Mistakes with Class 233 Designing Functions that Focus on User Actions, Not Data 234 Storing Data Based on User Actions, Not Data Structures 235 Keeping It Simple 236 Expecting Blockchain Access to Be Expensive 236 Staying Out of the User’s Way 237 Chapter 15: Top Ten Ethereum Projects 239 Predicting Future Events with Gnosis 240 Crowdsourcing Event Predictions in Augur 240 Managing Decentralized Organizations with Aragon 241 Breeding and Collecting Cryptokitties 241 Exchanging Tokens with IDEX 242 Creating Your Digital Identity with uPort 243 Sharing Your Thoughts on the Blockchain with EtherTweet 243 Searching for Jobs with EthLance 244 Using TenX to Pay with Cryptocurrency 245 Buying and Selling Computing Power with Golem 246 Index 247
£19.54
BPB Publications The Official New Features Guide to Sybase ASE 15
Book SynopsisThe book covers enhancements in Sybase ASE 15 like system admin improvements, function-based indexes, computed columns, scrollable cursor, galaxy optimizer, query plan, galaxy partitions, multiple tempdb, Mda tables, and plan viewer.
£10.12
Mike Murach & Associates Inc. Murach's MySQL, 3rd Edition
£50.14
Pearson Education (US) PostgreSQL
Book SynopsisAims to cover the internals of the PostgreSQL open source database chapter, offering a code-based approach explaining how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This guide helps in building, programming and administering the PostgreSQL open-source database system.Table of ContentsIntroduction. PostgreSQL Features What Versions Does This Book Cover? Who Is This Book For? What Topics Does This Book Cover? What's New in the Second Edition? I. GENERAL POSTGRESQL USE. 1. Introduction to PostgreSQL and SQL. A Sample Database Basic Database Terminology Prerequisites Installing PostgreSQL Using an RPM Connecting to a Database A (Very) Simple Query Creating Tables Viewing Table Descriptions Adding New Records to a Table Using the INSERT Command Using the COPY Command Installing the Sample Database Retrieving Data from the Sample Database SELECT Expression SELECT FROM Table SELECT Single-Column FROM Table SELECT Column-List FROM Table SELECT Expression-List FROM Table Selecting Specific Rows The CASE Expression Formatting Column Results Matching Patterns Aggregates COUNT() SUM() AVG() MIN() and MAX() Other Aggregate Functions Grouping Results Multi-Table Joins Join Types UPDATE DELETE A (Very) Short Introduction to Transaction Processing Creating New Tables Using CREATE TABLE...AS Using VIEW Summary 2. Working with Data in PostgreSQL. NULL Values Character Values Syntax for Literal Values Supported Operators Numeric Values Size, Precision, and Range-of-Values Syntax for Literal Values Supported Operators Date/Time Values Syntax for Literal Values Supported Operators Boolean (Logical) Values Size and Valid Values Syntax for Literal Values Supported Operators Geometric Data Types Syntax for Literal Values Sizes and Valid Values Supported Operators Object IDs (OID) Syntax for Literal Values Size and Valid Values Supported Operators BLOBs Syntax for Literal Values Supported Operators Large-Objects Network Address Data Types MACADDR CIDR INET Syntax for Literal Values Supported Operators Sequences Arrays Column Constraints NULL/NOT NULL UNIQUE PRIMARY KEY REFERENCES CHECK() Expression Evaluation and Type Conversion Creating Your Own Data Types Refining Data Types with CREATE DOMAIN Creating and Using Composite Types Summary 3. PostgreSQL SQL Syntax and Use. PostgreSQL Naming Rules The Importance of the COMMENT Command Creating, Destroying, and Viewing Databases Tablespaces Creating New Databases Dropping a Database Viewing Databases Creating New Tables Temporary Tables Table Constraints Dropping Tables Inheritance ALTER TABLE Adding Indexes to a Table Tradeoffs Creating an Index Functional Indexes and Partial Indexes Creating Indexes on Array Values Indexes and Tablespaces Getting Information About Databases and Tables Transaction Processing Persistence Transaction Isolation Multi-Versioning and Locking Summary 4. Performance. How PostgreSQL Organizes Data Page Caching Summary Gathering Performance Information Dead Tuples Index Performance Understanding How PostgreSQL Executes a Query EXPLAIN Seq Scan Index Scan Sort Unique LIMIT Aggregate Append Result Nested Loop Merge Join Hash and Hash Join Group Subquery Scan and Subplan Tid Scan Materialize Setop (Intersect, Intersect All, Except, Except All) Execution Plans Generated by the Planner The ARC Buffer Manager Table Statistics Performance Tips II. PROGRAMMING WITH POSTGRESQL. 5. Introduction to PostgreSQL Programming. Server-Side Programming PL/pgSQL Other Procedural Languages Supported by PostgreSQL Extending PostgreSQL Using External Languages Client-Side APIs General Structure of Client Applications Connection Properties LISTEN/NOTIFY Choosing an Application Environment Server-Side Code Client-Side Code Mixing Server-Side and Client-Side Code Summary 6. Extending PostgreSQL. Extending the PostgreSQL Server with Custom Functions Returning Multiple Values from an Extension Function The PostgreSQL SRF Interface Returning Complete Rows from an Extension Function Extending the PostgreSQL Server with Custom Data Types Internal and External Forms Defining a Simple Data Type in PostgreSQL Defining the Data Type in C Defining the Input and Output Functions in C Defining the Input and Output Functions in PostgreSQL Defining the Data Type in PostgreSQL Indexing Custom Data Types Summary 7. PL/pgSQL. Installing PL/pgSQL Language Structure Quoting Embedded Strings CREATE FUNCTION DROP FUNCTION Function Body Comments Variables PL/pgSQL Statement Types Cursors FETCH Parameterized Cursors Cursor References Triggers TRIGGER Return Values TRIGGER Function Arguments Polymorphic Functions PL/pgSQL and Security Summary 8. The PostgreSQL C API-libpq. Prerequisites Client 1-Connecting to the Server Compiling the Client Identifying the Server Client 2-Adding Error Checking Viewing Connection Attributes Client 3-Simple Processing-PQexec() and PQprint() Results Returned by PQexec() The Prepare/Execute Model Client 4-An Interactive Query Processor Processing Multiple Result Sets Asynchronous Processing Summary 9. A Simpler C API-libpgeasy. Prerequisites Client 1-Connecting to the Server Client 2-Adding Error Checking Client 3-Processing Queries Working with Binary Cursors Byte Ordering and NULL Values Client 4-An Interactive Query Processor Summary 10. The New PostgreSQL C++ API-libpqxx. Prerequisites Client 1-Connecting to the Server Using pqxx-config to Create a Simple Makefile connection Member Functions Client 2-Adding Error Checking Other Exceptions Thrown by libpqxx Handling Informational/Warning Messages with Notice Processor Objects Client 3-Processing Queries Working with Transactions Working with Result Sets Working with Large-Objects LISTEN/NOTIFY set_variable() and get_variable() Client 4-Working with transactors Summary 11. Embedding SQL Commands in C Programs-ecpg. Prerequisites Client 1-Connecting to the Server The ecpg Preprocessor Connection Strings Client 2-Adding Error Checking The sqlca Structure Client 3-Processing SQL Commands ecpg Data Types Client 4-An Interactive Query Processor Summary 12. Using PostgreSQL from an ODBC Client Application. ODBC Architecture Overview The ODBC Client Application The ODBC Driver Manager The ODBC Driver The ODBC-Compliant Database The Data Source Setting Up a Data Source on Unix Systems Setting Up a Data Source in Windows Datasource Connection Properties Prerequisites Client 1-Connecting to the Server Client 2-Adding Error Checking Client 3-Processing Queries Client 4-An Interactive Query Processor Summary Resources 13. Using PostgreSQL from a Java Client Application. JDBC Architecture Overview The JDBC DriverManager The JDBC Driver The JDBC-Compliant Database Prerequisites Client 1-Connecting to the Server JDBC URLs Client 2-Adding Error Checking JNDI and the DataSource Class Client 3-Processing Queries Statement Classes Metadata Client 4-An Interactive Query Processor Summary 14. Using PostgreSQL with Perl. DBI Architecture Overview The DBI The DBD Driver The DBI-Compliant Database Prerequisites Client 1-Connecting to the Server DBI URLs Client 2-Adding Error Checking Client 3-Processing Queries The Prepare/Execute Model Metadata and Result Set Processing Other Statement and Database Handle Attributes Client 4-An Interactive Query Processor Summary 15. Using PostgreSQL with PHP. PHP Architecture Overview Prerequisites Client 1-Connecting to the Server Client 2-Adding Error Checking Client 3-Query Processing Other Ways to Retrieve Result Set Values Metadata Access Client 4-An Interactive Query Processor Other Features Summary 16. Using PostgreSQL with Tcl and Tcl/Tk. Prerequisites Client 1-Connecting to the Server Making the Connection Dialog Reusable Client 2-Query Processing Result Set Processing Client 3-An Interactive Query Processor The libpgtcl Large-Object API Summary 17. Using PostgreSQL with Python. Python/PostgreSQL Interface Architecture Prerequisites Client 1-Connecting to the Server Client 2-Adding Error Checking Client 3-Query Processing Client 4-An Interactive Command Processor Summary 18. Npgsql: The .NET Data Provider. Prerequisites Preparing Visual Studio Understanding the ADO.NET Class Hierarchy Creating an Npgsql-enabled VB Project Client 1-Connecting to the Server Client 2-An Interactive Query Processor Client 3-Updating the Database with a DataSet Client 4-A More Robust Query Processor Client 5-Using a Typed DataSet Creating a Typed DataSet Summary 19. Other Useful Programming Tools. PL/Java-Writing Stored Procedures in Java Installing PL/Java Writing a Simple PL/Java Function Accessing the Database from a PL/Java Function Returning Multiple Results from a PL/Java Function Writing PL/Java Trigger Functions Adding Install/Uninstall Commands to a Jar File pgcurl-Web-enabling Your PostgreSQL Server pgbash-Writing PostgreSQL-enabled Shell Scripts III. POSTGRESQL ADMINISTRATION. 20. Introduction to PostgreSQL Administration. Security User Accounts Backup and Restore Server Startup and Shutdown Running PostgreSQL on a Windows Host Tuning Installing Updates Localization Summary 21. PostgreSQL Administration. Roadmap (Where's All My Stuff?) Installing PostgreSQL Unix/Linux Windows Managing Databases Creating a New Cluster Creating a New Database Routine Maintenance Logfile Rotation The PostgreSQL BGWRITER Process Managing User Accounts CREATE USER Managing Groups Configuring Your PostgreSQL Runtime Environment File Locations Security-Related Parameters Connection-Related Parameters Operational Parameters Write-Ahead Log Parameters Optimizer Parameters Debugging/Logging Parameters Performance Statistics Per-session Parameters Miscellaneous Parameters Read-only Parameters Arranging for PostgreSQL Startup and Shutdown Using pg_ctl Shutdown Modes Configuring PostgreSQL Startup on Unix/Linux Hosts Backing Up and Copying Databases Using pg_dump Using pg_dumpall Using pg_restore Point-in-time Recovery Summary 22. Internationalization and Localization. Locale Support Enabling Locale Support Effects of Locale Support PostgreSQL Locale Summary Multi-Byte Character Sets Encodings Supported by PostgreSQL Enabling Multi-Byte Support Selecting an Encoding Client/Server Translation Summary 23. Security. Securing the PostgreSQL Data Files Securing PostgreSQL Data Files in Windows Securing Network Access local Connections host, hostssl, and hostnossl Connections The trust Authentication Method The ident Authentication Method The password Authentication Method The crypt Authentication Method The md5 Authentication Method The pam Authentication Method The krb4 and krb5 Authentication Methods The reject Authentication Method Securing Tables Securing Functions Summary 24. Replicating PostgreSQLData with Slony. Overview Requirements Creating a Replication Cluster Starting the Replication Daemons Creating a Replication Set Subscribing to a Replication Set Copying Table and Sequence Definitions Creating a Subscriber Changing the Cluster Topology (Re-mastering and Failover) Summary 25. Contributed Modules. Exchanging PostgreSQL Data with XML XPath Queries Converting XML Data with XSLT Using Full-text Search Searching Multiple Columns Simplifying tsearch2 with Customized Functions Searching for Phrases Configuring tsearch2 Index.
£30.37
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
£41.24
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).
£39.09
Mike Murach & Associates Inc. Murach's SQL Server 2019 for Developers
Book Synopsis
£51.84
BPB Publications Understanding Oracle
Book Synopsis
£11.24
BPB Publications SQL Server Interview Questions
Book Synopsis
£14.99
BPB Publications Flash 8 Game Developing Hand Book
Book Synopsis
£7.49
BPB Publications Mastering Amazon Relational Database Service for
Book SynopsisThis book is a valuable resource as a practical guide for professionals involved in managing Amazon Relational Database Service (RDS) instances. The book covers the fundamentals of Amazon RDS, configuration best practices, and optimizing performance. With MySQL databases, it explores essential components, AWS Regions, and Availability Zones. Readers will benefit from the detailed discussions on managing and maintaining Amazon RDS MySQL instances, covering topics like stopping and starting DB instances, optimizing settings, handling maintenance updates, and understanding the nuances of reboots. The book emphasizes security considerations and provides a comprehensive guide to storage management, encryption options, backup strategies, and cost optimization. The later chapters delve into advanced topics such as creating and connecting to MySQL databases on Amazon RDS, managing Multi-AZ MySQL DB clusters, and upgrading AWS RDS MySQL.
£30.39
Laxmi Publications Power of Oracle 9i
Book Synopsis
£22.88
Springer The Pace System
a huge range and FREE tracked UK delivery on ALL orders.
£74.93
W. W. Norton & Company The Advanced PRISM Workbook Program for Innovative Self Management
Book SynopsisThis new, advanced supplement to the 16-group program described in The Adolescent Self provides advanced exercises and techniques for adolescents who have mastered those taught in the original PRISM Workbook.
£14.50
Springer Advanced Relational Programming
a huge range and FREE tracked UK delivery on ALL orders.
£92.50
iUniverse The Complete HyperCard 22 Handbook Fourth Edition Volume 1
a huge range and FREE tracked UK delivery on ALL orders.
£24.50
iUniverse Understanding dBASE 5 for Windows Volume 1 01
a huge range and FREE tracked UK delivery on ALL orders.
£24.50
Locate Press pgRouting A Practical Guide
£35.00
Kiet Huynh Learning SQL
£14.24
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?
£39.49
Technics Publications MongoDB Data Modeling and Schema Design
£35.99
