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

Рет қаралды 272,825

Ай бұрын

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

Пікірлер: 281

@jdp486 Ай бұрын

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

@93gus Ай бұрын

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

@Nop3.1 Ай бұрын

@@93gus cringe

@its_jei Ай бұрын

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 Ай бұрын

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!

@adammich01 Ай бұрын

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 14 күн бұрын

Need more of your knowledge! 😮

@LovelyArcticBirds-dq1sj Ай бұрын

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

@Snowyness Ай бұрын

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

@aliynarouise Ай бұрын

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 Ай бұрын

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 💜

@fang-wenhsiao2696 Ай бұрын

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 🧡

@aneoden7551 26 күн бұрын

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!

@spacedog6229 Ай бұрын

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!

@cherie4665 Ай бұрын

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

@kimitursi762 Ай бұрын

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!

@gastronomee_ Ай бұрын

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

@sharissebullock Ай бұрын

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 ?

@abbytpco Ай бұрын

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

@amartyabhattacharya Ай бұрын

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!

@gabemcmillan Ай бұрын

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

@esperanzagonzalezcoons Ай бұрын

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.

@raspada306 Ай бұрын

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!

@kungkungx3 Ай бұрын

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!

@ericliujt Ай бұрын

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

@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 Ай бұрын

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!

@TheMisschrisaz Ай бұрын

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!

@benjaminsaucedo3569 Ай бұрын

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

@allthehui Ай бұрын

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

@jessicahuang6310 16 күн бұрын

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

@user-we8dn5ub9z Ай бұрын

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

@rmoorefla Ай бұрын

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.

@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 Ай бұрын

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

@RiseAboveRoots987 Ай бұрын

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

@josedosreis6630 Ай бұрын

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

@sagea2042 Ай бұрын

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

@wangzhao8398 Ай бұрын

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

@vio_tio12 Ай бұрын

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!

@animancy9824 Ай бұрын

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

@chi2om Ай бұрын

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!

@reelabdalla1289 Ай бұрын

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

@maielavegavlog Ай бұрын

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

@thej00se Ай бұрын

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!

@Sunflower94H Ай бұрын

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

@sunshinemindset8497 Ай бұрын

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

@KuroUmbreon Ай бұрын

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

@b_c_. Ай бұрын

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

@rodeketan Ай бұрын

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.

@chloeshih Ай бұрын

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

@sunainajain05 Ай бұрын

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

@gellirollz Ай бұрын

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

@mahirislam1930 17 күн бұрын

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!

@saldiamond 28 күн бұрын

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!

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

@martymas502 Ай бұрын

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

@moon.benjee Ай бұрын

focus is def the key! Best of luck Julia

@AbigailMCruz_ Ай бұрын

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

@rachelmorgan6291 Ай бұрын

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

@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

@JcOnAFieldtrip Ай бұрын

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

@annetteyang Ай бұрын

Loved this

@balintlaszlo1999 Ай бұрын

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

@nadia6579 Ай бұрын

Thank you so much for the python and sql resources!

@tommyls4357 Ай бұрын

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.

@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

@gilt0301 Ай бұрын

actually so much useful info! Appreciate so much

@ko_grindz Ай бұрын

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

@pinkhope84 Ай бұрын

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

@SiraSam Ай бұрын

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

@TimothyJoo Ай бұрын

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

@SHIBIYAYA Ай бұрын

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

@justlistenduh Ай бұрын

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

@freebabe4real Ай бұрын

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

@NhatVo-hg6qs 14 күн бұрын

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

@Ghost-sz7uo Ай бұрын

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

@aninditab57 Ай бұрын

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?

@moabbas5525 Ай бұрын

Thank you so much for all the valuable information and links

@pranavtyagi1401 Ай бұрын

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

@emilyb7752 Ай бұрын

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

@selbimammetgulyyeva2349 Ай бұрын

Your videos motivate me to study more, thanks 😊

@mainwork5118 Ай бұрын

Thank you for this video ❤

@its_jei Ай бұрын

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

@Rebellionrider Ай бұрын

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

@Aripoma Ай бұрын

Mode analytics sql tutorial is so amazing

@rebeccahelga32 Ай бұрын

Your hair looked especially good in this video. Just wanted to say that😂❤🎉

@apurvsaha4648 Ай бұрын

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

@lenali3149 Ай бұрын

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

@kaltoumrachdi2086 14 күн бұрын

your vidéo is so instructive

@SyriusOLsh Ай бұрын

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 KZfaq 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 KZfaqr, and a small question (hopefully): how do you do the top-down angle video when you're cooking?

@tajauberseri-ph3du 26 күн бұрын

loving this camera

@santielewaut Ай бұрын

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

@iceishhk. Ай бұрын

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.

@smkeong Ай бұрын

Yeah 🎉 Julia good vlog 😊

@Kreytonchild Ай бұрын

oh man, yeah. I got laid off last month. But yes, currently re-studying Python and SQL again (graduated from software developement last year in August, but haven't quite done much after). Will check out your videos soon.

@mxderntimes Ай бұрын

Best of luck on your search Julia! How are you enjoying Doctor Slump? I just finished it today :D

@programmingtechnical6132 Ай бұрын

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

@mix_348 Ай бұрын

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!

@OGSweetMeat Ай бұрын

Another great video!

@sasss7060 Ай бұрын

most realistic useful videos around

@TheLeaveTaking Ай бұрын

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