Details

<p>Introduction xxi</p> <p>Assessment Test xxviii</p> <p><b>Chapter 1 Today's Data Systems Professional 1</b></p> <p>Data Drives the Modern Business 2</p> <p>Data 3</p> <p>Storage 3</p> <p>Computing Power 5</p> <p>Data Systems 5</p> <p>Database Fundamentals 6</p> <p>Database Deployment 7</p> <p>Database Management and Maintenance 8</p> <p>Data and Database Security 8</p> <p>Business Continuity 9</p> <p>Careers in Data Systems 10</p> <p>Summary 11</p> <p><b>Chapter 2 Database Fundamentals 13</b></p> <p>Types of Databases 14</p> <p>The Relational Model 14</p> <p>Relational Databases 18</p> <p>Nonrelational Databases 22</p> <p>Linear vs. Nonlinear Format 27</p> <p>NoSQL Database Tools 28</p> <p>Programming and Database Operations 29</p> <p>Object- Relational Mapping 30</p> <p>Process to Gauge Impact 31</p> <p>Summary 33</p> <p>Exam Essentials 34</p> <p>Review Questions 36</p> <p><b>Chapter 3 SQL and Scripting 41</b></p> <p>Flavors of SQL 42</p> <p>Data Definition Language 43</p> <p>Data Manipulation Language 46</p> <p>Set- Based Logic 50</p> <p>Transaction Control Languages 54</p> <p>ACID Principles 58</p> <p>SQL 58</p> <p>Programmatic SQL 59</p> <p>SQL and Set-Based Logic 68</p> <p>Automating Operations 72</p> <p>Script Purpose and Runtime Location 74</p> <p>Languages 75</p> <p>Command- Line Scripting 76</p> <p>Summary 77</p> <p>Exam Essentials 79</p> <p>Review Questions 81</p> <p><b>Chapter 4 Database Deployment 87</b></p> <p>Planning and Design 88</p> <p>Requirements Gathering 88</p> <p>Database Architecture 99</p> <p>Schema Design 106</p> <p>Design Documentation 116</p> <p>Implementation, Testing, and Deployment 121</p> <p>Acquisition of Assets 121</p> <p>Phases of Deployment 122</p> <p>Database Connectivity 122</p> <p>Testing 127</p> <p>Database Validation 135</p> <p>Summary 139</p> <p>Exam Essentials 140</p> <p>Review Questions 142</p> <p><b>Chapter 5 Database Management and Maintenance 147</b></p> <p>Monitoring and Reporting 148</p> <p>System Alerts and Notifications 149</p> <p>Log Files 157</p> <p>Deadlock Monitoring 158</p> <p>Connections and Sessions 159</p> <p>Maintenance 160</p> <p>Database Stability 160</p> <p>Database Performance 163</p> <p>Database Reliability 168</p> <p>Facilitating Operations 172</p> <p>Data Management Tasks 180</p> <p>Data Management 181</p> <p>Summary 189</p> <p>Exam Essentials 191</p> <p>Review Questions 193</p> <p><b>Chapter 6 Governance, Security, and Compliance 199</b></p> <p>Data Governance 200</p> <p>Data Governance Roles 200</p> <p>Access Requirements 201</p> <p>Data Retention 206</p> <p>Identity and Access Management 207</p> <p>Identification, Authentication, and Authorization 207</p> <p>Authentication Techniques 208</p> <p>Password Policies 209</p> <p>Account Types 211</p> <p>Data Security 212</p> <p>Protecting Data at Rest 213</p> <p>Protecting Data in Transit 213</p> <p>Data Loss Prevention 216</p> <p>Data Classification 217</p> <p>Personally Identifiable Information 217</p> <p>Protected Health Information 218</p> <p>Payment Card Information 220</p> <p>Regional Requirements 221</p> <p>Breach Reporting Requirements 222</p> <p>Routine Auditing 223</p> <p>Expired Accounts 223</p> <p>Connection Requests 223</p> <p>SQL Code 224</p> <p>Credential Storage Checks 224</p> <p>Summary 225</p> <p>Exam Essentials 225</p> <p>Review Questions 227</p> <p><b>Chapter 7 Database Security 231</b></p> <p>Database Infrastructure Security 232</p> <p>Physical Security 232</p> <p>Logical Security 237</p> <p>Database Attacks 242</p> <p>SQL Injection 242</p> <p>Denial of Service 248</p> <p>On- Path Attacks 249</p> <p>Malware 250</p> <p>Phishing 253</p> <p>Password Attacks 255</p> <p>Summary 255</p> <p>Exam Essentials 256</p> <p>Review Questions 258</p> <p><b>Chapter 8 Business Continuity 265</b></p> <p>The Nature of Disaster 266</p> <p>Natural Disasters 266</p> <p>Human-Made Disasters 272</p> <p>Disaster Recovery Planning 275</p> <p>Prioritizing Disaster Recovery Efforts 275</p> <p>Disaster Recovery Documentation 277</p> <p>Disaster Recovery Technology 280</p> <p>Disaster Recovery Plan Testing 285</p> <p>Lessons Learned 287</p> <p>Plan Maintenance 288</p> <p>Backup and Restore 288</p> <p>Summary 292</p> <p>Exam Essentials 293</p> <p>Review Questions 294</p> <p><b>Appendix Answers to Review Questions 299</b></p> <p>Chapter 2: Database Fundamentals 300</p> <p>Chapter 3: SQL and Scripting 301</p> <p>Chapter 4: Database Deployment 304</p> <p>Chapter 5: Database Management and Maintenance 309</p> <p>Chapter 6: Governance, Security, and Compliance 312</p> <p>Chapter 7: Database Security 314</p> <p>Chapter 8: Business Continuity 316</p> <p>Index 319</p>

