Mastering Postgres - The most comprehensive course on PostgreSQL Database Feb 2025

CategoryOther
TypeTutorials
LanguageEnglish
Total size7.6 GB
Uploaded Bynotimmune

Downloads145
Last checkedFeb. 17th '25
Date uploadedFeb. 16th '25
Seeders 28
Leechers27

Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : B6AEA05A13F1CBBA5F2CC3850B03B473D0C9E18E

The most comprehensive course on PostgreSQL

Mastering Postgres is an in-depth video course by database educator Aaron Francis. Created in partnership with XATA

Your application is only as fast as your slowest query regardless of what language, framework, or hosting platform you choose. Mastering Postgres is a comprehensive video course that will help you level up your applications and your career.

You'll deeply understand the core principles of PostgreSQL through real-world examples. Get to know the many data types Postgres offers and when to use them, and more importantly, when not to use them. You'll understand how indexes work, how to improve your indexes and keep your database running as efficiently as possible.

30+ data types

Includes 117 videos

Over 16 hrs of content

                            Files: 
                            Mastering Postgres - The most comprehensive course on PostgreSQL Feb 2025

Bootstrapping an email service provider with Jesse Hanley.mp4 (1.1 GB)

Overview of course structure.mp4 (17.7 MB)

Postgres vs everyone.mp4 (14.8 MB)

The psql CLI.mp4 (9.6 MB)

Introduction to schema.mp4 (41.9 MB)

Integers.mp4 (27.7 MB)

Numeric.mp4 (33.8 MB)

Floating point.mp4 (26.3 MB)

Storing money.mp4 (22.7 MB)

NaNs and infinity.mp4 (9.2 MB)

Casting types.mp4 (13.6 MB)

Characters types.mp4 (28.7 MB)

Check constrai.mp4 (36.3 MB)

Domain types.mp4 (30.2 MB)

Chars and collations.mp4 (23.5 MB)

Binary data.mp4 (35.4 MB)

UUIDs.mp4 (21.8 MB)

Boolean.mp4 (11.4 MB)

Enums.mp4 (46.0 MB)

Timestamps.mp4 (43.7 MB)

Timezones.mp4 (48.7 MB)

Dates and times.mp4 (30.1 MB)

Intervals.mp4 (21.0 MB)

Serial type.mp4 (40.1 MB)

Sequences.mp4 (11.8 MB)

Identity.mp4 (82.1 MB)

Network and mac addresses.mp4 (15.9 MB)

JSON.mp4 (44.7 MB)

Arrays.mp4 (27.3 MB)

Generated columns.mp4 (34.0 MB)

Text search types.mp4 (23.0 MB)

Bit string.mp4 (22.3 MB)

Ranges.mp4 (52.5 MB)

Composite types.mp4 (15.8 MB)

Nulls.mp4 (21.3 MB)

Unique constrai.mp4 (17.2 MB)

Exclusion constrai.mp4 (21.8 MB)

Foreign key constrai.mp4 (49.1 MB)

Introduction to indexes.mp4 (39.3 MB)

Heaps and CTIDs.mp4 (21.9 MB)

B Tree overview.mp4 (22.8 MB)

Primary keys vs secondary indexes.mp4 (19.9 MB)

Primary key types.mp4 (53.4 MB)

Where to add indexes.mp4 (36.9 MB)

Index selectivity.mp4 (40.3 MB)

Composite indexes.mp4 (43.8 MB)

Composite range.mp4 (19.5 MB)

Combining multiple indexes.mp4 (19.9 MB)

Covering indexes.mp4 (47.1 MB)

Partial indexes.mp4 (29.8 MB)

Index ordering.mp4 (12.1 MB)

Ordering nulls in indexes.mp4 (9.0 MB)

Functional indexes.mp4 (21.2 MB)

Duplicate indexes.mp4 (10.2 MB)

Hash indexes.mp4 (22.8 MB)

Naming indexes.mp4 (6.9 MB)

Introduction to explain.mp4 (8.9 MB)

Explain structure.mp4 (18.4 MB)

