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