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