Scribd
Upload
2 views7 pages

SQL File Merged

This certificate confirms that Ali Humza Malik has completed the SQL Practical File for Class XII, which includes 20 queries covering essential SQL concepts. The work was supervised by Mr. Prashant Kumar and has been evaluated as original and satisfactory. The practical file demonstrates proficiency in various SQL operations necessary for senior secondary education.

Uploaded by

thenics943
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
2 views7 pages

SQL File Merged

This certificate confirms that Ali Humza Malik has completed the SQL Practical File for Class XII, which includes 20 queries covering essential SQL concepts. The work was supervised by Mr. Prashant Kumar and has been evaluated as original and satisfactory. The practical file demonstrates proficiency in various SQL operations necessary for senior secondary education.

Uploaded by

thenics943
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

CERTIFICATE

This is to certify that Ali Humza Malik, a student of Class XII, has successfully
completed the SQL Practical File containing 20 queries as per the prescribed
curriculum for the academic session. The file includes a well-organized set of SQL
queries based on important concepts such as database creation, table creation,
insertion of records, selection queries, sorting and filtering (WHERE, ORDER BY),
aggregate functions (SUM, AVG, COUNT, MAX, MIN), grouping (GROUP BY,
HAVING), and other essential operations required at the senior secondary level.

The work has been carried out diligently under the guidance and supervision of
Mr. Prashant Kumar. The practical file has been checked and found to be original,
neatly presented, and satisfactory in terms of content, correctness, and
understanding of SQL commands.

_________________________ _________________________
Teacher’s Signature Examiner’s Signature
1) Creating and Using Database:

2) Creating a Table:

3) Table Description:

4) Inserting a record into table:


5) Inserting Multiple Values into Table:

6) Displaying All from Table:

7) Displaying Few fields from Table:

8) Displaying Filtered Records From Table:


9) Displaying records using pattern match

10) Displaying Records sorted by a field:


11) Displaying records using multiple filter criteria:

12) Displaying records by a distinct field:

13) Displaying Values using aggregate functions:


14) Updating record using a field filter:

15) Deleting record from a Table:

16) Altering Table Definition:

17) Using Aggregate Function with WHERE:

18) Displaying records Groupped by a field name:


19) Displaying records using Having and Group By Clause:

20) Displaying Records From TWO DIFFERENT TABLES using a common


field:

You might also like