MySQL Databases | Python Programming (Build App and API)

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

Build Database Driven App | Build API with Python, Django ,MySQL , REST Framework

1. MySQL Database Server Setup

1. Introduction

2. What is MySQL

3. MySQL Download and Installation on Windows

4. MySQL Download and Installation on Mac

5. What is MySQL Workbench

6. Installing MySQL Workbench on a Mac

7. Database Concepts

8. What is a Schema

9. Database Schema

10. MySQL Data Types

2. Introduction to Database Modeling

1. Introduction to data modeling

2. Creating a model - Part 1

3. Creating a model - Part 2

4. Basic Modeling

3. Creating MySQL Objects

1. MySQL Naming Convention

2. Creating a new MySQL Database

3. Using IF NOT EXIST DROP

4.1 table+create+script.zip

4. Creating a Table in MySQL

5. Setting a default database in MySQL

6. Using Comments

7. Primary Keys

8. Foreign Keys

4. MySQL Statements

1. Overview of some fundamental MySQL statements.html

2. What is CRUD

3. MySQL SELECT Statement

4.1 insert+data+into+tables.zip

4. MySQL INSERT Statement

5. MySQL UPDATE Statement

6. MySQL DELETE Statement

5. Data Extraction from multiple tables in MySQL

1. Introduction to MySQL Table Joins.html

2. MySQL INNER Join

3. MySQL LEFT Join

4. MySQL RIGHT Join

5. MySQL SELF Join

6. MySQL Stored Procedures

1. What are Stored Procedures

2.1 creating+stored+procedure.zip

2. Creating Stored Procedures

3.1 modifying+stored+procedure.zip

3. Modifying Stored Procedures

4.1 advanced+stored+procedure.zip

4. Creating an advanced Stored Procedure

5. Calling and deleting a Stored Procedure

7. MySQL Subqueries and Derived Tables

1. What is a Subquery

2. Nested Subqueries

3. Derived Tables

8. MySQL Aggregate Functions

1. Introduction to Aggregate Functions

2. AVG Aggregate Functions

3. COUNT Aggregate Functions

4. SUM Aggregate Functions

5. MIN Aggregate Functions

6. MAX Aggregate Functions

9. Python Setup

1. What is Python

2. What is Jupyter Notebook

3. Installing Jupyter Notebook Server

4. Running Jupyter Notebook Server

5. Jupyter Notebook Dashboard

6. Jupyter Notebook Dashboard

7. Creating a new Notebook

8. Notebook Components

10. Python Programming Fundamentals

1. Python Expressions

2. Python Statements

3. Python Comments

4. Python Data Types

5. Casting Data Types

6. Variables

7. Python List

8. Python Dictionary

9. Python Operators

10. Python Conditional Statements

11. Python Loops

12. Python Functions

11. Build a Database driven app with Python and MySQL

1. What we will build

2. Install Python on Windows

3. Install Python on Mac

4. Application Design

5. Note on Text Editors.html

6. Install Visual Studio Code

7. Creating a project directory and Python file

8. Creating the application interface - Part 1

9. Creating the application interface - Part 2

10. Creating the application interface - Part 3

11. Creating the application interface - Part 4

12. Creating the application interface - Part 5

13. Create a database and table

14. Create and activate a virtual environment

15. Install MySQL Connector

16. Creating a configuration connection file

17. Create a class with methods

18. Creating Functions

19. Activating button widgets

20. Modifying python file for mysql interaction

21. Testing connection to database with Python

22. Interacting with MySQL from Python - Part 1

23. Interacting with MySQL from Python - Part 2

24.1 mybooks.zip

24.2 mysql_config.zip

24. Project Code.html

12. Build API with Python Django MySQL REST Framework

1. Introduction.html

2. Create and activate a virtual environment

3. What is Django.html

4. Install Django

5. Install REST Framework

6. Install Corsheaders

7. Create a Django Project

8. Create a Django App

9. Register Applications

10. Django and MySQL Database Setup

11. Applying Initial Migration

12. Create a Django Model

13. Create and apply a new migration

14. Create a serializer class

15. Starting and stopping Django Development Server

16. Create a superuser account

17. Creating Views - Part 1

18. Creating Views - Part 2

19. Mapping Views to URLS

20. Register Model with Admin Site

21. Create Model Objects

22. Installing Postman

23. Testing API with CRUD Operations

24.1 project+code.rar

24. Project Code.html

45,900 تومان

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

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

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

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