MySQL Databases | Python Programming (Build App and API)

Focused View

247 Learning

10:45:09

58 View

1. MySQL Database Server Setup

1. Introduction.mp4

00:20

2. What is MySQL.mp4

03:31

3. MySQL Download and Installation on Windows.mp4

14:55

4. MySQL Download and Installation on Mac.mp4

06:58

5. What is MySQL Workbench.mp4

06:02

6. Installing MySQL Workbench on a Mac.mp4

05:36

7. Database Concepts.mp4

09:00

8. What is a Schema.mp4

02:50

9. Database Schema.mp4

04:50

10. MySQL Data Types.mp4

06:56

2. Introduction to Database Modeling

1. Introduction to data modeling.mp4

01:49

2. Creating a model - Part 1.mp4

11:05

3. Creating a model - Part 2.mp4

06:25

4. Basic Modeling.mp4

06:06

3. Creating MySQL Objects

1. MySQL Naming Convention.mp4

05:05

2. Creating a new MySQL Database.mp4

06:31

3. Using IF NOT EXIST DROP.mp4

04:41

4.1 table+create+script.zip

4. Creating a Table in MySQL.mp4

12:43

5. Setting a default database in MySQL.mp4

05:03

6. Using Comments.mp4

05:38

7. Primary Keys.mp4

04:09

8. Foreign Keys.mp4

06:00

4. MySQL Statements

1. Overview of some fundamental MySQL statements.html

2. What is CRUD.mp4

02:02

3. MySQL SELECT Statement.mp4

08:22

4.1 insert+data+into+tables.zip

4. MySQL INSERT Statement.mp4

08:48

5. MySQL UPDATE Statement.mp4

10:51

6. MySQL DELETE Statement.mp4

05:06

5. Data Extraction from multiple tables in MySQL

1. Introduction to MySQL Table Joins.html

2. MySQL INNER Join.mp4

11:57

3. MySQL LEFT Join.mp4

06:05

4. MySQL RIGHT Join.mp4

04:13

5. MySQL SELF Join.mp4

08:07

6. MySQL Stored Procedures

1. What are Stored Procedures.mp4

03:46

2.1 creating+stored+procedure.zip

2. Creating Stored Procedures.mp4

06:54

3.1 modifying+stored+procedure.zip

3. Modifying Stored Procedures.mp4

05:13

4.1 advanced+stored+procedure.zip

4. Creating an advanced Stored Procedure.mp4

07:26

5. Calling and deleting a Stored Procedure.mp4

05:32

7. MySQL Subqueries and Derived Tables

1. What is a Subquery.mp4

04:37

2. Nested Subqueries.mp4

03:22

3. Derived Tables.mp4

04:15

8. MySQL Aggregate Functions

1. Introduction to Aggregate Functions.mp4

06:02

2. AVG Aggregate Functions.mp4

03:29

3. COUNT Aggregate Functions.mp4

08:49

4. SUM Aggregate Functions.mp4

04:22

5. MIN Aggregate Functions.mp4

02:25

6. MAX Aggregate Functions.mp4

02:48

9. Python Setup

1. What is Python.mp4

05:16

2. What is Jupyter Notebook.mp4

01:20

3. Installing Jupyter Notebook Server.mp4

06:45

4. Running Jupyter Notebook Server.mp4

08:44

5. Jupyter Notebook Dashboard.mp4

04:20

6. Jupyter Notebook Dashboard.mp4

05:44

7. Creating a new Notebook.mp4

06:45

8. Notebook Components.mp4

04:26

10. Python Programming Fundamentals

1. Python Expressions.mp4

03:37

2. Python Statements.mp4

04:42

3. Python Comments.mp4

04:48

4. Python Data Types.mp4

04:52

5. Casting Data Types.mp4

02:57

6. Variables.mp4

07:28

7. Python List.mp4

09:33

8. Python Dictionary.mp4

10:17

9. Python Operators.mp4

14:55

10. Python Conditional Statements.mp4

08:03

11. Python Loops.mp4

09:04

12. Python Functions.mp4

07:59

11. Build a Database driven app with Python and MySQL

1. What we will build.mp4

01:39

2. Install Python on Windows.mp4

04:34

3. Install Python on Mac.mp4

06:57

4. Application Design.mp4

01:49

5. Note on Text Editors.html

6. Install Visual Studio Code.mp4

06:00

7. Creating a project directory and Python file.mp4

02:36

8. Creating the application interface - Part 1.mp4

10:30

9. Creating the application interface - Part 2.mp4

07:31

10. Creating the application interface - Part 3.mp4

12:18

11. Creating the application interface - Part 4.mp4

11:53

12. Creating the application interface - Part 5.mp4

