Ukukhangela idatha kunye ne-Transact-SQL

UkuCima iDatha ngeTransact SQL Training Course & Certification

inkcazelo

Abaphulaphuli kunye neemfuno ezifunekayo

Inkcazo yeNkcazo

IShedyuli kunye neMali

iziQinisekiso

Ukukhangela idatha kunye ne-Transact SQL yoQuquzelelo loQeqesho

Le khosi yenzelwe ukuzisa abafundi kwi-Transact-SQL. Yenzelwe ngendlela yokuba iintsuku zokuqala ezintathu zifundiswe njengekhosi kubafundi abafuna ulwazi kwezinye iikholeji SQL Server ikharityhulam. Iintsuku ze-4 ne-5 zifundisa izakhono ezisele ezifunekayo ukuba zithathe 70-761.

Iinjongo zokuCima idatha kunye neCompact SQL Training

  • Chaza ubuchule obuphambili kunye namacandelo eSQL Server 2016.
  • Chaza i-T-SQL, iiseti, kunye neengqiqo zengqiqo.
  • Bhala itafile enye.
  • Bhala i-table multiple-SECTION statement.
  • Bhala i-SELECT inkcazo ngokucoca nokukhetha.
  • Chaza indlela i-SQL Server isebenzisa ngayo iintlobo zeenkcukacha.
  • Bhala izitatimende zeDML.
  • Bhala imibuzo esebenzisa imisebenzi eyakhelwe ngaphakathi.
  • Bhala imibuzo edibanisa idatha.
  • Bhala phantsi.
  • Yakha uphinde usebenze imibono kunye nemisebenzi exabisekileyo yetafile.
  • Sebenzisa abasebenzisi abasetyenzisiweyo ukudibanisa iziphumo zombuzo.
  • Bhala imibuzo esebenzisa i-windows ranking, offset, kunye nemisebenzi ebanzi.
  • Ukuguqula idatha ngokuphumeza i-pivot, unpivot, rollup kunye nekhamera.
  • Yakha uphinde usebenzise iinkqubo ezigcinwe.
  • Yongeza iinkqubo ezakhayo ezifana neziguquko, imiqathango, kwaye udibanise kwi-T-SQL ikhowudi.

Abaphulaphuli abafunyenweyo ngeenjongo zokufuna iData kunye ne-Transact-SQL

Injongo ephambili yekhosi kukunika abafundi ukuqonda kakuhle ulwimi lwaseTransact-SQL elisetyenziswe kuzo zonke izikhokelo ezihlobene ne-SQL Server; oko kukuthi, uLawulo loLwazi, uLawulo loLwazi kunye noBuchule boBuchule. Ngaloo ndlela, abaphulaphuli abaziintloko ekujoliswe kule khosi ngu: Abalawuli beDatabase, abaSebenzisi beDatabase kunye nabafundi beBI.

Ixesha loKhutshwa kweNkundla: Iintsuku ze-5

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

Le modyuli izisa iSQL Server, iinguqulelo ze-SQL Server, kuquka iinguqu zefu, nendlela yokuxhuma kwi-SQL Server usebenzisa iSQL Server Management Studio.

  • I-Basic Architecture yeSquL Server
  • I-SQL Server Editions kunye neeVulelo
  • Ukuqalisa nge-SQL Server Management Studio

ULebhu: Ukusebenza kunye nezixhobo ze-SQL Server 2016

  • Ukusebenza ne-SQL Server Management Studio
  • Ukudala nokuhlela ii-Scripts ze-T-SQL
  • Ukusebenzisa iincwadi kwi-intanethi

Emva kokugqiba le modyuli, uya kuba:

  • Chaza iinkcukacha zolwazi kunye ne-Transact-SQL imibuzo.
  • Chaza i-script-based and versions-based based versions of SQL Server.
  • Chaza indlela yokusebenzisa i-SQL Server Management Studio (SSMS) ukuxhuma kumzekelo we-SQL Server, ukuhlolisisa iinkcukacha eziqulethwe kwimeko, kwaye usebenze kunye neefayile ezibhalwe kwi-T-SQL imibuzo.

I-Module 2: Isingeniso kwi-T-SQL Ukukhangela

