This Oracle Database: SQL and PL/SQL Fundamentals training delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You'll explore the concepts of relational databases.
Start learning today!
Click Hereto customize your Training
Private training brings the classroom or virtual classroom experience to your office or a preferred offsite location. Convenient, practical, and effective training tailored to your company's needs.
If you have multiple locations, please list them in the comments section.
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
This course is not associated with any Certification.