0001_Introduction_to_the_course--[TutFlix.ORG]--.mp4

0002_Overview_of_course_structure--[TutFlix.ORG]--.mp4

0003_Postgres_vs_everyone--[TutFlix.ORG]--.mp4

0004_The_psql_CLI--[TutFlix.ORG]--.mp4

0005_Introduction_to_schema--[TutFlix.ORG]--.mp4

0006_Integers--[TutFlix.ORG]--.mp4

0007_Numeric--[TutFlix.ORG]--.mp4

0008_Floating_point--[TutFlix.ORG]--.mp4

0009_Storing_money--[TutFlix.ORG]--.mp4

0010_NaNs_and_infinity--[TutFlix.ORG]--.mp4

0011_Casting_types--[TutFlix.ORG]--.mp4

0012_Characters_types--[TutFlix.ORG]--.mp4

0013_Check_constrai--[TutFlix.ORG]--.mp4

0014_Domain_types--[TutFlix.ORG]--.mp4

0015_Chars_and_collations--[TutFlix.ORG]--.mp4

0016_Binary_data--[TutFlix.ORG]--.mp4

0017_UUIDs--[TutFlix.ORG]--.mp4

0018_Boolean--[TutFlix.ORG]--.mp4

0019_Enums--[TutFlix.ORG]--.mp4

0020_Timestamps--[TutFlix.ORG]--.mp4

0021_Timezones--[TutFlix.ORG]--.mp4

0022_Dates_and_times--[TutFlix.ORG]--.mp4

0023_Intervals--[TutFlix.ORG]--.mp4

0024_Serial_type--[TutFlix.ORG]--.mp4

0025_Sequences--[TutFlix.ORG]--.mp4

0026_Identity--[TutFlix.ORG]--.mp4

0027_Network_and_mac_addresses--[TutFlix.ORG]--.mp4

0028_JSON--[TutFlix.ORG]--.mp4

0029_Arrays--[TutFlix.ORG]--.mp4

0030_Generated_columns--[TutFlix.ORG]--.mp4

0031_Text_search_types--[TutFlix.ORG]--.mp4

0032_Bit_string--[TutFlix.ORG]--.mp4

0033_Ranges--[TutFlix.ORG]--.mp4

0034_Composite_types--[TutFlix.ORG]--.mp4

0035_Nulls--[TutFlix.ORG]--.mp4

0036_Unique_constrai--[TutFlix.ORG]--.mp4

0037_Exclusion_constrai--[TutFlix.ORG]--.mp4

0038_Foreign_key_constrai--[TutFlix.ORG]--.mp4

0039_Introduction_to_indexes--[TutFlix.ORG]--.mp4

0040_Heaps_and_CTIDs--[TutFlix.ORG]--.mp4

0041_B_Tree_overview--[TutFlix.ORG]--.mp4

0042_Primary_keys_vs_secondary_indexes--[TutFlix.ORG]--.mp4

0043_Primary_key_types--[TutFlix.ORG]--.mp4

0044_Where_to_add_indexes--[TutFlix.ORG]--.mp4

0045_Index_selectivity--[TutFlix.ORG]--.mp4

0046_Composite_indexes--[TutFlix.ORG]--.mp4

0047_Composite_range--[TutFlix.ORG]--.mp4

0048_Combining_multiple_indexes--[TutFlix.ORG]--.mp4

0049_Covering_indexes--[TutFlix.ORG]--.mp4

0050_Partial_indexes--[TutFlix.ORG]--.mp4

0051_Index_ordering--[TutFlix.ORG]--.mp4

0052_Ordering_nulls_in_indexes--[TutFlix.ORG]--.mp4

0053_Functional_indexes--[TutFlix.ORG]--.mp4

0054_Duplicate_indexes--[TutFlix.ORG]--.mp4

0055_Hash_indexes--[TutFlix.ORG]--.mp4

0056_Naming_indexes--[TutFlix.ORG]--.mp4

0057_Introduction_to_explain--[TutFlix.ORG]--.mp4

0058_Explain_structure--[TutFlix.ORG]--.mp4

0059_Scan_nodes--[TutFlix.ORG]--.mp4

0060_Co_and_rows--[TutFlix.ORG]--.mp4

0061_Explain_analyze--[TutFlix.ORG]--.mp4

