PostgreSQL Databases | Python Programming(Build App and API)

Focused View

Skill Tree

11:02:37

78 View

1 - PostgreSQL Setup

1 - Introduction.mp4

00:20

2 - What is PostgreSQL.html

3 - PostgreSQL Installation Requirements.html

4 - Install PostgreSQL for Windows.mp4

09:53

5 - Install PostgreSQL for Mac.mp4

02:54

6 - Installing PgAdmin on Mac.mp4

05:23

7 - Connecting PgAdmin to PostgreSQL.mp4

09:35

8 - Install Sample Database.mp4

11:49

2 - PostgreSQL Fundamentals

9 - Database Concepts.mp4

04:31

10 - PostgreSQL Data Types.mp4

09:48

11 - PostgreSQL Unique Constraint.mp4

06:09

12 - Filtering data using WHERE Clause.mp4

06:58

13 - Retrieving all data from a table.mp4

06:33

14 - Retrieving data from a specific column.mp4

07:41

15 - Removing duplicate records.mp4

05:00

16 - Sorting Data.mp4

08:16

17 - Grouping Data.mp4

11:15

18 - Using the HAVING Clause.mp4

04:11

19 - Truncating a table.mp4

03:52

20 - Stored Procedures.mp4

04:44

3 - Performing CRUD Operation with PostgreSQL

21 - What is CRUD.mp4

00:56

22 - Create database with pgadmin.mp4

05:40

23 - Create a table with pgadmin.mp4

07:48

24 - Create a table with SQL Statement.mp4

08:40

25 - Inserting records.mp4

09:36

26 - Retrieve data with SQL SELECT Statement.mp4

05:10

27 - Retrieving data with a subquery.mp4

08:13

28 - Updating existing records.mp4

07:48

29 - Deleting records.mp4

05:26

4 - PostgreSQL Table Joins

30 - Introduction to table joins.mp4

01:06

31 - INNER Table Join.mp4

10:35

32 - LEFT Table Join.mp4

11:17

33 - FULL OUTER Table Join.mp4

10:21

34 - NATURAL Table Join.mp4

10:27

35 - CROSS Table Join.mp4

06:49

5 - PostgreSQL Aggregate Functions

36 - Introduction to Aggregate Functions.mp4

02:03

37 - AVG Aggregate Functions.mp4

11:56

38 - COUNT Aggregate Functions.mp4

11:09

39 - MAX Aggregate Functions.mp4

10:59

40 - MIN Aggregate Functions.mp4

08:58

41 - SUM Aggregate Functions.mp4

06:48

6 - PostgreSQL Triggers

42 - Introduction to triggers.mp4

08:38

43 - Creating a trigger Part 1.mp4

11:06

44 - Creating a trigger Part 2.mp4

08:49

45 - Creating a trigger Part 3.mp4

13:48

46 - Managing triggers.mp4

06:26

7 - Setting Up Python Programming Environment

47 - What is Python.mp4

05:16

48 - What is Jupyter Notebook.mp4

01:20

49 - Installing Jupyter Notebook Server.mp4

06:45

50 - Running Jupyter Notebook Server.mp4

08:44

51 - Notebook Dashboard.mp4

04:20

52 - Jupyter Notebook Interface.mp4

05:44

53 - Creating a new Notebook.mp4

06:45

8 - Python Programming Fundamentals

54 - Python Expressions.mp4

03:37

55 - Python Statements.mp4

04:42

56 - Python Comments.mp4

04:48

57 - Python Data Types.mp4

04:52

58 - Python Variables.mp4

07:28

59 - Python List.mp4

09:33

60 - Python Dictionaries.mp4

10:17

61 - Python Operators.mp4

14:55

62 - Python Conditional Statements.mp4

08:03

63 - Python Loops.mp4

09:04

64 - Python Functions.mp4

07:59

9 - Build a database driven app with PostgreSQL and Python

65 - What we will create.mp4

02:14

66 - Create a database and table.mp4

05:07

67 - Create sequence and alter table column.mp4

03:34

68 - Installing Python on Windows.mp4

03:38

69 - Installing Python on Macs.mp4

05:28

70 - Note on text editor.html

71 - Installing Text Editor.mp4

06:00

72 - Project design.mp4

01:37

73 - Create project directory and Python file.mp4

02:26

74 - Create the application interface Part 1.mp4

08:56

75 - Create the application interface Part 2.mp4

15:17

76 - Create and activate a virtual environment.mp4

