{"id":2168,"date":"2020-03-06T14:10:18","date_gmt":"2020-03-06T11:10:18","guid":{"rendered":"http:\/\/cadredidactice.ub.ro\/simonavarlan\/?page_id=2168"},"modified":"2020-05-16T12:45:30","modified_gmt":"2020-05-16T09:45:30","slug":"sgbd-2020","status":"publish","type":"page","link":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/sgbd-2020\/","title":{"rendered":"SGBD 2020"},"content":{"rendered":"\n<p style=\"background-color:#adf0da\" class=\"has-text-color has-background has-vivid-red-color\"><strong>De Facut !!!  &#8211; pentru anul II ZI<\/strong>   <br \/><strong>Cei de la FR discutam doar pe Teams.<\/strong> <\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><strong>Aveti rezolvare pentru Tema 4, plus inca un model de exercitii, le rulati si analizati ce fac.<\/strong><\/li><li><strong>Examen semestru 2 MidTerm de tip grila &#8211; deadline 20 mai ora 23:59.<\/strong><\/li><li><strong>Intalnirea din date de 22 mai e posibil sa o reprogramam, pe Teams. <\/strong><\/li><li><\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Pagina dedicata laboratorului de SGBD &#8211; 2020<\/strong><\/h2>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>I) Pregatirea mediului de lucru<\/strong><\/h2>\n\n\n\n<p>In cadrul acestui laborator veti lucra cu PL\/SQL -un limbaj de scripting ce poate fi executat direct de c\u0103tre serverul Oracle SQL (a fost dezvoltat de c\u0103tre Oracle la sf\u00e2r\u015fitul anilor &#8217;80 special pentru a ajuta limbajul SQL s\u0103 devin\u0103 mai complex).&nbsp; &nbsp;<\/p>\n\n\n\n<p>Mediul de lucru&nbsp;pentru testarea instructiunilor SQL este<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li> <strong>Oracle Database 11g Express Edition<\/strong>&nbsp;ca \u0219i server SQL \u0219i<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li> un IDE specializat pentru PLSQL: <strong>SQL Developer<\/strong>.<\/li><\/ul>\n\n\n\n<p><strong>1)&nbsp;&nbsp;Pentru instalarea Oracle 11g<\/strong> se poate face download de aici:  <br \/><a href=\"https:\/\/www.oracle.com\/database\/technologies\/xe-prior-releases.html\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (se deschide \u00eentr-o fil\u0103 nou\u0103)\">https:\/\/www.oracle.com\/database\/technologies\/xe-prior-releases.html<\/a> &nbsp; si instalat pe calculatorul personal.<br \/>Pentru download aveti nevoie de un cont creat pe situl-ul Oracle.<\/p>\n\n\n\n<p>In timpul instalarii veti fi intrebat o parola. Aceasta este parola de administrare ce va fi utila daca vreti sa administrati serverul de la distanta. Local aceasta parola va fi ignorata de catre SQL*Plus.<\/p>\n\n\n\n<p>Dupa instalare&nbsp;accesati utilitarul Run SQL Command Line unde va veti conecta la serverul de SQL cu contul de administrator astfel:&nbsp;&nbsp;<\/p>\n\n\n\n<p><strong>CONN SYS AS SYSDBA <\/strong><\/p>\n\n\n\n<p>cu parola <strong>sql<\/strong>.&nbsp;<\/p>\n\n\n\n<p>Dupa ce v-ati conectat cu contul de administrator este indicat sa va faceti un cont separat in care sa creati schema bazei de date. Scrieti urmatoarele comenzi exact in ordinea data:<\/p>\n\n\n\n<p>CREATE USER STUDENT IDENTIFIED BY STUDENT DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;<\/p>\n\n\n\n<p>(crearea unui user cu numele STUDENT si parola STUDENT)<\/p>\n\n\n\n<p>ALTER USER STUDENT QUOTA 100M ON USERS;<\/p>\n\n\n\n<p>GRANT CONNECT TO STUDENT;<\/p>\n\n\n\n<p>GRANT CREATE TABLE TO STUDENT;<\/p>\n\n\n\n<p>GRANT CREATE VIEW TO STUDENT;<\/p>\n\n\n\n<p>GRANT CREATE SEQUENCE TO STUDENT;<\/p>\n\n\n\n<p>GRANT CREATE TRIGGER TO STUDENT;<\/p>\n\n\n\n<p>GRANT CREATE SYNONYM TO STUDENT;<\/p>\n\n\n\n<p>GRANT CREATE PROCEDURE TO STUDENT;<\/p>\n\n\n\n<p>La urma va conectati cu contul Student:&nbsp; CONN STUDENT&nbsp;&nbsp;cu parola STUDENT<\/p>\n\n\n\n<p><strong>2) Pentru instalarea SQl Developer \u0219i modul de conectare la baza de date Oracle<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>In primul rand trebuie sa aveti instalat Oracle 11g XE (Express edition)<\/li><li>Desc\u0103rca\u0163i SQL Developer  <br \/><a rel=\"noreferrer noopener\" aria-label=\" (se deschide \u00eentr-o fil\u0103 nou\u0103)\" href=\"https:\/\/www.oracle.com\/ro\/database\/technologies\/appdev\/sql-developer.html\" target=\"_blank\">https:\/\/www.oracle.com\/ro\/database\/technologies\/appdev\/sql-developer.html<\/a>  (versiunea windows 64). Alegeti arhiva cu jdk inclus.<\/li><li>Dezarhiva\u0163i arhiva de mai sus \u00eentr-un director la alegere.<\/li><li>Porni\u0163i SQL developer din directorul in care l-a\u0163i dezarhivat.<\/li><li>Indica\u0163i calea c\u0103tre Java Development Kit (JDK) de obicei acesta este \u00een C:\/Program Files\/Java\/jdk &#8211; optional pentru cei care nu au ales cu jdk inclus, asta inseamna ca trebuie sa aveti jdk deja instalat pe calculator<\/li><li>Ap\u0103sa\u0163i butonul + (verde, st\u00e2nga-sus) pentru crearea unei noi conexiuni.<\/li><li>Completa\u0163i informa\u0163iile ca \u00een&nbsp;<a rel=\"noreferrer noopener\" aria-label=\" (se deschide \u00eentr-o fil\u0103 nou\u0103)\" href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2018\/02\/conectare.jpg\" target=\"_blank\">https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2018\/02\/conectare.jpg<\/a><\/li><li>In cazul in care conexiunea nu poate fi efectuata, verificati sa aveti pornite serviciile Oracle necesare (OracleServiceXE si OracleXETNSListener)<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>II) Pentru lucrul la orele de laborator<\/strong>:<\/h2>\n\n\n\n<p> Cursurile de PLSQL  le gasiti la adresa  <br \/>&nbsp;<a rel=\"noreferrer noopener\" target=\"_blank\" href=\"http:\/\/ilearning.oracle.com\/ilearn\/en\/learner\/jsp\/login.jsp?site=OracleAcad\">http:\/\/ilearning.oracle.com\/ilearn\/en\/learner\/jsp\/login.jsp?site=OracleAcad<\/a> <\/p>\n\n\n\n<p>Fiecare student va intra <a rel=\"noreferrer noopener\" aria-label=\"aici (se deschide \u00eentr-o fil\u0103 nou\u0103)\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/15hlLrkkP4vd8ArHTalkGwy65BYOhEVS8-CpiR_uT-G0\/edit?usp=sharing\" target=\"_blank\">aici<\/a>  \u0219i va completa numele \u0219i prenumele \u00een dreptul contului ales. Aici va fi p\u0103strata o statistica a activit\u0103\u021bii voastre pe conturile online a cursului PLSQL oferit de Academy Oracle.<\/p>\n\n\n\n<p>Vom lucra cu&nbsp; urmatoarele scheme de baze de date:&nbsp;&nbsp;<a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2017\/11\/SQL_Schema_ERD_and_Table_Designs.pdf\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (se deschide \u00eentr-o fil\u0103 nou\u0103)\">SQL_Schema_ERD_and_Table_Designs<\/a><\/p>\n\n\n\n<p>Scriptul pentru crearea bazei de date este: &nbsp;<a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/05\/PLSQL_Schema.zip\">PLSQL_Schema<\/a>.&nbsp;Deschideti acest script in SQL Developer si rulati-l.<\/p>\n\n\n\n<p><a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/04\/Mini-tutorial-oracle.pdf\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Mini tutorial PLSQL (se deschide \u00eentr-o fil\u0103 nou\u0103)\">Mini tutorial PLSQL<\/a>  <\/p>\n\n\n\n<p><strong>Teme laborator:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\"><li><a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/05\/Tema-1-oracle.pdf\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Tema 1 (se deschide \u00eentr-o fil\u0103 nou\u0103)\">Tema 1<\/a>  PL\/SQL  &#8211; 13 martie 2020<\/li><li>De parcurs sectiunile 1 si 2 din cursurile online<\/li><li>Recapitulare SQL :<br \/> <a rel=\"noreferrer noopener\" href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2015\/02\/PLSQL_l1.pdf\" target=\"_blank\">PLSQL_l1<\/a>&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2015\/02\/PLSQL_l2.pdf\" target=\"_blank\">PLSQL_l2<\/a>&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2015\/02\/PLSQL_l3.pdf\" target=\"_blank\">PLSQL_l3<\/a>&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2015\/02\/PLSQL_l4.pdf\" target=\"_blank\">PLSQL_l4<\/a> <\/li><li> <a rel=\"noreferrer noopener\" aria-label=\"Rezolvare tema 1 (se deschide \u00eentr-o fil\u0103 nou\u0103)\" href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/04\/Tema-1-rezolvata-1.pdf\" target=\"_blank\">Rezolvare tema 1<\/a>   <\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" aria-label=\"Tema 2 (se deschide \u00eentr-o fil\u0103 nou\u0103)\" href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/04\/Tema-2-oracle-4.pdf\" target=\"_blank\">Tema 2<\/a>  PL\/SQL   pentru  06.04.2020<\/li><li><a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/04\/Tema-2-rezolvata.pdf\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Rezolvare Tema 2 (se deschide \u00eentr-o fil\u0103 nou\u0103)\">Rezolvare Tema 2<\/a>     <\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" aria-label=\"Tema 3 (se deschide \u00eentr-o fil\u0103 nou\u0103)\" href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/04\/Tema-3-oracle-1.pdf\" target=\"_blank\">Tema 3<\/a> PL\/SQL  pentru 22 aprilie 2020<\/li><li><a rel=\"noreferrer noopener\" aria-label=\"Rezolvare Tema 3 (se deschide \u00eentr-o fil\u0103 nou\u0103)\" href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/04\/Tema-3-oracle-rezolvat-2.pdf\" target=\"_blank\">Rezolvare Tema 3<\/a>  <\/li><li> <a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2019\/05\/Exercitii-functie-si-triggere-2019.pdf\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (se deschide \u00eentr-o fil\u0103 nou\u0103)\">Ceva suplimentar cu exemplu functie si trigger<\/a>e<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" aria-label=\"Tema 4 (se deschide \u00eentr-o fil\u0103 nou\u0103)\" href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/04\/Tema-4-oracle-2.pdf\" target=\"_blank\">Tema 4<\/a> PLSQL pentru 8 mai 2020<\/li><li><a rel=\"noreferrer noopener\" aria-label=\"Rezolvare Tema 4 (se deschide \u00eentr-o fil\u0103 nou\u0103)\" href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/05\/Tema-4-oracle-rezolvata.pdf\" target=\"_blank\">Rezolvare Tema 4<\/a> <\/li><li><a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/05\/TEMA-4-rezolvata-vr.2-.pdf\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Altfel de rezolvari (se deschide \u00eentr-o fil\u0103 nou\u0103)\">Altfel de rezolvari<\/a>, rulati si vedeti ce face fiecare exemplu prezentat <\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>De Facut !!! &#8211; pentru anul II ZI Cei de la FR discutam doar pe Teams. Aveti rezolvare pentru Tema 4, plus inca un model de exercitii, le rulati si analizati ce fac. Examen semestru 2 MidTerm de tip grila &hellip;<\/p>\n<p class=\"read-more\"><a href=\"https:\/\/cadredidactice.ub.ro\/simonavarlan\/sgbd-2020\/\">Continue reading<\/a><\/p>\n","protected":false},"author":269,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2168","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/wp-json\/wp\/v2\/pages\/2168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/wp-json\/wp\/v2\/users\/269"}],"replies":[{"embeddable":true,"href":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/wp-json\/wp\/v2\/comments?post=2168"}],"version-history":[{"count":96,"href":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/wp-json\/wp\/v2\/pages\/2168\/revisions"}],"predecessor-version":[{"id":2315,"href":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/wp-json\/wp\/v2\/pages\/2168\/revisions\/2315"}],"wp:attachment":[{"href":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/wp-json\/wp\/v2\/media?parent=2168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}