Dear WScube, please make a Course on Stock Market or trading from very Basic to Advance level Because on RU-vid there are NOT very good sources are available to learn it from scratch so kindly make a playlist on learn stock market from Basic to Advance level. 😇
If you have basic knowledge about sql then it will be quick revision for you. Mentor is so good at explaining. it's not for absolute beginners but if you want a clear explaination then it's a masterpiece video. Thankyou mam for teaching us.
And I also requested to wscube tech team to make a brief video or Playlist on microcontroller programming especially esp 32. I mean full coding and logics of programing using in esp ide.
00:00:00 - About the SQL Course 00:01:17 - What is SQL? 00:02:08 - What we Learn (SQL query in MySQL) 00:07:38 - Connect MySQL with Jupyter 00:10:58 - Understand SQL Query 00:11:19 - Select Query for data retrieval 00:14:44 - RETRIEVE SPECIFIC DATA (uses of WHERE) 00:18:01 - AND, OR, NOT operators 00:21:29 - BETWEEN Operator 00:22:43 - IN & NOT IN operators 00:24:18 - LIKE operators (retrieve data on pattern detection) 00:25:48 - ORDER BY (arrange data ascending or descending) 00:28:12 - Beautify your code 00:28:47 - Limit Query 00:30:13 - Function in MySQL 00:30:16 - Aggregate Functions 00:31:02 - Round Function 00:31:36 - AVG, MAX & MIN Function 00:32:40 - Count Function 00:33:48 - How to count Distinct 00:35:16 - Talking About Text Function 00:35:55 - Length Functions 00:36:23 - How to remove white spaces (Trim Functions) 00:36:50 - Convert Data to Lower and Upper case 00:37:21 - How to Replace Value? 00:38:18 - Concat Function (Join columns) 00:39:44 - Date Function & Time Function() 00:42:32 - (Day, Month, Month Name, Year, Dayname, Datediff) 00:42:32 - Numeric Functions (CEIL & FLOOR) 00:47:52 - Null Value in Data 00:49:10 - Group by Function (Create Pivot Data) 00:53:20 - Utilization of HAVING (difference between WHERE and HAVING) 00:55:25 - Utilization of JOIN 01:01:08 - Left Join & Right Join, Self Join, Cross Join 01:04:19 - Concept of Subquery 01:10:14 - Case Operator 01:12:52 - Window Function 01:19:41 - Creating View
Mene pgdca kare rakha hai muje advance Excel,SQL,and power bi ata hai and mene eske project bhi bana rakhe hai kya me data analysis job ke liye apply Kare sakta hu ya muje alag se eska course karna hoga please reply