03:46

77 - Install Python Database Connector.mp4

02:04

78 - Create database configuration file.mp4

04:35

79 - Connecting to PostgreSQL Database from Python file.mp4

06:16

80 - Create a class and methods.mp4

13:55

81 - Create standalone functions.mp4

12:51

82 - Binding button widgets to functions.mp4

04:06

83 - Testing the application.mp4

07:49

84 - Viewing database data with SQL.mp4

01:42

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

05:19

90 - Installing Django.mp4

02:49

91 - Installing REST Framework.mp4

01:05

92 - Installing Corsheaders.mp4

05:12

93 - Create a new Django Project.mp4

05:13

94 - Django App vs Django Project.html

95 - Registering Django Apps.mp4

03:50

96 - Django PostgreSQL Database Setup.mp4

04:42

97 - Applying initial migration.mp4

03:19

98 - Creating a serializer class.mp4

03:57

99 - Starting and stopping Django Server.mp4

03:32

100 - Creating a superuser account.mp4

04:48

101 - Creating views Part 1.mp4

10:56

102 - Creating views Part 2.mp4

07:08

103 - Mapping views to URLS.mp4

11:32

104 - Register model with Admin Site.mp4

04:07

105 - Creating model objects.mp4

06:13

106 - Installing Postman.mp4

04:52

107 - Testing API.mp4

09:06

108 - API.rar

108 - Project Code.html

Description

Mastering Data and Code: Unleashing the Power of PostgreSQL and Python to Build Dynamic Apps and APIs

What You'll Learn?

Installing and configuring PostgreSQL.
Understanding the fundamental concepts of PostgreSQL databases.
Creating PostgreSQL databases and tables.
Understanding and utilizing PostgreSQL data types.
Understanding the concept of CRUD (Create, Read, Update, Delete) operations.
Performing CRUD operations in PostgreSQL.
Understanding and utilizing table joins in PostgreSQL.
Performing various types of PostgreSQL table joins like Inner Join, Left Join, Right Join, and Full Outer Join.
Understanding and utilizing PostgreSQL aggregate functions like COUNT, SUM, AVG, MAX, and MIN.
Creating and using PostgreSQL triggers for automatic database operations.
Basic Python programming syntax and concepts.
Understanding and using Python variables and data types.
Implementing conditional statements in Python.
Understanding and utilizing loops in Python.
Writing and calling Python functions.
Using Jupyter Notebook for Python coding and testing.
Connecting a PostgreSQL database with a Python application.
Performing database operations in Python using PostgreSQL.
Understanding the structure of a database-driven Python application.
Designing and building a database-driven Python application.
Introduction to API and their importance.
Basics of the Django framework and Django REST Framework.
Building APIs using Django and Django REST Framework.
Connecting an API to a PostgreSQL database.
Making API calls from a Python application.
Understanding the principles of the REST architecture.
Testing and debugging a Python application connected to a PostgreSQL database.

Who is this for?

Beginner Programmers: Individuals who are starting their journey in programming and want to learn Python and PostgreSQL. This course provides foundational knowledge in Python and database management with PostgreSQL.

Experienced Programmers: Those already familiar with programming concepts but want to expand their knowledge into Python and PostgreSQL. This course can act as an efficient refresher or skill enhancer.

Database Administrators: Those who want to gain or enhance their understanding of PostgreSQL, including CRUD operations, table joins, triggers, and aggregate functions.

Web Developers: Those looking to build database-driven applications and APIs using Python, Django, and PostgreSQL. This course covers the use of Django REST Framework, which is widely used for API development.

Data Analysts and Data Scientists: Those who work with data regularly and want to enhance their data retrieval and manipulation skills using PostgreSQL. Python is also widely used in data analysis and machine learning, making this a good course for data professionals.

Career Changers: Individuals looking to shift their career into the tech industry, especially into roles such as software development, web development, or database administration.

IT Professionals: Those who wish to upskill by learning a modern programming language like Python and a robust database system like PostgreSQL.

Students: Those studying computer science or a related field, seeking to augment their academic knowledge with practical skills in Python and PostgreSQL.

This course is designed to cater to a broad spectrum of learners, ranging from beginners to experienced professionals looking to upgrade their skills or transition into new roles.

What You Need to Know?

Basic Computing Skills: Students should be comfortable with using a computer, installing software, and navigating the internet.

Familiarity with Programming: While not absolutely necessary, some familiarity with programming concepts would be advantageous. This could be in any language, not necessarily Python or SQL.

