The Complete Beginner to Advanced PostgreSQL Course 2024

Focused View

Hoang Quy La

6:18:16

119 View

1. Introduction

1. Course structure.mp4

01:53

2. How to make the most out of this course.mp4

01:52

3. How to install pgAdmin 4.mp4

03:33

4. what is relational databases.mp4

04:03

5. How to create a database and delete a database.mp4

01:51

6. Introduction to some of the basic SQL Commands.mp4

13:15

Files.zip

2. Data Types and Operators

1. What are data types and how to work with them.mp4

12:53

2. What are primary keys.mp4

03:04

3. what are Operators and Functions and how to implement both of them.mp4

21:29

3. Database Design and Management

1. what is Database Design Principles.mp4

04:45

2. Introduction to normalization and implementation.mp4

23:07

3. Explanation of REFERENCES keywords.mp4

03:49

4. Introduction to entity relationship modeling.mp4

04:52

5. Introduction to one to one relationship.mp4

06:17

6. Introduction to one to many relationship.mp4

05:56

7. Introduction to Many to many relationship.mp4

07:14

8. What are constraints in postgreSQL.mp4

04:55

9. Example of constraints in postgreSQL.mp4

09:38

10. Introduction to indexes in postgreSQL.mp4

07:07

11. Introduction to transactions in postgreSQL.mp4

11:15

Files.zip

4. Manipulating and retrieving data

1. How to filter in postgreSQL.mp4

08:05

2. How to sort in postgreSQL.mp4

04:55

3. Introduction to join in PostgreSQL.mp4

13:18

4. Introduction to LIKE clause.mp4

08:42

5. Introduction to ILIKE clause.mp4

05:03

6. Introduction to distinct.mp4

03:43

7. Introduction to limit and offset.mp4

05:39

8. Deep dive into subqueries in PostgreSQL.mp4

21:38

9. Introduction to NOT EXISTS clause.mp4

04:06

10. Introduction to EXISTS clause.mp4

03:56

11. Introduction to HAVING clause.mp4

06:56

12. What is upsert in PostgreSQL.mp4

07:10

13. Time to test knowledge.html

Files.zip

5. Advanced SQL Features

1. How to add a new column into existing table.mp4

04:45

2. Introduction to Common Table Expressions (CTEs) with implementation.mp4

08:53

3. Introduction to window function with implementation.mp4

06:48

4. Introduction to RANK() function with implementation.mp4

04:47

5. Introduction to procedure in postgreSQL.mp4

08:17

6. Introduction to Recursive Queries with implementation.mp4

06:46

7. Time to test knowledge.html

Files.zip

6. Advanced Database Administration

1. Introduction to User Management and Permissions.mp4

05:19

2. How to create users and roles in postgreSQL.mp4

05:00

3. What is ACLs.mp4

07:09

4. How to list users and roles.mp4

06:14

5. Introduction to RLs.mp4

06:57

6. how to list all Row-level security.mp4

06:58

Files.zip

7. Some other advanced concepts

1. Introduction to Transaction Isolation.mp4

12:24

2. What is MVCC.mp4

04:01

3. Introduction to Savepoints.mp4

05:59

4. What is Deadlocks .mp4

03:36

5. What is VACUUMM.mp4

08:30

6. what is The EXPLAIN statement.mp4

05:37

7. Examples of query tuning.mp4

09:40

8. Introduction to ANALYZE keywords.mp4

03:21

Files.zip

8. Thank you

1. Thank you.mp4

01:16

Description

Database Design Principles, Normalization, Entity relationship modelling, Common table expressions (CTES), ACLs, RLs

What You'll Learn?

pgAdmin4
create and delete a database
data types
primary keys
operators
functions
Database Design Principles
Normalization
References keywords
Entity relationship modelling
one to one relationship
one to many relationship
Many to many relationship
Constraints
indexes
transactions
filter
sort
join
like
ilike
distinct
subqueries
Not exists
exists
having
upsert
Common table expressions (CTES)
Rank function
window function
procedure
Recursive queries
User management and permissions
How to create users and roles
ACLs
list all users and roles
RLs
Transaction Isolation
MVCC
Savepoints
Deadlocks
Vacuumm
explain statement
query tuning
Analyze keyword
Variables, constrol structure, if-then-else, case statement, for-loop, while-loop, error tyoes, exception handling.
functions, cursors, Raise, procedures, triggers
Dynamic SQL concepts, SQL injections
lock, table-level-lock, AccessShareLock, RowShareLock, RowExclusiveLock, ShareLock, ExclusiveLock, AccessExclusiveLock, Database-level locks, Explicit Lock.

