{"product_id":"comptia-datasys-study-guide-exam-ds0-001-paperback-softback-9781394180059","title":"CompTIA DataSys+ Study Guide; Exam DS0-001 (Paperback \/ softback) 9781394180059","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eCompTIA DataSys+ Study Guide\u003c\/font\u003e\u003cbr\u003e\r\n\u003cfont size=\"5\"\u003eExam DS0-001\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\u003cp\u003e\u003cfont size=\"4\"\u003eMike Chapple (Author), Sharif Nijim (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9781394180059, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 23 October 2023\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e368 pages\u003cbr\u003e23.1 x 18.5 x 2.3 cm, 0.612 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\"\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 scenarios drawn from real life, as well as challenging chapter review questions\u003c\/li\u003e \u003cli\u003eComplimentary access to Sybex’s interactive online learning environment and test bank, accessible from multiple devices, and including electronic flashcards and a searchable glossary, all supported by Wiley's support agents who are available 24x7 via email or live chat to assist with access and login questions\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003ePerfect for anyone getting ready to write the DS0-001 certification exam, \u003ci\u003eCompTIA DataSys+ Study Guide: Exam DS0-001\u003c\/i\u003e is also an essential resource for everyone seeking the foundational knowledge and skills required to move into a database administrator role.\u003c\/p\u003e\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\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\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Education [\u003ca title=\"See our other books on Education\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Education%20%5BJN%5D%22\"\u003eJN\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Sybex","offers":[{"title":"Brand New","offer_id":52460678316312,"sku":"9781394180059","price":32.89,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9781394180059.jpg?v=1785457941","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/comptia-datasys-study-guide-exam-ds0-001-paperback-softback-9781394180059","provider":"Freshly Printed Books","version":"1.0","type":"link"}