Take a look at our COM021000 books. Shulph carries a great selection of COM021000 books, and we are always adding more.
Run queries and analysis on big data clusters across relational and non relational databases Description This book brings exciting coverage on establishing and managing data virtualization using polybase. This book teaches how to configure polybase on almost all relational and nonrelational databases. You will learn to set up the test environment for any tool or software instantly without hassle. You will practice how to design and build some of the high performing data warehousing solutions and that too in a few minutes of time. You will almost become an expert in connecting to all databases including hadoop, cassandra, MySQL, PostgreSQL, MariaDB and Oracle database. This book also brings exclusive coverage on how to build data clusters on Azure and using Azure Synapse Analytics. By the end of this book, you just don't administer the polybase for managing big data clusters but rather you learn to optimize and boost the performance for enabling data analytics and ease of data accessibility. What you will learn -Learn to configure Polybase and process Transact SQL queries with ease. -Create a Docker container with SQL Server 2019 on Windows and Polybase. -Establish SQL Server instance with any other software or tool using Polybase. -Connect with Cassandra, MongoDB, MySQL, PostgreSQL, MariaDB, and IBM DB2. Who this book is for This book is for database developers and administrators familiar with the SQL language and command prompt. Managers and decision-makers will also find this book useful. No prior knowledge of any other technology or language is required. Table of Contents 1. What is Data Virtualization (Polybase) 2. History of Polybase 3. Polybase current state 4. Differences with other technologies 5. Usage 6. Future 7. SQL Server 8. Hadoop Cloudera and Hortonworks 9. Windows Azure Storage Blob 10. Spark 11. From Azure Synapse Analytics 12. From Big Data Clusters 13. Oracle 14. Teradata 15. Cassandra 16. MongoDB 17. CosmosDB 18. MySQL 19. PostgreSQL 20. MariaDB 21. SAP HANA 22. IBM DB2 23. Excel
A step-by-step guide to practising Oracle GoldenGate High Availability (HA) options, Microservices, and Real-Time downstream techniques Key Features Understand how and when they're used classic Vs. Microservices Learn how to use real-time downstream methods based on the environment Learn how to solve Oracle GoldenGate (OGG) Conflict Detection and Resolution (CDR) in bi-directional, active replication Learn how to implement high availability for mission-critical systems using Oracle GoldenGate – XAG components Learn how to set up bi-directional replication between pluggable databases (PDBs) in a multi-tenant environment Learn how to use differently typed of replicates in pluggable databases (PDBs) in a multi-tenant environment Description The book starts with a brief introduction about Oracle GoldenGate with Microservices and how to configure high availability using various methods. Oracle GoldenGate Microservices Architecture (MA) is a similar architecture based on REST APIs which enable us to configure, monitor, and manage Oracle GoldenGate services using a web-based user interface. Each module supports a specific business goal and uses a simple, lightweight, and well-defined interface to communicate with other sets of services. What will you learn By the end of the book, you will come across a few case studies about how to use Microservices, Kubernetes, REST APIs in Oracle GoldenGate, and How to monitor Oracle GoldenGate processes in real-time environments. This book also helps how to use various file systems like ACFS, DBFS, and NFS in high availability for Oracle GoldenGate. Who this book is for This book is intended for anyone looking for how to set up and configure Uni-directional, Bi-directional replication in mission-critical environments either using classic Oracle GoldenGate OR Oracle GoldenGate with Microservices. This book also helps various methods to implement real-time downstream techniques. Table of Contents 1. Introduction to Oracle GoldenGate HA - XAG Components 2. Extract and Replicat in Multitenant Environment 3. Consolidated and Cascaded Oracle GoldenGate 4. Introduction to Oracle GoldenGate Methodologies 5. Introduction to Oracle GoldenGate Utilities 6. Bi-Directional Replication with Conflict Detection and Resolution (CDR) 7. Bi-directional Replication with Pluggable Databases (PDBs) in Multitenant Environment 8. Real-Time Downstream Database with Multiple Scenarios 9. Oracle GoldenGate Microservices Architecture overview 10. Managing Oracle GoldenGate and Kubernetes 11. Automation Recipes Via Rest APIs 12. Oracle GoldenGate Tuning and Troubleshooting About the Author Yenugula Venkata Ravi Kumar (YVR) is an Oracle ACE Director and Oracle Certified Master (OCM) with 22+ years of experience in the banking, financial services, and insurance (BFSI) verticals. Mariami Kupatadze is an Oracle Certified Master since 2016. She is the first OCM in her country, Georgia. Mari is a member of the ACE program. She has published several articles in OraWorld e-magazine and Oracle Technology Network. Mari has been a speaker in APAC Oracle Users Groups Community (APACOUC) and Luxembourg Oracle Users Group (LUXOUG). Konstantin Kerekovski is an Oracle professional with more than seven years of experience in the financial services industry. He is a member of the Independent Oracle User Group, Suncoast Oracle User Group, and New York Oracle User Group. Tridib Das is a Senior Database Administrator with more than 9 years’ experience on Oracle and MySQL.
Understanding and implementing the database management systems concepts in SQL and PL/SQL Key Features Practice SQL concepts by writing queries and perform your own data visualization and analysis. Gain insights on Entity Relationship Model and how to implement in your business environment. Series of question banks and case-studies to develop strong hold on RDBMS concepts. Description Relational Database Management Systems In-Depth brings the fundamental concepts of database management systems to you in more elaborated learning with conceptual clarity of RDBMS. This book brings an extensive coverage of theoretical concepts on types of databases, concepts of relational database management systems, normalization and many more. You will explore exemplification of Entity Relational Model concepts that would teach the readers to design accurate business systems. Backed with a series of examples, you can practice the fundamental concepts of RDBMS and SQL queries including Oracle’s SQL queries, MySQL and SQL Server. In addition to the illustration of concepts on SQL, there is an implementation of crucial business rules using PL/SQL based stored procedures and database triggers.Finally, by the end of this book there is a mention of the useful data oriented technologies like Big Data, Data Lake etc and the crucial role played by such techniques in the current data driven decisions. Throughout the book, you will come across key learnings and key terms that will help you to understand and revise the concepts learned. Along with this, you will also come across questions and case studies by the end of every chapter to prepare for job interviews and certifications. What you will learn Depiction of Entity Relationship Model with various business case studies. Illustration of the normalization concept to make the database stronger and consistent. Designing the successful client-server applications using PL/SQL concepts. Learning the concepts of OODBS and Database Design with Normalization and Relationships. Who this book is for This book is meant for academicians, students, developers and administrators including beginners and readers experienced in some other programming languages and database systems. Table of Contents 1. Database Systems Architecture 2. Database Management System Models 3. Relational query languages 4. Relational Database Design 5. Query Processing and Optimization 6. Transaction Processing 7. Implementation Techniques 8. SQL Concepts 9. PL/SQL Concepts 10. Collections in PL/SQL 11. What Next? About the Author Dr. Madhavi Vaidya is an experienced and qualified Assistant Professor with a demonstrated history of working in the education management industry . Skilled in programming languages like C, Python, SQL, Oracle Database, Dr. Madhavi has understanding and knowledge of Data Analytics, Information Retrieval, Software Engineering and Project Management. She has strong education professional with a Master of Computer Applications and Doctor of Philosophy in the subject of Computer Science and Engineering. One of the key areas of her research is Big Data analytics using Hadoop-MapReduce and various Big Data technologies. She is a Content Writer @Udemy and various other online courses are in her credit including BPB publications. Ample research papers are in her credit, presented and published in various National and International conference along with research chapters and articles in ACM, IEEE, Elsevier and Developer IQ magazine. Reviewing articles and research papers- Acting as a reviewer for the journals like IEEE Access, ASSA, IGI Global and many other prestigious journals. LinkedIn Profile: https://www.linkedin.com/in/dr-madhavi-v-01882327
Complete reference guide to Redis Key Features Complete coverage of Redis Modules. Best practices, tips and tricks, and expert techniques to scale Redis. Troubleshooting solutions to perform real-time faster data processing for client applications. Description This book begins with teaching you to set up your own Redis environment, followed by Redis data structures, their architecture, and use cases. You get to learn the details about Redis Modules such as RediSearch, RedisJSON, RedisTimeSeries, RedisAI, and RedisGraph with specific business use-case examples. This book makes you a Redis Expert by getting you hands-on with best practices on Redis and some tricks to scale Redis activities. What you will learn Redis’s advantages over the other NOSQL databases. Explore Redis Enterprise and its real gameplay in enterprise applications. Learn Redis data structures through practically demonstrated use cases. Learn from Industry expert to setup the Redis in production environment. Understand how Redis enterprise enhances Redis OSS. Who this book is for This book is ideal for anyone who is interested in understanding the basic concepts of the Redis database. The book will help the IT professionals, Software developers, Technical leads, Architects. Readers should have a working knowledge of database designing, basic programming skills, and an understanding of the latest trends in cloud computing. Table of Contents 1. Introduction to NoSQL World 2. NoSQL database types 3. Are NoSQL databases better than traditional databases? 4. History of Redis 5. Getting started with Redis 6. Setting up Redis 7. Redis Data Structures in details 8. Scaling Redis 9. Modules 10. Redis use cases 11. Redis as database service - enterprise solutions 12. What is new in Redis 6? 13. Appendix A  , , , , , ,(i) Using Redis-cli  , , , , , ,(ii) RedisInsight tool  , , , , , ,(iii) Community helps About the Author Suyog is a solutions architect at Redis Labs (a database unicorn company in Silicon Valley). Suyog is a technology evangelist, community helper, and has broad technical knowledge and business experience with a specialization in distributed, micro-services, low-latency, and high-throughput demand mission critical apps. He is a trusted advisor to Redis Labs customers, which include leading global banking institutions, fintechs, telcos, media, and financial service providers. LinkedIn Profile: Suyog Kale: https://www.linkedin.com/in/suyogkale// Chinmay is the founder and director of Hybrowlabs Technologies, a digital solutions and cloud consultancy company based out of Pune. He helps fortune 500 clients create awesome websites. He is a passionate speaker of OSS. In his free time, Chinmay likes to read non-fiction books on psychology, history, and philosophy. LinkedIn Profile: https://www.linkedin.com/in/cykulkarni/