Multi-Tenant Backup Script with Sergey Lisitsin | Learn To Code Using AI Course

Every day, 3-4 people at an MSP spent their entire morning clicking through a GUI just to confirm customer devices were backed up… ~35 lines of code changed that. In this friendly conversation between Sergey Lisitsin, a network automation engineer, and Erika Dietrick, a software engineer, we walk you through Sergey's approach to multi-tenant device backup automation using Python and a SQL query. IN THIS VIDEO... 00:13 Introducing Sergey and his background 01:11 The story of why Sergey created this script 03:28 Sergey's approach to writing this script 04:46 Sergey's past experience with SQL (if any) 05:25 How Sergey became a network automation wiz 08:22 We walk through Sergey's script 08:29 Libraries/modules used: argv, datetime, psycopg2 09:28 Why you might use argv 10:13 Using an f string, introducing the SQL query 11:05 How he connected to device database & ran his query 11:49 Printing the results and formatting them 13:32 How did you know what libraries to use? 15:22 I walk back through this script section-by-section 15:56 Python help( ) function 19:41 We actually run the script and see the result 20:40 How he formatted his print statements, including alignment markers 22:36 Breaking down how he organized the script 22:59 Using dynamic values in your SQL query 23:40 Creating an object (we just crashed into this, will make another vid) 26:42 Explaining how to use the Python interactive shell 32:02 When it makes sense to use the Python interactive shell 32:38 The advice Sergey would give folks to network automation 35:18 Options for testing your scripts 38:23 Considerations for code readability 39:34 Where to check out Sergey's work SERGEY'S LINKEDIN   / sergey-lisitsin-42115816   COURSE DESCRIPTION Network engineers need automation skills, but learning to code is boring, time-consuming, and abstract. Right? ...In this YouTube course, I teach coding skills in the age of AI and ever-pressing cybersecurity threats, leveraging the many conversations and insights I gained as a former developer advocate at Cisco Systems. After all... the greatest barrier I've seen to automation outreach efforts is the blatant overlooking of the glaringly obvious: many network engineers just don't know how to code yet (or how to solve problems with code), and they don't have the right resources to get them there. This course is not for showboating my skills; it's for practically addressing coding skills in a way that's not off-putting and leaves you eager to continue learning. Piggybacking off of DEVNET-2720, my most recent Cisco Live presentation, I've initially divided this course into 3 levels: Level 1: Foundational skills (critical thinking skills) you NEED to know before using AI Level 2: Guided AI use and instructions to drastically speed up your learning journey Level 3: Guided code generation using AI coding assistants, including the do's and the don'ts In a currently drafted and undisclosed Level 4, I'll start guiding you through more advanced content HOW TO SUPPORT [[ contact via LinkedIn/TikTok/Substack DMs ]] 🔁 SHARE these videos to help us unlock fan monetization on YouTube 🙋‍♂️ VOLUNTEER to be a guest in one of her coding videos (both novice & expert welcome) 📖 SUBSCRIBE to Substack on underdiscussed tech topics 🎤 HOST Erika on your podcast to promote her free coding courses 🤝 HIRE Erika to teach workshops at your company or university LinkedIn: / erikadietrick TikTok: / erika_thedev Substack: https://erikathedev.substack.com/ ABOUT THE YOUTUBER ERIKA DIETRICK is a software engineer, technical content creator, and former Developer Advocate at Cisco Systems in North Carolina, USA. Her six years of experience ranges from network to software engineering across Fortune 100s and startups alike; she has found herself in the cybersecurity space for most of that time. She holds CCNA and DevNet Associate certifications as well as a Master of Software Engineering from East Carolina University. You can follow her on most social media platforms @erika_thedev.