Python with Oracle Database Part I Free class

Tarek Abulnaga, Technical Consultant

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Videos (1h 4m)
    • Introduction

      8:29
    • Install Python and Pycharm

      6:40
    • Install Python library cx_Oracle

      1:55
    • Connect from Python To Oracle

      2:38
    • Select

      7:50
    • Insert

      4:41
    • Update

      5:22
    • Delete

      3:05
    • Bulk Select

      4:34
    • Bulk Insert

      10:25
    • Bulk Update

      4:42
    • Bulk Delete

      3:39

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

59

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