Загрузка видео...

Не удалось загрузить видео

На главную

if you have a SQL test coming up for a data analyst interview and you are panicking right, here’s what you need to know LEFT JOIN combines two tables but keeps everything from your main table even when the other table does not have a match. this is on...

codingfortherestofus's profile picture

brooke | learn coding + ai

35,400 subscribers

276,500 просмотров • 8 месяцев назад •via TikTok

ОбразованиеНаука и технологии#dataanalysis#sql#dataanalytic#dataanalyst#careeradvice
LIVE

Anya Rossi• Live Now

Private livecam show

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

Нет доступных комментариев

Здесь появятся комментарии из оригинального поста

Похожие видео

This 5 website will help you learn SQL 1. SQLBolt * Best for absolute beginners. * Interactive lessons with hands-on exercises after every topic. * Learn SELECT, WHERE, JOIN, GROUP BY, and more. 2. Mode * Designed specifically for aspiring data analysts. * Uses real business datasets. * Covers beginner to intermediate SQL. 3. DataCamp * Excellent structured SQL courses. * Practice directly in your browser. * Covers PostgreSQL and SQL for data analysis. 4. StrataScratch * Best for real-world SQL interview questions. * Questions from companies like Google, Amazon, Meta, and Microsoft. * Great once you know the basics. 5. HackerRank * Beginner-friendly SQL challenges. * Covers Basic, Intermediate, and Advanced SQL. #sql #coding #codinglife #creatorsearchinsights #creatorsearchinsight
0:11

This 5 website will help you learn SQL 1. SQLBolt * Best for absolute beginners. * Interactive lessons with hands-on exercises after every topic. * Learn SELECT, WHERE, JOIN, GROUP BY, and more. 2. Mode * Designed specifically for aspiring data analysts. * Uses real business datasets. * Covers beginner to intermediate SQL. 3. DataCamp * Excellent structured SQL courses. * Practice directly in your browser. * Covers PostgreSQL and SQL for data analysis. 4. StrataScratch * Best for real-world SQL interview questions. * Questions from companies like Google, Amazon, Meta, and Microsoft. * Great once you know the basics. 5. HackerRank * Beginner-friendly SQL challenges. * Covers Basic, Intermediate, and Advanced SQL. #sql #coding #codinglife #creatorsearchinsights #creatorsearchinsight

Ada🩵

13,800 просмотров • 3 месяцев назад

SQL Has Been Replaced by English You don't need to learn SQL anymore; you can simply learn English 🤣 Our platform users have been using this feature for the last 18 months.
0:18

SQL Has Been Replaced by English You don't need to learn SQL anymore; you can simply learn English 🤣 Our platform users have been using this feature for the last 18 months.

Bindu Reddy

91,211 просмотров • 2 лет назад

I don’t have a single tattoo. I’m not against them. I actually like them. I’ve just… never done it. How many tattoos do you have? And does anyone here have a FULL body tattoo? No judgment. I’m genuinely curious.
0:10

I don’t have a single tattoo. I’m not against them. I actually like them. I’ve just… never done it. How many tattoos do you have? And does anyone here have a FULL body tattoo? No judgment. I’m genuinely curious.

JJ

125,574 просмотров • 7 месяцев назад

