From Excel to SQL Master SQL Like a Pro

Files Included :

1 - Introduction.mp4 (11.89 MB)
MP4
2 - Logging to snowflake.mp4 (21.2 MB)
MP4
3 - Preparation.mp4 (13.9 MB)
MP4
65 - Concat.mp4 (22.12 MB)
MP4
66 - Len.mp4 (14.03 MB)
MP4
67 - Substr.mp4 (20.4 MB)
MP4
68 - Position.mp4 (19.4 MB)
MP4
69 - Upper case Lower case proper case.mp4 (16.01 MB)
MP4
70 - Trim.mp4 (15.84 MB)
MP4
71 - Replace.mp4 (4.19 MB)
MP4
72 - Reverse.mp4 (2.27 MB)
MP4
73 - Contains.mp4 (15.05 MB)
MP4
74 - ARRAYAGG.mp4 (13.93 MB)
MP4
75 - Translate.mp4 (14.37 MB)
MP4
76 - SUM Count Min Max AVG ABS.mp4 (10.37 MB)
MP4
77 - Arithmetic Operations.mp4 (9.48 MB)
MP4
78 - Convert String to Number.mp4 (9.48 MB)
MP4
79 - Get Number of DayMonthYear between 2 dates DATEDIFF TIMEDIFF.mp4 (16.89 MB)
MP4
80 - REGEXP.mp4 (29.74 MB)
MP4
81 - REGEXPLIKE.mp4 (10 MB)
MP4
82 - REGEXPSUBSTR REGEXPSUBSTRALL.mp4 (12.93 MB)
MP4
83 - REGEXPCount.mp4 (9.11 MB)
MP4
84 - REGEXPREPLACE.mp4 (6.86 MB)
MP4
85 - REGEXPINSTR.mp4 (11.98 MB)
MP4
86 - SQL Standards Tips.mp4 (21.32 MB)
MP4
87 - Performance Tunning.mp4 (24.46 MB)
MP4
88 - Practice Session 1.mp4 (19.15 MB)
MP4
89 - Practice Session 2.mp4 (25.2 MB)
MP4
90 - Practice Session 3.mp4 (12.63 MB)
MP4
91 - Practice Session 4.mp4 (48.08 MB)
MP4
92 - Practice Session 5.mp4 (48.51 MB)
MP4
93 - Practice Session 6.mp4 (7.17 MB)
MP4
94 - Practice Session 7.mp4 (68.22 MB)
MP4
95 - Practice Session 8.mp4 (34.83 MB)
MP4
96 - Practice Session 9.mp4 (15.96 MB)
MP4
10 - Filters on Aggregated Data Having Clause.mp4 (9.3 MB)
MP4
11 - Column Alias Use cases AS.mp4 (6.52 MB)
MP4
12 - Conditional Logic CASE IFF.mp4 (30.27 MB)
MP4
13 - Limiting records TOP Limit Sample.mp4 (11.28 MB)
MP4
14 - Intro to NULL finding NULL values replace NULL with Coalease NULLIFZERO.mp4 (27.09 MB)
MP4
15 - Sorting the output ORDER BY.mp4 (23.05 MB)
MP4
16 - Subquery.mp4 (12.12 MB)
MP4
4 - Select ALL.mp4 (31.72 MB)
MP4
5 - Select specific columns.mp4 (20.89 MB)
MP4
6 - Select specific Rows Where Clause.mp4 (24.94 MB)
MP4
7 - Multiple Filters AND OR IN Between Not In Not Between.mp4 (109.45 MB)
MP4
8 - Aggregation SUM MIN MAX COUNT AVG.mp4 (53.2 MB)
MP4
9 - Select unique values DISTINCT Group By.mp4 (11.15 MB)
MP4
17 - Join Concept.mp4 (20.38 MB)
MP4
18 - Inner JOIN.mp4 (22.47 MB)
MP4
19 - Left JOIN.mp4 (12.45 MB)
MP4
20 - Right JOIN.mp4 (12.96 MB)
MP4
21 - Full Outer JOIN.mp4 (5.78 MB)
MP4
22 - CROSS JOIN.mp4 (9.01 MB)
MP4
23 - Set Operator Concept.mp4 (7.05 MB)
MP4
24 - UNION ALL.mp4 (15.64 MB)
MP4
25 - UNION.mp4 (5.9 MB)
MP4
26 - MINUS Except.mp4 (13.91 MB)
MP4
27 - INTERSECT.mp4 (4.05 MB)
MP4
28 - Insert Into the table 1 row multiple rows at a time Manual.mp4 (13.89 MB)
MP4
29 - Insert Into the table From other tables.mp4 (14.99 MB)
MP4
30 - Handling NOT NULL columns Default Values.mp4 (15.8 MB)
MP4
31 - Update a specific value.mp4 (11.01 MB)
MP4
32 - Update using other tables.mp4 (10.33 MB)
MP4
33 - Delete Specific row in table.mp4 (8.78 MB)
MP4
34 - Delete based upon reference table.mp4 (10.88 MB)
MP4
35 - Truncate.mp4 (6.04 MB)
MP4
36 - Merge.mp4 (30.09 MB)
MP4
37 - Data Types.mp4 (36.83 MB)
MP4
38 - Create Table Primary Key Not Null.mp4 (15.53 MB)
MP4
39 - Create Table with Like and Clone.mp4 (27.39 MB)
MP4
40 - Alter Table Add a column.mp4 (21.54 MB)
MP4
41 - Alter Table Drop a column.mp4 (9.56 MB)
MP4
42 - Alter Table Rename a column.mp4 (9.56 MB)
MP4
43 - Drop Table.mp4 (3.23 MB)
MP4
44 - Create View.mp4 (9.15 MB)
MP4
45 - Create Materialized View.mp4 (9.31 MB)
MP4
46 - Number to String tochartovarchar.mp4 (14.08 MB)
MP4
47 - String to Number ToNumber.mp4 (22.55 MB)
MP4
48 - String to Date ToDate.mp4 (12.79 MB)
MP4
49 - Pivot.mp4 (33.93 MB)
MP4
50 - Unpivot.mp4 (26.51 MB)
MP4
51 - Aggregate with LISTAGG.mp4 (11.65 MB)
MP4
52 - Table Functions.mp4 (15.28 MB)
MP4
53 - Hierarchy.mp4 (20.02 MB)
MP4
54 - Hierarchy using Connect By.mp4 (10.71 MB)
MP4
55 - Recursive SQL.mp4 (21.85 MB)
MP4
56 - Common Table Expression CTE.mp4 (18.07 MB)
MP4
57 - Windows Functions Rank.mp4 (17.3 MB)
MP4
58 - RowNumber.mp4 (14.51 MB)
MP4
59 - NTILE.mp4 (11.14 MB)
MP4
60 - DenseRank.mp4 (10.35 MB)
MP4
61 - LAG LEAD.mp4 (18.1 MB)
MP4
62 - FirstValue LastValue NTHValue.mp4 (14.83 MB)
MP4
63 - Cumulative Sum.mp4 (40.11 MB)
MP4
64 - Handling Duplicates.mp4 (15.83 MB)
MP4