Databases / Data management Books

Book Synopsis1. Snowflake.- 2. The Snowflake Data Cloud.- 3. Getting Started with Snowflake SQL API.- 4. SQL Basics in Snowflake Using Snowflake SQL API.- 5. Advanced SQL Techniques using Snowflake SQL API.- 6. Data Security and Access Control.- 7. Performance Tuning and Optimization.- 8. Data Warehousing Best Practices.- 9. Working With Laravel 10.- 10. Architectural Patterns and Solutions.- 11. Community and Resources.- 12. Conclusion.

Read more less

Book SynopsisHarness the capabilities of Python and gain the expertise need to master data science techniques. This step-by-step book guides you through using Python to achieve tasks related to data cleaning, statistics, and visualization. You'll start by reviewing the foundational aspects of the data science process. This includes an extensive overview of research points and practical applications, such as the insightful analysis of presidential elections. The journey continues by navigating through installation procedures and providing valuable insights into Python, data types, typecasting, and essential libraries like Pandas and NumPy. You'll then delve into the captivating world of data visualization. Concepts such as scatter plots, histograms, and bubble charts come alive through detailed discussions and practical code examples, unraveling the complexities of creating compelling visualizations for enhanced data understanding. Statistical analysis, linear models, and advanced data preprocessing techniques are also discussed before moving on to preparing data for analysis, including renaming variables, variable rearrangement, and conditional statements. Finally, you'll be introduced to regression techniques, demystifying the intricacies of simple and multiple linear regression, as well as logistic regression. What You'll LearnUnderstand installation procedures and valuable insights into Python, data types, typecastingExamine the fundamental statistical analysis required in most data science and analytics reportsClean the most common data set problemsUse linear progression for data predictionWho This Book Is ForData Analysts, data scientists, Python programmers, and software developers new to data science.

Read more less

Book SynopsisYour MySQL instances are probably broken. Many developers face slow-running queries, issues related to database architecture, replication, or database securityand that's only the beginning. This book will deliver answers to your most pressing MySQL database questions related to performance, availability, or security by uncovering what causes databases to break in the first place. At its core, this book provides you with the knowledge necessary for you to break your database instances so you can better optimize it for performance and secure it from data breaches. In other words, you'll discover the sorts of actions, minor and major, that degrade databases so you can fix and ultimately preempt them. MySQL sometimes acts according to its own rules, and this book will help you keep it working on your terms. At the same time, you will learn to optimize your backup and recovery procedures, determine when and which data to index to achieve maximum performance, and choose the best MySQL configurations, among other essential skills. Most MySQL books focus exclusively on optimization, but this book argues that it's just as important to pay attention to the ways databases break. Indeed, after reading this book, you will be able to safely break your database instances to expose and overcome the nuanced issues that affect performance, availability, and security. What You Will LearnKnow the basics of MySQL and the storage engines innoDB and MyISAMSpot the ways you are harming your database's performance, availability and security without even realizing itFix minor bugs and issues that have surprisingly serious impactOptimize schema, data types, queries, indexes, and partitions to head off issuesUnderstand key MySQL security strategiesWho This Book Is ForDatabase administrators, web developers, systems administrators, and security professionals with an intermediary knowledge of database management systems and building applications in MySQL

Read more less

Book SynopsisMaster Oracle Database administration in both on-premises and cloud environments. This new edition covers the tasks you'll need to perform to keep your databases tuned and performing, and includes new, important innovations with AI Vector Search, JSON Duality Views, and Select AI. Since Oracle Database 23ai offers a choice of platforms with on-premises and cloud, the book also includes administrative tasks specific to cloud environments, including the Oracle Autonomous Database running in the Oracle Cloud Infrastructure. New in this edition is help for DBAs who are becoming involved in data management, and a look at the idea of a converged database and what that means in handling various data types and workloads. The book covers some of the machine learning features now in Oracle and shows how the same SQL that you know for database administration also helps you with data management tasks. The information in this book helps you to apply the right solution at the right time, mitigating risk and making robust choices that protect your data and avoid midnight phone calls. Data management is increasingly a DBA function, and DBAs are often called upon for help in getting data loaded into analytics environments such as a data lakehouse or a data mesh. This book addresses this fast-growing new role for database administrators and helps you build on your existing knowledge to make the transition into a new skill set that is in high demand. You'll learn how to look at data optimization from the standpoint of data analysis and machine learning so that you can be seen as a key player in preparing your organization's data for those type of activities. You'll know how to pull back information from a combination of relational tables and JSON structures. You'll become familiar with the tools that Oracle Database provides to make analytics easier and more straightforward. And you'll learn simpler ways to manage time-based tables that eliminate the need for painfully creating triggers to track the history of row changes over time. This book builds your skills as an Oracle Database administrator with the aim of helping you to be seen as a key player in data management as your organization pivots toward cloud computing and a greater use of machine learning and analytics technologies. What You Will LearnConfigure and manage Oracle 23ai databases both on-premises and in the cloudMeet your DBA responsibilities in the Oracle Cloud and with Database Cloud ServicesLeverage converged database capabilities to manage different workloads, structured and unstructured dataPerform administrative tasks for Autonomous Database dedicated environmentsPerform DBA tasks and effectively use data management toolsMigrate from on-premises to the Oracle Cloud InfrastructureTroubleshoot issues with Oracle 23ai databases and quickly solve performance problemsArchitect cloud, on-premises, hybrid, and multi-cloud database environmentsWho This Book Is ForOracle database administrators (DBAs) who want to be current with the new features in Oracle Database 23ai. For any DBA who is tasked with managing Oracle databases in cloud, hybrid cloud, and multi-cloud configurations. Also helpful for data architects who are designing analytic solutions in data lake house and data mesh environments.

Read more less

Book SynopsisChapter 1: PostgreSQL System Architecture.- Chapter 2: Installation and Database Clusters.- Chapter 3: PostgreSQL Physical Structures.- Chapter 4: Management of Database Cluster/Schemas/Users.- Chapter 5: Backup, Recovery, and Point in Time Recovery.- Chapter 6: Routine Maintenance Tasks.- Chapter 7: Monitoring PostgreSQL.- Chapter 8: Migration from Oracle to PostgreSQL.- Chapter 9: Replication from Oracle to PostgreSQL.

Read more less

Book SynopsisChapter 1: Introduction to SAP Fiori.- Chapter 2: SAP Fiori Apps Reference Library.- Chapter 3: SAP Fiori Apps Recommendation Report.- Chapter 4: SAP Fiori Implementation and Deployment.- Chapter 5: SAP Fiori Configuration.- Chapter 6: Introduction to Fiori Apps.- Chapter 7: Introduction to SAP Fiori Catalogs.- Chapter 8: SAP Fiori Launchpad App Manager.- Chapter 9: SAP Fiori Launchpad Content Manager.- Chapter 10: Introduction to SAP Fiori Spaces and Pages.- Chapter 11: Converting SAP Fiori Groups to Pages.- Chapter 12: Configure Custom SAP Fiori Apps.- Chapter 13: SAP Fiori App Support and Troubleshooting.- Chapter 14: SAP Fiori Upgrade Impact Analysis.- Chapter 15: SAP Fiori Adapt UI.- Chapter 16: SAP Fiori Reports.

Read more less