1. Udomo 70-461 – Querying Microsoft SQL Server 2012 : Microsoft akwụkwọ na Business ọgụgụ isi

The first exam tests your ability to query a Microsoft SQL Server 2012, nke pụtara na ọ ga-bụ nwaa gị SQL ihe ọmụma.

Ihe na-esonụ na-nkà tụọ:

  • Mepụta nchekwa data akpọkwa (24%)
    • Tebụl – Nad; Dobe; Nad na kọlụm; Mepụta
    • Views – Mepụta, Nad, Dobe
    • Usoro na Ọrụ
    • Manyere – kọwaa constraints; pụrụ iche constraints; ndabere constraints; isi na mba ọzọ na mkpịsị ugodi
    • DML Triggers – kpara akwụ triggers; iche nke triggers; melite ọrụ; aka otutu ahịrị a nnọkọ; ịrụ ọrụ pụtara nke triggers
  • Na-arụ ọrụ na data (27%)
    • Họrọ
    • Mpaghara Sub gbara ajụjụ – ajụjụ atụmatụ; pivot na unpivot; ide ọrụ; cte kwuru; na na nkwupụta
    • Data iche – Iji data ụdị, mmetụta nke GUID (mgbanwe, newsequentialid) na nchekwa data arụmọrụ
    • Rụpụta mkpokọta nchịkọta gbara ajụjụ – New analytic ọrụ; grouping adaa; gbasara ohere aggregates; ide nọ n'ọkwá ọrụ
    • Ajụjụ na jikwaa XML data
  • Gbanwee data (24%)
    • Mepụta na-agbanwe ịchekwa usoro
    • Gbanwee data site na iji Fanye, Melite, na Nhichapụ okwu
    • Union na Union nile
    • Ọrụ na ọrụ – Ihe deterministic, na-abụghị ndị deterministic ọrụ; scalar na tebụl ụkpụrụ; Mee wuru-na scalar ọrụ; ike na-agbanwe ọrụ-kọwaa ọrụ (UDFs)
  • Troubleshoot na-ebuli
    • Ebuli gbara ajụjụ – Ihe ndekọ ọnụ ọgụgụ; ịgụ ajụjụ atụmatụ; atụmatụ nduzi; DMVs; mma; ọnụ ọgụgụ IO; ike na na. parameterized gbara ajụjụ; kọwaa dị iche iche iso iche (HASH, Jikọrọ ọnụ, LOOP) na kọwaa ndapụta na ha ga-eji na-
    • Jikwaa Azụmahịa – Kaa a azụmahịa; Ghọta na-amalite tran, ime, na rollback; isịne vs Akowara azụmahịa; iche na ọkwa; akporo na ụdị ji akpọchi; trancount
    • Nyochaa iji ihe n'usoro dabeere na arụmọrụ vs. ka dabeere na arụmọrụ – Mgbe iji cursors; mmetụta nke scalar UDFs; ikpokọta otutu DML arụmọrụ
    • Mejuputa njehie njikwa – Mejuputa Gbalịa / gbutere / otutu; iji set dabeere kama n'usoro dabeere na mgbagha; azụmahịa management

Ọnụ ọgụgụ nke Ajụjụ: 45-55
Ụdị nke Ajụjụ: Otutu Nhọrọ (Ka nwere scernario ajụjụ)
Agafe Akara: 700 (This does not mean 70%. Each question is given a score.)
Oge amachi: 120 nkeji

Azu isi menu

Nkume a-aza