|
Books > Computing & IT > Computer software packages > Database software
This publication outlines key blockchain use cases that demonstrate
how digital solutions can be applied to facilitate domestic and
cross-border trade in Maldives. The Asian Development Bank is
helping Maldives implement a robust domestic and regional trade
system under the South Asia Subregional Economic Cooperation
program. This integrated trade network facilitates seamless
movement of goods and documents, across organizational and national
boundaries, and will vastly improve the business environment and
overall economic activity. The feasibility study conducted from
April to July 2019 established the use cases of blockchain
technology that may be ideal in Maldives.
An essential how-to guide for experienced DBAs on the most
significant product release since 2005
Microsoft SQL Server 2012 will have major changes throughout the
SQL Server and will impact how DBAs administer the database. With
this book, a team of well-known SQL Server experts introduces the
many new features of the most recent version of SQL Server and
deciphers how these changes will affect the methods that
administrators have been using for years. Loaded with unique tips,
tricks, and workarounds for handling the most difficult SQL Server
admin issues, this how-to guide deciphers topics such as
performance tuning, backup and recovery, scaling and replication,
clustering, and security.Serves as a must-have how-to guide on the
new features of the 2012 release of Microsoft SQL Server Walks you
through ways to manage and monitor SQL Server and automate
administration Guides you through SQL Azure for cloud computing,
data replication, and data warehouse performance improvements
Addresses client-connectivity enhancements, new features that
ensure high availability of mission-critical applications, and
tighter integration with Excel and SharePoint for data analysis and
reporting Highlights major changes to the suite of SQL Server BI
tools, including integration, reporting, and analysis services
Includes real-world case examples and best practices from Microsoft
insiders
If you're a database administrator eager to get started with the
newest version of SQL Server, then this book is essential
reading.
Learning MySQL just got a whole lot easier, thanks to this hands-on
workshop, complete with simple explanations, engaging examples, and
realistic exercises that focus on helping you to build and maintain
databases effectively Key Features Learn how to set up and maintain
a MySQL database Run SQL queries to create, retrieve, and
manipulate data Use MySQL effectively with common business
applications such as Excel and MS Access Book DescriptionDo you
want to learn how to create and maintain databases effectively? Are
you looking for simple answers to basic MySQL questions as well as
straightforward examples that you can use at work? If so, this
workshop is the right choice for you. Designed to build your
confidence through hands-on practice, this book uses a simple
approach that focuses on the practical, so you can get straight
down to business without having to wade through pages and pages of
dull, dry theory. As you work through bite-sized exercises and
activities, you'll learn how to use different MySQL tools to create
a database and manage the data within it. You'll see how to
transfer data between a MySQL database and other sources, and use
real-world datasets to gain valuable experience of manipulating and
gaining insights from data. As you progress, you'll discover how to
protect your database by managing user permissions and performing
logical backups and restores. If you've already tried to teach
yourself SQL, but haven't been able to make the leap from
understanding simple queries to working on live projects with a
real database management system, The MySQL Workshop will get you on
the right track. By the end of this MySQL book, you'll have the
knowledge, skills, and confidence to advance your career and tackle
your own ambitious projects with MySQL. What you will learn
Understand the concepts of relational databases and document stores
Use SQL queries, stored procedures, views, functions, and
transactions Connect to and manipulate data using MS Access, MS
Excel, and Visual Basic for Applications (VBA) Read and write data
in the CSV or JSON format using MySQL Manage data while running
MySQL Shell in JavaScript mode Use X DevAPI to access a NoSQL
interface for MySQL Manage user roles, credentials, and privileges
to keep data secure Perform a logical database backup with
mysqldump and mysqlpump Who this book is forThis book is for anyone
who wants to learn how to use MySQL in a productive, efficient way.
If you're totally new to MySQL, it'll help you get started or if
you've used MySQL before, it'll fill in any gaps, consolidate key
concepts, and offer valuable hands-on practice. Prior knowledge of
simple SQL or basic programming techniques will help you in quickly
grasping the concepts covered, but is not necessary.
Oracle designed its database products to be flexible and
configurable so they would operate on a variety of hardware
platforms, and they succeeded--Oracle software runs on more than
seventy computer platforms, from mainframes to PC networks to
handheld PDAs. The secret to this flexibility lies in the
software's initialization parameters, whose numerous settings can
be configured for top performance in countless environments. On the
downside, however, improper settings can slow a system down; even
grind it to a halt. And with so many parameters--which change from
version to version of Oracle software--it's challenging for Oracle
administrators to keep in mind the characteristics and optimal
settings for each parameter.
The "Oracle Initialization Parameters Pocket Reference" provides
the crucial information you need to make key adjustments to your
Oracle database. This concise guide is a mix of invaluable
performance tips and a quick reference to Oracle's initialization
parameters. The book describes each initialization parameter,
indicates what category it's in--from auditing to multi-threaded
server MTS--and whether it can be modified dynamically via the
ALTER SESSION or ALTER SYSTEM command.
In addition to the details about parameter characteristics and
settings, you'll find performance tips, such as how the various
parameters interact, and what the most advantageous settings are
for different configurations. No other reference focuses
exclusively on these initialization parameters--an absolute must
for anyone working with an Oracle database.
Presented in a handy, easy-to-use format, the "Oracle
Initialization Parameters Pocket Reference" is a welcome
alternative for anyonewho's struggled to memorize the best
configuration settings or gone back and forth to online resources,
trying to figure out what works. O'Reilly's Pocket References put
the information you need close at hand where you need it most. This
guide will keep your Oracle databases operating at peak
performance.
This report reviews the impact of trade facilitation initiatives in
Asia and the Pacific since the coronavirus disease (COVID-19)
pandemic began and discusses how to increase supply chain
resilience. Supply chain disruptions caused by the pandemic have
underscored the need for digital and paperless trade procedures. A
special chapter examines the pandemic's impact on the supply chains
of critical goods such as vaccines, personal protective equipment,
and food, and provides policy suggestions for enhancing supply
chain resilience and trade facilitation. This is the third biennial
progress report on trade facilitation implementation in Asia and
the Pacific jointly prepared by the Asian Development Bank and the
United Nations Economic and Social Commission for Asia and the
Pacific.
Administer, monitor, and replicate your PostgreSQL 14 database for
efficient database management and maintenance Key Features
Troubleshoot and tackle any administration and management problems
in PostgreSQL 14 Find expert techniques for monitoring,
fine-tuning, and securing your database Adopt efficient replication
for high availability with PostgreSQL 14 Book 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 learn
Plan, manage, and maintain PostgreSQL databases in production Work
with the newly introduced features of PostgreSQL 14 Use pgAdmin or
OmniDB to perform database administrator (DBA) tasks Use psql to
write accurate and repeatable scripts Understand how to tackle
real-world data issues with the help of examples Select and
implement robust backup and recovery techniques in PostgreSQL 14
Deploy best practices for planning and designing live databases Who
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.
This report discusses the enhanced framework of the Asia-Pacific
Regional Cooperation and Integration Index (ARCII) that now
includes digital connectivity and environmental cooperation among
other innovations for monitoring progress. The ARCII has been used
for monitoring progress in various dimensions of regional
cooperation and integration (RCI) in Asia and the Pacific since
2017. With these new features of the ARCII, the report explores the
links between regional and global economic integration and sheds
light on the application of the index to RCI analysis and policy
strategies for Asia and Pacific economies.
|
You may like...
A Guide To SQL
Philip Pratt, Hassan Afyouni, …
Paperback
R1,221
R1,092
Discovery Miles 10 920
|