Excel in BI Webinars - Why SQL still relevant nowadays? - Episode #35 скачать в хорошем качестве

Excel in BI Webinars - Why SQL still relevant nowadays? - Episode #35

Why SQL is still relevant in 2025 (and beyond) | Excel in BI Webinars SQL is not “old tech”. In this session I show why SQL remains a core skill for data analysts, BI developers, and anyone building dashboards in tools like Power BI. We look at practical use cases, performance wins with SQL Views, how to query sample databases with SSMS, and where SQL fits alongside Python and cloud platforms like Azure, AWS, and Google Cloud. You will leave with clear steps to practise SQL today and speed up your dashboards. What you’ll learn Why SQL still matters in 2025, 2026, and 2030 How SQL Views make dashboards faster and lighter Joins, WHERE, CASE, CTEs, and stored procedures Handling dates, text filters, and common query patterns Local practice with Microsoft SQL Server + SSMS (free) When to prep data in SQL vs your BI tool How SQL works across Azure, AWS, and Google Cloud Who this is for Data analysts, BI developers, Excel and Power BI users Students and career changers who want a durable, in-demand skill Try it yourself Download the Microsoft sample database and SSMS to practise queries Or use an online SQL playground to learn in your browser Chapters 00:00 Intro 01:19 Why SQL is still relevant 04:39 Declarative language and transformations 05:39 Views for fast dashboards 08:54 Direct data access and performance 10:59 Complex prep with SQL (CTEs, procedures) 11:59 Industry standard skill 18:47 Demo: SSMS, tables, schemas 21:41 SELECT, WHERE, LIKE, dates 32:52 JOIN example and creating a View 37:53 Renaming columns for BI tools 38:59 Keep learning and next steps Free webinars and resources Register for the next live session, micro-courses, and free guides: 👉 https://www.excelinbi.com/events Work with us Need help with your data pipeline or dashboards? Book a discovery call: 👉 https://www.excelinbi.com Contact 📧 contact@excelinbi.com #SQL #DataAnalytics #PowerBI #BusinessIntelligence #DataEngineering #CloudData #Azure #AWS #GoogleCloud #SSMS #SQLViews #CTE #DataVisualisation #LearnSQL #ExcelinBI