Online Web-Based Training Services

The Vendor is required to provide online web-based training on an as-needed basis.
- Available online training courses
•    The state reserves the right to request additional training in other software and web-based technology training programs as needed throughout the resulting contract. 
•    These courses will be scheduled directly through the contractor’s site and at the times available online.
•    Instructor-led online training will be based upon:
o    1 to 15 students per class
•    There are no guaranteed minimum or maximum number of training sessions or participating students that the agency is committed to purchasing under this contract. 
•    Reimbursement will be based on actual number of courses taken and students who attend.
- Providing instructor-led online web based training in all of the following information technology areas
•    Java
•    Crystal reports
•    C#
•    Asp.net
•    SQL
•    Oracle systems administration
•    Oracle database administration
•    Oracle enterprise manager cloud control
- Java training objectives
•    The JDK directory structure
•    Data types and variables
•    Primitive data types
•    Declarations
•    Variable names
•    Numeric literals
•    Character literals
•    String
•    String literals
•    Arrays
•    Non-primitive data types
•    The dot operator
•    Operators and expressions
•    Control flow
•    Methods
•    Object-oriented programming
•    Objects and classes
•    Using java objects
•    Inheritance in java
•    Advanced inheritance and language constructs (including enumerated types, abstract classes, interfaces, collections)
•    Packages
•    Exception handling
•    Input and output streams
•    Core collection classes
•    Collection sorting and tuning
•    Inner classes
•    Introduction to JDBC
•    Introduction to threads, and
•    JDBC SQL programming
- Crystal reports training objectives
•    The crystal report writer structure
•    Designing a report
•    Setting up data sources
•    Inserting fields
•    Creating and inserting special fields
•    Changing text object properties
•    Changing date properties
•    Setting up and inserting a selection formula
•    Using component filters
•    Sorting and grouping data
•    Creating summary and grand totals
•    Inserting formula fields
•    Using conditional formatting and selection formulas
•    Using functions
•    Nested and conditional statements, and
•    Printing and exporting a report
- SQL training objectives
•    Relational database basics
•    Simple selects
•    Advanced selects
•    Subqueries, joins and unions
•    Conditional processing with case
•    Use SQL with oracle databases (PLSQL)
•    Use SQL with IBM databases
- Oracle database administration training objectives
•    Understand oracle database and DBCS architecture
•    Install, configure, and deploy oracle 19c environments
•    Manage users, security settings, and auditing policies
•    Perform backup and recovery operations using RMAN
•    Monitor performance and move data across systems efficiently
•    Overview of oracle cloud infrastructure (OCI)
•    Provision and manage DBCS instances
•    Install software using OUI
•    Configure initialization parameters
•    Create and configure databases
•    Manage users, roles, and privileges
•    Implement profiles and password policies
•    Configure auditing settings and review logs
•    Understand backup strategies
•    Use RMAN for full and incremental backups
•    Perform database recovery
•    Use data pump for import and export
•    Move data with SQL*loader
•    Implement transportable tablespaces
•    Monitor with AWR and enterprise manager
•    Identify performance issues
•    Tune SQL and manage memory
- Oracle enterprise manager cloud control training objectives
•    Use the job system to create and manage jobs to automate commonly performed tasks
•    View, search and compare configurations
•    Manage targets patching
•    Explain compliance policies and evaluate policy violations
•    Use bi publisher to generate custom reports
•    Navigate and monitor the overall health of your cloud control system
•    Setup targets monitoring, alerts and notifications
•    Organize targets and groups.