AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
Hacker News Recap
February 6th, 2024 | "Fake Chinese income" mortgages fuel Toronto real estate bubble: HSBC bank leaks
Feb 7, 2024
SQL for data scientists, Fake Chinese income mortgages in Toronto real estate bubble, AI vs. human lawyers, Outdated jQuery, Sea Temperature Records, DNS solutions vs Smart Toothbrush DDoS Attack
25:13
AI Summary
AI Chapters
Episode notes
Podcast summary created with Snipd AI
Quick takeaways
- The podcast provides an extensive tutorial on SQL for data scientists, covering query structure, database management, JSON data handling, joins, window functions, subqueries, and Python integration.
- The podcast uncovers mortgage fraud in Toronto's real estate market, with HSBC and possibly other banks issuing loans based on exaggerated or falsified Chinese incomes, contributing to inflated housing prices.
Deep dives
Tutorial on SQL for Data Scientists
This podcast episode features an expansive tutorial on SQL for data scientists. The tutorial covers a wide range of topics, including SQL query structure, database management with SQLite, handling JSON data, different types of joins, window functions, subqueries, and integrating database interactions with Python. The material provides both theoretical concepts and practical exercises, making it a valuable resource for educators. The comments section discusses the evolving definition and expectations of data scientists, including concerns about job dilution and varying skill sets.
Get the Snipd
podcast app
Unlock the knowledge in podcasts with the podcast player of the future.
AI-powered
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode
Save any
moment
Hear something you like? Tap your headphones to save it with AI-generated key takeaways
Share
& Export
Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more
AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode