Oracle PL/SQL

by Sisoft Claim Listing

This course is designed to aim at imparting a basic level Oracle database. After completing the course the incumbent is able to the write, execute and understand sql statement and basic PL/SQL programming.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Sisoft Logo

img Duration

1.5 Month

Course Details

This course is designed to aim at imparting a basic level Oracle database. After completing the course the incumbent is able to the write, execute and understand sql statement and basic PL/SQL programming.

 

Course Outline:

  • Overview of Oracle:
    • Overview of Oracle Database and architecture
    • Overview of Transactions
    • Commit and Undo Transactions
    • Savepoints
    • Overview of Oracle SQL
  • Overview of SQL:
    • Use of DDL Statements to Create and Manage Tables
    • Overview of Datatypes
    • Overview of Data Integrity, Integrity Constraints & Keys
    • Data Manipulation Statements
    • DCL - Data Control Language. Some examples:
    • TCL - Transaction Control:
    • Retrieve Data using the SQL SELECT Statement
    • Learn to Restrict and Sort Data
    • Usage of Single-Row Functions to Customize Output
    • Invoke Conversion Functions and Conditional Expressions
    • Aggregate Data Using the Group Functions
    • Display Data From Multiple Tables Using Joins
    • Use Sub-queries to Solve Queries
    • The SET Operators
    • Function
    • Expressions
    • Other Schema Objects
    • Pseudocolumns
  • Overview of PL/SQL:
    • Understanding the basic Features of PL/SQL
    • Block Structure
    • Variables, Assignment and Operators
    • Writing Control Structures
    • Cursors
    • Cursor FOR Loops
    • Cursor Variables Attributes
    • Procedures
    • Functions
    • Packages
    • Triggers
    • Error Handling
  • Ghaziabad Branch

    SRC E7-E8, Shipra Riviera, Gyan Khand-3,Indirapuram, Ghaziabad

Check out more Oracle courses in India

Vataliya Soft-Tech Logo

MySQL

MySQL course is offered by Vataliya Soft-Tech. If you want to learn computer science perfectly and master in it so please come to our soft-tech.  We provide all computer science subjects with live project-making.

by Vataliya Soft-Tech [Claim Listing ]
Spark DataBox Logo

Oracle PL SQL Training

The best Oracle PL/SQL Training in Coimbatore is here. Oracle is an unaffiliated head in the database industry. The immense progress in data aggregation in the IT field and other industries has made PL/SQL technology a record-breaking high demand, which ultimately outperforms IT industry growth.

by Spark DataBox [Claim Listing ]
Besant Technologies Logo

HBase Training

Besant Technologies is a pioneering IT training institute that offers the Best HBase training in Pune. We boast of our knowledgeable trainers whom we fondly call our asset. They impart lessons in a unique way putting all of their theoretical and practical knowledge into use.

by Besant Technologies [Claim Listing ]
OIVET (OM Institute Of Vocational Education & Training) Logo

Certificate In DBMS (Data Base Management)

Certificate in DBMS (Data Base Management) course is offered by OIVET (OM Institute Of Vocational Education & Training). OIVET is an academically independent self-financed autonomous certification body offering various industry-integrated professional, vocational & job-oriented diplomas courses.

by OIVET (OM Institute Of Vocational Education & Training) [Claim Listing ]
Vinsys Logo

Oracle SQL 12 C

This Oracle SQL 12 c Certification Course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database.

by Vinsys

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy