Python and SQL Application Development : Build an app

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.