Workshop on Oracle Database 10g

Oracle Database 10g was the first database designed for grid computing, the most flexible and cost-effective way to manage enterprise information. It cut costs of management while providing the highest possible quality of service.

In this workshop students will be learning about how to install, configure and create projects on Oracle 10g software.

This is just 2 days course content, if you need training content for Faculty Development Program or for 5/7/10/15/30/45/180 Days training, Click Here.

Day 1

  • Installing oracle and configuration+java latest version tool jdk+sql developer
  • Why to study and learn oracle instead of other database management softwares like MS Access and IBM Database?
  • Some basics of database in oracle by using SQL.
  • Creation of student database/college database/Choose Database as example
    • Insertion of data in the database
    • Deletion of data in the database
    • Updation of data in the database
  • Some standard function and system operation in database.
    • Example : Number Functions, Character Functions, Date Functions , Conversion         Functions, Various Group Functions.
  • Storing Audio Video image files in database.

 

Day 2

  • Introduction to PL/SQL.
  • Database connectivity in Java (Java Database Connectivity using oracle, JDBC).
  • Implement the concept of views in the database.
  • Choosing a project like college database/canteen database etc
    • Creating realtime database.
    • Connecting multiple databases to make one database.
    • Fetching data from different database into another database. 

The Workshop content consists of an approximately equal mixture of lecture and hands-on lab. 

Recommendation: It is strongly recommended to bring your own LAPTOP during the training on which you can install and run programs if you would like to do the optional, hands-on experiments/exercises after the trainings/ workshops.

Certificates will be provided by ISO 9001:2008 certified I-Medita Learning Solutions Pvt. Ltd. Company which is registered with Ministry of Corporate Affairs for providing IT Trainings all over India and IBNC India which is a trademark championship that has already been executed in 106 Engineering colleges till March 2015.

  • Participation Certificate: Given to each candidate who participate in the workshop
  • Appreciation Certificate: Given to the College/ Institution who help in conducting the workshop.
  • Excellence Certificate: Given to the winner of the Zonal Center Championship.
  • Coordination Certificate: Given to those active & strong students and faculty coordinators who help in making the workshop and training successful.

IBNC Team gives you freedom to ask your relationship manager at IBNC India for certificate samples in advance so that you could be aware of the certificate you will be receiving before hand the trainings/workshops.

IBNC DVD to each participant to help them learn more about the workshop containing e books, presentations, videos and softwares after the training.

  • One on one interaction in the class with the Trainer.
  • Study material designed by panel of experts from industry.
  • Lead trainer will also have supporting trainers with him/her so that they can help you fall in love with the technology.
  • We believe in learning with fun!
  • The skills we develop are those that employers within the industry are looking for.
  • Covering theoretical and practical concepts in such a way that it is fun to learn the technology and easy to make unique projects.
  • Your skills and certifications are recognized anywhere in the world your career takes you.
  • Successfully trained over 15000 students in India till now.
  • Watch video testimonials given by students: www.youtube.com/ibncindia
  • Check out our facebook page to see live comments from our prestigious students.
  • IBNC makes sure that you should get the full worth of the money you have paid during the trainings anywhere in India.

Please contact IBNC India Team to know more about careers in this technology.