How to create a CRUD Application with Python and SQL Server

[mitsumi]

How to create a CRUD Application with Python and SQL Server
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 0.97 GB
Genre: eLearning Video | Duration: 1 hour | Language: English + .srt

Create a Python Application to interact with SQL Server Database

What you'll 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

Description

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 tha twill be used to interact with the SQL Server database from our Python application.

Who this course is for:

    Beginners to Python
    Beginners to SQL
    Beginners to programming
       

               

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction