Databasesoftware

This new edition will help you learn PostgreSQL from scratch with the latest version, providing a complete focused view on aspects like configuration, high performance, partitioning, backup, server-side programming and replication.Purchase of the print or Kindle book includes a free eBook in PDF format.Key Features:Learn the fundamentals of PostgreSQL 16, including SQL statements, replication, and securityEnhance your learning journey with the provided Docker images for practical hands-on exercises and tests at the end of each chapterGet new and improved examples, use-cases, and scenarios specifically for concepts like partitioning, replication, back-up and restore, cluster configuration, monitoring and othersBook Description:The latest edition of this PostgreSQL book will help you to start using PostgreSQL from absolute scratch, helping you to quickly understand the internal workings of the database. With a structured approach and practical examples, go on a journey that covers the basics, from SQL statements and how to run server-side programs, to configuring, managing, securing, and optimizing database performance.This new edition will not only help you get to grips with all the recent changes within the PostgreSQL ecosystem but will also dig deeper into concepts like partitioning and replication with a fresh set of examples. The book is also equipped with Docker images for each chapter which makes the learning experience faster and easier. Starting with the absolute basics of databases, the book sails through to advanced concepts like window functions, logging, auditing, extending the database, configuration, partitioning, and replication. It will also help you seamlessly migrate your existing database system to PostgreSQL and contains a dedicated chapter on disaster recovery. Each chapter ends with practice questions to test your learning at regular intervals.By the end of this book, you will be able to install, configure, manage, and develop applications against a PostgreSQL database. What You Will Learn:Gain a deeper understanding of PostgreSQL internals like transactions, MVCC, security and replicationEnhance data management with PostgreSQL's latest partitioning featuresChoose the right replication strategy for your databaseSee concrete examples of how to migrate data from another database, perform backups and restores, monitor your PostgreSQL installation and moreEnsure security and compliance with schemas and user privilegesCreate customized database functions and extensionsGet to grips with server-side programming, window functions, and triggersWho this book is for:Learning PostgresSQL 16 book is for anyone interested in learning about the PostgreSQL database from scratch. Anyone looking to build robust data warehousing applications and scale the database for high-availability and performance using the latest features of PostgreSQL will also find this book useful. Although prior knowledge of PostgreSQL is not required, familiarity with databases is expected.

REGARDING OUR APPROACH TO THE END OF LIFE Death is a universal human experience. The knowledge of our own mortality connects us - beyond all boundaries of space, time and social conventions. Even while we're still alive, the great unknown presents us with a multitude of questions, affecting us in different ways: Is there life after death? What is a 'good death'? How do we find comfort? What remains of me? This book discusses possible answers from an individual point of view as well as from a cultural and social perspective. It forges a bridge between the nature of our fleeting existence and a culture of death that can be shaped, between the certainty of our own passing and the awareness of the impending loss of all our livelihood through the extinction of species.-Reflecting on the great unknown: What does death mean today?-Conceptions of the afterlife, funerary rites, and commemoration of the dead all around the world-Experts from the fields of journalism, philosophy, medicine, forensics, art, ecology, archaeology, psychotherapy, palliative care, zoology, and sociology illuminate the topic in all its facets-On dignity, mourning, and living with the dead-Essays, interviews, personal accounts, and photo spreadsAN ENCOUNTER WITH THE MANY DIFFERENT NOTIONS OF DEATHIn a wide-ranging compilation of essays, interviews and personal accounts, "in_finite. Living with Death" offers a multi-layered look at beliefs about the afterlife, funerary rites, the treatment of the dying, and coping with grief. Here, the perspective extends far beyond the European cultural sphere. Alongside experts from various fields of science, representatives of religious communities such as Judaism, Christianity, Islam, Hinduism, and the Yoruba religions, also share their views and provide nuanced accounts of diverse, including non-Western, perspectives on the end of life. This book offers an approach that contributes to a holistic understanding of death and makes it possible to ask questions that remain hidden in everyday life.ABOUT THE FINAL CHAPTER OF OUR BEINGFor all the broadness of its thematic scope, the book is clearly structured around key topics. The individual contributions range from reflections on immortality by the philosopher and journalist Stephen Cave to factual descriptions of the process of dying by Dr Jens Dreier of the Berlin Charité hospital and touching reports from the everyday lives of end-of-life caregivers from all over the world.The publication accompanying the exhibition "un_endlich. Leben mit dem Tod" is published by the Humboldt Forum Foundation in the Berliner Schloss. With contributions by Stephen Cave, Robin Wall Kimmerer, Matthias Glaubrecht, Cristina Cattaneo, Hartmut Dorgerloh, Jens Dreier, and others.

