Job Searching Ep. 2 | studying sql & python (w/ tips!), trying to enjoy unemployment life

Подписаться 167 тыс.

Просмотров 291 тыс.

50% 1

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

Опубликовано:

23 мар 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 277

@jdp486 2 месяца назад

Making a note to start with "my expertise is in..." before diving into the details of my experience. So smart.

@93gus 2 месяца назад

Does she have any whyte friends? I can be her first whyte friend.

@Nop3.1 Месяц назад

@@93gus cringe

@its_jei 2 месяца назад

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.

@Nop3.1 Месяц назад

getting interview number 1 is the hardest part! Tech employers with unrealistic expectations of every single job is annoying asf.

@user-tz9jh6pv2j Месяц назад

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.

@dearkathlyn 2 месяца назад

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!

@fang-wenhsiao2696 2 месяца назад

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 🧡

@aliynarouise 2 месяца назад

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

@thatstrueblue 2 месяца назад

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 💜

@LovelyArcticBirds-dq1sj 2 месяца назад

I must confess, you had me glued for 13 minutes straight. You are good at what you do. Thank you.

@Snowyness 2 месяца назад

Same, and I'm not even in the tech industry. Regardless, the whole process is super interesting to see!

@spacedog6229 2 месяца назад

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!

@gastronomee_ 2 месяца назад

Best of luck! I spent a long time finding work that resonated as well so feeling what you’re feeling. You got this!

@kimitursi762 2 месяца назад

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!

@sharissebullock 2 месяца назад

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 :)

@dawidbujak Месяц назад

This is tech-heavy ?

@cherie4665 2 месяца назад

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!!)

@aneoden7551 Месяц назад

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!

@gabemcmillan 2 месяца назад

Thank you Julia for posting. Having lived in nyc a while back, I really enjoy these videos.

@abbytpco Месяц назад

i've been enjoying this series, julia! it makes me more hopeful with my current unemployed life and ongoing job search

@amartyabhattacharya 2 месяца назад

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!

@TheMisschrisaz 2 месяца назад

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!

@ericliujt 2 месяца назад

Thank you for sharing the resources! As someone who's also going through technical interviews these resources are helping a ton

@adammich01 2 месяца назад

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!

@prernatripathy8406 Месяц назад

Great advice. Thankyou

@TheSdk19 Месяц назад

Need more of your knowledge! 😮

@kungkungx3 2 месяца назад

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!

@esperanzagonzalezcoons 2 месяца назад

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.

@eimon928 Месяц назад

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!

@hanaasagiii 2 месяца назад

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!

@user-we8dn5ub9z 2 месяца назад

I work in healthcare and have no idea what’s going on but was glued to the screen anyway!

@raspada306 2 месяца назад

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!

@reelabdalla1289 2 месяца назад

Juliaaaa love you , literally I like your video before watching ❤🎉

@rmoorefla 2 месяца назад

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.

@wangzhao8398 2 месяца назад

This is very helpful, wish you all the best Julia!

@kvcha5725 Месяц назад

Such good advice- interviewing is a huge time commitment so it’s best to weed out the roles that are not a good fit ❤

@nickodell2318 2 месяца назад

Love the technical videos! I'm a data analyst and your content always inspires me to improve my skills.

@RiseAboveRoots987 2 месяца назад

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

@vio_tio12 2 месяца назад

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!

@bench.convos Месяц назад

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

@sagea2042 2 месяца назад

Such an inspiration! Wish the best for you in your journey since I am in the same position. Best of luck!

@animancy9824 2 месяца назад

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

@benjaminsaucedo3569 2 месяца назад

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 😊)

@chloeshih 2 месяца назад

Your videos are just getting better and better Julia!!! I love it!!

@allthehui 2 месяца назад

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!!

@maielavegavlog 2 месяца назад

Thanks for the video Julia❤ good luck on the job hunt!

@josedosreis6630 2 месяца назад

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 🤘🏼

@Sunflower94H 2 месяца назад

Thank you for sharing your journey with us, your advice is appreciated. You are going to do extremely well!!!!

@rodeketan 2 месяца назад

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.

@thej00se 2 месяца назад

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!

@moon.benjee 2 месяца назад

focus is def the key! Best of luck Julia

@sunainajain05 2 месяца назад

You are amazing! As I want to become a Data Scientist too, and your videos always motivate me. Thank you.

@mahirislam1930 Месяц назад

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!

@KuroUmbreon 2 месяца назад

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! :)

@saldiamond Месяц назад

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!

@user-yn6ii7ys3u 6 дней назад

Really liked the video. Thought it would be like those day in life, but actually contains some good technical tips.

@sunshinemindset8497 2 месяца назад

Looking forward to seeing the next stages of your job search xxx

@chi2om 2 месяца назад

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!

@b_c_. 2 месяца назад

