Clasa+12+INFO

= Materiale =
 * ** Modelul conceptual **
 * **Lectii online**
 * **Normalizarea datelor**
 * ** [[file:normalizarea_datelor.pptx|Prezentare]] **
 * ** [[file:Exemple ERD.pptx|Exercitii]] **
 * **[[file:autoevaluare_erd.docx|Exercitii Model conceptual]](ERD)**
 * ** Maparea **
 * **[[file:exercitii mapare.docx|Exercitii finale Mapare]]**
 * **[[file:exercitii mapare.docx|Exercitii finale Mapare]]**

>>>>>>> **Username**: RO_1773_SQL01_S41 ..... RO_1773_SQL01_S60
 * **Conectare** ** Oracle Application Express **
 * **Workspace**: RO_1773
 * ** [[file:Fisa de lucru.docx|Fisa de lucru recapitulativa]] **


 * ====**Lectii Oracle:**====
 * ===**[[file:05select_formagenerala.ppt|Comanda Select ]]**===
 * ====**[[file:Crearea si modificarea structurii tabelelor.pptx|Crearea tabelelor]]**====
 * **[[file:Modificarea structurii unei tabele.pptx|Modificarea structurii tabelelor]]**
 * **[[file:ex_pag251_B.txt|ex_manual]]**
 * **[[file:Functii singulare2.pptx|Functii siruri]]**
 * **[[file:Functii numerice.pptx|Functii numerice]]**
 * **[[file:Funcţii_date_calendaristice.pptx|Functii asupra datelor calendaristice]]**
 * **[[file:Functii de conversie.pptx|Functii de conversie]]**
 * **[[file:Funcţii de uz general.pptx|Functii uzuale]]**
 * **[[file:interogari multiple.docx|Interogari multiple]]**
 * **[[file:outerjoin.pptx|Outer join]]**
 * **[[file:Operatorii UNION, INTERSECT, MINUS.pptx|Functii pentru multimi si functii de grup]]**
 * **[[file:Gruparea datelor.pptx|Group by si Having]]**
 * **[[file:Subinterogari_final.pptx|Subinterogari]]**
 * **[[file:Subinterogari_multiple.pptx|Subinterogări multiple]]**
 * [[file:View-vederi.pptx|Vederi]] http://www.runceanu.ro/adrian/wp-content/cursuri/bd2013/C10-BD.pdf

= FIŞE DE LUCRU =
 * **Maparea relatiilor : [[file:dd_s11_l03_try.pdf|ex1, ]]**
 * ** Maparea relatiilor : [[file:exercitii mapare.docx|ex2]] **

