Program kursa

7 Chapters · 23 Lessons

  1. 1

    UVOD

    1. (Included in full purchase)

      Uvod u SQL

    2. (Included in full purchase)

      Preuzimanje baze podataka

    3. (Included in full purchase)

      Instalacija MySQL Workbench

    4. (Included in full purchase)

      Uvod u bazu podataka

  2. 2

    FILTRIRANJE PODATAKA

    1. (Included in full purchase)

      Filtriranje podataka (USE, SELECT, SELECT *, SELECT FROM, SELECT DISTINCT)

    2. (Included in full purchase)

      Mini kviz: Filtriranje podataka

  3. 3

    LOGIČKE FUNKCIJE

    1. (Included in full purchase)

      Logičke funkcije (WHERE, OR, AND, NOT, BETWEEN, IN)

    2. (Included in full purchase)

      Logičke funkcije (LIKE)

    3. (Included in full purchase)

      Mini kviz: Logičke funkcije

  4. 4

    NUMERIČKE FUNKCIJE

    1. (Included in full purchase)

      Numeričke funkcije (GROUP BY, AS, COUNT, MIN, MAX, SUM)

    2. (Included in full purchase)

      Mini kviz: Numeričke funkcije

  5. 5

    GRUPISANJE PODATAKA

    1. (Included in full purchase)

      Grupisanje podataka (HAVING)

    2. (Included in full purchase)

      Grupisanje podataka (CASE, WHEN, THEN)

    3. (Included in full purchase)

      Grupisanje podataka (Kreiranje pivot tabele preko CASE)

    4. (Included in full purchase)

      Mini kviz: Grupisanje podataka

  6. 6

    SORTIRANJE PODATAKA

    1. (Included in full purchase)

      Sortiranje podataka (ORDER BY, DESC)

    2. (Included in full purchase)

      Mini kviz: Sortiranje podataka

  7. 7

    RAD SA VIŠE TABELA

    1. (Included in full purchase)

      Uvod u upite nad više tabela

    2. (Included in full purchase)

      Spajanje tabela (INNER JOIN, LEFT JOIN, LIMIT)

    3. (Included in full purchase)

      Spajanje tabela (RIGHT JOIN, FULL OUTER JOIN)

    4. (Included in full purchase)

      Kreiranje veza između tabela (BRIDGING)

    5. (Included in full purchase)

      Spajanje tabela (JOIN sa više uslova, UNION)

    6. (Included in full purchase)

      Mini kviz: Rad sa više tabela