Publish listing Add
0 0 0

Oracle SQL Plsql training at Futurepointtech.com

India, Karnataka, Bangalore
Published 1 week ago
ID #7813
1 photo
Check with seller
Oracle SQL Plsql training at Futurepointtech.com
India, Karnataka, Bangalore,
Published 1 week ago

Description


Oracle 12c SQL and PL/SQL Course Contents
ORACLE 12c SQL

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

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

SINGLE-ROW FUNCTIONS
• 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

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

SUBQUERIES
• 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
• REGEXP_LIKE
• REGEXP_REPLACE
• REGEXP_INSTR
• REGEXP_SUBSTR
• REGEXP_COUNT

ORACLE 12c PLSQL

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

Packages
• 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

Triggers
• 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





Courses Offerings

• Android
• AIX Administration
• Business Analyst
• CCNA, CCNP Security, CCIE
• Citrix XenApp
• Cognos 10 BI & Tm1
• Crystal Reports
• Data Stage
• DB2 DBA
• Dot Net
• DAC
• Google Web Tool Kit
• Hadoop
• IBM Lotus Notes (Development)
• IBM Lotus Notes Domino Server Administration
• IBM Message Broker
• IBM MQ Series
• IBM Tivoli Access Manager
• IBM Web Sphere Application Server Administration (WAS)
• IBM WAS Portal server Development
• IBM Websphere Transformation extender (WTX 8.2)
• Informatica
• I Phone
• Java/J2EE
• J Query
• MCITP
• MicroSoft .NET Technologies (VB.NET, C#, ASP.NET)
• Microstrategy
• MicroSoft Business Intelligence
• MicroSoft Dynamics CRM
• OBIEE 11 g
• Oracle APPS - HRMS


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


http://www.futurepointtech.com/oracle-11g-sql-pl-sql-training.html

FuturePoint Technologies
0 votes

Related listings in your area
How far is it? Show listings in my area

Show only listings that are km distanced Show listings

 

Contact seller

    Company
    Registered on 15. Jul 2017

    Comments

    Question? Need more information? Want to ask question? Add new comment...
    Ask questions related to this listing only.
    Comments are moderated.
    Add new comment
    Check with seller
    Contact seller 0924776xxxx

    Listing location

    India, Karnataka, Bangalore
    Plot No:60, 2nd Floor ,Western Hills, Opp: Sri Chaitanya Junior Kalasala Behind Arjuna Theatre, KPHB