{"product_id":"comptia-datasys-study-guide-9781394180059","title":"CompTIA DataSys Study Guide","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cb\u003eYour all-in-one guide to preparing for the CompTIA DataSys+ exam\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIn \u003ci\u003eCompTIA DataSys+ Study Guide: Exam DS0-001\u003c\/i\u003e, a team of accomplished IT experts delivers a practical and hands-on roadmap to succeeding on the challenging DS0-001 exam and in a new or existing career as a data systems professional. In the book, you'll explore the essentials of databases, their deployment, management, maintenance, security, and more.\u003c\/p\u003e \u003cp\u003eWhether you're preparing for your first attempt at the CompTIA DataSys+ exam or for your first day on the job at a new database-related IT position, this book walks you through the foundational and intermediate skills you need to have to succeed. It covers every objective tested by the DS0-001 and skills commonly required in the real-world.\u003c\/p\u003e \u003cp\u003eYou''ll also find:\u003c\/p\u003e \u003cul\u003e \u003cli\u003ePractice test questions that measure your readiness for the real exam and your ability to handle the challenges of a new data systems position\u003c\/li\u003e \u003cli\u003eExamples and scen\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003eIntroduction xxi\u003c\/p\u003e \u003cp\u003eAssessment Test xxviii\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Today's Data Systems Professional 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eData Drives the Modern Business 2\u003c\/p\u003e \u003cp\u003eData 3\u003c\/p\u003e \u003cp\u003eStorage 3\u003c\/p\u003e \u003cp\u003eComputing Power 5\u003c\/p\u003e \u003cp\u003eData Systems 5\u003c\/p\u003e \u003cp\u003eDatabase Fundamentals 6\u003c\/p\u003e \u003cp\u003eDatabase Deployment 7\u003c\/p\u003e \u003cp\u003eDatabase Management and Maintenance 8\u003c\/p\u003e \u003cp\u003eData and Database Security 8\u003c\/p\u003e \u003cp\u003eBusiness Continuity 9\u003c\/p\u003e \u003cp\u003eCareers in Data Systems 10\u003c\/p\u003e \u003cp\u003eSummary 11\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Database Fundamentals 13\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTypes of Databases 14\u003c\/p\u003e \u003cp\u003eThe Relational Model 14\u003c\/p\u003e \u003cp\u003eRelational Databases 18\u003c\/p\u003e \u003cp\u003eNonrelational Databases 22\u003c\/p\u003e \u003cp\u003eLinear vs. Nonlinear Format 27\u003c\/p\u003e \u003cp\u003eNoSQL Database Tools 28\u003c\/p\u003e \u003cp\u003eProgramming and Database Operations 29\u003c\/p\u003e \u003cp\u003eObject- Relational Mapping 30\u003c\/p\u003e \u003cp\u003eProcess to Gauge Impact 31\u003c\/p\u003e \u003cp\u003eSummary 33\u003c\/p\u003e \u003cp\u003eExam Essentials 34\u003c\/p\u003e \u003cp\u003eReview Questions 36\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 SQL and Scripting 41\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFlavors of SQL 42\u003c\/p\u003e \u003cp\u003eData Definition Language 43\u003c\/p\u003e \u003cp\u003eData Manipulation Language 46\u003c\/p\u003e \u003cp\u003eSet- Based Logic 50\u003c\/p\u003e \u003cp\u003eTransaction Control Languages 54\u003c\/p\u003e \u003cp\u003eACID Principles 58\u003c\/p\u003e \u003cp\u003eSQL 58\u003c\/p\u003e \u003cp\u003eProgrammatic SQL 59\u003c\/p\u003e \u003cp\u003eSQL and Set-Based Logic 68\u003c\/p\u003e \u003cp\u003eAutomating Operations 72\u003c\/p\u003e \u003cp\u003eScript Purpose and Runtime Location 74\u003c\/p\u003e \u003cp\u003eLanguages 75\u003c\/p\u003e \u003cp\u003eCommand- Line Scripting 76\u003c\/p\u003e \u003cp\u003eSummary 77\u003c\/p\u003e \u003cp\u003eExam Essentials 79\u003c\/p\u003e \u003cp\u003eReview Questions 81\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Database Deployment 87\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePlanning and Design 88\u003c\/p\u003e \u003cp\u003eRequirements Gathering 88\u003c\/p\u003e \u003cp\u003eDatabase Architecture 99\u003c\/p\u003e \u003cp\u003eSchema Design 106\u003c\/p\u003e \u003cp\u003eDesign Documentation 116\u003c\/p\u003e \u003cp\u003eImplementation, Testing, and Deployment 121\u003c\/p\u003e \u003cp\u003eAcquisition of Assets 121\u003c\/p\u003e \u003cp\u003ePhases of Deployment 122\u003c\/p\u003e \u003cp\u003eDatabase Connectivity 122\u003c\/p\u003e \u003cp\u003eTesting 127\u003c\/p\u003e \u003cp\u003eDatabase Validation 135\u003c\/p\u003e \u003cp\u003eSummary 139\u003c\/p\u003e \u003cp\u003eExam Essentials 140\u003c\/p\u003e \u003cp\u003eReview Questions 142\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Database Management and Maintenance 147\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMonitoring and Reporting 148\u003c\/p\u003e \u003cp\u003eSystem Alerts and Notifications 149\u003c\/p\u003e \u003cp\u003eLog Files 157\u003c\/p\u003e \u003cp\u003eDeadlock Monitoring 158\u003c\/p\u003e \u003cp\u003eConnections and Sessions 159\u003c\/p\u003e \u003cp\u003eMaintenance 160\u003c\/p\u003e \u003cp\u003eDatabase Stability 160\u003c\/p\u003e \u003cp\u003eDatabase Performance 163\u003c\/p\u003e \u003cp\u003eDatabase Reliability 168\u003c\/p\u003e \u003cp\u003eFacilitating Operations 172\u003c\/p\u003e \u003cp\u003eData Management Tasks 180\u003c\/p\u003e \u003cp\u003eData Management 181\u003c\/p\u003e \u003cp\u003eSummary 189\u003c\/p\u003e \u003cp\u003eExam Essentials 191\u003c\/p\u003e \u003cp\u003eReview Questions 193\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Governance, Security, and Compliance 199\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eData Governance 200\u003c\/p\u003e \u003cp\u003eData Governance Roles 200\u003c\/p\u003e \u003cp\u003eAccess Requirements 201\u003c\/p\u003e \u003cp\u003eData Retention 206\u003c\/p\u003e \u003cp\u003eIdentity and Access Management 207\u003c\/p\u003e \u003cp\u003eIdentification, Authentication, and Authorization 207\u003c\/p\u003e \u003cp\u003eAuthentication Techniques 208\u003c\/p\u003e \u003cp\u003ePassword Policies 209\u003c\/p\u003e \u003cp\u003eAccount Types 211\u003c\/p\u003e \u003cp\u003eData Security 212\u003c\/p\u003e \u003cp\u003eProtecting Data at Rest 213\u003c\/p\u003e \u003cp\u003eProtecting Data in Transit 213\u003c\/p\u003e \u003cp\u003eData Loss Prevention 216\u003c\/p\u003e \u003cp\u003eData Classification 217\u003c\/p\u003e \u003cp\u003ePersonally Identifiable Information 217\u003c\/p\u003e \u003cp\u003eProtected Health Information 218\u003c\/p\u003e \u003cp\u003ePayment Card Information 220\u003c\/p\u003e \u003cp\u003eRegional Requirements 221\u003c\/p\u003e \u003cp\u003eBreach Reporting Requirements 222\u003c\/p\u003e \u003cp\u003eRoutine Auditing 223\u003c\/p\u003e \u003cp\u003eExpired Accounts 223\u003c\/p\u003e \u003cp\u003eConnection Requests 223\u003c\/p\u003e \u003cp\u003eSQL Code 224\u003c\/p\u003e \u003cp\u003eCredential Storage Checks 224\u003c\/p\u003e \u003cp\u003eSummary 225\u003c\/p\u003e \u003cp\u003eExam Essentials 225\u003c\/p\u003e \u003cp\u003eReview Questions 227\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Database Security 231\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDatabase Infrastructure Security 232\u003c\/p\u003e \u003cp\u003ePhysical Security 232\u003c\/p\u003e \u003cp\u003eLogical Security 237\u003c\/p\u003e \u003cp\u003eDatabase Attacks 242\u003c\/p\u003e \u003cp\u003eSQL Injection 242\u003c\/p\u003e \u003cp\u003eDenial of Service 248\u003c\/p\u003e \u003cp\u003eOn- Path Attacks 249\u003c\/p\u003e \u003cp\u003eMalware 250\u003c\/p\u003e \u003cp\u003ePhishing 253\u003c\/p\u003e \u003cp\u003ePassword Attacks 255\u003c\/p\u003e \u003cp\u003eSummary 255\u003c\/p\u003e \u003cp\u003eExam Essentials 256\u003c\/p\u003e \u003cp\u003eReview Questions 258\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Business Continuity 265\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Nature of Disaster 266\u003c\/p\u003e \u003cp\u003eNatural Disasters 266\u003c\/p\u003e \u003cp\u003eHuman-Made Disasters 272\u003c\/p\u003e \u003cp\u003eDisaster Recovery Planning 275\u003c\/p\u003e \u003cp\u003ePrioritizing Disaster Recovery Efforts 275\u003c\/p\u003e \u003cp\u003eDisaster Recovery Documentation 277\u003c\/p\u003e \u003cp\u003eDisaster Recovery Technology 280\u003c\/p\u003e \u003cp\u003eDisaster Recovery Plan Testing 285\u003c\/p\u003e \u003cp\u003eLessons Learned 287\u003c\/p\u003e \u003cp\u003ePlan Maintenance 288\u003c\/p\u003e \u003cp\u003eBackup and Restore 288\u003c\/p\u003e \u003cp\u003eSummary 292\u003c\/p\u003e \u003cp\u003eExam Essentials 293\u003c\/p\u003e \u003cp\u003eReview Questions 294\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix Answers to Review Questions 299\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 2: Database Fundamentals 300\u003c\/p\u003e \u003cp\u003eChapter 3: SQL and Scripting 301\u003c\/p\u003e \u003cp\u003eChapter 4: Database Deployment 304\u003c\/p\u003e \u003cp\u003eChapter 5: Database Management and Maintenance 309\u003c\/p\u003e \u003cp\u003eChapter 6: Governance, Security, and Compliance 312\u003c\/p\u003e \u003cp\u003eChapter 7: Database Security 314\u003c\/p\u003e \u003cp\u003eChapter 8: Business Continuity 316\u003c\/p\u003e \u003cp\u003eIndex 319\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49083885060439,"sku":"9781394180059","price":38.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781394180059.jpg?v=1725550320","url":"https:\/\/bookcurl.com\/products\/comptia-datasys-study-guide-9781394180059","provider":"Book Curl","version":"1.0","type":"link"}