Database Programming with Python II | Tarek Abulnaga | Skillshare

Database Programming with Python II

Tarek Abulnaga, Technical Consultant

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
19 Lessons (2h 46m)
    • 1. Call Procedure

      2:37
    • 2. Call Function

      2:59
    • 3. Call Procedure that has Date Parameter

      3:40
    • 4. Call Procedure that has OUT Parameter

      2:46
    • 5. Using hash to detect code change I

      3:15
    • 6. Using hash to detect code change II

      8:19
    • 7. Run multi instance from a program

      11:59
    • 8. Run multi threads program

      9:19
    • 9. Bulk Compile Oracle Forms

      4:57
    • 10. Bulk Replace in all Oracle Forms

      7:59
    • 11. Bulk Replace in Oracle Procedures Functions

      12:40
    • 12. Generating a formatted Excel sheet from Query

      8:49
    • 13. Storing Python .Exe into Oracle BLOB

      13:14
    • 14. Python and Windows, Monitor the changes in any windows directory

      13:10
    • 15. Register Python Program as WindowsService

      16:17
    • 16. Send Formatted HTML Mail by python

      11:10
    • 17. CreateSample Dll and call it from Python

      6:12
    • 18. Call Dll From Oracle DB

      6:19
    • 19. Embedded SQL into Windows Dll

      20:25

About This Class

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!!