MySQL

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

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.

**PLEASE READ THE FOLLOWING IMPORTANT NOTES:** 1. The dates for this series are simply placeholders at the moment. We are working on our 2026 schedule, and adjustments are forthcoming. 2. Each class in this series has an attendance fee. 3. Each class from BOTH a sign-up and fee perspective is a separate entity. **Introduction:** Our Page Building with Bricks web development class provides detailed instruction for using Bricks Builder, a visual site builder for WordPress, to create and manage websites. Widely considered by many of the world's leading web developers to be the most complete page builder on the market today, Bricks Builder offers a wide range of features and comprehensive tools. Our Bricks Builder web development class provides detailed instructions on utilizing the toolset. The series of courses covers the core features of Bricks Builder, enabling users to design and develop responsive, visually appealing websites. Moreover, the courses are oriented to reinforce a focus on professional, scalable web development. Throughout the series, we focus our page-building instruction on the semantic and structural integrity of the pages in a responsive world. By the end of the 10-class series, participants will have a fundamental understanding of proper web page and website development. **The breakdown of the 10-class series is as follows:** * Class 01 - Survey of Page Builders / What Bricksbuilder Does For You * Class 02 - Boxes, Boxes, Boxes / Sections / Containers * Class 03 - Static Units / Relative Units / Responsive Development And Math Functions * Class 04 - CSS Variables And DRY Development / Classes And Global Styling * Class 05 - CSS Grid And CSS Flexbox * Class 06 - Responsive Development / Breakpoints And Media Queries * Class 07 - Effective Use Of Color / Effective Use Of Images * Class 08 - Beginning To Think Dynamically / Using Templates And Components * Class 09 - Dynamic Styling / Data Attributes And Attribute Selectors * Class 10 - Pseudo Elements / Programmatically Styling With Pseudo Classes Throughout the class sessions listed above, we cover the following key areas of web development with Bricks Builder: * **Introduction to Bricks Builder Interface:** * Familiarization with the builder's layout, including the toolbar, panel, and canvas, and understanding how to navigate and interact with its various components. * **Visual Site Building:** * Techniques for creating layouts using Bricks' drag-and-drop interface, incorporating sections, rows, columns, and elements to build page structures. * **Styling and Design:** * Utilizing Bricks' styling options to customize elements, apply global CSS classes for consistent design, and leverage features like Flexbox and CSS Grid for responsive layouts. * **Dynamic Content and Custom Fields:** * Integrating dynamic content from custom post types and custom field plugins (like ACF, Meta Box) to build data-driven websites. * **Template Building:** * Creating and managing reusable templates for headers, footers, post type layouts, and other site-wide elements. * **Performance Optimization:** * Understanding how Bricks Builder contributes to fast-loading websites and implementing performance best practices. * **Advanced Features:** * Depending on the class level, it might delve into advanced topics such as conditional logic, interactions, and custom code integration to enable more complex functionality. The series aims to equip participants with the skills to efficiently build, customize, and maintain WordPress websites using Bricks Builder, catering to both beginners and experienced web developers.

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

**PLEASE READ THE FOLLOWING IMPORTANT NOTES:** 1. The dates listed for this series are about 95% reliable. We are completing our 2026 schedule as we speak, so minor adjustments are still occurring. 2. Each class in this series has an attendance fee, on a first-come, first-served basis. 3. Each class, from BOTH a sign-up and fee perspective, is a separate entity. **Introduction:** **The breakdown of the four-class series is as follows:** **Class 1: Introduction to Web Styling and Basic CSS3** **Class 2:** **Class 3:** **Class 4:** **Class 5:** **Class 6:**

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

Come out to Improving for our monthly iOS and Mac meetings. This Month's Presentation: Nothing yet. (You should volunteer). What is Cocoaheads (http://cocoaheads.org/)? CocoaHeads is a group devoted to discussion of Apple Computer's Cocoa Framework for programming on MacOS X and iOS (including the iPhone, iPad and Apple Watch). During monthly meetings, members present on their projects and offer tutorials on various programming topics. What is BuckeyeCocoa (http://buckeyecocoa.org/)? BuckeyeCocoa is a group of Objective-C/Swift developers/enthusiasts. We host monthly Cocoaheads and near-weekly NSCoder meetings in Columbus, Ohio. The meetings are free to attend. Presentations! Presenters welcome! We are always in need of people willing to present material. Any Swift and/or Objective-C related topic is welcome. Times can be 5 minutes (i.e. lightning talks) to a maximum of 2 hours. Interested? Contact info is on the BuckeyeCocoa website. To volunteer for a presentation contact us at @BuckeyeCocoa on Twitter. Follow us on Twitter! @BuckeyeCocoa (https://twitter.com/#!/Buckeyecocoa/) For more information: http://buckeyecocoa.org/