Search

Dive into DuckDB and start processing gigabytes of data with ease—all with no data warehouse.DuckDB is a cutting-edge SQL database that makes it incredibly easy to analyze big data sets right from your laptop. In DuckDB in Action you'll learn everything you need to know to get the most out of this awesome tool, keep your data secure on prem, and save you hundreds on your cloud bill. From data ingestion to advanced data pipelines, you'll learn everything you need to get the most out of DuckDB—all through hands-on examples. Open up DuckDB in Action and learn how to: • Read and process data from CSV, JSON and Parquet sources both locally and remote • Write analytical SQL queries, including aggregations, common table expressions, window functions, special types of joins, and pivot tables • Use DuckDB from Python, both with SQL and its'Relational'-API, interacting with databases but also data frames • Prepare, ingest and query large datasets • Build cloud data pipelines • Extend DuckDB with custom functionality Pragmatic and comprehensive, DuckDB in Action introduces the DuckDB database and shows you how to use it to solve common data workflow problems. You won't need to read through pages of documentation—you'll learn as you work. Get to grips with DuckDB's unique SQL dialect, learning to seamlessly load, prepare, and analyze data using SQL queries. Extend DuckDB with both Python and built-in tools such as MotherDuck, and gain practical insights into building robust and automated data pipelines. About the technology DuckDB makes data analytics fast and fun! You don't need to set up a Spark or run a cloud data warehouse just to process a few hundred gigabytes of data. DuckDB is easily embeddable in any data analytics application, runs on a laptop, and processes data from almost any source, including JSON, CSV, Parquet, SQLite and Postgres. About the book DuckDB in Action guides you example-by-example from setup, through your first SQL query, to advanced topics like building data pipelines and embedding DuckDB as a local data store for a Streamlit web app. You'll explore DuckDB's handy SQL extensions, get to grips with aggregation, analysis, and data without persistence, and use Python to customize DuckDB. A hands-on project accompanies each new topic, so you can see DuckDB in action. What's inside • Prepare, ingest and query large datasets • Build cloud data pipelines • Extend DuckDB with custom functionality • Fast-paced SQL recap: From simple queries to advanced analytics About the reader For data pros comfortable with Python and CLI tools. About the author Mark Needham is a blogger and video creator at @?LearnDataWithMark. Michael Hunger leads product innovation for the Neo4j graph database. Michael Simons is a Java Champion, author, and Engineer at Neo4j.

If you work with SQL Server, dbatools is a lifesaver. This book will show you how to use this free and open source PowerShell module to automate just about every SQL server task you can imagine—all in just one month!In Learn dbatools in a Month of Lunches you will learn how to: Perform instance-to-instance and customized migrations Automate security audits, tempdb configuration, alerting, and reporting Schedule and monitor PowerShell tasks in SQL Server Agent Bulk-import any type of data into SQL Server Install dbatools in secure environments Written by a group of expert authors including dbatools creator Chrissy LeMaire, Learn dbatools in a Month of Lunches teaches you techniques that will make you more effective—and efficient—than you ever thought possible. In twenty-eight lunchbreak lessons, you'll learn the most important use cases of dbatools and the favorite functions of its core developers. Stabilize and standardize your SQL server environment, and simplify your tasks by building automation, alerting, and reporting with this powerful tool. About the technology For SQL Server DBAs, automation is the key to efficiency. Using the open-source dbatools PowerShell module, you can easily execute tasks on thousands of database servers at once—all from the command line. dbatools gives you over 500 pre-built commands, with countless new options for managing SQL Server at scale. There's nothing else like it. About the book Learn dbatools in a Month of Lunches teaches you how to automate SQL Server using the dbatools PowerShell module. Each 30-minute lesson introduces a new automation that will make your daily duties easier. Following the expert advice of dbatools creator Chrissy LeMaire and other top community contributors, you'll learn to script everything from backups to disaster recovery. What's inside Performing instance-to-instance and customized migrations Automating security audits, best practices, and standardized configurations Administering SQL Server Agent including running PowerShell scripts effectively Bulk-importing many types of data into SQL Server Executing advanced tasks and increasing efficiency for everyday administration About the reader For DBAs, accidental DBAs, and systems engineers who manage SQL Server. About the author Chrissy LeMaire is a GitHub Star and the creator of dbatools. Rob Sewell is a data engineer and a passionate automator. Jess Pomfret and Cláudio Silva are data platform architects. All are Microsoft MVPs. Table of Contents 1 Before you begin 2 Installing dbatools 3 The dbatools lab 4 A gentle introduction to dbatools commands 5 Writing to SQL Server 6 Finding SQL Server instances on your network 7 Inventorying your SQL estate 8 Registered Servers 9 Logins and users 10 Backups 11 Restore 12 Snapshots 13 Install and update SQL Server 14 Preparing for disaster 15 Performing your first advanced SQL Server instance migration, part 1 16 Performing your first advanced SQL Server instance migration, part 2 17 High availability and disaster recovery 18 PowerShell and SQL Server Agent 19 SQL Server Agent administration 20 Creating and working with SQL Server Agent objects 21 Data masking 22 DevOps automation 23 Tracing SQL Server activity 24 Security and encryption 25 Data compression 26 Validating your estate with dbachecks 27 Working in the cloud 28 dbatools configurations and logging 29 Never the end

