1. Exam 70-461 – Querying lub Microsoft SQL neeg rau zaub mov 2012 : Microsoft Certified nyob rau hauv Lag luam txawj ntse

Hla mus rau cov ntsiab lus los ntawm

Tus thawj xeem sim koj muaj peev xwm mus nug ib tug Microsoft SQL neeg rau zaub mov 2012, uas txhais tau tias nws yuav mas kuaj koj cov kev txawj ntse SQL.

Cov nram no yog cov kev txawj ntsuas:

  • Tsim database khoom (24%)
    • Ntxhuav – Hloov; TEE; Hloov lub kem; Tsim
    • Views – Tsim, Hloov, TEE
    • Cov txheej txheem thiab kev khiav dej num
    • Yuam – txhais tuav tseg; cim tuav tseg; neej ntawd tuav tseg; thawj thiab txawv teb chaws yuam sij
    • DML mob – nested chiv; hom chiv; update zog; lis ntau kab nyob rau hauv ib tug kev sib kho; kev ua tau zoo uas siv cov chiv
  • Ua hauj lwm nrog cov ntaub ntawv (27%)
    • Xaiv
    • Sub lus nug – query kev npaj; pivot thiab unpivot; thov neeg teb xov tooj; CTE daim ntawv qhia; nrog daim ntawv qhia
    • Cov ntaub ntawv Hom – Siv cov ntaub ntawv hom, feem ntawm GUID (kev hloov, newsequentialid) on database kev ua tau zoo
    • Aggregate lus nug – Tshiab analytic zog; grouping poob lawm; ntsig txog aggregates; thov duas zog
    • Lus nug thiab tswj cov ntaub ntawv XML
  • Hloov cov ntaub ntawv (24%)
    • Tsim thiab hloov cov txheej txheem cia
    • Hloov cov ntaub ntawv los ntawm kev siv INSERT, Hloov tshiab, thiab RHO TAWM nqe lus
    • Union thiab Union TXHUA
    • Ua hauj lwm nrog kev khiav dej num – To taub deterministic, uas tsis yog-deterministic zog; scalar thiab rooj qhov tseem ceeb; Thov built-nyob rau hauv scalar zog; tsim thiab hloov muab neeg siv txhais zog (UDFs)
  • Troubleshoot thiab optimize
    • Optimize lus nug – To taub statistics; nyeem lus nug kev npaj; txoj kev npaj ntawm cov; DMVs; piv txwv; statistics IO; dynamic vs. parameterized lus nug; piav qhia txog qhov sib txawv tuaj koom nrog hom (Hash, Hauj lwm ua ke, Loop) thiab piav qhia txog cov scenarios lawv yuav siv nyob rau hauv
    • Tswj muas – Kos ib tug lw; to taub pib tran, txhaum, thiab rollback; Implicit vs tsi ntsees muas; rho tawm theem; Scope thiab hom xauv; trancount
    • Soj ntsuam kev siv cov kab-based ua hauj lwm vs. teem-based ua hauj lwm – Thaum siv cursors; feem ntawm scalar UDFs; ua ke ntau DML ua hauj lwm
    • Kev yuam kev tuav – Kev zaug / catch / muab; siv teeb raws li es tsis kab raws logic; lw kev tswj

Xov tooj ntawm cov lus nug: 45-55
Hom Lus nug: Multiple Xaiv (Tej zaum yuav muaj cov lus nug scernario)
Dua cov qhab-nees: 700 (This does not mean 70%. Each question is given a score.)
Lub sij hawm Tsis txhob: 120 feeb

Rov qab mus rau lub ntsiab zaub mov