Produktbild: CompTIA DataSys+ Study Guide

CompTIA DataSys+ Study Guide Exam DS0-001

Aus der Reihe Sybex Study Guide

56,99 €

inkl. gesetzl. MwSt., Versandkostenfrei


Beschreibung

Produktdetails

Einband

Taschenbuch

Erscheinungsdatum

23.10.2023

Verlag

John Wiley & Sons

Seitenzahl

368

Maße (L/B/H)

18,7/23,6/3 cm

Gewicht

658 g

Auflage

1. Auflage

Sprache

Englisch

ISBN

978-1-394-18005-9

Beschreibung

Produktdetails

Einband

Taschenbuch

Erscheinungsdatum

23.10.2023

Verlag

John Wiley & Sons

Seitenzahl

368

Maße (L/B/H)

18,7/23,6/3 cm

Gewicht

658 g

Auflage

1. Auflage

Sprache

Englisch

ISBN

978-1-394-18005-9

Herstelleradresse

Libri GmbH
Europaallee 1
36244 Bad Hersfeld
DE

Email: gpsr@libri.de

Noch keine Bewertungen vorhanden

Verfassen Sie die erste Bewertung zu diesem Artikel

Helfen Sie anderen Kundinnen und Kunden durch Ihre Meinung.

Kundinnen und Kunden meinen

Bewertungen (0)

Die Leseprobe wird geladen.
  • Produktbild: CompTIA DataSys+ Study Guide
  • 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