Course Overview This course can benefit you in two ways.
Description
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.
Prerequisites
To ensure your success in this course, you should have two to three years of hands-on experience working as a database administrator.
Course Outline
Database Fundamentals
Understand database structure types while developing, modifying and running structured query language (SQL) code, providing the groundwork to gather, store, and drive data assets on any operating system.
Data and Database Security
Secure databases, protect against attacks, and control authorization while ensuring governance and regulatory compliance.
Database Deployment
Compare and contrast the different aspects of database design and planning and explain the various phases of the implementation, testing, deployment and optimization of collected data.
Business Continuity
Prepare for and recover from incidents by implementing best practices for disaster recovery, backup and restoration of database management systems.
Database Management and Maintenance
Learn the purpose of monitoring and reporting database performance, explain common database maintenance processes, and produce critical documentation.
