MALUMOTLAR BAZASI FANIDAN 2-Amaliy ish.

MALUMOTLAR BAZASI FANIDAN 2-Amaliy ishi mavzulari (

1.1. INNER JOIN

1.2. LEFT JOIN

1.3. RIGHT JOIN

1.4. CROSS JOIN

2.1. Agregat funksiyalar (COUNT, SUM, AVG, MAX, MIN)

2.2. GROUP BY va HAVING

2.3. Matn (String) funksiyalar

2.4. Sana (Date) funksiyalar

2.5. Matematik funksiyalar

3.1. Oddiy INDEX yaratish

3.2. UNIQUE INDEX yaratish

3.3. INDEX ko'rish va o'chirish

4.1. VIEW yaratish — CREATE VIEW

4.2. VIEW dan foydalanish — SELECT

4.3. VIEW o'chirish — DROP VIEW

5.1. Funksiya yaratish — CREATE FUNCTION

5.2. Funksiyadan foydalanish

5.3. Funksiyani ko'rish va o'chirish va xulosa.)