DBA Essentials for 21c
DBA Essentials for 21c

Author: Divit Gupta

Publisher: BPB Publications

Published: 2023-12-30

Total Pages: 333

ISBN-13: 9355516290

DOWNLOAD EBOOK

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
Exam Prep AZ-305

Author: Lalit Rawat

Publisher: BPB Publications

Published: 2024-07-24

Total Pages: 608

ISBN-13: 9355517114

DOWNLOAD EBOOK

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
Fun with Data Analysis and BI

Author: Nitin Sethi

Publisher: BPB Publications

Published: 2024-08-29

Total Pages: 368

ISBN-13: 9355519265

DOWNLOAD EBOOK

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
Expert Oracle Database Architecture

Author: Darl Kuhn

Publisher: Apress

Published: 2021-11-14

Total Pages: 0

ISBN-13: 9781484274989

DOWNLOAD EBOOK

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
Easy Oracle Automation

Author: Arun Kumar R.

Publisher: Rampant TechPress

Published: 2005

Total Pages: 296

ISBN-13: 0974599360

DOWNLOAD EBOOK

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.

Oracle PL/SQL Programming
Oracle PL/SQL Programming

Author: Steven Feuerstein

Publisher: "O'Reilly Media, Inc."

Published: 2002

Total Pages: 1028

ISBN-13: 9780596003814

DOWNLOAD EBOOK

The authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.

OCA: Oracle Database 12c Administrator Certified Associate Study Guide
OCA: Oracle Database 12c Administrator Certified Associate Study Guide

Author: Biju Thomas

Publisher: John Wiley & Sons

Published: 2014-05-12

Total Pages: 1238

ISBN-13: 111864395X

DOWNLOAD EBOOK

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.

Python Data Persistence
Python Data Persistence

Author: Malhar Lathkar

Publisher: BPB Publications

Published: 2019-09-19

Total Pages: 328

ISBN-13: 9388511751

DOWNLOAD EBOOK

Designed to provide an insight into the SQL and MySQL database concepts using python DESCRIPTION Python is becoming increasingly popular among data scientists. However, analysis and visualization tools need to interact with the data stored in various formats such as relational and NOSQL databases. This book aims to make the reader proficient in interacting with databases such as MySQL, SQLite, MongoDB, and Cassandra. This book assumes that the reader has no prior knowledge of programming. Hence, basic programming concepts, key concepts of OOP, serialization and data persistence have been explained in such a way that it is easy to understand. NOSQL is an emerging technology. Using MongoDB and Cassandra, the two widely used NOSQL databases are explained in detail. The knowhow of handling databases using Python will certainly be helpful for readers pursuing a career in Data Science. KEY FEATURES A practical approach Ample code examples A Quick Start Guide to Python for beginners WHAT WILL YOU LEARN Python basics and programming fundamentals Serialization libraries pickle, CSV, JSON, and XML DB-AP and, SQLAlchemy Python with Excel documents Python with MongoDB and Cassandra WHO THIS BOOK IS FOR Students and professionals who want to become proficient at database tools for a successful career in data science. Table of Contents 1. Ê Ê Getting Started 2. Ê Ê Program Flow Control 3. Ê Ê Structured Python 4. Ê Ê Python Ð OOP 5. Ê Ê File IO 6. Ê Ê Object Serialization 7. Ê Ê RDBMS Concepts 8. Ê Ê Python DB-API 9. Ê Ê Python Ð SQLAlchemy 10. Ê Python and Excel 11. Ê Python Ð PyMongo 12. Ê Python Ð Cassandra

Learn SQL with MySQL
Learn SQL with MySQL

Author: Pajankar Ashwin

Publisher: BPB Publications

Published: 2020-09-03

Total Pages: 178

ISBN-13: 9389898137

DOWNLOAD EBOOK

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/