<p><b>ABOUT THE AUTHORS</b></p> <p><b>Mike Chapple, PhD, Security+, CySA+, CISSP,</b> is Teaching Professor of Information Technology, Analytics, and Operations at Notre Dame's Mendoza College of Business. He is a bestselling author of over 30 books and serves as the Academic Director of the University's Master of Science in Business Analytics program. He holds multiple additional certifications, including the CISSP (Certified Information Systems Security Professional), CompTIA Data+, CIPP/US (Certified Information Privacy Professional), CompTIA PenTest+, and CompTIA Security+. Mike provides IT certification resources at his website, CertMike.com.</p> <p><b>Sharif Nijim</b> is an Associate Teaching Professor of IT, Analytics, and Operations at Notre Dame's Mendoza College of Business, where he also serves as the Academic co-Director of the residential Master of Science in Business Analytics program. Prior to Notre Dame, Sharif co-founded and served on the board of a customer data integration company serving the airline industry.</p>

<p><b>Your all-in-one guide to preparing for the CompTIA DataSys+ exam</b></p> <p>The CompTIA DataSys+ Study Guide is your complete resource for comprehensive coverage of the challenging DS0-001 exam. This Sybex Study Guide covers 100% of the DS0-001 objectives. Prepare for the exam faster and smarter with Sybex thanks to accurate content that includes real-world examples and scenarios, practical exercises, and challenging chapter review questions. Reinforce and remember what you've learned with the Sybex online learning environment and test bank, accessible from almost anywhere. Get prepared for the CompTIA DataSys+ exam with Sybex.</p> <p><b>Coverage of 100% of all exam objectives in this Study Guide means you'll be ready for: </b></p> <ul> <li>Database Fundamentals</li> <li>Database Deployment</li> <li>Database Management and Maintenance</li> <li>Data and Database Security</li> <li>Business Continuity</li> </ul> <p><b>ABOUT THE COMPTIA DATASYS+ CERTIFICATION</b></p> <p>The CompTIA DataSys+ certification is the perfect credential to demonstrate you have the knowledge and skills required to deploy, manage, and maintain databases, including employing the fundamentals of scripting and programming in a database environment while using security and business continuity best practices. Recommended experience is 2–3 years of hands-on experience as a database administrator. Go to comptia.org for more information.</p> <p><b>Interactive learning environment</b></p> <p>Take your exam prep to the next level with Sybex's superior interactive online study tools. To access our learning environment, simply visit <b>www.wiley.com/go/sybextestprep</b>, register your book to receive your unique PIN, and instantly gain one year of FREE access after activation to:</p> <ul> <li><b>Interactive test bank</b> with a practice exam to help you identify areas where further review is needed. Get more than 90% of the answers correct, and you're ready to take the certification exam.</li> <li><b>100 electronic flashcards</b> to reinforce learning and last-minute prep before the exam</li> <li><b>Comprehensive glossary</b> in PDF format gives you instant access to the key terms so you are fully prepared</li> </ul>

US