b/tomorrowland 10 years ago by

Python with Oracle Database

This post was published 10 years ago. Download links are most likely obsolete. If that's the case, try asking the uploader to re-upload.

Students that have little knowledge about Oracle SQL/PLSQL and Python, this course will be very useful for them, as using Python with Oracle will make the processing performance much much better as we will see in a lot of examples during the course.

Why Python?

Very fast language
Easy to learn
Cross platform
Unlimited third party libraries
Get your job done with few lines
Ranked as #1 for the most popular programming languages

In case of big data python we will be very useful as it has below features:-

Bulk DML Operations, so you can hit Oracle DB only one time to insert Bulk of records
Process Forking, which enable to run multi instances from the process.
Multi Threading which enable you to do do processing in parallel not one by one.
Also python very Useful in below Scenarios:-

In case of rename any table, by few lines you can replace all the forms - procedures - functions with the new table name instead of modifying them one by one.
Prevent customer to Modify any procedures - functions with the the help of python hashing.
Many Many More!!

Screenshots