Database Professionals

Window functions have nothing to do with the Windows operating system but provide a “window” to a result set when used in SQL queries. They are powerful, set-based methods to view data in unexpected ways. Window functions provide easy, set-based solutions to solve some common problems: * Using running totals * Performing operations in intervals * Identifying data gaps and islands * Performing aggregates without losing detail Many people are confused by window functions and do not know how to use them properly. This session will explore window functions, how they work, and how to use them. Demonstrations with several examples will solidify how window functions can simplify queries and make them more powerful.

One of the most valuable parts of this community is the opportunity to think out loud with other product professionals. This session is built for exactly that. As we wrap up the quarter, it’s a great time to pause and reflect. What’s on track? What needs adjustment? Where could a small shift create bigger impact? Join fellow product professionals for a focused, interactive conversation designed to help you recalibrate for the next quarter. You’ll have the opportunity to share where you are, hear how others are thinking through similar challenges, and gain fresh perspective you can bring back to your team and organization. We’ll gather at 8:00AM, with discussion starting promptly at 8:15AM. 📍 First Watch - 7227 N High St Located in: The Shops at Worthington Ample parking is available. Food and beverages will be available for purchase. Start your morning with clarity and connection — we hope to see you there! ☀️

Discover Kiro, AWS’s innovative development environment that adapts to your workflow. Whether you prefer specification-driven development or a more intuitive, vibe-based approach, Kiro empowers you to build applications your way. In this session, speakers will explore Kiro’s core functionality and its evolution through re:Invent 2025, along with demonstrations of prompts used to create APIs, hooks, and steering documents. In the latter part of the session, watch as we build a complete example from scratch, showcasing Kiro’s agentic AI workflow in action for spec-driven development and vibe coding. What You'll Learn - Core Kiro concepts and development philosophy Feature evolution: pre and post re:Invent 2025 Practical examples: API creation, hooks, and steering docs Live coding demonstration with real-time problem solving Who Should Attend - Developers, solutions architects, and technical leaders interested in modern AWS development tools and AI-assisted coding workflows. **Speakers Bio:** Matthew Jorat: Matthew Jorat is a Customer Solutions Manager at AWS with nearly three decades of expertise in AI, cloud transformation, migration, modernization, IT, technology, and business. His career spans infrastructure engineer, solutions architect, security auditor, customer success director, support and services director, and operations officer. He was an early adopter of AWS services as a customer, and his current role at AWS uniquely blends his technical and business skills as he partners with executive teams to translate strategic priorities into measurable business outcomes through cloud adoption, AI implementation, and operational excellence. Matt leads end-to-end AI initiatives for enterprise customers, identifying high-impact use cases and maintaining relentless focus on measurable ROI. He holds eight AWS certifications and serves as Adjunct Professor at Franklin University teaching cloud computing and AWS architecture. His expertise encompasses GenAI, agentic AI systems, migration, modernization, and optimization strategies that drive transformation at scale. [https://www.linkedin.com/in/mattjorat/](https://www.linkedin.com/in/mattjorat/) Girish Bhatia: Girish Bhatia is a seasoned technology delivery leader with deep expertise in cross-domain program management. He holds multiple AWS certifications, including AWS Certified Solutions Architect – Associate, AWS Certified Developer – Associate, and AWS Generative AI Practitioner, and is also an AWS Community Builder. Girish brings over two decades of experience in the information technology industry. Throughout his career, Girish has led major technology-driven business transformation from modernizing on-premises applications to driving large-scale cloud migrations. His work includes API-based integration platforms, data-center and mainframe modernization, and enterprise cloud adoption initiatives. Based in Columbus, Ohio, Girish works at a tech-forward fintech company. He is passionate about AWS serverless architectures, Generative AI and emerging cloud technologies. An avid learner and builder, he continues to explore and apply the latest innovations in AWS to help organizations accelerate their digital transformation. https://www.linkedin.com/in/girishbhatia/[https://www.linkedin.com/in/girishbhatia/](https://www.linkedin.com/in/girishbhatia/) **THANK YOU** *Franklin University* for hosting our meetup! To learn more about *Franklin University*, please visit their website: https://www.franklin.edu/ **DIRECTIONS** Franklin University Fisher Hall 300 E. Main St, Columbus, OH 43215 Map: https://maps.app.goo.gl/jxjBA2hUmS5qrvhq8 Parking is FREE! Please park in Lot C in front of Fisher Hall. See attached map. NOTE: Map the address only. When mapping with Google Maps it may use the Fisher Hall at OSU, which is NOT correct. **Want to sponsor the pizza and/or bar tab?** Please contact me if you would like to sponsor this meetup's pizza and/or bar tab: angelo@mandato.com

Our monthly PHP meetup. A virtual shindig courtesy of Zoom. Check back here for the details around 6:15 pm

