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.

Course 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.

Course Topics

  • 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
  • Aggregated Data Using the Group Functions
  • Display Data From Multiple Tables
  • Usage of Subqueries to Solve Queries
  • SET Operators
  • Data Manipulation
  • DDL Statements to Create and Manage Tables
  • Other Schema Objects
  • Introduction to PL/SQL
  • PL/SQL Identifiers
  • Write Executable Statements
  • Interaction with the Oracle Server
  • Control Structures
  • Usage of Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures and Functions

It is the first and largest provider of computer software and hardware training in Egypt.

We_They is fast growing training provider over 20 years of experience in the delivery of computer training.

Our organization is dedicated to provide education excellence to meet the needs of each technology, simultaneously, as customer expand designed solutions to meet his particular organization's business needs.

Also Compuek is aimed by great companies and institutions for training their human resources looking for their progress and growth, and to make HR learn this promising technology at that time. For 20 years, the center is supplying the career market by highly qualified HR members who having broad minded, acquired with high technique and capable to work on the most difficult systems by all easiness and facility.

Computek is distinguished by its remote sighted management that enjoyed advanced thinking and firmness in order to enable the trainees to get as much training as possible by easy and simple way and in fine, splendid, and very organized training halls acquired with high capability PCs that are continuously upgraded to maintain high performance.

See all Computek Training Center courses

Contact information not available.

Courses you can instantly connect with...
Querying Microsoft SQL Server New Horizons Egypt Mastering PHP & MySQL Helper Learning MCTS: SQL Server 2008, Database Development Helper Learning

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?