How to create a CRUD Application with Python and SQL Server

Create a Python Application to interact with SQL Server Database

Created by: Bluelime Learning Solutions
Making Learning Simple

What Will I 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

Requirements

• Basic knowledge of SQL will help but not essential
• Basic knowledge of Python

Target audience

• Beginners to Python
• Beginners to SQL
• Beginners to programming