Search in
Courses Providers, List Your Courses for FREE
Menu
High Technologies Solutions

Oracle 10g Developer Track Course


Training/Coaching/Tuition

by High Technologies Solutions


New Delhi, Delhi NCR, Mumbai, Jalandhar
View Contact
Request Info
Subjects Covered & Categories
Learn: Oracle 10g

Category: Database
Basic Details
Medium of instruction:English
Request Info
Overview, Content & Syllabus

This course introduces Oracle Database 10g technology and the relational database concepts and the powerful SQL programming language. This course provides the learners with the essential SQL skills of querying the database, the Meta data and creating database objects.In addition, the course also delves into the advanced querying and reporting techniques, data warehousing concepts and manipulating large data sets in different time zones. 1 Introduction to Oracle10g: SQL 40 2 Oracle 10g: Program with PL / SQL 40 3 Oracle10g: Forms Developer Build Internet Application 40 Oracle D

Course Outline

  • Introduction to Oracle10g: SQL

  • Search data using advanced sub queries

  • Retrieve row and column data from tables with the SELECT statement

  • Employ SQL functions to generate and retrieve customized data

  • Run data manipulation statements (DML) to update data in the Oracle Database 10g

  • Control user access and manage schema objects

  • Design PL / SQL anonymous blocks that execute efficiently

  • Write PL / SQL code to interface with the database

  • Describe the features and syntax of PL / SQL

  • Use PL / SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)

  • Handle runtime errors

  • Create simple procedures and functions Oracle 10g: Program with PL / SQL

  • Design PL / SQL packages to group and contain related constructs

  • Categorize and Use the Oracle supplied PL/SQL packages to generate screen output, file output, web output, and mail output

  • Schedule PL / SQL jobs to run independently

  • Write dynamic SQL for more coding flexibility

  • Create triggers to solve business challenges

  • Manage dependencies between PL / SQL subprograms Oracle10g: Forms Developer Build Internet Application Create form modules, including components for database interaction and GUI controls

  • Display form modules in multiple windows and use a variety of layout styles

  • Test form modules in a Web browser

  • Debug form modules in a 3-tier environment

  • Implement triggers

  • Reuse objects and code

  • Link one form module to another

Note:

The audience for this course is MCA, BCA, B.Sc (IT), M.Sc (IT), B.Sc, B.Tech or B.E (Any Branch), O Level, A Level etc..

USP's

  • Books

  • CD

  • Labs: 7:30 am to 9:00 pm

  • Live Projects

  • Live Mainframe Connectivity

  • Course Certificate

  • Confirmation Letter / Training Letter / Project Letter:For Degree Pursing Candidates To Submit In Colleges

  • Consultants/Faculties:All our consultants are professionals working with MNC's Eg. IBM, SDG, XANSA, HCL, WIPRO, CMS, PATNI & Many More

  • Experience Certificates:All our students would be given experience certificates after successful completion of project.

  • 100% Job Assistance:

  • Regular Job updates on our website.

  • Resourcing Through Consultancy Services

  • Regular Walk Ins

  • Exclusive Walk-ins For HTS Students

  • Campus Interviews

  • Resume Sending

  • References

Request Info
Course Schedule & Price
Classroom - Regular
When Duration Where Remarks Price
Not Specified (Total 48 Hrs) All Venues Not Specified Price On Request

Request Info
Venues (Locations)
New Delhi, Kalkaji (Head Office):- N-22 Kalkaji, New Delhi - 110019, Delhi, India

New Delhi, South Extension (Branch):- F-21,2nd Floor, South Ext-1, McDonald's Lane South Extension, New Delhi - 110049, Delhi, India

New Delhi, Pitampura (Branch):- 17, Kapil Vihar, 2nd Floor, opp. metro pillar No. 351 opp. Gulab Sweets, Near Kohat Enclave Metro Station Pitampura, New Delhi - 110034, Delhi, India

New Delhi, Vikas Puri (Branch):- B-55(1st Floor), New Krishna Park Vikas Puri, New Delhi - 110018, Delhi, India

New Delhi, Noida (Branch):- C-98, Sec-2 Noida, New Delhi, Delhi, India

Delhi NCR, Gurgaon (Branch):- C-4, First Floor, Old DLF Near Sector-14 Gurgaon, Delhi NCR, Delhi, India

Mumbai, Andheri (Branch):- 201, A Wing, Classique Centre Building, 26, Mahal Industrial Estate Near Holy Family School, Off Mahakali Caves Road Andheri, Mumbai, Maharashtra, India

Jalandhar, G T Road (Branch):- S.C.O. No 21,22 Kuldip Lal Complex Highway Plaza ,G.T Road, Adjoining Lovely Professional University G T Road, Jalandhar, Punjab, India

Request Info