{"guid":"e4eea379-c263-4178-9574-c836c4ee4259","title":"Fancy SQL","subtitle":null,"slug":"froscon2022-2738-fancy_sql","link":"https://programm.froscon.org/2022/events/2738.html","description":"Have you ever heard from CTEs or Window functions? What is it and when and how to use it? Can you remember correlated subselects? The talk shows some fancy SQL commands that you can use with PostgreSQL, MariaDB and MySQL.\n\nSQL just has 14 commands ... but these can get very complex. Also since a few years there are some very useful new functionalities like CTEs and Window functions. Additionally the talk shortly will show correlated subselects and more.","original_language":"eng","persons":["miracee"],"tags":["froscon2022","2738","2022","Database"],"view_count":352,"promoted":false,"date":"2022-08-21T17:45:00.000+02:00","release_date":"2022-08-22T00:00:00.000+02:00","updated_at":"2026-02-19T16:30:08.181+01:00","length":2729,"duration":2729,"thumb_url":"https://static.media.ccc.de/media/events/froscon/2022/2738-e4eea379-c263-4178-9574-c836c4ee4259.jpg","poster_url":"https://static.media.ccc.de/media/events/froscon/2022/2738-e4eea379-c263-4178-9574-c836c4ee4259_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/froscon/2022/2738-e4eea379-c263-4178-9574-c836c4ee4259.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/froscon/2022/2738-e4eea379-c263-4178-9574-c836c4ee4259.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/froscon2022-2738-fancy_sql","url":"https://api.media.ccc.de/public/events/e4eea379-c263-4178-9574-c836c4ee4259","conference_title":"FrOSCon 2022","conference_url":"https://api.media.ccc.de/public/conferences/froscon2022","related":[],"recordings":[{"size":374,"length":2729,"mime_type":"video/webm","language":"eng","filename":"froscon2022-2738-eng-Fancy_SQL_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2022-08-22T11:52:54.022+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2022/webm-hd/froscon2022-2738-eng-Fancy_SQL_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/61301","event_url":"https://api.media.ccc.de/public/events/e4eea379-c263-4178-9574-c836c4ee4259","conference_url":"https://api.media.ccc.de/public/conferences/froscon2022"},{"size":134,"length":2729,"mime_type":"video/webm","language":"eng","filename":"froscon2022-2738-eng-Fancy_SQL_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2022-08-22T11:23:07.488+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2022/webm-sd/froscon2022-2738-eng-Fancy_SQL_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/61300","event_url":"https://api.media.ccc.de/public/events/e4eea379-c263-4178-9574-c836c4ee4259","conference_url":"https://api.media.ccc.de/public/conferences/froscon2022"},{"size":83,"length":2729,"mime_type":"video/mp4","language":"eng","filename":"froscon2022-2738-eng-Fancy_SQL_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2022-08-22T11:02:06.112+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2022/h264-sd/froscon2022-2738-eng-Fancy_SQL_sd.mp4","url":"https://api.media.ccc.de/public/recordings/61299","event_url":"https://api.media.ccc.de/public/events/e4eea379-c263-4178-9574-c836c4ee4259","conference_url":"https://api.media.ccc.de/public/conferences/froscon2022"},{"size":41,"length":2729,"mime_type":"audio/mpeg","language":"eng","filename":"froscon2022-2738-eng-Fancy_SQL_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2022-08-22T10:54:41.130+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2022/mp3/froscon2022-2738-eng-Fancy_SQL_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/61298","event_url":"https://api.media.ccc.de/public/events/e4eea379-c263-4178-9574-c836c4ee4259","conference_url":"https://api.media.ccc.de/public/conferences/froscon2022"},{"size":25,"length":2729,"mime_type":"audio/opus","language":"eng","filename":"froscon2022-2738-eng-Fancy_SQL_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2022-08-22T10:54:03.971+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2022/opus/froscon2022-2738-eng-Fancy_SQL_opus.opus","url":"https://api.media.ccc.de/public/recordings/61297","event_url":"https://api.media.ccc.de/public/events/e4eea379-c263-4178-9574-c836c4ee4259","conference_url":"https://api.media.ccc.de/public/conferences/froscon2022"},{"size":247,"length":2729,"mime_type":"video/mp4","language":"eng","filename":"froscon2022-2738-eng-Fancy_SQL_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2022-08-22T10:50:24.879+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2022/h264-hd/froscon2022-2738-eng-Fancy_SQL_hd.mp4","url":"https://api.media.ccc.de/public/recordings/61296","event_url":"https://api.media.ccc.de/public/events/e4eea379-c263-4178-9574-c836c4ee4259","conference_url":"https://api.media.ccc.de/public/conferences/froscon2022"}]}