Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Python with Oracle Database to your Wishlist.

Add to Wishlist

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.4 (22 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,034 students enrolled
Created by Tarek Mahmoud
Last updated 7/2016
English
$19 $20 5% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 16 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
Requirements
  • The students should have an idea about Oracle SQL and Python
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!!


Who is the target audience?
  • SQL/PLSQL Developers
  • Python developers who want to learn database programming.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 31 Lectures Collapse All 31 Lectures 03:49:58
+
Introduction
1 Lecture 08:29

Introduction and Course Contents

Preview 08:29
+
Setup Course Lab
3 Lectures 11:11

Install Python Oracle library cx_Oracle
01:55

Connect from Python To Oracle DB
02:37
+
Working With Oracle DML (Query - Insert - Update - Delete)
4 Lectures 20:57
Select
07:49

Insert
04:41

Update
05:22

Delete
03:05
+
Working With Oracle Bulk DML (Query - Insert - Update - Delete)
4 Lectures 23:19
Bulk Select
04:33

Bulk Insert
10:25

Bulk Update
04:42

Bulk Delete
03:39
+
Working With Procedures and Functions
6 Lectures 23:36
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 2
08:19
+
Working With Large Data
2 Lectures 21:18
Run multi instance from a program
11:59

Run multi threads program
09:19
+
Some Advanced Topics and Fun Staff!!
6 Lectures 58:47
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
+
Python and Windows Programming
5 Lectures 01:02:21
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
About the Instructor
3.4 Average rating
22 Reviews
1,034 Students
1 Course
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


Report Abuse