CompTIA Data Systems (DSO-001) Cert Prep
6h 24mIntermediate2024-10-22
Authors
Mike Chapple
Teaching Professor at the University of Notre Dame
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.
Skills covered
Data PrivacyCert PrepData Science
Concepts
Introduction
- Earning your DataSys+ certification
- What you should know
- Study resources
Domain 1 - Database Fundamentals
- Overview of the database fundamentals domain
Understanding Data
- The value of data
- Structured data
- Tabular data
- Key value pairs
Data Storage
- Relational databases
- OLTP and OLAP
- Non-relational databases
Structured Query Language
- Structured Query Language
- SELECT statement
- Sorting results
- Filtering data
- Aggregating data
- String manipulation
- Working with dates
- Derived values
- Set operations
- Join operations
- Inner joins
- Joining multiple tables
- Outer joins
- Transactions and the ACID model
Database Programming
- Triggers
- Stored procedures and functions
- Views
- Scripting
- Object-relational mapping
Domain 2 - Database Deployment
- Overview of the database deployment domain
Database Planning
- Requirements gathering
- Database architecture factors
- What is the cloud
- Cloud service categories
- Database schema
- Data sources
- Design documentation
Database Implementation and Deployment
- Acquisition of assets
- Phases of deployment
- Client server architecture
- Domain Name System (DNS)
- Network ports
Database Testing
- Database quality checks
- Code execution testing
- Stress testing
- Version control testing
- Regression testing
- Negative testing
Database Validation
- Data mapping
- Data values
- Query validation
- Index analysis
- Integrity and scalability validation
Domain 3 - Database Management and Maintenance
- Overview of the database management and maintenance domain
Monitoring and Reporting
- Trends to monitor
- Baseline configuration and trending
- Activity tracking
- Transaction logs
- System logs
- Deadlock monitoring
- Connection monitoring
Database Maintenance
- Query optimization
- Index optimization
- Patch management
- Database integrity checks
- Data corruption checks
- Audit log review
- Performance tuning
- Load balancing
- Change management
Database Documentation
- Maintaining data dictionaries
- Maintenance documentation
- Standard operating procedure (SOP) documentation
- Documentation tools
Data Management
- Data redundancy
- Data sharing
Domain 4 - Data and Database Security
- Overview of the data and database security domain
Data Security Concepts
- Encrypting data
- Data discovery
- The data lifecycle
- Data de-identification
- Data obfuscation
- Monitoring accounts
- Monitoring connection requests
- Code auditing
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
Authentication and Authorization
- Identity and access management
- Usernames and access cards
- Biometrics
- Authentication factors
- Multifactor authentication
- Password policies
- Need to know and least privilege
- Privileged account management
Physical Security
- Site and facility design
- Data center environmental controls
- Data center environmental protection
- Physical access control
- Visitor management
Logical Security
- Firewalls
- Port security
Data Systems Attacks
- Preventing SQL injection
- Brute force attacks
- Denial-of-service attacks
- Eavesdropping attacks
- Impersonation attacks
- Malware prevention
- Ransomware
Domain 5 - Business Continuity
- Overview of the business continuity domain
Disaster Recovery Planning
- Disaster recovery
- Disaster recovery documentation
- Disaster recovery techniques
- Testing BC DR plans
Backups
- Backups
- Restoring backups
- Database dumping
- Backup automation and testing
- Disaster recovery sites
- Backup retention
Conclusion
- Preparing for the exam