Who is this for?

Individuals who are new to databases and want to learn the fundamentals of PostgreSQL from scratch.

Professionals responsible for managing and maintaining databases who wish to enhance their knowledge and skills in PostgreSQL administration.

Programmers who want to integrate PostgreSQL into their applications or learn how to interact with databases using SQL and PostgreSQL-specific features.

Those interested in working with large datasets, analyzing data, and gaining insights using PostgreSQL's analytical capabilities.

Students pursuing degrees in computer science, information technology, or related fields, as well as individuals interested in databases as a hobby or for personal projects.

What You Need to Know?

No prior knowledge will be required

More details

Description
Welcome to "The Complete Introduction to PostgreSQL Course 2024" on Udemy! Whether you're a beginner looking to learn the fundamentals of PostgreSQL or an experienced professional seeking to enhance your database management skills, this course is designed to provide you with a comprehensive understanding of PostgreSQL, one of the most powerful open-source relational database management systems (RDBMS) available today.
In this course, you will embark on a journey through the core concepts of PostgreSQL, starting with an introduction to relational databases and SQL (Structured Query Language). You will learn how to install PostgreSQL, set up databases, and perform basic SQL commands to query and manipulate data effectively.
As you progress, you will delve into more advanced topics, including database design principles, normalization, and entity-relationship modeling. You will explore PostgreSQL's rich feature set, including data types, constraints, and functions, and learn how to harness the power of SQL for data analysis and manipulation.
Throughout the course, you can apply your knowledge through hands-on exercises and real-world examples. You will gain practical experience in creating tables, designing schemas, writing stored procedures, and implementing triggers to automate tasks and enforce data integrity.
By the end of this course, you will have a solid understanding of PostgreSQL and the skills to work confidently with databases in various roles, including database administration, software development, data analysis, and more. Whether building applications, managing data, or exploring new career opportunities, "The Complete Introduction to PostgreSQL Course 2024" will equip you with the knowledge and tools you need to succeed.

Below areÂ topics covered in this course:
Data types and operators.
Primary keys.
Operators and functions.
Reference keywords.
one-one relationship.
one-to-many relationship
Many-to-many relationship.
Constraints
Indexes.
transactions.
Filter
Sort
Join
Like
ILIKE
Distinct
limit and offset
subqueries
not exists
exists
having
upsert
How to add a new column
CTE (Common table expression)
Window function
RANK() function
Procedure
Recursive Queries
User Management and permissions
users and roles
ACLs
list users and roles
Row-level security
transaction Isolation
MVCC
Savepoints
Deadlocks
Vacuumm
Explain statement
query tuning
Analyze keywords
Variables, constrol structure, if-then-else, case statement, for-loop, while-loop, error tyoes, exception handling.
functions, cursors, Raise, procedures, triggers
Dynamic SQL concepts, SQL injections
lock, table-level-lock, AccessShareLock, RowShareLock, RowExclusiveLock, ShareLock, ExclusiveLock, AccessExclusiveLock, Database-level locks, Explicit Lock.
Enroll now and take the first step towards mastering PostgreSQL! Let's dive into the world of databases together.
Take advantage of this opportunity to learn PostgreSQL from industry experts. Enroll now and unlock the full potential of PostgreSQL for your projects and career aspirations!
Who this course is for:
Individuals who are new to databases and want to learn the fundamentals of PostgreSQL from scratch.
Professionals responsible for managing and maintaining databases who wish to enhance their knowledge and skills in PostgreSQL administration.
Programmers who want to integrate PostgreSQL into their applications or learn how to interact with databases using SQL and PostgreSQL-specific features.
Those interested in working with large datasets, analyzing data, and gaining insights using PostgreSQL's analytical capabilities.
Students pursuing degrees in computer science, information technology, or related fields, as well as individuals interested in databases as a hobby or for personal projects.

User Reviews

Rating

average 0

Total votes0

Focused display

My name is Hoang Quy La. I did graduate from RMIT University as a first class honours in electrical engineering and I am currently studying master of software engineering in CDU at Australia. I have taught over 1250 students with 5 star reviews. I did develop a AI Chatbot with Tensorflow 2.0 with Flask by using Python and this Chatbot was implemented in the top University in Viet Nam. My current project is about AI in Healthcare applications. I also did complete my internship at SGS and Power System Company. Check my LinkedIn for all projects which I did in AI field.

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.