Le modyuli ichaza izinto ze-T-SQL kunye nendima yazo kwimibhalo ebhaliweyo. Chaza ukusetyenziswa kweesethi kwiSQL Server. Chaza ukusetyenziswa kweengcamango zengqikelela kwiSQL Server. Chaza umyalelo ochanekileyo wemisebenzi kwiZINCWADI zenkcazelo. Izifundo

  • Ukuzisa iT-SQL
  • Izixhobo zokuqonda
  • Ukuqonda i-Predicate Logic
  • Ukuqonda I-Order order of Operations kwi-SELECT inkcazo

ULabha: Isingeniso kwi-T-SQL Ukufuna

  • Ukusebenzisa iiNkcazo zokuSebenza eziSiseko
  • Imibuzo esebenzayo yokuCoca idatha ngokusebenzisa iIqendu
  • Ukuqhuba Imibuzo Eluhlu Lwedatha Usebenzisa I-ORDER BY

Emva kokugqiba le modyuli, uya kuba:

  • Chaza indima ye-T-SQL ngokubhaliweyo SELECT inkcazo.
  • Chaza izinto zeelwimi ze-T-SQL kwaye zeziphi izixhobo eziya kubanceda ngokubhala imibuzo.
  • Chaza iingcamango ze-theory, enye yeemathematika ezingaphantsi kweengxelo zolwazi, kunye nokukunceda ukuba uyisebenzise ngendlela ocinga ngayo ngokucima iSQL Server
  • Chaza ingqiqo yeengqiqo kwaye uhlolisise isicelo sayo ukucima iSQL Server.
  • Cacisa izinto ze-SELECT SELECT, ukucacisa umyalelo apho izixhobo zivandlakanywa khona, kwaye usebenzise le ngqiqo kwindlela efanelekileyo yokubhala imibuzo.

I-Module 3: Ukubhala UKUQALA Imibuzo

Le modyuli ibonisa iziseko ezisisigxina se-SELECT, ejolise kwiingxaki malunga netafile enye

  • Ukubhala okulula Iinkcazo ze-SELECT
  • Ukuqhoqhelanisa iziphumo kunye neDISTINCT
  • Ukusebenzisa iikholomu kunye neZibhakanyiso zeThebula
  • Ukubhala okulula CASE Expressions

ULabha: Ukubhala iSisiseko SEZINCWADI

  • Ukubhala okulula Iinkcazo ze-SELECT
  • Ukuqhoqhelisa ukuPhuqulwa kokusebenzisa i-DISTINCT
  • Ukusebenzisa iikholomu kunye neZibhakanyiso zeThebula
  • Ukusebenzisa i-CASE Expression Simple

Emva kokugqiba le modyuli, uya kuba:

  • Chaza isakhiwo kunye nefomathi yesitatimende sokukhetha, kunye nezongqinisiso eziza kuhlanganisa ukusebenza kunye nokufunda kwimibandela yakho
  • Chaza indlela yokuphelisa ukuphinda usebenzise iigatshana ze-DISTINCT
  • Chaza ukusetyenziswa kwamacandelo ekholomu kunye neetafile
  • Ukuqonda nokusebenzisa i-CASE expressions

I-4 yeModyuli: Ukufundwa kweeTables ezininzi

Le modyuli ichaza indlela yokubhala imibuzo edibanisa idatha evela kwimithombo emininzi kwi-Microsoft SQL Server 2016. Izifundo

  • Ukuqonda ukudibanisa
  • Ukucima nge-Joined Inner
  • UkuCima kunye namaQumrhu angaphandle
  • Ukucima nge-Cross Joins and Self Self

ULebhu: Ukufundwa kweeTables ezininzi

  • Ukubhala Imibuzo esebenzisanayo ngaphakathi
  • Ukubhala Imibuzo esebenzisa ii-Multiple-Table Inner Joins
  • Ukubhala Imibuzo esebenzisa ukuzibandakanya
  • Ukubhala Imibuzo esebenzisa ii-Outer zangaphandle
  • Ukubhala Imibuzo esebenzisana neziNxulumaniso eziMnqamlezo

