A Dev Gym Class

CRUD operations using cx_Oracle and Python

A free cx_Oracle course

Learn how to use the cx_Oracle driver in your Python-based applications to perform basic CRUD (Create, Read, Update and Delete) operations in Oracle Database. Each module in this class starts with a video and blog post, and concludes with quizzes to reinforce your knowledge of the topic.
Join 2,574 students    (37 ratings)

Information

Oracle Account Text

You need an Oracle Account to take a class. Click here to sign up.
Already a member of the Oracle Dev Gym? Click here to get back to work.

Course Modules

Connections and Cursors

In this module, you will learn how to create a connection to Oracle Database. We will also explore some basic functionality of the cursor object in cx_Oracle.

Create Rows (INSERT) using cx_Oracle

In this module, you will learn how to insert rows into tables through the cx_Oracle driver. We start with a video, then invite you to explore a blog post, and finish up with some quizzes to drive home the lessons.

Retrieve Rows (SELECT) with cx_Oracle

It's important to know how to get data into Oracle Database from your Python programs. But just as critical is getting data back out with SELECT statements. We show you the way with a video and blog post. Then you can get to verify your new-found knowledge with a handful of quizzes.

Update Rows with cx_Oracle

You may work with some tables that are "insert-only" - that is, data is inserted and never changed. But for most tables, you will need to insert rows and then change values of columns in those rows. For that you need the UPDATE statement and a driver to execute that statement for you. cx_Oracle to the rescue! So pop some popcorn and watch Blaine's video. Then catch up on the details in his blog post and prove to the world you're an expert by answering our quizzes.

Delete Rows with cx_Oracle

Data generally is forever, but individual rows? Not always. Sometimes they must be deleted. Learn the ins-and-outs of removing rows with the cx_Oracle driver. You can probably guess the drill: watch a video; read a blog post, then take some quizzes to validate your newfound knowledge.