Course Overview
Skilled database administrators are needed to oversee the increasing quantity of data available to organizations. We can help you gain the skills employers are looking for to manage and secure those important assets.
CertMaster Learn is a comprehensive eLearning experience that helps learners gain the knowledge and practical skills necessary to be successful on CompTIA certification exams and in their IT careers. A learning plan helps learners stay on track with their studies, while robust analytics bring awareness of strengths and weaknesses.
CertMaster Labs make it easy for learners to practice and apply their skills in real workplace scenarios in preparation for the certification exam. All lab activities use real equipment and software, offer feedback and hints, and provide a score based on learner inputs, ultimately guiding learners to the most correct and efficient path through job tasks.
In the integrated experience, CertMaster Labs are integrated as study tasks within the CertMaster Learn learning plan, accessible through a single login and seamless workflow.
What’s included:
Exam Voucher
CertMaster Learn + Labs
CertMaster Practice
Once redeemed, this bundle will be valid for 12 months
Access keys must be redeemed within 12 months of purchase
This is a single-user license and may not be shared
A CompTIA exam voucher is a unique code that will enable you to take your exam at an authorized CompTIA Test Service Provider. Exam vouchers are used similar to a gift card. For example, employers often use vouchers to pay for their employees exams, or parents may purchase vouchers for their children.
Vouchers are non-refundable and non-returnable.
One voucher is applicable towards one exam at an authorized CompTIA Test Service Provider.
All vouchers, including any retakes, are valid for 12 months from the date of purchase unless otherwise noted.
You must register and take your exam prior to the voucher expiration date.
Voucher expiration dates cannot be extended under any circumstances.
Certification exam retirement dates supersede voucher expiration dates. CompTIA may retire certifications and corresponding exams prior to voucher expiration dates.
Visit the CompTIA website for certification exam information, including exam launch and retirement dates.
Vouchers are country and currency restricted.
CompTIA and the participating test providers are not responsible for lost or stolen vouchers.
Vouchers cannot be redeemed for cash or credit.
CompTIA vouchers may not be resold.
License Information
One access key provides access to CertMaster Learn for DataSys+ (DS0-001) with CertMaster Labs integrated throughout the course.
Once activated, the license is valid for 12 months
Access keys must be redeemed within 12 months of purchase
CompTIA CertMaster Practice is an online knowledge assessment and training companion tool to help you prepare for your CompTIA certification exam. Featuring an adaptive question-first design, CertMaster Practice quickly assesses what you already know and what you still need to learn. For those topics where you need more support, CertMaster Practice provides personalized remediation and feedback. Once you’re ready, you can demonstrate your knowledge on a timed practice test complete with performance-based questions.
Speed-up learning
Increase retention
Build confidence
Curriculum
- 2 Sections
- 19 Lessons
- 51 Weeks
- Topics Covered15
- 1.1Lesson 1: Understanding Database Types and Structures
- 1.2Lesson 2: Recognizing Standards and Commands
- 1.3Lesson 3: Running Scripts for Data and Data Systems
- 1.4Lesson 4: Explaining the Impact of Programming on Database Operations
- 1.5Lesson 5: Understanding Database Planning and Design
- 1.6Lesson 6: Implementing, Testing, and Deploying Databases
- 1.7Lesson 7: Monitoring and Reporting on Database Performance
- 1.8Lesson 8: Understanding Common Data Maintenance Processes
- 1.9Lesson 9: Understanding Governance and Regulatory Compliance
- 1.10Lesson 10: Securing Data
- 1.11Lesson 11: Securing Data Access
- 1.12Lesson 12: Securing the Database and Server
- 1.13Lesson 13: Classifying Types of Attacks
- 1.14Lesson 14: Planning for Disaster Recovery
- 1.15Lesson 15: Implementing Backup and Restore Best Practices
- Labs Available4
- 2.1Assisted 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)
- 2.2Applied 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
- 2.3Assisted 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
- 2.4Assisted 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
