What is CertMaster Learn Integrated with CertMaster Labs?

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 career. A Learning Plan helps learners stay on track with your 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. Easy-to-use course management tools provide a comprehensive suite of instructor resources alongside a reporting dashboard, making course preparation and progress tracking simple and efficient.

Topics Covered

Lesson 1: Understanding Database Types and Structures

Lesson 2: Recognizing Standards and Commands

Lesson 3: Running Scripts for Data and Data Systems

Lesson 4: Explaining the Impact of Programming on Database Operations

Lesson 5: Understanding Database Planning and Design

Lesson 6: Implementing, Testing, and Deploying Databases

Lesson 7: Monitoring and Reporting on Database Performance

Lesson 8: Understanding Common Data Maintenance Processes

Lesson 9: Understanding Governance and Regulatory Compliance

Lesson 10: Securing Data

Lesson 11: Securing Data Access

Lesson 12: Securing the Database and Server

Lesson 13: Classifying Types of Attacks

Lesson 14: Planning for Disaster Recovery

Lesson 15: Implementing Backup and Restore Best Practices

Labs Available

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

License Information

• Once license 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

There are two options for adding students to your CertMaster Learn classroom setup.

Classroom Setup with Access Keys

1. You will receive student access keys via email upon purchase.
2. CompTIA will setup your institution and administrator access to the Institution Admin Dashboard, provide you with instructions for adding instructors, and communicate your institution-specific student registration instructions within 1 business day of purchase.
3. You will distribute access keys and registration instructions to students.
4. After registration students may login anytime at: https://learn.comptia.org/login

Classroom Setup with Student Upload

1. CompTIA will setup your institution and administrator access to the Institution Admin Dashboard, as well as the specific number of student seats purchased, within 1 business day of purchase.
2. As the administrator, you will add students to the platform either individually or by uploading a csv file. You have the option of either providing students with their login information or enabling them to automatically receive a registration link via email once they have been added to the platform. You will also add additional administrators (if necessary) as well as instructors. Note that not all roles will be applicable to every institution.
3. Students will login or click on the link to register.
4. After registration students may login anytime at: https://learn.comptia.org/login