Emva kokugqiba le modyuli, uya kuba:

  • Chaza izinto ezisemgangathweni zokujoyina i-SQL Server 2016
  • Bhala imibuzo yokujoyina ngaphakathi
  • Bhala imibuzo esebenzayo
  • Sebenzisa iintlobo zokujoyina ezongezelelweyo

I-Module 5: Ukuhlela nokuCoca idatha

Le modyuli ichaza indlela yokuqalisa ukuhlunga kunye nokucoca

  • Uludwe lweDatha
  • Idatha yokuCoca kunye neeNgxelo
  • Idatha yokuCoca kunye ne-TOP kunye ne-OFFSET-FETCH
  • Ukusebenzisana neMilinganiselo engaziwayo

ULabhanki: Ukuhlunga nokuCoca idatha

  • Ukubhala Imibuzo eLawula idatha ngokusebenzisa i-WHERE Clause
  • Ukubhala Imibuzo ehlela Uludwe lweDatha Usebenzisa ISIKHATHI NGOMGAWULO
  • Ukubhala Imibuzo Eyahluza Iinkcukacha ngokusebenzisa i-TOP Option

Emva kokugqiba le modyuli, uya kuba:

  • Cacisa indlela yokongeza ISIGABA NGOMGAQULO kwimibandela yakho ukulawula umyalelo wemigca eboniswe kwisiphumo sakho sombuzo
  • Cacisa indlela yokwakha iziqendu ze-WHERE ukucoca imiqolo engayifani niselo.
  • Chaza indlela yokunciphisa ububanzi bemigqa kwiGatya lokukhetha usebenzisa i-TOP option.
  • Cacisa indlela yokunciphisa ububanzi bemigqa usebenzisa i-OFFSET-FETCH inketho ye-ORDER BY clause.
  • Cacisa indlela iingxelo zeengcamango ezixabisekileyo ezintathu ezinokungazi kwaye zilahlekile, indlela iSQL Server isebenzisa ngayo i-NULL ukuphawula iimpawu ezingekhoyo kunye nendlela yokuvavanya iNULL kwimibandela yakho.

I-Module 6: Ukusebenza ngee-SQL Server 2016 Data Types

Le modyuli izisa iintlobo zeenkcukacha ze-SQL Server isebenzisa ukugcina idatha

  • Ukuzisa ii-SQL Server 2016 Data Data
  • Ukusebenza neNkcukacha zeNkcukacha
  • Ukusebenza noMhla neDatha yeDatha

Ibhab: Ukusebenza ngeendidi zeenkcukacha ze-SQL Server 2016

  • Ukubhalwa kwemibuzo yokuba uMhla wokuPhumela kunye neDatha yeDatha
  • Ukubhala Imibuzo esebenzisa iMini kunye nemiSebenzi yexesha
  • Ukubhala Imibuzo Ebuyisela Umntu Iinkcukacha
  • Ukubhala Imibuzo Ebuyisela Umntu Umsebenzi

Emva kokugqiba le modyuli, uya kuba:

  • Hlola ezininzi iinkcukacha zeenkcukacha ze-SQL Server ukugcina ukugcina idatha kunye nendlela iintlobo zeedatha eziguqulwa ngayo phakathi kweentlobo
  • Cacisa iintlobo zeenkcukacha zeenkcukacha ze-SQL Server, indlela othelekisa ngayo abalinganiswa, kunye neminye imisebenzi eqhelekileyo onokuyifumana inombuzo kwimibandela yakho.
  • Chaza iintlobo zeenkcukacha ezisetyenziselwa ukugcina idatha yesikhashana, indlela yokufaka imihla kunye namaxesha ukwenzela ukuba ichane ngokufanelekileyo yiSQL Server, nendlela yokusebenzisa imihla kunye namaxesha ngemisebenzi eyakhelwe kuyo.

I-Module 7: Ukusebenzisa i-DML ukuguqula idatha

Le modyuli ichaza indlela yokwenza imibuzo ye-DML, kwaye kutheni ufuna ukufuna

  • Ukufaka Iinkcukacha
  • Ukuguqula nokuSusa idatha

Ibhab: Ukusebenzisa i-DML ukuguqula idatha

  • Ukufaka Iinkcukacha
  • Ukuhlaziya nokuSusa idatha

