CompTIA DataSys+ Study Guide

ABOUT THE AUTHORSMike Chapple, PhD, Security+, CySA+, CISSP, 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.Sharif Nijim 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.

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