Author: Divit Gupta
Publisher: BPB Publications
ISBN: 9355516290
Category : Computers
Languages : en
Pages : 333
Book Description
Navigating the Oracle landscape, mastering installation on OCI Compute KEY FEATURES ● Comprehend Oracle Database 21c installation, essential concepts, and advanced features. ● Focus on Oracle Cloud Infrastructure (OCI) Compute, to deploy databases in a cloud environment. ● Practical tips and best practices to optimize performance and troubleshoot effectively. DESCRIPTION Oracle Database 21c is the engine driving some of the most critical systems on the planet. "DBA Essentials for 21c," equips you with the essential knowledge and skills to confidently manage and optimize your Oracle Database in the cloud. This book breaks down Oracle Database Setup Wizard, Configuration Assistant, and steps for creating and configuring databases. In the first section, you will learn the basics of 21c, understand its Infrastructure, use its advantages, and learn its role in the modern data landscape. As you progress, you will gain knowledge of tools like Setup Wizard and Configuration Assistant to build powerful database structures and optimize performance. Then advanced topics are covered, where you will discover how to secure your data, troubleshoot common issues, and automate tasks for efficiency with practical tips and best practices. After reading this book, you will be highly competent in Oracle Database 21c installation on OCI Compute. You will grasp the fundamental concepts and sophisticated features to deploy databases in a cloud environment. WHAT YOU WILL LEARN ● Grasp the fundamental concepts of Oracle Cloud Infrastructure. ● Acquire in-depth knowledge of prerequisites for a seamless installation. ● Successfully install Oracle Database 21c in different environments. ● Proficiently use DBCA for creating and configuring databases. ● Learn to create container databases in both typical and advanced modes. ● Implement best practices for optimal OCI Compute deployment. WHO THIS BOOK IS FOR This book is designed for aspiring database administrators, system administrators, IT professionals, developers, and technology enthusiasts, curious about the inner workings of this powerful data management system. TABLE OF CONTENTS 1. Introduction to Oracle Database 21c 2. Introduction to Oracle Cloud Infrastructure 3. OCI Essentials and Key Features 4. OCI Compute Basics 5. Oracle Database Setup Wizard 6. Oracle Database Configuration Assistant 7. Oracle Database 21c Installation: Part 1 8. Oracle Database 21c Installation: Part 2 9. Create Container Database
DBA Essentials for 21c
Author: Divit Gupta
Publisher: BPB Publications
ISBN: 9355516290
Category : Computers
Languages : en
Pages : 333
Book Description
Navigating the Oracle landscape, mastering installation on OCI Compute KEY FEATURES ● Comprehend Oracle Database 21c installation, essential concepts, and advanced features. ● Focus on Oracle Cloud Infrastructure (OCI) Compute, to deploy databases in a cloud environment. ● Practical tips and best practices to optimize performance and troubleshoot effectively. DESCRIPTION Oracle Database 21c is the engine driving some of the most critical systems on the planet. "DBA Essentials for 21c," equips you with the essential knowledge and skills to confidently manage and optimize your Oracle Database in the cloud. This book breaks down Oracle Database Setup Wizard, Configuration Assistant, and steps for creating and configuring databases. In the first section, you will learn the basics of 21c, understand its Infrastructure, use its advantages, and learn its role in the modern data landscape. As you progress, you will gain knowledge of tools like Setup Wizard and Configuration Assistant to build powerful database structures and optimize performance. Then advanced topics are covered, where you will discover how to secure your data, troubleshoot common issues, and automate tasks for efficiency with practical tips and best practices. After reading this book, you will be highly competent in Oracle Database 21c installation on OCI Compute. You will grasp the fundamental concepts and sophisticated features to deploy databases in a cloud environment. WHAT YOU WILL LEARN ● Grasp the fundamental concepts of Oracle Cloud Infrastructure. ● Acquire in-depth knowledge of prerequisites for a seamless installation. ● Successfully install Oracle Database 21c in different environments. ● Proficiently use DBCA for creating and configuring databases. ● Learn to create container databases in both typical and advanced modes. ● Implement best practices for optimal OCI Compute deployment. WHO THIS BOOK IS FOR This book is designed for aspiring database administrators, system administrators, IT professionals, developers, and technology enthusiasts, curious about the inner workings of this powerful data management system. TABLE OF CONTENTS 1. Introduction to Oracle Database 21c 2. Introduction to Oracle Cloud Infrastructure 3. OCI Essentials and Key Features 4. OCI Compute Basics 5. Oracle Database Setup Wizard 6. Oracle Database Configuration Assistant 7. Oracle Database 21c Installation: Part 1 8. Oracle Database 21c Installation: Part 2 9. Create Container Database
Publisher: BPB Publications
ISBN: 9355516290
Category : Computers
Languages : en
Pages : 333
Book Description
Navigating the Oracle landscape, mastering installation on OCI Compute KEY FEATURES ● Comprehend Oracle Database 21c installation, essential concepts, and advanced features. ● Focus on Oracle Cloud Infrastructure (OCI) Compute, to deploy databases in a cloud environment. ● Practical tips and best practices to optimize performance and troubleshoot effectively. DESCRIPTION Oracle Database 21c is the engine driving some of the most critical systems on the planet. "DBA Essentials for 21c," equips you with the essential knowledge and skills to confidently manage and optimize your Oracle Database in the cloud. This book breaks down Oracle Database Setup Wizard, Configuration Assistant, and steps for creating and configuring databases. In the first section, you will learn the basics of 21c, understand its Infrastructure, use its advantages, and learn its role in the modern data landscape. As you progress, you will gain knowledge of tools like Setup Wizard and Configuration Assistant to build powerful database structures and optimize performance. Then advanced topics are covered, where you will discover how to secure your data, troubleshoot common issues, and automate tasks for efficiency with practical tips and best practices. After reading this book, you will be highly competent in Oracle Database 21c installation on OCI Compute. You will grasp the fundamental concepts and sophisticated features to deploy databases in a cloud environment. WHAT YOU WILL LEARN ● Grasp the fundamental concepts of Oracle Cloud Infrastructure. ● Acquire in-depth knowledge of prerequisites for a seamless installation. ● Successfully install Oracle Database 21c in different environments. ● Proficiently use DBCA for creating and configuring databases. ● Learn to create container databases in both typical and advanced modes. ● Implement best practices for optimal OCI Compute deployment. WHO THIS BOOK IS FOR This book is designed for aspiring database administrators, system administrators, IT professionals, developers, and technology enthusiasts, curious about the inner workings of this powerful data management system. TABLE OF CONTENTS 1. Introduction to Oracle Database 21c 2. Introduction to Oracle Cloud Infrastructure 3. OCI Essentials and Key Features 4. OCI Compute Basics 5. Oracle Database Setup Wizard 6. Oracle Database Configuration Assistant 7. Oracle Database 21c Installation: Part 1 8. Oracle Database 21c Installation: Part 2 9. Create Container Database
Exam Prep AZ-305
Author: Lalit Rawat
Publisher: BPB Publications
ISBN: 9355517114
Category : Computers
Languages : en
Pages : 608
Book Description
DESCRIPTION “Exam Prep AZ-305: Designing Microsoft Azure Infrastructure Solutions” book is a comprehensive guide for IT professionals preparing for the Microsoft Azure AZ-305 certification exam. This book offers detailed insights into designing scalable, secure, and resilient infrastructure solutions on the Azure platform, aligning with the latest exam objectives. It covers critical topics such as designing governance, security, storage, and networking solutions, ensuring readers have the necessary knowledge to architect effective Azure solutions. Through a blend of theoretical concepts and practical exercises, this guide equips readers with the skills needed to apply Azure best practices in real-world scenarios. Each chapter covers specific areas of infrastructure design, providing step-by-step instructions, expert tips, and real-life examples to illustrate complex concepts. This practical approach not only helps in mastering the exam content but also enhances the reader's ability to solve real-world challenges in their job roles. It not only prepares you for certification but also empowers you to design and implement robust Azure infrastructure solutions, thereby enhancing your capabilities and career prospects in the evolving field of cloud technology. KEY FEATURES ● Expertise in Azure networking, storage, compute, identity management, monitoring, security, hybrid cloud solutions, and disaster recovery. ● Learn to design and implement robust Azure infrastructure solutions. ● Prepare for the AZ-305 Azure Infrastructure Architect certification exam. ● Utilize up-to-date Microsoft AZ-305 curriculum. WHAT YOU WILL LEARN ● Master Azure governance principles. ● Design secure authentication and authorization solutions. ● Architect scalable compute solutions on Azure. ● Implement effective data storage and integration strategies. ● Design robust backup and disaster recovery solutions. ● Learn key migration strategies for transitioning to Azure. WHO THIS BOOK IS FOR Whether you are an aspiring cloud architect, a seasoned IT professional, or someone looking to advance their career in cloud computing, this book serves as an essential resource. TABLE OF CONTENTS 1. Designing Governance 2. Designing Authentication and Authorization Solutions 3. Designing a Solution Monitor of Azure Resources 4. Designing an Azure Compute Solution 5. Designing a Data Storage Solution for Non-relational Data 6. Designing Data Integration 7. Designing Data Storage Solutions for Relational Data 8. Designing Network Solutions 9. Designing a Solution for Backup and Disaster Recovery 10. Designing Migration 11. Azure Well-Architected Framework 12. Exam Preparation Guidelines and Assessment Questions 13. Azure Architect Exam Mock Test
Publisher: BPB Publications
ISBN: 9355517114
Category : Computers
Languages : en
Pages : 608
Book Description
DESCRIPTION “Exam Prep AZ-305: Designing Microsoft Azure Infrastructure Solutions” book is a comprehensive guide for IT professionals preparing for the Microsoft Azure AZ-305 certification exam. This book offers detailed insights into designing scalable, secure, and resilient infrastructure solutions on the Azure platform, aligning with the latest exam objectives. It covers critical topics such as designing governance, security, storage, and networking solutions, ensuring readers have the necessary knowledge to architect effective Azure solutions. Through a blend of theoretical concepts and practical exercises, this guide equips readers with the skills needed to apply Azure best practices in real-world scenarios. Each chapter covers specific areas of infrastructure design, providing step-by-step instructions, expert tips, and real-life examples to illustrate complex concepts. This practical approach not only helps in mastering the exam content but also enhances the reader's ability to solve real-world challenges in their job roles. It not only prepares you for certification but also empowers you to design and implement robust Azure infrastructure solutions, thereby enhancing your capabilities and career prospects in the evolving field of cloud technology. KEY FEATURES ● Expertise in Azure networking, storage, compute, identity management, monitoring, security, hybrid cloud solutions, and disaster recovery. ● Learn to design and implement robust Azure infrastructure solutions. ● Prepare for the AZ-305 Azure Infrastructure Architect certification exam. ● Utilize up-to-date Microsoft AZ-305 curriculum. WHAT YOU WILL LEARN ● Master Azure governance principles. ● Design secure authentication and authorization solutions. ● Architect scalable compute solutions on Azure. ● Implement effective data storage and integration strategies. ● Design robust backup and disaster recovery solutions. ● Learn key migration strategies for transitioning to Azure. WHO THIS BOOK IS FOR Whether you are an aspiring cloud architect, a seasoned IT professional, or someone looking to advance their career in cloud computing, this book serves as an essential resource. TABLE OF CONTENTS 1. Designing Governance 2. Designing Authentication and Authorization Solutions 3. Designing a Solution Monitor of Azure Resources 4. Designing an Azure Compute Solution 5. Designing a Data Storage Solution for Non-relational Data 6. Designing Data Integration 7. Designing Data Storage Solutions for Relational Data 8. Designing Network Solutions 9. Designing a Solution for Backup and Disaster Recovery 10. Designing Migration 11. Azure Well-Architected Framework 12. Exam Preparation Guidelines and Assessment Questions 13. Azure Architect Exam Mock Test
Fun with Data Analysis and BI
Author: Nitin Sethi
Publisher: BPB Publications
ISBN: 9355519265
Category : Computers
Languages : en
Pages : 368
Book Description
DESCRIPTION Fun with Data Analysis and BI teaches you how to turn raw data into actionable insights using business intelligence tools. It equips you with essential skills to make data-driven decisions and effectively communicate findings. This book is designed to guide you through learning SQL from the ground up. Starting with installation and environment setup, it covers everything from building databases and creating tables to mastering SQL queries. Alongside theoretical concepts, you will engage in hands-on projects that demonstrate practical applications, including market analysis using Python to track stock trends and churn analysis to understand customer behavior. Each chapter concludes with MCQs to test your knowledge. The book also introduces you to Tableau, a powerful tool for creating visualizations without writing code, with step-by-step instructions on how to use it for your data projects. By the end of this book, you will be equipped with the skills to extract valuable insights from complex datasets, visualize data in compelling ways, and make data-driven decisions that positively impact your organization. KEY FEATURES ● In-depth coverage of SQL, Python, ML, and Tableau for all skill levels. ● Hands-on projects to transform raw information into valuable data insights. ● Practical examples and end-to-end solutions for mastering data science concepts. WHAT YOU WILL LEARN ● Install and set up SQL environments, create databases, develop tables, and write effective SQL queries. ● Use Python to analyze stock market data, create clusters, and support data-driven decisions. ● Apply ML to understand consumer behavior, predict churn, and improve retention. ● Design striking data visuals with Tableau, enhancing data presentation skills without coding. ● Gain hands-on experience by working on complete projects, from data preparation to final output. WHO THIS BOOK IS FOR Whether you are a business analyst, data scientist, or aspiring data professional, this book provides the essential knowledge and practical guidance to excel in the field of data analysis. TABLE OF CONTENTS 1. E-Ticket Booking 2. Creating Games on Python 3. Introduction to Sentiment Analysis 4. Sentiment Analysis on E-Commerce: Product Reviews 5. Sentiment Analysis on X 6. Stroke Prediction 7. Movie Review Sentiment Analysis 8. Stock Market Data Analysis 9. Customer Data Analysis 10. Analyzing Sports Data in Tableau 11. Office Supplies Dashboard Using Tableau 12. COVID Dashboard Using Tableau
Publisher: BPB Publications
ISBN: 9355519265
Category : Computers
Languages : en
Pages : 368
Book Description
DESCRIPTION Fun with Data Analysis and BI teaches you how to turn raw data into actionable insights using business intelligence tools. It equips you with essential skills to make data-driven decisions and effectively communicate findings. This book is designed to guide you through learning SQL from the ground up. Starting with installation and environment setup, it covers everything from building databases and creating tables to mastering SQL queries. Alongside theoretical concepts, you will engage in hands-on projects that demonstrate practical applications, including market analysis using Python to track stock trends and churn analysis to understand customer behavior. Each chapter concludes with MCQs to test your knowledge. The book also introduces you to Tableau, a powerful tool for creating visualizations without writing code, with step-by-step instructions on how to use it for your data projects. By the end of this book, you will be equipped with the skills to extract valuable insights from complex datasets, visualize data in compelling ways, and make data-driven decisions that positively impact your organization. KEY FEATURES ● In-depth coverage of SQL, Python, ML, and Tableau for all skill levels. ● Hands-on projects to transform raw information into valuable data insights. ● Practical examples and end-to-end solutions for mastering data science concepts. WHAT YOU WILL LEARN ● Install and set up SQL environments, create databases, develop tables, and write effective SQL queries. ● Use Python to analyze stock market data, create clusters, and support data-driven decisions. ● Apply ML to understand consumer behavior, predict churn, and improve retention. ● Design striking data visuals with Tableau, enhancing data presentation skills without coding. ● Gain hands-on experience by working on complete projects, from data preparation to final output. WHO THIS BOOK IS FOR Whether you are a business analyst, data scientist, or aspiring data professional, this book provides the essential knowledge and practical guidance to excel in the field of data analysis. TABLE OF CONTENTS 1. E-Ticket Booking 2. Creating Games on Python 3. Introduction to Sentiment Analysis 4. Sentiment Analysis on E-Commerce: Product Reviews 5. Sentiment Analysis on X 6. Stroke Prediction 7. Movie Review Sentiment Analysis 8. Stock Market Data Analysis 9. Customer Data Analysis 10. Analyzing Sports Data in Tableau 11. Office Supplies Dashboard Using Tableau 12. COVID Dashboard Using Tableau
Expert Oracle Database Architecture
Author: Darl Kuhn
Publisher: Apress
ISBN: 9781484274989
Category : Computers
Languages : en
Pages : 0
Book Description
Now in its fourth edition and covering Oracle Database 21c, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom Kyte and Darl Kuhn share a simple philosophy: "you can treat Oracle as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment." If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised fourth edition covers the developments and new features up to Oracle Database 21c. Up-to-date features are covered for tables, indexes, data types, sequences, partitioning, data loading, temporary tables, and more. All the examples are demonstrated using modern techniques and are executed in container and pluggable databases. The book’s proof-by-example approach encourages you to let evidence be your guide. Try something. See the result. Understand why the result is what it is. Apply your newfound knowledge with confidence. The book covers features by explaining how each one works, how to implement software using it, and the common pitfalls associated with it. Don’t treat Oracle Database as a black box. Get this book. Dive deeply into Oracle Database’s most powerful features that many do not invest the time to learn about. Set yourself apart from your competition and turbo-charge your career. What You Will Learn Identify and effectively resolve application performance issues and bottlenecks Architect systems to leverage the full power and feature set of Oracle’s database engine Configure a database to maximize the use of memory structures and background processes Understand internal locking and latching technology and how it impacts your system Proactively recommend best practices around performance for table and index structures Take advantage of advanced features such as table partitioning and parallel execution Who This Book Is For Oracle developers and Oracle DBAs. If you’re a developer and want a stronger understanding of Oracle features and architecture that will enable your applications to scale regardless of the workload, this book is for you. If you’re a DBA and want to intelligently work with developers to design applications that effectively leverage Oracle technology, then look no further.
Publisher: Apress
ISBN: 9781484274989
Category : Computers
Languages : en
Pages : 0
Book Description
Now in its fourth edition and covering Oracle Database 21c, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom Kyte and Darl Kuhn share a simple philosophy: "you can treat Oracle as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment." If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised fourth edition covers the developments and new features up to Oracle Database 21c. Up-to-date features are covered for tables, indexes, data types, sequences, partitioning, data loading, temporary tables, and more. All the examples are demonstrated using modern techniques and are executed in container and pluggable databases. The book’s proof-by-example approach encourages you to let evidence be your guide. Try something. See the result. Understand why the result is what it is. Apply your newfound knowledge with confidence. The book covers features by explaining how each one works, how to implement software using it, and the common pitfalls associated with it. Don’t treat Oracle Database as a black box. Get this book. Dive deeply into Oracle Database’s most powerful features that many do not invest the time to learn about. Set yourself apart from your competition and turbo-charge your career. What You Will Learn Identify and effectively resolve application performance issues and bottlenecks Architect systems to leverage the full power and feature set of Oracle’s database engine Configure a database to maximize the use of memory structures and background processes Understand internal locking and latching technology and how it impacts your system Proactively recommend best practices around performance for table and index structures Take advantage of advanced features such as table partitioning and parallel execution Who This Book Is For Oracle developers and Oracle DBAs. If you’re a developer and want a stronger understanding of Oracle features and architecture that will enable your applications to scale regardless of the workload, this book is for you. If you’re a DBA and want to intelligently work with developers to design applications that effectively leverage Oracle technology, then look no further.
Easy Oracle Automation
Author: Arun Kumar R.
Publisher: Rampant TechPress
ISBN: 0974599360
Category : Database management
Languages : en
Pages : 296
Book Description
Explaining how to use the powerful Oracle10g automatic features for simple database administration, this book has complete coverage for 10g Automatic Storage Management (ASM), 10g Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Automatic SGA Management (ASM), and the SQL Tuning Advisor. Demonstrated is how a non-Oracle person can quickly install and configure Oracle database 10g for automatic database administration and how, in less than a day, a complete Oracle10g database can be ready to use. Also explained is easy disk and file management with the 10g Automatic Storage Management and how the 10g Automatic Workload Repository collects important Oracle performance statistics.
Publisher: Rampant TechPress
ISBN: 0974599360
Category : Database management
Languages : en
Pages : 296
Book Description
Explaining how to use the powerful Oracle10g automatic features for simple database administration, this book has complete coverage for 10g Automatic Storage Management (ASM), 10g Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Automatic SGA Management (ASM), and the SQL Tuning Advisor. Demonstrated is how a non-Oracle person can quickly install and configure Oracle database 10g for automatic database administration and how, in less than a day, a complete Oracle10g database can be ready to use. Also explained is easy disk and file management with the 10g Automatic Storage Management and how the 10g Automatic Workload Repository collects important Oracle performance statistics.
Annual Report
Author: United States. Small Business Administration
Publisher:
ISBN:
Category : Small business
Languages : en
Pages : 728
Book Description
Publisher:
ISBN:
Category : Small business
Languages : en
Pages : 728
Book Description
PostgreSQL High Availability Cookbook - Second Edition
Author: Shaun M. Thomas
Publisher:
ISBN: 9781787125537
Category :
Languages : en
Pages : 472
Book Description
Over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL 9.4,9.5 and 9.6About This Book* Create a PostgreSQL cluster that stays online even when disaster strikes* Avoid costly downtime and data loss that can ruin your business* Updated to include the newest features introduced in PostgreSQL 9.6 with hands-on industry-driven recipesWho This Book Is ForIf you are a PostgreSQL DBA working on Linux systems who want a database that never gives up, this book is for you. If you've ever experienced a database outage, restored from a backup, spent hours trying to repair a malfunctioning cluster, or simply want to guarantee system stability, this book is definitely for you.What you will learn* Protect your data with PostgreSQL replication and management tools such as Slony, Bucardo, pglogical, and WAL-E* Hardware planning to help your database run efficiently* Prepare for catastrophes and prevent them before they happen* Reduce database resource contention with connection pooling using pgpool and PgBouncer* Automate monitoring and alerts to visualize cluster activity using Nagios and collected* Construct a robust software stack that can detect and fix outages* Learn simple PostgreSQL High Availability with Patroni, or dive into the full power of Pacemaker.In DetailDatabases are nothing without the data they store. In the event of a failure - catastrophic or otherwise - immediate recovery is essential. By carefully combining multiple servers, it's even possible to hide the fact a failure occurred at all.From hardware selection to software stacks and horizontal scalability, this book will help you build a versatile PostgreSQL cluster that will survive crashes, resist data corruption, and grow smoothly with customer demand. It all begins with hardware selection for the skeleton of an efficient PostgreSQL database cluster. Then it's on to preventing downtime as well as troubleshooting some real life problems that administrators commonly face. Next, we add database monitoring to the stack, using collectd, Nagios, and Graphite. And no stack is complete without replication using multiple internal and external tools, including the newly released pglogical extension. Pacemaker or Raft consensus tools are the final piece to grant the cluster the ability to heal itself. We even round off by tackling the complex problem of data scalability.This book exploits many new features introduced in PostgreSQL 9.6 to make the database more efficient and adaptive, and most importantly, keep it running.
Publisher:
ISBN: 9781787125537
Category :
Languages : en
Pages : 472
Book Description
Over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL 9.4,9.5 and 9.6About This Book* Create a PostgreSQL cluster that stays online even when disaster strikes* Avoid costly downtime and data loss that can ruin your business* Updated to include the newest features introduced in PostgreSQL 9.6 with hands-on industry-driven recipesWho This Book Is ForIf you are a PostgreSQL DBA working on Linux systems who want a database that never gives up, this book is for you. If you've ever experienced a database outage, restored from a backup, spent hours trying to repair a malfunctioning cluster, or simply want to guarantee system stability, this book is definitely for you.What you will learn* Protect your data with PostgreSQL replication and management tools such as Slony, Bucardo, pglogical, and WAL-E* Hardware planning to help your database run efficiently* Prepare for catastrophes and prevent them before they happen* Reduce database resource contention with connection pooling using pgpool and PgBouncer* Automate monitoring and alerts to visualize cluster activity using Nagios and collected* Construct a robust software stack that can detect and fix outages* Learn simple PostgreSQL High Availability with Patroni, or dive into the full power of Pacemaker.In DetailDatabases are nothing without the data they store. In the event of a failure - catastrophic or otherwise - immediate recovery is essential. By carefully combining multiple servers, it's even possible to hide the fact a failure occurred at all.From hardware selection to software stacks and horizontal scalability, this book will help you build a versatile PostgreSQL cluster that will survive crashes, resist data corruption, and grow smoothly with customer demand. It all begins with hardware selection for the skeleton of an efficient PostgreSQL database cluster. Then it's on to preventing downtime as well as troubleshooting some real life problems that administrators commonly face. Next, we add database monitoring to the stack, using collectd, Nagios, and Graphite. And no stack is complete without replication using multiple internal and external tools, including the newly released pglogical extension. Pacemaker or Raft consensus tools are the final piece to grant the cluster the ability to heal itself. We even round off by tackling the complex problem of data scalability.This book exploits many new features introduced in PostgreSQL 9.6 to make the database more efficient and adaptive, and most importantly, keep it running.
PeopleSoft for the Oracle DBA
Author: David Kurtz
Publisher: Apress
ISBN: 1430237082
Category : Computers
Languages : en
Pages : 540
Book Description
PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz's book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment. You’ll learn about PeopleSoft’s Internet architecture and its use of Oracle’s Tuxedo Application Server. You’ll find full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft. Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a PeopleSoft environment. The solid coverage of performance troubleshooting is enough by itself to make PeopleSoft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a PeopleSoft environment. Explains PeopleSoft’s technical architecture as it relates to Oracle Database Demonstrates how to instrument and measure the performance of PeopleSoft Provides techniques to troubleshoot and resolve performance problems
Publisher: Apress
ISBN: 1430237082
Category : Computers
Languages : en
Pages : 540
Book Description
PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz's book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment. You’ll learn about PeopleSoft’s Internet architecture and its use of Oracle’s Tuxedo Application Server. You’ll find full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft. Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a PeopleSoft environment. The solid coverage of performance troubleshooting is enough by itself to make PeopleSoft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a PeopleSoft environment. Explains PeopleSoft’s technical architecture as it relates to Oracle Database Demonstrates how to instrument and measure the performance of PeopleSoft Provides techniques to troubleshoot and resolve performance problems
OCA: Oracle Database 12c Administrator Certified Associate Study Guide
Author: Biju Thomas
Publisher: John Wiley & Sons
ISBN: 111864395X
Category : Computers
Languages : en
Pages : 1238
Book Description
An all-in-one study guide prepares you for the updated Oracle Certified Associate certification It's been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority. This resource answers that demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams. Provides you with a solid understanding of restricting and sorting data Walks you through using conversion functions and conditional expressions Addresses displaying data from multiple tables, manipulating data, database maintenance, and database backups and recovery Explores the Oracle database architecture and discusses preparing the database environment, creating an Oracle database, and managing the Oracle instance Focuses on administering and implementing user security This must-have study guide thoroughly prepares you to take the dramatically updated Oracle 12c OCA exams.
Publisher: John Wiley & Sons
ISBN: 111864395X
Category : Computers
Languages : en
Pages : 1238
Book Description
An all-in-one study guide prepares you for the updated Oracle Certified Associate certification It's been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority. This resource answers that demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams. Provides you with a solid understanding of restricting and sorting data Walks you through using conversion functions and conditional expressions Addresses displaying data from multiple tables, manipulating data, database maintenance, and database backups and recovery Explores the Oracle database architecture and discusses preparing the database environment, creating an Oracle database, and managing the Oracle instance Focuses on administering and implementing user security This must-have study guide thoroughly prepares you to take the dramatically updated Oracle 12c OCA exams.
Learn SQL with MySQL
Author: Pajankar Ashwin
Publisher: BPB Publications
ISBN: 9389898137
Category : Computers
Languages : en
Pages : 178
Book Description
A step-by-step guide that will help you manage data in a relational database using SQL with ease Key Features a- Understand the concepts related to relational databases. a- Learn how to install MariaDB and MySQL on Windows, Linux and tools to access it. a- Learn how to connect Python and Pandas to MySQL/MariaDB. Description This book starts with the concepts in RDBMS (Relational Database Management Systems) and SQL (Structured Query Language). The first few chapters cover the definitions and a brief explanation of all the important concepts. They also cover the installation of MariaDB and MySQL on Windows and Raspberry Pi, as well as the setup of various tools used to connect to MySQL and MariaDB server processes. We will also understand how to install sample schemas and how to use basic SQL queries. Then we move on to the SELECT query in detail. The book explores the data retrieval aspect of SQL queries in detail with the WHERE clause and NULL handling in detail. The book also explores the functions available in MySQL. Those are single row and group functions. Then we explore how to combine the data from multiple sources. The technique is known as Joins, and we will learn ANSI style and the old-style syntax for all the types of Joins. The last part explores the DDL and DMLs in depth. We also learn the concepts of Transactions and Constraints. The book explores how we can run the SQL queries from a Python 3 program and load a pandas DataFrame with the data from a table in a schema in the MySQL database. What will you learn a- Understand the basics of MySQL and MariaDB. a- Get familiar with MySQL Arithmetic Operators, DDL, DML, DCL & TCL commands. a- Understand the concept of Single-Row Functions and Group Functions in detail. a- Retrieve data from multiple sources using the Joins. Who this book is for This book is designed for beginners as well as professionals alike. The book will also be useful to Data Scientists, Data Analysts, Database Administrators, and Data Engineers. Table of Contents 1. Introduction and Installation 2. Getting Started with MySQL 3. Getting Started with SQL Queries 4. The WHERE clause in detail 5. Single Row Functions 6. Group Functions 7. Joins in MySQL 8. Subqueries 9. DDL, DML, and Transactions 10. Views 11. Python 3, MySQL, and Pandas About the Author Ashwin is an experienced veteran who, for the past 25 years, has been working with STEM (Science, Technology, Engineering, and Mathematics). In his career, Ashwin has worked for more than 7 years as an employee for various IT companies and Software Product Companies. He has written more than 2 dozen books on Arduino, Python programming, Computer Vision, IoT, databases, and other popular topics with BPB and other international publications. He has also reviewed many other technical books. He also creates courses for BPB and other platforms and teaches to 60000 students online. He has been working as a freelancer since 2017. He got his first taste in writing in 2015 when he wrote his first book on Raspberry Pi. In his free time, Ashwin makes videos for his Youtube channel, which has 10000 subscribers now. Outside work, Ashwin volunteers his spare time as a STEM Ambassador, helping, coaching, and mentoring young people in taking up careers in technology. Your Blog links: https://www.youtube.com/ashwinpajankar Your LinkedIn Profile: https://www.linkedin.com/in/ashwinpajankar/
Publisher: BPB Publications
ISBN: 9389898137
Category : Computers
Languages : en
Pages : 178
Book Description
A step-by-step guide that will help you manage data in a relational database using SQL with ease Key Features a- Understand the concepts related to relational databases. a- Learn how to install MariaDB and MySQL on Windows, Linux and tools to access it. a- Learn how to connect Python and Pandas to MySQL/MariaDB. Description This book starts with the concepts in RDBMS (Relational Database Management Systems) and SQL (Structured Query Language). The first few chapters cover the definitions and a brief explanation of all the important concepts. They also cover the installation of MariaDB and MySQL on Windows and Raspberry Pi, as well as the setup of various tools used to connect to MySQL and MariaDB server processes. We will also understand how to install sample schemas and how to use basic SQL queries. Then we move on to the SELECT query in detail. The book explores the data retrieval aspect of SQL queries in detail with the WHERE clause and NULL handling in detail. The book also explores the functions available in MySQL. Those are single row and group functions. Then we explore how to combine the data from multiple sources. The technique is known as Joins, and we will learn ANSI style and the old-style syntax for all the types of Joins. The last part explores the DDL and DMLs in depth. We also learn the concepts of Transactions and Constraints. The book explores how we can run the SQL queries from a Python 3 program and load a pandas DataFrame with the data from a table in a schema in the MySQL database. What will you learn a- Understand the basics of MySQL and MariaDB. a- Get familiar with MySQL Arithmetic Operators, DDL, DML, DCL & TCL commands. a- Understand the concept of Single-Row Functions and Group Functions in detail. a- Retrieve data from multiple sources using the Joins. Who this book is for This book is designed for beginners as well as professionals alike. The book will also be useful to Data Scientists, Data Analysts, Database Administrators, and Data Engineers. Table of Contents 1. Introduction and Installation 2. Getting Started with MySQL 3. Getting Started with SQL Queries 4. The WHERE clause in detail 5. Single Row Functions 6. Group Functions 7. Joins in MySQL 8. Subqueries 9. DDL, DML, and Transactions 10. Views 11. Python 3, MySQL, and Pandas About the Author Ashwin is an experienced veteran who, for the past 25 years, has been working with STEM (Science, Technology, Engineering, and Mathematics). In his career, Ashwin has worked for more than 7 years as an employee for various IT companies and Software Product Companies. He has written more than 2 dozen books on Arduino, Python programming, Computer Vision, IoT, databases, and other popular topics with BPB and other international publications. He has also reviewed many other technical books. He also creates courses for BPB and other platforms and teaches to 60000 students online. He has been working as a freelancer since 2017. He got his first taste in writing in 2015 when he wrote his first book on Raspberry Pi. In his free time, Ashwin makes videos for his Youtube channel, which has 10000 subscribers now. Outside work, Ashwin volunteers his spare time as a STEM Ambassador, helping, coaching, and mentoring young people in taking up careers in technology. Your Blog links: https://www.youtube.com/ashwinpajankar Your LinkedIn Profile: https://www.linkedin.com/in/ashwinpajankar/