Community Picks·50wOnline SQL Playground for MySQL, PostgreSQL, and SQL Server
RunSQL is an online SQL playground designed for learning, testing, and sharing SQL queries for MySQL, PostgreSQL, and SQL Server. Users can easily create and manipulate database schemas using DBML, collaborate on SQL projects, conduct interviews, and create web-based database documentation without needing local database setup. It provides a shared environment tailored for developers and data analysts.
Medium·52wBuilding a modern Data Warehouse from scratch
Learn how to build a modern data warehouse using SQL Server. The project guides you through designing data architecture with Medallion Architecture, setting up ETL pipelines, developing data models, and creating data analytics and reporting solutions. Key steps include setting up project tools, implementing data quality checks, and creating bronze, silver, and gold layers for data processing and hierarchy. Resources and detailed instructions are provided for each phase.
Collections·46wBeginner's Guide to REST API Development with .NET 9 and ASP.NET Core
Learn to develop REST APIs using .NET 9 and ASP.NET Core through a comprehensive guide available on freeCodeCamp.org's YouTube channel. The course covers REST concepts, ASP.NET Core architecture, project structure, HTTP methods, and CRUD operations. It includes SQL Server integration and testing using built-in tools and Postman.