Manage your SAP S/4HANA and SAP ERP master data with this hands-on guide! Walk through implementing, configuring, and using SAP Master Data Governance, both on-premise and in the cloud! Whether your organization requires custom applications or works with out-of-the-box central governance, consolidation, and mass processing, you'll find detailed instructions for every step. From data modeling to data replication, this comprehensive guide will help you master your data! a. Modeling Create and extend data models by mastering entity types, attributes, hierarchies, and other elements. Use the floorplan manager for UI modeling and explore the use of change requests and workflows in process modeling. b. Data Quality and Replication Ensure your organization is using quality data in its operations. Learn to remediate and your enrich data. Then, move that data to where it needs to be in your system using tools like the data export framework, data import frameworks, and entity-based upload/download. c. Integrations and Extensions Put SAP MDG to use in your entire landscape by integrating with SAP Integration Suite, Central Finance, SAP Product Lifecycle Management, SAP Ariba, and more. Explore SAP MDG's quick start options and complementary solutions from SolEx. Highlights:On-premise and cloud deployment Data modeling Process modeling Data quality Data replication Data migration Consolidation Operations Mass processing Integrations Extensions Analytics

Get started with Hibernate, an open source Java persistence layer and gain a clear introduction to the current standard for object-relational persistence in Java. This updated edition includes the new Hibernate 6.0 framework which covers new configuration, new object relational mapping changes, and enhanced integration with the more general Spring, Boot and Quarkus and other Java frameworks.The book keeps its focus on Hibernate without wasting time on nonessential third-party tools, so you'll be able to immediately start building transaction-based engines and applications. Experienced authors Joseph Ottinger with Dave Minter and Jeff Linwood provide more in-depth examples than any other book for Hibernate beginners. They present their material in a lively, example-based manner—not a dry, theoretical, hard-to-read fashion.What You'll LearnBuild enterprise Java-based transaction-type applications that access complex data with HibernateWork with Hibernate 6 using a present-day build processIntegrate into the persistence life cycleSearch and query with the new version of HibernateKeep track of versioned data with Hibernate EnversWho This Book Is ForProgrammers experienced in Java with databases (the traditional, or connected, approach), but new to open-source, lightweight Hibernate.

Ready to improve the handling of your master data? Walk through implementing, configuring, and using SAP Master Data Governance (SAP MDG)! Whether your organization requires custom applications or works with out-of-the-box central governance, consolidation, and mass processing, you'll find detailed instructions for every step. From data, process, and UI modeling to data replication, master your data!Highlights include:1) Deployment2) Data modeling3) Process modeling4) Data quality5) Data replication6) Data migration7) Consolidation8) Operations9) Mass processing10) Integrations11) Extensions12) Analytics

