SQL Basics for Beginners | CURD Operations (CREATE SELECT INSERT UPDATE DELETE) Explained in Detail
This video briefs about the basics of SQL for Beginners, with basic knowledge on RDBMS Database. along with examples and syntax's for basic SQL statements have been showcased. In this video we have also shown how to execute the SELECT, CREATE, UPDATE, DELETE (CURD Operations)and ORDER BY Clauses in the SQL Server Database along with the explanation.
CURD = Create Update Read Delete Operations
Chapters:
0:00 Introduction / Overview
0:44 What is a Database ?
1:27 What is a Relational Database (RDBMS) ?
2:37 What is SQL ?
3:50 Syntax and Example for CREATE TABLE Statement
5:18 Executing a CREATE TABLE Statement in SQL Server
6:45 Syntax and Example for INSERT Statement
8:22 Executing a INSERT Statement in SQL Server
8:59 Syntax and Example for SELECT Statement
9:27 Executing a SELECT Statement in SQL Server
10:43 Syntax and Example for WHERE Clause
11:55 Executing a WHERE Clause Statement in SQL Server
12:27 Syntax and Example of UPDATE Statement
15:22 Executing a UPDATE Statement in SQL Server
16:25 Syntax and Example for DELETE Statement
17:29 Executing a DELETE Statement in SQL Server
18:37 Syntax and Example for ORDER BY Clause
19:13 Executing a ORDER BY Clause in SQL Server
For SQL Server Installation, Please watch this video : • How to Install SQL Server 2022 Database in...
For SQL Server Management Studio (SSMS) Installation and usage, please refer this video : • How to Install SQL Server Management Studi...
The SQL Statements used in this video are below.
/* CREATE TABLE STATEMENT FOR STUDENT TABLE */
CREATE TABLE STUDENT (
STUDENT_ID VARCHAR(10),
STUDENT_NAME VARCHAR(30) NOT NULL,
DEPARTMENT VARCHAR(50) NOT NULL
CONSTRAINT PK_STUDENT PRIMARY KEY(STUDENT_ID)
)
/* INSERT STATEMENTS FOR STUDENT TABLE */
INSERT INTO STUDENT (STUDENT_ID, STUDENT_NAME, DEPARTMENT)
VALUES ('1001','JERRY','ACCOUNTS')
INSERT INTO STUDENT (STUDENT_ID, STUDENT_NAME, DEPARTMENT)
VALUES ('1002','TOM','ACCOUNTS')
INSERT INTO STUDENT (STUDENT_ID, STUDENT_NAME, DEPARTMENT)
VALUES ('1003','MIKE','MECHANICAL')
/* SELECT STATEMENT FOR STUDENT TABLE */
SELECT * FROM STUDENT
/* WHERE CLAUSE STATEMENT FOR STUDENT TABLE */
SELECT
STUDENT_ID,
STUDENT_NAME,
DEPARTMENT
FROM STUDENT
WHERE STUDENT_ID = '1002'
/* UPDATE STATEMENT FOR STUDENT TABLE */
UPDATE STUDENT
SET DEPARTMENT = 'COMPUTER SCIENCE'
WHERE STUDENT_ID = '1002'
/* DELETE STATEMENT FOR STUDENT TABLE */
DELETE STUDENT
WHERE STUDENT_ID = '1001'
AND STUDENT_NAME = 'JERRY'
/* ORDER BY CLAUSE STATEMENT FOR STUDENT TABLE */
SELECT
STUDENT_ID,
STUDENT_NAME,
DEPARTMENT
FROM STUDENT
ORDER BY STUDENT_ID ASC
Do not practice these SQL statements on a production environment.
