Curriculum
- 2 Sections
- 19 Lessons
- 51 Weeks
Expand all sectionsCollapse all sections
- 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) Applied Lab: Creating and Manipulating Databases and Data
- 2.2Assisted 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
- 2.3Assisted 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
Lesson 15: Implementing Backup and Restore Best Practices
Prev
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
Next