|
|
001 About me.en.srt
|
SRT
|
4 KB
|
|
|
001 About me.mp4
|
MP4
|
7.8 MB
|
|
|
001 Further learning.html
|
HTML
|
2.1 KB
|
|
|
001 Gary - How to merge large Excel files.en.srt
|
SRT
|
1.4 KB
|
|
|
001 Gary - How to merge large Excel files.mp4
|
MP4
|
12.7 MB
|
|
|
001 How to check two collections.en.srt
|
SRT
|
8.7 KB
|
|
|
001 How to check two collections.mp4
|
MP4
|
52.5 MB
|
|
|
001 LINQ - chapter overview.en.srt
|
SRT
|
921.6 B
|
|
|
001 LINQ - chapter overview.mp4
|
MP4
|
3.8 MB
|
|
|
002 Analysis_ What process type fits better for this_.en.srt
|
SRT
|
2.9 KB
|
|
|
002 Analysis_ What process type fits better for this_.mp4
|
MP4
|
10.9 MB
|
|
|
002 Announcement.en.srt
|
SRT
|
1.3 KB
|
|
|
002 Announcement.mp4
|
MP4
|
8.6 MB
|
|
|
002 Optimize queries.en.srt
|
SRT
|
5.1 KB
|
|
|
002 Optimize queries.mp4
|
MP4
|
34.5 MB
|
|
|
002 Resources.html
|
HTML
|
1.1 KB
|
|
|
002 What is LINQ.en.srt
|
SRT
|
5 KB
|
|
|
002 What is LINQ.mp4
|
MP4
|
13.2 MB
|
|
|
003 Conclusions.en.srt
|
SRT
|
1.1 KB
|
|
|
003 Conclusions.mp4
|
MP4
|
3.2 MB
|
|
|
003 Isolating exception handling.html
|
HTML
|
1.1 KB
|
|
|
003 LINQ overview functions.en.srt
|
SRT
|
6.8 KB
|
|
|
003 LINQ overview functions.mp4
|
MP4
|
33.4 MB
|
|
|
003 Merge multiple sources.en.srt
|
SRT
|
4.7 KB
|
|
|
003 Merge multiple sources.mp4
|
MP4
|
12.7 MB
|
|
|
003 Use-cases with LINQ.en.srt
|
SRT
|
2.9 KB
|
|
|
003 Use-cases with LINQ.mp4
|
MP4
|
21.8 MB
|
|
|
004 Filtering & transformation.en.srt
|
SRT
|
10.6 KB
|
|
|
004 Filtering & transformation.mp4
|
MP4
|
26.8 MB
|
|
|
004 Inline Joins & limitations.en.srt
|
SRT
|
10.9 KB
|
|
|
004 Inline Joins & limitations.mp4
|
MP4
|
62.1 MB
|
|
|
004 Resources.html
|
HTML
|
2.2 KB
|
|
|
004 Setting up prerequisites.en.srt
|
SRT
|
2.1 KB
|
|
|
004 Setting up prerequisites.mp4
|
MP4
|
13 MB
|
|
|
005 Development steps summary.en.srt
|
SRT
|
3.5 KB
|
|
|
005 Development steps summary.mp4
|
MP4
|
29 MB
|
|
|
005 Function syntax.en.srt
|
SRT
|
6.4 KB
|
|
|
005 Function syntax.mp4
|
MP4
|
20.7 MB
|
|
|
005 Improve the readability for joins.en.srt
|
SRT
|
11.4 KB
|
|
|
005 Improve the readability for joins.mp4
|
MP4
|
55.9 MB
|
|
|
006 Excel column retrival.en.srt
|
SRT
|
9.5 KB
|
|
|
006 Excel column retrival.mp4
|
MP4
|
32.3 MB
|
|
|
006 Joining from 2 sources.en.srt
|
SRT
|
9 KB
|
|
|
006 Joining from 2 sources.mp4
|
MP4
|
40.7 MB
|
|
|
006 Reading & filter the dynamic sheetname.en.srt
|
SRT
|
7.8 KB
|
|
|
006 Reading & filter the dynamic sheetname.mp4
|
MP4
|
38.2 MB
|
|
|
007 Dealing with multiple amount columns.en.srt
|
SRT
|
4 KB
|
|
|
007 Dealing with multiple amount columns.mp4
|
MP4
|
35.8 MB
|
|
|
007 Filtering and select.en.srt
|
SRT
|
6 KB
|
|
|
007 Filtering and select.mp4
|
MP4
|
25.6 MB
|
|
|
007 Joining from 3 sources.en.srt
|
SRT
|
7.1 KB
|
|
|
007 Joining from 3 sources.mp4
|
MP4
|
56.7 MB
|
|
|
008 Combining multiple sources.html
|
HTML
|
1.3 KB
|
|
|
008 Filter and projection.en.srt
|
SRT
|
1.7 KB
|
|
|
008 Filter and projection.mp4
|
MP4
|
8.6 MB
|
|
|
008 Filtering 100.000 rows.en.srt
|
SRT
|
2.9 KB
|
|
|
008 Filtering 100.000 rows.mp4
|
MP4
|
17.4 MB
|
|
|
009 Grouping by a column.en.srt
|
SRT
|
12.5 KB
|
|
|
009 Grouping by a column.mp4
|
MP4
|
70.1 MB
|
|
|
009 Use filter chaining.en.srt
|
SRT
|
4.6 KB
|
|
|
009 Use filter chaining.mp4
|
MP4
|
22.8 MB
|
|
|
010 Merging one file to the target Excel.en.srt
|
SRT
|
13.9 KB
|
|
|
010 Merging one file to the target Excel.mp4
|
MP4
|
108.8 MB
|
|
|
010 Return different result.en.srt
|
SRT
|
5.2 KB
|
|
|
010 Return different result.mp4
|
MP4
|
21.9 MB
|
|
|
011 Ensuring they are 5 rows per each group.en.srt
|
SRT
|
15.1 KB
|
|
|
011 Ensuring they are 5 rows per each group.mp4
|
MP4
|
122.9 MB
|
|
|
011 Find lines in an Excel_ classical vs LINQ.en.srt
|
SRT
|
5.9 KB
|
|
|
011 Find lines in an Excel_ classical vs LINQ.mp4
|
MP4
|
31.2 MB
|
|
|
012 Adding the third Excel file to our final target.en.srt
|
SRT
|
3.4 KB
|
|
|
012 Adding the third Excel file to our final target.mp4
|
MP4
|
32.3 MB
|
|
|
012 How to use use select.en.srt
|
SRT
|
6.7 KB
|
|
|
012 How to use use select.mp4
|
MP4
|
35 MB
|
|
|
013 Expose result of a LINQ.en.srt
|
SRT
|
5.9 KB
|
|
|
013 Expose result of a LINQ.mp4
|
MP4
|
35.3 MB
|
|
|
013 How to avoid empty rows.en.srt
|
SRT
|
4 KB
|
|
|
013 How to avoid empty rows.mp4
|
MP4
|
32.3 MB
|
|
|
014 Combine all 4 Excel files.en.srt
|
SRT
|
2.3 KB
|
|
|
014 Combine all 4 Excel files.mp4
|
MP4
|
19 MB
|
|
|
014 Create a dynamic LINQ query.en.srt
|
SRT
|
4 KB
|
|
|
014 Create a dynamic LINQ query.mp4
|
MP4
|
25 MB
|
|
|
015 Collection check mix.en.srt
|
SRT
|
5.9 KB
|
|
|
015 Collection check mix.mp4
|
MP4
|
33 MB
|
|
|
015 Verify the query result (optional).en.srt
|
SRT
|
1.6 KB
|
|
|
015 Verify the query result (optional).mp4
|
MP4
|
20 MB
|
|
|
016 Dry-run our robot with large files.en.srt
|
SRT
|
2.6 KB
|
|
|
016 Dry-run our robot with large files.mp4
|
MP4
|
27.4 MB
|
|
|
016 Lazy evaluation.en.srt
|
SRT
|
4.6 KB
|
|
|
016 Lazy evaluation.mp4
|
MP4
|
24 MB
|
|
|
017 Create array and lists.en.srt
|
SRT
|
7.9 KB
|
|
|
017 Create array and lists.mp4
|
MP4
|
40.7 MB
|
|
|
017 Limit variable scopes.en.srt
|
SRT
|
2 KB
|
|
|
017 Limit variable scopes.mp4
|
MP4
|
12 MB
|
|
|
018 Create dictionaries.en.srt
|
SRT
|
9.5 KB
|
|
|
018 Create dictionaries.mp4
|
MP4
|
59.8 MB
|
|
|
018 How to lookup for files dynamically.en.srt
|
SRT
|
3 KB
|
|
|
018 How to lookup for files dynamically.mp4
|
MP4
|
15.8 MB
|
|
|
019 Cleaning up the solution.en.srt
|
SRT
|
4.2 KB
|
|
|
019 Cleaning up the solution.mp4
|
MP4
|
31.6 MB
|
|
|
019 Group by a column from an Excel file.en.srt
|
SRT
|
10.4 KB
|
|
|
019 Group by a column from an Excel file.mp4
|
MP4
|
75.6 MB
|
|
|
020 Aggregate functions.en.srt
|
SRT
|
5.7 KB
|
|
|
020 Aggregate functions.mp4
|
MP4
|
27.2 MB
|
|
|
021 Aggregate functions simplified.en.srt
|
SRT
|
4.3 KB
|
|
|
021 Aggregate functions simplified.mp4
|
MP4
|
23.6 MB
|
|
|
022 Count function.en.srt
|
SRT
|
8.9 KB
|
|
|
022 Count function.mp4
|
MP4
|
39.2 MB
|
|
|
023 Aggregating all rows.en.srt
|
SRT
|
4.7 KB
|
|
|
023 Aggregating all rows.mp4
|
MP4
|
31.2 MB
|
|
|
024 Group by new syntax with C# and anonymous type.en.srt
|
SRT
|
10.6 KB
|
|
|
024 Group by new syntax with C# and anonymous type.mp4
|
MP4
|
54.1 MB
|
|
|
025 Group by new syntax with C# with object array.en.srt
|
SRT
|
9.1 KB
|
|
|
025 Group by new syntax with C# with object array.mp4
|
MP4
|
46.8 MB
|
|
|
026 How functions work.en.srt
|
SRT
|
12.8 KB
|
|
|
026 How functions work.mp4
|
MP4
|
44.6 MB
|
|
|
027 Select with inline functions.en.srt
|
SRT
|
3.5 KB
|
|
|
027 Select with inline functions.mp4
|
MP4
|
14.6 MB
|
|
|
028 Reuse function using variables.en.srt
|
SRT
|
6.7 KB
|
|
|
028 Reuse function using variables.mp4
|
MP4
|
38 MB
|
|
|
029 Reuse function in Invoke Code.en.srt
|
SRT
|
4.7 KB
|
|
|
029 Reuse function in Invoke Code.mp4
|
MP4
|
29.3 MB
|
|
|
030 Take a single element.en.srt
|
SRT
|
8.3 KB
|
|
|
030 Take a single element.mp4
|
MP4
|
38 MB
|
|
|
031 Count and Count().en.srt
|
SRT
|
6.1 KB
|
|
|
031 Count and Count().mp4
|
MP4
|
24.3 MB
|
|
|
032 Distinct elements.en.srt
|
SRT
|
4.6 KB
|
|
|
032 Distinct elements.mp4
|
MP4
|
30.3 MB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|