Python with Oracle Database II Premium class

Tarek Abulnaga, Technical Consultant

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

      2:37
    • Call Function

      2:59
    • Call Procedure that has Date Parameter

      3:40
    • Call Procedure that has OUT Parameter

      2:46
    • Using hash to detect code change I

      3:15
    • Using hash to detect code change II

      8:19
    • Run multi instance from a program

      11:59
    • Run multi threads program

      9:19
    • Bulk Compile Oracle Forms

      4:57
    • Bulk Replace in all Oracle Forms

      7:59
    • Bulk Replace in Oracle Procedures Functions

      12:40
    • Generating a formatted Excel sheet from Query

      8:49
    • Storing Python .Exe into Oracle BLOB

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

      13:10
    • Register Python Program as WindowsService

      16:17
    • Send Formatted HTML Mail by python

      11:10
    • CreateSample Dll and call it from Python

      6:12
    • Call Dll From Oracle DB

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

5

Students

--

Projects

0

Reviews (0)

Tarek Abulnaga

Technical Consultant

Microsoft

  Microsoft Certified Systems Engineer (MCSE).

Cisco

  Cisco Certified Network Associate (CCNA)

Oracle

  SQL-PLSQL Oracle Certified Professional (OCP)

Security 

  CEH (Certified Ethical Hacker) 

 CHFI (Computer Hacking Forensic Investigator )

Programming languages

  Assembly

  C/C++

  Oracle ProC

  Python