PostgreSQL Databases & Python


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


Subscribe to latest coupons on our Telegram channel.

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

Enroll for Free

Share This Course on:
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock