PostgreSQL Databases & Python
- Description
- Curriculum
- FAQ
- Reviews
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
-
2
Introduction -
3
Store and read Data in Python with text files
This lecture is about writing and reading from text files in python. Text files are very simple way to store and use data with python. But this is recommended only for simple use cases and simple datastructures as we will see later in the course.
-
4
Store and read Data in Python with excel files: pandas
This Lecture is about writing and reading excel files with python using the pandas library. This is a useful way of storing and using data in python. Your system needs to have an excel spreadsheet reader like gnumeric for example and pandas library installed. Installation process is explained as well.
-
5
What is a Database and what are the use cases?
Definition of a Database , classification of the different types of databases and presentation of the most common use cases for databases.
-
6
What are the different Linux databases?
This is a small list and description of the most common databases available on the market today.
-
7
Why use databases ?
This Lecture is about the advantages of Databases compared to other methods showed previously like text files and excel files. The main drawback compared to these other methods is maybe the complexity. But this class is here to make sure you know how to use databases efficiently for your purpose.
-
8
Install PostgreSQL on Debian Linux , and start database
How to install PostgreSQL on Debian Linux and start the database. You will also learn how to stop the database and check the status of database ( if it is active or inactive)
-
9
Create and Delete Users
How to create and delete postgres Users.
-
10
Create and Delete Databases
How to create and delete PostgreSQL Databases with concrete example.
-
11
Dump and Restore Databases
How to dump and restore databases in order to transfer databases between different computer systems.
-
12
SQL commands: Introduction
-
13
CREATE/DROP TABLE
How to create and delete a PostgreSQL table
-
14
PRIMARY KEY
What are Primary Keys and why do you need primary keys? A concrete example is given.
-
15
INSERT INTO
How to Insert new values inside a PostgreSQL table.
-
16
SELECT
How to Select content from a table.
-
17
UPDATE
How to update values in a table.
-
18
DELETE
-
19
CREATE/DROP INDEX
How to create and drop an Index
-
20
SELECT DISTINCT
How to select distinct values from a table.
-
21
ORDER BY
How to Order your query search results.
-
22
GROUP BY
How to group query search results.
-
23
BETWEEN
Lecture about BETWEEN keyword.
-
24
JOIN
Lecture about JOIN keyword.
-
25
LIMIT
Lecture about LIMIT keyword.
-
26
EXISTS
Lecture about EXISTS keyword.
-
27
FOREIGN KEY
What are Foreign Keys? And how do you use one?
-
28
GRANT
How to Grant privileges on a database to a user.
-
29
COUNT
How to count the number of rows satisfying a certain property.
-
30
MAX, MIN ,AVG
Lecture about the MAX, MIN and AVG keywords.
-
31
SUM
How to SUM values of a column.
-
32
SQL SUBQUERY
What is an SQL SUBQUERY and an example of how to use one.
-
33
Introduction
-
34
Install and Setup your LAPP stack ( Linux Apache PostgreSQL Php) on the cloud
This lecture teaches you how to install a Linux Apache Postgresql Php stack to host a website on the cloud. After this lecture you will be able to put your first static website online on the cloud. For database Interaction and configuration you need to check out lecture 35.
-
35
Interacting with the Database
In this lecture we learn how to configure the different configuration files ( php.ini, pg_hba.conf ...) to put your website online and make sure the interaction between database and client is working smoothly. We give a small example website with database that let's the user write a link and link name inside our database. We explain the php and html code carefully. First example of a dynamic website on the cloud!