Emva kokugqiba le modyuli, uya kuba:

  • Sebenzisa ISETYENZISWA NOKUKHETHA KWIINGXELO
  • Sebenzisa u-UPDATE, MERGE, DELETE, no-TRUNCATE.

I-Module 8: Ukusebenzisa Imisebenzi eYakhelweyo

Le modyuli ibonisa ezinye zezinto ezininzi ezakhiwe kwimisebenzi kwiSQL Server 2016

  • Ukubhala Imibuzo ngeMisebenzi eYakhelweyo
  • Ukusebenzisa Imisebenzi yokuguqula
  • Ukusebenzisa Imisebenzi Engqalileyo
  • Ukusebenzisa Imisebenzi Ukusebenza nge-NULL

Ibhanki: Ukusebenzisa Imisebenzi Yakhelwe ngaphakathi

  • Ukubhala Imibuzo Esebenzisa Imisebenzi Yokuguqula
  • Ukubhala Imibuzo eSebenzayo
  • Ukubhala Imibuzo eVavanywayo yokuNyuka

Emva kokugqiba le modyuli, uya kuba:

  • Chaza iintlobo zemisebenzi enikezwa yi-SQL Server, kwaye ke ugxininise ekusebenzeni ngemisebenzi ye-scalar
  • Cacisa indlela yokuguqula ngokucacileyo idatha phakathi kweentlobo usebenzisa imisebenzi emininzi yeSQL Server
  • Chaza indlela yokusebenzisa imisebenzi enengqiqo evavanya intetho kwaye ubuyele umphumo we-scalar.
  • Chaza imisebenzi eyongezelelweyo yokusebenza ne-NULL

I-9 yeModyuli: UkuQamba nokuQinisa iDatha

Le modyuli ichaza indlela yokusebenzisa imisebenzi ebanzi

  • Ukusebenzisa Imisebenzi yoLuntu
  • Ukusebenzisa i-GROUP BY Clause
  • Amacebo okucoca ane-HAVING

ULabhanki: Ukuqokelela kunye nokuHlanganisa iDatha

  • Ukubhala Imibuzo Esebenzisa IQAKUBA NGCANDELO
  • Ukubhala Imibuzo eSebenzayo Imisebenzi Yonke
  • Ukubhala Imibuzo eSebenzayo Imisebenzi yokuHlanganisa
  • Ukubhalwa kwemibuzo ehlaziya amaqela aneCANDELO ESIFUNDAYO

Emva kokugqiba le modyuli, uya kuba:

  • Chaza umsebenzi odibeneyo kwi-SQL Server kwaye ubhale imibuzo usebenzisa.
  • Bhala imibuzo eyahlula imigqa isebenzisa igatya le-GROUP BY.
  • Bhala imibuzo esebenzisa isigatshana SOKUHLOLA ukuhluza amaqela.

I-Module 10: Ukusebenzisa ii-Subqueries

Le modyuli ichaza iintlobo ezininzi zeengqungquthela kunye nendlela kwaye zisetyenziswe njani

  • Ukubhala ii-Subqueries ezinikezelweyo
  • Ukubhala iiNkcazo eziManyeneyo
  • Ukusebenzisa i-EXISTS Predicate kunye nee-Subqueries

Ibhabhi: Ukusebenzisa ii-Subqueries

  • Ukubhala Imibuzo Esebenzisa ii-Subqueries ezizimeleyo
  • Ukubhala Imibuzo Esebenzisa i-Scalar kunye neMiphumo emininzi yeMiphumo
  • UkuBhala Imibuzo Esebenzisa I-Subreleries kunye ne-EXISTS Igatya

Emva kokugqiba le modyuli, uya kuba:

  • Chaza ukuba zeziphi iindatshana ezingasetyenziswa kwisitatimende sokukhetha.
  • Bhala imibuzo esebenzisa imiyalezo engqameneyo kwiSETYENZO sokukhetha
  • Bhala imibuzo esebenzisa iziganeko zeziganeko kwiCANDELO LOMHLABA ukuvavanya ubukho bemigangatho efanelekileyo
  • Sebenzisa i-EXISTS predicate ukujonga ngokuchanekileyo ukuba kukho imigca kwi-subquery.

I-Module 11: Ukusebenzisa iifayile zeeThebula

