1. Cine sunt eu
2. De ce sunteți aici
3. Prezentare generală
a. Database
i. Navigational
ii. Sql – ACID
iii. OO
iv. NoSQL – AZURE
b. Technologies: ADO, ADO.NET, L2S, EF
4. http://en.wikipedia.org/wiki/Codd’s_12_rules
5. Forme normale (<= FN3)
1. not repeating: order, item1, item2
2. No partial dependencies on concatenated key: orderid, lineid, orderdate
3. No dependencies on non-key attributes : orderid, orderdate, customername, customer city
Bill Kent: “[Every] non-key [attribute] must provide a fact about the key, the whole key, and nothing but the key.”
6. Update versus EF
7. Combinarea seturilor de date, views
a. Tipuri de JOIN: http://www.gplivna.eu/papers/sql_join_types.htm
b. UNION, EXCEPT, INTERSECT, APPLY, IN, EXISTS: https://www.simple-talk.com/sql/performance/the-except-and-intersect-operators-in-sql-server/
c. Views: http://technet.microsoft.com/en-us/library/cc917715.aspx
d. Views si ORDER BY și Top 100 Percent
e. SCHEMABINDING
8. Agregarea și pivotarea datelor
a. GROUP BY
b. HAVING
c. ROLLUP, CUBE
d. GROUPING_ID: http://technet.microsoft.com/en-us/library/bb510624.aspx
e. Tabele pivot: http://www.kodyaz.com/articles/t-sql-pivot-tables-in-sql-server-tutorial-with-examples.aspx
9. Actualizarea datelor
a. INSERT [SELECT], row constructors, INSERT EXEC, BULK INSERT
b. UPDATE [JOIN]
c. DELETE
d. MERGE
10. IDENTITY, SEQUENCES, secvențe “custom”
11. Paging: soluții bazate pe SQL Server 2005 si SQL Server 2012
12. Indexes
13. Encrypt
14. DECIMAL, FLOAT(REAL), [SMALL]MONEY
15. LOCK
