SQL Query: Zero to Hero
ฝัง
- เผยแพร่เมื่อ 31 พ.ค. 2024
- In this tutorial video, we get you up to speed using SQL SELECT to query a relational database. You will learn everything from the extreme basics, up to some more advanced techniques to slice, dice and analyze data.
Intro image from pixabay.com/vectors/superhero...
Intro song by / @djsoundfx3101
Thumbnail background image by Pexels from Pixabay
00:00 Intro
01:13 The Basics
02:23 Getting Ready
03:45 Standards
04:23 The SELECT Statement
06:22 Columns
07:22 Filtering with WHERE
11:53 Counting records
12:36 NULL
12:57 Sorting
14:18 Aliases
15:04 Calculations
16:58 Functions
20:05 Joins
25:34 SELECT DISTINCT
27:11 Aggregation Functions
29:11 Pagination - วิทยาศาสตร์และเทคโนโลยี
Really good video! Thanks!
Thank you Leon!
keep the good work❤ can you do more of these about indexing, query optimization and T-SQL if possible?
I will definitely look into it!