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
Ramowy program szkolenia SQL podstawowy
- Wprowadzenie – trochę teorii
- Relacyjne bazy danych, pojęcia podstawowe
- Język SQL – czym jest?
- Projektowanie i normalizacja baz danych
- Środowisko MS SQL Server
- Obiekty bazodanowe
- Pobieranie danych – polecenie select.
- SELECT – definiowanie wyniku
- Najprostsze formy pobierania danych
- Wyświetlanie tylko wybranych kolumn
- Zastosowanie operatorów i funkcji
- Filtrowanie danych – klauzula where.
- proste filtrowanie danych
- null – wartości pust
- operatory logiczne i złożone filtry
- Sortowanie danych – klauzula order by.
- Grupowanie danych.
- zastosowanie funkcji agregujących i klauzuli group by
- ograniczanie wartości grupy – klauzula having
- Pobieranie danych z wielu tabel.
- użycie złączeń
- podzapytania
- Dane w tabeli
- Dodawanie danych do tabel – polecenie insert.
- ręczne wprowadzanie danych
- dodawanie danych przez zapytanie
- Modyfikowanie danych – polecenie update.
- Usuwanie danych – polecenie delete.
- Zmienianie struktury bazy danych.
- tworzenie nowych tabel – polecenie create table
- modyfikowanie tabel – polecenie alter table
- usuwanie tabel – polecenie drop table
Czas trwania 18 godz. lekcyjnych – Cena 900 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