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

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 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 15996
    حجم: 2944 مگابایت
    مدت زمان: 663 دقیقه
    تاریخ انتشار: ۱۵ تیر ۱۴۰۲
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید