Oracle Database programming PL/SQL, SQL Workshop

Kore Infotech Pte Ltd
SG, Chinatown, SG

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Term: 30-35 hours
Seats: 6 max
Fee: 450

Course Description:

'' 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 ...’’
Please go to the school’s official website for training price and schedule: www.koreinfotech.com ...''

Phone:81237970

School Address:



Jobs & Resumes: SG
Houses & Roommates: SG

Search other schools for Oracle Database programming PL/SQL, SQL training resources.

Solaris / Linux
Unix Shell Scripting

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.
 

Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.