How to create a CRUD Application with Python and SQL Server

How to create a CRUD Application with Python and SQL Server, available at $59.99, has an average rating of 4.6, with 36 lectures, based on 191 reviews, and has 5205 subscribers.

You will learn about Importing Python Modules Creating Graphical User Interface using Tkinter and ttk Creating a class with methods Creating functions Creating a virtual environment Installing Microsoft SQL Server 2017 Express Edition Creating a database and table Connecting Python file to database Create pop up boxes for your application Insert data into SQL Server database from Python application Update existing records inside SQL Server database from Python application Delete records from SQL Server database from Python application Create a database configuration file This course is ideal for individuals who are Beginners to Python or Beginners to SQL or Beginners to programming It is particularly useful for Beginners to Python or Beginners to SQL or Beginners to programming.

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

Summary

Title: How to create a CRUD Application with Python and SQL Server

Price: $59.99

Average Rating: 4.6

Number of Lectures: 36

Number of Published Lectures: 36

Number of Curriculum Items: 36

Number of Published Curriculum Objects: 36

Original Price: $69.99

Quality Status: approved

Status: Live

What You Will Learn

Importing Python Modules
Creating Graphical User Interface using Tkinter and ttk
Creating a class with methods
Creating functions
Creating a virtual environment
Installing Microsoft SQL Server 2017 Express Edition
Creating a database and table
Connecting Python file to database
Create pop up boxes for your application
Insert data into SQL Server database from Python application
Update existing records inside SQL Server database from Python application
Delete records from SQL Server database from Python application
Create a database configuration file

Who Should Attend

Beginners to Python
Beginners to SQL
Beginners to programming

Target Audiences

Beginners to Python
Beginners to SQL
Beginners to programming

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

We will be installing Microsoft SQL Server 20117 express edition 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 SQL Server database from our Python application.

Course Curriculum

Chapter 1: Creating the application interface

Lecture 1: Introduction

Lecture 2: What is CRUD

Lecture 3: What we will create

Lecture 4: The source code

Lecture 5: Application design|sketch

Lecture 6: Install Python on Windows

Lecture 7: Install Python3 on Mac

Lecture 8: Install Atom text editor

Lecture 9: Compilers and interpreters

Lecture 10: Create a project directory and a python file

Lecture 11: Creating the application GUI interface – Part 1

Lecture 12: Creating the application GUI interface – Part 2

Lecture 13: Creating the application GUI interface – Part 3

Lecture 14: Creating the application GUI interface – Part 4

Lecture 15: Creating the application GUI interface – Part 5

Lecture 16: Adding comments to your code

Chapter 2: Setting up Microsoft SQL Server Database

Lecture 1: What is SQL Server

Lecture 2: Minimum Installation Requirements for SQL Server 2019

Lecture 3: Download SQL Server Developer Edition

Lecture 4: Install SQL Server 2019 Developer Edition

Lecture 5: Installing SSMS

Lecture 6: Connecting to SQL Server with SSMS

Lecture 7: Install SQL Server 2017 Express

Lecture 8: Create a new database and table

Lecture 9: Create a database configuration file

Lecture 10: Create a virtual environment and install pypyodbc

Lecture 11: Connect python file to database

Lecture 12: Create a cursor object

Lecture 13: Create a class and methods

Lecture 14: Add more methods to class

Lecture 15: Create function for selected row

Lecture 16: Create more functions

Lecture 17: Activate button widgets

Chapter 3: Application and Database Interaction

Lecture 1: Interact with database from application -Part 1

Lecture 2: Interact with database from application -Part 2

Lecture 3: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 4 votes
2 stars: 5 votes
3 stars: 23 votes
4 stars: 80 votes
5 stars: 79 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!

Menu