SQL क्या है ?

 SQL का full form Structured Query Language है। इसके S-Q-L या कभी-कभी See-Quel भी पढ़ा जाता है। यह एक प्रकार का लैंग्वेज है जिसका उपयोग database management में किया जाता है।
इस query language के जरिये ही डेटाबेस पर create, insert, search, update, delete जैसे operation perform किये जाते हैं।

उदहारण के लिए हमारे पास student नाम का कोई टेबल है और हम ऐसे students का नाम देखना चाहते हैं जिनकी उम्र 20 साल से कम हो तब इसका syntax कुछ इस प्रकार होगा: SELECT name From students WHERE age < 20 जहाँ पर "name" एक कॉलम का नाम है और "students" एक टेबल का नाम है।
ऐसे ही हर प्रकार के operation के लिए SQL में अलग-अलग code निर्धारित किये गये हैं। इस language के माध्यम से कुछ कोड लिखे जाते हैं और डेटाबेस में insert, update, delete जैसे operations perform किये जाते हैं।

Comments

Post a Comment

Popular posts from this blog

Microorganisms Friend And Foe - Worksheets

Image
CBSE Worksheet-01 Class–VIII Science (Microorganisms : Friend and Foe) Low temperature prevents spoilage of food because it :- Retards microbial growth Inactivates enzymes Both a & b Removes water from food materials Which of the following is found to be present in curd? Lactobacillus Rhizobium Lactovirus Lactococcus In the given picture the microbe responsible for the spoilage is a :- Virus Protozoa Bacteria Fungus The microorganism used in preparation of bread is :- Yeast Adenovirus Penicillium Blue green algae Match the column :- Disease Transmission by a. Dengue i) Infected dog’s bite b. Hepatitis B ii) Contact c. Food poisoning iii) Contaminated water d. Rabies iv) Carrier Aedes mosquito bite e. Small Pox v) Contaminated food Fill in the blanks:- ______ are preserved by the use of oil and vinegar. ______ is the process of heat and cold treatment for preserving milk. ______ is a dangerous form of food poisoning. ______ is the oldest method of food preservation. Jellies, squashe...
Read more

The Fight - Worksheets

CBSE Worksheet 01 The Fight What was Ranji afraid of when he reached home at the end of the first day? Answer in the context of The Fight. What surprises the warrior? Answer in the context of  The Fight. What is it that Ranji finds difficult to explain at home? How did Ranji and the stranger introduce themselves to each other? Between Ranji and the other boy, who is trying to start a quarrel? Give a reason for your answer. What surprise did Ranji discover after a month in Rajpur? Narrate the episode of the fight between Ranji and Suraj in the forest in about 100-125 words. What does  pehelwan  mean? In what ways could Suraj help Ranji become one? CBSE Worksheet 01 The Fight Solution He was highly afraid as he was thinking lest his parents should come to know about the violent fight. The warrior is surprised at the clean dive which Ranji had executed. There are many cuts and bruises on Ranji’s face and arms. Ranji finds it difficult to explain them at home. The s...
Read more

Visualising Solid Shapes - Solutions 1

Image
CBSE Class –VIII Mathematics NCERT Solutions CHAPTER - 10 Visualising Solid Shapes (Ex. 10.1) 1. For each of the given solid, the two views are given. Match for each solid the corresponding top and front views. The first one is done for you. Ans. (a)    (iii)   (iv) (b)    (i)     (v) (c)   (iv)   (ii) (d)   (v)    (iii) (e)   (ii)    (i) 2. For each of the given solid, the three views are given. Identify for each solid the corresponding top, front and side views. Ans. (a)    (i)   Front (ii)   Side (iii)   Top view (b)   (i)   Side (ii)   Front (iii)   Top view (c)   (i)   Front (ii)   Side (iii)   Top view (d)   (i)   Front (ii)   Side (iii)   Top view 3. For each given solid, identify the top view, front...
Read more