Introduction to SQL

New to SQL and not sure where to start? In this beginner-friendly introduction, Mitchell Pearson breaks down the basics of writing SQL queries so you can start retrieving, filtering, renaming, and combining data from database tables with confidence. You’ll learn how SQL is used to pull data from databases like SQL Server, Azure SQL Database, Microsoft Fabric Data Warehouse, and other systems that support SQL-style querying. Mitchell walks through using SQL Server Management Studio, selecting columns from a table, why SELECT * is not a best practice, how aliases work for tables and columns, how to combine first and last names into a single full name field, and how to filter rows with a WHERE clause. You’ll also get a quick introduction to joining tables so you can bring related data together, like matching people to their phone numbers using a key column instead of unreliable name matching. If you’re a Power BI user, data analyst, or Fabric learner trying to build a stronger SQL foundation, this is a great place to start. Download the latest version of SSMS here: aka.ms/ssms Our T-SQL Course can be found here: https://youtube.com/live/cACat4KNncg 👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/ 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/ 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/ 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ 00:00 Introduction to SQL with Mitchell Pearson 00:26 Why more data analysts and Power BI users are learning SQL 01:13 What SQL can do: create, update, delete, and retrieve data 02:22 Using SQL Server Management Studio 03:28 Select top ro