Ngaphambili kule khosi, ufunde malunga nokusebenzisa i-subqueries njengombonakalo obuyisele iziphumo kumbuzo wesicelo ongaphandle. Njengama-subqueries, iintetho zeetheyibhile zibonakaliso zemibuzo, kodwa iifayile zetekisi zandisa le ngcamango ngokukuvumela ukuba uzibize kwaye usebenze neziphumo njengoko uza kusebenza kunye nedata kunoma yiphi na iithebhile ezihlobene. I-Microsoft SQL Server 2016 isekela iintlobo ezine zeentetho zeetafile: iitheyibhile ezifunyenweyo, ukuthetha kwetafile eziqhelekileyo (i-CTEs), imibono, kunye nemisebenzi ekhethiweyo yeetafile (i-TVFs). Kule modyuli, uya kufunda ukusebenzisana nale fom yeetekisi zeetafile kwaye ufunde indlela yokuwasebenzisa ukuze uncede ukudala indlela yokwenza imiyalezo yokubhala.

  • Ukusebenzisa Imibono
  • Ukusebenzisa Imisebenzi eSebenzi yeTable Table
  • Ukusebenzisa iiTable eziThatywayo
  • Ukusebenzisa Iifayile eziqhelekileyo

ULebhu: Ukusebenzisa iItratic Expressions

  • Ukubhala Imibuzo Esebenzisa Imiboniselo
  • Ukubhala Imibuzo Esebenzisa Iifayile Ezibukhali
  • Ukubhala Imibuzo Esebenzisa Iifayile Eziqhelekileyo Zeetafile (ii-CTEs)
  • Ukubhala Imibuzo Eyayibonakalisa Inkcazo-Iimpawu Ezixabisekileyo

Emva kokugqiba le modyuli, uya kuba:

  • Bhala imibuzo ebuyisela iziphumo kwiimbono.
  • Sebenzisa isitatimende SOKUSEBENZA IMISEBENZI ukudala iTVF elula.
  • Bhala imibuzo edala kunye nokufumana iziphumo ezivela kwiitheyibhile ezifunyenweyo.
  • Bhala imibuzo edala ii-CTE kunye nokubuyisela iziphumo ezivela kwintetho yetafile.

I-Module 12: Ukusebenzisa i-Set Operators

Le modyuli ichaza indlela yokusebenzisa abaqhubi be-UNION, INTERSECT, kunye ne-EXCEPT ukuthelekisa imigca phakathi kweefom zokufaka ezimbini.

  • Ukubhala Imibuzo kunye nomsebenzisi we-UNION
  • Ukusebenzisa i-EXCEPT ne-INTERSECT
  • Ukusebenzisa APPLY

ULebhu: Ukusebenzisa abaSebenzi bokuSebenza

  • Ukubhala Imibuzo Esebenzisa i-UNION Beka abaSebenzi kunye NONKE BONKE
  • Ukubhala Imibuzo Esebenzisa I-CROSS APPLY kunye NESICELO ESICELO SOMSEBENZI
  • Ukubhala Imibuzo Esebenzisa I-EXCEPT NE-INTERSECT Operators

Emva kokugqiba le modyuli, abafundi baya kuba nako uku:

  • Bhala imibuzo esebenzisa i-UNION ukudibanisa iisethi zokufaka.
  • Bhala imibuzo esebenzisa i-UNION YONKE ukudibanisa iisethi zokufaka
  • Bhala imibuzo esebenzisa umqhubi we-EXCEPT ukuba abuyisele imigqa kuphela kwisethi enye kodwa engekho enye.
  • Bhala imibuzo esebenzisa umqhubi we-INTERSECT ukuba abuyisele kuphela imigqa ekhoyo kwiisethi zombini
  • Bhala imibuzo usebenzisa i-CROSS APPLY opharetha.
  • Bhala imibuzo usebenzisa i-OUTER APPLY opharetha

I-Module 13: Ukusebenzisa i-Windows Usetyenziso, i-Offset, kunye neMisebenzi yokuHlanganisa