Universities and High Schools have not moved rapidly enough to guide students to have skills for the next decade. THEY HAVE FAILED. It is a massive crisis that can be averted by understanding what AI and Robotics will bring about. Solutions are knowing how to use these tools and new industries that will rise. But this situation is also on ALL OF US. No “job” is safe from founder to entry level in most industries. You and I, by what we do, will be “replaced” ultimately. What to do? AI and Robotics are tools, the next decade is owned by those who know how to use them expertly, but this is also temporary. We have to understand that what we do for “work” will change giving ultimately a greater value to those that are: Creative Flexible Always learning Willing to be wrong Love being human Love being alive Know history Covet wisdom Knowing all tech has downsides Building strong family and friends Realize many institutions have failed The first four are required for you to be able to live through this period with your sanity intact. The rest will allow you to thrive. There are no true careers at this point anymore. There are advocation and vocations which will either earn you money or give life meaning. We will learn that we are not “what we do”, just like we knew for 99% of human existence. Let that sink in. — You and I are far, far ahead of knowing this and we can do two things: 1) Laugh at the “clueless” 2) Help people understand with grace Go to Reddit if you are 1, in fact don’t follow me because you will not like this next decade and what I post. You are 2 and thank you. Even if you and I have not solved this issue, we can help people understand what is ahead and with determination and creativity bound together to solve it locally. Or human family has done this millions of times. The evidence is: you are here. The Neo Luddite movement has not even begun and it will potentially rip apart society even more than all the fashionable moment in the recent past has. These Luddites will have a good point with the wrong answers cooked up by dying academics that cling to labels, “virtues” and victim hood. It will be readymade for some governments to enter in as “big daddy” to “help us”. You will not like what they do, but you will only know when it is too late. It will include YOU “volunteering” to “leave” by 60, to “help out” CanadaPod style. “Brian, I’m 24 what do I do?”. I hope to do much more here to help. But I do know this: 1) Learn a trade or vocation because it’s valuable. It may also be free to low cost if you do it right. 2) Learn everything you can about USING AI and TRAINING YOUR AI. Your expertise will be in the top 1% for a decade. But not forever. 3) Understand Bitcoin and how it will rise while other things sink. This is a short list for now. We will know more moving forward. When you see videos like this posted below, know one thing: Many of these folks had no real family of mental and physical support. Maybe no parent or one parent. Maybe only a broke system to prepare them for—nothing. This was not their doing. Now it is not your “job” to help them, it is your survival to help them if that is what you need. See some day after the dust settles these 20 year olds will be 40 year olds and running YOUR world. And at some point you may need them more than you think you do. You will need them, as they need you now. THIS IS WHAT PAST WISDOM KNEW. The elders of the past never found the need to piss on the youth and hope for the best. THE YOUTH ARE OUR BEST, let us all find ways to change it, even if every aspect of “the system” wants us to berate them into the ground.
0:17

Universities and High Schools have not moved rapidly enough to guide students to have skills for the next decade. THEY HAVE FAILED. It is a massive crisis that can be averted by understanding what AI and Robotics will bring about. Solutions are knowing how to use these tools and new industries that will rise. But this situation is also on ALL OF US. No “job” is safe from founder to entry level in most industries. You and I, by what we do, will be “replaced” ultimately. What to do? AI and Robotics are tools, the next decade is owned by those who know how to use them expertly, but this is also temporary. We have to understand that what we do for “work” will change giving ultimately a greater value to those that are: Creative Flexible Always learning Willing to be wrong Love being human Love being alive Know history Covet wisdom Knowing all tech has downsides Building strong family and friends Realize many institutions have failed The first four are required for you to be able to live through this period with your sanity intact. The rest will allow you to thrive. There are no true careers at this point anymore. There are advocation and vocations which will either earn you money or give life meaning. We will learn that we are not “what we do”, just like we knew for 99% of human existence. Let that sink in. — You and I are far, far ahead of knowing this and we can do two things: 1) Laugh at the “clueless” 2) Help people understand with grace Go to Reddit if you are 1, in fact don’t follow me because you will not like this next decade and what I post. You are 2 and thank you. Even if you and I have not solved this issue, we can help people understand what is ahead and with determination and creativity bound together to solve it locally. Or human family has done this millions of times. The evidence is: you are here. The Neo Luddite movement has not even begun and it will potentially rip apart society even more than all the fashionable moment in the recent past has. These Luddites will have a good point with the wrong answers cooked up by dying academics that cling to labels, “virtues” and victim hood. It will be readymade for some governments to enter in as “big daddy” to “help us”. You will not like what they do, but you will only know when it is too late. It will include YOU “volunteering” to “leave” by 60, to “help out” CanadaPod style. “Brian, I’m 24 what do I do?”. I hope to do much more here to help. But I do know this: 1) Learn a trade or vocation because it’s valuable. It may also be free to low cost if you do it right. 2) Learn everything you can about USING AI and TRAINING YOUR AI. Your expertise will be in the top 1% for a decade. But not forever. 3) Understand Bitcoin and how it will rise while other things sink. This is a short list for now. We will know more moving forward. When you see videos like this posted below, know one thing: Many of these folks had no real family of mental and physical support. Maybe no parent or one parent. Maybe only a broke system to prepare them for—nothing. This was not their doing. Now it is not your “job” to help them, it is your survival to help them if that is what you need. See some day after the dust settles these 20 year olds will be 40 year olds and running YOUR world. And at some point you may need them more than you think you do. You will need them, as they need you now. THIS IS WHAT PAST WISDOM KNEW. The elders of the past never found the need to piss on the youth and hope for the best. THE YOUTH ARE OUR BEST, let us all find ways to change it, even if every aspect of “the system” wants us to berate them into the ground.

