Oracle 10g Developer Track Course
by High Technologies SolutionsNew Delhi, Delhi NCR, Mumbai, Jalandhar |
Request Info |
| Medium of instruction: | English |
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
| Classroom - Regular | ||||
| When | Duration | Where | Remarks | Price |
| Not Specified | (Total 48 Hrs) | All Venues | Not Specified | Price On Request |
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
High Technologies Solutions
High Technologies Solutions was founded in 2000 by a group of highly qualified Technocrats (with proven expertise in varied technology domains) as a Centre for education, training & software development at Delhi.
HTS holds the distinction of being a unique group, offering a variety of services with their comprehensive training and online consultancy experiences. We not only offer our services to our direct corporates, but are also providing services on behalf of well known organizations.
We are a leading Training Institute with a mission to provide comprehensive and accurate training information to all the prospective value conscious training buyers for any domain.
At High Technologies Solutions, we are your career partner, providing you with a lifetime of progressive learning products, which will ensure you have the knowledge, flexibility and interest to sustain a rewarding and exciting career.
Whether you are just starting out in the IT industry, want to change jobs, looking for a promotion or set up your own consulting business, HTS has the right building blocks for your career. We recognize that your career must be built to your own specifications. That's why HTS focuses on e-learning solutions, based on training courses from recognized global e-learning leaders, including Sun Microsystems.
Wherever possible, we make learning at your own pace, in your own time (and with your own special focus) as easy as possible, with online peer forums, articles, 24/7 mentoring support and other support services. Unlike other e-learning products, opening the box means only the beginning of your relationship with HTS.
Our business is dedicated to delivering good quality, inexpensive services that will improve the quality of work at all levels in an organization. We strongly believe in "Business goes where it is invited and stays where it is well treated.
