The All in One PostgreSQL Class
What you will learn
PostgreSQL
Python-Psycopg2
How to build and host an interactive website on digital ocean with a PostgreSQL database
Description
In this class you will learn how to install and use PostgreSQL databases, SQL commands, how to host an interactive website on the cloud with a PostgreSQL database. We provide a small example website with user interaction hosted on the cloud using PostgreSQL , PHP and HTML : we show how to configure your Webserver for PostgreSQL. The last part is about python and PostgreSQL interfacing for more advanced usage of PostgreSQL databases
English
language
Content
Introduction
What you will learn in this class?
Data Storage and Usage in Python
Introduction
Store and read Data in Python with text files
Store and read Data in Python with excel files: pandas
What is a Database and what are the use cases?
What are the different Linux databases?
Why use databases ?
PostgreSQL Databases
Install PostgreSQL on Debian Linux , and start database
Create and Delete Users
Create and Delete Databases
Dump and Restore Databases
SQL commands
SQL commands: Introduction
CREATE/DROP TABLE
PRIMARY KEY
INSERT INTO
SELECT
UPDATE
DELETE
CREATE/DROP INDEX
SELECT DISTINCT
ORDER BY
GROUP BY
BETWEEN
JOIN
LIMIT
EXISTS
FOREIGN KEY
GRANT
COUNT
MAX, MIN ,AVG
SUM
SQL SUBQUERY
Databases for Web Hosting
Introduction
Install and Setup your LAPP stack ( Linux Apache PostgreSQL Php) on the cloud
Interacting with the Database
Python and Postgresql with psycopg2
Connect to Database with python psycopg2
Write changes to Database
Read data from Database
Passing parameters to SQL queries