Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Python+SQL+Oracle and Endless Possibilities

Name: Python+SQL+Oracle and Endless Possibilities
Rating: 4.3 (63 reviews)

Develop Python application on Oracle Database

Created bySanjay Singh

Last updated 2/2022

English

What you'll learn

Python, SQL, PLSQL and Oracle Database
cx_Oracle, tkinter, pandas and other python libraries
Data Analytics using Python on Oracle Database
Develop a real life application using Python on Oracle Database.
Large Objects (LOB, CLOB, BLOB), Advanced Message Queues (AMQ), Type Handler.
Interaction with Hadoop database through HIVE.

Course content

14 sections • 64 lectures • 6h 18m total length

Introduction1:02
Welcome to this course!
Architecture8:44
In this lecture, you will learn about involved architecture for creating a Python application on the Oracle database. You will learn about
cx_Oracle, OracleNet,SQLNet, WebServer, OracleDBClient,Oracle Net and Oracle database.

Oracle Express Database Installation5:22
In this lecture, you are going to install and configure the Oracle Express database.
SQL Developer Download3:56
In this lecture, you will download the SQL developer tool.
SQL Developer Connection1:27
In this lecture, you will connect SQL developer with Oracle Database.
User Creation1:43
In this lecture, you will create a database user. Run below commands

alter session set "_ORACLE_SCRIPT"=true;

CREATE USER PLEARNER IDENTIFIED BY PLEARNER;

GRANT ALL PRIVILEGES TO PLEARNER;

Python Basics18:26
In this lecture, you will learn the basics of Python programming. You will learn about it.
White space Indentation while writing a Python Program
Different data types and data structures like int, string, list, dictionary, tuples
Flow Control and Loop
Functions
Modules
Install cx_Oracle0:58
In this lecture you will install cx_Oracle module in Python.
Python and cx_Oracle without Anaconda (Optional)0:33
If you have already installed Anaconda as suggested before, skip this lecture.
In case you already have installed Python IDE and don't want to use Anaconda and Jupyter, follow the attached method. These steps require the existence of an Oracle client, hence perform these steps after installing Oracle Database (in case you don't have it already installed)

Section Introduction0:46
Welcome to this section of course. In this section, you will learn about different types of connections between the python application and Oracle database.
Standalone Connection4:05
In this lecture, you are going to connect to the Oracle database using cx_Oracle.connect, which creates a standalone connection with the database.
Where is my python installed0:32
In this lecture, you will understand how to find out where Python is installed on your computer.
Standalone Connection with password file4:58
In this lecture, you will learn how to use a password file for the connection.
Connection Pool7:36
In this lecture, you will learn how to create a connection pool using cx_Oracle.SessionPool. You will understand the difference between a standalone connection and connection pool.

Section Introduction0:50
Welcome to this section of course. In this section, you will learn about SQL and how to implement them in Python application.
Cursor Method0:19
In this lecture, you will learn cursor method in connect object of Python.
Table Creation5:12
In this lecture, you will learn how to execute CREATE TABLE SQL in cx_Oracle.
Data Insertion2:24
In this lecture, you will insert data into the table.
Data Modification2:30
In this lecture you will modify existing data in table.
Data Selection8:25
In this lecture, you will select the data from the table. You will learn about fetchone(), fetchmany(), and fetchall().
Bind Variable5:41
In this lecture, you will learn about executing bind variables in SQL through the cursor. prepare the python method.
Bind Variable (more than one variable)0:21
How to add more than one bind variable.
Bind Variable in Insert Statement6:49
In this lecture, you will learn about how to use the bind variables in insert statements through executemany.
Error Handling7:55
In this error, you will learn about exception handling through batcherrors.

