Tutorials – Postgres
In this lesson we learn how to use the following Postgres aggregate functions: AVG function and SUM function, which are both aggregate functions in PostgreSQL. We also explore a statement required for filtering of aggregated data; “HAVING”.
Backup and Restore with PostgreSQL, Python, and HTML.
Backup Your PostgreSQL for a potential restore.
Duplicate tables from your PostgreSQL database using Python.
Write a Python app to create and Delete PostgreSQL tables.
Edit Columns with PostgreSQL and Python
Foreign Keys in PostgreSQL.
Forum Login with Python and PostgreSQL.
Manage Forum Posting with Python and PostgreSQL.
Forum Registration with Python and PostgreSQL.
For storing and retrieving images and other large data to and from a database. Get blob data type from Postgres using Python.
Get Records from Postgres using Python.
Using Group By in PostgreSQL.
Upload images to Postgres using Python.
Injection Prevention for PostgreSQL.
Return a limited recordset to be returned in Postgres using Python.
See a list of all tables in your PostgreSQL database using Python.
Explanation of various Loop Types for Postgres, using Python scripting.
Machine Learning using Python and PostgreSQL.
Make a game in Python – Draw Sprites.
Make a game in Python – Draw the Screen.
Make a game in Python – Move Monsters.
Make a game in Python – Move Player.
Make a game in Python – Player Login.
Make a game in Python – Player Registration.
Make a game in Python – Save Game to Postgres database.
Make a game in Python – add sounds and music to your game!
Make a game in Python – Sprite Collisions.
Make a game in Python – Sprite Intelligence. How to make the monsters “smart”.