We provide virtual course about Oracle Database: SQL and PL/SQL Fundamentals in english. In this Oracle Database: SQL and PL/SQL Fundamentals training course, you will learn the fundamentals of relational databases, SQL & PL/SQL programming language.
Course description:
You will also learn how to write queries against single and multiple tables, manipulate data in tables, and create database objects.
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
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
Target audience:
Administrator, analyst and developer
Prerequisites:
• Familiarity with data processing concepts and techniques
Language:
• English course material, english speaking instructor
Course material:
Digital course documentation and hands-on exercises