Idatha yokudinga nge-Transact-SQL

Idatha yokuqamba nge-Transact SQL Training Course & Certification

Incazelo

Izilaleli & Izidingo Zokuqala

Uhlaka Lokufunda

Uhlelo noHlelo

Certification

Ukuqaphela idatha nge-Transact SQL Ukubuka konke ukuqeqeshwa

Le nkambo yakhelwe ukwethula abafundi ku-Transact-SQL. Yenzelwe ngendlela yokuthi izinsuku ezintathu zokuqala zifundiswe njengenkambo kubafundi abafuna ulwazi kwezinye izifundo ku- I-SQL Server ikharikhulamu. Izinsuku ze-4 ne-5 zifundisa amakhono asele adingekayo ukuthatha ukuhlolwa kwe-70-761.

Izinhloso zokufuna idatha nge-Transact SQL Training

  • Chaza amakhono abalulekile nezinxenye ze-SQL Server 2016.
  • Chaza i-T-SQL, isethi, kanye nencazelo yokubikezela.
  • Bhala ithebula elilodwa.
  • Bhala isitatimende se-SELECT SELECT.
  • Bhala izitatimende zokukhetha ngokuhlunga nokuhlunga.
  • Chaza ukuthi i-SQL Server isebenzisa kanjani izinhlobo zedatha.
  • Bhala izitatimende ze-DML.
  • Bhala imibuzo esebenzisa imisebenzi eyakhelwe ngaphakathi.
  • Bhala imibuzo eqoqa idatha.
  • Bhala imibhalo engezansi.
  • Dala futhi usebenzise imibono kanye nemisebenzi ehlisiwe etafuleni.
  • Sebenzisa abasebenzisi bokusetha ukuhlanganisa imiphumela yombuzo.
  • Bhala imibuzo esebenzisa ukuma kwefasitela, ukukhipha, kanye nemisebenzi ehlanganisiwe.
  • Guqula idatha ngokusebenzisa i-pivot, i-unpivot, i-rollup ne-cube.
  • Dala futhi usebenzise izinqubo ezigcinwe.
  • Yengeza izinhlelo zokwakha ezifana neziguquko, izimo, futhi ukhiphe ikhodi ye-T-SQL.

Izilaleli ezihlosiwe zezinhloso zokufuna idatha nge-Transact - SQL

Inhloso eyinhloko yenkambo ukunikeza abafundi ukuqonda kahle ulimi lwe-Transact-SQL olusetshenziswa yizo zonke iziyalo ezihlobene ne-SQL Server; okungukuthi, Ukuphathwa Kwemininingwane, Ukuthuthukiswa Kwemininingwane kanye Nezobunhloli Zebhizinisi. Njengalokhu, izethameli eziyinhloko ezibhekiswe kule nkambo yizi: Abaphathi BaseDathayli, abaSebenzi beDatabas Developers kanye neBI.

Isikhathi sokuphuma kwesikhathi sezinkathi: Izinsuku ze-5

I-Module 1: Isingeniso kwi-Microsoft SQL Server 2016

Le module iveza iSQL Server, izinguqulo ze-SQL Server, kufaka phakathi izinguqulo zefu, nendlela yokuxhuma ku-SQL Server isebenzisa i-SQL Server Management Studio.Izici

  • I-Basic Architecture ye-SQL Server
  • Ama-Editions we-SQL Server nama-Versions
  • Ukuqalisa nge-SQL Server Management Studio

I-Lab: Ukusebenza ngamathuluzi we-SQL Server 2016

  • Ukusebenza ne-SQL Server Management Studio
  • Ukudala nokuhlela izikripthi ze-T-SQL
  • Ukusebenzisa Izincwadi Online

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza imininingwane yokuxhumana ne-Transact-SQL.
  • Chaza izinhlelo ezisemthethweni kanye nezinhlelo ze-cloud nezinguqulo ze-SQL Server.
  • Chaza ukuthi ungasebenzisa kanjani i-SQL Server Management Studio (SSMS) ukuxhuma kusibonelo se-SQL Server, ukuhlola ulwazi oluqukethwe kulokhu, futhi usebenzise amafayela weskripthi aqukethe imibuzo ye-T-SQL.