Directfrom Microsoft, this Exam Ref is the official study guide for the new MicrosoftDP-300 Administering Microsoft Azure SQL Solutions certification exam.ExamRef DP-300 Administering Microsoft Azure SQL Solutions offers professional-levelpreparation to maximize your exam performance and sharpen your skills on thejob. It focuses on helping modern IT professionals demonstrate real-worldmastery of implementing and managing cloud-native and hybrid data platformsolutions with Microsoft SQL Server and Microsoft Azure Data Services. Learnhow to:Planand implement data platform resourcesImplementa secure environmentMonitor,configure, and optimize database resourcesConfigureand manage automation of tasksPlanand configure a high availability and disaster recovery (HA/DR) environment MicrosoftExam Ref publications stand apart from third-party study guides because they:Provideguidance from Microsoft, the creator of Microsoft certification examsTargetIT professional-level exam candidates with content focused on their needs, notone-size-fits-all contentStreamlinestudy by organizing material according to the exam's objective domain (OD),covering one functional group and its objectives in each chapterOfferconcise overviews of every skill covered by the examFeatureThought Experiments and Thought Experiment Answers to guide candidatesthrough a set of what if? scenarios, and prepare them more effectively forPro-level style exam questionsIncludeNeed more review? aids pointing you to more study materials if you need themExplorebig picture thinking around the planning and design aspects of the IT pro's jobroleDeliverexam tips, summaries, and inline questions and answers to help you identify keypointsIncludeNeed more review? reader aids pointing to more study materials when readersneed themFormore information on Exam DP-300 and the Microsoft Certified: Azure DatabaseAdministrator Associate credential, visit https://learn.microsoft.com/en-us/certifications/azure-database-administrator-associate/.

Daten und Datenbanken sind quasi überall. Mit der Standardabfragesprache SQL können Daten in relationalen Datenbanken einfach, strukturiert und zielsicher abgefragt werden. Erfahren Sie in diesem Buch, das kein Vorwissen voraussetzt, wie Sie Datenbanken erstellen, Daten ordnen und abfragen und wie Sie SQL-Anweisungen in Programme und Websites einbinden. Nutzen Sie dieses Buch auch als Nachschlagewerk. Ganz wichtig: Sie lernen auch, wie Sie Ihre Datenbanken und Daten schützen und wie Sie typische Fehler vermeiden.

This book is designed as a textbook and provides a comprehensive approach to SQL - the standard programming language for defining, organizing, and exploring data in relational databases. It demonstrates how to leverage SQL and Excel to perform comprehensive data analysis without the need for a sophisticated and expensive data mining tool.

The low cost of getting started with cloud services can easily evolve into a significant expense down the road. That's challenging for teams developing data pipelines, particularly when rapid changes in technology and workload require a constant cycle of redesign. How do you deliver scalable, highly available products while keeping costs in check? With this practical guide, author Sev Leonard provides a holistic approach to designing scalable data pipelines in the cloud. Intermediate data engineers, software developers, and architects will learn how to navigate cost/performance trade-offs and how to choose and configure compute and storage. You'll also pick up best practices for code development, testing, and monitoring. By focusing on the entire design process, you'll be able to deliver cost-effective, high-quality products. This book helps you: Reduce cloud spend with lower cost cloud service offerings and smart design strategies Minimize waste without sacrificing performance by rightsizing compute resources Drive pipeline evolution, head off performance issues, and quickly debug with effective monitoring Set up development and test environments that minimize cloud service dependencies Create data pipeline code bases that are testable and extensible, fostering rapid development and evolution Improve data quality and pipeline operation through validation and testing

Studienarbeit aus dem Jahr 2014 im Fachbereich Informatik - Wirtschaftsinformatik, Note: 1,3, FOM Hochschule für Oekonomie & Management gemeinnützige GmbH, Köln, Sprache: Deutsch, Abstract: In dieser Arbeit werden die relationalen und objektorientierten Datenbanken betrachtet. Im Fazit wird das objektrelationale Datenbankmodell kurz vorgestellt. Das Ziel der Arbeit ist, neben der allgemeinen Einführung in das Thema der Datenbanken, die Erläuterung der Funktionalitäten von objektorientierten und relationalen Datenbanken, sowie deren Vor- und Nachteile.Der Besitz von Informationen zur Auswertung und Entwicklung neuer Strategien hat für Unternehmen und Organisationen, wie beispielsweise Behörden, einen zunehmenden Stellenwert. Die daraus resultierende steigende Anzahl von Informationen sorgt bei den Betroffenen für den Wunsch nach einer ständigen Verfügbarkeit, die mit einer Abfragemöglichkeit kombiniert ist. Dabei hat sich die Verwendung von Datenbanken in der Praxis als optimale Lösung bewährt.

