Mastering Postgres – The most comprehensive course on PostgreSQL 2024-10

Published on: 2024-10-17 11:56:31

Categories: 28

Descriptions

The most comprehensive course on PostgreSQL, Mastering Postgres is a comprehensive video course that will help you level up your applications and your career. 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. Start with the fundamentals and work your way up to advanced topics like indexes and data types. Learn how to use the full text search capabilities of Postgres to build powerful search features. Indexes are the key to fast queries. Learn how to create and use them to speed up your queries. Postgres has a lot of data types. You’ll learn which ones to use and which ones to avoid.

What you’ll learn

Data Types
Advanced Data Types
Indexing
Understanding Query Plans
Generating Results
Advanced SQL
Full Text Search

Specificatoin of The most comprehensive course on PostgreSQL

Publisher : Mastering Postgres
Teacher : Aaron Francis
Language : English
Level : All Levels
Number of Course : 99
Duration : 14 hours and 22 minutes

Content of The most comprehensive course on PostgreSQL

01.-Introduction-to-the-course
02.-Overview-of-course-structure
03.-Postgres-vs.-everyone
04.-The-psql-CLI
05.-Introduction-to-schema
06.-Integers
07.-Numeric
08.-Floating-point
09.-Storing-money
10.-NaNs-and-infinity
11.-Casting-types
12.-Characters-types
13.-Check-constraints
14.-Domain-types
15.-Charsets-and-collations
16.-Binary-data
17.-UUIDs
18.-Boolean
19.-Enums
20.-Timestamps
21.-Timezones
22.-Dates-and-times
23.-Intervals
24.-Serial-type
25.-Sequences
26.-Identity
27.-Network-and-mac-addresses
28.-JSON
29.-Arrays
30.-Generated-columns
31.-Text-search-types
32.-Bit-string
33.-Ranges
34.-Composite-types
35.-Nulls
36.-Unique-constraints
37.-Exclusion-constraints
38.-Foreign-key-constraints
39.-Introduction-to-indexes
40.-Heaps-and-CTIDs
41.-B-Tree-overview
42.-Primary-keys-vs.-secondary-indexes
43.-Primary-key-types
44.-Where-to-add-indexes
45.-Index-selectivity
46.-Composite-indexes
47.-Composite-range
48.-Combining-multiple-indexes
49.-Covering-indexes
50.-Partial-indexes
51.-Index-ordering
52.-Ordering-nulls-in-indexes
53.-Functional-indexes
54.-Duplicate-indexes
55.-Hash-indexes
56.-Naming-indexes
57.-Introduction-to-explain
58.-Explain-structure
59.-Scan-nodes
60.-Costs-and-rows
61.-Explain-analyze
62.-Introduction-to-queries
63.-Inner-joins
64.-Outer-joins
65.-Subqueries
66.-Lateral-joins
67.-ROWS-FROM
68.-Filling-gaps-in-sequences
69.-Subquery-elimination
70.-Combining-queries
71.-Set-generating-functions
72.-Indexing-joins
73.-Introduction-to-advanced-SQL
74.-Cross-joins
75.-Grouping
76.-Grouping-sets_-rollups_-cubes
77.-Window-functions
78.-CTEs
79.-CTEs-with-window-functions
80.-Recursive-CTE
81.-Hierarchical-recursive-CTE
82.-Handling-nulls
83.-Row-value-syntax
84.-Views
85.-Materialized-views
86.-Removing-duplicate-rows
87.-Upsert
88.-Returning-keyword
89.-COALESCE-generated-column
90.-Introduction-to-full-text-search
91.-Searching-with-LIKE
92.-Vectors_-queries_-and-ranks
93.-Websearch
94.-Ranking
95.-Indexing-full-text-search
96.-Highlighting
97.-Heroku_s-glory-days-_-Postgres-vs-the-world-_with-Craig-Kerstiens_
98.-Creating-a-Postgres-platform-with-Monica-_-Tudor-from-Xata.io
99.-Bootstrapping-an-email-service-provider-_with-Jesse-Hanley_