Python with Oracle Database

Using Python with Oracle will make the processing performance much better and complex tasks will be done in few lines!!
3.5 (27 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,012 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 31
  • Length 4 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 English

Course Description

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 parallel processing.
  • Create DLLs and call them from Python and Oracle.
  • Learn how to embedded SQL into DLL.
  • Learn how to create Windows Service from python.
  • Many Many More!!


What are the requirements?

  • The students should have an idea about Oracle SQL and Python

What am I going to get from this course?

  • Working with Oracle Database using Python
  • How to do Oracle DML operations (Insert - Update - Delete) using Python
  • How to call Oracle Procedure / Functions
  • How to Generated formatted Excel Sheet from Oracle DB
  • How to use Multithreading with Oracle DB to have super performance
  • How to send formatted mail using python
  • How to monitor changes in Windows directory
  • How to create Windows service using python

What is the target audience?

  • SQL/PLSQL Developers
  • Python developers who want to learn database programming.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
08:29

Introduction and Course Contents

Section 2: Setup Course Lab
Install Python and PyCharm
Preview
06:39
Install Python Oracle library cx_Oracle
01:55
Connect from Python To Oracle DB
02:37
Section 3: Working With Oracle DML (Query - Insert - Update - Delete)
Select
07:49
Insert
04:41
Update
05:22
Delete
03:05
Section 4: Working With Oracle Bulk DML (Query - Insert - Update - Delete)
Bulk Select
04:33
Bulk Insert
10:25
Bulk Update
04:42
Bulk Delete
03:39
Section 5: Working With Procedures and Functions
Call Procedure
02:37
Call Function
02:59
Call Procedure that has OUT Parameter
02:46
Call Procedure that has Date Parameter
03:40
Using hash to detect any changes in PLSQL objects code 1
Preview
03:15
Using hash to detect any changes in PLSQL Objects code 2
08:19
Section 6: Working With Large Data
Run multi instance from a program
11:59
Run multi threads program
09:19
Section 7: Some Advanced Topics and Fun Staff!!
Bulk Compile Oracle Forms
04:57
Bulk Replace in all Oracle Forms
07:59
Bulk Replace in Oracle Procedures/ Functions
12:40
Generating a formatted Excel sheet from Query.
08:49
Storing Python .Exe into Oracle BLOB
13:13
Send formatted mail from Python
11:09
Section 8: Python and Windows Programming
Monitor the changes in any windows directory
13:10
Register Python program as Windows service
16:17
Create Sample DLL and call it from Python
06:11
Call DLL from Oracle
06:18
How to embedded SQL/PLSQL into DLL
20:25

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Tarek Mahmoud, 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


Ready to start learning?
Take This Course