Books > Computing & IT > Computer software packages > Database software
|
Buy Now
Pro SQL Server Relational Database Design and Implementation - Best Practices for Scalability and Performance (Paperback, 6th ed.)
Loot Price: R1,759
Discovery Miles 17 590
You Save: R444
(20%)
|
|
Pro SQL Server Relational Database Design and Implementation - Best Practices for Scalability and Performance (Paperback, 6th ed.)
Expected to ship within 12 - 17 working days
|
Learn effective and scalable database design techniques in SQL
Server 2019 and other recent SQL Server versions. This book is
revised to cover additions to SQL Server that include SQL graph
enhancements, in-memory online transaction processing, temporal
data storage, row-level security, and other design-related
features. This book will help you design OLTP databases that are
high-quality, protect the integrity of your data, and perform fast
on-premises, in the cloud, or in hybrid configurations. Designing
an effective and scalable database using SQL Server is a task
requiring skills that have been around for well over 30 years,
using technology that is constantly changing. This book covers
everything from design logic that business users will understand to
the physical implementation of design in a SQL Server database.
Grounded in best practices and a solid understanding of the
underlying theory, author Louis Davidson shows you how to "get it
right" in SQL Server database design and lay a solid groundwork for
the future use of valuable business data. What You Will Learn
Develop conceptual models of client data using interviews and
client documentation Implement designs that work on premises, in
the cloud, or in a hybrid approach Recognize and apply common
database design patterns Normalize data models to enhance integrity
and scalability of your databases for the long-term use of valuable
data Translate conceptual models into high-performing SQL Server
databases Secure and protect data integrity as part of meeting
regulatory requirements Create effective indexing to speed query
performance Understand the concepts of concurrency Who This Book Is
For Programmers and database administrators of all types who want
to use SQL Server to store transactional data. The book is
especially useful to those wanting to learn the latest database
design features in SQL Server 2019 (features that include graph
objects, in-memory OLTP, temporal data support, and more). Chapters
on fundamental concepts, the language of database modeling, SQL
implementation, and the normalization process lay a solid
groundwork for readers who are just entering the field of database
design. More advanced chapters serve the seasoned veteran by
tackling the latest in physical implementation features that SQL
Server has to offer. The book has been carefully revised to cover
all the design-related features that are new in SQL Server 2019.
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!
|
|
Email address subscribed successfully.
A activation email has been sent to you.
Please click the link in that email to activate your subscription.