Introduction
  • Oracle SQL Developer Download and Installing
  • Create Connection
Working with Database Objects
  • Create Table with SQL
  • Creating Tables Using Table Dialog
  • Copy Table to Table and SQL Dialog
  • Adding a new column to the table
  • Deleting a Table
Data Access
  • Receive Columns
  • Getting rows
  • Oracle SQL Query Builder
  • JOIN 's Understanding
  • ON CLAUSE with the JOIN Operation
  • WHERE CLAUSE with the JOIN Operation
  • Writing a Query That Joins Multiple Tables
  • Character Functions
  • Numeric Functions
  • Date Functions
  • Date Formatting
  • NVL Function
  • Use of Group Functions
  • Grouped Data Reports
  • Use the HAVING clause
Data Processing
  • Add Single Line Data
  • Adding Multi-Line Data
  • Update Data
  • Delete Data
  • Excel to Export
  • Export to DDL
Adding Components PLSQL
  • Create DML Trigger
  • Manage Trigger
  • Create Stored Procedure
  • Use of Function