CompTIA Data Systems (DSO-001) Cert Prep

Course details

In this course, Mike Chapple—a teaching professor of information technology, analytics, and operations—guides you through the key topics of database fundamentals, database deployment, database management and maintenance, data and database security, and business continuity. Understand database structure types while developing, modifying, and running structured query language (SQL) code. Compare and contrast the different aspects of database design and planning and explain the various phases of the implementation, testing, deployment and optimization of collected data. Learn the purpose of monitoring and reporting database performance, explain common database maintenance processes, and produce critical documentation. Secure databases, protect against attacks, and control authorization while ensuring governance and regulatory compliance. Plus, implement best practices for disaster recovery, backup, and restoration of database management systems.

Concepts

0. Introduction

01 - Earning your DataSys+ certification
02 - What you should know
03 - Study resources

1. Domain 1 - Database Fundamentals

04 - Overview of the database fundamentals domain

2. Understanding Data

05 - The value of data
06 - Structured data
07 - Tabular data
08 - Key value pairs

3. Data Storage

09 - Relational databases
10 - OLTP and OLAP
11 - Non-relational databases

4. Structured Query Language

12 - Structured Query Language
13 - SELECT statement
14 - Sorting results
15 - Filtering data
16 - Aggregating data
17 - String manipulation
18 - Working with dates
19 - Derived values
20 - Set operations
21 - Join operations
22 - Inner joins
23 - Joining multiple tables
24 - Outer joins
25 - Transactions and the ACID model

5. Database Programming

26 - Triggers
27 - Stored procedures and functions
28 - Views
29 - Scripting
30 - Object-relational mapping

6. Domain 2 - Database Deployment

31 - Overview of the database deployment domain

7. Database Planning

32 - Requirements gathering
33 - Database architecture factors
34 - What is the cloud
35 - Cloud service categories
36 - Database schema
37 - Data sources
38 - Design documentation

8. Database Implementation and Deployment

39 - Acquisition of assets
40 - Phases of deployment
41 - Client server architecture
42 - Domain Name System (DNS)
43 - Network ports

9. Database Testing

44 - Database quality checks
45 - Code execution testing
46 - Stress testing
47 - Version control testing
48 - Regression testing
49 - Negative testing

10. Database Validation

50 - Data mapping
51 - Data values
52 - Query validation
53 - Index analysis
54 - Integrity and scalability validation

11. Domain 3 - Database Management and Maintenance

55 - Overview of the database management and maintenance domain

12. Monitoring and Reporting

56 - Trends to monitor
57 - Baseline configuration and trending
58 - Activity tracking
59 - Transaction logs
60 - System logs
61 - Deadlock monitoring
62 - Connection monitoring

13. Database Maintenance

63 - Query optimization
64 - Index optimization
65 - Patch management
66 - Database integrity checks
67 - Data corruption checks
68 - Audit log review
69 - Performance tuning
70 - Load balancing
71 - Change management

14. Database Documentation

72 - Maintaining data dictionaries
73 - Maintenance documentation
74 - Standard operating procedure (SOP) documentation
75 - Documentation tools

15. Data Management

76 - Data redundancy
77 - Data sharing

16. Domain 4 - Data and Database Security

78 - Overview of the data and database security domain

17. Data Security Concepts

79 - Encrypting data
80 - Data discovery
81 - The data lifecycle
82 - Data de-identification
83 - Data obfuscation
84 - Monitoring accounts
85 - Monitoring connection requests
86 - Code auditing

18. Compliance

87 - Legal and compliance risks
88 - Data privacy
89 - General Data Protection Regulation (GDPR)
90 - California Consumer Privacy Act (CCPA)
91 - Data types
92 - Data classification
93 - Data loss prevention
94 - Security policies

19. Authentication and Authorization

95 - Identity and access management
96 - Usernames and access cards
97 - Biometrics
98 - Authentication factors
99 - Multifactor authentication
100 - Password policies
101 - Need to know and least privilege
102 - Privileged account management

20. Physical Security

103 - Site and facility design
104 - Data center environmental controls
105 - Data center environmental protection
106 - Physical access control
107 - Visitor management

21. Logical Security

108 - Firewalls
109 - Port security

22. Data Systems Attacks

110 - Preventing SQL injection
111 - Brute force attacks
112 - Denial-of-service attacks
113 - Eavesdropping attacks
114 - Impersonation attacks
115 - Malware prevention
116 - Ransomware

23. Domain 5 - Business Continuity

117 - Overview of the business continuity domain

24. Disaster Recovery Planning

118 - Disaster recovery
119 - Disaster recovery documentation
120 - Disaster recovery techniques
121 - Testing BC DR plans

25. Backups

122 - Backups
123 - Restoring backups
124 - Database dumping
125 - Backup automation and testing
126 - Disaster recovery sites
127 - Backup retention

Conclusion

128 - Preparing for the exam