Tutorialsplanet NET Udemy - Data Engineering Essentials Hands-on SQL Python and Spark

1. 1. Introduction about the course/1. Introduction about course.mp438.1MB
2. 1. Introduction about the course/2. Desired Audience.mp420.51MB
3. 1. Introduction about the course/3. Pre-requisites.mp432.13MB
4. 1. Introduction about the course/4. [Must Watch] 30 Day Money Back Guarantee - Feedback and Rating.mp46.04MB
5. 1. Introduction about the course/5. Training Approach.mp436.72MB
6. 1. Introduction about the course/6. Overview of Environments for Hands on Practice (Must Watch).mp421.23MB
7. 1. Introduction about the course/8. [Must Watch] Setting up Course Material.mp458.35MB
8. 10. Database Essentials - Partitioning Tables and Indexes/1. Overview of Partitioning.mp48.91MB
9. 10. Database Essentials - Partitioning Tables and Indexes/10. Usage Scenarios.mp428.19MB
10. 10. Database Essentials - Partitioning Tables and Indexes/11. Sub Partitioning.mp441.98MB
11. 10. Database Essentials - Partitioning Tables and Indexes/12. Exercise - Partitioned Tables.mp49.79MB
12. 10. Database Essentials - Partitioning Tables and Indexes/2. List Partitioning.mp427.93MB
13. 10. Database Essentials - Partitioning Tables and Indexes/3. Managing Partitions - List.mp452.59MB
14. 10. Database Essentials - Partitioning Tables and Indexes/4. Manipulating Data.mp430.79MB
15. 10. Database Essentials - Partitioning Tables and Indexes/5. Range Partitioning.mp418.9MB
16. 10. Database Essentials - Partitioning Tables and Indexes/6. Managing Partitions - Range.mp446.12MB
17. 10. Database Essentials - Partitioning Tables and Indexes/7. Repartitioning - Range.mp473.35MB
18. 10. Database Essentials - Partitioning Tables and Indexes/8. Hash Partitioning.mp426.63MB
19. 10. Database Essentials - Partitioning Tables and Indexes/9. Managing Partitions - Hash.mp446.43MB
20. 11. Database Essentials - Predefined Functions/1. Overview of Functions.mp441.4MB
21. 11. Database Essentials - Predefined Functions/10. Getting Current Date or Timestamp.mp422.45MB
22. 11. Database Essentials - Predefined Functions/11. Date Arithmetic.mp437.76MB
23. 11. Database Essentials - Predefined Functions/12. Beginning Date or Time using date_trunc.mp428.04MB
24. 11. Database Essentials - Predefined Functions/13. Using to_char and to_date.mp474.11MB
25. 11. Database Essentials - Predefined Functions/14. Extracting Information using extract.mp421.79MB
26. 11. Database Essentials - Predefined Functions/15. Dealing with Unix Timestamp or epoch.mp417.31MB
27. 11. Database Essentials - Predefined Functions/16. Overview of Numeric Functions.mp440.38MB
28. 11. Database Essentials - Predefined Functions/17. Data Type Conversion.mp423.29MB
29. 11. Database Essentials - Predefined Functions/18. Handling NULL Values.mp426.74MB
30. 11. Database Essentials - Predefined Functions/19. Using CASE and WHEN.mp445.58MB
31. 11. Database Essentials - Predefined Functions/2. String Manipulation Functions.mp47.81MB
32. 11. Database Essentials - Predefined Functions/3. Case Conversion and Length.mp426.6MB
33. 11. Database Essentials - Predefined Functions/4. Extracting Data - Using substr and split_part.mp4101.89MB
34. 11. Database Essentials - Predefined Functions/5. Using position or strpos.mp433.59MB
35. 11. Database Essentials - Predefined Functions/6. Trimming and Padding Functions.mp436MB
36. 11. Database Essentials - Predefined Functions/7. Reverse and Concatenate Multiple Strings.mp419.88MB
37. 11. Database Essentials - Predefined Functions/8. String Replacement.mp445.57MB
38. 11. Database Essentials - Predefined Functions/9. Date Manipulation Functions.mp412.15MB
39. 12. Database Essentials - Writing Advanced SQL Queries/1. Overview of Views.mp446.75MB
40. 12. Database Essentials - Writing Advanced SQL Queries/10. Cumulative or Moving Aggregations.mp451.16MB
41. 12. Database Essentials - Writing Advanced SQL Queries/11. Analytic Functions - Windowing.mp482.29MB
42. 12. Database Essentials - Writing Advanced SQL Queries/12. Analytic Functions - Ranking.mp472.65MB
43. 12. Database Essentials - Writing Advanced SQL Queries/13. Analytic Functions - Filtering.mp458.87MB
44. 12. Database Essentials - Writing Advanced SQL Queries/14. Ranking and Filtering - Recap.mp419.18MB
45. 12. Database Essentials - Writing Advanced SQL Queries/2. Overview of Named Queries.mp427.4MB
46. 12. Database Essentials - Writing Advanced SQL Queries/3. Overview of Sub Queries.mp441.45MB
47. 12. Database Essentials - Writing Advanced SQL Queries/4. CTAS - Create Table As Select.mp452.14MB
48. 12. Database Essentials - Writing Advanced SQL Queries/5. Advanced DML Operations.mp487.46MB
49. 12. Database Essentials - Writing Advanced SQL Queries/6. Merging or Upserting Data.mp455.67MB
50. 12. Database Essentials - Writing Advanced SQL Queries/7. Pivoting Rows into Columns.mp48.07MB
51. 12. Database Essentials - Writing Advanced SQL Queries/8. Overview of Analytic Functions.mp438.17MB
52. 12. Database Essentials - Writing Advanced SQL Queries/9. Analytic Functions - Aggregations.mp466.35MB
53. 13. Programming Essentials using Python - Perform Database Operations/1. Introduction - Perform Database Operations.mp49.2MB
54. 13. Programming Essentials using Python - Perform Database Operations/10. Example - Web Application.mp467.32MB
55. 13. Programming Essentials using Python - Perform Database Operations/11. Exercise - Database Operations.mp418.74MB
56. 13. Programming Essentials using Python - Perform Database Operations/2. Overview of SQL.mp414.55MB
57. 13. Programming Essentials using Python - Perform Database Operations/3. Create Database and Users Table.mp453.25MB
58. 13. Programming Essentials using Python - Perform Database Operations/4. DDL - Data Definition Language.mp440.96MB
59. 13. Programming Essentials using Python - Perform Database Operations/5. DML - Data Manipulation Language.mp441.93MB
60. 13. Programming Essentials using Python - Perform Database Operations/6. DQL - Data Query Language.mp431.35MB
61. 13. Programming Essentials using Python - Perform Database Operations/7. CRUD Operations - DML and DQL.mp413.58MB
62. 13. Programming Essentials using Python - Perform Database Operations/8. TCL - Transaction Control Language.mp48.55MB
63. 13. Programming Essentials using Python - Perform Database Operations/9. Example - Data Engineering.mp449.26MB
64. 14. Programming Essentials using Python - Getting Started with Python/1. Installing Python on Windows.mp448.48MB
65. 14. Programming Essentials using Python - Getting Started with Python/2. Overview of Anaconda.mp466.29MB
66. 14. Programming Essentials using Python - Getting Started with Python/3. Python CLI and Jupyter Notebook.mp455.59MB
67. 14. Programming Essentials using Python - Getting Started with Python/4. Overview of Jupyter Lab.mp438.25MB
68. 14. Programming Essentials using Python - Getting Started with Python/5. Using IDEs - Pycharm.mp442.97MB
69. 14. Programming Essentials using Python - Getting Started with Python/6. Using Visual Studio Code.mp430.52MB
70. 14. Programming Essentials using Python - Getting Started with Python/7. Using ITVersity Labs.mp441.07MB
71. 14. Programming Essentials using Python - Getting Started with Python/8. Leveraging Google Colab.mp485.66MB
72. 15. Programming Essentials using Python - Basic Programming Constructs/1. Basic Programming Constructs using Python - Introduction.mp48.67MB
73. 15. Programming Essentials using Python - Basic Programming Constructs/10. Exercises - Basic Programming Constructs.mp435.24MB
74. 15. Programming Essentials using Python - Basic Programming Constructs/11. Dynamic Arithmetic Operations using eval and exec.mp416.38MB
75. 15. Programming Essentials using Python - Basic Programming Constructs/2. Getting Help.mp422.02MB
76. 15. Programming Essentials using Python - Basic Programming Constructs/3. Variables and Objects.mp410.44MB
77. 15. Programming Essentials using Python - Basic Programming Constructs/4. Data Type - Commonly Used.mp48.49MB
78. 15. Programming Essentials using Python - Basic Programming Constructs/5. Operators in Python.mp413.19MB
79. 15. Programming Essentials using Python - Basic Programming Constructs/6. Tasks - Data Types and Operators.mp437.95MB
80. 15. Programming Essentials using Python - Basic Programming Constructs/7. Conditionals.mp458.46MB
81. 15. Programming Essentials using Python - Basic Programming Constructs/8. All about for loops.mp481.98MB
82. 15. Programming Essentials using Python - Basic Programming Constructs/9. Running os commands.mp475.11MB
83. 16. Programming Essentials using Python - Predefined Functions/1. Predefined Functions - Introduction.mp46.84MB
84. 16. Programming Essentials using Python - Predefined Functions/2. Overview of Predefined Functions.mp425.84MB
85. 16. Programming Essentials using Python - Predefined Functions/3. Numeric Functions.mp430.23MB
86. 16. Programming Essentials using Python - Predefined Functions/4. Overview of Strings.mp423.81MB
87. 16. Programming Essentials using Python - Predefined Functions/5. String Manipulation Functions.mp447.86MB
88. 16. Programming Essentials using Python - Predefined Functions/6. Formatting Strings.mp428.2MB
89. 16. Programming Essentials using Python - Predefined Functions/7. Print and Input Functions.mp434MB
90. 16. Programming Essentials using Python - Predefined Functions/8. Date Manipulation Functions.mp476.62MB
91. 16. Programming Essentials using Python - Predefined Functions/9. Exercises - Predefined Functions in Python.mp411.4MB
92. 17. Programming Essentials using Python - User Defined Functions/1. User Defined Functions - Introduction.mp47.34MB
93. 17. Programming Essentials using Python - User Defined Functions/10. Lambda Functions.mp427.17MB
94. 17. Programming Essentials using Python - User Defined Functions/11. Usage of Lambda Functions.mp479.27MB
95. 17. Programming Essentials using Python - User Defined Functions/12. Exercise - User Defined Functions.mp412.18MB
96. 17. Programming Essentials using Python - User Defined Functions/2. Defining Functions.mp420.29MB
97. 17. Programming Essentials using Python - User Defined Functions/3. Doc Strings.mp419.86MB
98. 17. Programming Essentials using Python - User Defined Functions/4. Returning Variables.mp421.86MB
99. 17. Programming Essentials using Python - User Defined Functions/5. Function Parameters and Arguments.mp456.47MB
100. 17. Programming Essentials using Python - User Defined Functions/6. Varying Arguments.mp441.4MB
101. 17. Programming Essentials using Python - User Defined Functions/7. Keyword Arguments.mp417.28MB
102. 17. Programming Essentials using Python - User Defined Functions/8. Recap of User Defined Functions.mp491.95MB
103. 17. Programming Essentials using Python - User Defined Functions/9. Passing Functions as Arguments.mp435.79MB
104. 18/1. Overview of Collections - list and set - Introduction.mp410.25MB
105. 18/10. Validating sets.mp413.06MB
106. 18/11. list and set - Usage.mp459.8MB
107. 18/12. Exercises - Basic Operations on list and.mp415.66MB
108. 18/13. List of Delimited Strings.mp426.73MB
109. 18/14. Sorting data in lists and tuples.mp436.66MB
110. 18/15. Sorting list of Delimited Strings.mp447.41MB
111. 18/16. Exercises - Sorting lists and sets.mp434.01MB
112. 18/2. Overview of list and set.mp428.6MB
113. 18/3. Common Operations.mp413.37MB
114. 18/4. Accessing elements from list.mp424.82MB
115. 18/5. Adding elements to list.mp416.92MB
116. 18/6. Updating and Deleting elements -list.mp413.88MB
117. 18/7. Other list operations.mp415.19MB
118. 18/8. Adding and Deleting elements - set.mp427.01MB
119. 18/9. Typical set operations.mp411MB
120. 19/1. Manipulating Collections using loops - Introduction.mp48.86MB
121. 19/10. Process dict values.mp419.96MB
122. 19/11. Processing dict items.mp436.52MB
123. 19/12. Sorting dict items.mp421.63MB
124. 19/13. Exercises - Overview of Collections - dict and set.mp415.75MB
125. 19/2. Overview of dict and tuple.mp433.32MB
126. 19/3. Common Operations - dict and tuple.mp425.86MB
127. 19/4. Accessing Elements - tuples.mp425.5MB
128. 19/5. Accessing Elements - dict.mp435.94MB
129. 19/6. Manipulating dict.mp465.54MB
130. 19/7. Common Examples - dict.mp436.48MB
131. 19/8. List of Tuples.mp477.99MB
132. 19/9. List of dicts.mp459.82MB
133. 2. Setting up Environment using AWS Cloud9/1. Getting Started with Cloud9.mp423.23MB
134. 2. Setting up Environment using AWS Cloud9/2. Creating Cloud9 Environment.mp433.91MB
135. 2. Setting up Environment using AWS Cloud9/3. Warming up with Cloud9 IDE.mp420.99MB
136. 2. Setting up Environment using AWS Cloud9/4. Details about material to setup postgres database using docker.mp49.92MB
137. 2. Setting up Environment using AWS Cloud9/5. Overview of EC2 related to Cloud9.mp410.37MB
138. 2. Setting up Environment using AWS Cloud9/6. Opening ports for Cloud9 Instance.mp422.7MB
139. 2. Setting up Environment using AWS Cloud9/7. Associating Elastic IPs to Cloud9 Instance.mp436.23MB
140. 2. Setting up Environment using AWS Cloud9/8. Increase EBS Volume Size of Cloud9 Instance.mp421.15MB
141. 2. Setting up Environment using AWS Cloud9/9. Setup Jupyter Lab on Cloud9.mp447.58MB
142. 20. Programming Essentials using Python - Manipulating Collections using loops/1. Manipulating Collections using loops - Introduction.mp414.3MB
143. 20. Programming Essentials using Python - Manipulating Collections using loops/10. Overview of Grouped Aggregations.mp413.43MB
144. 20. Programming Essentials using Python - Manipulating Collections using loops/11. Get Order Count by Status.mp450.02MB
145. 20. Programming Essentials using Python - Manipulating Collections using loops/12. Get Revenue Details per Order.mp499.79MB
146. 20. Programming Essentials using Python - Manipulating Collections using loops/13. Get Order Count by Month.mp427.67MB
147. 20. Programming Essentials using Python - Manipulating Collections using loops/14. Joining Data Sets.mp4102.56MB
148. 20. Programming Essentials using Python - Manipulating Collections using loops/15. Manipulate Collections using Comprehensions.mp46.25MB
149. 20. Programming Essentials using Python - Manipulating Collections using loops/16. List Comprehensions using Python.mp444.71MB
150. 20. Programming Essentials using Python - Manipulating Collections using loops/17. Set Comprehensions using Python.mp419MB
151. 20. Programming Essentials using Python - Manipulating Collections using loops/18. Dict Comprehensions in Python.mp430.66MB
152. 20. Programming Essentials using Python - Manipulating Collections using loops/19. Limitations of using loops.mp436.33MB
153. 20. Programming Essentials using Python - Manipulating Collections using loops/2. Reading Files into Collections.mp426.75MB
154. 20. Programming Essentials using Python - Manipulating Collections using loops/20. Exercises - Manipulating Collections using loops.mp449.95MB
155. 20. Programming Essentials using Python - Manipulating Collections using loops/3. Overview of Standard Transformations.mp426.39MB
156. 20. Programming Essentials using Python - Manipulating Collections using loops/4. Row Level Transformations.mp485.19MB
157. 20. Programming Essentials using Python - Manipulating Collections using loops/5. Getting Unique Elements.mp464.73MB
158. 20. Programming Essentials using Python - Manipulating Collections using loops/6. Filtering Data.mp485.42MB
159. 20. Programming Essentials using Python - Manipulating Collections using loops/7. Preparing Data Sets.mp437.58MB
160. 20. Programming Essentials using Python - Manipulating Collections using loops/8. Quick recap of dict operations.mp439.07MB
161. 20. Programming Essentials using Python - Manipulating Collections using loops/9. Performing Total Aggregations.mp496.86MB
162. 21. Programming Essentials using Python - Development of Map Reduce APIs/1. Develop myFilter.mp438.67MB
163. 21. Programming Essentials using Python - Development of Map Reduce APIs/10. Validate myJoin Function.mp446.88MB
164. 21. Programming Essentials using Python - Development of Map Reduce APIs/11. Exercises - Development of Map Reduce APIs.mp441.98MB
165. 21. Programming Essentials using Python - Development of Map Reduce APIs/2. Validate myFilter.mp445.69MB
166. 21. Programming Essentials using Python - Development of Map Reduce APIs/3. Develop myMap Function.mp430.72MB
167. 21. Programming Essentials using Python - Development of Map Reduce APIs/4. Validate myMap Function.mp463.52MB
168. 21. Programming Essentials using Python - Development of Map Reduce APIs/5. Develop myReduce Function.mp421.1MB
169. 21. Programming Essentials using Python - Development of Map Reduce APIs/6. Validate myReduce Function.mp430.23MB
170. 21. Programming Essentials using Python - Development of Map Reduce APIs/7. Develop myReduceByKey Function.mp425.71MB
171. 21. Programming Essentials using Python - Development of Map Reduce APIs/8. Validate myReduceByKey Function.mp460.7MB
172. 21. Programming Essentials using Python - Development of Map Reduce APIs/9. Develop myJoin Function.mp429.12MB
173. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/1. Preparing Data Sets.mp418.14MB
174. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/10. Cumulative Operations using itertools.mp448.63MB
175. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/11. Using itertools starmap.mp431.09MB
176. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/12. Overview of itertools groupby.mp435.56MB
177. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/13. Get order count by status using itertools groupby.mp425.53MB
178. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/14. Get revenue per order using itertools groupby.mp466.67MB
179. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/15. Limitations of Map Reduce Libraries.mp412.92MB
180. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/16. Exercises - Understanding Map Reduce Libraries.mp411.57MB
181. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/2. Filtering Data using filter.mp443.77MB
182. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/3. Projecting data using map.mp436.87MB
183. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/4. Row Level Transformations using map.mp470.09MB
184. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/5. Aggregations using reduce.mp443.16MB
185. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/6. Get Revenue for a given product id.mp446.66MB
186. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/7. Get total items sold and revenue for a product.mp432.05MB
187. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/8. Get total commission amount.mp437.68MB
188. 22. Programming Essentials using Python - Understanding Map Reduce Libraries/9. Overview of itertools.mp430.78MB
189. 23. Programming Essentials using Python - Basics of File IO using Python/1. Basics of File IO using Python - Introduction.mp419.15MB
190. 23. Programming Essentials using Python - Basics of File IO using Python/10. Read csv into list of strings.mp458.97MB
191. 23. Programming Essentials using Python - Basics of File IO using Python/11. Writing Strings to file in Append Mode.mp433.46MB
192. 23. Programming Essentials using Python - Basics of File IO using Python/12. Managing Files and Folders using Python.mp4115.22MB
193. 23. Programming Essentials using Python - Basics of File IO using Python/2. Overview of File IO.mp418.67MB
194. 23. Programming Essentials using Python - Basics of File IO using Python/3. Folders and Files.mp484.58MB
195. 23. Programming Essentials using Python - Basics of File IO using Python/4. File Paths and Names.mp428.31MB
196. 23. Programming Essentials using Python - Basics of File IO using Python/5. Overview of Retail Data.mp435.72MB
197. 23. Programming Essentials using Python - Basics of File IO using Python/6. Read text file into string.mp433.53MB
198. 23. Programming Essentials using Python - Basics of File IO using Python/7. Write string to text file.mp437.38MB
199. 23. Programming Essentials using Python - Basics of File IO using Python/8. Overview of modes to write into files.mp449.72MB
200. 23. Programming Essentials using Python - Basics of File IO using Python/9. Overview of Delimited Strings.mp427.13MB
201. 24. Programming Essentials using Python - Delimited Files and Collections/1. Delimited Files and Collections.mp49.22MB
202. 24. Programming Essentials using Python - Delimited Files and Collections/10. Apply Schema on lists from files.mp478.09MB
203. 24. Programming Essentials using Python - Delimited Files and Collections/2. Overview of Delimited Text Files.mp459.24MB
204. 24. Programming Essentials using Python - Delimited Files and Collections/3. Recap of basic file IO.mp458.53MB
205. 24. Programming Essentials using Python - Delimited Files and Collections/4. Read Delimited files into list of tuples.mp483.11MB
206. 24. Programming Essentials using Python - Delimited Files and Collections/5. Write Delimited Strings into files.mp472.05MB
207. 24. Programming Essentials using Python - Delimited Files and Collections/6. Overview of CSV Module.mp451.34MB
208. 24. Programming Essentials using Python - Delimited Files and Collections/7. Read Delimited data using CSV.mp482.96MB
209. 24. Programming Essentials using Python - Delimited Files and Collections/8. Writing iterables to files using csv.mp458.08MB
210. 24. Programming Essentials using Python - Delimited Files and Collections/9. Advantages of using csv module.mp410.12MB
211. 25. Programming Essentials using Python - Overview of Pandas Libraries/1. Overview of Pandas Libraries.mp412.33MB
212. 25. Programming Essentials using Python - Overview of Pandas Libraries/10. Writing Data Frames to Files.mp475.74MB
213. 25. Programming Essentials using Python - Overview of Pandas Libraries/11. Joining Data Frames.mp494.61MB
214. 25. Programming Essentials using Python - Overview of Pandas Libraries/2. Pandas Data Structures.mp441.64MB
215. 25. Programming Essentials using Python - Overview of Pandas Libraries/3. Overview of series.mp425.52MB
216. 25. Programming Essentials using Python - Overview of Pandas Libraries/4. Creating Data Frames from lists.mp423.85MB
217. 25. Programming Essentials using Python - Overview of Pandas Libraries/5. Data Frames - Basic Operations.mp491.93MB
218. 25. Programming Essentials using Python - Overview of Pandas Libraries/6. CSV to Pandas Data Frames.mp449MB
219. 25. Programming Essentials using Python - Overview of Pandas Libraries/7. Projecting and Filtering.mp476.41MB
220. 25. Programming Essentials using Python - Overview of Pandas Libraries/8. Performing Total Aggregations.mp480.1MB
221. 25. Programming Essentials using Python - Overview of Pandas Libraries/9. Performing Grouped Aggregations.mp476.57MB
222. 26. Programming Essentials using Python - Database Programming - CRUD Operations/1. Database Operations - CRUD Operations - Introduction.mp410.13MB
223. 26. Programming Essentials using Python - Database Programming - CRUD Operations/10. Querying Data From Table.mp470.15MB
224. 26. Programming Essentials using Python - Database Programming - CRUD Operations/11. Recap - CRUD Operations.mp49.67MB
225. 26. Programming Essentials using Python - Database Programming - CRUD Operations/2. Overview of Database Programming.mp427.84MB
226. 26. Programming Essentials using Python - Database Programming - CRUD Operations/3. Recap of RDBMS Concepts.mp447.81MB
227. 26. Programming Essentials using Python - Database Programming - CRUD Operations/4. Setup Database Client Libraries.mp458.59MB
228. 26. Programming Essentials using Python - Database Programming - CRUD Operations/5. Function Get Database Connection.mp420.97MB
229. 26. Programming Essentials using Python - Database Programming - CRUD Operations/6. Create Database Table.mp444.6MB
230. 26. Programming Essentials using Python - Database Programming - CRUD Operations/7. Inserting Data into Table.mp485.14MB
231. 26. Programming Essentials using Python - Database Programming - CRUD Operations/8. Updating Existing Table Data.mp420.03MB
232. 26. Programming Essentials using Python - Database Programming - CRUD Operations/9. Deleting Data From Table.mp414.74MB
233. 27/1. Database Programming - Batch Operations - Introduction.mp48.08MB
234. 27/2. Recap of Insert.mp418.91MB
235. 27/3. Preparing Database.mp427.57MB
236. 27/4. Reading Data From File.mp434.25MB
237. 27/5. Batch Loading of Data.mp464.83MB
238. 27/6. Best Practices Batch Loading.mp410.41MB
239. 28. Programming Essentials using Python - Processing JSON Data/1. Processing JSON Data - Introduction.mp49.49MB
240. 28. Programming Essentials using Python - Processing JSON Data/10. Common Use Cases for JSON.mp476.28MB
241. 28. Programming Essentials using Python - Processing JSON Data/11. Write to JSON files using json module.mp464.99MB
242. 28. Programming Essentials using Python - Processing JSON Data/12. Write to JSON files using pandas.mp449.45MB
243. 28. Programming Essentials using Python - Processing JSON Data/2. Overview of JSON.mp419.77MB
244. 28. Programming Essentials using Python - Processing JSON Data/3. JSON Data Types.mp414.72MB
245. 28. Programming Essentials using Python - Processing JSON Data/4. Create JSON String.mp461.1MB
246. 28. Programming Essentials using Python - Processing JSON Data/5. Process JSON String.mp4104.42MB
247. 28. Programming Essentials using Python - Processing JSON Data/6. Single JSON Document in Files.mp491.04MB
248. 28. Programming Essentials using Python - Processing JSON Data/7. Multiple JSON Documents in files.mp455.67MB
249. 28. Programming Essentials using Python - Processing JSON Data/8. Process JSON using Pandas.mp458.3MB
250. 28. Programming Essentials using Python - Processing JSON Data/9. Different JSON Formats supported by Pandas.mp479.88MB
251. 29. Programming Essentials using Python - Processing REST Payloads/1. Overview of REST APIs.mp426.04MB
252. 29. Programming Essentials using Python - Processing REST Payloads/2. Using curl command.mp444.63MB
253. 29. Programming Essentials using Python - Processing REST Payloads/3. Overview of Postman.mp447.32MB
254. 29. Programming Essentials using Python - Processing REST Payloads/4. Getting Started with requests.mp463.04MB
255. 29. Programming Essentials using Python - Processing REST Payloads/5. Convert REST Payload to Python Objects.mp453.7MB
256. 29. Programming Essentials using Python - Processing REST Payloads/6. Process REST Payload using Collection Operations.mp4131.13MB
257. 29. Programming Essentials using Python - Processing REST Payloads/7. Process REST Payload using Pandas.mp469.91MB
258. 3. Setting up Environment - Overview of GCP and Provision Ubuntu VM/1. Signing up for GCP.mp423.59MB
259. 3. Setting up Environment - Overview of GCP and Provision Ubuntu VM/2. Overview of GCP Web Console.mp414.24MB
260. 3. Setting up Environment - Overview of GCP and Provision Ubuntu VM/3. Overview of GCP Pricing.mp444.07MB
261. 3. Setting up Environment - Overview of GCP and Provision Ubuntu VM/4. Provision Ubuntu VM from GCP.mp453.55MB
262. 3. Setting up Environment - Overview of GCP and Provision Ubuntu VM/5. Setup Docker.mp474.5MB
263. 3. Setting up Environment - Overview of GCP and Provision Ubuntu VM/6. Validating Python.mp434.31MB
264. 3. Setting up Environment - Overview of GCP and Provision Ubuntu VM/7. Setup Jupyter Lab.mp478.91MB
265. 30. Understanding Python Virtual Environments/1. Introduction to Python Virtual Environments.mp41.8MB
266. 30. Understanding Python Virtual Environments/10. Define requirements file for Web Application.mp415.24MB
267. 30. Understanding Python Virtual Environments/11. Install Dependencies using requirements file for Web Application.mp443.8MB
268. 30. Understanding Python Virtual Environments/12. Create Virtual Environment for Data Engineering Application.mp427.02MB
269. 30. Understanding Python Virtual Environments/13. Install Dependencies for Data Engineering Application.mp452.53MB
270. 30. Understanding Python Virtual Environments/14. Install Dependencies for Data Engineering Application using Python 3.6.mp421.56MB
271. 30. Understanding Python Virtual Environments/15. Validate Python and Package Compatibility and Install Python 3.6.mp458.77MB
272. 30. Understanding Python Virtual Environments/16. Conclusion about understanding Python Virtual Environments.mp417.59MB
273. 30. Understanding Python Virtual Environments/2. Validating Python Versions.mp418.71MB
274. 30. Understanding Python Virtual Environments/3. Create Virtual Environment for Web Application.mp449.78MB
275. 30. Understanding Python Virtual Environments/4. Reviewing dependencies installed in Virtual Environment.mp416.12MB
276. 30. Understanding Python Virtual Environments/5. Installing Dependencies for Web Application using pip.mp445.57MB
277. 30. Understanding Python Virtual Environments/6. Getting Details about installed packages using pip.mp417.1MB
278. 30. Understanding Python Virtual Environments/7. Uninstall Packages using pip.mp427.07MB
279. 30. Understanding Python Virtual Environments/8. Cleanup Python Virtual Environment.mp414.5MB
280. 30. Understanding Python Virtual Environments/9. Recreate and Activate Virtual Environment for Web Application.mp46.6MB
281. 31. Overview of Pycharm for Python Application Development/1. Introduction to Pycharm for Python Application Development.mp44.28MB
282. 31. Overview of Pycharm for Python Application Development/10. Overview of Pycharm Integrated Terminal.mp425.38MB
283. 31. Overview of Pycharm for Python Application Development/11. Overview of Pycharm Integrated Terminal on Mac.mp412.26MB
284. 31. Overview of Pycharm for Python Application Development/12. Overview of Run Time Arguments for Python Applications.mp421.48MB
285. 31. Overview of Pycharm for Python Application Development/13. Passing Run Time Arguments using Pycharm.mp420.45MB
286. 31. Overview of Pycharm for Python Application Development/2. Installation of Pycharm on Windows.mp418.36MB
287. 31. Overview of Pycharm for Python Application Development/3. Installation of Pycharm on Mac.mp420.65MB
288. 31. Overview of Pycharm for Python Application Development/4. Setup Getting Started Project using Pycharm.mp430.22MB
289. 31. Overview of Pycharm for Python Application Development/5. Setup Getting Started Project using Pycharm on Mac.mp412.8MB
290. 31. Overview of Pycharm for Python Application Development/6. Setup de-demo project using Pycharm.mp415.4MB
291. 31. Overview of Pycharm for Python Application Development/7. Accessing Setting in Pycharm and Changing Font Size.mp49.01MB
292. 31. Overview of Pycharm for Python Application Development/8. Accessing Setting in Pycharm and Changing Font Size on Mac.mp413.89MB
293. 31. Overview of Pycharm for Python Application Development/9. Install Python Packages using Pycharm.mp413.58MB
294. 32. Data Copier - Getting Started/1. Introduction to Getting Started for Data copier.mp411.61MB
295. 32. Data Copier - Getting Started/10. Setup Project using Pycharm.mp430.68MB
296. 32. Data Copier - Getting Started/11. Managing Dependencies for the project.mp429.9MB
297. 32. Data Copier - Getting Started/12. Create GitHub Project.mp463.97MB
298. 32. Data Copier - Getting Started/2. Problem Statement - Data Copier.mp425.09MB
299. 32. Data Copier - Getting Started/3. Create Working Directory for the Project.mp48.73MB
300. 32. Data Copier - Getting Started/4. Setup Docker on Windows 10 Pro.mp446.13MB
301. 32. Data Copier - Getting Started/5. Quick Overview of Docker.mp4115.68MB
302. 32. Data Copier - Getting Started/6. Prepare Dataset.mp414.28MB
303. 32. Data Copier - Getting Started/7. Create Postgres Container.mp468.61MB
304. 32. Data Copier - Getting Started/8. Setup Postgres Database for development.mp452.4MB
305. 32. Data Copier - Getting Started/9. Overview of Postgres Database Commands.mp462.02MB
306. 33. Data Copier - Reading Data using Pandas/1. Reading Data using Pandas - Introduction.mp49.82MB
307. 33. Data Copier - Reading Data using Pandas/2. Overview of Retail Data.mp436.07MB
308. 33. Data Copier - Reading Data using Pandas/3. Adding Pandas to the project.mp431.76MB
309. 33. Data Copier - Reading Data using Pandas/4. Reading JSON Data using Pandas.mp451.06MB
310. 33. Data Copier - Reading Data using Pandas/5. Previewing Data using Pandas.mp448.66MB
311. 33. Data Copier - Reading Data using Pandas/6. Reading Data in Chunks using Pandas.mp437.62MB
312. 33. Data Copier - Reading Data using Pandas/7. Dynamically read files using os.mp428.43MB
313. 34. Data Copier - Database Programming using Pandas/1. Database Programming using Pandas - Introduction.mp411.85MB
314. 34. Data Copier - Database Programming using Pandas/10. Drop users table.mp415.31MB
315. 34. Data Copier - Database Programming using Pandas/2. Validate Postgres Setup using Docker.mp425.61MB
316. 34. Data Copier - Database Programming using Pandas/3. Add required dependencies for database programming using pandas.mp415.57MB
317. 34. Data Copier - Database Programming using Pandas/4. Create users table in retail_db Database.mp411.43MB
318. 34. Data Copier - Database Programming using Pandas/5. Populating Sample Data into users table.mp415.38MB
319. 34. Data Copier - Database Programming using Pandas/6. Reading data from table using Pandas.mp438.96MB
320. 34. Data Copier - Database Programming using Pandas/7. Truncate users table.mp416.1MB
321. 34. Data Copier - Database Programming using Pandas/8. Writing Pandas Dataframe to table.mp467.06MB
322. 34. Data Copier - Database Programming using Pandas/9. Validating users data.mp415.22MB
323. 35. Data Copier - Loading Data from files to tables/1. Loading Data from files to tables - Introduction.mp47.3MB
324. 35. Data Copier - Loading Data from files to tables/2. Populating Departments data into table.mp475.06MB
325. 35. Data Copier - Loading Data from files to tables/3. Validate departments table.mp422.19MB
326. 35. Data Copier - Loading Data from files to tables/4. Populating orders table in chunks.mp473.78MB
327. 35. Data Copier - Loading Data from files to tables/5. Validate orders table in database.mp426.08MB
328. 35. Data Copier - Loading Data from files to tables/6. Validate orders table using pandas.mp433.35MB
329. 36. Data Copier - Modularizing the application/1. Overview of main function.mp438.65MB
330. 36. Data Copier - Modularizing the application/10. Validate Integration logic.mp449.5MB
331. 36. Data Copier - Modularizing the application/11. Develop logic for multiple tables.mp434.6MB
332. 36. Data Copier - Modularizing the application/12. Validate logic for table list as run time argument.mp468.92MB
333. 36. Data Copier - Modularizing the application/13. Push changes to remote git repository.mp430.96MB
334. 36. Data Copier - Modularizing the application/2. Overview of Environment Variables.mp425.39MB
335. 36. Data Copier - Modularizing the application/3. Using os module for Environment Variables.mp450.37MB
336. 36. Data Copier - Modularizing the application/4. Passing Environment Variables using Pycharm.mp426.53MB
337. 36. Data Copier - Modularizing the application/5. Read logic using Pandas.mp465.73MB
338. 36. Data Copier - Modularizing the application/6. Validate read logic.mp453.43MB
339. 36. Data Copier - Modularizing the application/7. Write logic using Pandas.mp454.73MB
340. 36. Data Copier - Modularizing the application/8. Validate write logic.mp460.64MB
341. 36. Data Copier - Modularizing the application/9. Integrate read and write logic.mp436.37MB
342. 37. Data Copier - Dockerizing the application/1. Dockerizing the application - Introduction.mp44.85MB
343. 37. Data Copier - Dockerizing the application/10. Validate Network Connectivity between Docker Containers.mp422.5MB
344. 37. Data Copier - Dockerizing the application/11. Running Application from the Docker Container.mp451.82MB
345. 37. Data Copier - Dockerizing the application/12. Delete Docker Container.mp437.58MB
346. 37. Data Copier - Dockerizing the application/2. Prepare Database for validation.mp414.99MB
347. 37. Data Copier - Dockerizing the application/3. Pull and validate appropriate python image.mp449.57MB
348. 37. Data Copier - Dockerizing the application/4. Create and attach network to database container.mp451.74MB
349. 37. Data Copier - Dockerizing the application/5. Quick recap about Docker containers.mp427.74MB
350. 37. Data Copier - Dockerizing the application/6. Deploying application and installing dependencies in the docker container.mp462.48MB
351. 37. Data Copier - Dockerizing the application/7. Copy source data files into container.mp422.47MB
352. 37. Data Copier - Dockerizing the application/8. Add Data Copier container to custom network.mp426.94MB
353. 37. Data Copier - Dockerizing the application/9. Installing OS libraries as part of Docker container.mp415.34MB
354. 38. Data Copier - Using custom Docker Image/1. Using Custom Docker Image - Introduction.mp44.99MB
355. 38. Data Copier - Using custom Docker Image/10. Run application using Docker.mp460.25MB
356. 38. Data Copier - Using custom Docker Image/2. Getting started with docker custom image.mp437.18MB
357. 38. Data Copier - Using custom Docker Image/3. Install OS Modules in custom docker image.mp438.02MB
358. 38. Data Copier - Using custom Docker Image/4. Copying Source Code to Docker Custom Image.mp480.98MB
359. 38. Data Copier - Using custom Docker Image/5. Adding dependencies to the custom image.mp428.83MB
360. 38. Data Copier - Using custom Docker Image/6. Understanding docker custom image build process.mp428.21MB
361. 38. Data Copier - Using custom Docker Image/7. Mounting Data Folders on to Docker Container.mp434.69MB
362. 38. Data Copier - Using custom Docker Image/8. Passing Environment Variables to Docker Container.mp468.38MB
363. 38. Data Copier - Using custom Docker Image/9. Add Data Copier Container to custom network.mp442.45MB
364. 39. Data Copier - Deploy and Validate Application on Remote Server/1. Deploy and Validate Application on Remote Server - Introduction.mp49.76MB
365. 39. Data Copier - Deploy and Validate Application on Remote Server/10. Run and Validate Dockerized Application.mp473.58MB
366. 39. Data Copier - Deploy and Validate Application on Remote Server/2. Push Application Changes to GitHub Repository.mp419.28MB
367. 39. Data Copier - Deploy and Validate Application on Remote Server/3. Requirements to deploy application on Virtual Machine.mp428.67MB
368. 39. Data Copier - Deploy and Validate Application on Remote Server/4. Clone Application on remote machine.mp423.48MB
369. 39. Data Copier - Deploy and Validate Application on Remote Server/5. Setup Data Set for Validation.mp424.48MB
370. 39. Data Copier - Deploy and Validate Application on Remote Server/6. Setup Network and Database Folder for Database using Docker.mp430.84MB
371. 39. Data Copier - Deploy and Validate Application on Remote Server/7. Setup Docker Container for the Database.mp466.1MB
372. 39. Data Copier - Deploy and Validate Application on Remote Server/8. Setup Database and Tables as part of Docker based Database Server.mp437.38MB
373. 39. Data Copier - Deploy and Validate Application on Remote Server/9. Building Custom Docker Image for application.mp434.42MB
374. 4. Networking Concepts for Beginners - ip addresses and port numbers/1. Enable telnet on Windows.mp414MB
375. 4. Networking Concepts for Beginners - ip addresses and port numbers/10. Setup Web Application and access using private ip.mp430.23MB
376. 4. Networking Concepts for Beginners - ip addresses and port numbers/11. Disable Access to Web Application using Public ip.mp425.03MB
377. 4. Networking Concepts for Beginners - ip addresses and port numbers/12. Install sshuttle on Mac using brew.mp410.78MB
378. 4. Networking Concepts for Beginners - ip addresses and port numbers/13. Access Web Application using Private IP using SSH as proxy.mp442.94MB
379. 4. Networking Concepts for Beginners - ip addresses and port numbers/2. Different IP Address Types.mp421.7MB
380. 4. Networking Concepts for Beginners - ip addresses and port numbers/3. Port Numbers associated with Applications or Services.mp450.95MB
381. 4. Networking Concepts for Beginners - ip addresses and port numbers/4. Reverting port for SSH to default port number.mp421.16MB
382. 4. Networking Concepts for Beginners - ip addresses and port numbers/5. Setup Apache2 on Ubuntu.mp441.46MB
383. 4. Networking Concepts for Beginners - ip addresses and port numbers/6. Overview of localhost.mp415.94MB
384. 4. Networking Concepts for Beginners - ip addresses and port numbers/7. Overview of Private IP Address associated with a server.mp430.25MB
385. 4. Networking Concepts for Beginners - ip addresses and port numbers/8. Overview of Public IP Address associated with a server.mp438.06MB
386. 4. Networking Concepts for Beginners - ip addresses and port numbers/9. Setup Web Application and access using local ip.mp442.18MB
387. 40. Setup Hadoop on Single Node Cluster/1. Introduction to Single Node Hadoop Cluster.mp416.4MB
388. 40. Setup Hadoop on Single Node Cluster/2. Setup Prerequisties.mp431.43MB
389. 40. Setup Hadoop on Single Node Cluster/3. Setup Password less login.mp417.24MB
390. 40. Setup Hadoop on Single Node Cluster/4. Download and Install Hadoop.mp430.56MB
391. 40. Setup Hadoop on Single Node Cluster/5. Configure Hadoop HDFS.mp447.35MB
392. 40. Setup Hadoop on Single Node Cluster/6. Start and Validate HDFS.mp446.12MB
393. 40. Setup Hadoop on Single Node Cluster/7. Configure Hadoop YARN.mp47.72MB
394. 40. Setup Hadoop on Single Node Cluster/8. Start and Validate YARN.mp414.29MB
395. 40. Setup Hadoop on Single Node Cluster/9. Managing Single Node Hadoop.mp420.23MB
396. 41. Setup Hive and Spark on Single Node Cluster/1. Setup Data Sets for Practice.mp438.95MB
397. 41. Setup Hive and Spark on Single Node Cluster/10. Validate Jupyter Lab Setup.mp467.88MB
398. 41. Setup Hive and Spark on Single Node Cluster/11. Intergrate Spark 2 with Jupyter Lab.mp438.77MB
399. 41. Setup Hive and Spark on Single Node Cluster/12. Download and Install Spark 3.mp414.65MB
400. 41. Setup Hive and Spark on Single Node Cluster/13. Configure Spark 3.mp458.91MB
401. 41. Setup Hive and Spark on Single Node Cluster/14. Validate Spark 3 using CLIs.mp462.49MB
402. 41. Setup Hive and Spark on Single Node Cluster/15. Intergrate Spark 3 with Jupyter Lab.mp425.31MB
403. 41. Setup Hive and Spark on Single Node Cluster/2. Download and Install Hive.mp413.22MB
404. 41. Setup Hive and Spark on Single Node Cluster/3. Setup Database for Hive Metastore.mp453.29MB
405. 41. Setup Hive and Spark on Single Node Cluster/4. Configure and Setup Hive Metastore.mp453.46MB
406. 41. Setup Hive and Spark on Single Node Cluster/5. Launch and Validate Hive.mp436.08MB
407. 41. Setup Hive and Spark on Single Node Cluster/6. Scripts to Manage Single Node Cluster.mp422.37MB
408. 41. Setup Hive and Spark on Single Node Cluster/7. Download and Install Spark 2.mp425.36MB
409. 41. Setup Hive and Spark on Single Node Cluster/8. Configure Spark 2.mp466.77MB
410. 41. Setup Hive and Spark on Single Node Cluster/9. Validate Spark 2 using CLIs.mp466.22MB
411. 42. Introduction to Hadoop eco system - Overview of HDFS/1. Getting help or usage.mp434.51MB
412. 42. Introduction to Hadoop eco system - Overview of HDFS/10. Getting HDFS Storage Usage.mp415.04MB
413. 42. Introduction to Hadoop eco system - Overview of HDFS/11. USing HDFS Stat Commands.mp410.79MB
414. 42. Introduction to Hadoop eco system - Overview of HDFS/12. HDFS File Permissions.mp468.92MB
415. 42. Introduction to Hadoop eco system - Overview of HDFS/13. Overriding Properties.mp442.7MB
416. 42. Introduction to Hadoop eco system - Overview of HDFS/2. Listing HDFS Files.mp441.48MB
417. 42. Introduction to Hadoop eco system - Overview of HDFS/3. Managing HDFS Directories.mp493.79MB
418. 42. Introduction to Hadoop eco system - Overview of HDFS/4. Copying files from local to HDFS.mp4102.57MB
419. 42. Introduction to Hadoop eco system - Overview of HDFS/5. Copying files from HDFS to local.mp440.85MB
420. 42. Introduction to Hadoop eco system - Overview of HDFS/6. Getting Files Metadata.mp466.85MB
421. 42. Introduction to Hadoop eco system - Overview of HDFS/7. Previewing Data in HDFS Files.mp436.65MB
422. 42. Introduction to Hadoop eco system - Overview of HDFS/8. HDFS Block Size.mp440.64MB
423. 42. Introduction to Hadoop eco system - Overview of HDFS/9. HDFS Replication Factor.mp457.52MB
424. 43. Data Engineering using Spark SQL - Getting Started/1. Getting Started - Overview.mp49.76MB
425. 43. Data Engineering using Spark SQL - Getting Started/10. Role of Spark Metastore or Hive Metastore.mp427.82MB
426. 43. Data Engineering using Spark SQL - Getting Started/11. Exercise - Getting Started with Spark SQL.mp458.18MB
427. 43. Data Engineering using Spark SQL - Getting Started/2. Overview of Spark Documentation.mp420.83MB
428. 43. Data Engineering using Spark SQL - Getting Started/3. Launching and using Spark SQL CLI.mp429.4MB
429. 43. Data Engineering using Spark SQL - Getting Started/4. Overview of Spark SQL Properties.mp470.11MB
430. 43. Data Engineering using Spark SQL - Getting Started/5. Running OS Commands using Spark SQL.mp424.13MB
431. 43. Data Engineering using Spark SQL - Getting Started/6. Understanding Warehouse Directory.mp430.41MB
432. 43. Data Engineering using Spark SQL - Getting Started/7. Managing Spark Metastore Databases.mp465.63MB
433. 43. Data Engineering using Spark SQL - Getting Started/8. Managing Spark Metastore Tables.mp417.51MB
434. 43. Data Engineering using Spark SQL - Getting Started/9. Retrieve Metadata of Tables.mp415.25MB
435. 44. Data Engineering using Spark SQL - Basic Transformations/1. Basic Transformations - Introduction.mp416.63MB
436. 44. Data Engineering using Spark SQL - Basic Transformations/10. Sorting Data.mp432.16MB
437. 44. Data Engineering using Spark SQL - Basic Transformations/11. Conclusion - Final Solution.mp423.39MB
438. 44. Data Engineering using Spark SQL - Basic Transformations/2. Spark SQL - Overview.mp442.5MB
439. 44. Data Engineering using Spark SQL - Basic Transformations/3. Define Problem Statement.mp419.57MB
440. 44. Data Engineering using Spark SQL - Basic Transformations/4. Prepare Tables.mp434.15MB
441. 44. Data Engineering using Spark SQL - Basic Transformations/5. Projecting Data.mp430.08MB
442. 44. Data Engineering using Spark SQL - Basic Transformations/6. Filtering Data.mp469.94MB
443. 44. Data Engineering using Spark SQL - Basic Transformations/7. Joining Tables - Inner.mp452.84MB
444. 44. Data Engineering using Spark SQL - Basic Transformations/8. Joining Tables - Outer.mp456.2MB
445. 44. Data Engineering using Spark SQL - Basic Transformations/9. Aggregation Data.mp481.3MB
446. 45. Data Engineering using Spark SQL - Managing Tables - Basic DDL and DML/1. Introduction.mp420.06MB