I-Module 2: Isingeniso ku-T-SQL Ukucaphuna

Le module ichaza izakhi ze-T-SQL kanye nendima yazo emibhalweni yokubhala. Chaza ukusetshenziswa kwamasethingi ku-SQL Server. Chaza ukusetshenziswa kwelogi lokubikezela ku-SQL Server. Chaza ukulandelana okunengqondo kwemisebenzi kuZINYE izitatimende. Izifundo

  • Ukwethulwa kwe-T-SQL
  • Izinkinobho zokuqonda
  • Ukuqonda i-Predicate Logic
  • Ukuqonda i-Logical Order of Operations kuZITATIMENDE ezikhethiwe

I-Lab: Isingeniso sokuthi ukukhishwa kwe-T-SQL

  • Ukusebenzisa izitatimende eziyisisekelo zokukhetha
  • Imibuzo Esebenzayo Ehlunga Idatha ngokusebenzisa Ama-Predicates
  • Ukusebenza Imibuzo Ehlela Ukwaziswa Nge-ORDER BY

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza indima ye-T-SQL ngokubhala Bhala izitatimende.
  • Chaza izakhi zolimi lwe-T-SQL nokuthi yiziphi izakhi ezizosiza emibhalweni yokubhala.
  • Chaza imibono ye-theory ehleliwe, enye yezibalo ezingezansi zezibalo zokuxhumana, futhi ikusize ukuthi uyisebenzise ngendlela ocabanga ngayo ngokucwaninga iSQL Server
  • Chaza logical predicate bese uhlola uhlelo lwakho lokufaka isicelo se-SQL Server.
  • Chaza izakhi zesitatimende SOKUKHETHA, uhlathulule umyalelo lapho izakhi zihlolwe khona, bese usebenzisa lokhu kuqonda ngendlela esebenzayo yokubhala imibuzo.

I-Module 3: Ukubhala QALA imibuzo

Le module iveza okuyisisekelo esitatimendeni sokukhetha, sigxile emibuthanweni ebhekene netafula elilodwa.Izici

  • Ukubhala Okulula SELECT Izitatimende
  • Ukuqeda izimpendulo nge-DISTINCT
  • Ukusebenzisa i-Column ne-Table Aliases
  • Ukubhala okulula kwama-CASE Expressions

I-Lab: Ukubhala Okuyisisekelo SELECT Statements

  • Ukubhala Okulula SELECT Izitatimende
  • Ukuqeda ukuphindaphinda kokusebenzisa i-DISTINCT
  • Ukusebenzisa i-Column ne-Table Aliases
  • Ukusebenzisa i-Simple CASE Expression

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza isakhiwo nesakhiwo sesitatimende sokukhetha, kanye nezithuthukisi ezizofaka ukusebenza nokufunda imibuzo yakho
  • Chaza indlela yokuqeda ama-duplicates usebenzisa isigatshana se-DISTINCT
  • Chaza ukusebenzisa ukusetshenziswa kwekholomu kanye nezibhebhe zethebula
  • Qonda futhi usebenzise izinkulumo ze-CASE

I-Module 4: Ukucaphuna amathebula amaningi

Le module ichaza indlela yokubhala imibuzo ehlanganisa idatha evela kwimithombo eminingi ku-Microsoft SQL Server 2016. Izifundo

  • Ukuqonda Kujoyina
  • Ukuzama ukujoyina kwangaphakathi
  • Ukucubungula nge-Outer Joins
  • Ukuzibandakanya nge-Cross Joins and Self Self

I-Lab: Ukucaphuna amathebula amaningi

  • Ukubhala Imibuzo esebenzisa Ukujoyina Okungaphakathi
  • Ukubhala Imibuzo esebenzisa ama-Multiple-Table Inner Joins
  • Ukubhala Imibuzo esebenzisa Ukuzihlanganisa Ngokuzihlanganisa
  • Ukubhala Imibuzo esebenzisa Ukuhlangana Okungaphandle
  • Ukubhala Imibuzo esebenzisa ukuhlangana okuPhambene

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza okuyisisekelo kokujoyina ku-SQL Server 2016
  • Bhala imibuzo yokujoyina ngaphakathi
  • Bhala imibuzo esebenzisa ukungena kwangaphandle
  • Sebenzisa izinhlobo zokujoyina ezengeziwe

