YOUR AD GOES HERE

SQL for Beginners: Your First Query with SELECT (SQL from Scratch Ep 1)

Published 17, Nov 2026

Rosleecia Productions


Description:
Welcome to SQL from Scratch, a beginner SQL series from Rosleecia Productions.

In this first episode you'll write your very first SQL query with SELECT, step by step in SQL Server Management Studio.
You'll learn what databases, tables, rows and columns are, how to choose the columns you want, the two mistakes every beginner makes, and how to remove duplicates with DISTINCT.

Practice database (ShopDB.sql) to follow along:
https://shop.rosleeciaproductions.com/b/KoqU4

SQL Cheat Sheet, all the basics on one page:
https://payhip.com/b/0rGmg

Want to practise more?
The SQL Club gives you a bigger practice database, challenges with answers and every cheat sheet:
https://rosleeciaproductions.com/sql-club.html

Support the channel:
PayPal: https://www.paypal.biz/rosleeciaproductions
Card: https://buy.stripe.com/6oU28t2Y3gpMgld6605gc00

Chapters
0:00 Welcome
0:52 What you need
1:13 A tour of SSMS and the shop database
2:19 Opening a new query
2:35 Your first SELECT query
3:42 Two common mistakes
4:32 Column order, layout and comments
5:31 Querying other tables
5:49 Every column and the drag trick
6:31 DISTINCT
7:02 Your turn: two challenges
7:58 Recap

Next episode: WHERE, filtering your rows.

#SQL #LearnSQL #SQLServer #SQLforBeginners #rosleeciaproductions

Releted More Videos

  • Sorry!!! Nothing to show

You May Also Like

YOUR AD GOES HERE

YOUR AD GOES HERE