Scan nodes.mp4 (50.8 MB)

Co and rows.mp4 (24.0 MB)

Explain analyze.mp4 (10.3 MB)

Introduction to queries.mp4 (10.1 MB)

Inner joins.mp4 (25.3 MB)

Outer joins.mp4 (24.4 MB)

Subqueries.mp4 (28.0 MB)

Lateral joins.mp4 (22.7 MB)

ROWS FROM.mp4 (12.1 MB)

Filling gaps in sequences.mp4 (19.8 MB)

Subquery elimination.mp4 (46.6 MB)

Combining queries.mp4 (25.9 MB)

Set generating functions.mp4 (20.5 MB)

Indexing joins.mp4 (16.3 MB)

Introduction to advanced SQL.mp4 (10.6 MB)

Cross joins.mp4 (18.6 MB)

Grouping.mp4 (35.9 MB)

Grouping s rollups cubes.mp4 (24.7 MB)

Window functions.mp4 (76.1 MB)

CTEs.mp4 (35.2 MB)

CTEs with window functions.mp4 (43.1 MB)

Recursive CTE.mp4 (21.4 MB)

Hierarchical recursive CTE.mp4 (22.0 MB)

Handling nulls.mp4 (21.1 MB)

Row value syntax.mp4 (40.2 MB)

Views.mp4 (28.3 MB)

Materialized views.mp4 (41.9 MB)

Removing duplicate rows.mp4 (15.3 MB)

Upsert.mp4 (30.3 MB)

Returning keyword.mp4 (10.5 MB)

COALESCE generated column.mp4 (16.6 MB)

Introduction to full text search.mp4 (17.3 MB)

Searching with LIKE.mp4 (8.3 MB)

Vectors queries and ranks.mp4 (27.3 MB)

Websearch.mp4 (27.5 MB)

Ranking.mp4 (51.0 MB)

Indexing full text search.mp4 (20.1 MB)

Highlighting.mp4 (17.0 MB)

Intro to JSON.mp4 (38.6 MB)

JSON vs JSONB.mp4 (52.5 MB)

Validating JSON.mp4 (25.2 MB)

Creating JSON objects arrays.mp4 (41.0 MB)

JSON extraction.mp4 (43.6 MB)

JSON containment.mp4 (16.5 MB)

JSON existence.mp4 (15.1 MB)

JSON recordset.mp4 (44.7 MB)

Updating JSON.mp4 (53.6 MB)

Indexing JSON parts.mp4 (56.8 MB)

GIN index.mp4 (50.7 MB)

Intro to pgvector.mp4 (26.9 MB)

Vector embedding columns.mp4 (42.4 MB)

Find related articles.mp4 (55.3 MB)

Upsert vector embedding.mp4 (15.7 MB)

Semantic search.mp4 (37.0 MB)

Other operators.mp4 (24.1 MB)

Vector indexes.mp4 (39.4 MB)

Thank you.mp4 (19.6 MB)

Heroku s glory days Postgres vs the world with Craig Kerstiens.mp4 (912.8 MB)

Creating a Postgres platform with Monica Tudor from Xata io.mp4 (1,003.6 MB)

Introduction to the course.mp4 (15.2 MB)
code
code (726.9 MB)
mp_demo_data
mp_demo_data (726.9 MB)

Code:

udp://tracker.opentrackr.org:1337/announce
http://bt.okmp3.ru:2710/announce
udp://u4.trakx.crim.ist:1337/announce
udp://wepzone.net:6969/announce
udp://ttk2.nbaonlineservice.com:6969/announce
https://tracker.yemekyedim.com:443/announce
https://tracker.gcrenwp.top:443/announce
https://tracker.bjut.jp:443/announce
https://api.ipv4online.uk:443/announce
https://tr.zukizuki.org:443/announce
https://tracker.moeking.me:443/announce
http://tracker.renfei.net:8080/announce
http://fleira.no:6969/announce
https://tr.nyacat.pw:443/announce
udp://tracker.gmi.gd:6969/announce