Oracle Database Training Programs
Our Oracle training programs provide hands-on learning in database fundamentals, SQL & PL/SQL, performance tuning, backup strategies, and security. Designed for real-world application, these courses help participants gain practical skills for managing and optimizing Oracle environments.
Oracle Database Training Programs
Our Oracle training programs provide hands-on learning in database fundamentals, SQL & PL/SQL, performance tuning, backup strategies, and security. Designed for real-world application, these courses help participants gain practical skills for managing and optimizing Oracle environments.
Oracle Database Training Programs
Our Oracle training programs provide hands-on learning in database fundamentals, SQL & PL/SQL, performance tuning, backup strategies, and security. Designed for real-world application, these courses help participants gain practical skills for managing and optimizing Oracle environments.
DB_ORA01
Oracle Database Administration
3 days
Fundamental
Online/ In-Office
Introduction to Oracle Database
Introduction to Oracle Database
Introduction to Oracle Database
Configuring Naming Methods
Configuring Naming Methods
Configuring Naming Methods
Accessing an Oracle Database
Accessing an Oracle Database
Accessing an Oracle Database
Configuring and Administering the Listener
Configuring and Administering the Listener
Configuring and Administering the Listener
Creating an Oracle Database by Using DBCA
Creating an Oracle Database by Using DBCA
Creating an Oracle Database by Using DBCA
Configuring and Administering the Listener
Configuring and Administering the Listener
Configuring and Administering the Listener
Starting Up and Shutting Down a Database Instance
Starting Up and Shutting Down a Database Instance
Starting Up and Shutting Down a Database Instance
Creating and Managing Tablespaces
Creating and Managing Tablespaces
Creating and Managing Tablespaces
Managing Database Instances
Managing Database Instances
Managing Database Instances
Improving Space Usage
Improving Space Usage
Improving Space Usage
Oracle Net Services Overview
Oracle Net Services Overview
Oracle Net Services Overview
Creating and Managing User Accounts
Creating and Managing User Accounts
Creating and Managing User Accounts
Implementing Oracle Database Auditing
Implementing Oracle Database Auditing
Implementing Oracle Database Auditing
Introduction to Loading and Transporting Data
Introduction to Loading and Transporting Data
Introduction to Loading and Transporting Data
Using External Tables to Load and Transport Data
Using External Tables to Load and Transport Data
Using External Tables to Load and Transport Data
Automated Maintenance Tasks Overview
Automated Maintenance Tasks Overview
Automated Maintenance Tasks Overview
Backup Methods
Backup Methods
Backup Methods
Recovery Configuration
Recovery Configuration
Recovery Configuration
Configuring RMAN
Configuring RMAN
Configuring RMAN
RMAN Backups
RMAN Backups
RMAN Backups
Managing Backups
Managing Backups
Managing Backups
RMAN Complete Recovery
RMAN Complete Recovery
RMAN Complete Recovery
User Managed Backup
User Managed Backup
User Managed Backup
User Managed Recovery
User Managed Recovery
User Managed Recovery
Configuring Flashback
Configuring Flashback
Configuring Flashback
Performing Flashback Recoveries
Performing Flashback Recoveries
Performing Flashback Recoveries
Performing Flashback Database
Performing Flashback Database
Performing Flashback Database
SQL_ORA01
Oracle SQL Fundamentals
3 Days
Fundamental
Online
Muhammet Kurtoğlu (Over 20 years of database experience)
Relational Database Concepts
Explain the theoretical and physical aspects of relational databases
Explain the theoretical and physical aspects of relational databases
Explain the theoretical and physical aspects of relational databases
Map ERD components to SQL SELECT statement subclauses
Map ERD components to SQL SELECT statement subclauses
Map ERD components to SQL SELECT statement subclauses
Explain the relationship between databases and SQL
Explain the relationship between databases and SQL
Explain the relationship between databases and SQL
Restricting and Sorting Data
Apply precedence rules for operators in expressions
Apply precedence rules for operators in expressions
Apply precedence rules for operators in expressions
Limit the rows returned in a SQL statement
Limit the rows returned in a SQL statement
Limit the rows returned in a SQL statement
Sort data
Sort data
Sort data
Using Conversion Functions and Conditional Expressions
Apply NVL, NULLIF, and COALESCE functions to data
Apply NVL, NULLIF, and COALESCE functions to data
Apply NVL, NULLIF, and COALESCE functions to data
Understand data type conversion
Understand data type conversion
Understand data type conversion
Use TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Use TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Use TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Nest multiple functions
Nest multiple functions
Nest multiple functions
Retrieving Data from Multiple Tables
Use JOINs
Use JOINs
Use JOINs
Use different types of JOINs
Use different types of JOINs
Use different types of JOINs
Use equijoins
Use equijoins
Use equijoins
Use OUTER JOINs
Use OUTER JOINs
Use OUTER JOINs
Understand and use Cartesian products
Understand and use Cartesian products
Understand and use Cartesian products
Using Set Operators
Combine SELECT statements
Combine SELECT statements
Combine SELECT statements
Use ORDER BY in set operations
Use ORDER BY in set operations
Use ORDER BY in set operations
Use INTERSECT operator
Use INTERSECT operator
Use INTERSECT operator
Use MINUS operator
Use MINUS operator
Use MINUS operator
Use UNION and UNION ALL operators
Use UNION and UNION ALL operators
Use UNION and UNION ALL operators
Managing Indexes, Synonyms, Sequences, and Views
Manage indexes
Manage indexes
Manage indexes
Manage synonyms
Manage synonyms
Manage synonyms
Manage sequences
Manage sequences
Manage sequences
Manage views
Manage views
Manage views
Manage data dictionary view objects
Manage data dictionary view objects
Manage data dictionary view objects
Use data dictionary views
Use data dictionary views
Use data dictionary views
Retrieving Data Using SQL SELECT Statement
Use column aliases
Use column aliases
Use column aliases
Use SQL SELECT statement
Use SQL SELECT statement
Use SQL SELECT statement
Use concatenation, literal strings, alternative quoting, and DISTINCT keyword
Use concatenation, literal strings, alternative quoting, and DISTINCT keyword
Use concatenation, literal strings, alternative quoting, and DISTINCT keyword
Use arithmetic expressions and NULL values in SELECT statements
Use arithmetic expressions and NULL values in SELECT statements
Use arithmetic expressions and NULL values in SELECT statements
Using Single-Row Functions to Customize Output
Process strings using character functions in SELECT and WHERE clauses
Process strings using character functions in SELECT and WHERE clauses
Process strings using character functions in SELECT and WHERE clauses
Perform arithmetic on date values
Perform arithmetic on date values
Perform arithmetic on date values
Modify numbers with ROUND, TRUNC, and MOD functions
Modify numbers with ROUND, TRUNC, and MOD functions
Modify numbers with ROUND, TRUNC, and MOD functions
Manipulate dates with date functions
Manipulate dates with date functions
Manipulate dates with date functions
Reporting Aggregated Data Using GROUP BY Functions
Restrict group results
Restrict group results
Restrict group results
Create data groups
Create data groups
Create data groups
Use group functions
Use group functions
Use group functions
Subqueries in SQL
Use single-row subqueries
Use single-row subqueries
Use single-row subqueries
Use multiple-row subqueries
Use multiple-row subqueries
Use multiple-row subqueries
Update and delete rows using correlated subqueries
Update and delete rows using correlated subqueries
Update and delete rows using correlated subqueries
Managing Tables Using DML Statements
Manage database transactions
Manage database transactions
Manage database transactions
Control transactions
Control transactions
Control transactions
Perform INSERT, UPDATE, and DELETE operations
Perform INSERT, UPDATE, and DELETE operations
Perform INSERT, UPDATE, and DELETE operations
Perform multi-table inserts
Perform multi-table inserts
Perform multi-table inserts
Use MERGE statements
Use MERGE statements
Use MERGE statements
Using DDL to Manage Tables and Their Relationships
Define and work with tables
Define and work with tables
Define and work with tables
Define and manage columns and data types
Define and manage columns and data types
Define and manage columns and data types
Create tables
Create tables
Create tables
Drop columns and mark columns as UNUSED
Drop columns and mark columns as UNUSED
Drop columns and mark columns as UNUSED
Perform TRUNCATE TABLE operations
Perform TRUNCATE TABLE operations
Perform TRUNCATE TABLE operations
Use CREATE TABLE AS SELECT statements
Use CREATE TABLE AS SELECT statements
Use CREATE TABLE AS SELECT statements
Manage constraints
Manage constraints
Manage constraints
Controlling User Access
Differentiate system privileges from object privileges
Differentiate system privileges from object privileges
Differentiate system privileges from object privileges
Grant privileges on tables
Grant privileges on tables
Grant privileges on tables
Understand the difference between granting privileges and roles
Understand the difference between granting privileges and roles
Understand the difference between granting privileges and roles
A certificate of participation will be awarded by BiSoft.
SQL_ORA02
Advanced Oracle SQL
2 Days
Advanced
Online
Muhammet Kurtoğlu (Over 20 years of database experience)
Analytical Queries
Use “OVER BY” clauses in SELECT statements
Use “OVER BY” clauses in SELECT statements
Use “OVER BY” clauses in SELECT statements
Use ROW_NUMBER functions
Use ROW_NUMBER functions
Use ROW_NUMBER functions
Use LAG/LEAD functions
Use LAG/LEAD functions
Use LAG/LEAD functions
SQL Query Execution Plan Analysis
Extract and read execution plans
Extract and read execution plans
Extract and read execution plans
Detect missing or incorrect index usage
Detect missing or incorrect index usage
Detect missing or incorrect index usage
Read and analyze joins in execution plans
Read and analyze joins in execution plans
Read and analyze joins in execution plans
A certificate of participation will be awarded by BiSoft.
Empower Your Skills with Expert Training
Want to learn more about our tailored training programs? Contact us to discover the right course for your needs. Our experts are here to guide you.
Empower Your Skills with Expert Training
Want to learn more about our tailored training programs? Contact us to discover the right course for your needs. Our experts are here to guide you.
Empower Your Skills with Expert Training
Want to learn more about our tailored training programs? Contact us to discover the right course for your needs. Our experts are here to guide you.
Smart data solutions for business growth and efficiency
Company
More content
Company
Services
Product
Vispeahen
BFM
BFM4Patroni
More content