Introduction
Earning your DataSys+ certification
()
What you should know
()
Study resources
()
1. Domain 1: Database Fundamentals
Overview of the database fundamentals domain
()
2. Understanding Data
The value of data
()
Structured vs. unstructured data
()
Tabular data
()
Key/value pairs
()
3. Data Storage
Relational databases
()
OLTP and OLAP
()
Non-relational databases
()
4. Structured Query Language
Structured Query Language
()
SELECT statement
()
Sorting results
()
Filtering data
()
Aggregating data
()
String manipulation
()
Working with dates
()
Computed columns
()
Set operations
()
Join operations
()
Inner joins
()
Joining multiple tables
()
Outer joins
()
Windowing
()
Nested queries
()
Transactions and the ACID model
()
The BASE model
()
Table isolation levels
()
5. Database Programming
Triggers
()
Stored procedures and functions
()
Views
()
Scripting
()
Object-relational mapping
()
6. Domain 2: Database Deployment
Overview of the database deployment domain
()
7. Database Planning
Requirements gathering
()
Database architecture factors
()
Service-level agreements
()
What is the cloud?
()
Cloud service categories
()
Database as a service
()
Persistence
()
Database schema
()
Design documentation
()
8. Database Implementation and Deployment
Acquisition of assets
()
Phases of deployment
()
Client/server architecture
()
Domain Name System (DNS)
()
Network ports
()
Load balancing
()
Multizone regions
()
9. Database Testing
Database quality checks
()
Schema compatibility testing
()
Stress testing
()
Regression testing
()
10. Database Validation
Data mapping
()
Data values
()
Query validation
()
Index analysis
()
Integrity and scalability validation
()
11. Domain 3: Database Management and Maintenance
Overview of the database management and maintenance domain
()
12. Monitoring and Reporting
Trends to monitor
()
Baseline configuration and trending
()
Activity tracking
()
Transaction logs
()
System logs
()
Deadlock monitoring
()
Connection monitoring
()
13. Database Maintenance
Query optimization
()
Index optimization
()
Database statistics
()
Patch management
()
Database integrity checks
()
Data corruption checks
()
Audit log review
()
Performance tuning
()
Partitioning
()
Change management
()
14. Database Documentation
Maintaining data dictionaries
()
Maintenance documentation
()
Standard operating procedure (SOP) documentation
()
15. Data Management
Data redundancy
()
Data sharing
()
16. Domain 4: Data and Database Security
Overview of the data and database security domain
()
17. Data Security Concepts
Encrypting data
()
Encryption key management
()
Data discovery
()
The data lifecycle
()
Data deidentification
()
Data obfuscation
()
Data suppression
()
Data destruction
()
Monitoring accounts
()
Monitoring connection requests
()
Database forensics
()
Code auditing
()
18. Compliance
Legal and compliance risks
()
Data privacy
()
General Data Protection Regulation (GDPR)
()
California Consumer Privacy Act (CCPA)
()
Data types
()
Data classification
()
Data loss prevention
()
Security policies
()
Data sovereignty and data residency
()
19. Authentication and Authorization
Identity and access management
()
Access controls
()
Usernames and access cards
()
Authentication factors
()
Multifactor authentication
()
Single sign-on and federation
()
Kerberos
()
OAuth and OpenID Connect
()
Digital certificates
()
20. Physical Security
Site and facility design
()
Data center environmental controls
()
Data center environmental protection
()
Physical access control
()
Visitor management
()
21. Logical Security
Firewalls
()
Port security
()
Zero trust architecture
()
Attack surface management
()
22. Data Systems Attacks
Preventing SQL injection
()
Data poisoning
()
Social engineering
()
Malware prevention
()
Ransomware
()
23. Domain 5: Business Continuity
Overview of the business continuity domain
()
24. Disaster Recovery Planning
Disaster recovery
()
Disaster recovery documentation
()
Disaster recovery techniques
()
Testing BC/DR plans
()
25. Backups
Backups
()
Restoring backups
()
Database dumping
()
Backup automation and testing
()
Disaster recovery sites
()
Backup retention and archiving
()
26. Domain 6: Data Integration
Overview of the data integration domain
()
27. Data Acquisition
ETL and ELT processes
()
Database connectivity
()
Service connectivity
()
Remote access and file transfer
()
Data sources
()
Text files
()
JSON data
()
XML data
()
28. Troubleshooting Data Acqusition
Troubleshooting data issues
()
Troubleshooting connectivity issues
()
Troubleshooting encryption issues
()
Troubleshooting infrastructure limitations
()
Troubleshooting programming errors
()
29. AI and Emerging Technologies
AI and analytics
()
Generative AI
()
Robotic process automation
()
Data manipulation libraries
()
Human-in-the-loop
()
Virtual data warehouses
()
30. What's Next?
Preparing for the exam
()