19 lines (14 loc) · 638 Bytes

Day 22: SQL — Views and Constraints

📘 Topics Covered

Creating and updating SQL Views
Applying Constraints: CHECK, NOT NULL, UNIQUE, PRIMARY/FOREIGN KEY
Use-cases for views (security, reuse, simplified queries)

📄 Scripts

Views: SQL/view.sql, SQL/updatingview.sql
Constraints examples: SQL/check.sql
Practice: SQL/agelimit.sql

🔗 References

SQL Views: https://www.sqltutorial.org/sql-views/
SQL Constraints: https://www.sqltutorial.org/sql-constraint/ SQL Views Todays conecept Normal View & Material View