In diesem Praxishandbuch lernen Sie das SAP-Standardwerkzeug zur Datenmigration, die Legacy System Migration Workbench (kurz LSMW), Schritt für Schritt kennen. Der Leitfaden vermittelt Einsteigern ein grundlegendes Verständnis der Arbeitsweise mit SAP LSMW und dient erfahrenen SAP-Berater als Nachschlagwerk. Auf der Basis von Praxisbeispielen und zahlreichen Screenshots werden die Funktionen dieses Tools anschaulich erläutert. Dazu gehören die verschiedenen Importtechniken, das Aufzeichnen von SAP-Transaktionen zum Laden und Ändern von Daten sowie das Administrieren von Projekten. SAP LSMW lässt sich auch ohne Programmierkenntnisse gut einsetzen und hilft Ihnen in der Kombination mit MS Excel, Daten erfolgreich aufzubereiten und zu migrieren. Inhalte sowie im Buch dargestellte Beispiele basieren auf dem Releasestand SAP ERP 6.08. In dieser zweiten Auflage zeigt die Autorin das Befüllen von SAP- bzw. kundeneigenen Tabellen und sie erläutert, inwieweit sich die Einführung von S/4HANA auf den Einsatz der LSM Workbench auswirkt. Zum Schluss wird mit dem Produkt „SimDia2“ eine Alternative zu LSMW vorgestellt. - Datenmigration ohne Programmierung - Details zum Update kundeneigener Tabellen - Änderungen zu LSMW unter S/4HANA - Tipps und Tricks für eine erfolgreiche Datenmigration

Todos conocemos qué es Microsoft Office, o podríamos decir incluso quién es, puesto que después de muchos años tiene ya su propia personalidad. La propia página de Microsoft le define como una suite ofimática; es decir, una recopilación de aplicaciones informáticas, que operan entre ellas, reduciendo costos y que están enfocadas para el uso en oficinas, trabajos y proyectos académicos, entre muchas y diversas tareas.

Extend FileMaker's built-in functionality and totally customize your data management environment with specialized functions and menus to super-charge the results and create a truly unique and focused experience. This book includes everything a beginner needs to get started building databases with FileMaker and contains advanced tips and techniques that the most seasoned professionals will appreciate. Written by a long time FileMaker developer, this book contains material for developers of every skill level. FileMaker Pro 16 is a powerful database development application used by millions of people in diverse industries to simplify data management tasks, leverage their business information in new ways and automate many mundane tasks. A custom solution built with FileMaker can quickly tap into a powerful set of capabilities and technologies to offer users an intuitive and pleasing environment in which to achieve new levels of efficiency and professionalism. What You'll learnCreate SQL queries to build fast and efficient formulasDiscover new features of version 16 such as JSON functions, Cards, Layout Object window, SortValues, UniqueValues, using variables in Data Sources Write calculations using built-in and creating your own custom functionsDiscover the importance of a good approach to interface and technical designApply best practices for naming conventions and usage standards Explore advanced topics about designing professional, open-ended solutions and using advanced techniquesWho This Book Is ForCasual programmers, full time consultants and IT professionals.

Policy-based data management enables the creation of community-specific collections. Every collection is created for a purpose. The purpose defines the set of properties that will be associated with the collection. The properties are enforced by management policies that control the execution of procedures that are applied whenever data are ingested or accessed. The procedures generate state information that defines the outcome of enforcing the management policy. The state information can be queried to validate assessment criteria and verify that the required collection properties have been conserved. The integrated Rule-Oriented Data System implements the data management framework required to support policy-based data management. Policies are turned into computer actionable Rules. Procedures are composed from a microservice-oriented architecture. The result is a highly extensible and tunable system that can enforce management policies, automate administrative tasks, and periodically validate assessment criteria. iRODS 4.0+ represents a major effort to analyze, harden, and package iRODS for sustainability, modularization, security, and testability. This has led to a fairly significant refactorization of much of the underlying codebase. iRODS has been modularized whereby existing iRODS 3.x functionality has been replaced and provided by small, interoperable plugins. The core is designed to be as immutable as possible and serve as a bus for handling the internal logic of the business of iRODS. Seven major interfaces have been exposed by the core and allow extensibility and separation of functionality into plugins.