Brian Roemmele

37,681 просмотров • 1 год назад

I kid you not, Taiwan is the most orderly country that I have seen in my entire travel history. I have been using their public transportation and boy they are the epitome of discipline. I have been to Japan and you would have read about them as well but I feel they beat Japan in here. Stations as crowded as Rajeev chowk but people are in zen mode, not even a single soul is breaking the queue anywhere. 0 bloody push, 0. 🤯 This law and order, keeps your mind cool. Nothing spoils your mood and you can invest your time and brain over things that matter and not pity problems or argument. From escalators to Metros, not a single person is breaking the queue. I will put forward more videos.
0:15

I kid you not, Taiwan is the most orderly country that I have seen in my entire travel history. I have been using their public transportation and boy they are the epitome of discipline. I have been to Japan and you would have read about them as well but I feel they beat Japan in here. Stations as crowded as Rajeev chowk but people are in zen mode, not even a single soul is breaking the queue anywhere. 0 bloody push, 0. 🤯 This law and order, keeps your mind cool. Nothing spoils your mood and you can invest your time and brain over things that matter and not pity problems or argument. From escalators to Metros, not a single person is breaking the queue. I will put forward more videos.

Priyesh Sharma

297,255 просмотров • 7 месяцев назад

This lady was filming these parents who were in the car line at school 2 1/2 hours before school gets out. She says don’t be like them. But many people said it’s worth not having to deal with the traffic and backup and some parents may work closer to the school and it beats driving all the way back home and then coming back. I have been known to go get in line at the school about an hour before they get out so I can beat it as well. Sometimes I’ll catch up on emails, phone calls and even take a nap. Have you ever gone this early to get in the car line? Have you ever wondered when you have left early how these people are here before you? Does this bother you like it does this woman or to each their own?
0:11

This lady was filming these parents who were in the car line at school 2 1/2 hours before school gets out. She says don’t be like them. But many people said it’s worth not having to deal with the traffic and backup and some parents may work closer to the school and it beats driving all the way back home and then coming back. I have been known to go get in line at the school about an hour before they get out so I can beat it as well. Sometimes I’ll catch up on emails, phone calls and even take a nap. Have you ever gone this early to get in the car line? Have you ever wondered when you have left early how these people are here before you? Does this bother you like it does this woman or to each their own?

👉M-Û-R-Č-H👈

30,107 просмотров • 5 месяцев назад

People get so emotional about DNA issues that they refuse to think reasonably. If you, on your own volition, wake up one morning, and decide to go have a DNA paternity test of "your" children, then you must also be ready for the results that will come back to you. You must have reasonable cause to go for the test. That reasonable cause means you are not 100% sure if the kids are yours and hence need a confirmation test. The DNA centers are supposed to take you through counseling before you sign on to do the test. Don't go for a test and later come and disturb us online with the results. Nobody asked for it. The situation is different if you need to have the DNA test to help you complete some documentation for traveling etc. That one you didn't request for the test out of your own volition. So I can understand you if you are surprised when the results come. There is an Akan proverb that says "if you go searching for stuffs in the eyes of dead person, you will definitely see a ghost."
0:17

People get so emotional about DNA issues that they refuse to think reasonably. If you, on your own volition, wake up one morning, and decide to go have a DNA paternity test of "your" children, then you must also be ready for the results that will come back to you. You must have reasonable cause to go for the test. That reasonable cause means you are not 100% sure if the kids are yours and hence need a confirmation test. The DNA centers are supposed to take you through counseling before you sign on to do the test. Don't go for a test and later come and disturb us online with the results. Nobody asked for it. The situation is different if you need to have the DNA test to help you complete some documentation for traveling etc. That one you didn't request for the test out of your own volition. So I can understand you if you are surprised when the results come. There is an Akan proverb that says "if you go searching for stuffs in the eyes of dead person, you will definitely see a ghost."

