(
встроенный
)
. SQL ning bu 2 turi ishlashi
bir hil, lekin har xil joyda ishlatiladi.
Interaktiv SQL deganda — ma'lumotlar bazasiga so'rov orqali murojaat qilib, shu zahoti
natijani olish tushuniladi. Ya'ni bunda ketma-ketlik asosida jarayon sodir bo'ladi. So'rov-natija
rejimda ishlaydi.
O'rnatilgan SQL deganda – so'rovlar yig'indisi biror dasturlash tilida ishlatilishi tushuniladi.
Pascal, Delphi, Java tillarida bazaga murojaat qilib, natijani biror o'zgaruvchiga yuklab
qo'yamiz va kerakli joyda bu natijani ishlatamiz. Ya'ni bunda so'rov berib, darhol natijani
ILM-FAN VA INNOVATSIYA
ILMIY-AMALIY KONFERENSIYASI
in-academy.uz/index.php/si
73
ololmaymiz. Natija faqat dasturning davom etishi uchun olinadi va talab etilgan joyda
ishlatiladi.
SQl operatorlari bir necha guruhlarga bo'lingan. Bu bo'linish operatorlarning bajarilish
vazifasi asosida bo'lingan. Ular quyidagilar:
DDL(Data Definition Language) , ANSI bu guruh SDL(Schema Definition Language) deb
ataladi. Bu guruhga ma'lumotlar bazasida ob'ektlar(jadvallar, indekslar)ni hosil qiluvchi
operatorlar kiradi.
DML(Data Manipulation Language) – ma'lumotlarni manipulyatsiya qiluvchi operatorlar
yig'indisi guruhi. Istalgan vaqtda jadval ichida qanday ma'lumotlar saqlanayotganini
aniqlovchi operatorlar.
DCL(Data Control Language) – ma'lumotlarni boshqaruvchi operatorlar.
ANSI ning ruxsati bilan, DCL DDL ning bir qismi sifatida qaraladi. Bu guruhlarni
aralashtirmaslik zarur. Bular alohida tillar emas, balki SQL operatorlarining guruhlaridir.
Foydalanilgan saytlar ruyxati:
1.https://www.texnoman.uz/post/sql-structured-query-language-haqida.html -mavzuga doir
ma’lumotlar shu saytda mavjud.
2.Juraev, Muzaffarjon Mansurjonovich. "Prospects for the development of professional
training of students of professional educational institutions using electronic educational
resources in the environment of digital transformation." Academicia Globe: Inderscience
Research 3.10 (2022): 158-162.
3.Juraev, Muzaffarjon Mansurjonovich. "The value of open mass competitions in the process of
digitalization of extracurricular activities of schoolchildren." Web of Scientist: International
Scientific Research Journal 3.10 (2022): 338-344.
4.Jo‘rayev, Muzaffarjon. "Professional ta’lim jarayonida fanlararo uzvilik va uzliksizlikni
ta’minlash o ‘quvchilari kasbiy tayyorgarligining muhim omili sifatida." Zamonaviy dunyoda
amaliy fanlar: Muammolar va yechimlar 1.29 (2022): 43-46.
5.Juraev, M. M. "OA Qo ‘ysinov Description of the methodological basis for ensuring
interdisciplinary continuity of the subject “Computer Science and Information Technology” in
vocational education." JournalNX-A Multidisciplinary Peer Reviewed 7.10 (2021).
6.Mansurjonovich, Juraev Muzaffarjon. "Description of the Methodological Basis for Ensuring
Interdisciplinary Continuity of the Subject" Computer Science and Information TECHNOLOGY"
in Vocational Education." JournalNX 7.10: 223-225.
7.Khasanov, A. R. (2022). LEARNING IS A COMPETENCY-BASED APPROACH AS A CONTENT
UPDATE STEP. Galaxy International Interdisciplinary Research Journal, 10(12), 217-223.
8. Khasanov, A. R. (2022). Development of information competence of future informatics
teachers as a pedagogical problem. Open Access Repository, 9(12), 73-79.
9. Xasanov, A. R. (2021, May). USE OF MODERN PEDAGOGICAL TECHNOLOGIES AND
INTERACTIVE METHODS IN TEACHING COMPUTER SCIENCE. In E-Conference Globe (pp.
198-199).
10.Mansurjonovich, Juraev Muzaffarjon. "CURRENT STATUS OF THE SCIENCE OF
INFORMATICS AND INFORMATION TECHNOLOGIES IN THE PROFESSIONAL EDUCATION
SYSTEM, EXISTING PROBLEMS AND SOLUTIONS, PRINCIPLES AND CONTENT OF THE
|