Database software Books
Pearson Education Mondrian in Action Open source business analytics
Book Synopsis
£43.44
Manning Publications PostGIS in Action
Book Synopsis DESCRIPTION PostGIS is an open source spatial database extender for PostgreSQL. It equals or surpasses proprietary alternatives, allowing the creations of location-aware queries with just a few lines of SQL code, and provides a back-end for mapping, raster analysis, and routing applications with minimal effort. PostGIS in Action, Second Edition teaches readers of all levels to write spatial queries that solve real-world problems. After covering the background in vector, raster and topology based GIS, it quickly moves into analyzing, viewing, and mapping data. The book shows how to optimize queries for maximum speed, simplify geometries for greater efficiency, analyze rasters, vectorize rasters, better manage data utilizing topologies, and create custom functions for applications. It covers PostGIS 2.0 and 2.1 series, PostgreSQL 9.1- 9.3 features and shows how to integrate with other GIS tools. RETAIL SELLING POINTS Comprehensive coverage of PostGIS Applies PostGIS to real-world problems Significant updates to the first edition AUDIENCE Familiarity with relational database concepts is helpful but not required. This book is for programmers, GIS and DB practitioners, scientists, researchers, educators, and engineers. ABOUT THE TECHNOLOGY PostGIS (pronounced post-jis) is a spatial database extender for the PostgreSQL open source relational database management system. It’s the most powerful open source spatial database engine. It also adds to PostgreSQL several spatial data types and over 300 functions for working with these spatial types.
£46.72
Manning Publications PostGIS in Action, Third Edition
Book SynopsisPostGIS in Action, Third Edition teaches you to solve real-world geodata problems. It first gives you a background in vector-, raster-, and topology-based GIS and then quickly moves into analyzing, viewing, and mapping data. You'll learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions for your own applications. You'll also learn how to apply your existing GIS knowledge to PostGIS and integrate with other GIS tools. Fully updated to the latest versions of PostGIS and PostgreSQL, this Third Edition covers new PostGIS features including Foreign Data Wrappers, Database as a Service, parallelization of queries, and new JSON and Vector Tiles functions that help in creating web mapping applications. Key Features · An introduction to spatial databases · Geometry, geography, raster, and topology spatial types, · functions, and queries · Applying PostGIS to real-world problems · Extending PostGIS to web and desktop applications · Updated for PostGIS 3 and PostgreSQL 12 For readers familiar with relational databases and basic SQL. About the technology Processing location and topology data requires specialized know-how. PostGIS is a free spatial database extender for PostgreSQL that delivers the features and firepower you need to take on nearly any geodata task. With it, you can easily create location-aware queries in just a few lines of SQL code and build the back end for a mapping, raster analysis, or routing application with minimal effort. Regina Obe and Leo Hsu are database consultants and authors. Regina is a member of the PostGIS core development team and the Project Steering Committee.
£55.56
Manning Publications Learn dbatools in a Month of Lunches
Book SynopsisAn effective DBA is an efficient DBA. And if you work with SQL Server, dbatools is a lifesaver. With over 500 commands, this free and open source PowerShell module has the horsepower to automate just about every task you can imagine—and then some! Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective—and efficient—than you ever thought possible. Learn dbatools in a Month of Lunches is a practical hands-on guide to automating SQL Server with PowerShell and the awesome dbatools module. You'll master techniques you can immediately put into practice, from daily duties like backups and restores right through to performing security audits. Stabilize and standardize your SQL server environment, and simplify your tasks by building automation, alerting, and reporting with this powerful tool. Each lesson delivers another skill that you can use to speed through your core tasks as a SQL Server DBA! About the TechnologyWant to automate tasks for thousands of SQL servers at once? Want to migrate an entire SQL server using just the command line? dbatools can do all that—and more. A free and open source PowerShell module, dbatools offers over 500 commands for automating SQL Server from the command line. Boasting advanced options unavailable in official tools, dbatools makes it easy to automate tasks including mass exports for simplified disaster recovery, tempdb configuration, and improving an instance's security posture.Trade Review"This is an excellent resource to use for advancing your skills with advanced administration for SQL servers, regardless of the number of servers you are administering." Joseph Houghes "A great book that holds your hand on the journey from a beginner who has never used dbatools all the way to an expert!" Paul Broadwith "If you have not heard of dbatools, prepare to make managing your SQL Server infrastructure easier with the combination of it and PowerShell!" Wayne Mather "One of, if not THE best, technical books I have read, this book brings joy and life to automating DBA tasks through PowerShell, so much fun." Ben McNamara "This book and dbatools are a very serious game changer for doing automation, get out of the dark ages and look at these tools!" Steve Atchue "This book is a must for a busy SQL Server database professional." Arthur Zubarev
£51.49
Pearson Education Learn SQL in a Month of Lunches
Book SynopsisJeff Iannucci is a Senior Consultant with Straight Path Solutions. For over 20 years, he has worked extensively with SQL and relational databases to solve critical business needs in sectors such as health care, finance, retail sales, and government. He loves sharing his knowledge and enthusiasm for SQL as a blogger, speaker, and video course author.
£35.09
Technics Publications LLC Growing Business Intelligence: An Agile Approach
Book SynopsisHow do we enable our organisations to enjoy the often significant benefits of BI and analytics, while at the same time minimising the cost and risk of failure? In this book, I am not going to try to be prescriptive; I wont tell you exactly how to build your BI environment. Instead, I am going to focus on a few core principles that will enable you to navigate the rocky shoals of BI architecture and arrive at a destination best suited for your particular organisation. Some of these core principles include: Have an overarching strategy, plan, and roadmap. Recognise and leverage your existing technology investments. Support both data discovery and data reuse. Keep data in motion, not at rest. Separate information delivery from data storage. Emphasise data transparency over data quality. Take an agile approach to BI development. This book will show you how to successfully navigate both the jungle of BI technology and the minefield of human nature. It will show you how to create a BI architecture and strategy that addresses the needs of all organisational stakeholders. It will show you how to maximise the value of your BI investments. It will show you how to manage the risk of disruptive technology. And it will show you how to use agile methodologies to deliver on the promise of BI and analytics quickly, succinctly, and iteratively. This book is about many things. But principally, its about success. The goal of any enterprise initiative is to succeed and to derive benefit -- benefit that all stakeholders can share in. I want you to be successful. I want your organisation to be successful. This book will show you how. This book is for anyone who is currently or will someday be working on a BI, analytics, or Big Data project, and for organisations that want to get the maximum amount of value from both their data and their BI technology investment. This includes all stakeholders in the BI effort -- not just the data people or the IT people, but also the business stakeholders who have the responsibility for the definition and use of data. There are six sections to this book: In Section I, What Kind of Garden Do You Want?, we will examine the benefits and risks of Business Intelligence, making the central point that BI is a business (not IT) process designed to manage data assets in pursuit of enterprise goals. We will show how data, when properly managed and used, can be a key enabler of several types of core business processes. The purpose of this section is to help you define the particular benefit(s) you want from BI. In Section II, Building the Bones, we will talk about how to design and build out the hardscape (infrastructure) of your BI environment. This stage of the process involves leveraging existing technology investments and iteratively moving toward your desired target state BI architecture. In Section III, From the Ground Up, we explore the more detailed aspects of implementing your BI operational environment. In Section IV, Weeds, Pests and Critters, we talk about the myriad of things that can go wrong on a BI project, and discuss ways of mitigating these risks. In Section V, The Sustainable Garden, we talk about how to create a BI infrastructure that is easy and inexpensive to maintain. Finally, Section VI presents a case study illustrating the principles of this book, as applied to a fictional manufacturing company (the Blue Moon Guitar Company).
£36.79
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
Packt Publishing Limited MySQL for Python Database Access Made Easy
£39.99
Packt Publishing Limited Oracle Identity and Access Manager 11g for Administrators
£36.99
Packt Publishing Limited Oracle APEX Best Practices
£39.99
Packt Publishing Limited Managing Multimedia and Unstructured Data in the Oracle Database
£44.64
Red Gate Books Brad's Sure Guide to SQL Server Maintenance Plans
£17.99
Simple Talk Publishing Troubleshooting SQL Server - A Guide for the Accidental DBA
£17.99
Mike Murach & Associates Inc. Murach's SQL Server 2019 for Developers
Book Synopsis
£45.74
Mike Murach & Associates Inc. Murach's SQL Server 2022 for Developers
Book Synopsis
£45.74
BPB Publications Practical ASP
Book Synopsis
£13.49
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 Certified Kubernetes Application Developer (CKAD)
Book Synopsis
£30.93
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-Verlag Berlin and Heidelberg GmbH & Co. KG PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
Book SynopsisWrite optimized queries. This book helps you write queries that perform fast and deliver results on time. You will learn that query optimization is not a dark art practiced by a small, secretive cabal of sorcerers. Any motivated professional can learn to write efficient queries from the get-go and capably optimize existing queries. You will learn to look at the process of writing a query from the database engine’s point of view, and know how to think like the database optimizer. The book begins with a discussion of what a performant system is and progresses to measuring performance and setting performance goals. It introduces different classes of queries and optimization techniques suitable to each, such as the use of indexes and specific join algorithms. You will learn to read and understand query execution plans along with techniques for influencing those plans for better performance. The book also covers advanced topics such as the use of functions and procedures, dynamic SQL, and generated queries. All of these techniques are then used together to produce performant applications, avoiding the pitfalls of object-relational mappers.This second edition includes new examples using Postgres 15 and the newest version of the PostgresAir database. It includes additional details and clarifications about advanced topics, and covers configuration parameters in greater depth. Finally, it makes use of advancements in NORM, using automatically generated functions. What You Will Learn Identify optimization goals in OLTP and OLAP systems Read and understand PostgreSQL execution plans Distinguish between short queries and long queries Choose the right optimization technique for each query type Identify indexes that will improve query performance Optimize full table scans Avoid the pitfalls of object-relational mapping systems Optimize the entire application rather than just database queries Who This Book Is ForIT professionals working in PostgreSQL who want to develop performant and scalable applications, anyone whose job title contains the words “database developer” or “database administrator" or who is a backend developer charged with programming database calls, and system architects involved in the overall design of application systems running against a PostgreSQL databaseTable of Contents1. Why Optimize?2. Theory - Yes, We Need It!3. Even More Theory Algorithms4. Understanding Execution Plans5. Short Queries and Indexes6. Long Queries and Full Scans7. Long Queries: Additional Techniques8. Optimizing Data Modification9. Design Matters10. Application Development and Performance11. Functions12. Dynamic SQL13. Avoiding the Pitfalls of Object-Relational Mapping14. More Complex Filtering and Search15. Ultimate Optimization Algorithm16. Conclusion
£35.99
