📄️ Normalization
Normalization is a systematic approach in relational database design that organizes data to minimize redundancy and dependency.
📄️ Accessing data
1. Retrieve company details:
📄️ SELECT Queries
1. Retrieve top 10 most expensive products:
📄️ Accessing Multiple Tables
JOIN
📄️ Subqueries
1. Average Freight for Specific Employee:
📄️ Database Design
High Level Database Model
📄️ DDL (for MyShop)
1. Create Schema:
📄️ DML (for MyShop)
1. Insert a Product:
📄️ Views
1. Create a View for Products with Quantity Greater than 20:
📄️ Database administration
DCL
📄️ Functions & Stored procedures
Functions