Concepts of relational and object relational databases, SQL programming language, create and maintain database objects and to store, retrieve, and manipulate data. Participants also learn to retrieve data by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. Learn how to write SQL and SQL Plus script files using the iSQL Plus tool.
Course highlight:
- Learn from an Oracle Certified instructor with 6 yrs of DBA experience
- Thorough, deliberate and detailed - the best way to master Oracle
- The course prepares you for the OCA and OCP
- Comprehensive Courseware : PPTs+ Docs + PDFs
- Each class is 60 minutes
Language of the course:
English
Refunds:
If the candidate is not satisfied with the course, he or she can call for refund after first two sessions.
Course content:
- Describe relational and object relational database concepts
- Retrieve, insert, update, and delete data
- Use the Single row and Group functions
- Retrieve data using additional advanced techniques like using
- ROLLUP, CUBE, set operators, correlated sub queries and hierarchical queries
- Solve problems by using multicolumn sub queries
- Sub queries in the from clause of a SELECT statement, correlated sub queries, and scalar Sub queries
- Use the iSQL Plus environment
- Write scripts to generate script files
- Generate reports using iSQL Plus
- Create and maintain database objects
- Control transactions
- Control data/user access
- Use the Oracle 9i Single row functions
- Use GROUPING SETS and the WITH clause
- Use the Oracle9i extensions to DML and DDL statements
- Apply techniques in real life simulation
Duration:
10 hours
Course fee:
Rs. 24999
In order to apply, click here.
Stay tuned with Oneindia Education on: Entrance Exams, Admissions, News, Value Education, Online Courses
For Quick Alerts
For Daily Alerts
Story first published: Tuesday, March 11, 2014, 17:12 [IST]