Sewing Machine 🇬🇭 🇳🇬

135,985 просмотров • 1 год назад

On progress to become a professional data Analyst #dataanalyst #sql #microsoftsqlserver #selflearning #fyp
0:14

On progress to become a professional data Analyst #dataanalyst #sql #microsoftsqlserver #selflearning #fyp

Bryant

573,900 просмотров • 2 лет назад

4 websites to gamify SQL! SQL Squid Game 🦑 - 9 levels, 1 data science job with your life on the line The SQL Murder Mystery 🕵️ - learn concepts and commands, for both beginners and experienced SQL users Lost at SQL 🏝️ - test your SQL skills against the clock SQL Noir 🔍 - Crack murder mystery’s in beginner, intermediate, and advanced levels #computerscience #sql #coding #university #college
0:10

4 websites to gamify SQL! SQL Squid Game 🦑 - 9 levels, 1 data science job with your life on the line The SQL Murder Mystery 🕵️ - learn concepts and commands, for both beginners and experienced SQL users Lost at SQL 🏝️ - test your SQL skills against the clock SQL Noir 🔍 - Crack murder mystery’s in beginner, intermediate, and advanced levels #computerscience #sql #coding #university #college

Cleo

139,300 просмотров • 18 дней назад

When you have too many hobbies but you don’t have time for all of them and all that’s left is to start combining them.
0:12

When you have too many hobbies but you don’t have time for all of them and all that’s left is to start combining them.

Weapons Daily

18,443 просмотров • 3 месяцев назад

🚨Either you are a politician, or you are a cricketer - Kaif slams Mohsin Naqvi🤯 Mohammad Kaif said :🗣️ "Are they living in the past? Don't they have a reality check? Mohsin Naqvi is in politics. He is the boss of the board. It's not like that. If you are in cricket, then you have to be in cricket. You have to go to two places. It's a difficult job. You won't be able to give time. You have so many political commitments. You have to run the cricket board. You have to see what's going on inside. You have to stop at one place and invest time. If you look at anybody, if you compare it with the BCCI, or if you look at it from the outside, nobody does two things. Either you are a politician, or you are a cricketer. You have to balance it. You have to focus on one thing".
0:12

🚨Either you are a politician, or you are a cricketer - Kaif slams Mohsin Naqvi🤯 Mohammad Kaif said :🗣️ "Are they living in the past? Don't they have a reality check? Mohsin Naqvi is in politics. He is the boss of the board. It's not like that. If you are in cricket, then you have to be in cricket. You have to go to two places. It's a difficult job. You won't be able to give time. You have so many political commitments. You have to run the cricket board. You have to see what's going on inside. You have to stop at one place and invest time. If you look at anybody, if you compare it with the BCCI, or if you look at it from the outside, nobody does two things. Either you are a politician, or you are a cricketer. You have to balance it. You have to focus on one thing".

Akshat

37,184 просмотров • 1 месяц назад

i'm not lying when i tell you that i think stan hansen's body language in this clip is one of the funniest things i have ever seen in the history of wrestling. every time i see it i crack up no matter how many times i've seen it previously.
0:16

i'm not lying when i tell you that i think stan hansen's body language in this clip is one of the funniest things i have ever seen in the history of wrestling. every time i see it i crack up no matter how many times i've seen it previously.

emil

15,800 просмотров • 7 месяцев назад

