Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Database Programming with Python II

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

9

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

See full profile

Technology Web Development