SQL TILIDA SO‘ROVLAR YARATISH
Abstract
Ushbu maqolada zamonaviy ma’lumotlar bazasini boshqarish tizimlarida keng qo‘llaniladigan SQL (Structured Query Language) tili orqali so‘rovlar yaratish tamoyillari, asosiy buyruqlar va ularning amaliy qo‘llanilishi tahlil qilinadi. SELECT, INSERT, UPDATE, DELETE kabi buyruqlar va ularga bog‘liq WHERE, JOIN, GROUP BY kabi konstruktsiyalar yordamida samarali ma’lumot olish va boshqarish masalalari yoritilgan. Shuningdek, SQL so‘rovlarini optimallashtirish va real hayotdagi qo‘llanilishi haqida fikr yuritilgan.
References
1. Хармер Дж. The Practice of English Language Teaching. – 4-е изд. – Harlow: Pearson Longman, 2007. – 448 с.
2. Coronel, C., & Morris, S. Database Systems: Design, Implementation, and Management. – 13th ed. – Boston: Cengage Learning, 2018. – 784 p.
3. Бейли Б. SQL. Основы языка запросов. – Москва: БХВ-Петербург, 2017. – 336 с.
4. Хорстманн К. Основы SQL. – СПб: Питер, 2021. – 280 с.
5. Rob, P., Coronel, C. Database Principles: Fundamentals of Design, Implementation, and Management. – 9th ed. – Boston: Cengage Learning, 2015. – 720 p.
6. Silberschatz, A., Korth, H.F., Sudarshan, S. Database System Concepts. – 7th ed. – New York: McGraw-Hill, 2020. – 1376 p.
