SQL Made Easy for AI – Day 1

‍
Environment Setup and Basics
‍

Installation:

MySQL Community Addition:
https://dev.mysql.com/downloads/mysql/

MySQL Workbench

https://www.mysql.com/products/workbench/

‍

Queries Used:

CREATE DATABASE students;

‍

CREATE TABLE student_info (    
student_id INT PRIMARY KEY,    
name VARCHAR(50),    
email VARCHAR(100),  
enrollment_date DATE
);

‍

INSERT INTO students.student_info (student_id, name, email, enrollment_date)
VALUES (1, ‘Aparna Singh’, ‘aparna@gmail.com’, ‘2022-01-01’),
      (2, ‘Bharath Kumar’, ‘bharath@hmail.com’, ‘2022-01-02’);

‍

SELECT *
FROM student_info;