Témy a oblasti online kurzu a konzultácií:
základy jazyka, programovanie v PL/SQL, pokročilé metódy analýzy dát v SQL, Oracle 10g a ďalšie
Témy a oblasti online kurzu a konzultácií:
základy jazyka, programovanie v PL/SQL, pokročilé metódy analýzy dát v SQL, Oracle 10g a ďalšie
Zisťujete ako samostatne pracovať s databázou Oracle cez SQL Developer? Hľadáte ľubovoľný iný program podporujúci SQL (Structured Query Language)? Princípy relačných databáz sú univerzálne a jazyk SQL je štandardizovaný. Preto nadobudnuté znalosti z kurzu budete vedieť uplatniť nielen pri práci so samotnými databázami Oracle, ale v prípade potreby vo veľkej miere aj pri práci s inými databázovými systémami.
Tento kurz je určený najmä pre začiatočníkov, ktorí sa chcú alebo potrebujú sa naučiť pracovať v databázovom systéme Oracle. Zoznámia sa na ňom so všeobecnými princípmi a terminológiou relačných databáz ako aj špecifickými vlastnosťami Oracle. Naučia sa vyberať požadované údaje z tabuliek, analyzovať ich, spájať viaceré zdroje do spoločných výstupov. Od jednoduchých výberových dotazov na jednej tabuľke sa postupne prejde až ku komplexnejším dotazom, kde zoskupenie a následná analýza vyžaduje spojiť niekoľko vzájomne súvisiacich tabuliek. Na výberové dotazy nadviažeme DML príkazmi pre úpravu, vkladanie a odstraňovanie záznamov a s tým súvisiacimi transakciami. Po predstavení dátových typov Oracle sa účastníci kurzu budú zaoberať vytváraním vlastnej relačnej tabuľky, pohľadmi a ďalšími užitočnými objektami.
Aktuálne individuálne online kurzy neplánujeme realizovať, vyberte si skupinový kurz – prezenčný v Bratislave, alebo živou online formou. Pozrieť ponuku kurzov
Cookie | Dĺžka trvania | Popis |
---|---|---|
_ga | 2 years | The _ga cookie, installed by Google Analytics, calculates visitor, session and campaign data and also keeps track of site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognize unique visitors. |
_ga_4H8KDTW0CE | 2 years | This cookie is installed by Google Analytics. |
_gat | 1 minute | This cookie is installed by Google Universal Analytics to restrain request rate and thus limit the collection of data on high traffic sites. |
_gat_gtag_UA_4041841_1 | 1 minute | Set by Google to distinguish users. |
_gid | 1 day | Installed by Google Analytics, _gid cookie stores information on how visitors use a website, while also creating an analytics report of the website's performance. Some of the data that are collected include the number of visitors, their source, and the pages they visit anonymously. |
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
PHPSESSID | session | This cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user session on the website. The cookie is a session cookies and is deleted when all the browser windows are closed. |
ssupp.vid | 6 months | Cookie set by Smartsupp to record the visitor ID. |
ssupp.visits | 6 months | Cookie set by Smartsupp to record the number of previous visits, necessary to track automatic messages. |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |
Cookie | Dĺžka trvania | Popis |
---|---|---|
_fbp | 3 months | This cookie is set by Facebook to display advertisements when either on Facebook or on a digital platform powered by Facebook advertising, after visiting the website. |
CONSENT | 2 years | YouTube sets this cookie via embedded youtube-videos and registers anonymous statistical data. |
fr | 3 months | Facebook sets this cookie to show relevant advertisements to users by tracking user behaviour across the web, on sites that have Facebook pixel or Facebook social plugin. |
test_cookie | 15 minutes | The test_cookie is set by doubleclick.net and is used to determine if the user's browser supports cookies. |
VISITOR_INFO1_LIVE | 5 months 27 days | A cookie set by YouTube to measure bandwidth that determines whether the user gets the new or old player interface. |
YSC | session | YSC cookie is set by Youtube and is used to track the views of embedded videos on Youtube pages. |
yt-remote-connected-devices | never | YouTube sets this cookie to store the video preferences of the user using embedded YouTube video. |
yt-remote-device-id | never | YouTube sets this cookie to store the video preferences of the user using embedded YouTube video. |
yt.innertube::nextId | never | This cookie, set by YouTube, registers a unique ID to store data on what videos from YouTube the user has seen. |
yt.innertube::requests | never | This cookie, set by YouTube, registers a unique ID to store data on what videos from YouTube the user has seen. |