17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Mastering Postgres - The Most Comprehensive Course On PostgreSQL Feb 2025
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
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
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
