Oracle Database 12c: SQL and PL/SQL Fundamentals (CO-80198)

Course details

Introduction

This five-day instructor led course is a bundled course thqat consists of Oracle Database: SQL Workshop I and Oracle Database: PL/SQL Fundamentals and will teach you 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.

Course Content

SQL FUNDAMENTALS I

• Lesson 1: Introduction
• Lesson 2: Retrieving Data Using the SQL SELECT Statement
• Lesson 3: Restricting and Sorting Data
• Lesson 4: Using Single-Row Functions to Customize Output
• Lesson 5: Using Conversion Functions and Conditional Expressions
• Lesson 6: Reporting Aggregated Data Using the Group Functions
• Lesson 7: Displaying Data from Multiple Tables Using Joins
• Lesson 8: Using Subqueries to Solve Queries
• Lesson 9: Using the Set Operators
• Lesson 10: Manipulating Data
• Lesson 11: Introductions to Data Definition Language

PL/SQL Fundamentals

• Lesson 1: Introduction
• Lesson 2: Introduction to PL/SQL
• Lesson 3: Declaring PL/SQL Variables
• Lesson 4: Writing Executable Statements
• Lesson 5: Using SQL Statements within a PL/SQL Block
• Lesson 6: Writing Control Structures
• Lesson 7: Working with Composite Data Types
• Lesson 8: Using Explicit Cursors
• Lesson 9: Handling Exceptions
• Lesson 10: Introducing Stored Procedures and Functions