07:00

13. Create a database and table.mp4

05:20

14. Create and activate a virtual environment.mp4

03:41

15. Install MySQL Connector.mp4

01:50

16. Creating a configuration connection file.mp4

02:02

17. Create a class with methods.mp4

12:59

18. Creating Functions.mp4

04:09

19. Activating button widgets.mp4

03:30

20. Modifying python file for mysql interaction.mp4

06:02

21. Testing connection to database with Python.mp4

02:15

22. Interacting with MySQL from Python - Part 1.mp4

06:02

23. Interacting with MySQL from Python - Part 2.mp4

01:59

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.mp4

05:19

3. What is Django.html

4. Install Django.mp4

02:49

5. Install REST Framework.mp4

01:05

6. Install Corsheaders.mp4

05:12

7. Create a Django Project.mp4

05:13

8. Create a Django App.mp4

02:38

9. Register Applications.mp4

03:50

10. Django and MySQL Database Setup.mp4

13:53

11. Applying Initial Migration.mp4

03:19

12. Create a Django Model.mp4

05:26

13. Create and apply a new migration.mp4

05:19

14. Create a serializer class.mp4

03:57

15. Starting and stopping Django Development Server.mp4

03:32

16. Create a superuser account.mp4

04:48

17. Creating Views - Part 1.mp4

10:56

18. Creating Views - Part 2.mp4

07:08

19. Mapping Views to URLS.mp4

11:32

20. Register Model with Admin Site.mp4

04:07

21. Create Model Objects.mp4

06:13

22. Installing Postman.mp4

04:52

23. Testing API with CRUD Operations.mp4

09:06

24.1 project+code.rar

24. Project Code.html

Description

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

What You'll Learn?

Setting up MySQL Database Server
Creating Objects like Databases and Tables in MySQL
Setting up Python
Setting up a development environment for Django.
Implementing MySQL table joins
Mastering the basic syntax and constructs of Python.
Writing Python functions and classes using object-oriented programming (OOP).
Integrating MySQL with Django using Django's Object-Relational Mapping (ORM).
Building an API using Django and Django REST Framework.
Implementing Create, Retrieve, Update, Delete (CRUD) operations in the API.
Testing APIs using tools like Postman
Understanding API serialization and how to use it in Django REST Framework.
Building a desktop application with Python and MySQL

Who is this for?

Beginner Python Developers

Beginner Database Administrators

Beginner Data Scientist

Beginner Data Analyst

Beginner Data Engineers

What You Need to Know?

Basic knowledge of Python advised but not mandatory

Basic knowledge of Database Concepts advised but not mandatory

Software required is covered in the course.

More details

Description
In this comprehensive course, you will embark on a journey of learning and practical application that leverages MySQL databases and Python programming. By the end of this course, you'll have built a database-driven application and an API using Python, Django, MySQL, and the REST framework.
MySQL, an open-source relational database management system (RDBMS), is renowned for its speed and reliability. Python, on the other hand, is a versatile and powerful high-level programming language, praised for its simplicity and readability. The combination of these two technologies provides a solid foundation for creating robust and scalable web applications.
The first part of the course is dedicated to providing you with a thorough understanding of MySQL databases, where you will explore MySQL's capabilities, including data types, operators, SQL statements, and table joins. From creating databases and tables to writing complex queries, you'll gain hands-on experience and learn best practices for optimizing your database.
Next, you'll immerse yourself in Python programming, where you will learn PythonÂ fundamentals which includes, Expressions, Statements, Variables, Operators, conditional statements,loops and functions.
We will explore how to buildÂ a database driven application and API using Python,MySQL, Django and the REST Framework.
Throughout the course, we'll be creating a fully functional web application and API from scratch, which will serve as a tangible testament to your newfound skills. This project-based learning approach ensures you understand the concepts and how they come together in real-world applications.
Whether you're a beginner looking to jumpstart your career in web development, or an experienced programmer aiming to add new tools to your repertoire, this course will provide you with a thorough understanding and practical skills to build database-driven apps and APIs with Python, Django, MySQL, and the REST Framework.
Join us in this exciting course, "MySQL Databases | Python Programming: Build Database Driven App and API", and take your web development skills to the next level.

Who this course is for:
Beginner Python Developers
Beginner Database Administrators
Beginner Data Scientist
Beginner Data Analyst
Beginner Data Engineers

User Reviews

Rating

average 0

Total votes0

Focused display

Hello and welcome to 247 Learning.We create online courses that will help you acquire useful and productive technical skills that can be applied to real world jobs. We have over 18,000 students on Udemy that have signed up to our courses . We are continuously adding more courses to our course catalogues. We are looking forward to welcoming you to one or more of our courses.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.