The first exam tests your ability to query a 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