Take a look at our Databases books. Shulph carries a great selection of Databases books, and we are always adding more.
Master MongoDB - The widely used modern database in a step-by-step, practical, and easy-to-understand approach covering all major topics Key Features - In-depth practical demonstration of MongoDB concepts with numerous examples. - Includes graphical illustrations and visual explanations for MongoDB commands and methods. - Covers advanced topics such as MongoDB Compass, MongoDB Security, Backup and Restore, and Replication and Sharding. Description MongoDB Complete Guide book starts with the basics of MongoDB, what exactly is MongoDB, and how to use it practically. You will understand how MongoDB is different from the traditional RDBMS. Topics such as installation and configuration of the MongoDB server, MongoDB commands, MongoDB Shell methods, and data types in MongoDB are covered in detail. You will practice how to perform MongoDB CRUD operations, indexing, MongoDB query selectors, projection in MongoDB and projection operators as well as aggregation in a very detailed and step-by-step manner. You learn how to work with MongoDB Compass and some of the advanced MongoDB topics like managing and administering MongoDB, managing the MongoDB process, monitoring and diagnosing MongoDB, backup and restore, MongoDB security, replication and sharding. What you will learn - Perform write operations, search documents, and define complex queries in MongoDB. - Perform indexing, aggregation, and data replication. - End-to-end MongoDB administration along with authentication and authorization. - Running backups, restoring, and monitoring of MongoDB database enterprise-wide. Who this book is for This book is designed for software developers and server administrators who want to quickly learn MongoDB basics and start applying the knowledge of MongoDB in their business systems. Table of Contents MongoDB Basics   1. Introduction to MongoDB   2. MongoDB Installation and Setup on Windows   3. MongoDB Installation and Setup on Linux (Ubuntu)   4. MongoDB Installation and Setup on macOS   5. Getting started with MongoDB   6. Storage Engines in MongoDB   7. Managing and Administering MongoDB   8. MongoDB Shell Methods   9. Data Types in MongoDB MongoDB Intermediate Level Topics   10. Introduction to MongoDB CRUD Operations   11. MongoDB Intermediate Concepts   12. Introduction to MongoDB Indexes   13. MongoDB Query Selectors   14. Projection in MongoDB and Projection Operators   15. Aggregation in MongoDB   16. MongoDB Data Manipulations Using MongoDB Compass MongoDB Advanced Level Topics   17. Managing and Administering MongoDB (Advanced Level)   18. Replication in MongoDB   19.Sharding in MongoDB About the Authors Manu Sharma (MPhil) has more than 17 years of industry experience in Software Development at the Architect Level, Web Administration, Project Management and Execution, Product Development, and Team Management. He has worked in various multinational companies, small to mid-sized organizations, universities as well as one of the biggest Conglomerates of India. He is also the founder, architect, and developer of two open-source projects. In his free time, he loves to spend his time with his family and daughter. His other interests are singing and Arts. During weekends, you can find him singing and recording music in studios, playing the flute, and sometimes, you can find him with painting brushes in his hand while he paints. LinkedIn Profile: https://www.linkedin.com/in/manu-sharma-link/
Understand, explore, and effectively present data using the powerful data visualization techniques of Python Key Features Use the power of Pandas and Matplotlib to easily solve data mining issues Understand the basics of statistics to build powerful predictive data models Grasp data mining concepts with helpful use-cases and examples Book Description Data mining, or parsing the data to extract useful insights, is a niche skill that can transform your career as a data scientist Python is a flexible programming language that is equipped with a strong suite of libraries and toolkits, and gives you the perfect platform to sift through your data and mine the insights you seek. This Learning Path is designed to familiarize you with the Python libraries and the underlying statistics that you need to get comfortable with data mining. You will learn how to use Pandas, Python's popular library to analyze different kinds of data, and leverage the power of Matplotlib to generate appealing and impressive visualizations for the insights you have derived. You will also explore different machine learning techniques and statistics that enable you to build powerful predictive models. By the end of this Learning Path, you will have the perfect foundation to take your data mining skills to the next level and set yourself on the path to become a sought-after data science professional. This Learning Path includes content from the following Packt products: Statistics for Machine Learning by Pratap Dangeti Matplotlib 2.x By Example by Allen Yu, Claire Chung, Aldrin Yim Pandas Cookbook by Theodore Petrou What you will learn Understand the statistical fundamentals to build data models Split data into independent groups Apply aggregations and transformations to each group Create impressive data visualizations Prepare your data and design models Clean up data to ease data analysis and visualization Create insightful visualizations with Matplotlib and Seaborn Customize the model to suit your own predictive goals Who this book is for If you want to learn how to use the many libraries of Python to extract impactful information from your data and present it as engaging visuals, then this is the ideal Learning Path for you. Some basic knowledge of Python is enough to get started with this Learning Path.
Get up and running with Oracle's premium cloud blockchain services and build distributed blockchain apps with ease Key Features Discover Hyperledger Fabric and its components, features, qualifiers, and architecture Get familiar with the Oracle Blockchain Platform and its unique features Build Hyperledger Fabric-based business networks with Oracle's premium blockchain cloud service Book Description Hyperledger Fabric empowers enterprises to scale out in an unprecedented way, allowing organizations to build and manage blockchain business networks. This quick start guide systematically takes you through distributed ledger technology, blockchain, and Hyperledger Fabric while also helping you understand the significance of Blockchain-as-a-Service (BaaS). The book starts by explaining the blockchain and Hyperledger Fabric architectures. You'll then get to grips with the comprehensive five-step design strategy - explore, engage, experiment, experience, and in?uence. Next, you'll cover permissioned distributed autonomous organizations (pDAOs), along with the equation to quantify a blockchain solution for a given use case. As you progress, you'll learn how to model your blockchain business network by defining its assets, participants, transactions, and permissions with the help of examples. In the concluding chapters, you'll build on your knowledge as you explore Oracle Blockchain Platform (OBP) in depth and learn how to translate network topology on OBP. By the end of this book, you will be well-versed with OBP and have developed the skills required for infrastructure setup, access control, adding chaincode to a business network, and exposing chaincode to a DApp using REST configuration. What you will learn Model your blockchain-based business network by defining its components, transactions, integrations, and infrastructure through use cases Develop, deploy, and test chaincode using shim and REST, and integrate it with client apps using SDK, REST, and events Explore accounting, blockchain, hyperledger fabric, and its components, features, qualifiers, architecture and structure Understand the importance of Blockchain-as-a-Service (BaaS) Experiment Hyperledger Fabric and delve into the underlying technology Set up a consortium network, nodes, channels, and privacy, and learn how to translate network topology on OBP Who this book is for If you are a blockchain developer, blockchain architect or just a cloud developer looking to get hands-on with Oracle Blockchain Cloud Service, then this book is for you. Some familiarity with the basic concepts of blockchain will be helpful to get the most out of this book
Get to grips with building reliable, scalable, and maintainable database solutions for enterprises and production databasesKey FeaturesImplement PostgreSQL 13 features to perform end-to-end modern database managementDesign, manage, and build enterprise database solutions using a unique recipe-based approachSolve common and not-so-common challenges faced while working to achieve optimal database performanceBook DescriptionPostgreSQL has become the most advanced open source database on the market. This book follows a step-by-step approach, guiding you effectively in deploying PostgreSQL in production environments. The book starts with an introduction to PostgreSQL and its architecture. You'll cover common and not-so-common challenges faced while designing and managing the database. Next, the book focuses on backup and recovery strategies to ensure your database is steady and achieves optimal performance. Throughout the book, you'll address key challenges such as maintaining reliability, data integrity, a fault-tolerant environment, a robust feature set, extensibility, consistency, and authentication. Moving ahead, you'll learn how to manage a PostgreSQL cluster and explore replication features for high availability. Later chapters will assist you in building a secure PostgreSQL server, along with covering recipes for encrypting data in motion and data at rest. Finally, you'll not only discover how to tune your database for optimal performance but also understand ways to monitor and manage maintenance activities, before learning how to perform PostgreSQL upgrades during downtime. By the end of this book, you'll be well-versed with the essential PostgreSQL 13 features to build enterprise relational databases.What you will learnUnderstand logical and physical backups in PostgresDemonstrate the different types of replication methods possible with PostgreSQL todaySet up a high availability cluster that provides seamless automatic failover for applicationsSecure a PostgreSQL encryption through authentication, authorization, and auditingAnalyze the live and historic activity of a PostgreSQL serverUnderstand how to monitor critical services in Postgres 13Manage maintenance activities and performance tuning of a PostgreSQL clusterWho this book is forThis PostgreSQL book is for database architects, database developers and administrators, or anyone who wants to become well-versed with PostgreSQL 13 features to plan, manage, and design efficient database solutions. Prior experience with the PostgreSQL database and SQL language is expected.
Administer, monitor, and replicate your PostgreSQL 14 database for efficient database management and maintenanceKey FeaturesTroubleshoot and tackle any administration and management problems in PostgreSQL 14Find expert techniques for monitoring, fine-tuning, and securing your databaseAdopt efficient replication for high availability with PostgreSQL 14Book DescriptionPostgreSQL is a powerful, open-source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 14 allows you to scale up your PostgreSQL infrastructure. With this book, you'll take a step-by-step, recipe-based approach to effective PostgreSQL administration.This book will get you up and running with all the latest features of PostgreSQL 14 while helping you explore the entire database ecosystem. You'll learn how to tackle a variety of problems and pain points you may face as a database administrator such as creating tables, managing views, improving performance, and securing your database. As you make progress, the book will draw attention to important topics such as monitoring roles, validating backups, regular maintenance, and recovery of your PostgreSQL 14 database. This will help you understand roles, ensuring high availability, concurrency, and replication. Along with updated recipes, this book touches upon important areas like using generated columns, TOAST compression, PostgreSQL on the cloud, and much more.By the end of this PostgreSQL book, you'll have gained the knowledge you need to manage your PostgreSQL 14 database efficiently, both in the cloud and on-premise.What you will learnPlan, manage, and maintain PostgreSQL databases in productionWork with the newly introduced features of PostgreSQL 14Use pgAdmin or OmniDB to perform database administrator (DBA) tasksUse psql to write accurate and repeatable scriptsUnderstand how to tackle real-world data issues with the help of examplesSelect and implement robust backup and recovery techniques in PostgreSQL 14Deploy best practices for planning and designing live databasesWho this book is forThis Postgres 14 book is for database administrators, data architects, database developers, and anyone with an interest in planning and running live production databases using PostgreSQL 14. Those looking for hands-on solutions to any problem associated with PostgreSQL 14 administration will also find this book useful. Some experience with handling PostgreSQL databases will help you to make the most out of this book, however, it is a useful resource even if you are just beginning your Postgres journey.
Leverage the features of Azure SQL database and become an expert in data management Key Features Explore ways to create shards and elastic pools to scale Azure SQL databases Automate common management tasks with PowerShell Implement over 40 practical activities and exercises to reinforce your learning Book Description Despite being the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. This book shows you how to administer Azure SQL database to fully benefit from its wide range of features and functionality. Professional Azure SQL Database Administration begins by covering the architecture and explaining the difference between Azure SQL Database and the on-premise SQL Server to help you get comfortable with Azure SQL database. You'll perform common tasks such as migrating, backing up, and restoring a SQL Server database to an Azure database. As you progress, you'll study how you can save costs and manage and scale multiple SQL Databases using elastic pools. You'll also implement a disaster recovery solution using standard and active geo-replication. Whether it is learning different techniques to monitor and tune an Azure SQL database or improving performance using in-memory technology, this book will enable you to make the most out of Azure SQL database features and functionality for data management solutions. By the end of this book, you'll be well versed with key aspects of an Azure SQL database instance, such as migration, backup restorations, performance optimization, high availability, and disaster recovery. What you will learn Understand Azure SQL Database configuration and pricing options Provision a new SQL database or migrate an existing on-premise SQL Server database to Azure SQL Database Back up and restore Azure SQL Database Secure an Azure SQL database Scale an Azure SQL database Monitor and tune an Azure SQL database Implement high availability and disaster recovery with Azure SQL Database Automate common management tasks with PowerShell Develop a scalable cloud solution with Azure SQL Database Manage, maintain, and secure managed instances Who this book is for If you're a database administrator, database developer, or an application developer interested in developing new applications or migrating existing ones with Azure SQL database, this book is for you. Prior experience of working with an on-premise SQL Server or Azure SQL database along with a basic understanding of PowerShell scripts and C# code is necessary to grasp the concepts covered in this book.
Designed to provide an insight into the SQL and MySQL database concepts using python. Key Features A practical approach Ample code examples A Quick Start Guide to Python for beginners 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. 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 Getting Started Program Flow Control Structured Python Python – OOP File IO Object Serialization RDBMS Concepts Python DB-API Python – SQLAlchemy Python and Excel Python – PyMongo Python – Cassandra Appendix A: Alternate Python Implementations Appendix B: Alternate Python Distributions Appendix C: Built-in Functions Appendix D: Built-in Modules Appendix E: Magic Methods Appendix F: SQLite Dot Commands Appendix G: ANSI SQL Statements Appendix H: PyMongo API Methods Appendix I: Cassandra CQL Shell Commands About the Author Malhar Lathkar is an Independent software professional / Programming technologies trainer/E-Learning Subject matter Expert. He is a of Director Institute of Programming Language Studies, having an academic experience of 33 years. His expertise is in Java, Python, C#, IoT, PHP, databases. linkedIn: linkedin.com/in/malharlathkar Blog: indsport.blogspot.com
Learn how to architect, implement, and administer a complex Splunk Enterprise environment and extract valuable insights from business data. Key Features Understand the various components of Splunk and how they work together to provide a powerful Big Data analytics solution. Collect and index data from a wide variety of common machine data sources Design searches, reports, and dashboard visualizations to provide business data insights Book Description Splunk is a leading platform and solution for collecting, searching, and extracting value from ever increasing amounts of big data - and big data is eating the world! This book covers all the crucial Splunk topics and gives you the information and examples to get the immediate job done. You will find enough insights to support further research and use Splunk to suit any business environment or situation. Splunk 7.x Quick Start Guide gives you a thorough understanding of how Splunk works. You will learn about all the critical tasks for architecting, implementing, administering, and utilizing Splunk Enterprise to collect, store, retrieve, format, analyze, and visualize machine data. You will find step-by-step examples based on real-world experience and practical use cases that are applicable to all Splunk environments. There is a careful balance between adequate coverage of all the critical topics with short but relevant deep-dives into the configuration options and steps to carry out the day-to-day tasks that matter. By the end of the book, you will be a confident and proficient Splunk architect and administrator. What you will learn Design and implement a complex Splunk Enterprise solution Configure your Splunk environment to get machine data in and indexed Build searches to get and format data for analysis and visualization Build reports, dashboards, and alerts to deliver critical insights Create knowledge objects to enhance the value of your data Install Splunk apps to provide focused views into key technologies Monitor, troubleshoot, and manage your Splunk environment Who this book is for This book is intended for experienced IT personnel who are just getting started working with Splunk and want to quickly become proficient with its usage. Data analysts who need to leverage Splunk to extract critical business insights from application logs and other machine data sources will also benefit from this book.
Take your first steps to become a fully qualified data analyst by learning how to explore large relational datasets. Key Features Explore a variety of statistical techniques to analyze your data Integrate your SQL pipelines with other analytics technologies Perform advanced analytics such as geospatial and text analysis Book Description Understanding and finding patterns in data has become one of the most important ways to improve business decisions. If you know the basics of SQL, but don't know how to use it to gain business insights from data, this book is for you. SQL for Data Analytics covers everything you need progress from simply knowing basic SQL to telling stories and identifying trends in data. You'll be able to start exploring your data by identifying patterns and unlocking deeper insights. You'll also gain experience working with different types of data in SQL, including time-series, geospatial, and text data. Finally, you'll understand how to become productive with SQL with the help of profiling and automation to gain insights faster. By the end of the book, you'll able to use SQL in everyday business scenarios efficiently and look at data with the critical eye of analytics professional. What you will learn Use SQL to summarize and identify patterns in data Apply special SQL clauses and functions to generate descriptive statistics Use SQL queries and subqueries to prepare data for analysis Perform advanced statistical calculations using the window function Analyze special data types in SQL, including geospatial data and time data Import and export data using a text file and PostgreSQL Debug queries that won't run Optimize queries to improve their performance for faster results Who this book is for If you're a database engineer looking to transition into analytics, or a backend engineer who wants to develop a deeper understanding of production data, you will find this book useful. This book is also ideal for data scientists or business analysts who want to improve their data analytics skills using SQL. Knowledge of basic SQL and database concepts will aid in understanding the concepts covered in this book.
Cut through the noise and get real results with a step-by-step approach to learning SQL Key Features A structured, straightforward introduction to SQL for beginners A SQL tutorial with step-by-step exercises and activities that help build key skills Structured to let you progress at your own pace, on your own terms Use your physical print copy to redeem free access to the online interactive edition Book Description You already know you want to learn SQL, and the best way to learn SQL is to learn by doing. The SQL Workshop focuses on building up your SQL database management skills so that you can easily store and retrieve data or become the in-house expert on complex queries. You'll learn from real examples that lead to real results. Throughout The SQL Workshop, you'll take an engaging step-by-step approach to understanding SQL programming. You won't have to sit through any unnecessary theory. If you're short on time you can jump into a single exercise each day or spend an entire weekend learning how to create functions and stored procedures. It's your choice. Learning on your terms, you'll build up and reinforce key skills in a way that feels rewarding. Every physical print copy of The SQL Workshop unlocks access to the interactive edition. With videos detailing all exercises and activities, you'll always have a guided solution. You can also benchmark yourself against assessments, track progress, and receive content updates. You'll even earn a secure credential that you can share and verify online upon completion. It's a premium learning experience that's included with your printed copy. To redeem, follow the instructions located at the start of your book. Fast-paced and direct, The SQL Workshop is the ideal companion for SQL beginners. You'll build and iterate on your code like a software developer, learning along the way. This process means that you'll find that your new skills stick, embedded as best practice. A solid foundation for the years ahead. What you will learn Learn how to create normalized databases Explore how to insert data into tables efficiently Explore various techniques to retrieve data from multiple tables Build advanced queries using techniques like subqueries and views Learn advanced SQL programming techniques such as functions and triggers Who this book is for Our goal at Packt is to help you be successful, in whatever it is you choose to do. The SQL Workshop is an ideal SQL tutorial for the SQL beginner who is just getting started. Pick up a Workshop today, and let Packt help you develop skills that stick with you for life.