Understanding of Databases: Basic understanding of what a database is and why it is used can be helpful. Familiarity with SQL would be a bonus but is not required.

Python Installation: It's recommended to have a recent version of Python (3.x) installed on your system. You should also install Jupyter Notebook, which is a popular tool for running Python code. The installations are covered in the course.

PostgreSQL Installation: You'll need to install PostgreSQL on your system. Don't worry if you're not sure how to do this, as the course will guide you through the process.

Willingness to Learn: Most importantly, you should be curious and willing to learn new concepts and tools. This is a hands-on course, so you'll need to be ready to get involved and experiment with the code and concepts.

While meeting all these prerequisites will help you get the most out of the course, don't be discouraged if you don't meet them all right now. The course is designed to be accessible even to beginners, and we'll be covering all necessary foundational concepts as we go. The most important requirement is a willingness to learn.

More details

Description
Dive deep into the world of Python programming and PostgreSQL databases with our comprehensive course designed to take you from beginner to expert. In this dynamic and engaging course, you will learn the essential concepts and practices used by professional programmers and database administrators worldwide.
This course begins by guiding you through the PostgreSQL Setup, introducing you to the world of relational databases. You will gain a solid understanding of PostgreSQL Database Fundamentals, including database schemas, data types, and relationships.
Once you're comfortable with the basics, we'll venture into Performing PostgreSQL CRUD Operations, where you'll learn how to Create, Read, Update, and Delete data in your PostgreSQL databases. You'll then discover the power of PostgreSQL Table Joins, which allow you to combine data from multiple tables in powerful and insightful ways.
We'll also delve into advanced SQL concepts, including PostgreSQL Aggregate Functions for summarizing data, and PostgreSQL Triggers which allow automatic actions based on database events.
Shifting gears, we'll introduce you to Python, one of the world's most popular and powerful programming languages. You will get hands-on experience with Performing basic Python operations like Loops, conditional statements, Variables, and functions with Jupyter Notebook. This knowledge will form the foundation for all your Python programming.
The course then merges these two powerful tools â€“ Python and PostgreSQL. You will learn how to Build a database-driven application with PostgreSQL and Python, enabling you to create dynamic and interactive web applications.
Lastly, you'll enter the world of APIs. Building an API with Python, Django, PostgreSQL, and the REST Framework will be the final step in your journey. This will allow your applications to communicate with other applications, providing powerful and flexible functionality.
By the end of the course, you will have a thorough understanding of Python programming and PostgreSQL databases, and you will be able to create sophisticated web applications and APIs. Whether you're just starting your coding journey or looking to enhance your skills, this course will provide the knowledge and experience you need to succeed.

Who this course is for:
Beginner Programmers: Individuals who are starting their journey in programming and want to learn Python and PostgreSQL. This course provides foundational knowledge in Python and database management with PostgreSQL.
Experienced Programmers: Those already familiar with programming concepts but want to expand their knowledge into Python and PostgreSQL. This course can act as an efficient refresher or skill enhancer.
Database Administrators: Those who want to gain or enhance their understanding of PostgreSQL, including CRUD operations, table joins, triggers, and aggregate functions.
Web Developers: Those looking to build database-driven applications and APIs using Python, Django, and PostgreSQL. This course covers the use of Django REST Framework, which is widely used for API development.
Data Analysts and Data Scientists: Those who work with data regularly and want to enhance their data retrieval and manipulation skills using PostgreSQL. Python is also widely used in data analysis and machine learning, making this a good course for data professionals.
Career Changers: Individuals looking to shift their career into the tech industry, especially into roles such as software development, web development, or database administration.
IT Professionals: Those who wish to upskill by learning a modern programming language like Python and a robust database system like PostgreSQL.
Students: Those studying computer science or a related field, seeking to augment their academic knowledge with practical skills in Python and PostgreSQL.
This course is designed to cater to a broad spectrum of learners, ranging from beginners to experienced professionals looking to upgrade their skills or transition into new roles.

User Reviews

Rating

average 0

Total votes0

Focused display

Python

PostgreSQL

Skill Tree

Instructor's Courses

We are experienced company that provides quality video based training .Our courses are easy to follow and understand and will take you froman absolute beginner with no technical skills to being efficient and confident with various technical skill like SQL and databases.We have worked with companies of various sizes and provided consultancy services at various levels.Thank you for learning with us and we hope your experience will be pleasant.

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.