The Complete Beginner to Advanced PostgreSQL Course 2024
Database Design Principles, Normalization, Entity relationship modelling, Common table expressions (CTES), ACLs, RLs
4.50 (39 reviews)
110
students
9.5 hours
content
Apr 2024
last update
$69.99
regular price
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.
Screenshots
5895496
udemy ID
3/28/2024
course created date
4/14/2024
course indexed date
Bot
course submited by