I don’t really know where to start but here I go. I’m feeling lots of emotions but the one thing I know forsure is this has been the best year and a half that I have known you both. The beautiful moments I’ll never forget. The way you looked at each other, held hands together, leaned on each other in good and bad times. I know that was all real. Everyday wasn’t perfect but it was real. You never had to tell me cause I know. Please don’t feel guilty for the decision you had to make. “Forever” ended a bit earlier than we all expected but with growing comes change and sometimes the journeys don’t align but I hope one day your paths can cross again because you two in each other’s lives is forever. To Joong อันโดรเมด้า ชุน: I know it’s been hard, especially lately. I’m so sorry for all of the hate you have received and I truly hope mentally you are okay. I know you have a great support system but don’t forget, we, the real fans are also your support system. I pray for your wellbeing everyday. Thank you for being such a bright light. I hope your beautiful smile never fades and you continue to flourish in your career. I’m so excited to see you take on a new role in Loveless Heroine and continue your journey in JASPER and I’ll be watching with proud eyes through every step of the way. To Dunk dunknatachai: I know it’s been hard for you as well. Receiving hate and false accusations about your personal and professional life from people who claim to love you isn’t easy but you are a kind soul and it will come back tenfold. Thank you for bringing some sweetness into my life with your gorgeous smile and personality but also with Navori. I haven’t been here long but I’m truly proud of the man you’ve grown to be when it comes to your passion. I will be supporting every Navori release and all of your future endeavors. Please know that we, the real fans are always here for you as well. You two were never JUST a ship to me. I have always said no matter what I would support you both individually and together and I meant that. Today’s announcement doesn’t change that. The path may be different than what I expected and I’m sure from what you expected but I will continue walking this journey with you both because you deserve love always. Both of you will always remain in my heart as JoongDunk so I’ll always bask in the memories but I’ll be there for everything you decide to pursue in your solo careers. I have cried many tears and been super emotional today but I will try my best to take care of myself so you two don’t have to worry about me. Every single time I’ve met you, both together and individually, I’ve felt so much warmth and excitement and that will never change. There may be a twinge of sadness knowing you two won’t be partners anymore but I’m relieved to know you two still love each other dearly and that’s all I can ask for at this time. I know you two will always hold each others hands through every chapter of life. I know this is difficult for you as it is for us to take your time and grieve and process and I’ll do the same. I can’t wait to see where your new journeys take you and I can’t wait to meet you again. I love you so so so so so much. Always and forever. Thank you for being JoongDunk. Thank you for being Joong Archen. Thank you for being Dunk Natachai. And thank you for always bringing me happiness. My sunshine 🌞 and my sunflower 🌻 Love, Lele ♥️
0:15

I don’t really know where to start but here I go. I’m feeling lots of emotions but the one thing I know forsure is this has been the best year and a half that I have known you both. The beautiful moments I’ll never forget. The way you looked at each other, held hands together, leaned on each other in good and bad times. I know that was all real. Everyday wasn’t perfect but it was real. You never had to tell me cause I know. Please don’t feel guilty for the decision you had to make. “Forever” ended a bit earlier than we all expected but with growing comes change and sometimes the journeys don’t align but I hope one day your paths can cross again because you two in each other’s lives is forever. To Joong อันโดรเมด้า ชุน: I know it’s been hard, especially lately. I’m so sorry for all of the hate you have received and I truly hope mentally you are okay. I know you have a great support system but don’t forget, we, the real fans are also your support system. I pray for your wellbeing everyday. Thank you for being such a bright light. I hope your beautiful smile never fades and you continue to flourish in your career. I’m so excited to see you take on a new role in Loveless Heroine and continue your journey in JASPER and I’ll be watching with proud eyes through every step of the way. To Dunk dunknatachai: I know it’s been hard for you as well. Receiving hate and false accusations about your personal and professional life from people who claim to love you isn’t easy but you are a kind soul and it will come back tenfold. Thank you for bringing some sweetness into my life with your gorgeous smile and personality but also with Navori. I haven’t been here long but I’m truly proud of the man you’ve grown to be when it comes to your passion. I will be supporting every Navori release and all of your future endeavors. Please know that we, the real fans are always here for you as well. You two were never JUST a ship to me. I have always said no matter what I would support you both individually and together and I meant that. Today’s announcement doesn’t change that. The path may be different than what I expected and I’m sure from what you expected but I will continue walking this journey with you both because you deserve love always. Both of you will always remain in my heart as JoongDunk so I’ll always bask in the memories but I’ll be there for everything you decide to pursue in your solo careers. I have cried many tears and been super emotional today but I will try my best to take care of myself so you two don’t have to worry about me. Every single time I’ve met you, both together and individually, I’ve felt so much warmth and excitement and that will never change. There may be a twinge of sadness knowing you two won’t be partners anymore but I’m relieved to know you two still love each other dearly and that’s all I can ask for at this time. I know you two will always hold each others hands through every chapter of life. I know this is difficult for you as it is for us to take your time and grieve and process and I’ll do the same. I can’t wait to see where your new journeys take you and I can’t wait to meet you again. I love you so so so so so much. Always and forever. Thank you for being JoongDunk. Thank you for being Joong Archen. Thank you for being Dunk Natachai. And thank you for always bringing me happiness. My sunshine 🌞 and my sunflower 🌻 Love, Lele ♥️

