▶️ BASIC SQL QUERIES | Video Tutorial
Learn how to create basic queries in SQL Server Management Studio from scratch.
00:00 Introduction
00:43 Restoring the test database (BikeStores)
04:37 SELECT statement syntax
06:18 Selecting attributes (SELECT)
10:24 Conditions (WHERE)
12:33 WHERE with relational operators
14:03 WHERE with BETWEEN
16:21 WHERE with LIKE
18:44 WHERE with IN
20:59 WHERE with AND/OR/NOT
23:05 AS clauses and aggregate functions
25:29 Grouping (GROUP BY)
27:46 HAVING clause
29:55 Ordering (ORDER BY)
31:20 Null values (NULL/NOT IS NULL)
32:55 Inserting records (INSERT INTO)
35:09 Updating records (UPDATE)
37:37 Deleting Records (DELETE FROM)
39:19 Closing
Download the database we used for the practical exercises in the video:
https://www.sqlservertutorial.net/sql...