Completed
Sub queries
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
The NoSQL Store Everyone Ignores - PostgreSQL
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Who is Stephan
- 3 Who are you
- 4 No sequel databases
- 5 Classification
- 6 Why Schemaless
- 7 Why you should never use MongoDB
- 8 PostgreSQL schemaless data types
- 9 Create an array column
- 10 Multidimensional arrays
- 11 Selecting data
- 12 Arrays
- 13 Unnecessary rows
- 14 Indexing
- 15 Updating arrays
- 16 Updating a single item
- 17 Partial update
- 18 Array functions
- 19 Hstore
- 20 Hstore on Linux
- 21 Insert date
- 22 Accessing elements
- 23 Searching for a key
- 24 Akey function
- 25 Index function
- 26 Update function
- 27 minus function
- 28 a keys function
- 29 why is Hstore interesting
- 30 JSON
- 31 Metadata
- 32 Inserting
- 33 Array
- 34 Query
- 35 Unique indexes
- 36 Updating JSON
- 37 JSON functions
- 38 Row to JSON
- 39 Sub queries
- 40 Data types
- 41 JSONB
- 42 Gene Index
- 43 JSON Keys
- 44 JSON vs JSON
- 45 XML over FTP
- 46 Wellformed XML
- 47 Expert exists
- 48 Query to XML
- 49 XML functions
- 50 Partitioning tables
- 51 Child tables
- 52 Create a table
- 53 Foreign data wrappers
- 54 PostgreSQL ecosystem
- 55 Try it out
- 56 Questions
