Jess Ramos

Пікірлер

@saxonleefowler 6 сағат бұрын

I think it’s coding language - I haven’t heard anyone say it isn’t

@BruceParker98 11 сағат бұрын

Well finally a woman with a useful degree.

@voicification Күн бұрын

Ignore the haters. Most don’t do anything with their lives. You go! I love your videos and they have helped me immensely at work! You’ve got a lot of fans! 🎉🎉

@JessRamosData 22 сағат бұрын

@@voicification aw thank you so glad to hear that ♥️🎉

@nilaygokdemir4553 Күн бұрын

i think i am a slay queen!! 💅💅 I watched all the videos and practiced with you 💅 thank you Jess!! Even though I only finished the beginner series, I feel like I can solve any problem in SQL. But I wonder why we need SQL when everything we can do in Excel is sometimes easier than writing code? I can use Excel at a good level, so I couldn't help but think about this in every step and every formula while learning SQL?

@JessRamosData Күн бұрын

This is def a great overview but I promise there are WAY more complicated business problems that require a deeper knowledge of SQL so def learn intermediate level!! Excel is great for quick fixes and local files, but using SQL allows us to clean and wrangle LARGER amounts of data straight from the database. Excel can't handle that much data and it's harder to use replicable processes there.

@nilaygokdemir4553 Күн бұрын

sum(case when product_name='Laptop' then 1 else 0 end)::int as laptop_binary, sum(case when product_name='Monitor' then 1 else 0 end)::int as monitor_binary, sum(case when product_name='Mouse' then 1 else 0 end)::int as mouse_binary, sum(case when product_name='Webcam' then 1 else 0 end)::int as webcam_binary, sum(case when product_name='Keyboard' then 1 else 0 end)::int as keyboard_binary,

@JessRamosData Күн бұрын

woooooo nice binary columns 😉

@chaitanya_kulkarni Күн бұрын

Sorry to hear it 😔. You go girl you are creating a great content on Data. 👍

@JessRamosData Күн бұрын

thank you!! Love my loyal followers who are nice lol

@giantzay2041 Күн бұрын

I ran the query first and thought why is product_type not coming up - I knew what to do to check but was lazy. Then I saw you fix it after I unpaused the video lololol

@Gab_O_uwu 2 күн бұрын

Guys shes just doing a trend and her life looks amazing let her be happy ❤❤

@Ryan770 2 күн бұрын

SQL is turing complete, and has been since 1999. Therefore, it is a coding language.

@JessRamosData Күн бұрын

we got the factsssss LOLOL

@Lifewithilenia 2 күн бұрын

Omg these people are crazy!!! I think you are skinny to my eyes. You are the perfect weight to be tbh

@JessRamosData Күн бұрын

yeah people are mean for no reason when they see a confident and successful woman

@fuzzym30 2 күн бұрын

WITH CTE (Col1) AS ( SELECT 1 AS Col1 UNION ALL SELECT Col1 + 1 FROM CTE WHERE Col1 < 100 ) SELECT CASE WHEN Col1%15 = 0 THEN 'Fizz-Buzz' WHEN Col1%3 = 0 THEN 'Fizz' WHEN COl1%5 = 0 THEN 'Buzz' ELSE CONVERT(VARCHAR(3), Col1) END as result FROM CTE -- Yes SQL is a coding language.

@JessRamosData Күн бұрын

LOL a perfect answer. Love this

@Sunshine-wn4eg 4 күн бұрын

Hi @Jess Ramos I did the cast as int and I still have a decimal. for example 33.0. How do I fix it?

@JessRamosData Күн бұрын

hm... int should get rid of the decimal place! If not you can try round or floor. This is the pain of data cleaning 🧽

@bshroats5 4 күн бұрын

Trailing commas FTW. Leading commas is a sign of a serial killer

@JessRamosData 4 күн бұрын

@@bshroats5 ACCURATE 😂 no lies detected

@JimmyBrock 5 күн бұрын

Don't many-to-many tables usually have a middle table to make joins easier?

@JessRamosData 4 күн бұрын

@@JimmyBrock yes that’s one way to set it up

@peepaxo 5 күн бұрын

I’m so excited to get more into my studies this semester! I swapped to comp sci two years ago and I’m loving it :D Very inspiring girly <3

@JessRamosData 5 күн бұрын

@@peepaxo yesssss welcome to the coding girlies 💕💅🏼 💰 so exciting!!!

@peepaxo 5 күн бұрын

@@JessRamosData ty!! its so much fun :D

@xyz-nt1ku 7 күн бұрын

Will it not come on your KZbin channel?

@JessRamosData 7 күн бұрын

My intermediate course will not be on KZbin! I host it separately because it provides immense value and has exclusive resources I can't put out publicly!

@kxwjy 7 күн бұрын

also, can someone help me with this one? why the return have decimals when i cast as integer? in the video it return as 33 but i get 33.0

@Sunshine-wn4eg 4 күн бұрын

I got the same thing

@kxwjy 7 күн бұрын

in line 16 when casting coupon as decimals it return 159.15200000000002 how do i make it shorter?

@KatherineVoakes 8 күн бұрын

creating data dictionaries and documentation would honestly be my dream task. 😂

@JessRamosData 7 күн бұрын

you may have a future career in data governance! 😂

@KatherineVoakes 6 күн бұрын

@@JessRamosData There are so many options for data roles it's hard to choose one!

@JessRamosData 5 күн бұрын

@ it really is!! No wrong answer. Choose what you’re interested in and maybe what you have past domain experience in

@blacktalon1607 8 күн бұрын

(20 years from now) Where have all the good men gone? (Sobs into pile of cats) All jokes aside though, if shes as smart as she claims, I hope she breeds. We need more smart people on this planet. Driving to work feels like pulling teeth nowadays lmao.

@420sippin 8 күн бұрын

Single cat lady from here on out and shes still going to blame us men for her cocky/💩 attitude and being that way 😂😂😂😂 good thing you make money u not hot

@brandonabbott6261 8 күн бұрын

So we get to listen to you womansplain your fancy life huh 😂 Strong woman don’t need no man

@timothymichlik1818 8 күн бұрын

She is like that chick In the IQ test, Bragging and bashing other people, and then she scored lowest. They are probably sisters!