CompTIA DataSys+ Study Guide : Exam DS0-001 (2023)

Page 1 of 16

CompTIA DataSys+ Study Guide : Exam DS0-001 (2023) - Page 1 preview image

Page 2 of 16

CompTIA DataSys+ Study Guide : Exam DS0-001 (2023) - Page 2 preview image

Page 3 of 16

CompTIA DataSys+ Study Guide : Exam DS0-001 (2023) - Page 3 preview image

Table of ContentsCoverTable of ContentsTitle PageCopyrightDedicationAcknowledgmentsAbout the AuthorsAbout the Technical EditorsIntroductionThe DataSys+ ExamWhat Does This Book Cover?Exam DS0-001 Exam ObjectivesDS0-001 Certification Exam Objective MapHow to Contact the PublisherAssessment TestAnswers to Assessment TestChapter 1: Today's Data Systems ProfessionalData Drives the Modern BusinessData SystemsCareers in Data SystemsSummaryChapter 2: Database FundamentalsTypes of DatabasesProgramming and Database OperationsSummaryExam EssentialsReview Questions

Page 4 of 16

CompTIA DataSys+ Study Guide : Exam DS0-001 (2023) - Page 4 preview image

Chapter 3: SQL and ScriptingFlavors of SQLAutomating OperationsSummaryExam EssentialsReview QuestionsChapter 4: Database DeploymentPlanning and DesignImplementation, Testing, and DeploymentSummaryExam EssentialsReview QuestionsChapter 5: Database Management and MaintenanceMonitoring and ReportingMaintenanceFacilitating OperationsData Management TasksSummaryExam EssentialsReview QuestionsChapter 6: Governance, Security, and ComplianceData GovernanceIdentity and Access ManagementData SecurityData ClassificationRoutine AuditingSummaryExam EssentialsReview Questions

Page 5 of 16

CompTIA DataSys+ Study Guide : Exam DS0-001 (2023) - Page 5 preview image

Chapter 7: Database SecurityDatabase Infrastructure SecurityDatabase AttacksSummaryExam EssentialsReview QuestionsChapter 8: Business ContinuityThe Nature of DisasterDisaster Recovery PlanningBackup and RestoreSummaryExam EssentialsReview QuestionsAppendix: Answers to Review QuestionsChapter 2: Database FundamentalsChapter 3: SQL and ScriptingChapter 4: Database DeploymentChapter 5: Database Management and MaintenanceChapter 6: Governance, Security, and ComplianceChapter 7: Database SecurityChapter 8: Business ContinuityIndexEnd User License AgreementList of TablesChapter 1TABLE 1.1 Gigabyte Storage Costs over TimeTABLE 1.2 Highest-Demand OccupationsChapter 2

Page 6 of 16

CompTIA DataSys+ Study Guide : Exam DS0-001 (2023) - Page 6 preview image

TABLE 2.1 Customer DataTABLE 2.2 Customer and Address DataTABLE 2.3 Address DataTABLE 2.4 Address Data with Foreign KeyChapter 3TABLE 3.1 Common Data TypesTABLE 3.2 Data Manipulation Language OperationsTABLE 3.3 Customer TableTABLE 3.4 Address DataTABLE 3.5 Name and Work Address Result SetTABLE 3.6 LEFT JOIN Name and Address Result SetChapter 4TABLE 4.1 Availability TargetsTABLE 4.2 Default Database PortsTABLE 4.3 Default Database PortsChapter 5TABLE 5.1 Common Database Index TypesTABLE 5.2 Effective Date LogicTABLE 5.3 Initial Phone_Type Data ValuesTABLE 5.4 Initial Phone_Type Data ValuesChapter 6TABLE 6.1 Sample Data Classification MatrixChapter 8TABLE 8.1 Business Impact AnalysisList of Illustrations

Page 7 of 16

CompTIA DataSys+ Study Guide : Exam DS0-001 (2023) - Page 7 preview image

Chapter 1FIGURE 1.1 Analytics is made possible by modern data,storage, and computing...FIGURE 1.2 Storage costs have decreased over time.FIGURE 1.3 SQLQueryChapter 2FIGURE 2.1 Sample Customer tableFIGURE 2.2 Sample Address tableFIGURE 2.3 Customer and Address tablesFIGURE 2.4 Key-value sample dataFIGURE 2.5 JSON document sample dataFIGURE 2.6 Data in a graphFIGURE 2.7 Sample data in CSV formFIGURE 2.8 Comparing SQL execution plansChapter 3FIGURE 3.1 DDL for sample Customer tableFIGURE 3.2 Sample Address tableFIGURE 3.3 SQL INSERT syntaxFIGURE 3.4 SQL SELECT syntaxFIGURE 3.5 SQL UPDATE syntaxFIGURE 3.6 SQL DELETE syntaxFIGURE 3.7 Two independent setsFIGURE 3.8 Union of two setsFIGURE 3.9 Comparing UNION and UNION ALL result setsFIGURE 3.10 Intersection of two setsFIGURE 3.11 INTERSECT result set

Page 8 of 16

CompTIA DataSys+ Study Guide : Exam DS0-001 (2023) - Page 8 preview image

