Course

Sql

Topics in Sql.

98 Topics 6 Quizzes 9h 48min Est. Time
Login to Start Course »

Curriculum

1
Execution Plan Reading (EXPLAIN ANALYZE)
Execution Plan Reading (EXPLAIN ANALYZE)
Start »
2
Sequential vs Index Scan
Sequential vs Index Scan
Start »
3
Join Strategies (Nested Loop, Hash, Merge)
Join Strategies (Nested Loop, Hash, Merge)
Start »
4
Subquery Optimization (Correlation, Materialization)
Subquery Optimization (Correlation, Materialization)
Start »
5
Index-Only Scan & Covering Indexes
Index-Only Scan & Covering Indexes
Start »
6
Bitmap Scan & Bitmap Heap Scan
Bitmap Scan & Bitmap Heap Scan
Start »
7
Query Rewriting for Performance
Query Rewriting for Performance
Start »
8
B-Tree Index Internals
B-Tree Index Internals
Start »
9
Composite Index Column Order
Composite Index Column Order
Start »
10
Partial & Expression Indexes
Partial & Expression Indexes
Start »
11
Covering Indexes with INCLUDE Columns
Covering Indexes with INCLUDE Columns
Start »
12
GiST, GIN & BRIN Indexes
GiST, GIN & BRIN Indexes
Start »
13
Index Maintenance (Bloat, Reindex)
Index Maintenance (Bloat, Reindex)
Start »
14
Index-Only Scan Optimization
Index-Only Scan Optimization
Start »
15
OVER & PARTITION BY Basics
OVER & PARTITION BY Basics
Start »
16
ROW_NUMBER, RANK, DENSE_RANK
ROW_NUMBER, RANK, DENSE_RANK
Start »
17
LAG, LEAD & Offset Functions
LAG, LEAD & Offset Functions
Start »
18
FIRST_VALUE, LAST_VALUE & NTH_VALUE
FIRST_VALUE, LAST_VALUE & NTH_VALUE
Start »
19
Window Frame Specification (ROWS, RANGE, GROUPS)
Window Frame Specification (ROWS, RANGE, GROUPS)
Start »
20
NTILE & Percentile Functions
NTILE & Percentile Functions
Start »
21
Filtered Aggregates in Window Functions
Filtered Aggregates in Window Functions
Start »
22
WITH Clause Basics
WITH Clause Basics
Start »
23
Recursive CTE (UNION ALL)
Recursive CTE (UNION ALL)
Start »
24
Graph Traversal (Adjacency List)
Graph Traversal (Adjacency List)
Start »
25
Hierarchy Queries (Org Chart)
Hierarchy Queries (Org Chart)
Start »
26
CTE Materialization & Optimization
CTE Materialization & Optimization
Start »
27
Multiple CTEs in One Query
Multiple CTEs in One Query
Start »
28
Modifying CTEs (INSERT/UPDATE/DELETE WITH)
Modifying CTEs (INSERT/UPDATE/DELETE WITH)
Start »
29
Range Partitioning
Range Partitioning
Start »
30
List & Hash Partitioning
List & Hash Partitioning
Start »
31
Composite Partitioning
Composite Partitioning
Start »
32
Partition Pruning & Performance
Partition Pruning & Performance
Start »
33
Partition Maintenance (ATTACH/DETACH)
Partition Maintenance (ATTACH/DETACH)
Start »
34
Partitioned Indexes
Partitioned Indexes
Start »
35
Sub-partitioning
Sub-partitioning
Start »
36
ACID Properties
ACID Properties
Start »
37
Read Committed vs Repeatable Read
Read Committed vs Repeatable Read
Start »
38
Serializable Isolation
Serializable Isolation
Start »
39
Snapshot Isolation (MVCC)
Snapshot Isolation (MVCC)
Start »
40
Lost Updates & Skew
Lost Updates & Skew
Start »
41
Distributed Transactions (2PC)
Distributed Transactions (2PC)
Start »
42
Transaction Anomalies (Phantom, Non-Repeatable)
Transaction Anomalies (Phantom, Non-Repeatable)
Start »
43
Row-Level vs Table-Level Locks
Row-Level vs Table-Level Locks
Start »
44
Deadlock Detection & Prevention
Deadlock Detection & Prevention
Start »
45
Advisory Locks
Advisory Locks
Start »
46
SKIP LOCKED & NOWAIT
SKIP LOCKED & NOWAIT
Start »
47
Optimistic Locking Patterns
Optimistic Locking Patterns
Start »
48
Lock Escalation
Lock Escalation
Start »
49
Predicate Locks
Predicate Locks
Start »
50
Stored Function/Procedure Creation
Stored Function/Procedure Creation
Start »
51
Cursor Management (Explicit, Implicit, Ref)
Cursor Management (Explicit, Implicit, Ref)
Start »
52
Exception Handling (WHEN OTHERS)
Exception Handling (WHEN OTHERS)
Start »
53
Dynamic SQL (EXECUTE IMMEDIATE)
Dynamic SQL (EXECUTE IMMEDIATE)
Start »
54
Bulk Collect & FORALL
Bulk Collect & FORALL
Start »
55
Autonomous Transactions
Autonomous Transactions
Start »
56
Package Organization
Package Organization
Start »
57
JSON/JSONB Internals (PostgreSQL)
JSON/JSONB Internals (PostgreSQL)
Start »
58
JSON Path Queries (jsonpath)
JSON Path Queries (jsonpath)
Start »
59
Indexing JSONB (GIN)
Indexing JSONB (GIN)
Start »
60
Partial JSON Updates
Partial JSON Updates
Start »
61
JSON Aggregation Functions
JSON Aggregation Functions
Start »
62
JSON vs Relational Performance
JSON vs Relational Performance
Start »
63
Hybrid Document-Relational Design
Hybrid Document-Relational Design
Start »
64
tsvector & tsquery Types
tsvector & tsquery Types
Start »
65
GIN Indexes for Full-Text
GIN Indexes for Full-Text
Start »
66
Ranking (ts_rank, ts_rank_cd)
Ranking (ts_rank, ts_rank_cd)
Start »
67
Highlighting Results (ts_headline)
Highlighting Results (ts_headline)
Start »
68
Thesaurus & Synonym Dictionaries
Thesaurus & Synonym Dictionaries
Start »
69
Language Configurations
Language Configurations
Start »
70
Full-Text vs LIKE/ILIKE Performance
Full-Text vs LIKE/ILIKE Performance
Start »
71
Vacuum & Autovacuum Tuning
Vacuum & Autovacuum Tuning
Start »
72
Work Memory & Resource Allocation
Work Memory & Resource Allocation
Start »
73
Connection Pooling (PgBouncer)
Connection Pooling (PgBouncer)
Start »
74
Effective Cache Size Planning
Effective Cache Size Planning
Start »
75
I/O Bottleneck Analysis (pg_stat_user_tables)
I/O Bottleneck Analysis (pg_stat_user_tables)
Start »
76
Unused Index Detection
Unused Index Detection
Start »
77
Query Normalization & pg_stat_statements
Query Normalization & pg_stat_statements
Start »
78
SQL Injection Prevention
SQL Injection Prevention
Start »
79
Role-Based Access Control (GRANT/REVOKE)
Role-Based Access Control (GRANT/REVOKE)
Start »
80
Row-Level Security (RLS Policies)
Row-Level Security (RLS Policies)
Start »
81
Encryption at Rest (pgcrypto)
Encryption at Rest (pgcrypto)
Start »
82
TLS & Connection Security
TLS & Connection Security
Start »
83
Audit Logging (pgaudit)
Audit Logging (pgaudit)
Start »
84
Secure Connection Pools
Secure Connection Pools
Start »
85
Streaming Replication (Physical)
Streaming Replication (Physical)
Start »
86
Logical Replication (Publications/Subscriptions)
Logical Replication (Publications/Subscriptions)
Start »
87
Conflict Resolution
Conflict Resolution
Start »
88
Synchronous vs Asynchronous Replication
Synchronous vs Asynchronous Replication
Start »
89
Failover & Timeline Management
Failover & Timeline Management
Start »
90
Cascading Replication
Cascading Replication
Start »
91
Zero-Downtime Migration Strategies
Zero-Downtime Migration Strategies
Start »
92
Normalization (1NF, 2NF, 3NF, BCNF)
Normalization (1NF, 2NF, 3NF, BCNF)
Start »
93
Denormalization for Read Performance
Denormalization for Read Performance
Start »
94
Inheritance & Table Partitioning
Inheritance & Table Partitioning
Start »
95
Foreign Key Performance
Foreign Key Performance
Start »
96
Indexing Strategy Planning
Indexing Strategy Planning
Start »
97
Schema Migration (Flyway, Liquibase)
Schema Migration (Flyway, Liquibase)
Start »
98
Timestamp & Versioning Strategies
Timestamp & Versioning Strategies
Start »

Quizzes

SQL Basics
5 questions
SQL Core Concepts
5 questions
SQL Intermediate
5 questions
SQL Advanced
5 questions
SQL Expert
5 questions
SQL Mastery
5 questions