Table of Contents:
“...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....
”
Call Number:
Loading...
Located:
Loading...
Connect to the full text of this electronic book
eBook
