Feel free to connect on LinkedIn if you ave any questions or would like the database used in the video, I can share a word doc that has the steps to get this installed. I would appreciate if you like and subscribe. This video took me 20+ hours to edit! www.linkedin.com/in/rajausmaanayub ⌚Timestamps 0:00 - Introduction 0:28 - What are databases/SQL? 1:38 - Selecting Database 2:04 - Loading a Table 2:26 - Choosing columns 3:02 - Renaming columns 3:47 - WHERE / filtering 4:21 - AND OR 4:58 - Test1 7:08 - COUNT 7:56 - Grouping Calculations 9:23 - SUM 11:27 - Divide 11:54 - Average 12:14 - JOINS 18:24 - Test2 20:31 - IS NULL / NOT NOLL 21:10 - BETWEEN 21:51 - WILDCARDS 23:14 - IN & NOT IN 24:17 - IF ELSE (CASE) 25:15 - Final Scenerio
@vincofrohlich5854
18 күн бұрын
Hey Raja I`ve connected with you in LinkedIn but for some reason, I`m not able to send you a message. I would love to learn SQL with your video, would it be please possible to share the DB file ?
@end-game2030
Жыл бұрын
Nice. Useful content
@kondor7
Жыл бұрын
I only have a slight knowledge of SQL and this helps me to freshen up and learn some new things 👌
@Transformita
Жыл бұрын
Glad that it helped.
@efazhossain9445
Ай бұрын
Can you attach the data files you're working with ,please? It'll be easy to follow along. Thanks!
@alexrosen8762
Жыл бұрын
Very useful. Thanks 🙏
@Transformita
Жыл бұрын
Glad it was helpful! I appreciate the comment.
@timknight5105
Жыл бұрын
Very good. Make more!
@Transformita
Жыл бұрын
Thank you. Will do, got a few videos coming out 👍🏼
@hydratednation4519
Жыл бұрын
Message sent via linkedin 👍
@bloodyred633
Жыл бұрын
How much i have to be expert on SQL to start applying for job?
@Transformita
Жыл бұрын
It really depends on the role. Junior level data anlayst, you're probably good to go with this, learning the other joins, Excel and basic Power BI.
Пікірлер: 15