У нас вы можете посмотреть бесплатно Learn 12 Advanced SQL Concepts in 20 Minutes (project files included!) или скачать в максимальном доступном качестве, видео которое было загружено на ютуб. Для загрузки выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием видео, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса ClipSaver.ru
Level up your SQL skills in just 20 minutes with SQL Pocket Guide author, Alice Zhao. In this video, we'll cover 12 advanced SQL concepts: ✔ UNION ✔ UNION ALL ✔ Subqueries ✔ LEFT JOIN ✔ INNER JOIN ✔ CTEs ✔ Recursive CTEs ✔ Date Expressions ✔ CAST ✔ COALESCE ✔ ROUND ✔ Window Functions …all in less than 20 minutes! 🔗 Helpful links: 👉 Downloadable project file: https://maven-datasets.s3.us-east-1.a... 👉 Advanced SQL Querying Course: Maven: https://bit.ly/4amQMqA Udemy: https://bit.ly/40A6ZVW 👉 MySQL Specialist Path: https://bit.ly/4gghp1L 👉 Follow us on LinkedIn: Alice: / alicexzhao Maven Analytics: / maven-analytics ⏱️Timestamps ⏱️ 0:00 Intro 01:05 UNION vs UNION ALL 03:01 Subqueries 04:14 LEFT JOIN vs INNER JOIN 06:44 CTEs 10:02 Recursive CTEs 11:16 Date Expressions 12:16 CAST 14:28 COALESCE 15:55 ROUND 16:33 Window Functions (ROW_NUMBER, LAG & LEAD) 19:35 Final Query 21:09 Outro At Maven Analytics, we empower everyday people with life-changing data & AI skills. Head to http://mavenanalytics.io and master in-demand tools like Excel, SQL, Power BI, Tableau, Python and more. Design your own personalized learning plan and get started for FREE! Looking for more opportunities to sharpen your skills? Explore sample datasets and practice solving real business problems with unique, expert-led guided projects: https://mavenanalytics.io/guided-proj...