Academics

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.

http://photos2.meetupstatic.com/photos/event/2/a/9/6/600_348310902.jpeg Instructor - Crow, HPS Class fee is $30 at the door or approved exchange RSVP with Advance pay of $25 (discounted) by PayPal on the web or by contacting Enchanted Elements (614) 437-2642. Reservations made directly to Enchanted Elements will be added to the class list manually not online. Private Instruction ~ Closed to the Public ~ Initiated Members Only Please come prepared for ritual. Blessings ~ Crow

**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)

Drake Lundstrom is presenting: Code Anywhere by Talking to your Phone Abstract: Have you heard the trend of people deploying code anywhere from checkout lines to doctors' offices? In this talk, you will learn how to talk to your phone and have an app on Azure to show your friend 5 minutes later. The basic DevOps tools you already know, plus a little bit of AI magic, are all you need! If you want to follow along, the demo will be in Azure with GitHub Actions and GitHub Copilot, and you can have it set up on your phone by the end of the session. Just come in with an Azure account and a GitHub repo. Join us for pizza, drinks, and networking @ Improving's office. Doors open at 5:45.

Bring your business cards and network in person with other business professionals! Gold Star Referral Clubs is one of the most established professional networking organizations in the country, with multiple groups in central Ohio. Join us!

Do toxic people weigh you down? Affect your happiness? How can having toxic relationships affect your Health? And moreover, how can you spot them before it’s too late? Attend this in-person meeting to find out how to spot these people and remove their negative emotions from your life. This event is hosted by The Dianetics and Scientology Life Improvement Center in Central Ohio.