** SQL : **

 * [[file:dd_s15_l01_try.pdf|fisa1 ]]- Anatomia unei comenzi SQL
 * [[file:dd_s16_l01_try.pdf|fisa2]]- Coloane, randuri, caractere
 * [[file:dd_s16_l02_try.pdf|fisa3]]- Limitarea randurilor selectate
 * pt.ex 1 folositi tabelul F_CUSTOMERS
 * pt ex2 folositi F_PROMOTIONAL_MENUS
 * pt ex 3 folositi D_CDS
 * pt ex 5 folositi D_CDS
 * pt ex 10 ...d_cds
 * [[file:dd_s16_l03_try.pdf|fisa4]]- Operatori relationali/logici
 * 1. f_staffs
 * 2. d_venues
 * 4. d_cds
 * 5. d_parteners
 * 6. employees
 * 8. d_songs
 * [[file:dd_s17_l01_try.pdf|fisa5]]- Comparatii si reguli de precedenta
 * 2. f_staffs
 * 3. f_staffs
 * 5. d_venues
 * 7. employees
 * 8. employees
 * [[file:dd_s17_l02_try.pdf|fisa6 - ]] Sortarea randurilor
 * 2.d_cds
 * 3.d_songs
 * [[file:Fisa_de_lucru_select.docx|Fisa recapitulativa]]
 * [[file:exercitii Oracle SQL.txt|Fisa Select ]]
 * fisa 7 -creare [[file:Test 1_create.docx|exercitiu ]]
 * fisa 8 - [[file:dp_s07_l01_try.pdf|inserare]]
 * fisa 9 - [[file:dp_s07_l02_try.pdf|actualizare]]
 * fisa 10- [[file:ltin/dp_s01_l01_try.pdf|functii pentru siruri]], [[file:ltin/dp_s01_l02_try.pdf|functii pentru date numerice]]
 * [[file:dp_s01_l03_try.pdf|fisa 11 - functii pentru date calendaristice>]]
 * ! F[[file:fisa_FCTII_SINGULARE.doc|isa recapitulativă(fctii singulare)]]
 * fisa 12: [[file:dp_s02_l02_try.pdf|NULL Functions]]
 * fisa 13: [[file:dp_s02_l03_try.pdf|Conditional Expressions]]
 * fisa 14: N[[file:dp_s03_l01_try.pdf|atural join]]
 * fisa 15:[[file:dp_s03_l02_try.pdf|Equijoin]]
 * fisa 16: [[file:dp_s03_l03_try.pdf|join]]
 * [[file:ltin/dp_s04_l01_try.pdf|Recapitulare join]]
 * fisa 17:[[file:dp_s04_l02_try.pdf| Functii de grup]]
 * [[file:dp_s05_l01_try.pdf|Fisa 18:Group by si Having]]
 * [[file:ltin/dp_s04_l03_try.pdf|Fisa 19.1: Count,Distinct,NVL]]
 * [[file:Fisa de lucru 2_group_by_having.docx|Fisa 19.2 ]]
 * [[file:Fisa de lucru_functii_de_grup2.docx|Fisa 20 ]]
 * [[file:Fișa recapitulativă Join_f_de_grup.docx|Fisa recapitulativa]]
 * [[file:Fisa_subinterogari.docx|Fișa subinterogari simple]]
 * [[file:Fișa de lucru_12_subinterogari.docx|Fișa subinterogări]]
 * [|Fisa vederi, sinonime...]
 * [|Fisa vederi, sinonime...]

= Atestat 2015 (NOU !!!) =
 * 1) [[file:atestat2015.zip|Arhiva subiecte 2015]]
 * Programare C/C++ [[file:ltin/subiecte_PROGRAMARE_2015Bun.pdf|subiecte_PROGRAMARE_2015Bun.pdf]]
 * Baze de date [[file:ltin/subiecte_BD_atestat2015.pdf|subiecte_BD_atestat2015.pdf]]
 * Office [[file:ltin/subiecte_OFFICE_2015.pdf|subiecte_OFFICE_2015.pdf]]

2. Proiect atestat pe suport electronic(CD, DVD);
 * [[file:Teme_atestat_2015.docx|Teme atestat 2015]]
 * ** [[file:Atestat Street Dance.zip|Model atestat ]] **
 * ** [[file:Flower.zip|Model Sablon]], **** [[file:site.txt|adrese utile]] **
 * Documentație proiect pe suport electronic(alături de proiect):
 * Coperta - [[file:ltin/coperta_atestat.docx|model_coperta_atestat]]
 * Motivarea temei alese
 * Descrierea tehnologiilor utilizate(cu detalierea elementelor utilizate în dezvoltarea proiectului)
 * Prezentarea proiectului(etape de dezvoltare, capturi ecran, cod sursa, etc.)

Extinderi posibile ale aplicaţiei.

 * Cuprins(automat)
 * exemplu :[]

= Atestat 2013 =


 * [[file:Enunturi BD_2013_2.docx|Subiecte baze de date 2013, ]]
 * ** [[file:Subiecte rezolvate atestat Baze de date Atestat.docx|sub 10-13]] **
 * ** [[file:ex_atestat_bd_14_16.docx|sub 14-16]] **
 * ** [[file:ex_atestat_bd_28_30.docx|sub 28-30]] **


 * [[file:Enunturi Office_2013_2.docx|Subiecte TIC 2013]]
 * ** [[file:TEME PROIECTE atestat INFORMATICA.docx|Teme proiecte atestat]] **

**Bacalaureat Informatică**
 * ===[[file:info_bac_2009_100_variante.pdf|Subiecte BAC Informatica]]===
 * []
 * [|Rezolvare 55 Modele subiecte bac 2009]
 * [|Rezolvari grafuri bac]

Subiecte ani anteriori
 * [|Subiecte Bacalaureat]
 * Simulari
 * [[file:simulare 2014.zip|2014 - simulare]]
 * [[file:simulare info 2015.zip|2015- simulare]]
 * [[file:simulare_info_2016.rar|2016 - simulare]]