Type: Offer Category: Training Price: Contact advertiser

Oracle SQl Development Training

Advertiser: Sriram Posted: Sep 26, 2018 3:25:05 PM Hits: 137

Oracle SQl Development Training

Ref: PUC180868
Oracle 11g SQL and PL/SQL Course Contents

DBMS Concepts
• What is Database?
• What is Database System?
• Difference Between DBMS, RDBMS & ORDBMS

• What is SQL?
• Using SQL*PLUS, Using SQL Developer
• SELECT statements
Order by Clause
Distinct Clause
Comparison Conditions
Where Clause

• Describe various types of functions that are available in SQL
• Use character, number, and date functions in SELECT statements
• Describe the use of conversion functions
• Identify the available group functions

• Describe the use of group functions
• Group data by using the GROUP BY clause
• Include or exclude grouped rows by using the HAVING clause

JOINS - Displaying Data from Multiple Tables
• Access data from more than one table using equijoins and nonequijoins
• Join a table to itself by using a self-join
• View data that generally does not meet a join condition by using outer joins
• Cartesian product from two or more tables

• What is a subqueries
• Types of problems that subqueries can solve
• Single-row and multiple-row subqueries
• Solve problems with correlated subqueries

DML Statements
• Describe each data manipulation language (DML) statement
• Insert rows into a table
• Update rows in a table
• Delete rows from a table
• Control transactions

DDL Statements
• Database objects
• Table structure and the data types for columns
• Create a table
• Creating constraints at the time of table creation
• Managing Database Objects with Data Dictionary Views

Other Database Objects
• Simple and complex views
• Create, maintain, and use sequences
• Create and maintain indexes
• Create private and public synonyms

Regular Expression Functions


Introduction to PL/SQL
• Describe the need for PL/SQL
• Benefits of PL/SQL
• Different types of PL/SQL blocks

Declaring PL/SQL Variables
• Uses of variables
• Declare and initialize variables
• Describe various PLSQL data types
• Benefits of using the %TYPE attribute
• Bind variables

Executable Statements in a PLSQL block
• Lexical units in a PL/SQL block
• Built-in SQL functions in PL/SQL
• Nested blocks and variables with labels
• SQL statements can be directly included in a PL/SQL executable block
• DML statements in PL/SQL transaction control statements in PL/SQL
• INTO clause to hold the values returned by a SQL statement
• Iimplicit cursors and explicit cursors and SQL cursor attributes

Control Structures
• An IF statement
• CASE statements and CASE expressions
• Loop statements

Composite Data Types
• User-defined PL/SQL records
• The %ROWTYPE attribute
• An INDEX BY table and an INDEX BY table of records
• Describe the differences among records, tables, and tables of records

Explicit Cursors
• Describe the reasons for using explicit cursors
• Declare and control explicit cursors
• Use simple loops and cursor FOR loops to fetch data
• Use of cursors with parameters
• FOR UPDATE clause and the WHERE CURRENT clause

Handling Exceptions
• PL/SQL exceptions and recognize unhandled exceptions
• Different types of PL/SQL exception handlers
• The effect of exception propagation in nested blocks
• Customize PL/SQL exception messages

Stored Procedures and Functions
• Difference between anonymous block and subprograms
• Create a simple procedure and invoke it from an anonymous block
• Create a simple procedure that accepts a parameter
• Create a simple function
• Create a simple function that accepts a parameter
• Differentiate between procedures and functions

• Describe packages and their components
• Create a package to group together related variables, cursors, constants, exceptions, procedures, and functions
• Describe a package construct as either public or private
• Describe the use of a bodiless package
• Overload package procedures and functions
• Use forward declarations

Dynamic SQL
• Describe the execution flow of SQL statements
• Dynamically build and execute SQL statements using Native Dynamic SQL EXECUTE IMMEDIATE statement

Oracle-Supplied Packages
• The DBMS_OUTPUT package

Large Objects
• Compare LONG and LOB data types
• Create and maintain LOB data types
• Internal and external LOBs

• Describe the different types of triggers and their uses
• Create DML triggers - statement and row triggers
• Understand trigger-firing sequence
• Creating database triggers on DDL statements

Visit www.futurepointtech.com for course curriculum
Drop a mail info@futurepointtech.com we will get in touch with u


More details: Oracle SQl Development Training
On Social:Oracle SQl Development Training on facebook/FuturePointTech

Contact Advertiser My Post Inform Friend Report Spam