Job Searching Ep. 2 | studying sql & python (w/ tips!), trying to enjoy unemployment life
ฝัง
- เผยแพร่เมื่อ 23 มี.ค. 2024
- Hello friends,
I received some call-back interviews so in this video I started preparing for tech screens! There are amazing videos out there that actually teach the technical aspects of SQL & Python, so instead, I wanted to share some of my favorite resources that have been helping me. As always, I hope you enjoy!
xx,
Julia
[let’s connect!]
instagram: @julia.fei
/ julia.fei
[study resources]
product data science →
• vlogs: • //data science
• / what-does-a-product-da...
sql →
• mode.com/sql-tutorial
• leetcode.com/studyplan/top-sq...
• / sql-window-functions
• @emma_ding • Master SQL Window Func...
python →
• www.kaggle.com/learn/pandas
• github.com/guipsamora/pandas_...
[products mentioned]
• pinstripe pants (ivory stripe, M): go.magik.ly/ml/1sw0y/
• button-down shirt (similar): go.magik.ly/ml/216i5/
• jacket (similar): go.magik.ly/ml/216i3/
• necklace: bit.ly/499shdZ
• infinite hoops: bit.ly/3xaXkJh
• molten hoops: bit.ly/3TMTxdY
[cooking]
• thit kho recipe: helenrecipes.com/recipe-42-th...
[freebies]
+ Try out Notability: apps.apple.com/app/apple-stor...
+ 20% off your first Outdoor Voices order: JULIA20
+ 10% off your first Mejuri purchase: mejurifinecrew.sjv.io/juliafei
+ 30-day free trial for copyright-free music: www.epidemicsound.com/referra...
+ shop my amazon favorites: www.amazon.com/shop/juliafei
[about me]
Hi everyone my name is Julia ~ I'm a 20-something-year-old data scientist navigating through life in NYC. You can find vlogs, fashion & beauty content, productivity videos, and more on my channel. Thanks for stopping by & I hope you enjoy :)
[ftc]
This video is not sponsored. There are some affiliate links above, meaning I may earn a small commission if any purchases are made. Thank you for supporting my channel - it means the world to me ♥
[business Inquiries only]
email: laujuliafei@gmail.com
![อาจารย์ยอด : เรื่องแปลกจากท้องนา [ผี]](http://i.ytimg.com/vi/8PxYzVOjmK8/mqdefault.jpg)
Making a note to start with "my expertise is in..." before diving into the details of my experience. So smart.
Does she have any whyte friends?
I can be her first whyte friend.
@@93gus cringe
As a software engineer, I feel this. We usually go through 4-6 interview stages for each company. Good luck, Julia! You absolutely got this! Both SQL and Python are very powerful languages to have a firm grasp on.
getting interview number 1 is the hardest part! Tech employers with unrealistic expectations of every single job is annoying asf.
good luck everyone. i along with 4 others on my team, (and like 1000s others) are SWEs with like 8+ YOE. we got laid off in like... dec. we're fighting you guys for roles.
Hey Julia~ best of luck on your job search! I already know you’ll land a job you love because you know what you want and it’s inspirational to see how you strive to go for it. You’re much younger than I am, but I think you just inspired me to review my database knowledge and update myself. Please keep the videos coming and I hope the next level interviews go well for you!
Thank you so much Julia for sharing the Job Searching journey with us! I'm also searching for a data analyst role in Berlin. The tips you share are so valuable! Wish us good luck 🧡
These are so helpful, and thank you for providing the links! I'm not in the same niche, but SQL is required more often even if you're a content writer. Every piece of advice you give is really precious. I hope you're getting some well-deserved rest as well 💜
Best of luck! I spent a long time finding work that resonated as well so feeling what you’re feeling. You got this!
the fact that you're making information and methods about your role as a product data scientist accessible is so great! I definitely see you in a leadership role where you teach a course or offer modules on the field of data science/tech in general
Really enjoyed how specific you were in your studying process. I’m a chemical engineer so I don’t do any of this but it was super intriguing to see a different world. Good luck on your job search!
Yay a new video! As much as I enjoy your increased posting frequency, I still pray and hope you land a great job soon haha. Good luck! (And thanks for the awesome job hunting tips!!)
Thank you Julia for posting. Having lived in nyc a while back, I really enjoy these videos.
Love that you provided real, unsponsored resources that you personally use to study SQL and Python!! I'll need to learn some SQL for a new role so this will be so helpful, ty!
i've been enjoying this series, julia! it makes me more hopeful with my current unemployed life and ongoing job search
I mean..how???
the quality of the editing got me speechless..great timing between subjects, change of screens, even blurring people's faces at the coffee shop part...also all the informations you shared with us, with links in the description, this is amazing! Also, you're very fun, loved to know more about your routine! Thank you for this quality content!
Great to give yourself some space for the job search and not feel "rushed". Obviously everyone's situation is different but I was laid off last year. A little further in my career in tech, at the Sr. Director level, but it was quite a shock. It was the first time in 20 years I didn't have a job. I gave myself 3 months off (severance). Gave me time to rethink what was important to me and my family. I started consulting. Interviewed for lots of roles but didn't find anything I really felt was right. So still consulting and working on starting my own business.
It's a journey. Also, learn to love the power of "no". When you say "no" to something (a role that's a bad fit, etc) you are only eliminating 1 possible option. All the other options in the universe are still available to you. When you say "yes" to something you eliminate ALL OTHER options. So make sure the "yes" is something you really feel good about. Good luck!
Great advice. Thankyou
Need more of your knowledge! 😮
Thank you for sharing the resources! As someone who's also going through technical interviews these resources are helping a ton
Great info! How you feel when you’re day is free and your friends are working is how some retired people feel but I’m so looking forward to retirement in a few years. I enjoy your Vlogs and think of me when I was in my 20s in New York if I would’ve stayed but decided to leave for a challenge in Puerto Rico. Your vlogs are for young and slightly older, starting careers and finishing them as well. Praying for you and your future. Your recipes look delicious.
i love your tech-heavy videos! it’s so interesting to see the specifics of what you did in your previous role. good luck on the job hunt! any company would be lucky to have you on their team :)
This is tech-heavy ?
Julia, i'm here to just let u know that you are my favorite youtuber. I am also studying python and sql. I've been watching your videos for quite a period and you inspire me a lot to be in this career path. I am still a beginner and trying to get into the job market so I wish the best for both of us!
Hey Julia! I'm now using Mode to SQL and really like it. Thanks for sharing this and good luck to your job hunting journey!
Such an inspiration! Wish the best for you in your journey since I am in the same position. Best of luck!
This is very helpful, wish you all the best Julia!
Really great video! I'm currently going through a similar experience as a Front End Engineer after being laid off a couple months ago. It's nice to see others dealing with the same things, I don't feel quite as alone in my experience now. Good luck on your interviews!
watching this is so reassuring because I know you'll do great, and that you'll learn so much from these hard times-and so will the rest of us! also, your hair is amazing
I must confess, you had me glued for 13 minutes straight.
You are good at what you do.
Thank you.
Same, and I'm not even in the tech industry. Regardless, the whole process is super interesting to see!
As always, wishing you the best in all your endeavors. I know you'll do just fine. Enjoyed Dr. Slump & currently impatiently waiting for each new episode of Queen of Tears to drop.
I’m glad you are taking some time out for yourself during your job search. Those cheat days are so important. Hope you have a great week!
Thanks for the video Julia❤ good luck on the job hunt!
Juliaaaa love you , literally I like your video before watching ❤🎉
Such good advice- interviewing is a huge time commitment so it’s best to weed out the roles that are not a good fit ❤
Thanks for all the SQL resources! I’ve been using W3 schools for a while but haven’t gotten much out of their practice problems. Good luck with the job hunt!❤ (coming from one tech person to another 😊)
hi julia, thank you for this video. I lost my job a year ago and hav been struggling to land anything since, i'm trying to transition into a career in data analysis despite my old age of 32 as hard as it probably will be. However your videos have helpd me figure out where to start. Hopefully I wlil become someone as inpsiring as yourself in this journey and thank you for helping me stay motivated in this hard time. You'll definitely land that next dream position. Love your content!
Hey Julia! Hope you are doing well. I am a ML Research Engineer myself and have been watching your vlogs for the past couple of years. Your videos are so much peaceful that it becomes an addiction after a point. And the recent videos are so much relatable, specially this one. The perfect blend of tech+lifestyle vlog. So thankful to you for these vlogs! All the best for the next interviews!
I recently just went through a 2.5 month job search journey as a product manager (in nyc and was also full-time searching after taking a gap year!) There were soooo many stages for each of my interviews as well. Best of luck and you got this!!
Thanks for sharing your resources. I've been wanting to improve my tech skills. And the pork recipe I'm super excited for it. Best of luck on landing your next role. I'm sure it will come so enjoy your free time and friendships!
Thank you for sharing your journey with us, your advice is appreciated. You are going to do extremely well!!!!
Looking forward to seeing the next stages of your job search xxx
Love the technical videos! I'm a data analyst and your content always inspires me to improve my skills.
Hi, I am changing my career from Mechanical Engineer to data analyst. Could you tell me what skills should I develop and what certificates need to land the first job? I am following python sql courses right now. Thanks in advance. @nickodell2318
This video was motivating! I also might have some technical interviews soon, so I need to make a study plan and get into things. Great video! :)
this video is a godsend right now! best of luck with your search & thank you for sharing your journey
I am looking for a job as well Julia, and you just posting this video helps me to know we not alone in this process you're the best
focus is def the key! Best of luck Julia
Your videos are just getting better and better Julia!!! I love it!!
Hi Julia! I just wanted to say that your videos inspire me a lot. I've been working as a data analyst for more than 3 years and recently finished a data science bootcamp. After being let go from my previous job, I'm currently looking for a new job as well. I really appreciate your tips and the resources you recommend for practicing SQL and Pandas, as these are indeed the main tools for us. Maybe we can connect one day! I wish you the best of luck 🤘🏼
You are amazing! As I want to become a Data Scientist too, and your videos always motivate me. Thank you.
I work in healthcare and have no idea what’s going on but was glued to the screen anyway!
Super helpful. I enjoyed learning sql and R. My only issue with coding is I feel like I easily forget things lol. Practice is definitely the way. I hope you find the perfect role for you soon!
Love the study process, thanks for sharing ... looking forward to more & G'Luck with new job 💕
Ty gorgeous girl for taking the time. You are so sweet at teaching and getting the feeling across. Don't give up, which I think you won't, otherwise, you will demoralize me on the quest to continue🤗.
As someone who is in a job search for an entry-level data science position, I love the specific resources and tips you are giving out (what to focus on like pandas instead of general leetcode style question) and if you could do a whole video on that it would be even better. Stay healthy!
Hey Julia. Love your videos! Thank you for sharing your job search journey. I’d love to hear more about A/B test resources from you. Thanks! Keep it up.
I am looking to get into data science with a background in IT, this video really helped in terms of resources to get started and a direction to take, so thank you very much for that!
Video idea alert,
I love how you said you know what you want out of the job, what you want to do in the job and skills you want to either use or skills you want to gain. Can you do a video on the skills you have vs what you want to expand on the job, how you know exactly what job you want and want to do on the job and even do a interview scenario of the answers and questions you face on interviews and how you answer them?
I am in marketing and I know its board but I usually apply to social media roles or digital marketing roles ( this role you need more SEO, Paid ads experience which I new at),
but I think my issue is I dont know what I want, what industry I want t work in or what I want to do.. At this point I want a job lol, but I would love some advice or how you figured out what you want in a job and what company/industry you want to work for
okay girl but your hair!!! looks so nice. love the way it looks
I am a very casual SQL user for my job and i am on and off with studying more advanced concepts. I learned a bit of python too and started a personal project, but there's been no progress in a while. Life has gotten super busy and stressful for me recently, but this video has me inspired to get back at it!
Loved this
I made Thit Kho for the first time after seeing it in your video...thank you for sharing this recipe! It was soooo good!
what an awesome video! thank you for all your tips so helpful!
You are amazing! You will get a job and enjoy it. You will look back on this process and grow as an individual.
all the best to keep working hard and study hard too, i know what its like iv been there. hope you land a good job
Keep it up Julia. Been following your journey and thanks for sharing the realistic process with us. Hope to have you on our podcast sometimes
yay love this channel and this series keep up the vids❤ from Thailand
Hy Julia I'm glad to see you again studying data base for new career. I hope, to find a new job where you feel fulfilled and where you can advance step by step. I Wish good LUCK!!!!
actually so much useful info! Appreciate so much
I hope you find what you are looking for. You got this Julia
Thank you so much for the python and sql resources!
your video is an inspiration. Thank you and good luck!!!
Thank you for sharing all those websites! It will sooo useful for me 😄
dr. slump was so good! best k drama i've watched in a while.
Thank you so much for all the valuable information and links
Love the video Julia! Esp the SQL and Python tips, they were really clear and straight to the point! Also I loved the recourses you gave as I didn’t know about them before the video!!
keep it up and excited to see more of your videos / journey through job hunting in tech! 😁😵💫
Random viewer but thanks for the SQL tips. I've been looking for SQL spaces to study so this was really helpful.
I am also in New York and looking for a new job. I am currently employed though. You're right. The interviewing cycle for tech positions is brutal. Moreover, for every company the kind of preparation needed is different. For the last two months I've just been focusing on preparing for Meta, and I still don't feel confident. After this I'll try for other companies like Google, which will have it's own prep.
The HR/Recruiter call ALWAYS goes well though! Haha. They are the best.
Anyway, good luck. I cannot get myself to quit my job and look for a new one. So I mostly spend nights and weekends in preparing.
I've been watching your videos since September 2022 and I think this is likely my most favourite video from you yet. I have been on a break for 2 years and some change - mostly from COVID-induced health complications and then working on my mental health - and you've provided just simply fabulous ways to get started. Quick question: for the kaggle resources, is there a subscription involved or just creating a free account is enough?
Wait putting plants in the sink is such a smart way to bottom water!!! I always put them in a bowl one at a time
Cheat days are more then just ok, they are imported from time to time ❤
Your videos motivate me to study more, thanks 😊
thanks julia for sharing the prep material that you are using for your job hunt. also plz share material using for statistics , ML DL also. all the best
Mode analytics sql tutorial is so amazing
loving this camera
Thank you for this video ❤
your vidéo is so instructive
Your hair looked especially good in this video. Just wanted to say that😂❤🎉
Yeah 🎉 Julia good vlog 😊
ALSO it's funny because I'm also making the braised pork dish today for lunch! I'm making the Cambodian version but both are very similar. I work remote so I just cook on my breaks. :D
most realistic useful videos around
im a student studying Business Analytics and ur tips on studying sql & python is so helpful, tysm :) good luck on ur job search!!! love ur vids
Ive been using a lot of pyspark as well for big datasets, super intuitive and with lazy evaluation
From my experiences i can tell you that to get a good software engineering job , it atleast takes upto 4-6 months as per todays job scenarios but this timeline is not necessary for everyone . Good Luck :)
I love this video ❤ Would like to know what you studied in the college? How to find a job that you actually like?
Just keep going. I know you will find your next gig!
Another great video!
Believe me, Python with SQL has proven to be a powerful combination in my career.
Super interesting! 👏🏻
I just finished Doctor Slump ❤😊
Just found your channel! I've graduated for like 7 months ago with a ton of rejections. I think Imma join you in here until I get a job.
Thanks for your sharing !!! 😁
I appreciate your tips (:
I almost completed a course over Udemy for SQL and started with SQL 50 over LeetCode, currently just started doing 5 questions per day(same pinch).
that is so interesting... in my country (due to demographic change and other reasons), data scientists/analysts etc. (tech people in general) are highly coveted, so I think finding a job would be much easier and less competitive than in NY
SELECT * FROM people WHERE name = 'Julia' AND personality = 'AWESOME' AND response_trigger = TRUE;
All the best!