A comprehensive guide from Oracle experts, that will act as your single point of reference for building an Oracle BI 12c system that turns data in actionable insight.Key Features[•]Come, start your first Oracle Business intelligence system and excel in BI with this exhaustive guide[•]An all-encompassing guide for your Oracle business intelligence needs[•]Learn from the self-paced professional guidance and implement Oracle business intelligence using this easy-to-follow guide by our expertsBook DescriptionOracle Business Intelligence Enterprise Edition (OBIEE) 12c is packed full of features and has a fresh approach to information presentation, system management, and security. OBIEE can help any organization to understand its data, to make useful information from data, and to ensure decision-making is supported by facts. OBIEE can focus on information that needs action, alerting users when conditions are met. OBIEE can be used for data analysis, form production, dashoarding, and workflow processes. We will introduce you to OBIEE features and provide a step-by-step guide to build a complete system from scratch. With this guide, you will be equipped with a good basic understanding of what the product contains, how to install and configure it, and how to create effective Business Intelligence. This book contains the necessary information for a beginner to create a high-performance OBIEE 12c system. This book is also a guide that explains how to use an existing OBIEE 12c system, and shows end users how to create.What you will learn[•]Install OBIEE in Windows, including how to create the underlying Weblogic Application server and the required database[•] Build the BI system repository, the vital engine connecting your data to the front end of Oracle BI[•] Develop effective analysis, draw out meaning from the data, and present it to end users on interactive dashboards[•] Build pixel-perfect, printable reports using the embedded BI Publisher feature[•] Build agents for actionable insight and enable your users to act on Business Intelligence at their desktop or on the move[•] Understand the various aspects of securing the Oracle BI system, from data restrictions to whole dashboard access rights[•] Get acquainted with the system management tools and methods available for the continuous improvement of your systemWho this book is forIf your job includes working on data, improving the financial or operational performance of your organization or you are a consultant for the above, then this book is for you. If you have been placed on a business intelligence project, then this book is for you. If you are the Project Manager, Business Analyst or Data Scientist then this book is for you. If you are an end user of Oracle Business Intelligence, then this book is for you too. Having a basic understanding of databases and the use of Business Intelligence is expected, but no knowledge of Oracle BI is required.

Achieve scalability and high availability without compromising on performance Key Features[•] See how to get 100 percent uptime with your Cassandra applications using this easy-follow guide[•] Learn how to avoid common and not-so-common mistakes while working with Cassandra using this highly practical guide[•] Get familiar with the intricacies of working with Cassandra for high availability in your work environment with this go-to-guideBook DescriptionApache Cassandra is a massively scalable, peer-to-peer database designed for 100 percent uptime, with deployments in the tens of thousands of nodes, all supporting petabytes of data. This book offers a practical insight into building highly available, real-world applications using Apache Cassandra. The book starts with the fundamentals, helping you to understand how Apache Cassandra's architecture allows it to achieve 100 percent uptime when other systems struggle to do so. You'll get an excellent understanding of data distribution, replication, and Cassandra's highly tunable consistency model. Then we take an in-depth look at Cassandra's robust support for multiple data centers, and you'll see how to scale out a cluster. Next, the book explores the domain of application design, with chapters discussing the native driver and data modeling. Lastly, you'll find out how to steer clear of common anti-patterns and take advantage of Cassandra's ability to fail gracefully. What you will learn[•] Understand how the core architecture of Cassandra enables highly available applications[•] Use replication and tunable consistency levels to balance consistency, availability, and performance[•] Set up multiple data centers to enable failover, load balancing, and geographic distribution[•] Add capacity to your cluster with zero downtime[•] Take advantage of high availability features in the native driver[•] Create data models that scale well and maximize availability[•] Understand common anti-patterns so you can avoid them[•] Keep your system working well even during failure scenariosWho this book is forIf you are a developer or DevOps engineer who has basic familiarity with Cassandra and you want to become an expert at creating highly available, fault tolerant systems using Cassandra, this book is for you.