Le modyuli ichaza izibonelelo zokusebenzisa imisebenzi ye window. Ukuthintela imisebenzi yefestile kwimigca echazwe kwigatya elisesigxina, kuquka amaqhosha kunye namafowuni. Bhala imibuzo esebenzisa imisebenzi yefestile ukuze isebenze kwifestile yemigca kwaye ubuye ubuyeke, ukuhlalisa, kunye neempembelelo zokuqhathanisa.

  • Ukudala iWindows nge-OVER
  • Ukuhlola Imisebenzi ye Window

ULebhu: Ukusebenzisa i-Windows usetyenziso, i-Offset, kunye neMisebenzi yokuBambisana

  • Ukubhala Imibuzo esebenzayo Usetyenziso lwemisebenzi
  • Ukubhala Imibuzo esebenzisa iAffset Functions
  • Ukubhala Imibuzo esebenzisa iWindows Widget Functions

Emva kokugqiba le modyuli, abafundi baya kuba nako uku:

  • Chaza izinto ze-T-SQL ezisetyenziselwa ukuchaza iifestile, kunye nolwalamano phakathi kwabo.
  • Bhala imibuzo esebenzisa isigatshana ESIKHULU, ngokuhlukanisa, ukuyalela, kunye nokuqulunqa ukuchaza iifestile
  • Bhala imibuzo esebenzisa imisebenzi yeefestile.
  • Bhala imibuzo esebenzisa imisebenzi yokubeka i window.
  • Bhala imibuzo esebenzisa imisebenzi ye-offset window

I-14 yeModyuli: Iifayile zokuHlola kunye nokuQela

Le modyuli ichaza imibuzo ebhaliweyo ehambayo kunye neziphumo zeempembelelo. Bhala imibuzo echaza amaqela amaninzi ngamaqela eqela

  • Ukubhala imibuzo ngePIVOT kunye ne-UNPIVOT
  • Ukusebenza kunye neSetting Sets

ULabhanki: Iifayile zokuHlola kunye nokuBamba

  • Ukubhala Imibuzo esebenzisa iPIVOT Operator
  • Ukubhala Imibuzo esebenzisa i-UNPIVOT Operator
  • Ukubhala Imibuzo esebenzisa i-CUBE ye-GROUPING SET ne-ROLLUP

Emva kokugqiba le modyuli, abafundi baya kuba nako uku:

  • Chaza indlela idatha echanekileyo ingasetyenziswa ngayo imibuzo ye-T-SQL.
  • Bhala imibuzo ebonisa idatha esuka kumqolo ukuya kwiikholam esebenzisa umqhubi we-PIVOT.
  • Bhala imibuzo engabonakali idatha ukusuka kwiikholam ukuya kwimigqa usebenzisa umsebenzisi we-UNPIVOT.
  • Bhala imibuzo usebenzisa isigxina se-GROUPING SETS.
  • Bhala imibuzo esebenzisa i-ROLLUP NE-CUBE.
  • Bhala imibuzo esebenzisa umsebenzi we-GROUPING_ID.

I-Module 15: Ukusebenzisa iiNkqubo eziLondoloziweyo

Le modyuli ichaza indlela yokubuyisela iziphumo ngokuqhuba iinkqubo ezigcinwe. Dlulisa iiparameter kwiinkqubo. Yenza iinkqubo ezigcinwe ezilula ezifakela isitatimende sokukhetha. Ukwakha nokwenza i-SQL enamandla kunye ne-EXEC kunye ne-sp_executesql.Lonsons

  • Ukukhangela iDatha kwiNkqubo eziCwangcisiweyo
  • Ukudlula iParameters kwiinkqubo ezigcinwe
  • Ukudala iinkqubo ezilula ezigcinwe
  • Ukusebenza neDynamic SQL

Iebhanki: Ukusebenzisa iiNkqubo zokuGcina

  • Ukusebenzisa isitatimende se-EXECUTE sokuVumbela iinkqubo ezigcinwe
  • Ukudlula iParameters kwiinkqubo ezigcinwe
  • Iinkqubo zokuSebenza eziGcinwe

