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
Share this link via
Or copy link























