Database Development

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.

The March Ohio North Database Training user group meeting will be held on **March 3rd, 2026 at 5:00PM**. This will be a **HYBRID** event and we will be joined in person by **Sam Nasr**. You're welcome to come meet in-person at our meeting location, the offices of Improving at **[6000 Freedom Square Dr,](https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D)** **[Unit 110,](https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D)** **[Independence, OH 44131](https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D)** [Teams Link ](https://teams.microsoft.com/l/meetup-join/19%3ameeting_YTg3MTY3NzItODI3OS00MTRjLTgzYTItYTBlMjY5NTQ5MzU4%40thread.v2/0?context=%7b%22Tid%22%3a%22b966f302-6b93-4686-9041-c084635642c5%22%2c%22Oid%22%3a%2278c760cb-657f-46aa-bd2f-7066d9403bdb%22%7d)if anyone needs it after RSVP-ing for in person. If you would like to subscribe to our email list outside of Meetup, we have changed platforms recently and you will need to register [here in Kit ](https://ohio-north-data-training.kit.com/b8f036f615)instead to receive emails. Agenda: **5:00 PM EST**: Online and in-person meeting begins with a social hour. This is an unstructured hour where you can join us to catch up and meet other group members before the session starts. There will be food brought in for in-person attendees. **6:00 PM EST**: Updates and announcements, followed by our feature presentation. See below for presentation details. **7:30 PM EST**: Optionally after the main presentations, the in-person crowd may go out for snacks and drinks at a local establishment. We hope to see you there! Session Abstract ### **Data Cleansing using Data Bricks** Machine Learning is highly dependent on adequate data. Not only does quantity matter, but more importantly quality. In this session we’ll cover how to build a custom automated process using Data Bricks. This will provide methods for cleaning data in a data lake using functions in Azure. \*Please note, that we will be using Microsoft Teams for the online portion of this meeting. You may want to join a few minutes early to ensure you do not have any issues. If you are attending in person, there are large TVs at the office, and you do not need to bring a laptop or use Teams.

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

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

Columbus Code & Coffee is an inclusive, informal co-working session. People of all skill levels attend, and we love it that way. Many people (optionally) bring projects to work on, and many other people (optionally) socialize the entire time. It's entirely up to you! **What to Expect at the Intro Circle** \~\~\~\~\~\~\~\~\~\~\~\~\~ Near the beginning of the event (1:30 pm), we do a standup: * Organizer announcements, updates, and logistics Round 1 - (7 secs max): * Your name * What you're working on * What you can help others with Round 2: * Community events you wanna plug. If none, that's cool too. Round 3: * Job opportunities you're hiring for OR announce that you are looking for one. If none, that's cool. After the introduction circle, everything is self-organized! Feel free to work alone, pair up, attend one of our workshops/presentations, or mingle!

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

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