Structured Query Language (sql)
Muhtasari
A database with a million records is useless unless you can ask it a question and get the four rows you actually wanted. The language for asking is SQL, and its central idea is unusual for a programming language: you describe what you want rather than how to find it. You do not write a loop over a million records. You say which fields, from which tables, matching which condition, and the database works out the rest.
This lesson covers the commands the specification names. You will learn to retrieve data with SELECT, FROM and WHERE, including queries that draw on two tables at once; to add a record with INSERT INTO; and to edit and delete data with UPDATE and DELETE FROM. You will also learn the single most consequential detail in the whole topic, which is what happens to an UPDATE or a DELETE that is missing its WHERE clause.
Malengo
- Be able to use SQL to retrieve data from a relational database, using the commands:
- SELECT
- FROM
- WHERE. Be able to use SQL to insert data into a relational database using INSERT INTO. Be able to use the SQL commands UPDATE and DELETE FROM to edit and delete data in a database.
Ramani ya mawazo
Mada hii imechorwa ili uone jinsi mawazo yanavyounganika.
Fungua ramani ya mawazo kwenye programu
Maelezo ya Somo
Dokezo Kamili la Somo Linapatikana kwenye Programu ya Green Bridge
Pata programu ya Green Bridge CBT kwenye simu au kompyuta yako kwa maktaba kamili ya IGCSE: mitihani ya miaka iliyopita, miongozo ya usahihishaji, ramani za mawazo, kadi za marudio na masomo ya sauti.
Tathmini ya Somo
Hongera kwa kukamilisha somo la Structured Query Language (sql). Sasa kwa kuwa umechunguza dhana na mawazo muhimu, ni wakati wa kuweka ujuzi wako kwa mtihani. Sehemu hii inatoa mazoezi mbalimbali maswali yaliyoundwa ili kuimarisha uelewaji wako na kukusaidia kupima ufahamu wako wa nyenzo.
Utakutana na mchanganyiko wa aina mbalimbali za maswali, ikiwemo maswali ya kuchagua jibu sahihi, maswali ya majibu mafupi, na maswali ya insha. Kila swali limebuniwa kwa umakini ili kupima vipengele tofauti vya maarifa yako na ujuzi wa kufikiri kwa makini.
Tumia sehemu hii ya tathmini kama fursa ya kuimarisha uelewa wako wa mada na kubaini maeneo yoyote ambapo unaweza kuhitaji kusoma zaidi. Usikatishwe tamaa na changamoto zozote utakazokutana nazo; badala yake, zitazame kama fursa za kukua na kuboresha.
- Which SQL clause states which records a query should return? A. SELECT B. FROM C. WHERE D. INSERT INTO Answer: C
- Which query correctly finds the names of all cats and all birds in a table called Pet? A. SELECT Name FROM Pet WHERE TypeOfAnimal = 'Cat' AND TypeOfAnimal = 'Bird' B. SELECT Name FROM Pet WHERE TypeOfAnimal = 'Cat' OR TypeOfAnimal = 'Bird' C. SELECT Name FROM Pet WHERE TypeOfAnimal = Cat OR Bird D. SELECT Name FROM Pet WHERE TypeOfAnimal = 'Cat' OR 'Bird' Answer: B
- What does the statement DELETE FROM Booking do if it has no WHERE clause? A. Nothing, because a WHERE clause is required B. It deletes the first record only C. It deletes every record in the Booking table D. It deletes the Booking table's field names Answer: C
- Which command is used to change the value already stored in a field? A. SELECT B. INSERT INTO C. UPDATE D. DELETE FROM Answer: C
- In a query drawing on two tables, what is the purpose of a condition such as Pet.PetID = Appointment.PetID? A. It sorts the results into order B. It matches each record in one table with the correct record in the other C. It deletes records that appear in both tables D. It renames a field Answer: B
Fanyia kazi maswali haya kwenye programu
Fanyia kazi maswali haya kwenye programu
Vitabu Vinavyopendekezwa
Fanya Mazoezi ya Maswali ya Majaribio
Ungependa kufanya mazoezi ya maswali ya majaribio kuhusu Structured Query Language (sql)? Pakua programu ya Green Bridge CBT ili kupata maswali ya majaribio na tathmini kamili za mazoezi kuhusu mada hii.
Pakua Programu Kwenye Google Playstore
Kila kitu unachohitaji ili kufaulu katika JAMB, WAEC & NECO.
