Home > Vendors > oracle > p3688

Share

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

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.

Learn To:

  • 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.
  • Conditionally control code flow (loops, control structures).
  • Describe stored procedures and functions.
  • Retrieve row and column data from tables.

Duration: 5.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

  • Run data manipulation statements (DML) to update data in the Oracle Database.
  • Design PL/SQL anonymous block that execute efficiently. 
  • Describe the features and syntax of PL/SQL. 
  • Handle runtime errors.
  • Describe stored procedures and functions.
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors). 
  • Use cursors to process rows.
  • Identify the major structural components of the Oracle Database 11g. 
  • Retrieve row and column data from tables with the SELECT statement.
  • Create reports of sorted and restricted data. 
  • Employ SQL functions to generate and retrieve customized data.
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax.
  • Create reports of aggregated data.
  • Run data definition language (DDL) statements to create and manage schema objects.

Content

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

Audience

  • Developer
  • Implementer

Prerequisites

N/A

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses

d90871

This training is the first step in mastering MySQL, the world’s most popular open source database.

p10380

P10380 - Oracle Database 18c: Administration Workshop

d79995

Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.

d83527

D83527 - Java SE 8 Fundamentals
Enquire Now
CvEhwz
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy
➤