|
Books > Computing & IT > Computer software packages > Database software > General
Use this fast and complete guide to optimize the performance of
MongoDB databases and the applications that depend on them. You
will be able to turbo-charge the performance of your MongoDB
applications to provide a better experience for your users, reduce
your running costs, and avoid application growing pains. MongoDB is
the world's most popular document database and the foundation for
thousands of mission-critical applications. This book helps you get
the best possible performance from MongoDB. MongoDB Performance
Tuning takes a methodical and comprehensive approach to performance
tuning that begins with application and schema design and goes on
to cover optimization of code at all levels of an application. The
book also explains how to configure MongoDB hardware and cluster
configuration for optimal performance. The systematic approach in
the book helps you treat the true causes of performance issues and
get the best return on your tuning investment. Even when you're
under pressure and don't know where to begin, simply follow the
method in this book to set things right and get your MongoDB
performance back on track. What You Will Learn Apply a methodical
approach to MongoDB performance tuning Understand how to design an
efficient MongoDB application Optimize MongoDB document design and
indexing strategies Tune MongoDB queries, aggregation pipelines,
and transactions Optimize MongoDB server resources: CPU, memory,
disk Configure MongoDB Replica sets and Sharded clusters for
optimal performance Who This Book Is For Developers and
administrators of high-performance MongoDB applications who want to
be sure they are getting the best possible performance from their
MongoDB system. For developers who wish to create applications that
are fast, scalable, and cost-effective. For administrators who want
to optimize their MongoDB server and hardware configuration.
Get up to speed with the new features added to Microsoft SQL Server
2019 Analysis Services and create models to support your business
Key Features Explore tips and tricks to design, develop, and
optimize end-to-end data analytics solutions using Microsoft's
technologies Learn tabular modeling and multi-dimensional cube
design development using real-world examples Implement Analysis
Services to help you make productive business decisions Book
DescriptionSQL Server Analysis Services (SSAS) continues to be a
leading enterprise-scale toolset, enabling customers to deliver
data and analytics across large datasets with great performance.
This book will help you understand MS SQL Server 2019's new
features and improvements, especially when it comes to SSAS. First,
you'll cover a quick overview of SQL Server 2019, learn how to
choose the right analytical model to use, and understand their key
differences. You'll then explore how to create a multi-dimensional
model with SSAS and expand on that model with MDX. Next, you'll
create and deploy a tabular model using Microsoft Visual Studio and
Management Studio. You'll learn when and how to use both tabular
and multi-dimensional model types, how to deploy and configure your
servers to support them, and design principles that are relevant to
each model. The book comes packed with tips and tricks to build
measures, optimize your design, and interact with models using
Excel and Power BI. All this will help you visualize data to gain
useful insights and make better decisions. Finally, you'll discover
practices and tools for securing and maintaining your models once
they are deployed. By the end of this MS SQL Server book, you'll be
able to choose the right model and build and deploy it to support
the analytical needs of your business. What you will learn
Determine the best analytical model using SSAS Cover the core
aspects involved in MDX, including writing your first query
Implement calculated tables and calculation groups (new in version
2019) in DAX Create and deploy tabular and multi-dimensional models
on SQL 2019 Connect and create data visualizations using Excel and
Power BI Implement row-level and other data security methods with
tabular and multi-dimensional models Explore essential concepts and
techniques to scale, manage, and optimize your SSAS solutions Who
this book is forThis Microsoft SQL Server book is for BI
professionals and data analysts who are looking for a practical
guide to creating and maintaining tabular and multi-dimensional
models using SQL Server 2019 Analysis Services. A basic working
knowledge of BI solutions such as Power BI and database querying is
required.
Design, administer, and deploy high-volume and fault-tolerant
database applications using MongoDB 4.x Key Features Build a
powerful and scalable MongoDB database using real industry data
Understand the process of designing NoSQL schema with the latest
release of MongoDB 4.x Explore the ins and outs of MongoDB,
including queries, replication, sharding, and vital admin tasks
Book DescriptionWhen it comes to managing a high volume of
unstructured and non-relational datasets, MongoDB is the defacto
database management system (DBMS) for DBAs and data architects.
This updated book includes the latest release and covers every
feature in MongoDB 4.x, while helping you get hands-on with
building a MongoDB database app. You'll get to grips with MongoDB
4.x concepts such as indexes, database design, data modeling,
authentication, and aggregation. As you progress, you'll cover
tasks such as performing routine operations when developing a
dynamic database-driven website. Using examples, you'll learn how
to work with queries and regular database operations. The book will
not only guide you through design and implementation, but also help
you monitor operations to achieve optimal performance and secure
your MongoDB database systems. You'll also be introduced to
advanced techniques such as aggregation, map-reduce, complex
queries, and generating ad hoc financial reports on the fly. Later,
the book shows you how to work with multiple collections as well as
embedded arrays and documents, before finally exploring key topics
such as replication, sharding, and security using practical
examples. By the end of this book, you'll be well-versed with
MongoDB 4.x and be able to perform development and administrative
tasks associated with this NoSQL database. What you will learn
Understand how to configure and install MongoDB 4.x Build a
database-driven website using MongoDB as the backend Perform basic
database operations and handle complex MongoDB queries Develop a
successful MongoDB database design for large corporate customers
with complex requirements Secure MongoDB database systems by
establishing role-based access control with X.509 transport-level
security Optimize reads and writes directed to a replica set or
sharded cluster Perform essential MongoDB administration tasks
Maintain database performance through monitoring Who this book is
forThis book is a MongoDB tutorial for DevOps engineers, database
developers, database administrators, system administrators and
those who are just getting started with NoSQL and looking to build
document-oriented databases and gain real-world experience in
managing databases using MongoDB. Basic knowledge of databases and
Python is required to get started with this DBMS book.
Now available in paperback-- Service Broker is a key Microsoft
product in support of message--based processing between
applications. Pro SQL Server 2008 Service Broker helps you to take
full advantage of this key Microsoft technology, beginning from the
fundamentals, moving through installation and application
development, and ultimately showing you how to develop highly
available and scalable applications based upon the
service--oriented architecture that is quickly gaining ground as
the way forward in application development.* Comprehensive approach
to developing with Service Broker * Strong focus on best practices
and real--world scenarios * Covers the key aspects of distributed
application design What you'll learn * Understand the fundamentals
of message--based processing * Install Service Broker and manage
the environment * Design databases for service--oriented
applications * Develop distributed applications * Build in
scalability and high availability * Apply best practices to avoid
future trouble Who this book is for Pro SQL Server 2008 Service
Broker is written for new and existing users of Service Broker who
wish to develop service--oriented and distributed transactions that
scale well, that are resilient against failure, and that are as
future--proofed as possible from the application of current best
practices in Service Broker development.
Pro SQL Server 2012 Administration is a one-stop source for all the
knowledge you'll need to professionally manage a database under
Microsoft SQL Server 2012. SQL Server administration is a complex
field requiring an unusually broad and well-rounded skill set. A
good database administrator must be part system administrator, part
database design expert, and part SQL tuning optimization guru.
Above all, he or she must be capable of restoring a damaged
database at any time. Database administration requires excellent
people skills for dealing with management and clients, and solid
technical skills for dealing with the hardware and the software.
Pro SQL Server 2012 Administration addresses all aspects of
database administration, regardless of the size of the
implementation. Install SQL Server 2012 and create new database
environments. Develop a sound backup strategy for your database.
Perform recovery as needed, which many consider to be job #1.
Authors Ken Simmons and Sylvester Carstarphen also help you
automate your work through the use of policy-based
management.Performance optimization gets good coverage, so that you
can render assistance when developers need help with problem
queries. Rare among database and other technical books is solid
guidance on the people side of the equation. Success as a database
administrator comes from working well with others, becoming
involved in the community, and building the right combination of
technical knowledge and people skills to solve problems and get
things done professionally and amicably. Simmons and Carstarphen
pay special attention to these aspects of the job in this new
edition of their comprehensive book on SQL Server administration.*
Helps you manage a SQL Server 2012 database at professional level *
Covers the gamut of database administration skills * Provides
guidance on performance optimization What you'll learn * Install
SQL Server 2012 and create new databases * Implement backup &
recovery strategies to protect your database, and your job *
Diagnose and resolve query performance problems * Apply
policy-based management for consistency across all databases in an
organization * Turn every interaction with a client, manager or
executive into a stepping-stone towards career success Who this
book is for Pro SQL Server 2012 Administration is aimed at junior
and seasoned database administrators who are looking to develop
their knowledge and skill set in Microsoft SQL Server 2012. Readers
should already have some exposure to databases in general, or to
SQL Server in specific. Table of Contents * What's New?*
Pre-Install Considerations * Choosing a High-Availability Solution
* Installing and Upgrading * Post Installation * Multi-Server
Administration * Security * Administering Database Objects *
Indexing for Performance * Managing Backups * Restore and Recovery
Strategies * Automating Routine Maintenance * Monitoring Your
Server * Auditing * Extended Events Interface * Managing Query
Performance * Secrets to Excelling as a Professional DBA * What's
Next?
Learn to exploit vulnerable database applications using SQL
injection tools and techniques, while understanding how to
effectively prevent attacks Key Features Understand SQL injection
and its effects on websites and other systems Get hands-on with SQL
injection using both manual and automated tools Explore practical
tips for various attack and defense strategies relating to SQL
injection Book DescriptionSQL injection (SQLi) is probably the most
infamous attack that can be unleashed against applications on the
internet. SQL Injection Strategies is an end-to-end guide for
beginners looking to learn how to perform SQL injection and test
the security of web applications, websites, or databases, using
both manual and automated techniques. The book serves as both a
theoretical and practical guide to take you through the important
aspects of SQL injection, both from an attack and a defense
perspective. You'll start with a thorough introduction to SQL
injection and its impact on websites and systems. Later, the book
features steps to configure a virtual environment, so you can try
SQL injection techniques safely on your own computer. These tests
can be performed not only on web applications but also on web
services and mobile applications that can be used for managing IoT
environments. Tools such as sqlmap and others are then covered,
helping you understand how to use them effectively to perform SQL
injection attacks. By the end of this book, you will be well-versed
with SQL injection, from both the attack and defense perspective.
What you will learn Focus on how to defend against SQL injection
attacks Understand web application security Get up and running with
a variety of SQL injection concepts Become well-versed with
different SQL injection scenarios Discover SQL injection manual
attack techniques Delve into SQL injection automated techniques Who
this book is forThis book is ideal for penetration testers, ethical
hackers, or anyone who wants to learn about SQL injection and the
various attack and defense strategies against this web security
vulnerability. No prior knowledge of SQL injection is needed to get
started with this book.
Explore expert techniques such as advanced indexing and high
availability to build scalable, reliable, and fault-tolerant
database applications using PostgreSQL 13 Key Features Master
advanced PostgreSQL 13 concepts with the help of real-world
datasets and examples Leverage PostgreSQL's indexing features to
fine-tune the performance of your queries Extend PostgreSQL's
functionalities to suit your organization's needs with minimal
effort Book DescriptionThanks to its reliability, robustness, and
high performance, PostgreSQL has become one of the most advanced
open source databases on the market. This updated fourth edition
will help you understand PostgreSQL administration and how to build
dynamic database solutions for enterprise apps with the latest
release of PostgreSQL, including designing both physical and
technical aspects of the system architecture with ease. Starting
with an introduction to the new features in PostgreSQL 13, this
book will guide you in building efficient and fault-tolerant
PostgreSQL apps. You'll explore advanced PostgreSQL features, such
as logical replication, database clusters, performance tuning,
advanced indexing, monitoring, and user management, to manage and
maintain your database. You'll then work with the PostgreSQL
optimizer, configure PostgreSQL for high speed, and move from
Oracle to PostgreSQL. The book also covers transactions, locking,
and indexes, and shows you how to improve performance with query
optimization. You'll also focus on how to manage network security
and work with backups and replication while exploring useful
PostgreSQL extensions that optimize the performance of large
databases. By the end of this PostgreSQL book, you'll be able to
get the most out of your database by executing advanced
administrative tasks. What you will learn Get well versed with
advanced SQL functions in PostgreSQL 13 Get to grips with
administrative tasks such as log file management and monitoring
Work with stored procedures and manage backup and recovery Employ
replication and failover techniques to reduce data loss Perform
database migration from Oracle to PostgreSQL with ease Replicate
PostgreSQL database systems to create backups and scale your
database Manage and improve server security to protect your data
Troubleshoot your PostgreSQL instance to find solutions to common
and not-so-common problems Who this book is forThis database
administration book is for PostgreSQL developers and database
administrators and professionals who want to implement advanced
functionalities and master complex administrative tasks with
PostgreSQL 13. Prior experience in PostgreSQL and familiarity with
the basics of database administration will assist with
understanding key concepts covered in the book.
Here is the expert-level, insider guidance you need on using Azure
SQL Database as your back-end data store. This book highlights best
practices in everything ranging from full-stack projects to mobile
applications to critical, back-end APIs. The book provides
instruction on accessing your data from any language and platform.
And you learn how to push processing-intensive work into the
database engine to be near the data and avoid undue networking
traffic. Azure SQL is explained from a developer's point of view,
helping you master its feature set and create applications that
perform well and delight users. Core to the book is showing you how
Azure SQL Database provides relational and post-relational support
so that any workload can be managed with easy accessibility from
any platform and any language. You will learn about features
ranging from lock-free tables to columnstore indexes, and about
support for data formats ranging from JSON and key-values to the
nodes and edges in the graph database paradigm. Reading this book
prepares you to deal with almost all data management challenges,
allowing you to create lean and specialized solutions having the
elasticity and scalability that are needed in the modern world.
What You Will Learn Master Azure SQL Database in your development
projects from design to the CI/CD pipeline Access your data from
any programming language and platform Combine key-value, JSON, and
relational data in the same database Push data-intensive compute
work into the database for improved efficiency Delight your
customers by detecting and improving poorly performing queries
Enhance performance through features such as columnstore indexes
and lock-free tables Build confidence in your mastery of Azure SQL
Database's feature set Who This Book Is For Developers of
applications and APIs that benefit from cloud database support,
developers who wish to master their tools (including Azure SQL
Database, and those who want their applications to be known for
speedy performance and the elegance of their code
Use this guide to one of SQL Server 2019's most impactful
features-Big Data Clusters. You will learn about data
virtualization and data lakes for this complete artificial
intelligence (AI) and machine learning (ML) platform within the SQL
Server database engine. You will know how to use Big Data Clusters
to combine large volumes of streaming data for analysis along with
data stored in a traditional database. For example, you can stream
large volumes of data from Apache Spark in real time while
executing Transact-SQL queries to bring in relevant additional data
from your corporate, SQL Server database. Filled with clear
examples and use cases, this book provides everything necessary to
get started working with Big Data Clusters in SQL Server 2019. You
will learn about the architectural foundations that are made up
from Kubernetes, Spark, HDFS, and SQL Server on Linux. You then are
shown how to configure and deploy Big Data Clusters in on-premises
environments or in the cloud. Next, you are taught about querying.
You will learn to write queries in Transact-SQL-taking advantage of
skills you have honed for years-and with those queries you will be
able to examine and analyze data from a wide variety of sources
such as Apache Spark. Through the theoretical foundation provided
in this book and easy-to-follow example scripts and notebooks, you
will be ready to use and unveil the full potential of SQL Server
2019: combining different types of data spread across widely
disparate sources into a single view that is useful for business
intelligence and machine learning analysis. What You Will Learn
Install, manage, and troubleshoot Big Data Clusters in cloud or
on-premise environments Analyze large volumes of data directly from
SQL Server and/or Apache Spark Manage data stored in HDFS from SQL
Server as if it were relational data Implement advanced analytics
solutions through machine learning and AI Expose different data
sources as a single logical source using data virtualization Who
This Book Is For Data engineers, data scientists, data architects,
and database administrators who want to employ data virtualization
and big data analytics in their environments
Use Microsoft SQL Server 2019 to implement, administer, and secure
a robust database solution that is disaster-proof and highly
available Key Features Explore new features of SQL Server 2019 to
set up, administer, and maintain your database solution
successfully Develop a dynamic SQL Server environment and
streamline big data pipelines Discover best practices for fixing
performance issues, database access management, replication, and
security Book DescriptionSQL Server is one of the most popular
relational database management systems developed by Microsoft. This
second edition of the SQL Server Administrator's Guide will not
only teach you how to administer an enterprise database, but also
help you become proficient at managing and keeping the database
available, secure, and stable. You'll start by learning how to set
up your SQL Server and configure new and existing environments for
optimal use. The book then takes you through designing aspects and
delves into performance tuning by showing you how to use indexes
effectively. You'll understand certain choices that need to be made
about backups, implement security policy, and discover how to keep
your environment healthy. Tools available for monitoring and
managing a SQL Server database, including automating health
reviews, performance checks, and much more, will also be discussed
in detail. As you advance, the book covers essential topics such as
migration, upgrading, and consolidation, along with the techniques
that will help you when things go wrong. Once you've got to grips
with integration with Azure and streamlining big data pipelines,
you'll learn best practices from industry experts for maintaining a
highly reliable database solution. Whether you are an administrator
or are looking to get started with database administration, this
SQL Server book will help you develop the skills you need to
successfully create, design, and deploy database solutions. What
you will learn Discover SQL Server 2019's new features and how to
implement them Fix performance issues by optimizing queries and
making use of indexes Design and use an optimal database management
strategy Combine SQL Server 2019 with Azure and manage your
solution using various automation techniques Implement efficient
backup and recovery techniques in line with security policies Get
to grips with migrating, upgrading, and consolidating with SQL
Server Set up an AlwaysOn-enabled stable and fast SQL Server 2019
environment Understand how to work with Big Data on SQL Server
environments Who this book is forThis book is for database
administrators, database developers, and anyone who wants to
administer large and multiple databases single-handedly using
Microsoft's SQL Server 2019. Basic awareness of database concepts
and experience with previous SQL Server versions is required.
Learn everything you need to know to build efficient SQL queries
using this easy-to-follow beginner's guide Key Features Explore all
SQL statements in depth using a variety of examples Get to grips
with database querying, data aggregate, manipulation, and much more
Understand how to explore and process data of varying complexity to
tell a story Book DescriptionSQL is a powerful querying language
that's used to store, manipulate, and retrieve data, and it is one
of the most popular languages used by developers to query and
analyze data efficiently. If you're looking for a comprehensive
introduction to SQL, Learn SQL Database Programming will help you
to get up to speed with using SQL to streamline your work in no
time. Starting with an overview of relational database management
systems, this book will show you how to set up and use MySQL
Workbench and design a database using practical examples. You'll
also discover how to query and manipulate data with SQL programming
using MySQL Workbench. As you advance, you'll create a database,
query single and multiple tables, and modify data using SQL
querying. This SQL book covers advanced SQL techniques, including
aggregate functions, flow control statements, error handling, and
subqueries, and helps you process your data to present your
findings. Finally, you'll implement best practices for writing SQL
and designing indexes and tables. By the end of this SQL
programming book, you'll have gained the confidence to use SQL
queries to retrieve and manipulate data. What you will learn
Install, configure, and use MySQL Workbench to restore a database
Explore different data types such as string, numeric, and date and
time Query a single table using the basic SQL SELECT statement and
the FROM, WHERE, and ORDER BY clauses Query multiple tables by
understanding various types of table relationships Modify data in
tables using the INSERT, UPDATE, and DELETE statements Use
aggregate functions to group and summarize data Detect bad data,
duplicates, and irrelevant values while processing data Who this
book is forThis book is for business analysts, SQL developers,
database administrators, and students learning SQL. If you want to
learn how to query and manipulate SQL data for database
administration tasks or simply extract and organize relevant data
for analysis, you'll find this book useful. No prior SQL experience
is required.
Dive into a secure future Professionals look to Ethereum as a
blockchain-based platform to develop safe applications and conduct
secure transactions. It takes a knowledgeable guiding hand to
understand how Ethereum works and what it does -- and Ethereum For
Dummies provides that guidance. Written by one of the leading
voices in the blockchain community and best selling author of
Blockchain For Dummies, this book demystifies the workings of
Ethereum and shows how it can enhance security, transactions, and
investments. As an emerging application of blockchain technology,
Ethereum attracts a wide swath of professionals ranging from
financial pros who see it as a way to enhance their business,
security analysts who want to conduct secure transactions,
programmers who build apps that employ the Ethereum blockchain, or
investors interested in cashing in on the rise of cryptocurrency.
Ethereum For Dummies offers a starting point to all members of this
audience as it provides easy-to-understand explanation of the tools
and techniques of using Ethereum. Understand the fundamentals of
Ethereum Build smart contracts Create decentralized applications
Examine public and private chains If you need to get a grip on one
of the biggest applications of blockchain technology, this book
makes it easier.
Prepare for Microsoft Exam 70-765-and help demonstrate your
real-world mastery of provisioning SQL Server databases both on
premise and in SQL Azure. Designed for experienced IT professionals
ready to advance their status, Exam Ref focuses on the critical
thinking and decision-making acumen needed for success at the MCSA
level. Focus on the expertise measured by these objectives: *
Implement SQL in Azure * Manage databases and instances * Manage
storage This Microsoft Exam Ref: * Organizes its coverage by exam
objectives * Features strategic, what-if scenarios to challenge you
* Assumes you have working knowledge of SQL Server administration
and maintenance, as well as Azure skills Provisioning SQL Databases
About the Exam Exam 70-765 focuses on skills and knowledge for
provisioning, upgrading, and configuring SQL Server; managing
databases and files; and provisioning, migrating, and managing
databases in the Microsoft Azure cloud. About Microsoft
Certification Passing this exam as well as Exam 70-764:
Administering a SQL Database Infrastructure earns you MCSA: SQL
2016 Database Administration certification, qualifying you for a
position as a database administrator or infrastructure specialist.
See full details at: microsoft.com/learning
|
You may like...
A Guide To SQL
Philip Pratt, Hassan Afyouni, …
Paperback
R1,246
R1,113
Discovery Miles 11 130
|