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

1 - PostgreSQL Setup

1 - Introduction

2 - What is PostgreSQL.html

3 - PostgreSQL Installation Requirements.html

4 - Install PostgreSQL for Windows

5 - Install PostgreSQL for Mac

6 - Installing PgAdmin on Mac

7 - Connecting PgAdmin to PostgreSQL

8 - Install Sample Database

2 - PostgreSQL Fundamentals

9 - Database Concepts

10 - PostgreSQL Data Types

11 - PostgreSQL Unique Constraint

12 - Filtering data using WHERE Clause

13 - Retrieving all data from a table

14 - Retrieving data from a specific column

15 - Removing duplicate records

16 - Sorting Data

17 - Grouping Data

18 - Using the HAVING Clause

19 - Truncating a table

20 - Stored Procedures

3 - Performing CRUD Operation with PostgreSQL

21 - What is CRUD

22 - Create database with pgadmin

23 - Create a table with pgadmin

24 - Create a table with SQL Statement

25 - Inserting records

26 - Retrieve data with SQL SELECT Statement

27 - Retrieving data with a subquery

28 - Updating existing records

29 - Deleting records

4 - PostgreSQL Table Joins

30 - Introduction to table joins

31 - INNER Table Join

32 - LEFT Table Join

33 - FULL OUTER Table Join

34 - NATURAL Table Join

35 - CROSS Table Join

5 - PostgreSQL Aggregate Functions

36 - Introduction to Aggregate Functions

37 - AVG Aggregate Functions

38 - COUNT Aggregate Functions

39 - MAX Aggregate Functions

40 - MIN Aggregate Functions

41 - SUM Aggregate Functions

6 - PostgreSQL Triggers

42 - Introduction to triggers

43 - Creating a trigger Part 1

44 - Creating a trigger Part 2

45 - Creating a trigger Part 3

46 - Managing triggers

7 - Setting Up Python Programming Environment

47 - What is Python

48 - What is Jupyter Notebook

49 - Installing Jupyter Notebook Server

50 - Running Jupyter Notebook Server

51 - Notebook Dashboard

52 - Jupyter Notebook Interface

53 - Creating a new Notebook

8 - Python Programming Fundamentals

54 - Python Expressions

55 - Python Statements

56 - Python Comments

57 - Python Data Types

58 - Python Variables

59 - Python List

60 - Python Dictionaries

61 - Python Operators

62 - Python Conditional Statements

63 - Python Loops

64 - Python Functions

9 - Build a database driven app with PostgreSQL and Python

65 - What we will create

66 - Create a database and table

67 - Create sequence and alter table column

68 - Installing Python on Windows

69 - Installing Python on Macs

70 - Note on text editor.html

71 - Installing Text Editor

72 - Project design

73 - Create project directory and Python file

74 - Create the application interface Part 1

75 - Create the application interface Part 2

76 - Create and activate a virtual environment

77 - Install Python Database Connector

78 - Create database configuration file

79 - Connecting to PostgreSQL Database from Python file

80 - Create a class and methods

81 - Create standalone functions

82 - Binding button widgets to functions

83 - Testing the application

84 - Viewing database data with SQL

85 - Project Code.html

85 - Project-code.zip

10 - Build API Using Python Django PostgreSQLREST Framework

86 - What is an API.html

87 - What is REST Framework.html

88 - What is Django.html

89 - Creating and activating a virtual environment

90 - Installing Django

91 - Installing REST Framework

92 - Installing Corsheaders

93 - Create a new Django Project

94 - Django App vs Django Project.html

95 - Registering Django Apps

96 - Django PostgreSQL Database Setup

97 - Applying initial migration

98 - Creating a serializer class

99 - Starting and stopping Django Server

100 - Creating a superuser account

101 - Creating views Part 1

102 - Creating views Part 2

103 - Mapping views to URLS

104 - Register model with Admin Site

105 - Creating model objects

106 - Installing Postman

107 - Testing API

108 - API.rar

108 - Project Code.html

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training