Python and SQL Application Development : Build an app

Python and SQL Application Development : Build an app

Python and SQL Application Development : Build an app

Learn how to Interact and manipulate SQL Databases from Python GUI

Language: english

Note: 0/5 (0 notes) 301 students  New course 

Instructor(s): Bluelime Learning Solutions

Last update: None

What you’ll learn

  • How to set up your Python environment and MySQL Server
  • Create application GUI with Python
  • Connecting to MySQL Server in Python
  • Creating a new Database
  • Creating a new Table
  • Create a class with methods in Python
  • Add new records into Table with Python GUI
  • Reading Data stored in database from Python GUI
  • Updating Records from Python GUI
  • Deleting Records from Python GUI
  • Interacting with SQL databases using from Python GUI

 

Requirements

  • Basic knowledge of Python and SQL

 

Udacity and OneTen Scholarship Opportunity

Python and SQL Application Development : Build an app

 

Description

Python is a popular programming language. It was created by Guido van Rossum, and released in 1991.


What can Python do?

  • Python can be used on a server to create web applications.

  • Python can be used alongside software to create workflows.

  • Python can connect to database systems. It can also read and modify files.

  • Python can be used to handle big data and perform complex mathematics.

  • Python can be used for rapid prototyping, or for production-ready software development.

  • Python works on different platforms (Windows, Mac, Linux, Raspberry Pi, etc).

  • Python has a simple syntax similar to the English language.

  • Python has syntax that allows developers to write programs with fewer lines than some other programming languages.

  • Python runs on an interpreter system, meaning that code can be executed as soon as it is written. This means that prototyping can be very quick.

  • Python can be treated in a procedural way, an object-oriented way or a functional way.


What is SQL?

  • SQL stands for Structured Query Language

  • SQL lets you access and manipulate databases

  • SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

  • What Can SQL do?

  • SQL can execute queries against a database

  • SQL can retrieve data from a database

  • SQL can insert records in a database

  • SQL can update records in a database

  • SQL can delete records from a database

  • SQL can create new databases

  • SQL can create new tables in a database

  • SQL can create stored procedures in a database

  • SQL can create views in a database

  • SQL can set permissions on tables, procedures, and views


You’ll learn how to pull data from relational databases straight into your  Python application.


 

Python and SQL Application Development : Build an appPython and SQL Application Development : Build an app

 

Who this course is for

  • Beginner Developers
  • Beginner Data Analyst
  • Beginner Data Scientist

 

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate