How to create a CRUD Application with Python and Oracle

How to create a CRUD Application with Python and Oracle, available at $49.99, has an average rating of 4.55, with 23 lectures, based on 25 reviews, and has 4272 subscribers.

You will learn about Installing Python Installing Oracle Database Server Creating a new database Creating a new table Create Graphical User Interface for application Create and activate a virtual environment Installing Oracle Python Database Connector Creating database configuration file Connecting to and interacting with database from Python Create a class with methods Creating stand alone functions Wiring functions to widgets Interacting with ListBox Performing CRUD operations on database with Python This course is ideal for individuals who are Beginners to creating Python Database Driven Applications. It is particularly useful for Beginners to creating Python Database Driven Applications.

Enroll now: How to create a CRUD Application with Python and Oracle

Summary

Title: How to create a CRUD Application with Python and Oracle

Price: $49.99

Average Rating: 4.55

Number of Lectures: 23

Number of Published Lectures: 23

Number of Curriculum Items: 23

Number of Published Curriculum Objects: 23

Original Price: $59.99

Quality Status: approved

Status: Live

What You Will Learn

Installing Python

Installing Oracle Database Server

Creating a new database

Creating a new table

Create Graphical User Interface for application

Create and activate a virtual environment

Installing Oracle Python Database Connector

Creating database configuration file

Connecting to and interacting with database from Python

Create a class with methods

Creating stand alone functions

Wiring functions to widgets

Interacting with ListBox

Performing CRUD operations on database with Python

Who Should Attend

Beginners to creating Python Database Driven Applications.

Target Audiences

Beginners to creating Python Database Driven Applications.

In this course you  learn how to interface a Python  application program with an Oracle Server Database. Python has  various modules that you can use to  interact with databases. We will install CX_ORACLE connector module to enable us interact with Oracle Server database from our Python application.

We will be installing Python and Oracle database server  and also create a new database and table that our Python application will interact with.

We will create the Python application frontend using Tkinter which is a built in Python module used to create graphical user interfaces . From tkinter module we will import ttk module which is a themed widget library that contains various types of widgets like buttons,labels etc that we can use to build the graphical user interface for our Python application. We will also import other bits and pieces from the tkinter module that our Python application will use.

Also we will create a database configuration file that twill be used to interact with the Oracle Server database from our Python application. We will also be creating a class with methods and also stand alone functions for our application.

When the application is complete we will be able to perform CRUD operations on the Oracle database from our Python application.

Course Curriculum

Chapter 1: Setting Up Python Development Environment

Lecture 1: Introduction

Lecture 2: Installing Python on Windows

Lecture 3: Installing Atom

Chapter 2: Creating the application interface

Lecture 1: Creating project directory and Python File

Lecture 2: Creating the GUI – Part 1

Lecture 3: Creating the GUI – Part 2

Lecture 4: Creating the GUI – Part 3

Lecture 5: Creating the GUI – Part 4

Lecture 6: Creating the GUI – Part 5

Chapter 3: Setting Up Oracle Database

Lecture 1: Download and Install Oracle

Lecture 2: What is SQLPlus

Lecture 3: Unlock sample schema

Lecture 4: Install Oracle Developer

Lecture 5: Create a new table

Lecture 6: Connecting to Oracle Database

Lecture 7: Creating and activating a virtual environment

Lecture 8: Installing Oracle Database Driver

Chapter 4: Oracle Database and Python Application Interaction

Lecture 1: Setting Up a database configuration file

Lecture 2: Creating a Class with Methods

Lecture 3: Creating independent functions

Lecture 4: Activating the buttons widgets

Lecture 5: Performing Some CRUD Operations with application

Lecture 6: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes

2 stars: 2 votes

3 stars: 4 votes

4 stars: 9 votes

5 stars: 10 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!