Love the study process, thanks for sharing ... looking forward to more & G'Luck with new job 💕

@yosef5508 Месяц назад

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🤗.

@AbigailMCruz_ 2 месяца назад

okay girl but your hair!!! looks so nice. love the way it looks

@JcOnAFieldtrip 2 месяца назад

what an awesome video! thank you for all your tips so helpful!

@gellirollz 2 месяца назад

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

@freebabe4real 2 месяца назад

this video is a godsend right now! best of luck with your search & thank you for sharing your journey

@balintlaszlo1999 2 месяца назад

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!!!!

@TimothyJoo 2 месяца назад

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! 😁😵‍💫

@nadia6579 2 месяца назад

Thank you so much for the python and sql resources!

@martymas502 2 месяца назад

I made Thit Kho for the first time after seeing it in your video...thank you for sharing this recipe! It was soooo good!

@aninditab57 2 месяца назад

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?

@rachelmorgan6291 2 месяца назад

You are amazing! You will get a job and enjoy it. You will look back on this process and grow as an individual.

@gilt0301 2 месяца назад

actually so much useful info! Appreciate so much

@ko_grindz 2 месяца назад

I hope you find what you are looking for. You got this Julia

@srali7609 Месяц назад

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

@pinkhope84 2 месяца назад

Cheat days are more then just ok, they are imported from time to time ❤

@annetteyang 2 месяца назад

Loved this

@SiraSam 2 месяца назад

yay love this channel and this series keep up the vids❤ from Thailand

@NhatVo-hg6qs Месяц назад

your video is an inspiration. Thank you and good luck!!!

@emilyb7752 2 месяца назад

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

@charleshart5563 13 дней назад

Good job! Make sure you look into API's with python. Keep up the good work. Sometimes you find a passion in learning new things.

@stellaxamy Месяц назад

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

@Ghost-sz7uo 2 месяца назад

dr. slump was so good! best k drama i've watched in a while.

@SHIBIYAYA Месяц назад

Thank you for sharing all those websites! It will sooo useful for me 😄

@tommyls4357 2 месяца назад

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.

@moabbas5525 Месяц назад

Thank you so much for all the valuable information and links

@pranavtyagi1401 2 месяца назад

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

@SyriusOLsh 2 месяца назад

Hi Julia! I came across and started watching your videos because I plan to take a gap year - and prayerfully I get a profitable business and a up and running RU-vid channel by the end of it. I really enjoy your sharings and your house tour video is so inspirational because I am very messy with my room. I've also been "studying" your videos as I want to be a RU-vidr, and a small question (hopefully): how do you do the top-down angle video when you're cooking?

@mix_348 2 месяца назад

Hi Julia, another lovely vlog :) I have a question... I'm trying to pivot more into a business analyst role from a sales development role and I'm trying to create a portfolio of work which could showcase my data analytics skills. My current job does require us to analyse some numbers however we solely rely on internal systems so I'm trying to develop my skills using different platforms and languages out there rn. Does any one have advice on how one could create such a portfolio - i.e: in addition to the resources mentioned by Julia in this vid, are there good free resources out there that provide data that we could use to build such portfolio of work? or any advice in general when it comes to pivoting to such roles/building and showcasing technical skills would be much appreciated!

@mainwork5118 2 месяца назад

Thank you for this video ❤

@justlistenduh Месяц назад

Random viewer but thanks for the SQL tips. I've been looking for SQL spaces to study so this was really helpful.

@selbimammetgulyyeva2349 Месяц назад

Your videos motivate me to study more, thanks 😊

@staciii 2 месяца назад

I am always confused about "permanent jewelry" What if you're in a situation where you need to remove all jewelry. What do you do?

@Rebellionrider Месяц назад

Believe me, Python with SQL has proven to be a powerful combination in my career.

@lenali3149 2 месяца назад

I love this video ❤ Would like to know what you studied in the college? How to find a job that you actually like?

@kaltoumrachdi2086 Месяц назад

your vidéo is so instructive

@pigglyjiggity2407 2 месяца назад

hey julia! was the italian food at 4:54 goood?

@lmhuyen1909 Месяц назад

Thanks for your sharing !!! 😁

@apurvsaha4648 2 месяца назад

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 :)

@santielewaut 2 месяца назад

Ive been using a lot of pyspark as well for big datasets, super intuitive and with lazy evaluation

@its_jei 2 месяца назад

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

@tragicallycanadian8317 2 месяца назад

Is that how to not over water plants? To do it in the sink...does it work for all plants?

@MrgLoRybLue 2 месяца назад

Hey, insightful video. Would you mind sharing where you got that ice box from @5:01 ?

@MysseMatch 2 месяца назад

Awhile ago you celebrated one of your friends making a course about breaking into tech. As someone with years of experience, would you consider doing something similar but using your own unique skillset and experiences?