- 89
- 140 681
Jess Ramos
เข้าร่วมเมื่อ 7 เม.ย. 2023
Beginner SQL Course⚡️ #17: Current Date & Time
Hi BDEs! ⚡️ Hands-on material below ⬇️
🔗 📈Written material & Datasets for this lesson: open.substack.com/pub/jessramosdata/p/current-date-and-time-in-sql-lesson?r=1vpwni&showWelcomeOnShare=true
🔗📫 My newsletter for updates & other lessons: jessramosdata.substack.com/
This is lesson 17 (Current Date & Time) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end.
NOTE: Parentheses after currentdate and other date time functions are required in some dialects but NOT in others. I used them in this video, but they're optional in this environment. So currentdate and currentdate() produce the same result here.
If you like this beginner course, you’ll LOVE the Big SQL Energy intermediate course which will have you job ready and acing your interviews for your dream data analyst job. We will go into more advanced skills by solving real business problems that I’ve solved on the job as a Senior Data Analyst in tech. At the end, I’ll help you build 2 projects that are exact replicas that I’ve solved in the real world, and then I’ll show you how to add them to your data analytics portfolio.
🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy?
🤳🏼 SOCIALS
📫 Newsletter: jessramosdata.substack.com/
📸 Instagram: @JessRamosData
💙 LinkedIn: Jess Ramos, MSBA
🎬 TikTok: @JessRamosData
💌 Brand Partnerships: partnerships@bdeanalytics.com
🔗 📈Written material & Datasets for this lesson: open.substack.com/pub/jessramosdata/p/current-date-and-time-in-sql-lesson?r=1vpwni&showWelcomeOnShare=true
🔗📫 My newsletter for updates & other lessons: jessramosdata.substack.com/
This is lesson 17 (Current Date & Time) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end.
NOTE: Parentheses after currentdate and other date time functions are required in some dialects but NOT in others. I used them in this video, but they're optional in this environment. So currentdate and currentdate() produce the same result here.
If you like this beginner course, you’ll LOVE the Big SQL Energy intermediate course which will have you job ready and acing your interviews for your dream data analyst job. We will go into more advanced skills by solving real business problems that I’ve solved on the job as a Senior Data Analyst in tech. At the end, I’ll help you build 2 projects that are exact replicas that I’ve solved in the real world, and then I’ll show you how to add them to your data analytics portfolio.
🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy?
🤳🏼 SOCIALS
📫 Newsletter: jessramosdata.substack.com/
📸 Instagram: @JessRamosData
💙 LinkedIn: Jess Ramos, MSBA
🎬 TikTok: @JessRamosData
💌 Brand Partnerships: partnerships@bdeanalytics.com
มุมมอง: 103
วีดีโอ
Beginner SQL Course⚡️ #16: Count(*) vs. Count(column)
มุมมอง 1302 ชั่วโมงที่ผ่านมา
Hi BDEs! ⚡️ Hands-on material below ⬇️ 🔗 📈Written material & Datasets for this lesson: open.substack.com/pub/jessramosdata/p/count-vs-countcolumn-in-sql-lesson?r=1vpwni&showWelcomeOnShare=true 🔗📫 My newsletter for updates & other lessons: jessramosdata.substack.com/ This is lesson 16 (Count(*) vs. Count(column)) of the Big SQL Energy Beginner course. This course will take us through all the SQL...
Beginner SQL Course⚡️(#15: Aggregate Functions)
มุมมอง 1707 ชั่วโมงที่ผ่านมา
Hi BDEs! ⚡️Written material & datasets below. This is lesson 15 (Aggregate Functions) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end. 🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy? 🔗 Written material & Datasets for this lesson: open.substack.com/pub/jessramosdata/p/aggregat...
Beginner SQL Course⚡️(#14: Like vs. ilike & Wildcard Variations)
มุมมอง 1479 ชั่วโมงที่ผ่านมา
Hi BDEs! ⚡️Written material & datasets below. This is lesson 14 (Like vs. ilike & Wildcard Variations) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end. 🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy? 🔗 Written material & Datasets for this lesson: open.substack.com/pub/jessram...
Beginner SQL Course⚡️(#13: Wildcards)
มุมมอง 20312 ชั่วโมงที่ผ่านมา
Hi BDEs! ⚡️Written material & datasets below. This is lesson 13 (Wildcards) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end. 🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy? 🔗 Written material & Datasets for this lesson: open.substack.com/pub/jessramosdata/p/wildcards-in-sql-l...
Beginner SQL Course⚡️(#12: Is Null, If Null, & Is Not Null)
มุมมอง 20214 ชั่วโมงที่ผ่านมา
Hi BDEs! ⚡️Written material & datasets below. This is lesson 12 (Is Null, If Null, & Is Not Null) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end. 🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy? 🔗 Written material & Datasets for this lesson: open.substack.com/pub/jessramosdat...
Beginner SQL Course⚡️(#11: In & Not In)
มุมมอง 14316 ชั่วโมงที่ผ่านมา
Hi BDEs! ⚡️Written material & datasets below. This is lesson 11 (In & Not In) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end. 🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy? 🔗 Written material & Datasets for this lesson:open.substack.com/pub/jessramosdata/p/in-and-not-in-in-...
Beginner SQL Course⚡️(#10: Between & Not Between)
มุมมอง 13719 ชั่วโมงที่ผ่านมา
Hi BDEs! ⚡️Written material & datasets below. This is lesson 10 (Between & Not Between) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end. 🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy? 🔗 Written material & Datasets for this lesson: open.substack.com/pub/jessramosdata/p/betwee...
Beginner SQL Course⚡️(#9: Boolean Logical Operators)
มุมมอง 18221 ชั่วโมงที่ผ่านมา
Hi BDEs! ⚡️Written material & datasets below. This is lesson 9 (Boolean Logical Operators) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end. 🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy? 🔗 Written material & Datasets for this lesson: open.substack.com/pub/jessramosdata/p/boo...
Beginner SQL Course⚡️(#8: Filtering w/ WHERE)
มุมมอง 190วันที่ผ่านมา
Hi BDEs! ⚡️Written material & datasets below. This is lesson 8 (Filtering w/ WHERE) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end. 🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy? 🔗 Written material & Datasets for this lesson: open.substack.com/pub/jessramosdata/p/filtering-...
Beginner SQL Course⚡️(#7: Arithmetic Operators)
มุมมอง 215วันที่ผ่านมา
Hi BDEs! ⚡️Written material & datasets below. This is lesson 7 (Arithmetic Operators) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end. 🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy? 🔗 Written material & Datasets for this lesson:open.substack.com/pub/jessramosdata/p/arithmeti...
Beginner SQL Course⚡️(#6: String Manipulation)
มุมมอง 296วันที่ผ่านมา
Hi BDEs! ⚡️Written material & datasets below. This is lesson 6 (String Manipulation) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end. 🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy? 🔗 Written material & Datasets for this lesson: open.substack.com/pub/jessramosdata/p/string-ma...
Beginner SQL Course⚡️(#5: Data Types & Cast)
มุมมอง 353วันที่ผ่านมา
Hi BDEs! ⚡️Written material & datasets below. This is lesson 5 (Data Types & Cast) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end. 🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy? 🔗 Written material & Datasets for this lesson: open.substack.com/pub/jessramosdata/p/free-big-sq...
Beginner SQL Course⚡️(#4: Limit & Top)
มุมมอง 30714 วันที่ผ่านมา
Hi BDEs! ⚡️Written material & datasets below. This is lesson 4 (Limit & Top) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end. 🔗 Intermediate Course: bigdataenergycourses.com/p/bigsqlenergy? 🔗 Written material & Datasets for this lesson: open.substack.com/pub/jessramosdata/p/free-big-sql-ener...
Beginner SQL Course⚡️(#3: Primary vs. Foreign Keys & Distinct)
มุมมอง 46014 วันที่ผ่านมา
Hi BDEs! ⚡️Written material & datasets below. This is lesson 3 (Primary vs. Foreign Keys & Distinct) of the Big SQL Energy Beginner course. This course will take us through all the SQL basics from the very beginning all the way to basic joins at the end. If you like this beginner course, you’ll LOVE the Big SQL Energy intermediate course which will have you job ready and acing your interviews f...
Beginner SQL Course⚡️(#1: select, from, and *)
มุมมอง 94314 วันที่ผ่านมา
Beginner SQL Course⚡️(#1: select, from, and *)
GRWM: Data Analyst vs. Data Scientist- what’s the difference??
มุมมอง 1658 หลายเดือนก่อน
GRWM: Data Analyst vs. Data Scientist- what’s the difference??
10 things that should send data scientists and data analysts straight to jail!!
มุมมอง 1559 หลายเดือนก่อน
10 things that should send data scientists and data analysts straight to jail!!
Another fantastic video 🎉
@@aditya3david woohoo more to come too 🎉
Why my dataframe section in hex is not like yours? I mean I have customers_3, dataframe, dessert_order_counts, filter_ result, orders, orders_2, orders_3, orders_4, orders_5. My dataframe section is not consist of just two tables like you have and I dont know how to change it? Any idea what am I doing wrong ?
@@mehmetakaln5340 you could delete everything from the space and re upload the original files. Or you could open a new notebook, reupload, and start fresh. Or if you customers table is now named as a data frame customers_3, you should be able to query from customers_3 as the table name! Looks like you just have different names and versions uploaded so the names might look a tad different than mine
select count(Beginner SQL Course) from Jess Ramos # count(Beginner SQL Course) 17 DONE!
NICEEEE Let'ssss goooo :) don't forget to grab my newsletter link too for the written material
Mam thank you for all the support. Pls do videos on interview questions
More videos coming later once I finish my daily SQL Course January series 😍
These are really good. I am coding in SQL after 15 years (I am a director but still like to get my hands dirty) and I am a bit rusty and these are just perfect length
LOVE THAT! Directors welcome 🤗 Nice to see you putting time into hands-on coding since it'll help you understand what your direct reports are doing! I have an intermediate course all hands-on in a modern tech stack if you want additional (FUN!) training for your team 😍
Really great to see keep it up
Thanks so much! Glad you're enjoying :)
Thank you for this Jess, great content to the point!!
SO HAPPY to hear that! Trying to not ramble ✨too much✨ when I get excited about data
Hex is a game changer, Thank you Jess!
Yes Hex is amazing and I love them!
ilike it
WOOOOO
Awesome. Thanks again. Looking forward to see how we can use Order by using Max/Min, and advance concepts!
@@pandabear087 woohoo 🎉 keep on moving through the lessons, so much to come 😍 thx for the support
Doing great keep going on ❤
THANK YOUUUUU :)
Done !
NICE this was a good one 🤩
Thank you Jess for the oportunity to learn SQL! Ready to Boom!!😎
@@AIMEEDOMINGUEZNIETO of course!! Makes me so happy to see so many people taking my freebie 🥹 putting in so much work into it
So excited. Thank you for this. Been patiently waiting.
@@pandabear087 yay so happy to see you on the intro vid!! You can now binge all the ones already posted 😂 show my videos some love and share with others too ♥️
Consistent and dedication! Let’s goo!
I have no choice but to be consistent when people are messaging me to lmk I'm late posting the daily lesson 🤣
❤❤
WOOO 14 days out of 31! Almost halfway through the course!
You didn't cover the '_' wildcard. Please include that also. And for the next course, it would be better if you specify syntax for both MySQL and PostgreSQL, because sometimes their functions differ.
How about you watch today's lesson and read my newsletter? Also the dialects are all the same and no one teaches all of them for good reason. Learn one and learn it well.
Thanks for the energy loving it😊
WOOOOO of course!! What has been your fave lesson so far?? ❤
@JessRamosData boolean and filtering. I loved the series really awesome. Simple and to the point 😁
@@aditya3david wooohoo love to hear that!
jess how do i get a business analyst role? im struggling
It's really competitive right now, so be easy on yourself. Work on mastering all the skills for your target role (BA is a lot of data viz, excel, and maybe SQL) and build a portfolio of work. Network a TON! First job is the hardest to get!
@@JessRamosData how do i build a portfolio?
@@nadiablossom3 I go into detail on this in my intermediate course but essentially you want to highlight your projects and communicate them in a way where hiring managers can clearly see your skills!
@@JessRamosData ok thank you!
@ of course 😍
Done!
WOOO LOVE THESE UPDATES! See you in the next few videos 😉
Thanks for sharing. 🎉
Of course thanks for following along ❤🎉
nicely explained. loving it and waiting for next lesson
WOOOO next one coming soon ;)
I'm procrastinating very much. Need to start from video 1 tommorow.
START TOMORROW and report back!! :)
Good night 😴
❤❤
@@code_to_insights ♥️♥️♥️
Loving the consistency and dedication! And this is the free version for all to learn from. Real business use cases and real world projects await those willing to take advantage and join the intermediate course!
@@JT-lo9nv yessss it’s no joke putting out 31 videos and newsletters in a row 🥲 appreciate the support!
You are so cool,really wanted to learn from someone like you.
thank you :) my goal was to make SQL as fun and cool as possible. There are already too many dry boring data videos on TH-cam 🤣
Dropping 2 videos in a day?! For those who are just starting out in SQL, these are gems! Keep learning and after you finish these beginner lessons, I HIGHLY recommend the intermediate course!
LOL I posted today's video early... shhh 🤫 and yay happy to see you in the intermediate course :)
Maybe I'm doing something wrong with the file but all I get is "None" when implemented
weird, did you download the CSV successfully? Where are you uploading?
Using :: to cast is what I learnt from today’s lesson.
@@pricillanakyazze7067 woohoo 🥳 the shorthand notation is awesome 😎
Thanks boo!
Wonderful, thank you! This seems more manageable. SQL is pretty much magic.
YESSSS it really is ❤
7:00 and what I’ve seen potential employers here in Europe want Jess, is the following: SQL Server, PostgreSQL, BigQuery, Oracle, MySQL, Snowflake, One or more of the following above ⬆️
From tomorrow I will start you sql course thanks thanks lots of love from India ❤️❤️
YES DOOO ITTT and comment back what you think!! ❤
Perfect explaination as usual! Have watched every video 💯 I am an MSc CS student seeking for an internship Can i get your email so that i can connect with you? As i believe on linkedin and instagram you would be getting a lot of messages. Thanks
@@shreyasnaphad3284 aw thank you 😊 so glad you’ve been keeping up! My LinkedIn connections are full but I’ll look out for an insta DM if you tell me your username!
@JessRamosData I have sent you a dm My user name is shreyas_naphad
Jess whenever you’re ready we also need a python course.
omg give me a minute to finish this series first 😂 jk appreciate the love and support ❤
awesome well explained
THANKS SO MUCH 🎉
Let's go - I did a bootcamp in 2023 but you're explaining this much more clearly and I am gaining so much knowledge. Thanks! I am going to go for my first job in 2025 and I am committed!
AW YAY! I designed my intermediate course (link in notes) for that exact purpose. Many people have basic skills or took an okay course or bootcamp but didn't get to a high enough level and most importantly didn't apply those skills to business. And then they end up struggling to get a job. I made this and my intermediate to bridge those gaps and help people confidently prep for interviews based on my actual industry experience 🎉
I need to give Jess Ramos some of this D.
@@jay_wright_thats_right you better mean D as in DISTINCT
Thank you Jess. I am your number one lifetime supporter.
@@code_to_insights aw I appreciate that so much 🥹♥️ thx for supporting me over here on TH-cam !!
The energy is high 🔥 Lets go!
@@shreyasnaphad3284 of courseeeee big data energy only 😉
Thanks Jess! Loving these lessons. I also signed up for your intermediate course!
@@JT-lo9nv aw yay I saw your signup come through ⚡️🎉 I celebrate every time I get an email. See you in the discord and can’t wait to hear what you think 😉
Reposting because my previous comment seems to have disappeared (likely user error on my end). Love the video and what it offers to those learning SQL. Few people offer high quality content for free. However, I disagree on the use of ordinals in the order by clause. Ad hoc analyses and for exploratory purposes? Sure. Production queries? I’d advise not.
That's totally valid! I find using numbers reduces clutters and makes it easier to follow (as long as things as labeled well and kept in an appropriate order in the select statement), but I def see an argument for using the column names!! Regardless ordering by a lot of columns in prod is bad either way lol
Amazing stuff Have been following since your first video Quick and easy explanation
Aw yay hi so happy to have you here watching! SO much more to come 😍
Totally loving the energy & the tips at the end of each video 👍 Looking forward the upcoming video..Great work!!
Aw yay happy to hear they’ve been helpful 🎉
Here we go!
HERE WEEEE GOOOO!!!! 31 days in a rowwww 🤪
How do you do it? 7 minutes per video. And your explanations are spot on! Keep it coming!
Aw you’re the best 😂 I try to squeeze in a lot real quick so hope these bite sized vids are useful for people!
@@JessRamosData Thank you. I believe they are. There are tons of long winded SQL tutorials on YT, so this series will likely stand out for its concise content. I am a data analyst and dpo, but I appreciate how other analysts and content creators view and use SQL and Python.
@@Kamadrion yesss there's too many long boring videos on here already so hoping to be a fresh breath of air!
Let's go😊
Woohoo 🎉
Well explained 🎉
Aw thank you! So many more to come ❤
@@JessRamosData i'm eagerly waiting
@@JitendraSingh-q9y4f woohoo 🎉
Amazing content! Already excited with this series 💯
thanks so much! Can't wait to hear what you think :)