Scribd
Upload
24 views19 pages

Class12 SQL Database Project

The project titled 'SQL and Database' covers essential concepts of SQL, including syntax, commands, and data types. It provides practical examples of SQL operations such as creating tables, inserting data, and querying information. The project is submitted by a student from SARVOYDAYA CO-ED VIDAYALAYA No. 1 SHAKTI NAGAR and acknowledges the support of teachers and peers.

Uploaded by

sinhapiyushraj3
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
24 views19 pages

Class12 SQL Database Project

The project titled 'SQL and Database' covers essential concepts of SQL, including syntax, commands, and data types. It provides practical examples of SQL operations such as creating tables, inserting data, and querying information. The project is submitted by a student from SARVOYDAYA CO-ED VIDAYALAYA No. 1 SHAKTI NAGAR and acknowledges the support of teachers and peers.

Uploaded by

sinhapiyushraj3
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 19

Class 12th Computer Science Project

Topic: SQL and Database

Submitted by: Your Name


Class: XII
School: SARVOYDAYA CO-ED VIDAYALAYA No. 1 SHAKTI NAGAR
Certificate

This is to certify that the project work titled "SQL and Database" has been

successfully completed by [Your Name] of class XII during the academic year. This

project is in accordance with the guidelines issued by CBSE for the subject of

Computer Science.

Signature of Teacher

Signature of Principal
Acknowledgement

I would like to express my sincere thanks to my Computer Science teacher for their

continuous support and guidance throughout this project. I am also grateful to my

school SARVOYDAYA CO-ED VIDAYALAYA No. 1 SHAKTI NAGAR for providing the

platform and resources. Lastly, I thank my parents and friends for their motivation and

encouragement.
Index
1. Introduction to SQL

2. What is a Database?

3. SQL Syntax

4. Data Types in SQL

5. CREATE TABLE command

6. INSERT INTO command

7. UPDATE command

8. DELETE command

9. SELECT statement

10. WHERE Clause

11. ORDER BY Clause

12. JOINS

13. GROUP BY Clause

14. SQL Functions

15. Project Summary


1. Introduction to SQL
SQL stands for Structured Query Language and is used to interact with databases.
2. What is a Database?
A database is an organized collection of data, generally stored and accessed electronically.
3. SQL Syntax
Basic SQL syntax includes keywords like SELECT, INSERT, UPDATE, DELETE, FROM, WHERE

etc.
4. Data Types in SQL
Common data types in SQL: INT, VARCHAR, DATE, FLOAT, BOOLEAN.
5. CREATE TABLE command
CREATE TABLE Students (ID INT, Name VARCHAR(50), Age INT);
6. INSERT INTO command
INSERT INTO Students (ID, Name, Age) VALUES (1, 'Rahul', 18);
7. UPDATE command
UPDATE Students SET Age = 19 WHERE ID = 1;
8. DELETE command
DELETE FROM Students WHERE ID = 1;
9. SELECT statement
SELECT * FROM Students;
10. WHERE Clause
SELECT * FROM Students WHERE Age > 18;
11. ORDER BY Clause
SELECT * FROM Students ORDER BY Name ASC;
12. JOINS
SELECT Students.Name, Marks.Score FROM Students JOIN Marks ON Students.ID =

Marks.StudentID;
13. GROUP BY Clause
SELECT Age, COUNT(*) FROM Students GROUP BY Age;
14. SQL Functions
SELECT COUNT(*), AVG(Age) FROM Students;
15. Project Summary
This project helped in understanding SQL commands and database operations practically.

You might also like