SQL databázy: MySQL a SQLite
8h 59min
Time
78
Chapters
Programovanie
Category
4.9
Rating
Beginner
Level
slovak
Language
Chapters
Relačné databázy pre teba a pre mňa
5min
Available in course preview
6min
Available in course preview
5min
Available in course preview
Tipy, rady a pravidlá pre každý kurz
5min
Available only with full access purchase
04 Tučný ERD diagram, jeden obrázok za tisíc vťahov
4min
Available only with full access purchase
05 SQL vs. MySQL vs. PostgreSQL vs. MSSQL vs. Oracle vs. the World
6min
Available only with full access purchase
06 vs. SQLite vs. NoSQL (MongoDB, CouchDB, Redis) vs. Dracula 3000
8min
Available only with full access purchase
07 SQL Queries, škandalózne neslýchané IDčka, URL adresy
8min
Available only with full access purchase
Kde ma nájdeš, mňa, yablka
1min
Available only with full access purchase
Nainštaluj server a skroť mocné nástroje
Laragon namiesto MAMP (hlavne pre Windows)
3min
Available only with full access purchase
HeidiSQL, nepotrebuješ každý program
3min
Available only with full access purchase
Ak sa ti cez Laragon nedá pripojiť k databáze
-
Available only with full access purchase
08 Poď, poď, inštaluj server databázový, objav phpMyAdmin boľavý
6min
Available only with full access purchase
09 Kreácia databázy, čo je Collation, utf8mb4, starý/dobrý import/export
7min
Available only with full access purchase
10 Login do databázy, vstúp do nej na hostigu, objav DB nástroje
7min
Available only with full access purchase
MySQL, poď do toho
8min
Available in course preview
6min
Available in course preview
13 MySQL INSERT, strčím ti tam hodnotu, NULL, DEFAULT
5min
Available only with full access purchase
14 MySQL NULLIF, ako na sladké diery v databáze a IS NULL prázdnotu
6min
Available only with full access purchase
5min
Available in course preview
16 MySQL DELETE, TRUNCATE, CREATE, DROP, zničím ťa komplet
6min
Available only with full access purchase
17 MySQL LIKE, pokročilý SELECT, hľadanie v názvoch, COUNT() riadkov
4min
Available only with full access purchase
18 MySQL JOIN, spojenie viacerých tabuliek, jak tá scéna z avatara
5min
Available only with full access purchase
19 MySQL RIGHT JOIN, LEFT JOIN, INNER JOIN, zo všetkých strán
5min
Available only with full access purchase
20 MySQL OUTER JOIN, UNION (nie tá poisťovňa) ALIAS (nie ten seriál)
5min
Available only with full access purchase
21 MySQL SUBQUERY vs JOIN, Inception medzi queries, zopakujem ti
5min
Available only with full access purchase
22 MySQL GROUP BY, HAVING, DISTINCT, správne poradie SQL príkazov
9min
Available only with full access purchase
Nemusíš všetko (+ frustrujúce úlohy)
11min
Available only with full access purchase
Vytvor si novú databázu / tabuľku, šup
23 MySQL CREATE, vytváranie databázy, dátové typy, milión nedáš
6min
Available only with full access purchase
24 MySQL TRIGGER, keď sa stane niečo, nech sa stane niečo iné
5min
Available only with full access purchase
25 MySQL PIVOT tabuľky, VZŤAHY 1:N, 1:1, M:N, funkcia GROUP_CONCAT
10min
Available only with full access purchase
MySQL pre pokročilejšejších
26 Nie sú tie PIVOT tabuľky zbytočne zložité? Kecajme radšej o kritikoch
8min
Available only with full access purchase
27 Niekedy stačí viac jednoduchších queries namiesto veľkého GROUP BY
3min
Available only with full access purchase
28 MySQL GROUP BY ešte raz, pretože naň nestačí jedno video
5min
Available only with full access purchase
29 MySQL GROUP BY na ŠTATISTIKU cez zlúčenie viacerých riadkov pod jeden
5min
Available only with full access purchase
30 INDEXy pre zrýchlenie databázy, typy, na kerý stĺpec INDEX dať
8min
Available only with full access purchase
31 STORED PROCEDURES, vlastné funkcie, LOOP REPEAT SQL príkazov, UNIQUE index
7min
Available only with full access purchase
32 MySQL EXPLAIN, rýchlosť SELECTu s a bez INDEXU, kedy ich NEpoužívať
5min
Available only with full access purchase
33 MySQL cez KONZOLU, kde si databáza ukladá súbory na disku?
7min
Available only with full access purchase
34 MySQL cez KONZOLU 2, tipy & triky & výhody konzole oproti GUI programu
5min
Available only with full access purchase
Storage Engines a FULLTEXT vyhľadávanie
35 MySQL STORAGE ENGINES, InnoDB vs MyISAM vs MariaDB (to si nečakal)
7min
Available only with full access purchase
36 SQL TRANSAKCIE a praktické porovnanie InnoDB vs MyISAM
4min
Available only with full access purchase
37 vs CSV vs MEMORY vs BLACKHOLE vs FREDDY vs JASON
5min
Available only with full access purchase
40 FULLTEXT IN NATURAL LANGUAGE MODE vs IN BOOLEAN MODE
6min
Available only with full access purchase
41 vs WITH QUERY EXPANSION, pravidlá FULLTEXT indexu, rozdiely v InnoDB/MyISAM
5min
Available only with full access purchase
42 MySQL FOREIGN KEY CONSTRAINTS, ochrana hodnôt v DB, automatické mazanie
5min
Available only with full access purchase
43 ON UPDATE DELETE CASCADE, auto-mazanie z dcérskej tabuľky, komplet deštrukcia
8min
Available only with full access purchase
44 MySQL neni na prd, inak by som nerobil kurz;) Zmena DEFAULT nastavení
10min
Available only with full access purchase
45 Zmena MySQL nastavení cez konfiguračný súbor, moja prosba, KONIEC MySQL
9min
Available only with full access purchase
SQLite
46 SQLite, najpoužívanejší databázový systém, výhody a nevýhody a tak vôbec
7min
Available only with full access purchase
47 Lumen, API aplikácie, PHP frameworky, náradie a nástroje pre SQLite
7min
Available only with full access purchase
48 SQLite Tools, SQLPro for SQLite, SQLiteManager, sqlite3 cez konzolu
5min
Available only with full access purchase
49 SQLite Tools, phpLiteAdmin, Adminer pre SQLite, PHPStorm
5min
Available only with full access purchase
50 SQLite cez Adminer, Adminer pluginy, témy a VYTVORENIE SQLite databázy
9min
Available only with full access purchase
ADMINER: ak nefunguje prihlásenie do adminer
-
Available only with full access purchase
51 Rozdiely v MySQL a SQLite kóde, SQLite dátové typy a CREATE syntax
9min
Available only with full access purchase
52 Rozdiely v queries a funkciách medzi MySQL a SQLite, encoding pre emojis
8min
Available only with full access purchase
Lumen aplikácia bežiaca na SQLite
53 Lumen ako rozcestník a ako zistíš, či tvoje PHP podporuje SQLite
8min
Available only with full access purchase
54 Vyrobíme API appku, napojenie na SQLite databázu, SQL injection
10min
Available only with full access purchase
55 Views, Templates, HTML šablóny, vyskladanie HTML stránky okolo údajov z DB
5min
Available only with full access purchase
56 Master Layout, sub-šablóny, prepojenie adresy stránky s údajmi v databáze
6min
Available only with full access purchase
57 Dizajn stránky, Lumen vs Laravel dokumentácia, DEFAULT pre yield()
7min
Available only with full access purchase
58 Lumen a Laravel COLLECTIONS
8min
Available only with full access purchase
59 Blade PARTIALS, dokončenie dizajnu stránky
5min
Available only with full access purchase
60 JOIN na tabuľku režisérov, Blade komentáre
6min
Available only with full access purchase
61 MVC (Model, View, Controller) a Refactoring kódu
8min
Available only with full access purchase
62 Model / Eloquent, PHPDoc komentáre divné šialené o čom sú?
7min
Available only with full access purchase
63 Model / Manuálne, SELECT pre režisérov
9min
Available only with full access purchase
64 POST Request, Method POST, SQL INSERT pre vkladanie nového režiséra
11min
Available only with full access purchase
65 SQLite Sequence Reset pre ne-diery, profil rejžu, nový film
10min
Available only with full access purchase
66 Profil režiséra, TODO komentáre a okno, BLADE podmienky
8min
Available only with full access purchase
67 Predvyznačenie SELECTu, listovanie podľa žánru, tipy/triky, stránkovanie
11min
Available only with full access purchase
68 PAGINATION (stránkovanie), EDIT a DELETE linky
9min
Available only with full access purchase
69 nice (UPDATE, DELETE, editácia a mazanie režisérov a filmov)
15min
Available only with full access purchase
70 Databázy v PHPStorm a srdcervúci záver, fňuk
10min
Available only with full access purchase
Domáca úloha, nech to nemáš tak jednoduché, frajer
-
Available only with full access purchase
24
Online courses
0
Posts