No cover art

Mastering Postgres - The most comprehensive course on PostgreSQL Feb 2025

Size
7.6 GB
Seeders
9
Leechers
4
Files
99
Category
Added
02/17/25 at 10:41am GMT+1
Status
Not verified
Infohash
b6aea05a13f1cbba5f2cc3850b03b473d0c9e18e

Description
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

File list
  • Mastering Postgres - The most comprehensive course on PostgreSQL Feb 2025
  • 0002. Overview of course structure.mp4 17.7 MB
  • 0003. Postgres vs everyone.mp4 14.8 MB
  • 0004. The psql CLI.mp4 9.6 MB
  • 0005. Introduction to schema.mp4 41.9 MB
  • 0006. Integers.mp4 27.7 MB
  • 0007. Numeric.mp4 33.8 MB
  • 0008. Floating point.mp4 26.3 MB
  • 0009. Storing money.mp4 22.7 MB
  • 0010. NaNs and infinity.mp4 9.2 MB
  • 0011. Casting types.mp4 13.6 MB
  • 0012. Characters types.mp4 28.7 MB
  • 0013. Check constrai.mp4 36.3 MB
  • 0014. Domain types.mp4 30.2 MB
  • 0015. Chars and collations.mp4 23.5 MB
  • 0016. Binary data.mp4 35.4 MB
  • 0017. UUIDs.mp4 21.8 MB
  • 0018. Boolean.mp4 11.4 MB
  • 0019. Enums.mp4 46 MB
  • 0020. Timestamps.mp4 43.7 MB
  • 0021. Timezones.mp4 48.7 MB
  • 0022. Dates and times.mp4 30.1 MB
  • 0023. Intervals.mp4 21 MB
  • 0024. Serial type.mp4 40.1 MB
  • 0025. Sequences.mp4 11.8 MB
  • 0026. Identity.mp4 82.1 MB
  • 0027. Network and mac addresses.mp4 15.9 MB
  • 0028. JSON.mp4 44.7 MB
  • 0029. Arrays.mp4 27.3 MB
  • 0030. Generated columns.mp4 34 MB
  • 0031. Text search types.mp4 23 MB
  • 0032. Bit string.mp4 22.3 MB
  • 0033. Ranges.mp4 52.5 MB
  • 0034. Composite types.mp4 15.8 MB
  • 0035. Nulls.mp4 21.3 MB
  • 0036. Unique constrai.mp4 17.2 MB
  • 0037. Exclusion constrai.mp4 21.8 MB
  • 0038. Foreign key constrai.mp4 49.1 MB
  • 0039. Introduction to indexes.mp4 39.3 MB
  • 0040. Heaps and CTIDs.mp4 21.9 MB
  • 0041. B Tree overview.mp4 22.8 MB
  • 0042. Primary keys vs secondary indexes.mp4 19.9 MB
  • 0043. Primary key types.mp4 53.4 MB
  • 0044. Where to add indexes.mp4 36.9 MB
  • 0045. Index selectivity.mp4 40.3 MB
  • 0046. Composite indexes.mp4 43.8 MB
  • 0047. Composite range.mp4 19.5 MB
  • 0048. Combining multiple indexes.mp4 19.9 MB
  • 0049. Covering indexes.mp4 47.1 MB
  • 0050. Partial indexes.mp4 29.8 MB
  • 0051. Index ordering.mp4 12.1 MB
  • 0052. Ordering nulls in indexes.mp4 9 MB
  • 0053. Functional indexes.mp4 21.2 MB
  • 0054. Duplicate indexes.mp4 10.2 MB
  • 0055. Hash indexes.mp4 22.8 MB
  • 0056. Naming indexes.mp4 6.9 MB
  • 0057. Introduction to explain.mp4 8.9 MB
  • 0058. Explain structure.mp4 18.4 MB
  • 0059. Scan nodes.mp4 50.8 MB
  • 0060. Co and rows.mp4 24 MB
  • 0061. Explain analyze.mp4 10.3 MB
  • 0062. Introduction to queries.mp4 10.1 MB
  • 0063. Inner joins.mp4 25.3 MB
  • 0064. Outer joins.mp4 24.4 MB
  • 0065. Subqueries.mp4 28 MB
  • 0066. Lateral joins.mp4 22.7 MB
  • 0067. ROWS FROM.mp4 12.1 MB
  • 0068. Filling gaps in sequences.mp4 19.8 MB
  • 0069. Subquery elimination.mp4 46.6 MB
  • 0070. Combining queries.mp4 25.9 MB
  • 0071. Set generating functions.mp4 20.5 MB
  • 0072. Indexing joins.mp4 16.3 MB
  • 0073. Introduction to advanced SQL.mp4 10.6 MB
  • 0074. Cross joins.mp4 18.6 MB
  • 0075. Grouping.mp4 35.9 MB
  • 0076. Grouping s rollups cubes.mp4 24.7 MB
  • 0077. Window functions.mp4 76.1 MB
  • 0078. CTEs.mp4 35.2 MB
  • 0079. CTEs with window functions.mp4 43.1 MB
  • 0080. Recursive CTE.mp4 21.4 MB
  • 0081. Hierarchical recursive CTE.mp4 22 MB
  • 0082. Handling nulls.mp4 21.1 MB
  • 0083. Row value syntax.mp4 40.2 MB
  • 0084. Views.mp4 28.3 MB
  • 0085. Materialized views.mp4 41.9 MB
  • 0086. Removing duplicate rows.mp4 15.3 MB
  • 0087. Upsert.mp4 30.3 MB
  • 0088. Returning keyword.mp4 10.5 MB
  • 0089. COALESCE generated column.mp4 16.6 MB
  • 0090. Introduction to full text search.mp4 17.3 MB
  • 0091. Searching with LIKE.mp4 8.3 MB
  • 0092. Vectors queries and ranks.mp4 27.3 MB
  • 0093. Websearch.mp4 27.5 MB
  • 0094. Ranking.mp4 51 MB
  • 0095. Indexing full text search.mp4 20.1 MB
  • 0096. Highlighting.mp4 17 MB
  • 0097. Intro to JSON.mp4 38.6 MB
  • 0098. JSON vs JSONB.mp4 52.5 MB
  • 0099. Validating JSON.mp4 25.2 MB
  • 0118. Bootstrapping an email service provider with Jesse Hanley.mp4 1.1 GB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
78 MB11/10/2559483961
29 MB08/24/2647633175
42 MB07/15/2644652975
29 MB01/07/2641922791
2.3 GB06/27/2621951710
2.8 GB07/22/26826312
1.1 GB07/19/26498484
4.3 GB07/19/26387193
19.5 GB07/22/26379676
1.3 GB06/27/26363170
628 MB07/15/2635514
6.4 GB07/25/26355128
2.7 GB07/22/2631831
290 MB07/08/2627413
2.4 GB07/22/2627238