PostgreSQL Databases Python

PostgreSQL Databases & Python, available at $39.99, has an average rating of 3.4, with 39 lectures, based on 26 reviews, and has 5477 subscribers.

You will learn about PostgreSQL Python-Psycopg2 How to build and host an interactive website on digital ocean with a PostgreSQL database This course is ideal for individuals who are Beginner database engineers or web devellopers. or Anyone who wants to build his own interactive website It is particularly useful for Beginner database engineers or web devellopers. or Anyone who wants to build his own interactive website.

Enroll now: PostgreSQL Databases & Python

Summary

Title: PostgreSQL Databases & Python

Price: $39.99

Average Rating: 3.4

Number of Lectures: 39

Number of Published Lectures: 39

Number of Curriculum Items: 39

Number of Published Curriculum Objects: 39

Original Price: 99.99

Quality Status: approved

Status: Live

What You Will Learn

PostgreSQL

Python-Psycopg2

How to build and host an interactive website on digital ocean with a PostgreSQL database

Who Should Attend

Beginner database engineers or web devellopers.

Anyone who wants to build his own interactive website

Target Audiences

Beginner database engineers or web devellopers.

Anyone who wants to build his own interactive website

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: What you will learn in this class?

Chapter 2: Data Storage and Usage in Python

Lecture 1: Introduction

Lecture 2: Store and read Data in Python with text files

Lecture 3: Store and read Data in Python with excel files: pandas

Lecture 4: What is a Database and what are the use cases?

Lecture 5: What are the different Linux databases?

Lecture 6: Why use databases ?

Chapter 3: PostgreSQL Databases

Lecture 1: Install PostgreSQL on Debian Linux , and start database

Lecture 2: Create and Delete Users

Lecture 3: Create and Delete Databases

Lecture 4: Dump and Restore Databases

Chapter 4: SQL commands

Lecture 1: SQL commands: Introduction

Lecture 2: CREATE/DROP TABLE

Lecture 3: PRIMARY KEY

Lecture 4: INSERT INTO

Lecture 5: SELECT

Lecture 6: UPDATE

Lecture 7: DELETE

Lecture 8: CREATE/DROP INDEX

Lecture 9: SELECT DISTINCT

Lecture 10: ORDER BY

Lecture 11: GROUP BY

Lecture 12: BETWEEN

Lecture 13: JOIN

Lecture 14: LIMIT

Lecture 15: EXISTS

Lecture 16: FOREIGN KEY

Lecture 17: GRANT

Lecture 18: COUNT

Lecture 19: MAX, MIN ,AVG

Lecture 20: SUM

Lecture 21: SQL SUBQUERY

Chapter 5: Databases for Web Hosting

Lecture 1: Introduction

Lecture 2: Install and Setup your LAPP stack ( Linux Apache PostgreSQL Php) on the cloud

Lecture 3: Interacting with the Database

Chapter 6: Python and Postgresql with psycopg2

Lecture 1: Connect to Database with python psycopg2

Lecture 2: Write changes to Database

Lecture 3: Read data from Database

Lecture 4: Passing parameters to SQL queries

Instructors

Lucas Mayrhofer
Computer scientist and Teacher

Rating Distribution

1 stars: 2 votes

2 stars: 2 votes

3 stars: 4 votes

4 stars: 7 votes

5 stars: 11 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!