{"product_id":"wiley-pathways-introduction-to-database-management-paperback-softback-9780470101865","title":"Wiley Pathways Introduction to Database Management (Paperback \/ softback) 9780470101865","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eWiley Pathways Introduction to Database Management\u003c\/font\u003e\u003cbr\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003c\/p\u003e\n\u003cp\u003e\u003cfont size=\"4\"\u003eMark L. Gillenson (Author), Paulraj Ponniah (Author), Alex Kriegel (Author), Boris M. Trukhnov (Author), Allen G. Taylor (Author), Gavin Powell (Author), Frank Miller (With)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9780470101865, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 20 April 2007\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e508 pages\u003cbr\u003e23.1 x 18.5 x 2.8 cm, 0.839 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003eYou can get there\u003cbr\u003e \u003cbr\u003e Where do you want to go? You might already be working in the information technology field and may be looking to expand your skills. You might be setting out on a new career path. Or, you might want to learn more about exciting opportunities in database management.\u003cbr\u003e \u003cbr\u003e Wherever you want to go, Introduction to Databases will help you get there. Easy-to-read, practical, and up-to-date, this text not only helps you learn fundamental database design and management concepts, it also helps you master the core competencies and skills you need to succeed in the classroom and in the real world. The book's brief, modular format and variety of built-in learning resources enable you to learn at your own pace and focus your studies.\u003cbr\u003e \u003cbr\u003e With this book, you will be able to:\u003cbr\u003e * Appreciate the key role of data in daily business operations and strategic decisions.\u003cbr\u003e * Understand databases, database management systems, and SQL, the software on which they are based, from the ground up.\u003cbr\u003e * Know how to gather and organize critical business information, design a database based on this information, and retrieve and modify that information in a useful manner.\u003cbr\u003e * Use accepted data modeling procedures to design a relational database.\u003cbr\u003e * Master the concept of data normalization and the use of standard normalization rules.\u003cbr\u003e * Explore critical real-world issues including application integration and securing data against disclosure and loss.\u003cbr\u003e \u003cbr\u003e Wiley Pathways helps you achieve your goals\u003cbr\u003e \u003cbr\u003e Not every student is on the same path, but every student wants to succeed. The Information Technology series in the new Wiley Pathways imprint helps you achieve your goals. The books in this series--Introduction to Databases, Introduction to Programming Using Visual Basic, Introduction to Operating Systems, Networking Basics, Windows Network Administration, Network Security Fundamentals, and PC Hardware Essentials--offer a coordinated information technology curriculum. Learn more at www.wiley.com\/go\/pathways\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e\u003cp\u003e\u003cb\u003e1 Introducing to Data and Data Management 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction 2\u003c\/p\u003e \u003cp\u003e1.1 Understanding the Role of Data and Databases 2\u003c\/p\u003e \u003cp\u003e1.1.1 A Practical Example 3\u003c\/p\u003e \u003cp\u003e1.1.2 Understanding Data Management5\u003c\/p\u003e \u003cp\u003e1.1.3 The Need for Data Management 5\u003c\/p\u003e \u003cp\u003eSelf-Check 7\u003c\/p\u003e \u003cp\u003e1.2 Understanding Data Sources7\u003c\/p\u003e \u003cp\u003e1.2.1 Picking a Starting Point 7\u003c\/p\u003e \u003cp\u003e1.2.2 Identifying Primary Processes 8\u003c\/p\u003e \u003cp\u003e1.2.3 Specific Data Sources 9\u003c\/p\u003e \u003cp\u003eSelf-Check 12\u003c\/p\u003e \u003cp\u003e1.3 Potential Data Concerns 12\u003c\/p\u003e \u003cp\u003e1.3.1 Managing Data Accuracy 13\u003c\/p\u003e \u003cp\u003e1.3.2 Managing Data Security 13\u003c\/p\u003e \u003cp\u003e1.3.3 Managing Data Organization 16\u003c\/p\u003e \u003cp\u003e1.3.4 Managing Data Access 16\u003c\/p\u003e \u003cp\u003eSelf-Check 18\u003c\/p\u003e \u003cp\u003eSummary 19\u003c\/p\u003e \u003cp\u003eKey Terms 19\u003c\/p\u003e \u003cp\u003eAssess Your Understanding 20\u003c\/p\u003e \u003cp\u003eSummary Questions 20\u003c\/p\u003e \u003cp\u003eApplying This Chapter 22\u003c\/p\u003e \u003cp\u003eYou Try It 23\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 Introducing Databases and Database Management Systems 24\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction 25\u003c\/p\u003e \u003cp\u003e2.1Introduction to Key Database Concepts 25\u003c\/p\u003e \u003cp\u003e2.1.1Database Approach to Data 25\u003c\/p\u003e \u003cp\u003e2.1.2Understanding Basic Concepts 26\u003c\/p\u003e \u003cp\u003e2.1.3Database Use 29\u003c\/p\u003e \u003cp\u003eSelf-Check31\u003c\/p\u003e \u003cp\u003e2.2 Understanding Basic Database Models 31\u003c\/p\u003e \u003cp\u003e2.2.1 The Hierarchical Database Model 32\u003c\/p\u003e \u003cp\u003e2.2.2 The Network Database Model 33\u003c\/p\u003e \u003cp\u003e2.2.3 The Relational Database Model 34\u003c\/p\u003e \u003cp\u003e2.2.4 The Object-Oriented Database Model 35\u003c\/p\u003e \u003cp\u003e2.2.5 The Object-Relational Database Model 36\u003c\/p\u003e \u003cp\u003eSelf-Check 37\u003c\/p\u003e \u003cp\u003e2.3 Database Components 38\u003c\/p\u003e \u003cp\u003e2.3.1 Hardware Components 40\u003c\/p\u003e \u003cp\u003e2.3.2 Software Requirements 43\u003c\/p\u003e \u003cp\u003e2.3.3 DBMS Components45\u003c\/p\u003e \u003cp\u003e2.3.4 Understanding People and Procedures 50\u003c\/p\u003e \u003cp\u003eSelf-Check 53\u003c\/p\u003e \u003cp\u003eSummary 54\u003c\/p\u003e \u003cp\u003eKey Terms 54\u003c\/p\u003e \u003cp\u003eAssess Your Understanding 55\u003c\/p\u003e \u003cp\u003eSummary Questions 55\u003c\/p\u003e \u003cp\u003eApplying This Chapter 57\u003c\/p\u003e \u003cp\u003eYou Try It 59\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Data Modeling 60\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction 61\u003c\/p\u003e \u003cp\u003e3.1 Understanding Database Design 61\u003c\/p\u003e \u003cp\u003e3.1.1 Understanding the Design Process 61\u003c\/p\u003e \u003cp\u003e3.1.2 Determining the Database Type 63\u003c\/p\u003e \u003cp\u003e3.1.3 Understanding Modeling Goals 66\u003c\/p\u003e \u003cp\u003e3.1.4 Understanding Business Rules 67\u003c\/p\u003e \u003cp\u003eSelf-Check 70\u003c\/p\u003e \u003cp\u003e3.2 Understanding Relational Database Models 70\u003c\/p\u003e \u003cp\u003e3.2.1 Entity-Relationship (E-R) Modeling Concepts 71\u003c\/p\u003e \u003cp\u003e3.2.2 Introducing Basic Database Objects 75\u003c\/p\u003e \u003cp\u003eSelf-Check 79\u003c\/p\u003e \u003cp\u003e3.3 Understanding Relationships 79\u003c\/p\u003e \u003cp\u003e3.3.1 Binary Relationships 80\u003c\/p\u003e \u003cp\u003e3.3.2 Unary Relationships 84\u003c\/p\u003e \u003cp\u003e3.3.3 Ternary Relationships 86\u003c\/p\u003e \u003cp\u003e3.3.4 Breaking Down Many-to-Many Relationships 87\u003c\/p\u003e \u003cp\u003eSelf-Check91\u003c\/p\u003e \u003cp\u003e3.4 Comparing Data Models 91\u003c\/p\u003e \u003cp\u003e3.4.1 Choosing a Modeling Tool 92\u003c\/p\u003e \u003cp\u003e3.4.2 The General Hardware Company 93\u003c\/p\u003e \u003cp\u003e3.4.3 Good Reading Bookstores 95\u003c\/p\u003e \u003cp\u003eSelf-Check 97\u003c\/p\u003e \u003cp\u003eSummary 97\u003c\/p\u003e \u003cp\u003eKey Terms 97\u003c\/p\u003e \u003cp\u003eAssess Your Understanding 99\u003c\/p\u003e \u003cp\u003eSummary Questions 99\u003c\/p\u003e \u003cp\u003eApplying This Chapter 101\u003c\/p\u003e \u003cp\u003eYou Try It103\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Designing a Database 104\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction 105\u003c\/p\u003e \u003cp\u003e4.1Designing Relational Tables 105\u003c\/p\u003e \u003cp\u003e4.1.1Converting a Single Entity 105\u003c\/p\u003e \u003cp\u003e4.1.2Converting Binary Relationships 106\u003c\/p\u003e \u003cp\u003e4.1.3Converting Unary Relationships 113\u003c\/p\u003e \u003cp\u003eSelf-Check 117\u003c\/p\u003e \u003cp\u003e4.2 Comparing Relational Designs 117\u003c\/p\u003e \u003cp\u003e4.2.1 Designing General Hardware 117\u003c\/p\u003e \u003cp\u003e4.2.2 Designing Good Reading Bookstores 120\u003c\/p\u003e \u003cp\u003eSelf-Check 123\u003c\/p\u003e \u003cp\u003e4.3 Normalizing Data 123\u003c\/p\u003e \u003cp\u003e4.3.1 Using Normalization Techniques 123\u003c\/p\u003e \u003cp\u003e4.3.2 Normalizing Data by the Numbers 125\u003c\/p\u003e \u003cp\u003e4.3.3 Shortening the Process 134\u003c\/p\u003e \u003cp\u003e4.3.4 Denormalizing Data 134\u003c\/p\u003e \u003cp\u003eSelf-Check 136\u003c\/p\u003e \u003cp\u003eSummary 136\u003c\/p\u003e \u003cp\u003eKey Terms 137\u003c\/p\u003e \u003cp\u003eAssess Your Understanding 138\u003c\/p\u003e \u003cp\u003eSummary Questions 138\u003c\/p\u003e \u003cp\u003eApplying This Chapter 140\u003c\/p\u003e \u003cp\u003eYou Try It 142\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Implementing a Database 146\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction 147\u003c\/p\u003e \u003cp\u003e5.1 Physical Design and Implementation 147\u003c\/p\u003e \u003cp\u003e5.1.1 Understanding Design Requirements 147\u003c\/p\u003e \u003cp\u003e5.1.2 Business Environment Requirements 149\u003c\/p\u003e \u003cp\u003e5.1.3 Data Characteristics 149\u003c\/p\u003e \u003cp\u003e5.1.4 Application Characteristics 151\u003c\/p\u003e \u003cp\u003e5.1.5 Operational Requirements 152\u003c\/p\u003e \u003cp\u003e5.1.6 The Hardware and Software Environment 152\u003c\/p\u003e \u003cp\u003e5.1.7 Evaluating Implementation Options 154\u003c\/p\u003e \u003cp\u003eSelf-Check 158\u003c\/p\u003e \u003cp\u003e5.2 Adjusting Your Design to the Real World 158\u003c\/p\u003e \u003cp\u003e5.2.1 Ensuring Data Integrity 159\u003c\/p\u003e \u003cp\u003e5.2.2 Adjusting Factors Related to Performance 162\u003c\/p\u003e \u003cp\u003eSelf-Check 171\u003c\/p\u003e \u003cp\u003e5.3 Implementing Database Objects 171\u003c\/p\u003e \u003cp\u003e5.3.1 Implementing Your Final Table Design 171\u003c\/p\u003e \u003cp\u003e5.3.2 Implementing Indexes 173\u003c\/p\u003e \u003cp\u003e5.3.3 Implementing Views 175\u003c\/p\u003e \u003cp\u003eSelf-Check 177\u003c\/p\u003e \u003cp\u003eSummary 177\u003c\/p\u003e \u003cp\u003eKey Terms 177\u003c\/p\u003e \u003cp\u003eAssess Your Understanding 178\u003c\/p\u003e \u003cp\u003eSummary Questions 178\u003c\/p\u003e \u003cp\u003eApplying This Chapter 180\u003c\/p\u003e \u003cp\u003eYou Try It182\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 Understanding the SQL Language 184\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction 185\u003c\/p\u003e \u003cp\u003e6.1 Introducing the SQL Language 185\u003c\/p\u003e \u003cp\u003e6.1.1 Understanding SQL Features 185\u003c\/p\u003e \u003cp\u003e6.1.2 Using SQL 186\u003c\/p\u003e \u003cp\u003e6.1.3 Understanding Command Basics 190\u003c\/p\u003e \u003cp\u003eSelf-Check 192\u003c\/p\u003e \u003cp\u003e6.2 Understanding SELECT Fundamentals 192\u003c\/p\u003e \u003cp\u003e6.2.1 Working with SELECT 192\u003c\/p\u003e \u003cp\u003e6.2.2 Using Simple Data Retrieval 193\u003c\/p\u003e \u003cp\u003e6.2.3 Retrieving Other Values 194\u003c\/p\u003e \u003cp\u003eSelf-Check 196\u003c\/p\u003e \u003cp\u003e6.3 Understanding Operators and Functions 196\u003c\/p\u003e \u003cp\u003e6.3.1 Arithmetic Operators 196\u003c\/p\u003e \u003cp\u003e6.3.2 Comparison and Logical Operators 197\u003c\/p\u003e \u003cp\u003e6.3.3 Standard SQL Functions 201\u003c\/p\u003e \u003cp\u003e6.3.4 Function Variations 202\u003c\/p\u003e \u003cp\u003eSelf-Check 208\u003c\/p\u003e \u003cp\u003e6.4 Understanding DML Commands 208\u003c\/p\u003e \u003cp\u003e6.4.1 Using INSERT 208\u003c\/p\u003e \u003cp\u003e6.4.2 Using UPDATE 209\u003c\/p\u003e \u003cp\u003e6.4.3 Using DELETE 211\u003c\/p\u003e \u003cp\u003eSelf-Check213\u003c\/p\u003e \u003cp\u003e6.5 Understanding DDL Commands 213\u003c\/p\u003e \u003cp\u003e6.5.1 Using CREATE 214\u003c\/p\u003e \u003cp\u003e6.5.2 Using ALTER 216\u003c\/p\u003e \u003cp\u003e6.5.3 Using DROP 216\u003c\/p\u003e \u003cp\u003eSelf-Check 216\u003c\/p\u003e \u003cp\u003eSummary 217\u003c\/p\u003e \u003cp\u003eKey Terms 217\u003c\/p\u003e \u003cp\u003eAssess Your Understanding 218\u003c\/p\u003e \u003cp\u003eSummary Questions 218\u003c\/p\u003e \u003cp\u003eApplying This Chapter 220\u003c\/p\u003e \u003cp\u003eYou Try It222\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 Data Access and Manipulation 223\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction224\u003c\/p\u003e \u003cp\u003e7.1 Using SELECT Statement Advanced Syntax 224\u003c\/p\u003e \u003cp\u003e7.1.1 Understanding SELECT Statement Syntax 224\u003c\/p\u003e \u003cp\u003e7.1.2 Filtering Your Result 226\u003c\/p\u003e \u003cp\u003e7.1.3 Managing Your Result Set 229\u003c\/p\u003e \u003cp\u003e7.1.4 Sorting, Organizing, and Grouping Data 231\u003c\/p\u003e \u003cp\u003e7.1.5 Understanding Operator Precedence 237\u003c\/p\u003e \u003cp\u003e7.1.6 Combining Statement Results 239\u003c\/p\u003e \u003cp\u003e7.1.7 Using SELECT with Other Commands 240\u003c\/p\u003e \u003cp\u003eSelf-Check 242\u003c\/p\u003e \u003cp\u003e7.2 Using Joins and Subqueries 242\u003c\/p\u003e \u003cp\u003e7.2.1 Understanding Joins 242\u003c\/p\u003e \u003cp\u003e7.2.2 Using Different Join Syntaxes 244\u003c\/p\u003e \u003cp\u003e7.2.3 Using Basic Subqueries 246\u003c\/p\u003e \u003cp\u003eSelf-Check 250\u003c\/p\u003e \u003cp\u003e7.3 Using Batches and Scripts 250\u003c\/p\u003e \u003cp\u003e7.3.1 Writing Batches and Scripts 251\u003c\/p\u003e \u003cp\u003e7.3.2 Understanding Basic Programming Concepts 252\u003c\/p\u003e \u003cp\u003eSelf-Check 256\u003c\/p\u003e \u003cp\u003eSummary 256\u003c\/p\u003e \u003cp\u003eKey Terms 256\u003c\/p\u003e \u003cp\u003eAssess Your Understanding 257\u003c\/p\u003e \u003cp\u003eSummary Questions 257\u003c\/p\u003e \u003cp\u003eApplying This Chapter 259\u003c\/p\u003e \u003cp\u003eYou Try It262\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 Improving Data Access 263\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction 264\u003c\/p\u003e \u003cp\u003e8.1 Understanding Performance Roadblocks 264\u003c\/p\u003e \u003cp\u003e8.1.1 Recognizing Potential Bottlenecks 265\u003c\/p\u003e \u003cp\u003e8.1.2 Understanding Hardware Performance 265\u003c\/p\u003e \u003cp\u003e8.1.3 Understanding Database Performance 270\u003c\/p\u003e \u003cp\u003e8.1.4 Performance Monitoring 270\u003c\/p\u003e \u003cp\u003e8.1.5 Knowing What to Use 274\u003c\/p\u003e \u003cp\u003eSelf-Check 275\u003c\/p\u003e \u003cp\u003e8.2 Using Indexes and Views 275\u003c\/p\u003e \u003cp\u003e8.2.1 Working with Indexes 276\u003c\/p\u003e \u003cp\u003e8.2.2 Working with Views 280\u003c\/p\u003e \u003cp\u003eSelf-Check 283\u003c\/p\u003e \u003cp\u003e8.3Using Programmable Objects 284\u003c\/p\u003e \u003cp\u003e8.3.1Understanding Procedures 284\u003c\/p\u003e \u003cp\u003e8.3.2Understanding Functions 287\u003c\/p\u003e \u003cp\u003eSelf-Check 292\u003c\/p\u003e \u003cp\u003eSummary 292\u003c\/p\u003e \u003cp\u003eKey Terms 292\u003c\/p\u003e \u003cp\u003eAssess Your Understanding 294\u003c\/p\u003e \u003cp\u003eSummary Questions 294\u003c\/p\u003e \u003cp\u003eApplying This Chapter 296\u003c\/p\u003e \u003cp\u003eYou Try It298\u003c\/p\u003e \u003cp\u003e\u003cb\u003e9 Database Administration 300\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction 301\u003c\/p\u003e \u003cp\u003e9.1 Understanding the Need for Administration 301\u003c\/p\u003e \u003cp\u003e9.1.1 Identifying Administration Roles 302\u003c\/p\u003e \u003cp\u003e9.1.2 Justifying the Need for Administration 302\u003c\/p\u003e \u003cp\u003eSelf-Check 306\u003c\/p\u003e \u003cp\u003e9.2 Identifying Administration Responsibilities 307\u003c\/p\u003e \u003cp\u003e9.2.1 Understanding Data Administration Responsibilities 308\u003c\/p\u003e \u003cp\u003e9.2.2 Understanding Database Administration Responsibilities 313\u003c\/p\u003e \u003cp\u003eSelf-Check 318\u003c\/p\u003e \u003cp\u003e9.3 Understanding Management Tasks 318\u003c\/p\u003e \u003cp\u003e9.3.1 Considering “What” and “When” 319\u003c\/p\u003e \u003cp\u003e9.3.2 Considering “When” and “How” 319\u003c\/p\u003e \u003cp\u003e9.3.3 Ongoing Management Tasks 321\u003c\/p\u003e \u003cp\u003e9.3.4 Considering Troubleshooting 324\u003c\/p\u003e \u003cp\u003eSelf-Check 326\u003c\/p\u003e \u003cp\u003eSummary 326\u003c\/p\u003e \u003cp\u003eKey Terms 326\u003c\/p\u003e \u003cp\u003eAssess Your Understanding 327\u003c\/p\u003e \u003cp\u003eSummary Questions 327\u003c\/p\u003e \u003cp\u003eApplying This Chapter 329\u003c\/p\u003e \u003cp\u003eYou Try It 330\u003c\/p\u003e \u003cp\u003e\u003cb\u003e10 Transactions and Locking 332\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction333\u003c\/p\u003e \u003cp\u003e10.1 Understanding Transaction Basics 333\u003c\/p\u003e \u003cp\u003e10.1.1 Understanding Transaction Processing 333\u003c\/p\u003e \u003cp\u003e10.1.2 Using Transaction Commands 336\u003c\/p\u003e \u003cp\u003e10.1.3 Understanding Transaction Properties 341\u003c\/p\u003e \u003cp\u003e10.1.4 Understanding Transaction Scope 341\u003c\/p\u003e \u003cp\u003e10.1.5 Recognizing and Resolving Potential Problems 345\u003c\/p\u003e \u003cp\u003eSelf-Check 347\u003c\/p\u003e \u003cp\u003e10.2 Managing Concurrency Control 347\u003c\/p\u003e \u003cp\u003e10.2.1 The Need for Concurrency Management 348\u003c\/p\u003e \u003cp\u003e10.2.2 Recognizing Concurrency Problems 348\u003c\/p\u003e \u003cp\u003e10.2.3 Designing for Concurrency 352\u003c\/p\u003e \u003cp\u003e10.2.4 Concurrency Methods 352\u003c\/p\u003e \u003cp\u003eSelf-Check 355\u003c\/p\u003e \u003cp\u003e10.3 SQL Server Transaction Management 355\u003c\/p\u003e \u003cp\u003e10.3.1 Understanding Transaction Processing 355\u003c\/p\u003e \u003cp\u003e10.3.2 Managing Locks, Locking, and Transaction Isolation 356\u003c\/p\u003e \u003cp\u003e10.3.3 Recognizing, Clearing, and Preventing Deadlocks 358\u003c\/p\u003e \u003cp\u003eSelf-Check 362\u003c\/p\u003e \u003cp\u003eSummary 362\u003c\/p\u003e \u003cp\u003eKey Terms 363\u003c\/p\u003e \u003cp\u003eAssess Your Understanding 364\u003c\/p\u003e \u003cp\u003eSummary Questions 364\u003c\/p\u003e \u003cp\u003eApplying This Chapter 366\u003c\/p\u003e \u003cp\u003eYou Try It 367\u003c\/p\u003e \u003cp\u003e\u003cb\u003e11 Data Access and Security 368\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction369\u003c\/p\u003e \u003cp\u003e11.1 Understanding Database Connections 369\u003c\/p\u003e \u003cp\u003e11.1.1 Understanding Connectivity Concepts 369\u003c\/p\u003e \u003cp\u003e11.1.2 Understanding Client\/Server Connectivity 376\u003c\/p\u003e \u003cp\u003e11.1.3 Understanding Multitier Connectivity 379\u003c\/p\u003e \u003cp\u003eSelf-Check 382\u003c\/p\u003e \u003cp\u003e11.2 Managing Access Control 382\u003c\/p\u003e \u003cp\u003e11.2.1 Controlling Server Access 383\u003c\/p\u003e \u003cp\u003e11.2.2 Controlling Database Access 386\u003c\/p\u003e \u003cp\u003e11.2.3 Understanding the Connection Process 387\u003c\/p\u003e \u003cp\u003eSelf-Check 392\u003c\/p\u003e \u003cp\u003e11.3 Protecting Your Data 392\u003c\/p\u003e \u003cp\u003e11.3.1 Implementing Data Permissions 393\u003c\/p\u003e \u003cp\u003e11.3.2 Minimizing Table Access 397\u003c\/p\u003e \u003cp\u003e11.3.3 Keeping Data Safe 397\u003c\/p\u003e \u003cp\u003e11.3.4 Understanding RAID Configurations 397\u003c\/p\u003e \u003cp\u003e11.3.5 Using Data Backups 400\u003c\/p\u003e \u003cp\u003e11.3.6 Protecting Your Server 404\u003c\/p\u003e \u003cp\u003eSelf-Check 405\u003c\/p\u003e \u003cp\u003eSummary 406\u003c\/p\u003e \u003cp\u003eKey Terms 406\u003c\/p\u003e \u003cp\u003eAssess Your Understanding 407\u003c\/p\u003e \u003cp\u003eSummary Questions 407\u003c\/p\u003e \u003cp\u003eApplying This Chapter 409\u003c\/p\u003e \u003cp\u003eYou Try It 411\u003c\/p\u003e \u003cp\u003e\u003cb\u003e12 Supporting Database Applications 412\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction 413\u003c\/p\u003e \u003cp\u003e12.1 Supporting a Centralized Database 413\u003c\/p\u003e \u003cp\u003e12.1.1 Understanding Local Area Networks (LANs) 413\u003c\/p\u003e \u003cp\u003e12.1.2 Understanding Data Configurations 414\u003c\/p\u003e \u003cp\u003e12.1.3 Understanding Server Configurations 416\u003c\/p\u003e \u003cp\u003e12.1.4 Consolidating Data Sources 417\u003c\/p\u003e \u003cp\u003eSelf-Check 419\u003c\/p\u003e \u003cp\u003e12.2 Supporting a Distributed Database 419\u003c\/p\u003e \u003cp\u003e12.2.1 Understanding Distributed Data 419\u003c\/p\u003e \u003cp\u003e12.2.2 Understanding Replicated Data 423\u003c\/p\u003e \u003cp\u003e12.2.3 Understanding Partitioned Data 425\u003c\/p\u003e \u003cp\u003e12.2.4 Distributed Data Support Issues 429\u003c\/p\u003e \u003cp\u003eSelf-Check 434\u003c\/p\u003e \u003cp\u003e12.3 Understanding Internet Issues 434\u003c\/p\u003e \u003cp\u003e12.3.1 Managing Performance Issues 435\u003c\/p\u003e \u003cp\u003e12.3.2 Managing Availability Issues 436\u003c\/p\u003e \u003cp\u003e12.3.3 Managing Security and Privacy Issues 438\u003c\/p\u003e \u003cp\u003eSelf-Check 441\u003c\/p\u003e \u003cp\u003eSummary 442\u003c\/p\u003e \u003cp\u003eKey Terms 442\u003c\/p\u003e \u003cp\u003eAssess Your Understanding 443\u003c\/p\u003e \u003cp\u003eSummary Questions 443\u003c\/p\u003e \u003cp\u003eApplying This Chapter 445\u003c\/p\u003e \u003cp\u003eYou Try It 447\u003c\/p\u003e \u003cp\u003eGlossary 448\u003c\/p\u003e \u003cp\u003eIndex 465\u003c\/p\u003e\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Computer networking \u0026amp; communications [\u003ca title=\"See our other books on Computer networking \u0026amp; communications\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Computer%20networking%20\u0026amp;%20communications%20%5BUT%5D%22\"\u003eUT\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Wiley","offers":[{"title":"Brand New","offer_id":52257070678296,"sku":"9780470101865","price":69.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9780470101865.jpg?v=1781276277","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/wiley-pathways-introduction-to-database-management-paperback-softback-9780470101865","provider":"Freshly Printed Books","version":"1.0","type":"link"}