The Complete Beginner to Advanced PostgreSQL Course 2024

The Complete Beginner to Advanced PostgreSQL Course 2024, available at $54.99, has an average rating of 4.77, with 91 lectures, 2 quizzes, based on 23 reviews, and has 76 subscribers.

You will learn about 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. This course is ideal for individuals who are Individuals who are new to databases and want to learn the fundamentals of PostgreSQL from scratch. or Professionals responsible for managing and maintaining databases who wish to enhance their knowledge and skills in PostgreSQL administration. or Programmers who want to integrate PostgreSQL into their applications or learn how to interact with databases using SQL and PostgreSQL-specific features. or Those interested in working with large datasets, analyzing data, and gaining insights using PostgreSQLs analytical capabilities. or 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. It is particularly useful for Individuals who are new to databases and want to learn the fundamentals of PostgreSQL from scratch. or Professionals responsible for managing and maintaining databases who wish to enhance their knowledge and skills in PostgreSQL administration. or Programmers who want to integrate PostgreSQL into their applications or learn how to interact with databases using SQL and PostgreSQL-specific features. or Those interested in working with large datasets, analyzing data, and gaining insights using PostgreSQLs analytical capabilities. or 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.

Enroll now: The Complete Beginner to Advanced PostgreSQL Course 2024

Summary

Title: The Complete Beginner to Advanced PostgreSQL Course 2024

Price: $54.99

Average Rating: 4.77

Number of Lectures: 91

Number of Quizzes: 2

Number of Published Lectures: 91

Number of Published Quizzes: 2

Number of Curriculum Items: 93

Number of Published Curriculum Objects: 93

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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 Should Attend

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

Target Audiences

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

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:

1. Data types and operators.

2. Primary keys.

3. Operators and functions.

4. Reference keywords.

5. one-one relationship.

6. one-to-many relationship

7. Many-to-many relationship.

8. Constraints

9. Indexes.

10. transactions.

11. Filter

12. Sort

13. Join

14. Like

15. ILIKE

16. Distinct

17. limit and offset

18. subqueries

19. not exists

20. exists

21. having

22. upsert

23. How to add a new column

24. CTE (Common table expression)

25. Window function

26. RANK() function

27. Procedure

28. Recursive Queries

29. User Management and permissions

30. users and roles

31. ACLs

32. list users and roles

33. Row-level security

34. transaction Isolation

35. MVCC

36. Savepoints

37. Deadlocks

38. Vacuumm

39. Explain statement

40. query tuning

41. Analyze keywords

42. Variables, constrol structure, if-then-else, case statement, for-loop, while-loop, error tyoes, exception handling.

43. functions, cursors, Raise, procedures, triggers

44. Dynamic SQL concepts, SQL injections

45. 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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course structure

Lecture 2: How to make the most out of this course

Lecture 3: How to install pgAdmin 4

Lecture 4: what is relational databases?

Lecture 5: How to create a database and delete a database

Lecture 6: Introduction to some of the basic SQL Commands

Chapter 2: Data Types and Operators

Lecture 1: What are data types and how to work with them

Lecture 2: What are primary keys

Lecture 3: what are Operators and Functions and how to implement both of them

Chapter 3: Database Design and Management

Lecture 1: what is Database Design Principles?

Lecture 2: Introduction to normalization and implementation

Lecture 3: Explanation of REFERENCES keywords

Lecture 4: Introduction to entity relationship modeling

Lecture 5: Introduction to one to one relationship

Lecture 6: Introduction to one to many relationship

Lecture 7: Introduction to Many to many relationship

Lecture 8: What are constraints in postgreSQL?

Lecture 9: Example of constraints in postgreSQL

Lecture 10: Introduction to indexes in postgreSQL

Lecture 11: Introduction to transactions in postgreSQL

Chapter 4: Manipulating and retrieving data

Lecture 1: How to filter in postgreSQL

Lecture 2: How to sort in postgreSQL

Lecture 3: Introduction to join in PostgreSQL

Lecture 4: Introduction to LIKE clause

Lecture 5: Introduction to ILIKE clause

Lecture 6: Introduction to distinct

Lecture 7: Introduction to limit and offset

Lecture 8: Deep dive into subqueries in PostgreSQL

Lecture 9: Introduction to NOT EXISTS clause

Lecture 10: Introduction to EXISTS clause

Lecture 11: Introduction to HAVING clause

Lecture 12: What is upsert in PostgreSQL

Chapter 5: Advanced SQL Features

Lecture 1: How to add a new column into existing table

Lecture 2: Introduction to Common Table Expressions (CTEs) with implementation

Lecture 3: Introduction to window function with implementation

Lecture 4: Introduction to RANK() function with implementation

Lecture 5: Introduction to procedure in postgreSQL

Lecture 6: Introduction to Recursive Queries with implementation

Chapter 6: Advanced Database Administration

Lecture 1: Introduction to User Management and Permissions

Lecture 2: How to create users and roles in postgreSQL?

Lecture 3: What is ACLs?

Lecture 4: How to list users and roles

Lecture 5: Introduction to RLs

Lecture 6: how to list all Row-level security

Chapter 7: Some other advanced concepts

Lecture 1: Introduction to Transaction Isolation

Lecture 2: What is MVCC?

Lecture 3: Introduction to Savepoints

Lecture 4: What is Deadlocks ?

Lecture 5: What is VACUUMM

Lecture 6: what is The EXPLAIN statement

Lecture 7: Examples of query tuning

Lecture 8: Introduction to ANALYZE keywords

Chapter 8: Introduction to PL/PG programming

Lecture 1: What is PL/PG programming

Lecture 2: The advantages of PL/PG programming and why do we do need to use it?

Lecture 3: what are use cases of PL/PG programming

Chapter 9: Introduction to variables

Lecture 1: what are variables and how to declare variables

Lecture 2: Example on how to declare variables

Lecture 3: what is block in pl/pgSQL?

Lecture 4: what is control structures in pl/pgSQL?

Lecture 5: what is if-then-else and example of how to implement if-then-else in pl/pgSQL

Lecture 6: What is the case statement?

Lecture 7: Introduction to for loop control structure

Lecture 8: Introduction to while loop

Lecture 9: What are Error Types in PL/pgSQL

Lecture 10: Introduction to exception handling

Chapter 10: Introduction to cursors, procedure, functions and triggers

Lecture 1: What are functions

Lecture 2: what is cursors in pl/pgSQL?

Lecture 3: What is the Raise statement?

Lecture 4: How to create functions

Lecture 5: What are parameters and return values

Lecture 6: What are procedures

Lecture 7: Procedures vs functions

Lecture 8: what are triggers

Lecture 9: what is Trigger Execution Time

Chapter 11: Introduction to Dynamic SQL

Lecture 1: what is Dynamic SQL Concepts?

Lecture 2: Executing Dynamic SQL Statements in pl/pgSQL

Lecture 3: what is SQL injection?

Lecture 4: Example of SQL injection

Chapter 12: Introduction to locks

Lecture 1: What is lock?

Lecture 2: What is Table-Level Locks

Lecture 3: Example of Table-Lock Locks

Lecture 4: what is AccessShareLock ?

Lecture 5: what is RowShareLock ?

Lecture 6: what is RowExclusiveLock?

Lecture 7: what is ShareUpdateExclusiveLock ?

Lecture 8: what is ShareLock?

Instructors

Hoang Quy La
Electrical Engineer

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 1 votes

4 stars: 3 votes

5 stars: 19 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!