I-Module 5: Ukuhlunga nokuhlunga idatha

Le module ichaza indlela yokuqalisa ukuhlunga nokuhlunga.Izici

  • Ukuhlela idatha
  • Ukuhlunga Idatha ngama-Predicates
  • Ukuhlunga idatha nge-TOP ne-OFFSET-FETCH
  • Ukusebenza Ngezimiso ezingaziwa

Ilabhu: Ukuhlunga nokuhlunga idatha

  • Ukubhala Imibuzo ehlunga idatha ngokusebenzisa i-WHERE Clause
  • Ukubhala Imibuzo Ehlela Ukwaziswa Ngokusebenzisa i-ORDER BY Clause
  • Ukubhala Imibuzo Ehlunga Idatha Ukusebenzisa i-TOP Option

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza indlela ongeza ngayo isigatshana se-ORDER BY kumbuzo yakho ukulawula ukulandelana kwemigqa ekhonjisiwe ekuphumeni kombuzo wakho
  • Chaza ukuthi ungakha kanjani izigaba ze-WHERE ukuze uhlunge imigqa engafani nalesi sisho.
  • Chaza ukuthi unganciphisa kanjani imigqa yemigqa kusigaba SELECT ukusebenzisa inketho TOP.
  • Chaza ukuthi unganciphisa kanjani imigqa yemigqa usebenzisa i-OFFSET-FETCH inketho ye-ORDER BY isigatshana.
  • Chaza ukuthi ama-logic ama-logic angama-value angani angaziwa futhi angalahleki, ukuthi i-SQL Server isebenzisa kanjani i-NULL ukukhomba amanani angekho, nokuthi ungahlola kanjani i-NULL emibuthanweni yakho.

I-Module 6: Ukusebenzisana Nezinhlobo Zedatha ye-SQL Server 2016

Le module iveza izinhlobo zedatha i-SQL Server isebenzisa ukugcina idatha.Izici

  • Ukwethulwa Kwezinhlobo Zedatha ye-SQL Server 2016
  • Ukusebenza ne-Character Data
  • Ukusebenza Datha Nesikhathi Idatha

I-Lab: Ukusebenzisana nohlobo lwemininingwane yedatha ye-SQL Server 2016

  • Ukubhala Imibuzo ukuthi Idatha Nesikhathi Sokubuya
  • Ukubhala Imibuzo esebenzisa Imisebenzi Yosuku Nesikhathi
  • Ukubhala Imibuzo Echaza Imininingwane Yobuntu
  • Ukubhala Imibuzo Efana Nokubuyiswa Komuntu

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Hlola eziningi zezinhlobo zedatha i-SQL Server isebenzisa ukugcina idatha nokuthi indlela yedatha iguqulwa kanjani phakathi kwezinhlobo
  • Chaza izinhlobo zedatha ezisuselwe kumlingiswa we-SQL Server, ukuthi ukufaniswa komlingiswa kusebenza kanjani, neminye imisebenzi evamile ongayithola ewusizo emibutheni yakho
  • Chaza izinhlobo zedatha ezisetshenziselwa ukugcina idatha yesikhashana, ukufaka izinsuku nezinkathi ukuze zihanjiswe kahle yi-SQL Server, nokuthi ungasebenzisa kanjani izinsuku nezinkathi ngemisebenzi eyakhelwe ngaphakathi.

I-Module 7: Ukusebenzisa i-DML ukuze ushintshe idatha

Le module ichaza indlela yokwakha imibuzo ye-DML, nokuthi kungani ungathanda.Izici

  • Ukufaka imininingwane
  • Ukuguqula nokususa idatha

I-Lab: Ukusebenzisa i-DML ukuze ushintshe idatha

  • Ukufaka imininingwane
  • Ukubuyekeza nokususa idatha

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Sebenzisa IZIMBUZO ZOKUSETSHENZISWA NOKUKHETHA
  • Sebenzisa QAPHELA, HLUNGISA, SUSELA, futhi U-TRUNCATE.

