COMPTIA DATASYS+

COURSE DESCRIPTION

The CompTIA DataSys+ (DS0-001) certification exam certifies that the successful candidate has the knowledge and skills required to deploy, manage, and maintain databases, including employing the fundamentals of scripting and programming in a database environment while using security and business continuity best-practices.

RECOMMENDED EXPERIENCE

• No prerequisites, but 2-3 years of experience in a database administrator role is recommended.

SKILLS YOU WILL LEARN

• Database Fundamentals – A solid understanding of database structure types and the ability to develop, modify and run code provides the groundwork for database administrators to gather, store, and drive data assets.
• Database Deployment – Compare and contrast the different aspects of database planning and design and explain the various phases of the implementation, testing, and deployment of collected data.
• Database Management and Maintenance – Understand the purpose of monitoring and reporting database performance, explain common database maintenance processes, and produce critical documentation. 
• Data and Database Security – Secure databases, protect against attacks, and control authorization while ensuring governance and regulatory compliance.

WHAT’S INCLUDED IN THE TRAINING?

• E-Book
• Certification Exam Voucher
• Learning progress analytics and reporting
• Certified Best Trainer
• Official Lab 1 Year access
• Certificate of Training Completion

COURSE OUTLINE

• Module 01: Understanding Database Types and Structures
• Module 02: Recognizing Standards and Commands
• Module 03: Running Scripts for Data and Data Systems
• Module 04: Explaining the Impact of Programming on Database Operations
• Module 05: Understanding Database Planning and Design
• Module 06: Implementing, Testing, and Deploying Databases
• Module 07: Monitoring and Reporting on Database Performance
• Module 08: Understanding Common Data Maintenance Processes
• Module 09: Understanding Governance and Regulatory Compliance
• Module 10: Securing Data
• Module 11: Securing Data Access
• Module 12: Securing the Database and Server
• Module 13: Classifying Types of Attacks
• Module 14: Planning for Disaster Recovery
• Module 15: Implementing Backup and Restore Best Practices

INTEGRATED LABS

• Assisted Lab: Exploring the Lab Environment
• Assisted Lab: Exploring a Database Environment
• Assisted Lab: Using Command Prompt and PowerShell
• Assisted Lab: Using Data Definition Language (DDL)
• Assisted Lab: Using Data Manipulation Language (DML)
• Assisted Lab: Using Transaction Control Language (TCL)
• Applied Lab: Creating and Manipulating Databases and Data
• Assisted Lab: Using Stored Procedures and Triggers
• Assisted Lab: Using GROUP BY to Group and Aggregate Data
• Assisted Lab: Creating Views with Functions
• Applied Lab: Creating Views and Building Functions
• Assisted Lab: Diagramming Databases
• Assisted Lab: Installing and Configuring Database Connectivity
• Assisted Lab: Validating Data
• Assisted Lab: Monitoring Databases
• Applied Lab: Configuring and Monitoring Databases
• Assisted Lab: Optimizing Queries
• Assisted Lab: Ensuring Data Integrity with Constraints
• Assisted Lab: Masking Data Using Pseudonymization and Anonymization
• Assisted Lab: Using Queries to Conduct Security Audits
• Assisted Lab: Using Queries for Code Review and Code Auditing
• Assisted Lab: Implementing Role-Based Access
• Assisted Lab: Reducing Privileges for Users
• Assisted Lab: Rewriting Queries to Prevent SQL Injection
• Assisted Lab: Backing Up and Restoring Databases with Backup Validation
• Applied Lab: Creating Roles and Establishing a Backup Plan

Please contact us for the schedules and for booking a private class.

Inquire Now