In this Oracle Dev Gym class...

CRUD operations using cx_Oracle and Python


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.

Information

  • Instructor

    Blaine Carter

  • Starts On

    On Demand

  • Difficulty

    Beginner

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.

What You'll Learn

Module 1: 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.
Module 2: 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.
Module 3: 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.
Module 4: 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.
Module 5: 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.