In this Oracle Database: SQL and PL/SQL Fundamentals training course, you will learn the fundamentals of relational databases, SQL & PL/SQL programming language. You will also learn how to write queries against single and multiple tables, manipulate data in tables, and create database objects.
Important notice about this training
This training is run over 3 + 2 days on these dates:
• 16-18 October: The first 3 days of this course
Oracle Database: Introduction to SQL
• 13-14 November: The first 2 days of this course
Oracle Database: Program with PL/SQL
Course objectives:
• Write queries against single and multiple tables, manipulate data in tables and create database objects.
• Use single row functions to customize output.
• Invoke conversion functions and conditional expressions.
• Use group functions to report aggregated data.
• Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
• Develop anonymous PL/SQL blocks, stored procedures and functions.
• Declare identifiers and trap exceptions.
• Use DML statements to manage data.
• Use DDL statements to manage database objects.
• Declare PL/SQL Variables.
Audience:
• Administrator
• Analyst
• Developer
Prerequisites:
• Familiarity with data processing concepts and techniques
Course content:
• Introduction
• Retrieve Data using the SQL SELECT Statement
• Restricted and Sorted Data
• Usage of Single-Row Functions to Customize Output
• Conversion Functions and Conditional Expressions
Module 7: Aggregated Data Using the Group Function
Module 8: Display Data From Multiple Tables
Module 9: Usage of Subqueries to Solve Queries
Module 10: SET Operators
Module 11: Data Manipulation
Module 12: DDL Statements to Create and Manage Tables
Module 13: Other Schema Objects
Module 14: Introduction to PL/SQL
Module 15: PL/SQL Identifiers
Module 16: Write Anonymous PL/SQL blocks
Module 17: SQL statements in PL/SQL block
Module 18: Control Structures
Module 19: Composite Data Types
Module 20: Explicit Cursors
Module 21: Exception Handling
Module 22: Stored Procedures and Functions