I-Module 8: Ukusebenzisa Imisebenzi eyakhelwe ngaphakathi

Le module iveza ezinye zezinto eziningi ezakhiwe emisebenzini ku-SQL Server 2016.Izici

  • Ukubhala Imibuzo NgemiSebenzi Engakhelwe
  • Ukusebenzisa Imisebenzi Yokuguqulwa
  • Ukusebenzisa Imisebenzi Eyingqayizivele
  • Ukusebenzisa Imisebenzi Yokusebenza NULL

Ilabhu: Ukusebenzisa Imisebenzi Eyakhelwe ngaphakathi

  • Ukubhala Imibuzo Esebenzisa Imisebenzi Yokuguqula
  • Ukubhala Imibuzo esebenzisa Imisebenzi Engokomzwelo
  • Ukubhala Imibuzo Evivinywa Ukungafinyeleli

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza izinhlobo zemisebenzi enikezwa yi-SQL Server, bese ugxila ekusebenzeni ngemisebenzi ye-scalar
  • Chaza indlela yokuguqula ngokucacile idatha phakathi kwezinhlobo usebenzisa imisebenzi eminingi ye-SQL Server
  • Chaza ukuthi ungasebenzisa kanjani imisebenzi enengqondo ehlola inkulumo bese ubuyela umphumela we-scalar.
  • Chaza imisebenzi eyengeziwe yokusebenza ne-NULL

I-Module 9: Ukuqoqa nokuhlanganisa idatha

Le module ichaza indlela yokusebenzisa imisebenzi ehlanganisiwe.Izici

  • Ukusebenzisa imisebenzi ehlanganisiwe
  • Usebenzisa i-GROUP BY Clause
  • Ukuhlunga amaqembu ane-HAVING

Ilabhu: Ukuhlanganisa nokuhlanganisa idatha

  • Ukubhala Imibuzo Esebenzisa i-GROUP BY Clause
  • Ukubhala Imibuzo Esebenzisa Imisebenzi Yonke
  • Ukubhala Imibuzo Esebenzisa Imisebenzi Yokuhlukanisa Ehlukile
  • Ukubhala Imibuzo Ehlunga Amaqembu NESIGABA ESIFUNDA

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza umsebenzi ohlanganisiwe we-SQL Server bese ubhala imibuzo usebenzisa.
  • Bhala imibuzo ehlukanisa imigqa esebenzisa isigatshana se-GROUP BY.
  • Bhala imibuzo esebenzisa isigatshana se-HAVING ukuze uhlunge amaqembu.

I-Module 10: Ukusebenzisa i-Subqueries

Le modula ichaza izinhlobo eziningana ze-subquery nokuthi zingayisebenzisa kanjani futhi nini.Izici

  • Ukubhala ama-Subqueries ayenayo
  • Ukubhalwa kwe-Subqueries ehlanganisiwe
  • Ukusebenzisa i-EXISTS Predicate ne-Subqueries

I-Lab: Ukusebenzisa i-Subqueries

  • Ukubhala Imibuzo Esebenzisa Okuzenzekelayo Okuzenzekelayo
  • Ukubhala Imibuzo Esebenzisa Izigcawu Ze-Scalar ne-Multi-Result Subqueries
  • Ukubhala Imibuzo Esebenzisa Imibuzo Engaphansi Kwezixhumanisi kanye nesigatshana SOKUQALA

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza ukuthi yikuphi lapho okumele kwenziwe khona kungasetshenziswa esitatimendeni sokukhetha.
  • Bhala imibuzo esebenzisa izifundo ezihambelanayo phakathi nesitatimende sokukhetha
  • Bhala imibuzo esebenzisa izibikezelo ze-EXISTS ku-WHERE clause ukuze uhlole ukuthi kukhona imigqa efanelekayo
  • Sebenzisa isichazamazwi se-EXISTS ukuze uhlole ngokucophelela ukuba khona kwemigqa engaphansi kwe-subquery.

I-Module 11: Ukusebenzisa Ithebula Lamazwi

