Скачать с ютуб CS50 SQL Final Project | Peer-to-peer Community Energy Trading System | HarvardX | edX в хорошем качестве

CS50 SQL Final Project | Peer-to-peer Community Energy Trading System | HarvardX | edX

This project was completed as part of CS50's Introduction to Databases with SQL, a course offered by Harvard University through HarvardX on the edX platform. In this 3-minute presentation, I demonstrate a Peer-to-peer Community Energy Trading System built using SQLite. The system enables users to register as producers, consumers, or prosumers, and trade renewable energy within a local microgrid. Skills Demonstrated in this SQL Project: Schema Design: Built a normalized schema with 7 interrelated tables Data Constraints: Enforced data integrity with primary keys, foreign keys and check constraints Views: Created views to simplify access to generation, storage and transaction data Triggers: Automated credit balance updates and history logging using triggers Indexes: Added indexes to improve query performance Subqueries & Aggregation: Used nested queries to compute latest logs and energy totals per user ACID Compliance: Ensured reliable and consistent energy trades through robust transaction management Real-world Modeling: Designed for a peer-to-peer energy trading system with producers, consumers, and prosumers Best Practices: Followed clean, maintainable, and scalable SQL practices throughout #CS50 #SQL #SQLite #EnergyTrading #Cleanenergy #HarvardX #edX #FinalProject