{"id":2328,"date":"2022-03-04T00:00:32","date_gmt":"2022-03-03T21:00:32","guid":{"rendered":"http:\/\/cadredidactice.ub.ro\/simonavarlan\/?page_id=2328"},"modified":"2023-03-10T09:59:37","modified_gmt":"2023-03-10T06:59:37","slug":"sgbd-2022","status":"publish","type":"page","link":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/sgbd-2022\/","title":{"rendered":"SGBD\/ABD 2022"},"content":{"rendered":"\r\n\r\n\r\n<h2 class=\"wp-block-heading\"><strong>Pagina dedicata laboratoarelor de SGBD\/ABD &#8211; 2022<\/strong><\/h2>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\"><strong>I) Pregatirea mediului de lucru<\/strong><\/h2>\r\n\r\n\r\n\r\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).<\/p>\r\n\r\n\r\n\r\n<p>Mediul de lucru\u00a0pentru testarea instructiunilor SQL este<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><strong>Oracle Database 11g R2 Express Edition<\/strong>\u00a0ca \u0219i server SQL \u0219i<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>un IDE specializat pentru PLSQL: <strong>SQL Developer<\/strong>.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><strong>1)\u00a0 Oracle 11g R2 <\/strong>il gasiti\u00a0 <a href=\"https:\/\/www.oracle.com\/database\/technologies\/xe-prior-release-downloads.html\" target=\"_blank\" rel=\"noopener noreferrer\">aici<\/a>. Downloadati arhiva dupa care il instalati pe calculatorul personal.\u00a0<\/p>\r\n\r\n\r\n\r\n<p>In timpul instalarii vi se va cere sa dati <strong>o parola pentru conturile de administrator<\/strong>. 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>\r\n\r\n\r\n\r\n<p>Dupa instalare accesati utilitarul Run SQL Command Line\u00a0 unde va veti conecta la serverul de SQL cu contul de administrator astfel:<\/p>\r\n\r\n\r\n\r\n<p><strong>sql&gt; CONN SYS AS SYSDBA <\/strong><\/p>\r\n\r\n\r\n\r\n<p><strong>sql&gt;<\/strong> parola furnizata la instalare sau va puteti conecta fara parola (SQL Plus ignora parola)<\/p>\r\n\r\n\r\n\r\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>\r\n\r\n\r\n\r\n<p><strong>sql&gt; CREATE USER STUDENT IDENTIFIED BY STUDENT DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;<\/strong><\/p>\r\n\r\n\r\n\r\n<p>(se va realiza crearea unui user cu numele STUDENT si parola STUDENT)<\/p>\r\n\r\n\r\n\r\n<p><strong>sql&gt; ALTER USER STUDENT QUOTA 100M ON USERS;<\/strong><\/p>\r\n\r\n\r\n\r\n<p><strong>sql&gt; GRANT CONNECT TO STUDENT;<\/strong><\/p>\r\n\r\n\r\n\r\n<p><strong>sql&gt; GRANT CREATE TABLE TO STUDENT;<\/strong><\/p>\r\n\r\n\r\n\r\n<p><strong>sql&gt; GRANT CREATE VIEW TO STUDENT;<\/strong><\/p>\r\n\r\n\r\n\r\n<p><strong>sql&gt; GRANT CREATE SEQUENCE TO STUDENT;<\/strong><\/p>\r\n\r\n\r\n\r\n<p><strong>sql&gt; GRANT CREATE TRIGGER TO STUDENT;<\/strong><\/p>\r\n\r\n\r\n\r\n<p><strong>sql&gt;<\/strong> <strong>GRANT CREATE SYNONYM TO STUDENT;<\/strong><\/p>\r\n\r\n\r\n\r\n<p><strong>sql&gt; GRANT CREATE PROCEDURE TO STUDENT;<\/strong><\/p>\r\n\r\n\r\n\r\n<p>La urma va conectati cu contul Student:\u00a0 CONN STUDENT\u00a0\u00a0cu parola STUDENT<\/p>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n<p><strong>2) Pentru instalarea SQL Developer \u0219i modul de conectare la baza de date Oracle<\/strong>:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>In primul rand trebuie sa aveti instalat Oracle 11g XE (Express edition)<\/li>\r\n<li>Desc\u0103rca\u0163i SQL Developer <a href=\"https:\/\/www.oracle.com\/tools\/downloads\/sqldev-downloads.html\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (se deschide \u00eentr-o fil\u0103 nou\u0103)\">https:\/\/www.oracle.com\/ro\/database\/technologies\/appdev\/sql-developer.html<\/a> (versiunea windows 64). Alegeti arhiva cu jdk inclus. Este posibil sa va ceara sa va logati, caz in care va puteti face rapid un cont Oracle, dureaza 2 minute. Dupa logare download-ul va porni automat.\u00a0<\/li>\r\n<\/ul>\r\n<p>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Dezarhiva\u0163i arhiva de mai sus \u00eentr-un director la alegere.<\/p>\r\n<ul>\r\n<li>Porni\u0163i SQL developer din directorul in care l-a\u0163i dezarhivat.<\/li>\r\n<li>Ap\u0103sa\u0163i butonul + (verde, st\u00e2nga-sus) pentru crearea unei noi conexiuni.<\/li>\r\n<li>Completa\u0163i informa\u0163iile ca \u00een\u00a0<a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2018\/02\/conectare.jpg\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (se deschide \u00eentr-o fil\u0103 nou\u0103)\">https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2018\/02\/conectare.jpg<\/a><\/li>\r\n<li>In cazul in care conexiunea nu poate fi efectuata, verificati sa aveti pornite serviciile Oracle necesare (OracleServiceXE si OracleXETNSListener)<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\"><strong>II) Pentru lucrul la orele de laborator<\/strong>:<\/h2>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<ul>\r\n<li>Atat pentru orele de laborator\/seminar cat si pentru orele de curs veti utiliza cursurile de pe paltforma Academy Oracle.<\/li>\r\n<li>Vom lucra cu urmatoarele scheme de baze de date: <a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2022\/03\/PLSQL_Schema_ERD_and_Table_Designs.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">PLSQL_Schema_ERD_and_Table_Designs<\/a><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<ul>\r\n<li>Scriptul pentru crearea bazei de date este: \u00a0<a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/05\/PLSQL_Schema.zip\" target=\"_blank\" rel=\"noopener noreferrer\">PLSQL_Schema<\/a>. Il gasiti de asemea pe TEAMS sectiunea FILES. Dupa dezarhivare deschideti acest script in SQL Developer si rulati-l.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<ul>\r\n<li>Un mic indrumar despre PLSQL: <a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2022\/03\/Mini-tutorial-oracle.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Mini tutorial oracle<\/a><\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p><strong>Teme laborator:<\/strong><\/p>\r\n\r\n\r\n\r\n<p>Recapitulare SQL : teorie BD + SQL \u00a0<\/p>\r\n<ul class=\"wp-block-list\">\r\n<li><a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2015\/02\/PLSQL_l1.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">PLSQL_l1<\/a>\u00a0<\/li>\r\n<li><a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2015\/02\/PLSQL_l2.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">PLSQL_l2<\/a><\/li>\r\n<li><a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2015\/02\/PLSQL_l3.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">PLSQL_l3<\/a>\u00a0<\/li>\r\n<li><a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2015\/02\/PLSQL_l4.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">PLSQL_l4<\/a><\/li>\r\n<li><a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2012\/04\/subselect.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">\u00a0Subcereri<\/a><\/li>\r\n<\/ul>\r\n<p>\r\n\r\n<\/p>\r\n<ol class=\"wp-block-list\">\r\n<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<\/li>\r\n<li><a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/04\/Tema-2-oracle-4.pdf\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Tema 2 (se deschide \u00eentr-o fil\u0103 nou\u0103)\">Tema 2<\/a> PL\/SQL<\/li>\r\n<\/ol>\r\n<p>\u00a0 \u00a0 \u00a03. <a href=\"https:\/\/cadredidactice.ub.ro\/wp-content\/uploads\/sites\/284\/2020\/04\/Tema-3-oracle-1.pdf\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Tema 3 (se deschide \u00eentr-o fil\u0103 nou\u0103)\">Tema 3<\/a> PL\/SQL<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Pagina dedicata laboratoarelor de SGBD\/ABD &#8211; 2022 I) Pregatirea mediului de lucru 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 &hellip;<\/p>\n<p class=\"read-more\"><a href=\"https:\/\/cadredidactice.ub.ro\/simonavarlan\/sgbd-2022\/\">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-2328","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/wp-json\/wp\/v2\/pages\/2328","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=2328"}],"version-history":[{"count":24,"href":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/wp-json\/wp\/v2\/pages\/2328\/revisions"}],"predecessor-version":[{"id":2428,"href":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/wp-json\/wp\/v2\/pages\/2328\/revisions\/2428"}],"wp:attachment":[{"href":"https:\/\/cadredidactice.ub.ro\/simonavarlan\/wp-json\/wp\/v2\/media?parent=2328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}