Logo
    Search

    tools

    Explore "tools" with insightful episodes like "A Beginner's Guide to Understanding SQL Window Functions - Part 2", "The Simple, Repeatable Path to Wealth with Real Estate in 2024 w/Scott Trench", "Talking Flipper Zero with The Talking Sasquatch", "Are You Overpaying? How to Evaluate and Offer on Rental Properties" and "EP 81: How To Get AI to Read and Write Your Emails" from podcasts like ""Programming Tech Brief By HackerNoon", "BiggerPockets Real Estate Podcast", "Hacked", "BiggerPockets Real Estate Podcast" and "Everyday AI Podcast – An AI and ChatGPT Podcast"" and more!

    Episodes (44)

    A Beginner's Guide to Understanding SQL Window Functions - Part 2

    A Beginner's Guide to Understanding SQL Window Functions - Part 2

    This story was originally published on HackerNoon at: https://hackernoon.com/a-beginners-guide-to-understanding-sql-window-functions-part-2.
    let us explore more advanced SQL concepts. It may sound a bit complicated at first glance, but I will provide simple examples suitable for beginners...
    Check more stories related to programming at: https://hackernoon.com/c/programming. You can also check exclusive content about #sql, #window-functions, #analytics, #tools, #cumulative-sum, #advanced-sql-concepts, #use-cases-of-window-functions, #hackernoon-top-story, #hackernoon-es, #hackernoon-hi, #hackernoon-zh, #hackernoon-fr, #hackernoon-bn, #hackernoon-ru, #hackernoon-vi, #hackernoon-pt, #hackernoon-ja, #hackernoon-de, #hackernoon-ko, #hackernoon-tr, and more.

    This story was written by: @yonatansali. Learn more about this writer by checking @yonatansali's about page, and for more stories, please visit hackernoon.com.

    Let us explore more advanced SQL concepts. It may sound a bit complicated at first glance, but I will provide simple examples suitable for beginners for all the possible cases, so it will be easy to catch my drift.

    The Simple, Repeatable Path to Wealth with Real Estate in 2024 w/Scott Trench

    The Simple, Repeatable Path to Wealth with Real Estate in 2024 w/Scott Trench
    Investing in real estate can build you massive wealth. And here’s the secret no one wants to tell you: it isn’t all that hard. But before you jump to conclusions and call real estate a get-rich-quick scheme, let’s lay down the law. Investing in real estate is a simple, repeatable process that MANY Americans have used to get rich, but it takes knowledge and time to succeed. Where do you go to learn how to buy your first or next rental property? Well, you’re already here! In this bonus episode, Scott Trench, CEO of BiggerPockets AND decade-long investor, will share his five-step, repeatable process for finding and analyzing real estate deals. Scott has taken the SLOW route to wealth. He doesn’t have a hundred units, a big real estate fund, or a yacht. But he does have a thirteen-unit passive-income-producing rental portfolio that pays him money every single month. Stick around to learn how YOU can get your first or next rental property in 2024. Want full access to the tools and resources from this episode, including calculators and rent estimators? Sign up for BiggerPockets Pro and use code “STABLEWEALTH24” for a special discount! In This Episode We Cover: The five-step process to find real estate deals in any market  How Scott built a thirteen-unit real estate portfolio in under ten years  The slow, steady, repeatable path to wealth with buy and hold rental properties Scott’s 2024 housing market, mortgage rate, and price predictions  How to choose a rental property market depending on your goals  And So Much More! Links from the Show Find an Agent Find a Lender BiggerPockets Youtube Channel BiggerPockets Forums BiggerPockets Pro Membership BiggerPockets Bookstore BiggerPockets Bootcamps BiggerPockets Podcast BiggerPockets Merch Listen to All Your Favorite BiggerPockets Podcasts in One Place Learn About Real Estate, The Housing Market, and Money Management with The BiggerPockets Podcasts Get More Deals Done with The BiggerPockets Investing Tools Find a BiggerPockets Real Estate Meetup in Your Area Rent Estimator Rental Property Calculator Connect with Other Investors on the BiggerPockets Forums Grab the “Quick Start Guide” to Real Estate Hear Scott on the “BiggerPockets Money” Podcast Work with Rent to Retirement for Your First or Next Turnkey Rental Property Books Mentioned in the Show: Set for Life by Scott Trench First-Time Home Buyer by Scott Trench Connect with Scott: Scott's BiggerPockets Profile Click here to listen to the full episode: https://www.biggerpockets.com/blog/real-estate-q4-3 Interested in learning more about today’s sponsors or becoming a BiggerPockets partner yourself? Email advertise@biggerpockets.com. Learn more about your ad choices. Visit megaphone.fm/adchoices

    Are You Overpaying? How to Evaluate and Offer on Rental Properties

    Are You Overpaying? How to Evaluate and Offer on Rental Properties
    Once you know how to analyze a rental property, you can reach financial freedom FAR faster than most Americans. You’ll be able to know how much a property is worth, how much passive income you’ll make, which properties are worth investing in, and how many rentals you’ll need to retire and reclaim your time freedom. Today, David Greene will give you a masterclass on analyzing rental properties plus seven “sneaky tips” to get ANY offer accepted (even in 2023!).  In this short webinar, you’ll learn how to find the best rental properties in any area and analyze a rental for cash flow, cash on cash return, equity upside, and more. The best part? You don’t need ANY investing experience to do these calculations. With the BiggerPockets Rental Property Calculator, you can tell if a property is worth the price in MINUTES! David will walk through it all in this episode!  Ready to start? Sign up for BiggerPockets Pro and use code “OFFER20” for 20% off an annual membership and UNLIMITED calculator usage!  In This Episode We Cover: How to buy your first (or next) rental property EVEN in today’s tough market  How to analyze a rental property from start to finish in MINUTES The “LAPS” system you can use to constantly find great real estate deals  Cash flow, cash on cash return, equity, and other metrics you MUST know about How to make an irresistible offer and David’s seven “sneaky tips” for getting your first property under contract  The one tool top real estate investors use to build massive passive income And So Much More! Links from the Show Find an Agent Find a Lender BiggerPockets Youtube Channel BiggerPockets Forums BiggerPockets Pro Membership BiggerPockets Bookstore BiggerPockets Bootcamps BiggerPockets Podcast BiggerPockets Merch Listen to All Your Favorite BiggerPockets Podcasts in One Place Learn About Real Estate, The Housing Market, and Money Management with The BiggerPockets Podcasts Get More Deals Done with The BiggerPockets Investing Tools Find a BiggerPockets Real Estate Meetup in Your Area Davids's BiggerPockets Profile David's Instagram Subscribe to David’s YouTube Channel Grab The Best-Selling Books by David Greene Rental Property Calculator Rent Estimator Pro-Exclusive Videos Ask David YOUR Investing Question Get the Slide Deck from This Webinar Connect with David: David's BiggerPockets Profile David's Instagram Lending Brokerage Textletter David's Website Click here to listen to the full episode: https://www.biggerpockets.com/blog/real-estate-q4-1 Interested in learning more about today’s sponsors or becoming a BiggerPockets partner yourself? Email advertise@biggerpockets.com. Learn more about your ad choices. Visit megaphone.fm/adchoices

    EP 81: How To Get AI to Read and Write Your Emails

    EP 81: How To Get AI to Read and Write Your Emails

    The average professional spends 28% of their work day in emails. How can you have AI read and write your emails so you can bring that down to about 5%? We show you how.

    Newsletter: Sign-up for our free daily newsletter
    More on this: Episode Page
    Join the discussion:
    Ask Jordan questions about AI and emails
    Upcoming Episodes: Check out the upcoming Everyday AI Livestream lineup
    Website: YourEverydayAI.com
    Email The Show: info@youreverydayai.com
    Connect with Jordan on LinkedIn

    Timestamps:
    [00:01:45] Daily AI news
    [00:07:15] The future of AI in emails
    [00:14:40] How to connect AI to your email:
    [00:17:40] 1. Outlook
    [00:20:43] 2. Gmail
    [00:27:15] Final takeaway

    Topic Covered in This Episode:
    - The importance of using AI to read and respond to emails

    - The CEO of DeepMind's prediction of AI taking over the world in the next decade

    - The Iowa school district's use of AI to ban certain books and the consequences of false positives

    - Google testing an AI-powered assistant as a potential life coach

    - The speaker asks the audience how much time they spend on emails and highlights the need for AI advancements in this area

    - Mention of Microsoft Copilot, an AI tool that could revolutionize email usage

    Keywords:
    AI reading emails, wasting time, developments in AI, DeepMind CEO, AI taking over the world, Iowa school district, banning books, false positives, incorrect bans, Google AI assistant, life coach, reading and responding to emails, important updates, Microsoft Copilot, revolutionize email usage, AI content

    EP 28: Reimagining Media Creativity Through AI

    EP 28: Reimagining Media Creativity Through AI

    Will AI end up being more creative than humans? With new advancements like Dall-E and Midjourney, AI is setting a new standard for media creativity. Travis Hawkes, Director and Co-founder of Lunar Speedboat Productions, joins us to discuss how to use AI tools for your creative advantage and finding ways to stay unique in a world of robots. 

    Time Stamps:
    [00:00:52] AI21 Labs Study Shows One-Third Can't Identify Bots from Humans
    [00:04:32] Google invests heavily in AI company Runway
    [00:06:43] Creating Imagery with Midjourney and Dall-E
    [00:12:11] Unleashing Your Creative Potential: The Power of Runway
    [00:16:53] Can AI create chatbot movies with celebrities?
    [00:20:22] Finding Your Creative Focus and Joining the Conversation
    [00:23:35] The Future of AI-Generated Content: Blessing or Curse?

    For full show notes, head to YourEverydayAI.com

    Girls That Startup: 5 Productivity Apps That Help Me Run a 7 Figure Business

    Girls That Startup: 5 Productivity Apps That Help Me Run a 7 Figure Business

    Welcome back to Girls That Startup, a weekly series where we spill the tea on how to create a seven-figure side hustle - because no one saves their way to wealth. You’re joined by Sim, a seven-figure business owner, and Maia, an entrepreneur in the making.

    This week, Sim and Maia discuss productivity apps. They mention Canva for creating visual content, Flow for managing tasks and workflows, and Notion for organisation and content calendars. They also discuss Monday.com for project management and ChatGPT for email writing and content ideation.

    For more Girls That Invest:

    'Til next week, team! 💖

    --- Send in a voice message: https://podcasters.spotify.com/pod/show/girls-that-invest/message



    Hosted on Acast. See acast.com/privacy for more information.

    WE WENT BROKE! -You Should Know Podcast-

    WE WENT BROKE! -You Should Know Podcast-
    LIVE SHOW TICKETS: https://www.axs.com/events/481891/you-should-know-tickets PATREON AVAILABLE NOW: https://www.patreon.com/YouShouldKnowPodcast SNAPCHAT: https://t.snapchat.com/rbfrNcAG0:00 Preview 0:23 ANNOUNCEMENT 2:35 Cam Joins 6:25 NECTAR LAUNCH WEEKEND 11:32 Club Behavior 14:56 Head out The Window 18:53 Do You Change your Socks? 25:56 City Birds 31:35 POP CULTURE 36:50 How Do You Dry Off 43:03 Wiping With Paper Towels 45:38 Broke Boys 50:16 The SENSES Test w/ Mama liv 56:56 Smell Like Warm 1:02:12 Peyton Goes METAL! 1:03:01 ANNOUNCEMENT YouShouldKnow P.O. BOX 191564 2825 Oak Lawn Ave Dallas, Texas 75219 FOLLOW PEYTON: https://instagram.com/psh8?igshid=ZDg1NjBiNjg= JOIN THE DISCORD: https://discord.gg/V5WYhSte2R GRAB SOME MERCH: https://www.youshouldknowstudios.com/shop Learn more about your ad choices. Visit megaphone.fm/adchoices

    Girls That Startup: How I Became Productive without Embracing Hustle Culture

    Girls That Startup: How I Became Productive without Embracing Hustle Culture

    Welcome back to Girls That Startup, a weekly series where we spill the tea on how to create a seven-figure side hustle - because no one saves their way to wealth. You’re joined by Sim, a seven-figure business owner, and Maia, an entrepreneur in the making.

    Burnout truly does come for us all - this week, Sim shares what she would have done differently, looking back, and steps you can take to be productive and give your business the energy it needs to thrive, without burning yourself out.

    For more Girls That Invest:

    'Til next week, team! 💖

    --- Send in a voice message: https://podcasters.spotify.com/pod/show/girls-that-invest/message



    Hosted on Acast. See acast.com/privacy for more information.

    Life Begins Once You Value Yourself

    Life Begins Once You Value Yourself

    Have you been lacking self respect for yourself? Finding yourself settling in situations with others? Or maybe settling with low expectations from yourself? In this episode, your host Jadyn Hailey speaks on the topic of Valuing yourself. As Jadyn always says, "High expections prevent low quality experiences." Learn how to properly value yourself, leading to making an impact on how your peers respect you, along with how you respectyourself. Tune into this episode with an iced matcha in almond milk and a whole lot of love for youself. 

    Jadyn's Social Media platforms:

    - Instagram: Jadyn's Instagram & Busy, Yet Pretty Instagram

     

    - Youtube: Jadyn's Youtube

     

    - Tiktok: Jadyn's Tiktok

     

    - Shop my Closet on Motom: Jadyn's Closet

     

    - My Amazon Storefront: Jadyn's Storefront

     

    Sponsors:

    BetterHelp - BetterHelp

    Shopify - Shopify

    Were We Wrong? 2022 Predictions Revisited

    Were We Wrong? 2022 Predictions Revisited

    In this episode of Syntax, Wes and Scott revisit their 2022 predictions and see which ones they got right, and which they got wrong.

    Sentry - Sponsor

    If you want to know what’s happening with your code, track errors and monitor performance with Sentry. Sentry’s Application Monitoring platform helps developers see performance issues, fix errors faster, and optimize their code health. Cut your time on error resolution from hours to minutes. It works with any language and integrates with dozens of other services. Syntax listeners new to Sentry can get two months for free by visiting Sentry.io and using the coupon code TASTYTREAT during sign up.

    Sanity - Sponsor

    Sanity.io is a real-time headless CMS with a fully customizable Content Studio built in React. Get a Sanity powered site up and running in minutes at sanity.io/create. Get an awesome supercharged free developer plan on sanity.io/syntax.

    Auth0 - Sponsor

    Auth0 is the easiest way for developers to add authentication and secure their applications. They provides features like user management, multi-factor authentication, and you can even enable users to login with device biometrics with something like their fingerprint. Not to mention, Auth0 has SDKs for your favorite frameworks like React, Next.js, and Node/Express. Make sure to sign up for a free account and give Auth0 a try with the link below. https://a0.to/syntax

    Show Notes

    ××× SIIIIICK ××× PIIIICKS ×××

    Shameless Plugs

    Tweet us your tasty treats

    Supper Club × React Video Creator with Jonny Burger

    Supper Club × React Video Creator with Jonny Burger

    In this supper club episode of Syntax, Wes and Scott talk with Jonny Burger about why and how he built Remotion, his app that lets you create MP4 videos using React.

    Gatsby - Sponsor

    Today’s episode was sponsored by Gatsby, the fastest frontend for the headless web. Gatsby is the framework of choice for content-rich sites backed by a headless CMS as its GraphQL data layer makes it straightforward to source website content from anywhere. Gatsby’s opinionated, React-based framework makes the hardest parts of building a performant website simpler. Visit Gatsby.dev/Syntax to get your first Gatsby site up in minutes and experience the speed. ⚡️

    Tuple - Sponsor

    This week’s sponsor is Tuple, an app built specifically for remote pair programming. The app is written in C++ and tuned for high-resolution screen sharing and low-latency remote control. Because developers deserve better than Zoom or Meet for pairing.

    Show Notes

    ××× SIIIIICK ××× PIIIICKS ×××

    Shameless Plugs

    Tweet us your tasty treats

    The Productivity Episode

    The Productivity Episode

    In this episode of Syntax, Wes and Scott talk through what they do to get things done - apps for to do list tracking, calendar blocking, and how they determine a productive day.

    StoryBlok - Sponsor

    Storyblok is a headless component-based CMS with a real-time visual editor. It offers the flexibility for developers to craft their perfect tech stack, but it also empowers content creators to make changes independently. The result is that every team has the freedom to quickly and easily create the ideal website with limitless extensibility. Other key features include robust Storyblok SDKs and APIs, powerful internationalization options, and an eCommerce-ready platform.

    LogRocket - Sponsor

    LogRocket lets you replay what users do on your site, helping you reproduce bugs and fix issues faster. It’s an exception tracker, a session re-player and a performance monitor. Get 14 days free at logrocket.com/syntax.

    Freshbooks - Sponsor

    Get a 30 day free trial of Freshbooks at freshbooks.com/syntax

    Show Notes

    ××× SIIIIICK ××× PIIIICKS ×××

    Shameless Plugs

    Tweet us your tasty treats

    Tips for Communicating

    Tips for Communicating

    In this episode of Syntax, Wes and Scott talk about their tips for better communication in email, Zoom calls, code reviews, or asking for help.

    Sentry - Sponsor

    If you want to know what’s happening with your code, track errors and monitor performance with Sentry. Sentry’s Application Monitoring platform helps developers see performance issues, fix errors faster, and optimize their code health. Cut your time on error resolution from hours to minutes. It works with any language and integrates with dozens of other services. Syntax listeners new to Sentry can get two months for free by visiting Sentry.io and using the coupon code TASTYTREAT during sign up.

    Sanity - Sponsor

    Sanity.io is a real-time headless CMS with a fully customizable Content Studio built in React. Get a Sanity powered site up and running in minutes at sanity.io/create. Get an awesome supercharged free developer plan on sanity.io/syntax.

    Auth0 - Sponsor

    Auth0 is the easiest way for developers to add authentication and secure their applications. They provides features like user management, multi-factor authentication, and you can even enable users to login with device biometrics with something like their fingerprint. Not to mention, Auth0 has SDKs for your favorite frameworks like React, Next.js, and Node/Express. Make sure to sign up for a free account and give Auth0 a try with the link below. https://a0.to/syntax

    Show Notes

    ××× SIIIIICK ××× PIIIICKS ×××

    Shameless Plugs

    Tweet us your tasty treats

    Wes and Scott React to the State of JS

    Wes and Scott React to the State of JS

    In this episode of Syntax, Wes and Scott take a look at the 2021 State of JS survey that was recently published, including demographics, salary, browser APIs, overall happiness, and more!

    Linode - Sponsor

    Whether you’re working on a personal project or managing enterprise infrastructure, you deserve simple, affordable, and accessible cloud computing solutions that allow you to take your project to the next level. Simplify your cloud infrastructure with Linode’s Linux virtual machines and develop, deploy, and scale your modern applications faster and easier. Get started on Linode today with a $100 in free credit for listeners of Syntax. You can find all the details at linode.com/syntax. Linode has 11 global data centers and provides 24/7/365 human support with no tiers or hand-offs regardless of your plan size. In addition to shared and dedicated compute instances, you can use your $100 in credit on S3-compatible object storage, Managed Kubernetes, and more. Visit linode.com/syntax and click on the “Create Free Account” button to get started.

    LogRocket - Sponsor

    LogRocket lets you replay what users do on your site, helping you reproduce bugs and fix issues faster. It’s an exception tracker, a session re-player and a performance monitor. Get 14 days free at logrocket.com/syntax.

    Freshbooks - Sponsor

    Get a 30 day free trial of Freshbooks at freshbooks.com/syntax

    Show Notes

    ××× SIIIIICK ××× PIIIICKS ×××

    Shameless Plugs

    Tweet us your tasty treats

    F*CK New Year New You with Elisabeth Kristof

    F*CK New Year New You with Elisabeth Kristof

    Elisabeth Kristof is here from Brain Based Wellness and we are going to get into why you are not meeting your new year’s resolutions. There's NOTHING wrong with you! You are setting yourself up to fail, when you don’t have the right tools & understandings. We will teach you how to set attainable goals. Diet culture and the wellness industry are harmful. We also talk about the work we do at Brain Based Wellness & the Food Freedom program. 

     

    In this episode, we discuss:

    • New year, return to YOU
    • Diet culture is here to ruin you
    • Creating safety in the body
    • What ‘Regulation’ means
    • Our sympathetic nervous system
    • The subconscious mind
    • Body boundary violation
    • What we do in Food Freedom 
    • Self Sabotage
    • How the economy runs on scarcity - it’s profitable…
    • True healing means removing the limitations

     

     

    • Work with Jennifer

    Get 25% Off a Private Coaching Session with me

    Sign-up for the Newsletter and stay up to date on my latest workshops, services, and speaking events. 

    Become a Member & Support the Illuminated Podcast on Patreon

    FREE 1 Year Supply of Vitamin D + 5 Travel Packs from Athletic Greens when you use

    My exclusive offer: AthleticGreens.com/Illuminated 

     

    • Work with Elisabeth 

    Get in on Elisabeth's exclusive Free Video Training - her proven step-by-step system to ZAP stress, RESOLVE anxiety, STOP pain, DROP unwanted behaviors and MAGNIFY clarity and focus. 

    It’s easier than you think. If you can watch a video, you can heal your nervous system. 

    Go here to get your free videos now: 

    https://brainbased-wellness.com/register/free-subscription/

     

    • Connect with Jennifer

    Website

    Patreon

    YouTube

    Facebook

    Instagram

     

     

    • Connect with Elisabeth

    Website

    Instagram

    Facebook

    No More Lonely Friends with Marissa Meizz

    No More Lonely Friends with Marissa Meizz

    How would you react if you found out that your friends purposely planned a birthday party when you were out of town so you wouldn’t attend? And what if you found out from a video that went viral on TikTok? 

    That’s exactly what happened to Marissa Meizz. 

    Marissa's reaction was absolutely beautiful. She used the attention - and the pain - to help others. She founded No More Lonely Friends, a group dedicated to help anyone who wants to build deeper, more meaningful friendships.

    This is… A Bit of Optimism.

    For more information on Marissa and her work visit: 

    https://nomorelonelyfriends.com/

    https://www.instagram.com/nomorelonelyfriends

    https://www.instagram.com/marissameizz

    See omnystudio.com/listener for privacy information.

    Coping Skills for Your Toolbox with Jenifer Wallace

    Coping Skills for Your Toolbox with Jenifer Wallace

    In this episode I will be talking about different coping tools you can add to your toolbox right now. We will be changing the physiological state in the body to the rest and digest place. 

     

    In this episode, I discuss:

    • When I discovered nervous system healing and fight to repair my mind and body
    • My encouragement to you to nurture yourself on your journey to heal
    • Using your senses as coping tools that can help you relax 
    • Co-regulating and the different methods and reactions of it
    • Giving gratitude for the physical body and its help with expansion
    • Meditation, trauma, and training your nervous system
    • Respiration tools – I guide you through 2 different breathing exercises
    • The vagus nerve



    Work with Jennifer

    Get 25% Off a Private Coaching Session with me

    Sign-up for the Newsletter and stay up to date on my latest workshops, services, and speaking events. 

    Become a Member & Support the Illuminated Podcast on Patreon

    FREE 1 Year Supply of Vitamin D + 5 Travel Packs from Athletic Greens when you use

    My exclusive offer: AthleticGreens.com/Illuminated 



    Resources From This Episode:

    BBW consultation for Food Freedom → Book Your Call

    Amazon Colored Glasses HERE

     

    Connect with Jennifer

    Website

    Patreon

    YouTube

    Facebook

    Instagram