|
|
1 - Introduction.mp4
|
MP4
|
28.2 MB
|
|
|
10 - Basic Formula Operations.mp4
|
MP4
|
134.7 MB
|
|
|
100 - INDEX.mp4
|
MP4
|
36.7 MB
|
|
|
101 - LENGTH.mp4
|
MP4
|
16.4 MB
|
|
|
102 - UPPER LOWER.mp4
|
MP4
|
10 MB
|
|
|
103 - REPLACE.mp4
|
MP4
|
24.2 MB
|
|
|
104 - TRIM LTRIM RTRIM.mp4
|
MP4
|
45 MB
|
|
|
105 - CONCATENATION.mp4
|
MP4
|
15.8 MB
|
|
|
106 - SUBSTRING.mp4
|
MP4
|
39.7 MB
|
|
|
107 - LIST AGGREGATION.mp4
|
MP4
|
30.8 MB
|
|
|
108 - CEIL FLOOR.mp4
|
MP4
|
16.5 MB
|
|
|
109 - RANDOM.mp4
|
MP4
|
24.3 MB
|
|
|
11 - Mathematical Functions Part 1.mp4
|
MP4
|
79 MB
|
|
|
110 - SETSEED.mp4
|
MP4
|
18.2 MB
|
|
|
111 - ROUND.mp4
|
MP4
|
13.7 MB
|
|
|
112 - POWER.mp4
|
MP4
|
10.8 MB
|
|
|
113 - CURRENT DATE TIME.mp4
|
MP4
|
28.5 MB
|
|
|
114 - AGE.mp4
|
MP4
|
23.8 MB
|
|
|
115 - EXTRACT.mp4
|
MP4
|
51.2 MB
|
|
|
116 - PATTERN MATCHING BASICS.mp4
|
MP4
|
36 MB
|
|
|
117 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS Part 1.mp4
|
MP4
|
50.1 MB
|
|
|
118 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS Part 2.mp4
|
MP4
|
31.5 MB
|
|
|
119 - Introduction to Window functions.mp4
|
MP4
|
60.7 MB
|
|
|
12 - Mathematical Functions Part 2.mp4
|
MP4
|
64.7 MB
|
|
|
120 - Introduction to Row number.mp4
|
MP4
|
39.5 MB
|
|
|
121 - Implementing Row number in SQL.mp4
|
MP4
|
186.9 MB
|
|
|
122 - RANK and DENSERANK.mp4
|
MP4
|
57.9 MB
|
|
|
123 - NTILE function.mp4
|
MP4
|
70 MB
|
|
|
124 - AVERAGE function.mp4
|
MP4
|
63.5 MB
|
|
|
125 - COUNT.mp4
|
MP4
|
34 MB
|
|
|
126 - SUM TOTAL.mp4
|
MP4
|
93.4 MB
|
|
|
127 - RUNNING TOTAL.mp4
|
MP4
|
68.1 MB
|
|
|
128 - LAG and LEAD.mp4
|
MP4
|
75.2 MB
|
|
|
129 - COALESCE function.mp4
|
MP4
|
45.2 MB
|
|
|
13 - Difference between RANK RANKAVG and RANKEQ.html
|
HTML
|
716.8 B
|
|
|
130 - Converting Numbers Date to String.mp4
|
MP4
|
61.6 MB
|
|
|
131 - Converting String to Numbers Date.mp4
|
MP4
|
28.9 MB
|
|
|
132 - User Access Control 1 Grant and Revoke.mp4
|
MP4
|
42.7 MB
|
|
|
133 - User Access Control 2 Drop Alter users.mp4
|
MP4
|
32.7 MB
|
|
|
134 - Tablespace.mp4
|
MP4
|
31.1 MB
|
|
|
135 - PRIMARY KEY FOREIGN KEY.mp4
|
MP4
|
21.2 MB
|
|
|
136 - ACID compliance.mp4
|
MP4
|
38 MB
|
|
|
137 - Truncate.mp4
|
MP4
|
17.6 MB
|
|
|
138 - TIP 1 EXPLAIN.mp4
|
MP4
|
28.3 MB
|
|
|
139 - TIP 2.mp4
|
MP4
|
6.3 MB
|
|
|
14 - Textual Functions Part 1.mp4
|
MP4
|
77.2 MB
|
|
|
140 - TIP 3.mp4
|
MP4
|
15.1 MB
|
|
|
141 - TIP 4 VACCUM.mp4
|
MP4
|
3.2 MB
|
|
|
142 - TIP 5.mp4
|
MP4
|
12.7 MB
|
|
|
143 - TIP 6 STRING FUNCTIONS.mp4
|
MP4
|
16.5 MB
|
|
|
144 - TIP 7 JOINS.mp4
|
MP4
|
12.4 MB
|
|
|
145 - TIP 8 SCHEMAS.mp4
|
MP4
|
36.9 MB
|
|
|
146 - What is SQL.mp4
|
MP4
|
9.6 MB
|
|
|
147 - Tables and DBMS.mp4
|
MP4
|
16.2 MB
|
|
|
148 - Types of SQL commands.mp4
|
MP4
|
23.9 MB
|
|
|
149 - PostgreSQL.mp4
|
MP4
|
15.6 MB
|
|
|
15 - Textual Functions Part 2.mp4
|
MP4
|
73.3 MB
|
|
|
150 - Introduction.mp4
|
MP4
|
21.9 MB
|
|
|
151 - Why Tableau.mp4
|
MP4
|
19.7 MB
|
|
|
152 - Tableau Products.mp4
|
MP4
|
52.6 MB
|
|
|
153 - Installing Tableau desktop and Public.mp4
|
MP4
|
36.2 MB
|
|
|
154 - About the data.mp4
|
MP4
|
133.9 MB
|
|
|
155 - Connecting to data.mp4
|
MP4
|
76.4 MB
|
|
|
156 - Live vs Extract.mp4
|
MP4
|
21.7 MB
|
|
|
157 - Combining data from multiple tables.mp4
|
MP4
|
29 MB
|
|
|
158 - Relationships in Tableau.mp4
|
MP4
|
68.5 MB
|
|
|
159 - Joins in Tableau.mp4
|
MP4
|
37.5 MB
|
|
|
16 - Logical Functions.mp4
|
MP4
|
87.8 MB
|
|
|
160 - Types of Joins in Tableau.mp4
|
MP4
|
36.3 MB
|
|
|
161 - Union in Tableau.mp4
|
MP4
|
53.5 MB
|
|
|
162 - Physical Logical layer and Data models.mp4
|
MP4
|
33 MB
|
|
|
163 - The visualization screen Sheet.mp4
|
MP4
|
47.4 MB
|
|
|
164 - Types of Data Dimensions and Measures.mp4
|
MP4
|
35 MB
|
|
|
165 - Types of Data Discreet and Continuous.mp4
|
MP4
|
28.2 MB
|
|
|
166 - Changing Data type in Tableau.mp4
|
MP4
|
52.1 MB
|
|
|
167 - Bar charts.mp4
|
MP4
|
73.3 MB
|
|
|
168 - Line charts.mp4
|
MP4
|
52.6 MB
|
|
|
169 - Scatterplots.mp4
|
MP4
|
38.5 MB
|
|
|
17 - DateTime Functions.mp4
|
MP4
|
46.8 MB
|
|
|
170 - Marks cards.mp4
|
MP4
|
82.9 MB
|
|
|
171 - Dropping Dimensions and Measures on marks card.mp4
|
MP4
|
63.1 MB
|
|
|
172 - Dropping Dimensions on Line chart.mp4
|
MP4
|
26.7 MB
|
|
|
173 - Adding marks in scatterplot.mp4
|
MP4
|
24.5 MB
|
|
|
174 - Text tables heat map and highlight tables.mp4
|
MP4
|
47.6 MB
|
|
|
175 - Pie charts.mp4
|
MP4
|
46.5 MB
|
|
|
176 - Area charts.mp4
|
MP4
|
74.3 MB
|
|
|
177 - Creating custom hierarchy.mp4
|
MP4
|
26.1 MB
|
|
|
178 - Tree map.mp4
|
MP4
|
34.7 MB
|
|
|
179 - Dual combination charts.mp4
|
MP4
|
50.3 MB
|
|
|
18 - Lookup Functions V Lookup Hlookup IndexMatch.mp4
|
MP4
|
62.5 MB
|
|
|
180 - Creating Bins.mp4
|
MP4
|
30.7 MB
|
|
|
181 - Histogram.mp4
|
MP4
|
26.8 MB
|
|
|
182 - Grouping Data.mp4
|
MP4
|
52.6 MB
|
|
|
183 - Filtering data.mp4
|
MP4
|
56.3 MB
|
|
|
184 - Dimension filters.mp4
|
MP4
|
62.6 MB
|
|
|
185 - Measure filters.mp4
|
MP4
|
22.9 MB
|
|
|
186 - DateTime filters.mp4
|
MP4
|
50.7 MB
|
|
|
187 - Filter options.mp4
|
MP4
|
49.6 MB
|
|
|
188 - Types of filters and order of operation.mp4
|
MP4
|
71.3 MB
|
|
|
189 - Customizing visual filters.mp4
|
MP4
|
60.6 MB
|
|
|
19 - Data Tools Part 1.mp4
|
MP4
|
90.2 MB
|
|
|
190 - Sorting options.mp4
|
MP4
|
87.8 MB
|
|
|
191 - How to make a map chart.mp4
|
MP4
|
49.7 MB
|
|
|
192 - Considerations before making a Map chart.mp4
|
MP4
|
24.2 MB
|
|
|
193 - Marks card for customizing maps.mp4
|
MP4
|
62.4 MB
|
|
|
194 - Customizing maps using map menu.mp4
|
MP4
|
95.3 MB
|
|
|
195 - Layers in a Map.mp4
|
MP4
|
69.9 MB
|
|
|
196 - Visual toolbar on a map.mp4
|
MP4
|
35.7 MB
|
|
|
197 - Custom background images.mp4
|
MP4
|
77.9 MB
|
|
|
198 - Territories in maps.mp4
|
MP4
|
44 MB
|
|
|
199 - Data blending for missing geocoding.mp4
|
MP4
|
83.6 MB
|
|
|
2 - Getting started with Excel.mp4
|
MP4
|
52.1 MB
|
|
|
20 - Data Tools Part 2.mp4
|
MP4
|
48.7 MB
|
|
|
200 - Calculated fields in Tableau.mp4
|
MP4
|
83.8 MB
|
|
|
201 - Functions in Tableau.mp4
|
MP4
|
12 MB
|
|
|
202 - Table calculations theory.mp4
|
MP4
|
37.3 MB
|
|
|
203 - Table calculations in Tableau.mp4
|
MP4
|
72.3 MB
|
|
|
204 - Understanding LOD expressions.mp4
|
MP4
|
155.5 MB
|
|
|
205 - LOD expressions examples.mp4
|
MP4
|
83.7 MB
|
|
|
206 - Analytics pane.mp4
|
MP4
|
125.4 MB
|
|
|
207 - Understanding sets in Tableau.mp4
|
MP4
|
17.4 MB
|
|
|
208 - Creating Sets in Tableau.mp4
|
MP4
|
62.8 MB
|
|
|
209 - Parameters.mp4
|
MP4
|
98.1 MB
|
|
|
21 - Formatting data and tables.mp4
|
MP4
|
166.6 MB
|
|
|
210 - Dashboard part 1.mp4
|
MP4
|
104.5 MB
|
|
|
211 - Dashboard part 2.mp4
|
MP4
|
82.2 MB
|
|
|
212 - Story.mp4
|
MP4
|
25.4 MB
|
|
|
213 - Connecting to SQL data source.mp4
|
MP4
|
36.4 MB
|
|
|
214 - Connecting to cloud storage services.mp4
|
MP4
|
19.1 MB
|
|
|
215 - The final milestone.mp4
|
MP4
|
12.7 MB
|
|
|
216 - Bonus lecture.html
|
HTML
|
2.4 KB
|
|
|
22 - Pivot Tables.mp4
|
MP4
|
73.7 MB
|
|
|
23 - Excel Charts Categories of messages that can be conveyed.mp4
|
MP4
|
16.9 MB
|
|
|
24 - Elements of charts.mp4
|
MP4
|
27.5 MB
|
|
|
25 - The Easy way of creating charts.mp4
|
MP4
|
23.5 MB
|
|
|
26 - Bar and column charts.mp4
|
MP4
|
91.5 MB
|
|
|
27 - Formatting charts Part 1.mp4
|
MP4
|
69.8 MB
|
|
|
28 - Formatting charts Part 2.mp4
|
MP4
|
32 MB
|
|
|
29 - Line Charts.mp4
|
MP4
|
87.2 MB
|
|
|
3 - Course Resources.html
|
HTML
|
409.6 B
|
|
|
30 - Area Charts.mp4
|
MP4
|
48.3 MB
|
|
|
31 - Pie and Doughnut Charts.mp4
|
MP4
|
104.5 MB
|
|
|
32 - Why we should avoid Pie charts.mp4
|
MP4
|
19.5 MB
|
|
|
33 - Scatter plot or XY chart.mp4
|
MP4
|
133.5 MB
|
|
|
34 - Frequency Distribution and Histograms.mp4
|
MP4
|
91.5 MB
|
|
|
35 - Waterfall Charts.mp4
|
MP4
|
77.6 MB
|
|
|
36 - Hierarchy Charts Sunburst and Treemap.mp4
|
MP4
|
70.7 MB
|
|
|
37 - Combination charts.mp4
|
MP4
|
61.7 MB
|
|
|
38 - Sparklines.mp4
|
MP4
|
42.4 MB
|
|
|
39 - Pivot Charts.mp4
|
MP4
|
47.1 MB
|
|
|
4 - This is a milestone.mp4
|
MP4
|
21.9 MB
|
|
|
40 - Stock charts.mp4
|
MP4
|
94.7 MB
|
|
|
41 - Radar charts.mp4
|
MP4
|
34.8 MB
|
|
|
42 - Surface charts.mp4
|
MP4
|
49.7 MB
|
|
|
43 - Heatmaps.mp4
|
MP4
|
40.5 MB
|
|
|
44 - Named Ranges.mp4
|
MP4
|
65.3 MB
|
|
|
45 - Indirect Functions.mp4
|
MP4
|
35.9 MB
|
|
|
46 - Shortcuts.mp4
|
MP4
|
103.8 MB
|
|
|
47 - Macros.mp4
|
MP4
|
71.5 MB
|
|
|
48 - Advanced Excel Analytics in Excel.mp4
|
MP4
|
123 MB
|
|
|
49 - Infographic Example 1.mp4
|
MP4
|
116.6 MB
|
|
|
5 - Worksheet basics.mp4
|
MP4
|
93.6 MB
|
|
|
50 - Infographic Example 2.mp4
|
MP4
|
37 MB
|
|
|
51 - Introduction.mp4
|
MP4
|
22.9 MB
|
|
|
52 - Installing PostgreSQL and pgAdmin in your PC.mp4
|
MP4
|
83.4 MB
|
|
|
53 - If pgAdmin is not opening.html
|
HTML
|
1.6 KB
|
|
|
54 - Case Study Part 1 Business problems.mp4
|
MP4
|
37.8 MB
|
|
|
55 - Case Study Part 2 How SQL is Used.mp4
|
MP4
|
59 MB
|
|
|
56 - CREATE.mp4
|
MP4
|
91.1 MB
|
|
|
57 - INSERT.mp4
|
MP4
|
73 MB
|
|
|
58 - Import data from File.mp4
|
MP4
|
42 MB
|
|
|
59 - SELECT statement.mp4
|
MP4
|
31.8 MB
|
|
|
6 - Entering values and Formulas.mp4
|
MP4
|
38.3 MB
|
|
|
60 - SELECT DISTINCT.mp4
|
MP4
|
46.2 MB
|
|
|
61 - WHERE.mp4
|
MP4
|
32.6 MB
|
|
|
62 - Logical Operators.mp4
|
MP4
|
50.5 MB
|
|
|
63 - UPDATE.mp4
|
MP4
|
38.2 MB
|
|
|
64 - DELETE.mp4
|
MP4
|
30 MB
|
|
|
65 - ALTER part 1.mp4
|
MP4
|
46.3 MB
|
|
|
66 - ALTER part 2.mp4
|
MP4
|
84.1 MB
|
|
|
67 - Restore and Backup.mp4
|
MP4
|
81.4 MB
|
|
|
68 - Debugging restoration issues.mp4
|
MP4
|
53.6 MB
|
|
|
69 - Creating DB using CSV files.mp4
|
MP4
|
38.4 MB
|
|
|
7 - Data Formats.mp4
|
MP4
|
48.7 MB
|
|
|
70 - Debugging summary and Code for CSV files.html
|
HTML
|
2.2 KB
|
|
|
71 - IN.mp4
|
MP4
|
29.6 MB
|
|
|
72 - BETWEEN.mp4
|
MP4
|
52.3 MB
|
|
|
73 - LIKE.mp4
|
MP4
|
72.7 MB
|
|
|
74 - Side Lecture Commenting in SQL.mp4
|
MP4
|
13.1 MB
|
|
|
75 - ORDER BY.mp4
|
MP4
|
72.8 MB
|
|
|
76 - LIMIT.mp4
|
MP4
|
29.3 MB
|
|
|
77 - AS.mp4
|
MP4
|
27.3 MB
|
|
|
78 - COUNT.mp4
|
MP4
|
43.9 MB
|
|
|
79 - SUM.mp4
|
MP4
|
26.1 MB
|
|
|
8 - Data Handling Basics Cut Copy Paste.mp4
|
MP4
|
89.8 MB
|
|
|
80 - AVERAGE.mp4
|
MP4
|
21.1 MB
|
|
|
81 - MIN MAX.mp4
|
MP4
|
32.3 MB
|
|
|
82 - GROUP BY.mp4
|
MP4
|
104.7 MB
|
|
|
83 - HAVING.mp4
|
MP4
|
38.8 MB
|
|
|
84 - CASE WHEN.mp4
|
MP4
|
35.1 MB
|
|
|
85 - Introductions to Joins.mp4
|
MP4
|
8.6 MB
|
|
|
86 - Concepts of Joining and Combining Data.mp4
|
MP4
|
65 MB
|
|
|
87 - Preparing the data.mp4
|
MP4
|
15.7 MB
|
|
|
88 - Inner Join.mp4
|
MP4
|
51.1 MB
|
|
|
89 - Left Join.mp4
|
MP4
|
40 MB
|
|
|
9 - Saving and Printing in Excel.mp4
|
MP4
|
52.2 MB
|
|
|
90 - Right Join.mp4
|
MP4
|
39 MB
|
|
|
91 - Full Outer Join.mp4
|
MP4
|
34.3 MB
|
|
|
92 - Cross Join.mp4
|
MP4
|
20.2 MB
|
|
|
93 - Intersect and Intersect ALL.mp4
|
MP4
|
26.5 MB
|
|
|
94 - Except.mp4
|
MP4
|
14 MB
|
|
|
95 - Union.mp4
|
MP4
|
38.8 MB
|
|
|
96 - Part1 Subquery in WHERE clause.mp4
|
MP4
|
25.7 MB
|
|
|
97 - Part2 Subquery in FROM clause.mp4
|
MP4
|
34.7 MB
|
|
|
98 - Part3 Subquery in SELECT clause.mp4
|
MP4
|
29.1 MB
|
|
|
99 - VIEWS.mp4
|
MP4
|
37 MB
|
|
|
[CourseClub.Me].url
|
URL
|
102.4 B
|
|
|
[FreeCourseSite.com].url
|
URL
|
102.4 B
|
|
|
[GigaCourse.Com].url
|
URL
|
0 B
|
