Training Course:A workshop on Oracle Database PL/SQL , SQLSchool/Trainer: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 ...''
Please go to the school's official website for training price and schedule: http://www.koreinfotech.blogspot.com/
Phone:81237970
School Address:
Singapore
Jobs & Resumes: Singapore Houses & Roommates: Singapore
Other training courses offered by Kore Infotech Pte Ltd. 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! |
|
|