Introduction to SQL for Banking and Financial Case Studies
Learn essential SQL skills for banking and finance through hands-on case studies, building on a SQLite database. Gain practical knowledge to kickstart your data analysis journey in the financial sector.
Introduction to SQLite - CSV to SQLite Import
Learn to import CSV data into SQLite databases efficiently using Python, with practical examples for financial data management in banking contexts.
Dataclasses in Python 3.7 - Implementation and Usage
Learn to implement and utilize Python 3.7's dataclasses feature, enhancing code efficiency with automatic special method generation for user-defined classes.
Automated Research: Extracting Companies from PDF and Googling Them Using PyPDF2 and Regex - Python Tutorial
Extract company names from PDFs and automate research using Python, regex, and web browsing. Ideal for beginners looking to streamline data extraction and analysis tasks.
Making a Sci-Fi Game with Cohere LLM and Stability AI - Generative AI Tutorial
Learn to create a unique sci-fi game world using Cohere's language model and Stability AI's text-to-image models. Explore generative AI for world-building and game development.
Use Less For-Loops, Use More Vectorization - Improving Code Efficiency
Optimize Python code by replacing for-loops with vectorization techniques, improving efficiency and speed while maintaining readability and functionality.
Creating Rolling Sum Grouped by ISO Weeks Using Python - No Pandas Required
Learn to implement weekly rolling sums using Python's standard library, exploring itertools' groupby, enumerate, and isocalendar. Enhance your data manipulation skills without relying on external libraries like pandas.
Python Code Refactoring - Writing Modular Functions
Explore techniques for refactoring monolithic Python functions into smaller, modular, and testable units. Learn mental models for writing maintainable and predictable code.
Creating a Voting Ballot Smart Contract with Brownie and Solidity - Part 5
Implement a voting smart contract using Solidity and Brownie, covering key ballot functionalities with 100% test coverage. Learn about structs and complex contract features.
TaskWarrior Command Line Productivity Scoreboard - Build with Python
Build a CLI productivity scoreboard for TaskWarrior using Python's standard libraries. Learn data manipulation techniques without external dependencies like pandas or numpy.
Building a Production-Ready Python CLI: Colorful Terminal, Argparse, and Package Structure
Learn to refactor Python code for production, adding color to CLI outputs, modularizing layout, implementing argparse, and creating a verbose mode using only the standard library.
Submitting Your First Pull Request: GitHub Actions, Unit Tests, and Coverage
Learn to contribute to open source by submitting your first pull request, using GitHub Actions for CI/CD, and understanding unit tests and coverage in this practical guide.
Django and Django REST Framework - API Development for Absolute Beginners
Learn to build APIs with Django and Django REST Framework, covering setup, models, serializers, views, and authentication for beginners.
Learning Django 3.2 from Scratch - August 2021
Learn to build a Django app from scratch, covering workflow, database management, and migrations, with insights on creating API services using Django Rest Framework.
Web Development Using Bootstrap 5 - Building a Stock Portfolio App
Learn to create a responsive stock portfolio app using Bootstrap 5, covering UI/UX principles and essential web development skills with HTML and CSS.
Alternatives to Modern Programming Languages - Causal Islands Podcast Episode 3
Explore the creation of Arabic and Cree programming languages with experts, discussing challenges, cultural implications, and innovative approaches to non-Latin alphabet-based coding.
Building Humane User Interfaces with Language Models
Explore how AI can revolutionize human-computer interaction, moving beyond text-based interfaces to create more intuitive and user-friendly experiences.
Fission CLI and Webnative SDK Demo - Authentication, Files, and Database Features
Explore Fission's developer tools: CLI for streamlined workflows and Webnative SDK for authentication, file management, and upcoming database features.
Artificial Intelligence, Games, Metaverse and the Future of Civilization
Explore the impact of generative AI on game development and its broader implications for human civilization, creativity, and empowerment in the evolving metaverse landscape.
Java 21 New Feature: Sequenced Collections
Explore Java 21's Sequenced Collections feature, enhancing the Collections Framework with defined encounter order and direct access to first/last elements. Learn API architecture, behavior, and implementation details.
Build a Random Quote Machine with Nextjs, PlanetScale MySQL, and Drizzle ORM
Learn to build a random quote machine using Next.js, PlanetScale MySQL, and Drizzle ORM. Set up a database, connect with Drizzle ORM, and create a Next.js frontend with API routes for a full-stack application.