Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Very fast language
Easy to learn
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:-
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Introduction and Course Contents
|Section 2: Setup Course Lab|
Install Python and PyCharmPreview
Install Python Oracle library cx_Oracle
Connect from Python To Oracle DB
|Section 3: Working With Oracle DML (Query - Insert - Update - Delete)|
|Section 4: Working With Oracle Bulk DML (Query - Insert - Update - Delete)|
|Section 5: Working With Procedures and Functions|
Call Procedure that has OUT Parameter
Call Procedure that has Date Parameter
Using hash to detect any changes in PLSQL objects code 1Preview
Using hash to detect any changes in PLSQL Objects code 2
|Section 6: Working With Large Data|
Run multi instance from a program
Run multi threads program
|Section 7: Some Advanced Topics and Fun Staff!!|
Bulk Compile Oracle Forms
Bulk Replace in all Oracle Forms
Bulk Replace in Oracle Procedures/ Functions
Generating a formatted Excel sheet from Query.
Storing Python .Exe into Oracle BLOB
Send formatted mail from Python
|Section 8: Python and Windows Programming|
Monitor the changes in any windows directory
Register Python program as Windows service
Create Sample DLL and call it from Python
Call DLL from Oracle
How to embedded SQL/PLSQL into DLL
Microsoft Certified Systems Engineer (MCSE).
Cisco Certified Network Associate (CCNA)
SQL-PLSQL Oracle Certified Professional (OCP)
CEH (Certified Ethical Hacker)
CHFI (Computer Hacking Forensic Investigator )