IMTS Training Institute (New)

Menu
Click here to verify with ID.me
thumbnail
Cybersecurity

CompTIA DataSys+ and MSSQL and Oracle Database Bundle

profile
Instructor

Online Instructors (Various)

Reviews 0 (0 Reviews)

Course Overview

High-level description: The CompTIA DataSys+ and MSSQL and Oracle Database Bundle provides comprehensive training for individuals seeking to excel in database management and systems administration. This blended bundle includes custom self-paced online instructor-led training (ILT) courses for Microsoft SQL Server 2019 Administration and Oracle 12c OCP, combined with engaging video lessons, text lessons, section quizzes, performance-based lab simulations, and comprehensive exam practice. The bundle also includes an exam voucher and an exam pass guarantee for DataSys+: if you don’t pass the DataSys+ exam on the first try, we will provide another 12 months of access to our custom online self-paced ILT along with an additional exam voucher.

Recommended Study Sequence: We recommend you start with ITI’s Custom Online Self-Paced ILT for MSSQL and Oracle Database, followed by the integrated CompTIA CertMaster Learn and Labs for DataSys+.

CTI Custom Online Self-Paced ILT Descriptions:

Microsoft SQL Server 2019 Administration: Master SQL Server administration with our comprehensive course designed to provide the skills needed to manage MS SQL databases effectively.

Course Highlights:

  1. Duration: 6+ hours
  2. Content: 40+ On-demand Videos
  3. Exam Prep: 70+ Prep Questions
  4. Certificate of Completion for Microsoft SQL Server 2019 Administration

Topics Areas Included:

  1. SQL Server Installation
  2. Data Storage Management
  3. Data Recovery Planning
  4. Monitoring and Performance Tuning
  5. Security Management
  6. Maintenance Tasks

Modules:

  1. Module 1: Installation
  2. Module 2: Data Storage
  3. Module 3: Data Recovery
  4. Module 4: Monitoring
  5. Module 5: Security
  6. Module 6: Maintenance

Oracle 12c OCP: Gain expertise in Oracle database administration with our Oracle 12c OCP course (covers exam objectives for 1Z0-061 & 1Z0-062), focusing on installation, administration, and optimization.

Oracle 12c OCP 1Z0-061- SQL Fundamentals Course Highlights:

  1. Duration: 16+ hours
  2. Content: 44+ On-demand Videos
  3. Exam Prep: 240+ Prep Questions
  4. Certificate of Completion for Oracle 12c OCP 1Z0-061: Installation and Administration

Topics Areas Included:

  1. Introduction to Oracle 12c SQL Fundamentals
  2. Structure of SQL and basic SELECT statements
  3. Retrieving data with WHERE and ORDER BY clauses
  4. SQL functions, including single row and aggregate functions
  5. Subqueries and their types
  6. Data Manipulation Language (DML) operations: adding, changing, and deleting data
  7. Data Control Language (DCL): security and object privileges
  8. Data Definition Language (DDL): creating objects, sequences, indexes, and views
  9. Combining queries
  10. Comprehensive review of Oracle 12c SQL Fundamentals

Modules

  1. Module 1: Introduction To Oracle 12c SQL Fundamentals
  2. Module 2: Retrieving Data
  3. Module 3: SQL Functions
  4. Module 4: Subqueries
  5. Module 5: Data Manipulation Language
  6. Module 6: Data Control Language
  7. Module 7: Data Definition Language
  8. Module 8: Combining Queries
  9. Module 9: Oracle 12C SQL Fundamentals Review

Labs Included (10 hours):

  1. Features of Oracle Database 12c
  2. Retrieving Data Using SQL Statements
  3. Restricting and Sorting Data
  4. Using Single Row Functions to Customize Output
  5. Conversion Functions and Conditional Expressions
  6. Reporting Aggregated Data Using Group Function
  7. Displaying Data from Multiple Tables using JOIN
  8. Using Subqueries
  9. Managing Tables using DML Statements
  10. Introduction to DDL Language

1Z0-062 Oracle Database 12c – Installation and Administration Course Highlights:

  1. Duration: 19+ hours
  2. Content: 50+ On-demand Videos
  3. Exam Prep: 55+ Prep Questions
  4. Certificate of Completion for Oracle 12c OCP 1Z0-062: Installation and Administration

Topics Areas Included:

  1. Oracle Database Installation
  2. Database Architecture
  3. Managing Database Instances
  4. Performance Monitoring and Tuning
  5. Backup and Recovery Techniques
  6. Security Implementation

Modules:

  1. Module 1: Database Concepts And Tools
  2. Module 2: Memory Structure
  3. Module 3: Tables
  4. Module 4: Indexes
  5. Module 5: Constraints And Triggers
  6. Module 6: Users
  7. Module 7: Internal Structures
  8. Module 8: Starting Up and Shutting Down Database
  9. Module 9: Critical Storage Files
  10. Module 10: Data Manipulation Language
  11. Module 11: Data Concurrency
  12. Module 12: BackUp And Recovery
  13. Module 13: Installation
  14. Module 14: Course Review

