CBSE Class 12 Informatic Practices Databases and SQL

Read and download CBSE Class 12 Informatic Practices Databases and SQL chapter in NCERT book for Class 12 Informatics Practices. You can download latest NCERT eBooks for 2022 chapter wise in PDF format free from This Informatics Practices textbook for Class 12 is designed by NCERT and is very useful for students. Please also refer to the NCERT solutions for Class 12 Informatics Practices to understand the answers of the exercise questions given at the end of this chapter

Databases And Sql Class 12 Informatics Practices NCERT

Class 12 Informatics Practices students should refer to the following NCERT Book chapter Databases And Sql in standard 12. This NCERT Book for Grade 12 Informatics Practices will be very useful for exams and help you to score good marks

Databases And Sql NCERT Class 12


Learning Objectives

After studying this lesson the students will be able to:

  Define the terms:

     (i) Group (Aggregate) functions, Constraints

     (ii) Cartesian Product, Join, Referential Integrity, Foreign Key.

  Write queries using aggregate functions and GROUP BY clause.

  Access data from multiple tables

  Create tables with PRIMARY KEY and NOT NULL constraints

  Add a constraint to a table, remove a constraint from a table, modify a   column of a table using ALTER TABLE command.   Delete a table using DROP TABLE.In the previous class, you have learnt some database concepts and SQL commands. You have also learnt how to create databases and tables within databases and howto access data from a table using various clauses of SELECT command. In this chapter you shall learn some more clauses and functions in SQL to access data from a table and how to access data from multiple tables of a database. It was Iftar party in Lucknow that Mr. David met Mr. Naqvi. They became friends and exchanged their phone numbers. After a few days, Mr. David rang up and invited Mr. Naqvi for New Year party at his house and gave him his house number as follows: "I live in a long street. Numbered on the side of my house are the houses one, two, three and so on. All the numbers on one side of my house add up to exactly the same as all the numbers on the other side of my house. I know there are more than thirty houses on that side of the street, but not so many as 50." With this information, Mr. Naqvi was able to find Mr. David's house number. Can you also find?

Such situations are faced by the developers of RDBMS software where they have to think of retrieval of data from multiple tables satisfying some specified conditions. Let us now move ahead with SQL and more database concepts.

Please refer to the link below for - CBSE Class 12 Informatic Practices Databases and SQL



Click to View or Download pdf file
Click for more Informatics Practices Study Material

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

CBSE notification 40/2021 Innovation Ambassador Program

This is with reference to CBSE Notification No. 40/2021 dated 04.05.2021 regarding the Innovation Ambassador program – An online training program for teachers by CBSE in collaboration with Ministry of Education’s Innovation Cell (MIC) and AICTE. In view of the current...

Class 10th and 12th Term 2 Revaluation Process 2022

Evaluation of the Answer Books is done under a well-settled Policy. To ensure that the evaluation is error free, CBSE is taking several steps. After strictly following these steps, the result is prepared. Though, CBSE is having a well-settled system of assessment,...

All India Children Educational Audio Video Festival

The Central Institute of Educational Technology (CIET), a constituent unit of National Council of Educational Research and Training (NCERT), is inviting entries for the 26th All India Children’s Educational Audio Video Festival (AICEAVF). This festival showcases the...

Pariksha Pe Charcha 2022

The 5th edition of Pariskhas Pe Charcha the unique interactive program of Hon’ble Prime Minister with students teaches and parents will be held through virtual mode in February, 2022. In order to select participants who will be featured in Pariksha Pe Charcha programme...

Board Exams Date Sheet Class 10 and Class 12

Datesheet for CBSE Board Exams Class 10  (Scroll down for Class 12 Datesheet) Datesheet for CBSE Board Exams Class 12

Online courses for classes XI and XII offered by NCERT

Ministry of Education (MoE), Government of India has launched a platform for offering Massive Open Online Courses (MOOCs) that is popularly known as SWAYAM (Study Webs of Active learning for Young Aspiring Minds) on 9 th July, 2017. NCERT now offers online courses for...