Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Deprecated: Function create_function() is deprecated in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line 484
Warning: chmod(): No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Deprecated: Function create_function() is deprecated in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line 484
Warning: chmod(): No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Deprecated: Function create_function() is deprecated in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line 484
Warning: chmod(): No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Program ramowy SQL średniozaawansowany
Tworzenie złożonych zapytań do baz danych
- Wykorzystanie dostępnych operatorów
- Zapytania z wieloma warunkami
Tworzenie tabel i referencji
- Komendy DDL (create, alter i drop)
- Tworzenie więzów integralności
- Normalizacja tabel (do 3 postaci normalnej)
- Anomalie i sposoby ich unikania
Zmiany struktury istniejących tabel
Manipulowanie danymi
- Komendy DML(insert, update, delete)
Łączenie tabel
- Wykorzystanie złączeń wewnętrznych i zewnętrznych
Agregacja danych
- Funkcje grupujące
- Wykorzystanie klauzuli GROUP BY i HAVING
- Grupowanie wielokolumnowe
Podzapytania
- Wielokolumnowe
- Skorelowane
- Klauzula WITH
Czas trwania 18 godz. lekcyjnych – Cena 984 zł. os
Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Deprecated: Function create_function() is deprecated in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line 484
Warning: chmod(): No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in /var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line 1
Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Deprecated: Function create_function() is deprecated in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php on line
484
Warning: chmod(): No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1
Warning: file_put_contents(/var/www/vhosts/hanakom.pl/httpdocs/wp-content/plugins/neuzpte/index.php): failed to open stream: No such file or directory in
/var/www/vhosts/hanakom.pl/httpdocs/wp-includes/plugin.php(484) : runtime-created function on line
1