**\*\*\*TO ATTEND THE EVENT, YOU MUST PURCHASE TICKETS THROUGH OUR WEBSITE\*\*\*** [https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup](https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup) Hosted by Pre-Dating Speed Dating, the experts, bringing people together since 2001! *Our events have been featured on CNN, CBS, Axios, Miami New Times, TLC's 90 Day Fiance - The Single Life, Tampa Bay Times, Southbend Times, Citylink Magazine, Essence, The Wall Street Journal, Best of Baltimore, AM New York, Chicago Tribune, WINK FM, Woman's World Magazine, and 100s more -- but come see for yourself!* Join us for a night of fun, flirtation, and possible romance at our singles speed dating event! If you're tired of swiping left and right on dating apps, speed dating is a great way to meet new people in person, in a relaxed, safe, and comfortable environment. **HOW IT WORKS:** We'll introduce you to at least 5, and up to 12 - or more - single women or men. Spend a little time with each one, during a series of 6-minute Pre-Dates. Then tell us who you'd like to speak with again & we'll do the rest! It's the modern, civilized, effective, and fun way to meet other professional-level singles. If you're finished with the games and ineffectiveness of online dating and apps, join us to share a wonderful evening of enjoyable conversation with interesting people... and maybe something magical will happen! **GET TICKETS:** A Meetup RSVP is not a ticket, you must purchase on our website. [https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup](https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup) Use Code MATCH5 for $5 off! **DOES IT WORK?** Yes! According to the New York Times, at a speed dating event, people like 2-3 out of 10 people they meet. Online daters only match with 1 in 100 or fewer of the profiles they study. This is the best way to meet new people, and it works! Just ask the thousands of people that have met at our events and had successful relationships and marriages. **WHAT DOES IT COST?** We put a lot of time and effort into creating the best singles events possible, so we collect a fee for our hard work. Our events are an excellent value at about $3 per introduction. Get your ticket for the best singles event in town. **NOTE FOR NEWCOMERS:** We post our events on various platforms. Our events often sell out, so expect plenty of fellow singles, regardless of the numbers you see here :) So what are you waiting for? Join us for some fun conversation with great new people... and maybe something more! Who will you meet? **GET TICKETS:** [https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup](https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup) #singles #singlesevents #speeddating #love #relationships

**New Dojo Location!** **Draft Day Columbus** 1130 Dublin Road Columbus, OH 43215 We're going to try a new dojo location for a few weeks and see how it works Dojos are informal Python group study sessions where everyone interested in Python gathers to learn about Python, help others with Python, or just hang out. Everyone is welcome from Python beginners to experts. Bringing a laptop is encouraged (we'll have extension cords and power strips). If there's something you want to learn leave a comment on this invite so we can plan ahead. We're looking for topic suggestions and people interested in presenting at our monthly meetings. To this end we've set up a survey form at [https://docs.google.com/forms/d/15eBKF1nQQ2XS5gzD4rvhVRHMBEj7lJtHuA9wXupS3Uc](https://docs.google.com/forms/d/15eBKF1nQQ2XS5gzD4rvhVRHMBEj7lJtHuA9wXupS3Uc)

**\*\*\*TO ATTEND THE EVENT, YOU MUST PURCHASE TICKETS THROUGH OUR WEBSITE\*\*\*** [https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup](https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup) Hosted by Pre-Dating Speed Dating, the experts, bringing people together since 2001! *Our events have been featured on CNN, CBS, Axios, Miami New Times, TLC's 90 Day Fiance - The Single Life, Tampa Bay Times, Southbend Times, Citylink Magazine, Essence, The Wall Street Journal, Best of Baltimore, AM New York, Chicago Tribune, WINK FM, Woman's World Magazine, and 100s more -- but come see for yourself!* Join us for a night of fun, flirtation, and possible romance at our singles speed dating event! If you're tired of swiping left and right on dating apps, speed dating is a great way to meet new people in person, in a relaxed, safe, and comfortable environment. **HOW IT WORKS:** We'll introduce you to at least 5, and up to 12 - or more - single women or men. Spend a little time with each one, during a series of 6-minute Pre-Dates. Then tell us who you'd like to speak with again & we'll do the rest! It's the modern, civilized, effective, and fun way to meet other professional-level singles. If you're finished with the games and ineffectiveness of online dating and apps, join us to share a wonderful evening of enjoyable conversation with interesting people... and maybe something magical will happen! **GET TICKETS:** A Meetup RSVP is not a ticket, you must purchase on our website. [https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup](https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup) Use Code MATCH5 for $5 off! **DOES IT WORK?** Yes! According to the New York Times, at a speed dating event, people like 2-3 out of 10 people they meet. Online daters only match with 1 in 100 or fewer of the profiles they study. This is the best way to meet new people, and it works! Just ask the thousands of people that have met at our events and had successful relationships and marriages. **WHAT DOES IT COST?** We put a lot of time and effort into creating the best singles events possible, so we collect a fee for our hard work. Our events are an excellent value at about $3 per introduction. Get your ticket for the best singles event in town. **NOTE FOR NEWCOMERS:** We post our events on various platforms. Our events often sell out, so expect plenty of fellow singles, regardless of the numbers you see here :) So what are you waiting for? Join us for some fun conversation with great new people... and maybe something more! Who will you meet? **GET TICKETS:** [https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup](https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup) #singles #singlesevents #speeddating #love #relationships