Ein Datenbanksystem ist Bestandteil fast jeder betriebswirtschaftlichen Anwendung. Grundkenntnisse im Entwurf solcher Systeme werden meist im Studium oder in der Ausbildung vermittelt und durch Seminare und Kurse aufgefrischt. Stichworte sind relationale Datenbank, Normalisierung, ER-Modell und SQL. Bei der Entwicklung von Software kann im Idealfall auf eine bestehende Datenbank zurückgegriffen werden und es ist nur die Anbindung zu dieser zu realisieren. Andererseits kann es auch zum Auftragsumfang gehören, die Datenbank vom ersten Schritt an aufzubauen. In beiden Fällen sind Kenntnisse im Datenbankdesign notwendig. Dieser shortcut vermittelt Ihnen das nötige Handwerkszeug. Für den Neueinsteiger ist es ein guter Leitfaden, um sich Wissen anzueignen. Für den erfahrenen Entwickler ist es eine Chance, die eine oder andere Lücke zu schließen.

Start learning the latest in Office Office Simplified is the quick, easy, full-color guide to the new features and tools of the latest version of Office. With a clear, highly visual, introductory style of instruction, this book gives you step-by-step directions alongside illustrative screen shots to help you learn Microsoft's bestselling productivity software. You'll take a tour through all Office applications, and learn how the new tools can make your workday easier. The simplified approach eliminates unnecessary information, focusing instead on the essentials you need to know to get things done. Organized for easy navigation, this helpful guide is designed to be used both as a start-to-finish tutorial and as a handy desk reference when you run into unfamiliar territory. Whether you're upgrading from a previous version or using the Office suite of applications for the first time, this book has you covered every step of the way. You'll find the answers you need, new tools you can use, and the step-by-step guidance that helps you get it right on the first try. Get acquainted with the Office workflow Walk through Word, Excel, PowerPoint, Outlook, and Publisher Follow along with practical examples to tackle dozens of tasks Compose documents, create spreadsheets, organize your email, and more This book provides the ideal rundown of Microsoft Office's full feature set and capabilities. Even experienced users may learn something they never realized they were missing. If you need to get things done with minimal interruption to your workflow, Office Simplified will get you up to speed quickly and easily.

You don't need a technical background to build powerful databases with FileMaker Pro 14. This crystal-clear, objective guide shows you how to create a database that lets you do almost anything with your data so you can quickly achieve your goals. Whether you're creating catalogs, managing inventory and billing, or planning a wedding, you'll learn how to customize your database to run on a PC, Mac, web browser, or iOS device.The important stuff you need to know:Dive into relational data. Solve problems quickly by connecting and combining data from different tables.Create professional documents. Publish reports, charts, invoices, catalogs, and other documents with ease.Access data anywhere. Use FileMaker Go on your iPad or iPhone—or share data on the Web.Harness processing power. Use new calculation and scripting tools to crunch numbers, search text, and automate tasks.Run your database on a secure server. Learn the high-level features of FileMaker Pro Advanced.Keep your data safe. Set privileges and allow data sharing with FileMaker's streamlined security features.

Key FeaturesBook DescriptionThe book is aimed at intermediate developers with an understanding of core database concepts who want to become a master at implementing Cassandra for their application.What you will learnWho this book is forThe book is aimed at intermediate developers with an understanding of core database concepts who want to become a master at implementing Cassandra for their application.