PostgreSQL Databases | Python Programming(Build App and API)
Mastering Data and Code: Unleashing the Power of PostgreSQL and Python to Build Dynamic Apps and APIs
3.90 (5 reviews)
1,037
students
11 hours
content
Feb 2025
last update
$54.99
regular price
What you will learn
Installing and configuring PostgreSQL.
Understanding the fundamental concepts of PostgreSQL databases.
Creating PostgreSQL databases and tables.
Understanding and utilizing PostgreSQL data types.
Understanding the concept of CRUD (Create, Read, Update, Delete) operations.
Performing CRUD operations in PostgreSQL.
Understanding and utilizing table joins in PostgreSQL.
Performing various types of PostgreSQL table joins like Inner Join, Left Join, Right Join, and Full Outer Join.
Understanding and utilizing PostgreSQL aggregate functions like COUNT, SUM, AVG, MAX, and MIN.
Creating and using PostgreSQL triggers for automatic database operations.
Basic Python programming syntax and concepts.
Understanding and using Python variables and data types.
Implementing conditional statements in Python.
Understanding and utilizing loops in Python.
Writing and calling Python functions.
Using Jupyter Notebook for Python coding and testing.
Connecting a PostgreSQL database with a Python application.
Performing database operations in Python using PostgreSQL.
Understanding the structure of a database-driven Python application.
Designing and building a database-driven Python application.
Introduction to API and their importance.
Basics of the Django framework and Django REST Framework.
Building APIs using Django and Django REST Framework.
Connecting an API to a PostgreSQL database.
Making API calls from a Python application.
Understanding the principles of the REST architecture.
Testing and debugging a Python application connected to a PostgreSQL database.
5344858
udemy ID
5/24/2023
course created date
5/27/2023
course indexed date
Bot
course submited by