Ngaphambilini kule nkambo, ufunde mayelana nokusebenzisa ama-subqueries njengombhalo obuyisela imiphumela kumbuzo wokubiza wangaphandle. Njengama-subqueries, izinkulumo zethebula ziyizinkulumo zombuzo, kodwa izinkulumo zethebula zendlulisela lo mqondo ngokukuvumela ukuba uziqambe futhi usebenze ngemiphumela yazo njengoba uzosebenza nedatha kunoma yikuphi ithebula elihlobene lokusebenza. I-Microsoft SQL Server 2016 isekela izinhlobo ezine zezinkulumo zetafula: amatafula atholakele, inkulumo ejwayelekile yetafula (ama-CTE), ukubukwa, nemisebenzi ehlanganisiwe yetafula (TVFs). Kule modyuli, uzofunda ukusebenza nalezi zinhlobo zezinkulumo zetafula futhi ufunde ukuthi ungayisebenzisa kanjani ukusiza ukwakha indlela yokumemeza yokubhala imibuzo.Izici

  • Ukusebenzisa ukubukwa
  • Ukusebenzisa Imisebenzi Elinganiselwe Ithebulethi Elingaphakathi
  • Ukusebenzisa amathebula aguquliwe
  • Ukusebenzisa ukuveza okuvamile kwethebula

Ilabhu: Ukusebenzisa ukuveza kwethebula

  • Ukubhala Imibuzo Esebenzisa Ukubukwa
  • Ukubhala Imibuzo Esebenzisa Amathebula Aguquliwe
  • Ukubhala Imibuzo Esebenzisa Amagama Ethebula Ejwayelekile (ama-CTE)
  • Ukubhala Imibuzo Ebonayo Ithebula Elilinganiselwe-Imibono Eyigugu

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Bhala imibuzo ebuyisela imiphumela kusuka ekubukeni.
  • Sebenzisa isitatimende SOKUSEBENZA KOMSEBENZI ukuze udale ama-TV elula alula.
  • Bhala imibuzo edala futhi ithole imiphumela kusuka kumatafula atholakele.
  • Bhala imibuzo edala ama-CTE futhi ubuye imiphumela kusukela enkulumweni yetafula.

I-Module 12: Ukusebenzisa i-Set Operators

Le module iveza indlela yokusebenzisa abasebenzisi bokusetha UNION, INTERSECT, ne-EXCEPT ukuqhathanisa imigqa phakathi kwamaqoqo amabili wokufaka.

  • Ukubhala Imibuzo ne-UNION
  • Isebenzisa i-EXCEPT ne-INTERSECT
  • Ukusebenzisa i-APPLY

Ilabhu: Ukusebenzisa i-Set Operators

  • Ukubhala Imibuzo Esebenzisa i-UNION Setha abaSebenzi kanye ne-UNION ALL
  • Ukubhala Imibuzo Esebenzisa I-CROSS APPLY kanye NOMSEBENZI APPLY Abasebenzisi
  • Ukubhala Imibuzo Esebenzisa i-EXCEPT ne-INTERSECT Abasebenzisi

Ngemuva kokuqedela le module, abafundi bazokwazi:

  • Bhala imibuzo esebenzisa i-UNION ukuhlanganisa amasethi wokufaka.
  • Bhala imibuzo esebenzisa i-UNION ALL ukuhlanganisa amasethi wokufaka
  • Bhala imibuzo esebenzisa opharetha we-EXCEPT ukuze ubuyele imigqa kuphela kwisethi eyodwa kodwa hhayi enye.
  • Bhala imibuzo esebenzisa opharetha be-INTERSECT ukubuyela kuphela imigqa ekhona kuzo zombili isethi
  • Bhala imibuzo usebenzisa i-CROSS APPLY opharetha.
  • Bhala imibuzo usebenzisa i-OUTER APPLY opharetha

I-Module 13: Ukusebenzisa iWindows Ranking, Ukusethelwa kwe-Offset, kanye Nemisebenzi Ehlanganisiwe

Le module ichaza izinzuzo zokusebenzisa imisebenzi yewindi. Vimbela ukusebenza kwefasitela kumigqa echazwe esigatsheni se-OVER, kufaka phakathi izingxenye namafremu. Bhala imibuzo esebenzisa imisebenzi yefasitela ukuze isebenze efasiteleni lemigqa futhi ubuyekeze isikhundla, ukuhlanganiswa, kanye nokuqhathanisa imiphumela yokuqhathanisa.

  • Ukudala iWindows nge-OVER
  • Ukuhlola Imisebenzi YeWindows

