Brief Introduction
Using Python with Oracle will make the processing performance much better and complex tasks will be done in few lines!!Description
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 parallel processing.
- Create DLLs and call them from Python and Oracle.
- Learn how to embedded SQL into DLL.
- Learn how to create Windows Service from python.
- Many Many More!!
Requirements
- Requirements
- The students should have the basics of SQL and Python