{"guid":"d9b14733-50f1-423c-9d77-5985ffc5d5e2","title":"Komplexe Abfragen mit aktuellem SQL","subtitle":"SQL wird oft unterschätzt und kann mehr als einfache Joins und Unterabfragen","slug":"froscon2016-1725-komplexe_abfragen_mit_aktuellem_sql","link":null,"description":"Seit einigen Jahren bietet ISO-SQL wesentlich mehr bei den Abfragen mit \u003ctt\u003eSELECT\u003c/tt\u003e als früher. Leider haben sich diese großartigen Neuerungen noch nicht so recht herumgesprochen, was dieser Vortrag ändern möchte.","original_language":"deu","persons":["Holger Jakobs"],"tags":["Databases"],"view_count":281,"promoted":false,"date":"2016-08-20T14:00:00.000+02:00","release_date":"2016-08-20T02:00:00.000+02:00","updated_at":"2026-02-19T16:45:09.581+01:00","length":3622,"duration":3622,"thumb_url":"https://static.media.ccc.de/media/events/froscon/2016/1725-hd.jpg","poster_url":"https://static.media.ccc.de/media/events/froscon/2016/1725-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/froscon/2016/d9b14733-50f1-423c-9d77-5985ffc5d5e2-timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/froscon/2016/d9b14733-50f1-423c-9d77-5985ffc5d5e2-thumbnails.vtt","frontend_link":"https://media.ccc.de/v/froscon2016-1725-komplexe_abfragen_mit_aktuellem_sql","url":"https://api.media.ccc.de/public/events/d9b14733-50f1-423c-9d77-5985ffc5d5e2","conference_title":"FrOSCon 2016","conference_url":"https://api.media.ccc.de/public/conferences/froscon2016","related":[{"event_id":3380,"event_guid":"f67e27f3-eef4-4233-8e21-a8296b486056","weight":5},{"event_id":3382,"event_guid":"7b5e1f40-3260-48f3-b5b0-b5b192a88737","weight":5},{"event_id":3384,"event_guid":"290b5960-72f0-4a68-9fee-b1125c0dd635","weight":4},{"event_id":3385,"event_guid":"74460321-01f0-4a03-b0fd-ae67143edfab","weight":3},{"event_id":3388,"event_guid":"aff502a2-5d3a-4c9b-a4fa-3031be2801e8","weight":3},{"event_id":3392,"event_guid":"cb203c07-ae7e-4022-8916-280bbc16a416","weight":5},{"event_id":3395,"event_guid":"fb6854da-6ee9-4dd4-b8db-ef69ea33cc36","weight":4},{"event_id":3404,"event_guid":"927868f5-bec9-457b-85c1-e248d971dcc7","weight":4},{"event_id":3418,"event_guid":"e22d9cbc-8dfe-4b87-a0e0-56fb76a62511","weight":6},{"event_id":3424,"event_guid":"915aced0-8526-4087-b0c3-769710ef6322","weight":6},{"event_id":3426,"event_guid":"96d9e96d-3a35-41bc-8528-09351e8fb2f4","weight":3},{"event_id":3428,"event_guid":"7d2ccfda-ae1f-47a9-8d0a-c1c6c270614a","weight":4},{"event_id":3430,"event_guid":"58fb896b-6a05-4bdf-ab5d-85fe2501c61e","weight":3},{"event_id":3442,"event_guid":"b467ea0d-15c2-4e1b-a430-fc3ee9be445f","weight":4},{"event_id":5349,"event_guid":"16a1a1ce-98ce-5d69-9af1-49ca4f154640","weight":4}],"recordings":[{"size":465,"length":3622,"mime_type":"video/mp4","language":"deu","filename":"froscon16-1725-deu-Komplexe_Abfragen_mit_aktuellem_SQL_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2016-08-20T23:24:05.134+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2016/h264-hd/froscon16-1725-deu-Komplexe_Abfragen_mit_aktuellem_SQL_hd.mp4","url":"https://api.media.ccc.de/public/recordings/12315","event_url":"https://api.media.ccc.de/public/events/d9b14733-50f1-423c-9d77-5985ffc5d5e2","conference_url":"https://api.media.ccc.de/public/conferences/froscon2016"},{"size":44,"length":3615,"mime_type":"audio/opus","language":"deu","filename":"froscon16-1725-deu-Komplexe_Abfragen_mit_aktuellem_SQL.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2016-08-21T00:02:30.214+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2016/opus/froscon16-1725-deu-Komplexe_Abfragen_mit_aktuellem_SQL.opus","url":"https://api.media.ccc.de/public/recordings/12378","event_url":"https://api.media.ccc.de/public/events/d9b14733-50f1-423c-9d77-5985ffc5d5e2","conference_url":"https://api.media.ccc.de/public/conferences/froscon2016"},{"size":113,"length":3622,"mime_type":"video/mp4","language":"deu","filename":"froscon16-1725-deu-Komplexe_Abfragen_mit_aktuellem_SQL_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2016-08-21T01:30:10.200+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2016/h264-sd/froscon16-1725-deu-Komplexe_Abfragen_mit_aktuellem_SQL_sd.mp4","url":"https://api.media.ccc.de/public/recordings/12435","event_url":"https://api.media.ccc.de/public/events/d9b14733-50f1-423c-9d77-5985ffc5d5e2","conference_url":"https://api.media.ccc.de/public/conferences/froscon2016"},{"size":410,"length":3622,"mime_type":"video/webm","language":"deu","filename":"froscon16-1725-deu-Komplexe_Abfragen_mit_aktuellem_SQL_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2016-08-21T03:02:56.191+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2016/webm-hd/froscon16-1725-deu-Komplexe_Abfragen_mit_aktuellem_SQL_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/12442","event_url":"https://api.media.ccc.de/public/events/d9b14733-50f1-423c-9d77-5985ffc5d5e2","conference_url":"https://api.media.ccc.de/public/conferences/froscon2016"},{"size":125,"length":3622,"mime_type":"video/webm","language":"deu","filename":"froscon16-1725-deu-Komplexe_Abfragen_mit_aktuellem_SQL_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2016-08-21T01:16:02.837+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2016/webm-sd/froscon16-1725-deu-Komplexe_Abfragen_mit_aktuellem_SQL_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/12421","event_url":"https://api.media.ccc.de/public/events/d9b14733-50f1-423c-9d77-5985ffc5d5e2","conference_url":"https://api.media.ccc.de/public/conferences/froscon2016"},{"size":55,"length":3615,"mime_type":"audio/mpeg","language":"deu","filename":"froscon16-1725-deu-Komplexe_Abfragen_mit_aktuellem_SQL.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2016-08-21T00:09:34.397+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2016/mp3/froscon16-1725-deu-Komplexe_Abfragen_mit_aktuellem_SQL.mp3","url":"https://api.media.ccc.de/public/recordings/12394","event_url":"https://api.media.ccc.de/public/events/d9b14733-50f1-423c-9d77-5985ffc5d5e2","conference_url":"https://api.media.ccc.de/public/conferences/froscon2016"}]}