Am tinut la Sinaia, Piatra Soimului, in urma unei crize(!), o prezentare de SqlServer 2012 pentru programatorii .NET de 2 zile * ( 3 ore dim + 3 ore seara)

Structura a fost urmatoarea:

1. Cine sunt eu

a. http://serviciipeweb.ro/iafblog/2013/06/03/activitate-profesionala-sumar-pentru-mine/

2. De ce sunteti aici

3. History

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. Normal Form – 3

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

i. http://www.gplivna.eu/papers/sql_join_types.htm

b. UNION, EXCEPT, INTERSECT, APPLY, IN, EXISTS

i. https://www.simple-talk.com/sql/performance/the-except-and-intersect-operators-in-sql-server/

c. Views

i. http://technet.microsoft.com/en-us/library/cc917715.aspx

restriction with indexes

d. Views si ORDER BY

i. Top 100 Percent

e. SCHEMABINDING

i.

8. Agregarea si pivotarea datelor

i. GROUP BY

ii. HAVING

b. WITH ROLLUP, WITH CUBE

i. |Grouping_ID : http://technet.microsoft.com/en-us/library/bb510624.aspx

c. Pivotarea datelor

i. http://www.kodyaz.com/articles/t-sql-pivot-tables-in-sql-server-tutorial-with-examples.aspx

9. Modificarea datelor

a. INSERT SELECT, INSERT EXEC, BULK INSERT

ZIUA 2

1. PSR – Snipping tool
2. Exists
3. Cross apply
4. Update Join
5. newSqlServer 2012
6. Sequences
7. MERGE
8. Paging
9. Indexes
10. Encrypt
11. Decimal
12. Lock

La fiecare subiect am avut o parte de teorie si o parte de exercitii . La acestea m-am folosit de  curs si de AdventureWorks 2012.