Course Description
This course can benefit you in two ways. If you intend to pass the CompTIA DataSys+ (Exam DS0-001) certification examination, this course can be a significant part of your preparation. But certification is not the only key to professional success in the field of database administration. Today's job market demands individuals with demonstrable skills, and the information and activities in this course can help you build your database administration skill set so that you can confidently perform your duties in any DBA role.
Course Objectives
- Understand database types and structures.
- Recognize standards and commands.
- Run scripts for data and data systems.
- Explain the impact of programming on database operations.
- Understand database planning and design.
- Implement, test, and deploy databases.
- Monitor and report on database performance.
- Understand common data maintenance processes.
- Understand governance and regulatory compliance.
- Secure data.
- Secure data access.
- Secure the database and server.
- Classify types of attacks.
- Plan for disaster recovery.
- Implement backup and restore best practices.
Course Outline
Lesson 1: Understanding Database Types and Structures
- Topic 1A: Identify Relational and Non-Relational Databases
- Topic 1B: Understand Different Types of NoSQL Databases and Tools
- Topic 1C: Understand Relational Database Design
- Topic 1D: Identify Other Data Systems
Lesson 2: Recognizing Standards and Commands
- Topic 2A: Understand Standards and Principles
- Topic 2B: Examine Operating Systems and Command Line Scripting
Lesson 3: Running Scripts for Data and Data Systems
- Topic 3A: Create and Alter Objects Using Data Definition Language
- Topic 3B: Manipulate Data Using Data Manipulation Language
- Topic 3C: Work with Transactions
- Topic 3D: Perform Data Management Tasks
Lesson 4: Explaining the Impact of Programming on Database Operations
- Topic 4A: Work with Views
- Topic 4B: Understand Object Relational Mapping
- Topic 4C: Program with SQL
- Topic 4D: Write Functions
Lesson 5: Understanding Database Planning and Design
- Topic 5A: Understand Types of Architecture
- Topic 5B: Gather Data System Requirements
- Topic 5C: Review Documentation Requirements
Lesson 6: Implementing, Testing, and Deploying Databases
- Topic 6A: Prepare for Deployment
- Topic 6B: Conduct Testing and Other Quality Measures
- Topic 6C: Understand Validation Techniques and Methods
Lesson 7: Monitoring and Reporting on Database Performance
- Topic 7A: Consider Database Connectivity Needs
- Topic 7B: Monitor the Database
- Topic 7C: Understand and Address Deadlocks
Lesson 8: Understanding Common Data Maintenance Processes
- Topic 8A: Explain Patch Management
- Topic 8B: Ensure Database Performance
- Topic 8C: Ensure Database Integrity
Lesson 9: Understanding Governance and Regulatory Compliance
- Topic 19A: Understand the Importance of Protecting Data and Preventing Data Loss
- Topic 9B: Understand Data Retention Policies
- Topic 9C: Classify Data
- Topic 9D: Consider Global Jurisdiction and Regional Regulations
- Topic 9E: Understand Third-Party Agreements and Release Approvals
Lesson 10: Securing Data
- Topic 10A: Understand Data Encryption
- Topic 10B: Understand Data Masking
- Topic 10C: Describe Data Destruction Techniques
- Topic 10D: Audit Data Access
- Topic 10E: Audit Code and Changes
Lesson 11: Securing Data Access
- Topic 11A: Understand Identity and Access Management
- Topic 11B: Understand Access Controls
- Topic 11C: Understand Password Policies
- Topic 11D: Work with Service Accounts
Lesson 12: Securing the Database and Server
- Topic 12A: Utilize Physical Security
- Topic 12B: Utilize Logical Security
Lesson 13: Classifying Types of Attacks
- Topic 13A: Mitigate the SQL Injection Attack
- Topic 13B: Mitigate the Denial of Service (DoS) Attack
- Topic 13C: Mitigate the On-Path Attack
- Topic 13D: Mitigate the Brute Force Attack
- Topic 13E: Mitigate Social Engineering Attacks
- Topic 13F: Mitigate Malware
Lesson 14: Planning for Disaster Recovery
- Topic 14A: Plan for Disaster Recovery
- Topic 14B: Conduct DR Plan Testing
- Topic 14C: Transition/Failback to Normal Operations
Lesson 15: Implementing Backup and Restore Best Practices
- Topic 15A: Identify Types of Backups
- Topic 15B: Implement a Backup Strategy
- Topic 15C: Store and Purge Backups
Course Prerequisites
To ensure your success in this course, you should have two to three years of hands-on experience working as a database administrator.
Course Information
Length: 5 day
Format: Lecture and Lab
Delivery Method: n/a
Max. Capacity: 16
Schedule
Contact Us
Do you have more questions? We're delighted to assist you!
Who Should Attend
The Official CompTIA DataSys+ (Exam DS0-001) is the primary course you will need to take if your job responsibilities include managing, maintaining, and securing data in one or more data systems, with consideration for data storage, organization, presentation, utilization, and analysis from a technical perspective. You can take this course to prepare for the CompTIA DataSys+ (Exam DS0-001) certification examination.
