Comptia Datasys+ Study Guide - Mike Chapple

. .

Auteur(s) : Mike Chapple - Sharif Nijim

Editeur : Wiley

Langue : Anglais

Parution : 01/11/2023

Format : Moyen, de 350g à 1kg

Nombre de pages : 368

Expédition : 692

Dimensions : 18.7 x 23.6 x 1.8

ISBN : 1394180055

Résumé :

Your all-in-one guide to preparing for the CompTIA DataSys+ exam

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.

Coverage of 100% of all exam objectives in this Study Guide means you'll be ready for:

• Database Fundamentals
• Database Deployment
• Database Management and Maintenance
• Data and Database Security
• Business Continuity

ABOUT THE COMPTIA DATASYS+ CERTIFICATION

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.

Interactive learning environment

Take your exam prep to the next level with Sybex's superior interactive online study tools. To access our learning environment, simply visit www.wiley.com/go/sybextestprep, register your book to receive your unique PIN, and instantly gain one year of FREE access after activation to:

• Interactive test bank 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.
• 100 electronic flashcards to reinforce learning and last-minute prep before the exam
• Comprehensive glossary in PDF format gives you instant access to the key terms so you are fully prepared

...

Biographie:
.

Sommaire:

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 ...