FIGURE 3.12 Difference between two setsFIGURE 3.13 Differences between setsFIGURE 3.14 TCL exampleFIGURE 3.15 Illustrating the consistency principleFIGURE 3.16 Before-update trigger exampleFIGURE 3.17 After-update trigger exampleFIGURE 3.18 Stored procedure exampleFIGURE 3.19 Customer dataFIGURE 3.20 Custom functionFIGURE 3.21 Using a view to restrict accessFIGURE 3.22 Using a view to combine data from multipletablesFIGURE 3.23 Employee and Order tablesFIGURE 3.24 Server-side and client-side scriptsChapter 4FIGURE 4.1 Transactional data sourcesFIGURE 4.2 Analytical data sourcesFIGURE 4.3 Travel history dataFIGURE 4.4 Direct database integrationFIGURE 4.5 Centralized database integrationFIGURE 4.6 Single database serverFIGURE 4.7 Active-active database clusterFIGURE 4.8 Active-passive database clusterFIGURE 4.9 Vertical scalingFIGURE 4.10 Horizontal scalingFIGURE 4.11 Conceptual data model

Page 9 of 16

CompTIA DataSys+ Study Guide : Exam DS0-001 (2023) - Page 9 preview image

FIGURE 4.12 Entity-relationship diagram line terminatorsFIGURE 4.13 Logical data modelFIGURE 4.14 Data in first normal formFIGURE 4.15 Data in second normal formFIGURE 4.16 Data in third normal formFIGURE 4.17 Physical data modelFIGURE 4.18 Package history viewFIGURE 4.19 Physical data model with package history viewFIGURE 4.20 Excerpt of an entity relationship diagramFIGURE 4.21 One-to-one cardinalityFIGURE 4.22 Many-to-many cardinalityFIGURE 4.23 Resolving a many-to-many relationshipFIGURE 4.24 Flat networkFIGURE 4.25 Network with public and private subnetsFIGURE 4.26 DNS host-name resolutionFIGURE 4.27 Border and internal firewallsFIGURE 4.28 Firewall rules for web and database trafficFIGURE 4.29a Range control with referential integrityFIGURE 4.29b Range control with a check constraintFIGURE 4.30a Primary keyFIGURE 4.30b Primary key and unique constraintFIGURE 4.31 Queries with and without bind variablesFIGURE 4.32a Uncovered queryFIGURE 4.32b Covered queryChapter 5FIGURE 5.1 Database CPU utilization

Page 10 of 16

CompTIA DataSys+ Study Guide : Exam DS0-001 (2023) - Page 10 preview image

FIGURE 5.2 Data load failure notificationFIGURE 5.3 Database replicationFIGURE 5.4 Deadlocked transactionsFIGURE 5.5 Connection poolingFIGURE 5.6 Load-balanced databaseFIGURE 5.7 Load-balanced application and databaseFIGURE 5.8 Customer table data dictionary entryFIGURE 5.9 Updated Customer table data dictionary entryFIGURE 5.10a Original Customer entityFIGURE 5.10b Modified Customer entityFIGURE 5.11 Generating DDL from an ERD in LucidchartFIGURE 5.12 Updating a table definition using Oracle SQLDeveloper Data Mode...FIGURE 5.13 ALTER TABLE DDL from Oracle SQLDeveloper Data ModelerFIGURE 5.14a Customer and Customer_Address ERDFIGURE 5.14b Customer and Customer_Address UMLclassesFIGURE 5.15 Updated Customer tableFIGURE 5.16 New Phone and Phone_Type tablesFIGURE 5.17 Creating duplicate dataFIGURE 5.18 Duplicate resolution processFIGURE 5.19 Data sharing with shared schemasFIGURE 5.20 Data sharing with APIsChapter 6FIGURE 6.1 Organizational exampleFIGURE 6.2 Access roles over time

Page 11 of 16

CompTIA DataSys+ Study Guide : Exam DS0-001 (2023) - Page 11 preview image

FIGURE 6.3 Danger of user-based accessFIGURE 6.4 Sample organization chartFIGURE 6.5 Sample user group-based rolesFIGURE 6.6 Biometric authentication with a (a) retinalscanner (b) fingerpri...FIGURE 6.7 Authentication tokenFIGURE 6.8 Creating a password in LastPassFIGURE 6.9 Encrypted network connectionFIGURE 6.10 HTTPS padlockFIGURE 6.11 Encrypted ETL processFIGURE 6.12 Data masking ETL processFIGURE 6.13 Re-identification by combining data setsChapter 7FIGURE 7.1 Cooling equipment on a data center roofFIGURE 7.2 Network firewalls divide networks into threezones.FIGURE 7.3 Account number input pageFIGURE 7.4 Account information pageFIGURE 7.5 Account information page after blind SQLinjectionFIGURE 7.6 A WAFFIGURE 7.7 On-path attackFIGURE 7.8 Windows Defender Antimalware packageChapter 8FIGURE 8.1 US earthquake risk mapFIGURE 8.2 Flood hazard map for Miami–Dade County,Florida

Page 12 of 16