CompTIA DataSys+

Price
$2,475.00 USD

Duration
5 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Add Exam Voucher
$358.00

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.
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

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 New Horizons, you may use a portion of your agreement to pay for this class.

If you have questions about Learning Credits, please contact your Account Manager.

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://www.newhorizons.com/eligible.

If you have questions about 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
 

Upcoming Class Dates and Times

Apr 29, 30, May 1, 2, 3
8:00 AM - 4:00 PM
ENROLL $2,475.00 USD
Jul 22, 23, 24, 25, 26
8:00 AM - 4:00 PM
ENROLL $2,475.00 USD
Oct 21, 22, 23, 24, 25
8:00 AM - 4:00 PM
ENROLL $2,475.00 USD
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
 
Contact Us about Starting Your Business Training Strategy with New Horizons