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
Access Key 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
How to Access CertMaster Learn
An access key and instructions will be sent via email after your purchase is complete.