Emva kokugqiba le modyuli, abafundi baya kuba nako uku:

  • Chaza iinkqubo ezigcinwe kunye nokusetyenziswa kwazo.
  • Bhala izitatimende ze-T-SQL ezenza iinkqubo ezigcinwe ukubuyisela idatha.
  • Bhala izitatimende ze-EXECUTE ezithatha iiparitha zengeniso kwiinkqubo ezigcinwe.
  • Bhala amanqwanqwa e-T-SQL alungiselela iiparitha zemveliso kwaye ayenze iinkqubo ezigcinwe.
  • Sebenzisa ISICWANGCISO seNKQUBO ukubhalela inkqubo egcinwe.
  • Yenza inkqubo egcinweyo yamkela iiparitha zokufaka.
  • Chaza indlela i-T-SQL inokwakhiwa ngayo.
  • Bhala imibuzo esebenzisa i-SQL enamandla.

I-Module 16: Inkqubo ngeT-SQL

Le modyuli ichaza indlela yokuphucula ikhowudi yakho ye-T-SQL kunye nezixhobo zoqulunqo

  • I-T-SQL Inkqubo yeeNkqubo
  • UkuLawula iNkqubo yoLwazi

ULebhu: Inkqubo ngeT-SQL

  • Ukumemezela iiNguquko kunye noLuhlu lweeMali
  • Ukusebenzisa i-Control-Flow-Flow Elements
  • Ukusebenzisa iinguqu kwiSitatimende seDynamic SQL
  • Ukusebenzisa iiNgqamaniso

Emva kokugqiba le modyuli, abafundi baya kuba nako uku:

  • Chaza indlela iMicrosoft SQL Server ithatha ngayo ukuqokelela iingxelo njengama-batches.
  • Yakha uphinde uthumele iifowuni zekhowudi ye-T-SQL yokusetyenziswa ngu-SQL Server.
  • Chaza indlela i-SQL Server egcina ngayo izinto zesikhashana njengezinto eziguqukayo.
  • Bhala ikhowudi echazayo kwaye ikwabelise iziguquko.
  • Yakha uphinde ubhale amagama
  • Chaza izinto zokulawula ukuhamba kwe-T-SQL.
  • Bhala ikhowudi ye-T-SQL usebenzisa i-IF ... i-ELSE blocks.
  • Bhala ikhowudi ye-T-SQL esebenzisa iWHILE.

I-Module 17: Ukuphunyezwa kweSiphumo sokuPhatha

Le modyuli ibonisa ukuphatha impazamo ye-T-SQL

  • Ukuphunyezwa kwephutha le-T-SQL
  • Ukuphunyezwa kokuphathwa okungafaniyo

ULebhu: Ukuphunyezwa kokuPhathwa kwePazamo

  • Ukuphosakela iziphene nge TRY / CATCH
  • Ukusebenzisa i-THROW ukudlulisela umyalezo wephutha kumthengi

Emva kokugqiba le modyuli, abafundi baya kuba nako uku:

  • Ukuphunyezwa kwephutha le-T-SQL.
  • Phunyezwa ukuphathwa okungafaniyo.

I-Module 18: Ukuphunyezwa kokuTshintshana

Le modyuli ichaza indlela yokuqalisa ukuthengiselana

  • Ukuthengiselana kunye neenjini zedatha
  • Ukulawula ukuthengiselana

ULebhu: Ukuphunyezwa kweeNtengiso

  • Ukulawula iintengiso kunye ne-BEGIN, IKOMIT, kunye ne-ROLLACK
  • Ukongeza impazamo yokuphatha kwi-block CATCH

Emva kokugqiba le modyuli, abafundi baya kuba nako uku:

  • Chaza intsebenziswano kunye neentlukwano phakathi kwamabhakethi kunye nokuthengiselana.
  • Chaza iibhenki kunye nendlela eziphathwa ngayo yi-SQL Server.
  • Yakha uphinde ulawule ukuthengiselana ngeengxelo zokulawula ulwimi (TCL).
  • Sebenzisa iSET XACT_ABORT ukuchaza i-SQL Servers handling of transactions ngaphandle kwe-TRY / CATCH ibhloko.

Uqeqesho oluzayo

Akukho ziganeko ezizayo ngeli xesha.

Nceda ubhalele apha info@itstechschool.com & xhumana nathi kwi-91-9870480053 kwixabiso lekhosi kunye neendleko zokuqinisekisa, ishedyuli kunye nendawo

Usilahle Umbuzo

Ngolwazi olungakumbi xha ga mshelana nathi.


Reviews