lele⁷ 🌞🌻🤍

41,640 просмотров • 23 дней назад

You have been dead far longer than you have been alive. This life is a brief hallucination between two eternities, and you chose it. Not to learn. Not to grow. To remember that you are the eternity both before and after.
0:10

You have been dead far longer than you have been alive. This life is a brief hallucination between two eternities, and you chose it. Not to learn. Not to grow. To remember that you are the eternity both before and after.

Ra 𐦝

12,804 просмотров • 1 месяц назад

this is the worst local ai will ever be. it only gets better from here. if you are not expanding your mind with these small models you are missing what's happening right now 99 percent tool call success rate. when steered well with the right skills and a framework like hermes agent the node becomes a cognition layer. not a chatbot. not a toy. an extension of how you think. i was cranking this node at 35 to 50 tok/s all day on personal experiments and now after all the work is done qwen 3.5 9B is iterating on its own code. the game it created. fixing its own bugs autonomously. and the part you should probably not miss is that all of this is happening on a RTX 3060. not an H100. not an A100. the card most of you have sitting in a drawer right now. if you just open that drawer and put that intelligence to work every tensor core on that card should be running for you. your work. your experiments. your thinking. you all have it but because nobody told you what this hardware can actually do in 2026 you never tried. the day it unlocks is the day you test your workload, understand the tradeoffs, debug the loops, and then decide if you need to scale the hardware. there is no point buying 3 mac studios when things done well you can squeeze a similar level of intelligence from 9B compared to 70B. but only when you create the right environment for your model through the right harness. and let me tell you i have tried claude code as a local harness. i have tried opencode. i have tried various others. somehow i landed on hermes agent and never left. there is something magical going on at Nous Research. the tool call parsers, the skills system, the way it handles small models natively. nothing else comes close for local inference. own your cognition. your AI. your agent. your prompts. your experiments. why give them away for free. those are who you are and they don't belong on someone else's servers being monitored. just give it a shot with your existing hardware. you run into a problem the community will help you. and if you are migrating from openclaw to hermes i will personally help you make the switch.
0:13

this is the worst local ai will ever be. it only gets better from here. if you are not expanding your mind with these small models you are missing what's happening right now 99 percent tool call success rate. when steered well with the right skills and a framework like hermes agent the node becomes a cognition layer. not a chatbot. not a toy. an extension of how you think. i was cranking this node at 35 to 50 tok/s all day on personal experiments and now after all the work is done qwen 3.5 9B is iterating on its own code. the game it created. fixing its own bugs autonomously. and the part you should probably not miss is that all of this is happening on a RTX 3060. not an H100. not an A100. the card most of you have sitting in a drawer right now. if you just open that drawer and put that intelligence to work every tensor core on that card should be running for you. your work. your experiments. your thinking. you all have it but because nobody told you what this hardware can actually do in 2026 you never tried. the day it unlocks is the day you test your workload, understand the tradeoffs, debug the loops, and then decide if you need to scale the hardware. there is no point buying 3 mac studios when things done well you can squeeze a similar level of intelligence from 9B compared to 70B. but only when you create the right environment for your model through the right harness. and let me tell you i have tried claude code as a local harness. i have tried opencode. i have tried various others. somehow i landed on hermes agent and never left. there is something magical going on at Nous Research. the tool call parsers, the skills system, the way it handles small models natively. nothing else comes close for local inference. own your cognition. your AI. your agent. your prompts. your experiments. why give them away for free. those are who you are and they don't belong on someone else's servers being monitored. just give it a shot with your existing hardware. you run into a problem the community will help you. and if you are migrating from openclaw to hermes i will personally help you make the switch.

Sudo su

58,717 просмотров • 7 месяцев назад

If you are a teacher, and your partner or spouse can’t understand why you don’t want to answer a single question when you get home—show them this. This is why I, and many educators, have difficulty answering the simplest questions after a school day.
0:14

If you are a teacher, and your partner or spouse can’t understand why you don’t want to answer a single question when you get home—show them this. This is why I, and many educators, have difficulty answering the simplest questions after a school day.

Nicholas Ferroni

29,557 просмотров • 1 год назад