Filename | Size |
| 1 - Introduction/1 - Introduction.mp4 | 28.2 MB |
| 10 - Named Ranges/44 - Named Ranges.mp4 | 65.3 MB |
| 10 - Named Ranges/45 - Indirect Functions.mp4 | 35.9 MB |
| 11 - Excel Shortcuts/46 - Shortcuts.mp4 | 103.8 MB |
| 12 - Macros/47 - Macros.mp4 | 71.5 MB |
| 13 - Advanced Excel/48 - Advanced Excel Analytics in Excel.mp4 | 123 MB |
| 14 - Creative Infographics/49 - Infographic Example 1.mp4 | 116.6 MB |
| 14 - Creative Infographics/50 - Infographic Example 2.mp4 | 37 MB |
| 15 - SQL/51 - Introduction.mp4 | 22.9 MB |
| 16 - Installation and getting started/52 - Installing PostgreSQL and pgAdmin in your PC.mp4 | 83.4 MB |
| 16 - Installation and getting started/53 - If pgAdmin is not opening.html | 1.6 KB |
| 17 - Case Study Demo/54 - Case Study Part 1 Business problems.mp4 | 37.8 MB |
| 17 - Case Study Demo/55 - Case Study Part 2 How SQL is Used.mp4 | 59 MB |
| 18 - Fundamental SQL statements/56 - CREATE.mp4 | 91.1 MB |
| 18 - Fundamental SQL statements/57 - INSERT.mp4 | 73 MB |
| 18 - Fundamental SQL statements/58 - Import data from File.mp4 | 42 MB |
| 18 - Fundamental SQL statements/59 - SELECT statement.mp4 | 31.8 MB |
| 18 - Fundamental SQL statements/60 - SELECT DISTINCT.mp4 | 46.2 MB |
| 18 - Fundamental SQL statements/61 - WHERE.mp4 | 32.6 MB |
| 18 - Fundamental SQL statements/62 - Logical Operators.mp4 | 50.5 MB |
| 18 - Fundamental SQL statements/63 - UPDATE.mp4 | 38.2 MB |
| 18 - Fundamental SQL statements/64 - DELETE.mp4 | 30 MB |
| 18 - Fundamental SQL statements/65 - ALTER part 1.mp4 | 46.3 MB |
| 18 - Fundamental SQL statements/66 - ALTER part 2.mp4 | 84.1 MB |
| 19 - Restore and Backup/67 - Restore and Backup.mp4 | 81.4 MB |
| 19 - Restore and Backup/68 - Debugging restoration issues.mp4 | 53.6 MB |
| 19 - Restore and Backup/69 - Creating DB using CSV files.mp4 | 38.4 MB |
| 19 - Restore and Backup/70 - Debugging summary and Code for CSV files.html | 2.2 KB |
| 2 - Excel Basics/2 - Getting started with Excel.mp4 | 52.1 MB |
| 2 - Excel Basics/3 - Course Resources.html | 396 B |
| 2 - Excel Basics/4 - This is a milestone.mp4 | 21.9 MB |
| 2 - Excel Basics/5 - Worksheet basics.mp4 | 93.6 MB |
| 2 - Excel Basics/6 - Entering values and Formulas.mp4 | 38.3 MB |
| 2 - Excel Basics/7 - Data Formats.mp4 | 48.7 MB |
| 2 - Excel Basics/8 - Data Handling Basics Cut Copy Paste.mp4 | 89.8 MB |
| 2 - Excel Basics/9 - Saving and Printing in Excel.mp4 | 52.2 MB |
| 20 - Selection commands Filtering/71 - IN.mp4 | 29.6 MB |
| 20 - Selection commands Filtering/72 - BETWEEN.mp4 | 52.3 MB |
| 20 - Selection commands Filtering/73 - LIKE.mp4 | 72.7 MB |
| 21 - Selection commands Ordering/74 - Side Lecture Commenting in SQL.mp4 | 13.1 MB |
| 21 - Selection commands Ordering/75 - ORDER BY.mp4 | 72.8 MB |
| 21 - Selection commands Ordering/76 - LIMIT.mp4 | 29.3 MB |
| 22 - Alias/77 - AS.mp4 | 27.3 MB |
| 23 - Aggregate Commands/78 - COUNT.mp4 | 43.9 MB |
| 23 - Aggregate Commands/79 - SUM.mp4 | 26.1 MB |
| 23 - Aggregate Commands/80 - AVERAGE.mp4 | 21.1 MB |
| 23 - Aggregate Commands/81 - MIN MAX.mp4 | 32.3 MB |
| 24 - Group By Commands/82 - GROUP BY.mp4 | 104.7 MB |
| 24 - Group By Commands/83 - HAVING.mp4 | 38.8 MB |
| 25 - Conditional Statement/84 - CASE WHEN.mp4 | 35.1 MB |
| 26 - JOINS/85 - Introductions to Joins.mp4 | 8.6 MB |
| 26 - JOINS/86 - Concepts of Joining and Combining Data.mp4 | 65 MB |
| 26 - JOINS/87 - Preparing the data.mp4 | 15.7 MB |
| 26 - JOINS/88 - Inner Join.mp4 | 51.1 MB |
| 26 - JOINS/89 - Left Join.mp4 | 40 MB |
| 26 - JOINS/90 - Right Join.mp4 | 39 MB |
| 26 - JOINS/91 - Full Outer Join.mp4 | 34.3 MB |
| 26 - JOINS/92 - Cross Join.mp4 | 20.2 MB |
| 26 - JOINS/93 - Intersect and Intersect ALL.mp4 | 26.5 MB |
| 26 - JOINS/94 - Except.mp4 | 14 MB |
| 26 - JOINS/95 - Union.mp4 | 38.8 MB |
| 27 - Subqueries/96 - Part1 Subquery in WHERE clause.mp4 | 25.7 MB |
| 27 - Subqueries/97 - Part2 Subquery in FROM clause.mp4 | 34.7 MB |
| 27 - Subqueries/98 - Part3 Subquery in SELECT clause.mp4 | 29.1 MB |
| 28 - Views and Indexes/100 - INDEX.mp4 | 36.7 MB |
| 28 - Views and Indexes/99 - VIEWS.mp4 | 37 MB |
| 29 - String Functions/101 - LENGTH.mp4 | 16.4 MB |
| 29 - String Functions/102 - UPPER LOWER.mp4 | 10 MB |
| 29 - String Functions/103 - REPLACE.mp4 | 24.2 MB |
| 29 - String Functions/104 - TRIM LTRIM RTRIM.mp4 | 45 MB |
| 29 - String Functions/105 - CONCATENATION.mp4 | 15.8 MB |
| 29 - String Functions/106 - SUBSTRING.mp4 | 39.7 MB |
| 29 - String Functions/107 - LIST AGGREGATION.mp4 | 30.8 MB |
| 3 - Essential Excel functions/10 - Basic Formula Operations.mp4 | 134.7 MB |
| 3 - Essential Excel functions/11 - Mathematical Functions Part 1.mp4 | 79 MB |
| 3 - Essential Excel functions/12 - Mathematical Functions Part 2.mp4 | 64.7 MB |
| 3 - Essential Excel functions/13 - Difference between RANK RANKAVG and RANKEQ.html | 766 B |
| 3 - Essential Excel functions/14 - Textual Functions Part 1.mp4 | 77.2 MB |
| 3 - Essential Excel functions/15 - Textual Functions Part 2.mp4 | 73.3 MB |
| 3 - Essential Excel functions/16 - Logical Functions.mp4 | 87.8 MB |
| 3 - Essential Excel functions/17 - DateTime Functions.mp4 | 46.8 MB |
| 3 - Essential Excel functions/18 - Lookup Functions V Lookup Hlookup IndexMatch.mp4 | 62.5 MB |
| 30 - Mathematical Functions/108 - CEIL FLOOR.mp4 | 16.5 MB |
| 30 - Mathematical Functions/109 - RANDOM.mp4 | 24.3 MB |
| 30 - Mathematical Functions/110 - SETSEED.mp4 | 18.2 MB |
| 30 - Mathematical Functions/111 - ROUND.mp4 | 13.7 MB |
| 30 - Mathematical Functions/112 - POWER.mp4 | 10.8 MB |
| 31 - DateTime Functions/113 - CURRENT DATE TIME.mp4 | 28.5 MB |
| 31 - DateTime Functions/114 - AGE.mp4 | 23.8 MB |
| 31 - DateTime Functions/115 - EXTRACT.mp4 | 51.2 MB |