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

Python Database Course: SQLite, PostgreSQL, MySQL,SQLAlchemy

سرفصل های دوره

Master Databases in Python: In-Depth Training on SQLAlchemy, SQLite, PostgreSQL, and MySQL


1 - Introduction
  • 1 - How to use the Course

  • 2 - A Comprehensive Python Starter Kit
  • 2 - IDE Code Editor for the Course
  • 3 - Start Code.txt
  • 3 - Values and Types
  • 4 - Start Code Variables.txt
  • 4 - Variables
  • 5 - Operators
  • 5 - Start Code Operators.txt
  • 6 - Asking User for Input
  • 6 - Input Fucntion.txt
  • 7 - Python Comments
  • 7 - Python Comments.txt
  • 8 - Variable Naming
  • 9 - Boolean Expressions
  • 9 - Boolean Expressions.txt
  • 10 - Conditional Execution
  • 10 - Conditional Execution.txt
  • 11 - Nested Conditionals
  • 12 - Chained Conditionals
  • 13 - Multiple IF Statements
  • 14 - Logical Operators
  • 14 - Logical Operators.txt
  • 15 - Try and Except
  • 15 - Try and Except.txt
  • 16 - Builtin Functions.txt
  • 16 - Calling Builtin Functions
  • 17 - Math Module
  • 17 - Math Module.txt
  • 18 - Randomization.txt
  • 18 - Random Module
  • 19 - Defining Function
  • 19 - Defining Function.txt
  • 20 - Indentation.txt
  • 20 - Indentation in Python
  • 21 - Functions with Input.txt
  • 21 - Function with Inputs
  • 22 - Positional and Keyword Arguments
  • 22 - Positional and Keyword Arguments.txt
  • 23 - Function with Output
  • 23 - Function with Outputs.txt
  • 24 - Docstring
  • 24 - Docstring.txt
  • 25 - List and Iteration.txt
  • 25 - List and Iterations
  • 26 - Foor Loop.txt
  • 26 - For Loop
  • 27 - Start Here.txt
  • 27 - Updating Variables
  • 28 - Loop Over Custom Function
  • 28 - Start Code.txt
  • 29 - Range Function with Loop
  • 29 - Start Code.txt
  • 30 - While Loop
  • 31 - Continue and Break
  • 31 - Continue and Break.txt
  • 32 - Strings Start Code.txt
  • 32 - What is a String
  • 33 - String Operations
  • 33 - String Operations.txt
  • 34 - String Methods
  • 34 - String Methods.txt
  • 35 - String Parsing
  • 35 - String Parsing.txt
  • 36 - Escape Sequence
  • 36 - Escape Sequence.txt
  • 37 - String Formatting
  • 37 - String Formatting.txt

  • 3 - Introduction to Databases in Python
  • 38 - What is a Database
  • 39 - Relational Databases
  • 40 - Non Relational Databases
  • 41 - Python Database API

  • 4 - SQLite in Python
  • 42 - What is SQL
  • 43 - What is SQLite
  • 44 - Connect SQLite with Python
  • 44 - SQLite.zip
  • 45 - SQLite Browser
  • 46 - Create Table in SQLite
  • 46 - SQLite Data Types.txt
  • 47 - What is Cursor
  • 48 - Insert INTO Adding Data to a Table in SQLite
  • 49 - CSVtoSQLite.zip
  • 49 - CSVtoSQLiteSTART.zip
  • 49 - CSV Library Documentation.txt
  • 49 - Insert data from CSV to SQLite
  • 50 - SELECT Retrieve Data from SQLIte
  • 51 - WHERE Filter Data in SQLite
  • 52 - UPDATE Change Data
  • 53 - DELETE DROP Remove Data
  • 54 - JOINS Access Tables Together
  • 54 - JoinTables.zip

  • 5 - Real Project Password Manager using SQLite
  • 55 - What you will make by the end of the section
  • 56 - Step 1 Design Layout and Create Widgets
  • 57 - Step 2 Place Widgets on Screen
  • 58 - Step 3 Develop Backend
  • 59 - Password-Manager.zip
  • 59 - Step 4 Connecting Backend with Frontend

  • 6 - SQL Alchemy Core
  • 60 - What is SQLAlchemy
  • 61 - Connecting Database and Create Table using SQLAlchemy Core
  • 62 - Insert Data to SQLite using SQLAlchemy Core
  • 62 - SQLAlchemy.zip
  • 63 - Retrieve Data from SQLite using SQLAlchemy
  • 64 - Update Data using SQLAlchemy Core
  • 65 - Delete Data using SQLAlchemy Core
  • 66 - Join Tables Docs.txt
  • 66 - Join Tables using SQLAlchemy Core
  • 66 - SQLAlchemyJoins.zip

  • 7 - Password Manager Project using SQLAlchemy Core
  • 67 - Password-Manager.zip
  • 67 - What you will make by the end of the section
  • 68 - Develop Backend using SQLAlchemy Core
  • 68 - Password-Manager-SQLAlchemy-Core.zip

  • 8 - SQL Alchemy ORM
  • 69 - Connecting Database and Create Table using SQLAlchemy ORM
  • 70 - Insert Data to Database using SQLAlchemy ORM
  • 70 - SQLAlchemy-ORM.zip
  • 71 - Retrieve Data From Database using SQLAlchemy ORM
  • 72 - Filter Operations SQLAlchemy ORM
  • 73 - Update Data using SQLAlchemy ORM
  • 74 - Delete Data From Database using SQLAlchemy ORM
  • 75 - Building Relationship SQLAlchemy ORM
  • 76 - Join Tables using SQLAlchemy ORM

  • 9 - Password Manager using SQLAlchemy ORM
  • 77 - What you will make by the end of the section
  • 78 - Develop Backend Using SQLAlchemy ORM
  • 78 - Password-Manager-SQLAlchemy-ORM.zip
  • 78 - Password-Manager-SQLAlchemy-ORM-START.zip

  • 10 - MySQL in Python
  • 79 - What is MySQL
  • 80 - Downloads.txt
  • 80 - Installing MySQL on Mac
  • 81 - Installing MySQL Workbench on Mac
  • 82 - Installing MySQL and MySQL Workbench on Windows.html
  • 83 - Creating Database and Tables in MySQL
  • 83 - Data Types.txt
  • 84 - Connecting MySQL using Python
  • 85 - MySQL.zip
  • 85 - MySQL Database Operations using Python
  • 86 - MySQL-SLQAlchemy-ORM.zip
  • 86 - Pythonic Application SQLAlchemy ORM MySQL
  • 87 - InsertRetrieve Data to MySQL using SQLAlchemy ORM
  • 87 - MySQL-SLQAlchemy-ORM-2.zip
  • 88 - MySQL Challenge
  • 89 - Import Data from CSV to MySQL
  • 89 - MySQL-CSV-START.zip
  • 90 - Import Data using Pandas to MySQL
  • 90 - MySQL-Pandas.zip
  • 90 - MySQL-Pandas-START.zip

  • 11 - Employee Management System MySQL App
  • 91 - EMP-Manager-START.zip
  • 91 - What you will make by the end of the section
  • 92 - Step 1 Create Database and Table in MySQL
  • 93 - Step 2 Insert Data MySQL
  • 94 - EMP-Manager.zip
  • 94 - Step 3 FetchUpdateDelete Data from MySQL

  • 12 - PostgreSQL in Python
  • 95 - What is PostgreSQL
  • 96 - Installing PostgreSQL on Mac
  • 97 - Installing PostgreSQL on Windows.html
  • 98 - Create a PostgreSQL Database
  • 98 - employees.csv
  • 99 - Insert and Select Data using SQL Statements
  • 100 - PostgreSQL-Core.zip
  • 100 - Pythonic Interactions with PostgreSQL using SQLAlchemy Core
  • 101 - Pythonic Interactions with PostgreSQL using SQLAlchemy ORM
  • 102 - Create Stored Procedure in PostgreSQL and Call it using Python

  • 13 - HCM using PostgreSQL
  • 103 - HCM-PostgreSQL-START.zip
  • 103 - What you will make by the end of the section
  • 104 - HCM-PostgreSQL.zip
  • 104 - Project Solution PostgreSQL Implementation
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 32533
    حجم: 4295 مگابایت
    مدت زمان: 775 دقیقه
    تاریخ انتشار: ۶ فروردین ۱۴۰۳
    طراحی سایت و خدمات سئو

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