Udemy - Master SQL - Simple to advanced 200 + queries

Start Download


Files Included :

2 Install PostgreSQL 13.mp4 (34.62 MB)
MP4
3 Install pgAdmin 4 v5 5.mp4 (78.02 MB)
MP4
4 Run PostgreSQL on the cloud.mp4 (37.16 MB)
MP4
3 Import sample datasets.mp4 (97.37 MB)
MP4
5 Important - SQL Query is in CODE Articles.mp4 (12.78 MB)
MP4
6 List data, sectors in ascending and descending orders.mp4 (70.02 MB)
MP4
8 Using COUNT, WHERE, IN and NOT IN with sectors.mp4 (23.25 MB)
MP4
1 Understand the database model.mp4 (11.32 MB)
MP4
10 Staking tables together.mp4 (76.28 MB)
MP4
2 Create tables and populate data.mp4 (90.44 MB)
MP4
3 Get filtered data via WHERE clause.mp4 (120.55 MB)
MP4
4 Referencing an alias and concatenate columns.mp4 (57.74 MB)
MP4
5 Using conditional logic with CASE expression.mp4 (47.62 MB)
MP4
6 Using ORDER BY, LIMIT and RANDOM.mp4 (50.72 MB)
MP4
7 Find NULL values and transform into real values.mp4 (39.25 MB)
MP4
8 Searching for patterns.mp4 (53.82 MB)
MP4
9 Sorting on data dependent key.mp4 (66.94 MB)
MP4
1 Expressing a Parent-Child Relationship.mp4 (69.09 MB)
MP4
2 Expressing a Child-Parent-Grandparent Relationship.mp4 (52.65 MB)
MP4
3 Creating a hierarchical view of a table.mp4 (48.39 MB)
MP4
4 Finding all child rows for a given parent row.mp4 (19.86 MB)
MP4
5 Which rows are leaf, branch, or root nodes.mp4 (67.49 MB)
MP4
1 Computing an average, minmax values.mp4 (25.61 MB)
MP4
2 Sum, and count.mp4 (17.02 MB)
MP4
3 Generating a running total.mp4 (34.45 MB)
MP4
4 Calculating 3-point moving averages.mp4 (47.85 MB)
MP4
5 Calculate a mode.mp4 (55.14 MB)
MP4
6 Calculate a median, averages without highs and lows.mp4 (29.85 MB)
MP4
1 Add, subtract dates, and numbers of days.mp4 (53.27 MB)
MP4
2 Compute running date difference.mp4 (33.77 MB)
MP4
3 Comparing records using dates.mp4 (33.78 MB)
MP4
1 Find differences between rows within same group or partition.mp4 (34.86 MB)
MP4
2 Pagination.mp4 (21.61 MB)
MP4
3 Skipping n rows.mp4 (18.05 MB)
MP4
4 Selecting the Top n Records.mp4 (31.86 MB)
MP4
1 Turn aggregate function to window function.mp4 (49.8 MB)
MP4
2 PARTITION BY clause.mp4 (51.21 MB)
MP4
3 Handling NULLs.mp4 (28.9 MB)
MP4
4 The ORDER BY clause matters.mp4 (47.43 MB)
MP4
1 Listing tables, columns and indexes.mp4 (79.14 MB)
MP4
2 Listing constraints on a table.mp4 (46.85 MB)
MP4
3 Using SQL to Generate SQL.mp4 (32.06 MB)
MP4
1 Preparing the data.mp4 (33.89 MB)
MP4
2 Analyzing International debt - Part 1.mp4 (56.67 MB)
MP4
3 Analyzing International debt - Part 2.mp4 (89.64 MB)
MP4