WITH VERIDATA IT WORKSHOPS
Easily Adapt To New Technologies!
You can quickly adapt to emerging technologies with Veridata IT Workshops. Instead of being a passive listener, you can be an active participant with our workshops, which are offered to you practically instead of classical methods.
Trainings & Workshops
3 days
Module 1: Querying Data with a SELECT Statement
Module 2: Restricting and Sorting Data in a SELECT Statement
Module 3: Uses of Single-Row Functions
Module 4: Conditional Expressions and Conversion Functions
Module 5: Group Functions
Module 6: JOINS Operations
Module 7: Subqueries Transactions
3 days
Module 1: PL/SQL descriptors
Module 2: Writing executable sentences
Module 3: Control Structures
Module 4: ExplicitCursors
Module 5: Error Handling
Module 6: Procedures and Functions
Module 7: Packages
3 days
Module 1: PL/SQL Programming Concepts: Review
Module 2: Designing PL/SQL Code
Module 3: Overview of Collections
Module 4: Using Collections
Module 5: Manipulating Large Objects
Module 6: Using Advanced Interface Methods
Module 7: Performance and Tuning
Module 8: Improving Performance with Caching
Module 9: Analyzing PL/SQL Code
Module 10: Profiling and Tracing PL/SQL Code
2 days
Module 1: Using Enterprise Manager and RMAN
Module 2: Required configurations for Database Recoverability
Module 3: Using RMAN RecoveryCatalog
Module 4: Backup
Module 5: Return and Recovery
Module 6: PerformingvRecovery
Module 7: Using Data Recovery Advisor
Module 8: Flashback Technologies
2 days
Module 1: Oracle Data Guard
Module 2: Creating the Physical Standby Database
Module 3: Oracle Data Guard Broker
Module 4: Creating a Logical Standby Database
Module 5: Creating Snapshot Standby Database
Module 6: Oracle Active Data Guard
Module 7: Configuring Data Protection Modes
Module 8: Role Transitions
Module 9: Monitoring Data Guard Configuration2
3 days
Module 1: Oracle Database Architecture
Module 2: Oracle Enterprise Linux Installation
Module 3: Linux Operating System Configuration
Module 4: Oracle Grid Infrastructure Software Installation
Module 5: Oracle Database RDBMS Software Installation and Configuration
Module 6: Oracle Net Services
Module 7: User Account Management
Module 8: Introduction to Oracle Database Administration
3 days
Module 1: Oracle Database Performance Management
Module 2: Database Backup and Recovery with RMAN
Module 3: Flashback Technology
Module 4: Oracle ASM
Module 5: Data Pump (Export/Import)
Module 6: Automating Database Jobs
Module 7: Oracle Resource Management
3 days
Module 1: What is PostgreSQL?
Module 2: PostgreSQL Cluster Structure
Module 3: PostgreSQL System Architecture
Module 4: PostgreSQL Data Dictionary
Module 5: Installation
Module 6: Command Line Tools
Module 7: Database Creation and SQL Fundamentals in PostgreSQL
Module 8: PostgreSQL Configuration File
Module 9: PostgreSQL Security and Access File
Module 10: User and Authorization
Module 11: Concept of Schema in PostgreSQL
Module 12: Creating a Tablespace
Module 13: Data export and import as dump
2 days
Module 1: MongoDB Architecture and Installation
Module 2: MongoDB Compass and CRUD Operations
Module 3: Schema Design and Data Modeling
Module 4: Management
Module 5: Scalability and Availability
Module 6: Indexing and Aggregation Framework
Module 7: Application Development and MongoDB Tools
Module 8: MongoDB Additional Concepts
2 days
Module 1: Authentication Transactions
Module 2: Authorization and Encryption Transactions
Module 3: Auditing Procedures
Module 4: Replication and Sharding Management
2 days
Module 1: Introduction to Couchbase and NOSQL Database
Module 2: Data Modeling with Coucbase
Module 3: Coucbase Scalability and Usability
Module 4: Coucbase Environmental Monitoring Tools
Module 5: Query Plan review and Database Performance improvement
Module 6: Application Development and Coucbase Tools
3 days
Module 1: SQL Server Introduction
Module 2: SQL Server Installation
Module 3: Database Operations
Module 4: The Concept of Index in SQL Server
Module 5: Views
Module 6: Stored Procedures
Module 7: User Defined Function
Module 8: Transaction Concept / OLTP Systems
Module 9: Triggers
Module 10: DDL Triggers
Module 11: Server Triggers
3 days
Module 1: Advanced SELECT operations Functions
Module 2: Sub Queries (Nested/Sub Queries)
Module 3: Sub Queries (Nested/Sub Queries)
Module 4: The Concept of Index in SQL Server
Module 5: Views
Module 6: Stored Procedures
- Module 7: Performance Monitoring and Improvement