Program kursa
-
1
UVOD
-
(Included in full purchase)
Uvod u SQL
-
(Included in full purchase)
Preuzimanje baze podataka
-
(Included in full purchase)
Instalacija MySQL Workbench
-
(Included in full purchase)
Uvod u bazu podataka
-
(Included in full purchase)
-
2
FILTRIRANJE PODATAKA
-
(Included in full purchase)
Filtriranje podataka (USE, SELECT, SELECT *, SELECT FROM, SELECT DISTINCT)
-
(Included in full purchase)
Mini kviz: Filtriranje podataka
-
(Included in full purchase)
-
3
LOGIČKE FUNKCIJE
-
(Included in full purchase)
Logičke funkcije (WHERE, OR, AND, NOT, BETWEEN, IN)
-
(Included in full purchase)
Logičke funkcije (LIKE)
-
(Included in full purchase)
Mini kviz: Logičke funkcije
-
(Included in full purchase)
-
4
NUMERIČKE FUNKCIJE
-
(Included in full purchase)
Numeričke funkcije (GROUP BY, AS, COUNT, MIN, MAX, SUM)
-
(Included in full purchase)
Mini kviz: Numeričke funkcije
-
(Included in full purchase)
-
5
GRUPISANJE PODATAKA
-
(Included in full purchase)
Grupisanje podataka (HAVING)
-
(Included in full purchase)
Grupisanje podataka (CASE, WHEN, THEN)
-
(Included in full purchase)
Grupisanje podataka (Kreiranje pivot tabele preko CASE)
-
(Included in full purchase)
Mini kviz: Grupisanje podataka
-
(Included in full purchase)
-
6
SORTIRANJE PODATAKA
-
(Included in full purchase)
Sortiranje podataka (ORDER BY, DESC)
-
(Included in full purchase)
Mini kviz: Sortiranje podataka
-
(Included in full purchase)
-
7
RAD SA VIŠE TABELA
-
(Included in full purchase)
Uvod u upite nad više tabela
-
(Included in full purchase)
Spajanje tabela (INNER JOIN, LEFT JOIN, LIMIT)
-
(Included in full purchase)
Spajanje tabela (RIGHT JOIN, FULL OUTER JOIN)
-
(Included in full purchase)
Kreiranje veza između tabela (BRIDGING)
-
(Included in full purchase)
Spajanje tabela (JOIN sa više uslova, UNION)
-
(Included in full purchase)
Mini kviz: Rad sa više tabela
-
(Included in full purchase)