MySQL & Relational Databases (SQL)

-- 1. Create Students Table Schema
CREATE TABLE students (
    id INTEGER PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    course VARCHAR(100),
    enrolled_date DATE
);

-- 2. Insert Initial Records
INSERT INTO students (id, name, email, course, enrolled_date) VALUES 
(1, 'Ankit Baruah', 'ankit@example.com', 'Web Dev with AI', '2026-01-15'),
(2, 'Dimple Kalita', 'dimple@example.com', 'Flutter Mobile Apps', '2026-02-01'),
(3, 'Manash Sharma', 'manash@example.com', 'Digital Marketing', '2026-02-10');

-- 3. View All Students
SELECT * FROM students;