Business Database Technology provides essential knowledge of database technology for four-year college/university business students who study information technology and data resource management. Students will learn basic data structure techniques in databases, relational database model, design and implementation of relational databases, normalization, SQL, physical relational database design techniques, database administration, relational databases in computer networks, data warehouses, overview of OLAP (online analytical processing), and introduction to NoSQL databases.

"Covers all things MySQL from the basics of creating a table to the complexities of managing an entire database. Teaches how to build efficient databases through examples, exercises, and three hands-on projects. Topics include creating simple databases and tables, updating and deleting data, working with multiple tables, and avoiding common mishaps"--

Advanced Database with Microsoft Access: ICDL Professional offers readers a guide to using many advanced features of Microsoft Access. The step-by-step lessons provided in this book may help learners prepare for their Advanced Database exam as part of their ICDL Professional learner profile. Topics covered include:The essential stages of database creationDeveloping advanced queriesCreating reports with features such as calculated fields, running sums and financial summariesLinking databases to external filesDesigning forms using automated and manual techniques with elements including text boxes, drop-down fields and radial buttonsCreating table relationships between a range of data sourcesEstablishing data input rules to limit errors Readers will be able to advance their knowledge and build on their existing skills using Microsoft Access. Illustrated with guided instructions and revision exercises after each section, readers can gain a range of useful skills from this book. Accompanying resources are available to download from the author's website.

Wohin geht ein geliebter Mensch, wenn er von uns gegangen ist? Wie sieht es aus, das Leben nach dem Tod? John Holland, praktizierendes Medium und spiritueller Lehrer, kennt die Antwort auf diese Fragen und zeichnet in seinem neuen Buch ein klares und deutliches Bild der jenseitigen Welt. Dank seiner besonderen Fähigkeiten ist es ihm möglich, mit dem Reich der Verstorbenen in Kontakt zu treten und ihre Botschaften zu empfangen. Als Mittler zwischen den Welten möchte er Hinterbliebenen dabei helfen, ihre eigenen spirituellen Fähigkeiten zu entfalten, Trost und Inspiration geben und mit seinem Wissen die Trauer der Lebenden lindern. Ein faszinierender Blick auf eine Welt, in der der Tod uns nicht ängstigt, wir niemals alleine sind und Seelen ewig leben.Sprachen: Englisch, Deutsch

Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010 and the many sources of data available to your business.

This new edition of Understanding Oracle APEX 5 Application Development shows APEX developers how to build practical, non-trivial web applications. The book introduces the world of APEX properties, explaining the functionality supported by each page component as well as the techniques developers use to achieve that functionality. The book is targeted at those who are new to APEX and just beginning to develop real projects for production deployment.Reading the book and working the examples will leave you in a good position to build good-looking, highly-functional, web applications. Topics include: conditional formatting, user-customized reports, data entry forms, concurrency and lost updates, and updatable reports. Accompanying the book is a demo web application that illustrates each concept mentioned in the book. Specific attention is given in the book to the thought process involved in choosing and assembling APEX components and features to deliver a specific result. Understanding Oracle APEX 5 Application Development is the ideal book to take you from an understanding of the individual pieces of APEX to an understanding of how those pieces are assembled into polished applications.Teaches how to develop non-trivial APEX applications.Provides deep understanding of APEX functionality.Shows the techniques needed for customization.

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You''ll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You''ll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.What DBA or developer isn''t faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft''s flagship tool for data integration in SQL Server environments. Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you''re looking for a resource to cover data integration and ETL across the gamut of Microsoft''s SQL Server toolset, SQL Server 2012 Data Integration Recipes is the one book that will meet your needs.Provides practical and proven solutions towards creating resilient ETL environments Clearly answers the tough questions which professionals ask Goes beyond the tools to a thorough discussion of the underlying techniques Covers the gamut of data integration, beyond just SSIS Includes example databases and files to allow readers to test the recipes

Agile Oracle Application Express shows how skilled, motivated, and self-organizing developers can realize extraordinary commercial benefits from Oracle Application Express.