0062_Introduction_to_queries--[TutFlix.ORG]--.mp4

0063_Inner_joins--[TutFlix.ORG]--.mp4

0064_Outer_joins--[TutFlix.ORG]--.mp4

0065_Subqueries--[TutFlix.ORG]--.mp4

0066_Lateral_joins--[TutFlix.ORG]--.mp4

0067_ROWS_FROM--[TutFlix.ORG]--.mp4

0068_Filling_gaps_in_sequences--[TutFlix.ORG]--.mp4

0069_Subquery_elimination--[TutFlix.ORG]--.mp4

0070_Combining_queries--[TutFlix.ORG]--.mp4

0071_Set_generating_functions--[TutFlix.ORG]--.mp4

0072_Indexing_joins--[TutFlix.ORG]--.mp4

0073_Introduction_to_advanced_SQL--[TutFlix.ORG]--.mp4

0074_Cross_joins--[TutFlix.ORG]--.mp4

0075_Grouping--[TutFlix.ORG]--.mp4

0076_Grouping_s_rollups_cubes--[TutFlix.ORG]--.mp4

0077_Window_functions--[TutFlix.ORG]--.mp4

0078_CTEs--[TutFlix.ORG]--.mp4

0079_CTEs_with_window_functions--[TutFlix.ORG]--.mp4

0080_Recursive_CTE--[TutFlix.ORG]--.mp4

0081_Hierarchical_recursive_CTE--[TutFlix.ORG]--.mp4

0082_Handling_nulls--[TutFlix.ORG]--.mp4

0083_Row_value_syntax--[TutFlix.ORG]--.mp4

0084_Views--[TutFlix.ORG]--.mp4

0085_Materialized_views--[TutFlix.ORG]--.mp4

0086_Removing_duplicate_rows--[TutFlix.ORG]--.mp4

0087_Upsert--[TutFlix.ORG]--.mp4

0088_Returning_keyword--[TutFlix.ORG]--.mp4

0089_COALESCE_generated_column--[TutFlix.ORG]--.mp4

0090_Introduction_to_full_text_search--[TutFlix.ORG]--.mp4

0091_Searching_with_LIKE--[TutFlix.ORG]--.mp4

0092_Vectors_queries_and_ranks--[TutFlix.ORG]--.mp4

0093_Websearch--[TutFlix.ORG]--.mp4

0094_Ranking--[TutFlix.ORG]--.mp4

0095_Indexing_full_text_search--[TutFlix.ORG]--.mp4

0096_Highlighting--[TutFlix.ORG]--.mp4

0097_Intro_to_JSON--[TutFlix.ORG]--.mp4

0098_JSON_vs_JSONB--[TutFlix.ORG]--.mp4

0099_Validating_JSON--[TutFlix.ORG]--.mp4

0100_Creating_JSON_objects_arrays--[TutFlix.ORG]--.mp4

0101_JSON_extraction--[TutFlix.ORG]--.mp4

0102_JSON_containment--[TutFlix.ORG]--.mp4

0103_JSON_existence--[TutFlix.ORG]--.mp4

0104_JSON_recordset--[TutFlix.ORG]--.mp4

0105_Updating_JSON--[TutFlix.ORG]--.mp4

0106_Indexing_JSON_parts--[TutFlix.ORG]--.mp4

0107_GIN_index--[TutFlix.ORG]--.mp4

0108_Intro_to_pgvector--[TutFlix.ORG]--.mp4

0109_Vector_embedding_columns--[TutFlix.ORG]--.mp4

0110_Find_related_articles--[TutFlix.ORG]--.mp4

0111_Upsert_vector_embedding--[TutFlix.ORG]--.mp4

0112_Semantic_search--[TutFlix.ORG]--.mp4

0113_Other_operators--[TutFlix.ORG]--.mp4

0114_Vector_indexes--[TutFlix.ORG]--.mp4

0115_Thank_you--[TutFlix.ORG]--.mp4

0116_Heroku_s_glory_days_Postgres_vs_the_world_with_Craig_Kerstiens--[TutFlix.ORG]--.mp4

0117_Creating_a_Postgres_platform_with_Monica_Tudor_from_Xata_io--[TutFlix.ORG]--.mp4

0118_Bootstrapping_an_email_service_provider_with_Jesse_Hanley--[TutFlix.ORG]--.mp4

CTEs with window functions