Section Introduction0:57
Welcome to this section of course. In this section, you will learn about PLSQL and how to implement it in Python application.
Call PLSQL Procedure in Python7:28
In this lecture, you will learn how to call a PLSQL procedure in the Python program.
Call PLSQL Function in Python5:13
In this lecture, you will learn how to call the PLSQL function in Python program.
Anonymous PLSQL7:10
In this lecture, you will learn how to create an anonymous PLSQL procedure in Python.
Error Handling- Data Integrity Error6:47
In this lecture, you will learn about PLSQL error handling.
Error Handling- Overall Error codes6:46
In this lecture you will learn about possible error codes like DatabaseError, InterfaceError, DataError, ProgrammingError etc. and understand where in overall landscape these errors happen.

Advanced Messaging Queuing (AMQ) Introduction7:37
In this lecture, you will learn about Advanced Queuing (AQ) and Oracle Advanced Queuing. You will learn about
Message Producer and message enqueue,
Message Consumer/Subscriber and message dequeue
Message Propogation -> Enqueued message is reproduced by another queue
Message Transformation -> Message is changed from one data type to Object of another data type.
You will understand how messages are transported using Oracle Net Service or HTTPS. You will understand how Advance Queues are stored in Oracle database tables and how it can be queried using SQL.
You will understand how Oracle Advance Queuing support Abstract Data Type (ADT) queues.
Advanced Queue (AQ) in Oracle Database2:18
In this lecture, you will learn about Advanced Queue (AQ) in the Oracle database.
Create and Start Queue3:50
In this lecture, you will learn how to create an advanced queue and start it in the Oracle database using the dbms_aqadm package.
Enqueue Messages5:02
In this lecture, you will enqueue messages to the advanced queue. You will use the enqOne method connect.queue.
Dequeue Messages4:03
In this lecture, you are going to dequeue the messages using queue.deqOne.

Requirements

Some knowledge of Python will be useful
Some knowledge of SQL and PLSQ will help

Description

Welcome to the most popular Python, SQL, and Oracle database course on Udemy.

Python is among the top three programming languages. Organizations like Quora, Facebook, YouTube, SlideShare, Dropbox, Pinterest, Reddit, and Netflix have most of their new code written in Python. Google has now adopted Python as its secondary coding language and has committed to using it more in its new product offerings.

Needless to say, Python programming is a secrete key to a successful future.

Why Python & SQL:

Oracle database is the most popular database management system. More and more Python applications are being developed on the Oracle database.

Oracle Analytics Cloud (OAC) will soon have the ability to integrate with custom-developed Python-based analytic applications.
Software Development Kit (SDK) of most of the Oracle products like Oracle Cloud Infrastructure (OCI), Oracle Database Management on Cloud, etc. are available in Python.
Python-based applications can be launched on OCI under the application container.
Python can be used to expose Oracle ERP programs as a REST API for integrating with cloud applications.

While Oracle has its programming language SQL and PLSQL, its capacity is limited when it comes to developing a diverse application.

Considering the popularity of Python in Application Development, Data Analytics, and Cloud-based SaaS application development, no IT professional can afford to not learn Python and connect it with the database.

Considering the huge customer base of Oracle, professionals with knowledge of Python, SQL, Oracle are in great demand.

Don't be left out and prepare well for these opportunities.

So, what are you waiting for?

Pay once, benefit a lifetime! This is an evolving course! Python, SQL, Oracle database, and future versions will be covered in this course. You won’t lose out on anything! Don’t lose any time, gain an edge, and start now!

Who this course is for:

Application Developer
Product development architect
Python Developer
Oracle Developer
Oracle EBS Professional
Data Scientist
Machine Learning Professionals
Project Manager
Business Analyst
System Architect
Solution Architect

Python+SQL+Oracle and Endless Possibilities

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 10min

Development Tools3 lectures • 10min

Oracle Database4 lectures • 12min

Python Tools3 lectures • 20min

Connecting the Database5 lectures • 18min

SQL & Python10 lectures • 40min

PLSQL & Python6 lectures • 34min

Type Handler1 lecture • 9min

Project #1: Large Objects (LOB)3 lectures • 18min

Project #2: Advanced Messaging Queues5 lectures • 23min

Requirements

Description

Who this course is for: