A workshop on Oracle Database PL/SQL , SQL

Kore Infotech Pte Ltd. Singapore
Singapore, Singapore, Singapore

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Course Contents

* What is database
* Need for a relational database
* Understanding the basic Oracle Architecture
* Understanding the different data types in Oracle
* Understanding the different statement types in Oracle
* Creating, Altering and Dropping Tables
* What is a constraint and different types of constraints
* Creating, altering and dropping constraints
* Retreiving data from tables using SELECT
* The WHERE clause
* Conditional Comparisons
* The ORDER BY clause
* understanding joins (Natural or Inner, Outer, Self, Equi)
and using them in SELECT

* Working with Subquery
* Working with Oracle provided string, number, date and special
functions like decode

* The DUAL table
* Working with NULL data
* Working with INSERT
* Working with UPDATE
* Working with DELETE
* Working with TRUNCATE
* What is PL/SQL
* What is an anonymous PL/SQL block
* Variables and Types in PL/SQL
* Writing, compiling and executing Procedures in PL/SQL
* Writing, compiling and executing Functions in PL/SQL
* Writing, compiling and executing Packages in PL/SQL
* Writing, compiling and executing Triggers in PL/SQL
* Working with explicit and implicit cursors in PL/SQL
* Indexes in Oracle
* Views in Oracle
* Synonyms in Oracle
* Sequences in Oracle
* COMMIT vs ROLLBACK vs SAVEPOINT
* What is performance optimization
* Ways of Optimizing a Query
* Creating a Normalizated relational database ...''

Phone:81237970

School Address:

Singapore

Jobs & Resumes: Singapore
Houses & Roommates: Singapore

Unix Shell Scripting
Unix
Web Designing

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!