CompTIA DataSys+

Price
$2,475.00

Duration
5 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Add Exam Voucher
$358.00

Request More Information
Download Course Details
Course Details Only
Course Details & Schedule
Skip to Class Dates

Course Overview

This course can benefit you in two ways. If you intend to pass the CompTIA DataSys+ (Exam DS0-001) certification examination, this course can be a significant part of your preparation. But certification is not the only key to professional success in the field of database administration. Today's job market demands individuals with demonstrable skills, and the information and activities in this course can help you build your database administration skill set so that you can confidently perform your duties in any DBA role.

Course Objectives

  • Understand database types and structures.
  • Recognize standards and commands.
  • Run scripts for data and data systems.
  • Explain the impact of programming on database operations.
  • Understand database planning and design.
  • Implement, test, and deploy databases.
  • Monitor and report on database performance.
  • Understand common data maintenance processes.
  • Understand governance and regulatory compliance.
  • Secure data.
  • Secure data access.
  • Secure the database and server.
  • Classify types of attacks.
  • Plan for disaster recovery.
  • Implement backup and restore best practices.

Who Should Attend?

The Official CompTIA DataSys+ (Exam DS0-001) is the primary course you will need to take if your job responsibilities include managing, maintaining, and securing data in one or more data systems, with consideration for data storage, organization, presentation, utilization, and analysis from a technical perspective. You can take this course to prepare for the CompTIA DataSys+ (Exam DS0-001) certification examination.

United Training is committed to working as a partner with our clients. Choose United Training and take advantage of the following benefits.

  • Robust Public Enrollment Schedule. Enjoy access to hundreds of Guaranteed to Run dates across a diverse catalog of course titles.
  • Private Group Training. Let our world-class instructors come to you to deliver training at your place of business or we can present to your team online using our Virtual Instructor-Led Training platform.
  • Custom Training Solutions. Our subject matter experts can customize the class to specifically address the unique goals of your team.
  • Free Re-Takes. Most completed United Training courses carry our unbeatable Learning Guarantee. This guarantee allows students to repeat most United Training courses, if they are the same version, FREE OF CHARGE, within six months of completion of the courses. Exceptions: Cisco, Citrix, VMware, Red Hat, and courses provided by affiliated 3rd party training providers.

Learning Credits: Learning Credits can be purchased well in advance of your training date to avoid having to commit to specific courses or dates. Learning Credits allow you to secure your training budget for an entire year while eliminating the administrative headache of paying for individual classes. They can also be redeemed for a full year from the date of purchase. If you have previously purchased a Learning Credit agreement with United Training, you may use a portion of your agreement to pay for this class.

Corporate Tech Pass: Our Corporate Tech Pass includes unlimited attendance for a single person, in the following Virtual Instructor Led course types: Microsoft Office, Microsoft Technical, CompTIA, Project Management, SharePoint, ITIL, Certified Ethical Hacker, Certified Hacking Forensics Investigator, Java, Professional Development Courses and more. The full list of eligible course titles can be found at https://unitedtraining.com/eligible.

If you have questions about Learning Credits or our Corporate Tech Pass, please contact your Account Manager.

Course Prerequisites

To ensure your success in this course, you should have two to three years of hands-on experience working as a database administrator.

Agenda

Lesson 1: Understanding Database Types and Structures

  • Topic 1A: Identify Relational and Non-Relational Databases
  • Topic 1B: Understand Different Types of NoSQL Databases and Tools
  • Topic 1C: Understand Relational Database Design
  • Topic 1D: Identify Other Data Systems

Lesson 2: Recognizing Standards and Commands

  • Topic 2A: Understand Standards and Principles
  • Topic 2B: Examine Operating Systems and Command Line Scripting

Lesson 3: Running Scripts for Data and Data Systems

  • Topic 3A: Create and Alter Objects Using Data Definition Language
  • Topic 3B: Manipulate Data Using Data Manipulation Language
  • Topic 3C: Work with Transactions
  • Topic 3D: Perform Data Management Tasks

Lesson 4: Explaining the Impact of Programming on Database Operations

  • Topic 4A: Work with Views
  • Topic 4B: Understand Object Relational Mapping
  • Topic 4C: Program with SQL
  • Topic 4D: Write Functions

Lesson 5: Understanding Database Planning and Design

  • Topic 5A: Understand Types of Architecture
  • Topic 5B: Gather Data System Requirements
  • Topic 5C: Review Documentation Requirements

Lesson 6: Implementing, Testing, and Deploying Databases

  • Topic 6A: Prepare for Deployment
  • Topic 6B: Conduct Testing and Other Quality Measures
  • Topic 6C: Understand Validation Techniques and Methods

Lesson 7: Monitoring and Reporting on Database Performance

  • Topic 7A: Consider Database Connectivity Needs
  • Topic 7B: Monitor the Database
  • Topic 7C: Understand and Address Deadlocks

Lesson 8: Understanding Common Data Maintenance Processes

  • Topic 8A: Explain Patch Management
  • Topic 8B: Ensure Database Performance
  • Topic 8C: Ensure Database Integrity

Lesson 9: Understanding Governance and Regulatory Compliance

  • Topic 19A: Understand the Importance of Protecting Data and Preventing Data Loss
  • Topic 9B: Understand Data Retention Policies
  • Topic 9C: Classify Data
  • Topic 9D: Consider Global Jurisdiction and Regional Regulations
  • Topic 9E: Understand Third-Party Agreements and Release Approvals

Lesson 10: Securing Data

  • Topic 10A: Understand Data Encryption
  • Topic 10B: Understand Data Masking
  • Topic 10C: Describe Data Destruction Techniques
  • Topic 10D: Audit Data Access
  • Topic 10E: Audit Code and Changes

Lesson 11: Securing Data Access

  • Topic 11A: Understand Identity and Access Management
  • Topic 11B: Understand Access Controls
  • Topic 11C: Understand Password Policies
  • Topic 11D: Work with Service Accounts

Lesson 12: Securing the Database and Server

  • Topic 12A: Utilize Physical Security
  • Topic 12B: Utilize Logical Security

Lesson 13: Classifying Types of Attacks

  • Topic 13A: Mitigate the SQL Injection Attack
  • Topic 13B: Mitigate the Denial of Service (DoS) Attack
  • Topic 13C: Mitigate the On-Path Attack
  • Topic 13D: Mitigate the Brute Force Attack
  • Topic 13E: Mitigate Social Engineering Attacks
  • Topic 13F: Mitigate Malware

Lesson 14: Planning for Disaster Recovery

  • Topic 14A: Plan for Disaster Recovery
  • Topic 14B: Conduct DR Plan Testing
  • Topic 14C: Transition/Failback to Normal Operations

Lesson 15: Implementing Backup and Restore Best Practices

  • Topic 15A: Identify Types of Backups
  • Topic 15B: Implement a Backup Strategy
  • Topic 15C: Store and Purge Backups
 

There are no open enrollment courses currently scheduled.
Inquire about scheduling this course when it’s best for your team. Learn More about Private Group Training

 


Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
 
Contact Us about Starting Your Business Training Strategy with United Training