1Z0-062 Labs (18 hours):

  1. Oracle Database Instances
  2. Configuring an Oracle Network Environment
  3. Managing Database Storage Structures
  4. Administering User Security
  5. Managing Space
  6. Managing Data Concurrency and Undo
  7. Implementing Oracle Database Auditing
  8. Using Backup and Recovery Concepts
  9. Performing Database Recovery
  10. Moving Data
  11. Managing Database Performance
  12. Managing Resource Using Database Resource Manager
  13. Automating Tasks Using Oracle Scheduler
  14. Installing Oracle Grid Infrastructure and Using Oracle Restart
  15. Installing Oracle 12c
  16. Creating an Oracle Database Using DBCA
  17. Upgrading to Oracle 12c
  18. Migrating Data Using Oracle Data Pump

CompTIA DataSys+ CertMaster Learn and Labs Description: CertMaster Learn is a comprehensive eLearning experience that helps learners gain the knowledge and practical skills necessary to be successful on CompTIA certification exams and in their IT career. A Learning Plan helps learners stay on track with their studies, while robust analytics bring awareness of strengths and weaknesses.

CertMaster Labs make it easy for learners to practice and apply their skills in real workplace scenarios in preparation for the certification exam. All lab activities use real equipment and software, offer feedback and hints, and provide a score based on learner inputs, ultimately guiding learners to the most correct and efficient path through job tasks.

In the integrated experience, CertMaster Labs are integrated as Study Tasks within the CertMaster Learn Learning Plan, accessible through a single login and seamless workflow.

Lessons cover all exam objectives with integrated videos:

  1. Hundreds of practice questions test your knowledge
  2. Performance-based questions apply what you’ve learned in a scenario
  3. Assisted Labs guide you step-by-step through tasks
  4. Applied Labs present goal-oriented scenarios and require critical thinking and analysis
  5. Flashcards ensure you know the terminology and acronyms required for the exam
  6. The Learning Plan keeps you on track with your studies

Topics Covered:

  1. Lesson 1: Understanding Database Types and Structures
  2. Lesson 2: Recognizing Standards and Commands
  3. Lesson 3: Running Scripts for Data and Data Systems
  4. Lesson 4: Explaining the Impact of Programming on Database Operations
  5. Lesson 5: Understanding Database Planning and Design
  6. Lesson 6: Implementing, Testing, and Deploying Databases
  7. Lesson 7: Monitoring and Reporting on Database Performance
  8. Lesson 8: Understanding Common Data Maintenance Processes
  9. Lesson 9: Understanding Governance and Regulatory Compliance
  10. Lesson 10: Securing Data
  11. Lesson 11: Securing Data Access
  12. Lesson 12: Securing the Database and Server
  13. Lesson 13: Classifying Types of Attacks
  14. Lesson 14: Planning for Disaster Recovery
  15. Lesson 15: Implementing Backup and Restore Best Practices

Labs Available:

  1. Assisted Lab: Exploring the Lab Environment
  2. Assisted Lab: Exploring a Database Environment
  3. Assisted Lab: Using Command Prompt and PowerShell
  4. Assisted Lab: Using Data Definition Language (DDL)
  5. Assisted Lab: Using Data Manipulation Language (DML)
  6. Assisted Lab: Using Transaction Control Language (TCL)
  7. Applied Lab: Creating and Manipulating Databases and Data
  8. Assisted Lab: Using Stored Procedures and Triggers
  9. Assisted Lab: Using GROUP BY to Group and Aggregate Data
  10. Assisted Lab: Creating Views with Functions
  11. Applied Lab: Creating Views and Building Functions
  12. Assisted Lab: Diagramming Databases
  13. Assisted Lab: Installing and Configuring Database Connectivity
  14. Assisted Lab: Validating Data
  15. Assisted Lab: Monitoring Databases
  16. Applied Lab: Configuring and Monitoring Databases
  17. Assisted Lab: Optimizing Queries
  18. Assisted Lab: Ensuring Data Integrity with Constraints
  19. Assisted Lab: Masking Data Using Pseudonymization and Anonymization
  20. Assisted Lab: Using Queries to Conduct Security Audits
  21. Assisted Lab: Using Queries for Code Review and Code Auditing
  22. Assisted Lab: Implementing Role-Based Access
  23. Assisted Lab: Reducing Privileges for Users
  24. Assisted Lab: Rewriting Queries to Prevent SQL Injection
  25. Assisted Lab: Backing Up and Restoring Databases with Backup Validation
  26. Applied Lab: Creating Roles and Establishing a Backup Plan

Product and License Information:

  1. One license provides access to CertMaster Learn for DataSys+ (DS0-001) with CertMaster Labs integrated throughout the course and ITU courses/labs.
  2. Access keys must be redeemed within 12 months of purchase
  3. Once redeemed, licenses will be valid for 12 months

How to Access Courses and Labs: An access key and instructions will be sent via email after your purchase is complete.

Exam Voucher and Exam Pass Guarantee (DataSys+ only): This bundle includes an exam voucher and an exam pass guarantee for DataSys+: if you don’t pass the DataSys+ exam on the first try, we will provide another 12 months of access to our custom online self-paced ILT along with an additional exam voucher. To qualify for the exam pass guarantee, you must show proof of completing all training materials, including course content, labs, and practice prep questions, before taking your exam.

Original price was: $1,999.00.Current price is: $1,499.00.
  • Skill Intermediate
  • Last Update November 11, 2024