💻 Data & SQL Tutorial: Master DQL queries for ETL
After watching this session, you will be able to:
0:00 Query a Table.
2:38 Reading Data
3:25 Formatting Queries
4:50 Work with data types
5:09 Data Type Conversion
8:10 Handle NULLs
10:40 Filter data with predicates
12:50 Activity: WHERE Clause
15:35 More advanced filters
19:30 Activity: More Filters
33: 15 Limit results.
33:23 Interview Question:
33:38 Answer
33:48 TOP, WITH TIES, PERCENT
34:43 DISTINCT keyword
35:00 Activity: Remove Duplicates
38:10 Sort results.
39:06 Activity: Sort Results
40:45 Return paged results.
41:00 Activity: OFFSET - FETCH
43:53 Challenges
44:44 Question: Ascending Order
46:47 Question: Is SQL Case sensitive?