The Humanist Monthly Program is our longest running event and still a community favorite. In the old days it used to be called "Going to HCCO" and we still like to think of it as our flagship event. Food and drinks will be provided at the event. Feel free to show up a little bit early to hang out and talk. Our March speakers are Molly Gaines and Zack Parrish, co-organizers of the Secular Education Association: They will share their story of how a small group of Ohio parents grew into a national organization tracking released-time religious instruction and other church–state issues in public schools. The presentation will cover SEA’s early wins and hard lessons, what we’re seeing nationally right now, and how local advocates can play a meaningful role in protecting public education. Attendees will leave with a clearer understanding of the landscape — and practical ways to get involved. Going forward our meetings will be hybrid. You can meet us in-person or attend online Join Zoom Meeting [https://us02web.zoom.us/j/87836564953?pwd=4Mi57ElZkDIFlb1fnlNwOJ0NiOK4tP.1](https://us02web.zoom.us/j/87836564953?pwd=4Mi57ElZkDIFlb1fnlNwOJ0NiOK4tP.1) Meeting ID: 878 3656 4953 Passcode: 760812 One tap mobile +19292056099,,87836564953#,,,,\*760812# US (New York) +13017158592,,87836564953#,,,,\*760812# US (Washington DC) The formal presentation will start at noon

Come join us for coffee at Matari Coffee to discuss our March book, "The Enchanted Greenhouse"! Book description: Terlu Perna broke the law because she was lonely. She cast a spell and created a magically sentient spider plant. As punishment, she was turned into a wooden statue and tucked away into an alcove in the North Reading Room of the Great Library of Alyssium. This should have been the end of her story . . . Yet one day, Terlu wakes in the cold of winter on a nearly-deserted island full of hundreds of magical greenhouses. She’s starving and freezing, and the only other human on the island is a grumpy gardener. To her surprise, he offers Terlu a place to sleep, clean clothes, and freshly baked honey cakes—at least until she’s ready to sail home. But Terlu can’t return home and doesn’t want to—the greenhouses are a dream come true, each more wondrous than the next. When she learns that the magic that sustains them is failing—causing the death of everything within them—Terlu knows she must help. Even if that means breaking the law again. This time, though, she isn’t alone. Assisted by the gardener and a sentient rose, Terlu must unravel the secrets of a long-dead sorcerer if she wants to save the island—and have a fresh chance at happiness and love.

Newark Area Traders and Exchangers Please join us! You won't want to miss this meeting! We have new investor topics every week. Finally, we will go over properties for sale, needs, and wants. Please carve out time to come join us Friday at 8 a.m. EST Don't forget to like us on Facebook, Newark Area Traders and Exchangers. NEWARK AREA TRADE & EXCHANGERS 975 Mt. Vernon Rd. (Entry at the front doors) Newark, OH 43055 Dues are $5 minimum per person, per week. Part of this goes to our treasurer to fund the meeting and the balance to the church for the use of their room. “Opportunity for Generosity”! Founders: Gerald DePalmo and Furman Tinon (and others) Established 60 +/- years ago and still going strong! Zoom meeting. Topic: NEWARK AREA TRADE & EXCHANGERS Time: 08:00 AM Eastern Time (US and Canada) Please download and import the following iCalendar (.ics) files to your calendar system. Weekly: [https://us02web.zoom.us/meeting/tZcrfuuoqTMvH9Ox4pAJb3wmj1KuwP_Vuylj/ics?icsToken=98tyKuGrqDIoGtOdtRyARpwqBIr4a_TwtlxYgvpyhEv1IgpRMRT7PLNpJ6VPL-7F](https://us02web.zoom.us/meeting/tZcrfuuoqTMvH9Ox4pAJb3wmj1KuwP_Vuylj/ics?icsToken=98tyKuGrqDIoGtOdtRyARpwqBIr4a_TwtlxYgvpyhEv1IgpRMRT7PLNpJ6VPL-7F) Join Zoom Meeting [https://us02web.zoom.us/j/83692078557?pwd=OXNKVGk4alRPNG1BdlNhdFNDQTFSUT09](https://us02web.zoom.us/j/83692078557?pwd=OXNKVGk4alRPNG1BdlNhdFNDQTFSUT09) Meeting ID: 836 9207 8557 Passcode: 215853 One tap mobile +13462487799,,83692078557#,,,,\*215853# US (Houston) +16699006833,,83692078557#,,,,\*215853# US (San Jose) Dial by your location +1 346 248 7799 US (Houston) +1 669 900 6833 US (San Jose) +1 929 205 6099 US (New York) +1 253 215 8782 US (Tacoma) +1 301 715 8592 US (Washington DC) +1 312 626 6799 US (Chicago) Meeting ID: 836 9207 8557 Passcode: 215853 Find your local number: [https://us02web.zoom.us/u/kc1yVEZLS1](https://us02web.zoom.us/u/kc1yVEZLS1)

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! ☀️

This month, we are in-person at GameArena!!! We will also be joined by students and their games from [Shawnee State](https://www.shawnee.edu/game-design-programs)! \-\-\- Join us for our our monthly COGG Prototype and Play event @GameArena! Come to play and showcase your games. We're back in the upper levels of the catwalk mezzanine area. It'll be packed with lots of camaraderie playing your game(s) and other's games on the 2nd floor as well as the 1st floor in the gaming room below the mezzanine. Light snacks and water provided but you can buy food and drinks at the bar (alcoholic drink ID required). [https://www.game-arena.co/menu](https://www.game-arena.co/menu) **Attendees:** Don't have a game to show? Not a problem! All are welcomed and invited from all ages and backgrounds. The more we can have to play test our games the better! **Developers:** Do you have a game that you would like to get critical feedback on? Would you like an excuse to work on a game with other talented artists, programmers, musicians, designers, and writers? Digital, table-top, non-experienced developers, and the like are welcomed! We'll provide signage for your game to help others learn more about your work. Wifi, outlets, tables, and seats (though standing tables also) are available. Come to the Prototype and Play workshop to collaborate and meet local game developers for an evening of epic and raw game play fun! Play works-in-progress, show off your own game, work with others to add polish to a game, or even lend your talents to other fellow developers. Can use South Garage at the Gateway with a $5 voucher on your way out. 75 E 11th Ave, Columbus, OH 43201 [https://maps.app.goo.gl/UwgveUYG37Jy7RtS9](https://maps.app.goo.gl/UwgveUYG37Jy7RtS9) If you have any questions or comments, as always, feel free to reach out to us at [info@thecogg.com!](http://info@thecogg.com!/)

Sleep in on Sundays. When you've had your fill of pajama-time, roll out and have some tasty brunch with your fellow Humanists!

Private Group. Closed to the Public Knowing ourselves and understanding our abilities is the first step toward wielding our gifts with control and accuracy. In subsequent classes we will verify and hone our talents with activities and discussion. These are hands-on workshops and participation is expected. The goal of our series will be to develop expertise in areas of particular interest such as mediumship, channeling, divination, healing and, etc.. Our ultimate directions will be determined by class members as we evolve. I look forward to sharing and discovering with you. - Cynthia

So this month's prompt is more general. I think we can all agree that we are living in "unique" times that require coping skills. I think that one role and/or purpose of philosophy is to help us deal with our daily lives and our "unique" times. So, let's share our feelings and thoughts about which philosopher/philosophy we turn to in order to deal with our crazy events. Who/what helps you stay focused in your daily life and helps you sleep at night. I find that Stoicism with a little philosophical pessimism mixed in goes a long way in helping me deal with what I see as very destructive, fearful and mean spirited public policies at both the state and federal levels. Hope to see you on March 28th!

Start your week the right way with Manic Mondays. Giving you an enjoyable Bachata lesson with a push of cool moves. The second hour has Beginner/Intermediate Salsa on 1. You must understand basic Salsa skills to participate. 730pm-830pm Bachata Cool Moves 830pm-930pm Salsa On 1 (Beginner/Intermediate) $15 for One Class $20 for Both Free Parking & Plenty of Dance Space.

Salsamante Dance Academy will be at Swerve Every Tuesday Night to share the Rhythm & Energy of Bachata & Salsa. These are Beginner Level lessons to get you comfortable and understand the two dances. Spread the Good News to all. Swerve Dance & Fitness Complex 640 Lakeview Plaza Blvd A, Worthington, OH 43085 Bachata 7pm-8pm Salsa 8pm-9pm $15 - One Lesson $20 - Both Lessons

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

We thought of one of the interesting things that can be enjoyed at this time of the year. We will be meeting at Immaculate Conception Catholic Church for a "Fish Fry" in Marian Hall on Friday, March 27th at 5:00 PM. It might be fun for you to experience what has become a tradition on the Fridays before Easter. They will have fried fish or baked fish, French fries and Cole slaw, as well as beverages, all for $16.00 for adults. They will have other beverages and desserts available for sale, as well. We have never tried this, and sometimes there are quite a few people at these events so we hope that we will be able to find each other easily. I'll try to have signs outside Marian Hall that Identify our group. We hope to have you join us!

**Important time note:** Please plan on arriving between 5:30 and 6:00 as the elevators lock after 6 and you'll need to message us and we'll need to come get you. The building address is 4450 Bridge Park The entrance is 6620 Mooney St, Suite 400 **Abstract** TBD **YouTube Link** TBA