D80178 – Oracle Database: Introduction to SQL/PLSQL Accelerated

  • Duration: 10 weeks
Categories:
  • Introduction to Oracle Database
  • Retrieve Data using the SQL SELECT Statement
  • Learn to Restrict and Sort Data
  • Usage of Single-Row Functions to Customize Output
  • Invoke Conversion Functions and Conditional Expressions
  • Aggregate Data Using the Group Functions
  • Display Data From Multiple Tables Using Joins
  • Use Sub-queries to Solve Queries
  • The SET Operators
  • Data Manipulation Statements
  • Use of DDL Statements to Create and Manage Tables
  • Other Schema Object
  • Introduction to PL/SQL
  • Declare PL/SQL Identifiers
  • Write Executable Statements
  • Interaction with the Oracle Server
  • Control Structures
  • Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures
  • Stored Functions and Debugging Subprograms

Leave feedback about this

Related Courses

Free

D75231 – Oracle VM Essentials Overview Seminar

Introduction to Oracle VM Server Virtualization and Management Concepts overview Defining Virtualization Server Virtualization Techniques Hypervisor Vs Virtualization Server Advantages to Virtualization Oracle VM Performance Inside the Virtualization Server Guest OS Considerations for Virtualization Security implications with Virtualization Lifecycle Management – Templates Three Advanced VM Creation Methods Oracle VM’s Directory…
0
Free

D82656 – Oracle VM Server for x86: Implementation Ed 2

Lesson 1: Oracle VM Manager UI and Oracle VM CLI Lesson 2: Oracle VM Web Services Lesson 3: Managing Virtual Machines Lesson 4: Oracle VM Guest Additions Lesson 5: Operations Lesson 6: Troubleshooting Lesson 7: Backup and Restore D/R Concepts
0
Free

D74763 – Oracle VM with Oracle VM Server for x86 Seminar

Introducing Oracle VM with Oracle VM Server for x86 Server Virtualization Oracle VM Components Oracle VM Features Oracle VM Benefits Planning and Installation Planning Installation Hardware and Software Requirements Network and Storage Planning Installation Processes Post-Installation Tasks Managing Servers and Networks Discovering Oracle VM Servers Managing Oracle VM Servers Network…
0
Free

D68549 – Exadata and Database Machine Administration Seminar

Introduction Exadata Overview Exadata Architecture Exadata Configuration Exadata Performance Monitoring and Maintenance Exadata and I/O Resource Management Optimizing Database Performance with Exadata Database Machine Overview and Architecture Database Machine Configuration Migrating Databases to Database Machine Bulk Data Loading with Database Machine Backup and Recovery with Database Machine Monitoring and Maintaining…
0
Free

P9410 – Oracle Access Management 12c: Administration Essentials Ed 1

Module 1: Overview of Access Manager Module 2: Installation and Configuration Module 3: System Configuration: Servers, Datasources and Agents Module 4: Policy Configuration: Shared Components and Application Domains Module 5: SSO and Session Management Module 6: Using Oracle Access Manager With WebLogic Applications Module 7: Auditing and Logging Module 8:…
0
Free

D75231 – Oracle VM Essentials Overview Seminar

Introduction to Oracle VM Server Virtualization and Management Concepts overview Defining Virtualization Server Virtualization Techniques Hypervisor Vs Virtualization Server Advantages to Virtualization Oracle VM Performance Inside the Virtualization Server Guest OS Considerations for Virtualization Security implications with Virtualization Lifecycle Management – Templates Three Advanced VM Creation Methods Oracle VM’s Directory…
0
Free

D82656 – Oracle VM Server for x86: Implementation Ed 2

Lesson 1: Oracle VM Manager UI and Oracle VM CLI Lesson 2: Oracle VM Web Services Lesson 3: Managing Virtual Machines Lesson 4: Oracle VM Guest Additions Lesson 5: Operations Lesson 6: Troubleshooting Lesson 7: Backup and Restore D/R Concepts
0
Free

D74763 – Oracle VM with Oracle VM Server for x86 Seminar

Introducing Oracle VM with Oracle VM Server for x86 Server Virtualization Oracle VM Components Oracle VM Features Oracle VM Benefits Planning and Installation Planning Installation Hardware and Software Requirements Network and Storage Planning Installation Processes Post-Installation Tasks Managing Servers and Networks Discovering Oracle VM Servers Managing Oracle VM Servers Network…
0
Free

D68549 – Exadata and Database Machine Administration Seminar

Introduction Exadata Overview Exadata Architecture Exadata Configuration Exadata Performance Monitoring and Maintenance Exadata and I/O Resource Management Optimizing Database Performance with Exadata Database Machine Overview and Architecture Database Machine Configuration Migrating Databases to Database Machine Bulk Data Loading with Database Machine Backup and Recovery with Database Machine Monitoring and Maintaining…
0
Free

P9410 – Oracle Access Management 12c: Administration Essentials Ed 1

Module 1: Overview of Access Manager Module 2: Installation and Configuration Module 3: System Configuration: Servers, Datasources and Agents Module 4: Policy Configuration: Shared Components and Application Domains Module 5: SSO and Session Management Module 6: Using Oracle Access Manager With WebLogic Applications Module 7: Auditing and Logging Module 8:…
0
Free

D75231 – Oracle VM Essentials Overview Seminar

Introduction to Oracle VM Server Virtualization and Management Concepts overview Defining Virtualization Server Virtualization Techniques Hypervisor Vs Virtualization Server Advantages to Virtualization Oracle VM Performance Inside the Virtualization Server Guest OS Considerations for Virtualization Security implications with Virtualization Lifecycle Management – Templates Three Advanced VM Creation Methods Oracle VM’s Directory…
0
Free

D82656 – Oracle VM Server for x86: Implementation Ed 2

Lesson 1: Oracle VM Manager UI and Oracle VM CLI Lesson 2: Oracle VM Web Services Lesson 3: Managing Virtual Machines Lesson 4: Oracle VM Guest Additions Lesson 5: Operations Lesson 6: Troubleshooting Lesson 7: Backup and Restore D/R Concepts
0
Free

D74763 – Oracle VM with Oracle VM Server for x86 Seminar

Introducing Oracle VM with Oracle VM Server for x86 Server Virtualization Oracle VM Components Oracle VM Features Oracle VM Benefits Planning and Installation Planning Installation Hardware and Software Requirements Network and Storage Planning Installation Processes Post-Installation Tasks Managing Servers and Networks Discovering Oracle VM Servers Managing Oracle VM Servers Network…
0
prev
next