P3688 – Oracle Database 12c: SQL and PL/SQL Fundamentals

  • Duration: 5 days
Categories:

Curriculum

  • Module 1: Introduction
  • Module 2: Retrieve Data using the SQL SELECT Statement
  • Module 3: Restricted and Sorted Data
  • Module 4: Usage of Single-Row Functions to Customize Output
  • Module 5: Conversion Functions and Conditional Expressions
  • Module 6:Aggregated Data Using the Group Functions
  • Module 7: Display Data From Multiple Tables
  • Module 8: Usage of Subqueries to Solve Queries
  • Module 9: SET Operators
  • Module 10: Data Manipulation
  • Module 11: DDL Statements to Create and Manage Tables
  • Module 12: Other Schema Objects
  • Module 13: Introduction to PL/SQL
  • Module 14: PL/SQL Identifiers
  • Module 15: Write Executable Statements
  • Module 16: Interaction with the Oracle Server
  • Module 17: Control Structures
  • Module 18: Usage of Composite Data Types
  • Module 19: Explicit Cursors
  • Module 20: Exception Handling
  • Module 21: Stored Procedures and Functions

Leave feedback about this

Related Courses

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

Overview The Oracle VM Server for x86: Implementation course teaches you how to enhance cloud effectiveness with rapid deployment of cloud resources and applications. You will learn how to administer, redistribute, troubleshoot and protect Oracle VM resources to ensure seamless and continuous access of your applications. Oracle VM offers a…
0
Free

D74763 – Oracle VM with Oracle VM Server for x86 Seminar

Overview This seminar tells you how to build a virtualization platform using the Oracle VM Manager and Oracle VM Server for x86 and to sustain the deployment of highly configurable, inter-connected virtual machines. The seminar is designed for students who are new to Oracle VM and who wish to get…
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