Axborot texnalogiyalari universiteti

MUHAMMAD AL-XORAZMIY NOMIDAGI TOSHKENT
AXBOROT TEXNALOGIYALARI UNIVERSITETI
KIBERXAVFSIZLIK FAKULTETI DMB007-GURUH
TALABASI JUMANAZAROV LAZIZNING MA’LUMOTLAR
BAZASI FANIDAN BAJARGAN 1-MUSTAQIL ISHI
REJA;
1. KIRISH
2. MySQL DA FUNKSIYALAR va
ULARNING VAZIFALARI
3. XULOSA

1.KIRISH

1.KIRISH

MySQL - bu ma'lumotlarni saqlash, boshqarish va olish

uchun keng qo'llaniladigan ochiq manbali relyatsion

ma'lumotlar bazasini boshqarish tizimi (RDBMS). Bu eng

mashhur va tez- tez ishlatiladigan ma'lumotlar bazasi

tizimlaridan biridir.

MySQL jadvallar yordamida ma'lumotlarni tuzilgan tarzda

saqlash usulini taqdim etadi. Bu sizga ma'lumotlaringizni

ifodalash uchun turli ustunlar va ma'lumotlar turlariga ega

jadvallarni belgilash imkonini beradi.

Database yaratish

database dan foydalanish rejimiga o'tish va table yaratish

• database dan foydalanish rejimiga o'tish va table yaratish
•  

Ma'lumotlar qo'shish

Ma'lumotlar qo'shish

select number, upper(type) from room where floor < 3;

• select number, upper(type) from room where floor < 3;

select number, upper(type) from room where floor < 3;

select number, upper(type) from room where floor = 3;

• select number, upper(type) from room where floor = 3;

select number from room where (type != 'business' and type != 'premium');

select number from room where not floor = 5;

• select number from room where not floor = 5;
•  

select number, type from room where number between 200 and 400;

select floor, count(*) as count_of_rooms from room group by floor;

• select floor, count(*) as count_of_rooms from room group by floor;

select number, max_occupancy from room order by max_occupancy;

select number, max_occupancy from room order by max_occupancy desc;

• select number, max_occupancy from room order by max_occupancy desc;

select number, max_occupancy, type from room having type = 'business';

• XULOSA:

Xulosa qilib aytganda, MySQL - bu ma'lumotlarni samarali boshqarish uchun keng imkoniyatlarni taklif qiluvchi kuchli va ko'p qirrali relyatsion ma'lumotlar bazasini boshqarish tizimi.
MySQL o'zining keng imkoniyatlari bilan kichik hajmdagi
loyihalardan tortib yirik korporativ tizimlargacha bo'lgan turli ilovalar uchun ishonchli tanlov ekanligini isbotlaydi. Uning ochiq manbali tabiati va keng qo'llanilishi uni ishlab chiquvchilar va biznes uchun mashhur ma'lumotlar bazasi yechimiga aylantiradi.