Ilabhu: Ukusebenzisa iWindows Ranking, Ukusethelwa kwe-Offset, kanye Nemisebenzi Yokuhlanganyela

  • Ukubhala Imibuzo esebenzisa Imisebenzi Yokusezingeni
  • Ukubhala Imibuzo esebenzisa i-Offset Imisebenzi
  • Ukubhala Imibuzo esebenzisa Imisebenzi Ehlanganisiwe YeWindows

Ngemuva kokuqedela le module, abafundi bazokwazi:

  • Chaza izingxenye ze-T-SQL ezisetshenziselwa ukuchaza amawindi, kanye nobuhlobo phakathi kwabo.
  • Bhala imibuzo esebenzisa isigatshana se-OVER, ngokuhlukanisa, ukuhleleka, nokuhlela ukuchaza amawindi
  • Bhala imibuzo esebenzisa imisebenzi ehlanganisiwe yamawindi.
  • Bhala imibuzo esebenzisa imisebenzi yokubeka iwindi.
  • Bhala imibuzo esebenzisa imisebenzi ye-window offset

I-Module 14: Amasethingi okuvota nokuhlanganisa

Le module ichaza imibuzo ebhaliwe ehamba phambili futhi evulekile. Bhala imibuzo ecacisa amaqoqo amaningi ngokuqoqa amaqoqo Izifundo

  • Ukubhala Imibuzo nge-PIVOT no-UNPIVOT
  • Ukusebenza Nezinhlaka Zokuqoqa

Ilabhu: Izintambo zokuvota nokuqoqa

  • Ukubhala Imibuzo esebenzisa i-PIVOT Operator
  • Ukubhala Imibuzo esebenzisa i-UNPIVOT Operator
  • Ukubhala Imibuzo esebenzisa i-GROUPING SETS CUBE ne-ROLLUP Subclauses

Ngemuva kokuqedela le module, abafundi bazokwazi:

  • Chaza indlela idatha eguqukayo engasetshenziswa ngayo imibuzo ye-T-SQL.
  • Bhala imibuzo ehlanganisa idatha kusuka emigqeni kuya kumakholomu usebenzisa i-PIVOT.
  • Bhala imibuzo ukuthi idatha engahambisani namakholomu abuyele emigqeni usebenzisa i-UNPIVOT.
  • Bhala imibuzo usebenzisa i-GROUPING SETS.
  • Bhala imibuzo esebenzisa i-ROLLUP ne-CUBE.
  • Bhala imibuzo esebenzisa umsebenzi we-GROUPING_ID.

I-Module 15: Ukusebenzisa Izinqubo Ezigcinwe

Le module ichaza indlela yokubuyisela imiphumela ngokusebenzisa izinqubo ezigcinwe. Dlulisa imingcele enqubo. Yakha izinqubo ezigcinwe ezilula ezifaka isitatimende SELECT. Yakha futhi yenza iSQL enamandla nge-EXEC kanye ne-sp_executesql.Lessons

  • Idatha Yokufaka Ngezinqubo Ezigcinwe
  • Ukudlula Izingqungquthela ezinqubo ezigcinwe
  • Ukudala izinqubo ezigcinwe kalula
  • Ukusebenza ne-Dynamic SQL

I-Lab: Ukusebenzisa Izinqubo Ezigcinwe

  • Ukusebenzisa isitatimende se-EXECUTE ku-Invoke Procedures Procedures
  • Ukudlula Izingqungquthela ezinqubo ezigcinwe
  • Ukusebenzisa Izinqubo Zokugcinwa Kwesistimu

