{"id":410,"date":"2020-08-11T13:27:32","date_gmt":"2020-08-11T11:27:32","guid":{"rendered":"https:\/\/kee.cp2.tuke.sk\/?page_id=410"},"modified":"2025-09-23T10:28:42","modified_gmt":"2025-09-23T08:28:42","slug":"databazove-systemy-sql-oracle","status":"publish","type":"page","link":"https:\/\/kee.fei.tuke.sk\/?page_id=410","title":{"rendered":"Datab\u00e1zov\u00e9 syst\u00e9my – SQL Oracle"},"content":{"rendered":"\n
\u0160tudijn\u00fd odbor:<\/strong><\/td>Elektrotechnika<\/td><\/tr>
\u0160tudijn\u00fd program:<\/strong><\/td>Elektroenergetika<\/td><\/tr>
Rozsah:<\/strong><\/td>2\/1\/1 (P\/S\/PP)<\/td><\/tr>
Po\u010det kreditov:<\/strong><\/td>6<\/td><\/tr>
Osoba zodpovedn\u00e1 za predmet:<\/strong><\/td>doc. Ing. Jaroslav Petr\u00e1\u0161, PhD.<\/td><\/tr>
Predn\u00e1\u0161a:<\/strong><\/td>doc. Ing. Jaroslav Petr\u00e1\u0161, PhD.<\/td><\/tr>
Cvi\u010d\u00ed:<\/strong><\/td>doc. Ing. Jaroslav Petr\u00e1\u0161, PhD.<\/td><\/tr>
Podmie\u0148uj\u00face predmety:<\/strong><\/td>–<\/td><\/tr>
Hodnotenie a ukon\u010denie:<\/strong><\/td>z\u00e1po\u010det a sk\u00fa\u0161ka.<\/td><\/tr>
Priebe\u017en\u00e9 hodnotenie:<\/strong><\/td>p\u00edsomn\u00fd test, projekt.<\/td><\/tr>
Z\u00e1vere\u010dn\u00e9 hodnotenie:<\/strong><\/td>sk\u00fa\u0161ka.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Cie\u013e predmetu<\/strong>: Obozn\u00e1mi\u0165 \u0161tudentov so z\u00e1kladn\u00fdmi princ\u00edpmi n\u00e1vrhu datab\u00e1z, jazyka SQL, z\u00e1kladmi pr\u00e1ce s tab\u013ekami, poh\u013eadmi, vnoren\u00fdmi dopytmi.<\/p>\n\n\n\n

Stru\u010dn\u00e1 osnova predmetu<\/h4>\n\n\n\n
  1. \u00davod do datab\u00e1z.<\/li>
  2. N\u00e1vrh datab\u00e1z.<\/li>
  3. Pr\u00e1ca s Oracle datab\u00e1zou a s Oracle Database Homepage.<\/li>
  4. \u00davod do SQL.<\/li>
  5. Pr\u00edkaz SELECT.<\/li>
  6. Manipul\u00e1cia s viacer\u00fdmi tabu\u013ekami.<\/li>
  7. Vnoren\u00e9 dopyty.<\/li>
  8. Zoskupenie d\u00e1t.<\/li>
  9. Poh\u013eady.<\/li>
  10. PL\/SQL.<\/li>
  11. Regul\u00e1rne v\u00fdkazy.<\/li>
  12. \u010eal\u0161ie \u010drty SQL, vlastnosti Oracle Database.<\/li><\/ol>\n\n\n\n

    \u010casov\u00fd rozvrh v\u00fdu\u010dby<\/h4>\n\n\n\n
    1. \u00davod do datab\u00e1z.
      Cv<\/strong>.: Ciele
      • Obozn\u00e1menie sa \u0161tudentov s organiza\u010dn\u00fdmi pokynmi a s podmienkami z\u00e1po\u010dtu.<\/li>
      • Obozn\u00e1mi\u0165 sa s datab\u00e1zov\u00fdm syst\u00e9mom ORACLE.<\/li>
      • Obozn\u00e1mi\u0165 sa s n\u00e1strojmi pre spr\u00e1vu datab\u00e1ze ORACLE a s ich prostred\u00edm.<\/li><\/ul><\/li>
      • In\u0161tal\u00e1cia a nastavenie SQL Oracle.
        Cv<\/strong>.: Ciele
        • Obozn\u00e1menie sa \u0161tudentov s organiza\u010dn\u00fdmi pokynmi a s podmienkami z\u00e1po\u010dtu.<\/li>
        • Obozn\u00e1mi\u0165 sa s datab\u00e1zov\u00fdm syst\u00e9mom ORACLE.<\/li>
        • Obozn\u00e1mi\u0165 sa s n\u00e1strojmi pre spr\u00e1vu datab\u00e1ze ORACLE a s ich prostred\u00edm.<\/li><\/ul><\/li>
        • N\u00e1vrh datab\u00e1z.
          Cv<\/strong>.: Ciele
          • Obozn\u00e1mi\u0165 sa s metodol\u00f3giou n\u00e1vrhu datab\u00e1z.<\/li>
          • Obozn\u00e1mi\u0165 sa so z\u00e1kladn\u00fdmi pr\u00edkazmi SQL a sp\u00f4sobmi zad\u00e1vania pr\u00edkazov pre datab\u00e1zu.<\/li>
          • Ur\u010di\u0165 znenie a form\u00e1t zadan\u00ed.<\/li><\/ul><\/li>
          • \u00davod do SQL.
            Cv<\/strong>.: Ciele
            • Obozn\u00e1mi\u0165 sa s metodol\u00f3giou n\u00e1vrhu datab\u00e1z.<\/li>
            • Obozn\u00e1mi\u0165 sa so z\u00e1kladn\u00fdmi pr\u00edkazmi SQL a sp\u00f4sobmi zad\u00e1vania pr\u00edkazov pre datab\u00e1zu.<\/li>
            • Ur\u010di\u0165 znenie a form\u00e1t zadan\u00ed.<\/li><\/ul><\/li>
            • Pr\u00edkaz SELECT.
              Cv<\/strong>.: Ciele
              • Obozn\u00e1mi\u0165 sa s pr\u00edkazom SELECT a jeho klauzulami.<\/li>
              • Obozn\u00e1mi\u0165 sa so spojeniami.<\/li><\/ul><\/li>
              • Manipul\u00e1cia s viacer\u00fdmi tabu\u013ekami.
                Cv<\/strong>.: Ciele
                • Obozn\u00e1mi\u0165 sa s pr\u00edkazom SELECT a jeho klauzulami.<\/li>
                • Obozn\u00e1mi\u0165 sa so spojeniami.<\/li><\/ul><\/li>
                • Vnoren\u00e9 dopyty.
                  Cv<\/strong>.: Ciele
                  • Obozn\u00e1menie sa so sp\u00f4sobmi exportovania a importovania d\u00e1t a \u0161trukt\u00fary zdatab\u00e1zy Oracle.<\/li>
                  • Obozn\u00e1mi\u0165 sa s n\u00e1strojom Query Builder v Oracle Database Homepage.<\/li>
                  • Obozn\u00e1mi\u0165 sa s vnoren\u00fdmi dopytmi a zoskupovan\u00edm d\u00e1t.<\/li><\/ul><\/li>
                  • Zoskupenie d\u00e1t.
                    Cv<\/strong>.: Ciele
                    • Obozn\u00e1menie sa so sp\u00f4sobmi exportovania a importovania d\u00e1t a \u0161trukt\u00fary zdatab\u00e1zy Oracle.<\/li>
                    • Obozn\u00e1mi\u0165 sa s n\u00e1strojom Query Builder v Oracle Database Homepage.<\/li>
                    • Obozn\u00e1mi\u0165 sa s vnoren\u00fdmi dopytmi a zoskupovan\u00edm d\u00e1t.<\/li><\/ul><\/li>
                    • Poh\u013eady.
                      Cv<\/strong>.: Ciele
                      • Obozn\u00e1menie sa s poh\u013eadmi.<\/li>
                      • Obozn\u00e1mi\u0165 sa s triggermi a sekvenciami.<\/li><\/ul><\/li>
                      • PL\/SQL.
                        Cv<\/strong>.: Ciele
                        • Obozn\u00e1menie sa s poh\u013eadmi.<\/li>
                        • Obozn\u00e1mi\u0165 sa s triggermi a sekvenciami.<\/li><\/ul><\/li>
                        • Regul\u00e1rne v\u00fdrazy.
                          Cv<\/strong>.: Ciele
                          • Vykona\u0165 z\u00e1po\u010dtov\u00fd test.<\/li>
                          • Precvi\u010di\u0165 pr\u00e1cu s Application Builder v Oracle Database Homepage.<\/li>
                          • Precvi\u010di\u0165 pr\u00e1cu sregul\u00e1rnymi v\u00fdrazmi – oper\u00e1tor LIKE.<\/li>
                          • Obozn\u00e1mi\u0165 sa s vytv\u00e1ran\u00edm \u010fal\u0161\u00edch objektov Oracle Database – Index aType.<\/li><\/ul><\/li>
                          • \u010eal\u0161ie \u010drty SQL, vlastnosti Oracle Database.
                            Cv<\/strong>.: Ciele
                            • Vykona\u0165 z\u00e1po\u010dtov\u00fd test.<\/li>
                            • Precvi\u010di\u0165 pr\u00e1cu s Application Builder v Oracle Database Homepage.<\/li>
                            • Precvi\u010di\u0165 pr\u00e1cu sregul\u00e1rnymi v\u00fdrazmi – oper\u00e1tor LIKE.<\/li>
                            • Obozn\u00e1mi\u0165 sa s vytv\u00e1ran\u00edm \u010fal\u0161\u00edch objektov Oracle Database – Index aType.<\/li><\/ul><\/li>
                            • \u010eal\u0161ie \u010drty SQL, vlastnosti Oracle Database.
                              Cv<\/strong>.: Ciele
                              • Odovzdanie projektu a z\u00e1po\u010det.<\/li><\/ul><\/li><\/ol>\n\n\n\n

                                Odpor\u00fa\u010dan\u00e1 literat\u00fara<\/h4>\n\n\n\n
                                1. T. Conolly, C. Begg, R. Holowczak: Mistrovstv\u00ed – datab\u00e1ze<\/em>, Computer Press 2009, ISBN 978-80-251-2328-7.<\/li>
                                2. M. J. Hernandez, J. L. Viescas: Mysl\u00edme v jazyku SQL tvorba dotazu<\/em>, Grada, Praha 2004, ISBN 80-247-0899-X.<\/li>
                                3. David Proch\u00e1zka: ORACLE<\/em>, pruvodce spr\u00e1vou, vyu\u017eit\u00edm a programov\u00e1n\u00edm nad datab\u00e1zov\u00fdm syst\u00e9mem, GRADA, Praha 2009, ISBN 978-80-247-2762-2.<\/li>
                                4. M. J. Hernandez, J. L. Viescas: Mysl\u00edme v jazyku SQL<\/em>, GRADA, Praha 2004, ISBN 80-247-0899-X.<\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"

                                  \u0160tudijn\u00fd odbor: Elektrotechnika \u0160tudijn\u00fd program: Elektroenergetika Rozsah: 2\/1\/1 (P\/S\/PP) Po\u010det kreditov: 6 Osoba zodpovedn\u00e1 za predmet: doc. Ing. Jaroslav Petr\u00e1\u0161, PhD. Predn\u00e1\u0161a: doc. Ing. Jaroslav…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":197,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/kee.fei.tuke.sk\/index.php?rest_route=\/wp\/v2\/pages\/410"}],"collection":[{"href":"https:\/\/kee.fei.tuke.sk\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/kee.fei.tuke.sk\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/kee.fei.tuke.sk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kee.fei.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=410"}],"version-history":[{"count":2,"href":"https:\/\/kee.fei.tuke.sk\/index.php?rest_route=\/wp\/v2\/pages\/410\/revisions"}],"predecessor-version":[{"id":2561,"href":"https:\/\/kee.fei.tuke.sk\/index.php?rest_route=\/wp\/v2\/pages\/410\/revisions\/2561"}],"up":[{"embeddable":true,"href":"https:\/\/kee.fei.tuke.sk\/index.php?rest_route=\/wp\/v2\/pages\/197"}],"wp:attachment":[{"href":"https:\/\/kee.fei.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}