Ngemuva kokuqedela le module, abafundi bazokwazi:

  • Chaza izinqubo ezigcinwe nokusetshenziswa kwazo.
  • Bhala izitatimende ze-T-SQL ezenza izinqubo ezigcinwe ukubuyisela idatha.
  • Bhala izitatimende ze-EXECUTE ezedlulisa imingcele yokufakwayo ezinkambisweni ezigcinwe.
  • Bhala amathebhu we-T-SQL enza amalungiselelo okukhipha futhi enze izinqubo ezigcinwe.
  • Sebenzisa isitatimende SOKUPHILA UKUQALA ukuze ubhale inqubo egcinwe.
  • Dala inqubo egcinwe eyamukela imingcele yokufaka.
  • Chaza ukuthi i-T-SQL ingakhiwa kanjani.
  • Bhala imibuzo esebenzisa i-SQL enamandla.

I-Module 16: Ukuhlela nge-T-SQL

Le module ichaza indlela yokuthuthukisa ikhodi yakho ye-T-SQL ngezici zokuhlela.Izici

  • T-SQL Izinhlelo Zokuhlela
  • Ukulawula ukugeleza kohlelo

I-Lab: Ukuhlela nge-T-SQL

  • Ukumemezela ukuguquguquka nokunciphisa ama-Batches
  • Ukusebenzisa i-Control-Of-Flow Elements
  • Ukusebenzisa iziguquko esitatimendeni se-Dynamic SQL
  • Ukusebenzisa izilinganiso

Ngemuva kokuqedela le module, abafundi bazokwazi:

  • Chaza ukuthi i-Microsoft SQL Server isebenzisa kanjani ukuqoqwa kwezitatimende njengama-batches.
  • Dala futhi uthumele amakhodi we-T-SQL ikhodi yokubulawa yi-SQL Server.
  • Chaza indlela uSQL Server egcina ngayo izinto zesikhashana njengezinguquko.
  • Bhala ikhodi echaza futhi inikeze iziguquko.
  • Yakha futhi ubuke izifanekiselo
  • Chaza izici zokulawula-zokugeleza kwe-T-SQL.
  • Bhala ikhodi ye-T-SQL usebenzisa i-IF ... i-ELSE blocks.
  • Bhala ikhodi ye-T-SQL esebenzisa i-WHILE.

I-Module 17: Ukuphatha Ukuphutha Ukuqalisa

Le module iveza ukungalungi kokuphathwa kwe-T-SQL.Izici

  • Ukusebenzisa ukuphathwa kwephutha le-T-SQL
  • Ukusebenzisa ukuphathwa okuhlukile okuhleliwe

Ilabhu: Ukusetjenziswa kokuPhatha kwephutha

  • Amaphutha okuqondisa kabusha nge-TRY / CATCH
  • Usebenzisa i-THROW ukudlulisela umlayezo wephutha emuva kuklayenti

Ngemuva kokuqedela le module, abafundi bazokwazi:

  • Qalisa ukuphathwa kwephutha le-T-SQL.
  • Qalisa ukuphathwa okuhlukile okuhleliwe.

I-Module 18: Ukuqalisa Ukusebenza

Le modula ichaza indlela yokuqalisa ukuthengiselana.Izidingo

  • Ukuthengiselana kanye nezinjini zemininingwane
  • Ukulawula ukuthengiselana

I-Lab: Ukuqalisa ukusebenza

  • Ukulawula ukuthengiselana ne-BEGIN, i-COMMIT, ne-ROLLBACK
  • Yengeza iphutha lokuphatha ku-block CATCH

Ngemuva kokuqedela le module, abafundi bazokwazi:

  • Chaza ukuthengiselana kanye nokwahlukana phakathi kwama-batches nokuthengiselana.
  • Chaza ama-batches nokuthi aphathwa kanjani yi-SQL Server.
  • Yakha futhi uphathe ukuthengiselana ngezitatimende zolimi lokulawula (TCL).
  • Sebenzisa i-SET XACT_ABORT ukuchaza amasevisi we-SQL ukuphatha kokuthengiselana ngaphandle kwamabhuloki we-TRY / CATCH.

Ukuqeqeshwa Okuzayo

Ayikho imicimbi ezayo ngalesi sikhathi.

Sicela ubhalele ku- info@itstechschool.com & uxhumane nathi ku-91-9870480053 ngezindleko zemali & isitifikedi, isimiso & indawo

Siphonsa Umbuzo

Ukuze uthole olunye ulwazi thintane nathi ngomusa.


Izibuyekezo