TypeKuphunzira Maphunziro
Time5 Masiku
Register

Lumikizanani nafe

Minda yodziwika ndi * zofunikira

 

Kutenga Data ndi Transact-SQL

Kuchokera Deta ndi Transact SQL Training Course & Certification

Kufotokozera

Omvetsera ndi Zoperekera

Zolembera Mwachidule

Ndandanda ndi Malipiro

chitsimikizo

Kuchokera Deta ndi Transact SQL Maphunziro Mwachidule

Maphunzirowa apangidwa kuti athandize ophunzira ku Transact-SQL. Zapangidwa m'njira yoti masiku atatu oyambirira athe kuphunzitsidwa monga maphunziro kwa ophunzira omwe akufuna kudziwa maphunziro ena SQL Server maphunziro. Masiku 4 & 5 amaphunzitsa maluso otsala omwe akufunikira kuti atenge mayeso 70-761.

Zolinga za Kutaya Data ndi Transact SQL Training

  • Fotokozani mphamvu ndi zigawo za SQL Server 2016.
  • Fotokozani T-SQL, seti, ndi ndondomeko yoyenera.
  • Lembani ndemanga imodzi yosankha SELECT.
  • Lembani ndemanga yowonjezera pa SELECT.
  • Lembani mawu osankhidwa ndi kusinthasintha ndi kusankha.
  • Fotokozani momwe SQL Server imagwiritsira ntchito mitundu ya data.
  • Lembani mawu a DML.
  • Lembani mafunso omwe amagwiritsa ntchito ntchito zomangidwa.
  • Lembani mafunso omwe ali ndi deta zambiri.
  • Lembani mawu omvera.
  • Pangani ndikugwiritsira ntchito ntchito zamtengo wapatali.
  • Gwiritsani ntchito ogwira ntchito kuti agwirizane ndi zotsatira za mafunso.
  • Lembani mafunso omwe amagwiritsira ntchito mawindo, mawonekedwe, ndi ntchito zonse.
  • Sinthani deta mwa kugwiritsa ntchito pivot, unpivot, rollup ndi cube.
  • Pangani ndikugwiritsa ntchito njira zosungidwa.
  • Onjezerani mapulogalamu omangidwa monga zosiyana, zikhalidwe, ndi malupu ku T-SQL code.

Omvera Ovomerezedwa pa Zolinga za Kufufuza Data ndi Transact - SQL

Cholinga chachikulu cha maphunziro ndi kupereka ophunzira kumvetsetsa bwino kwa Transact-SQL chinenero chomwe chimagwiritsidwa ntchito ndi malangizo onse a SQL Server; monga, Database Administration, Database Development ndi Business Intelligence. Choncho, cholinga chachikulu cha ophunzira pa maphunziro awa ndi: Database Administrators, Database Developers ndi BI akatswiri.

Nthawi Yoyendetsera Nthawi Yomweyi: Masiku a 5

1 Module: Kuyamba kwa Microsoft SQL Server 2016

Mutuwu umayambitsa SQL Server, ma SQL Server, kuphatikizapo mitambo yamtundu, ndi momwe mungagwirizanitse ndi SQL Server pogwiritsa ntchito SQL Server Management Studio.

  • The Basic Architecture ya SQL Server
  • SQL Server Editions ndi Versions
  • Kuyamba ndi SQL Server Management Studio

Lab: Kugwira ntchito ndi Zida za SQL Server 2016

  • Kugwira ntchito ndi SQL Server Management Studio
  • Kupanga ndi Kukonzekera Ma T-SQL Scripts
  • Kugwiritsa Ntchito Mabuku Online

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani mafotokozedwe achibale ndi Transact-SQL.
  • Fotokozani mapulogalamu ndi mapulogalamu a SQL Server omwe ali pamwamba pa mapepala.
  • Fotokozani momwe mungagwiritsire ntchito SQL Server Management Studio (SSMS) kuti mugwirizane ndi chochitika cha SQL Server, fufuzani malemba omwe alipo, ndipo gwiritsani ntchito maofesi omwe ali ndi T-SQL.

2 Module: Kuyamba kwa T-SQL Kuchokera

Mutu uwu ukufotokoza zinthu za T-SQL ndi udindo wawo polemba mafunso. Fotokozani kugwiritsa ntchito kwa SQL Server. Fotokozani kugwiritsiridwa ntchito kwa ndondomeko yowonongeka mu SQL Server. Fotokozani dongosolo lovomerezeka la machitidwe mu SELECT mawu. Tikuphunzirapo

  • Kuwunikira T-SQL
  • Kumvetsetsa Masikiti
  • Kumvetsetsa Mawu Ovomerezeka
  • Kumvetsa ndondomeko yoyendetsera ntchito mu ziganizo za SELECT

Lab: Kuyamba kwa T-SQL Kufufuza

  • Kuchita Zolemba Zenizeni ZOYENERA
  • Kuchita Mafunsowo omwe Sanagwiritse Maulo pogwiritsa ntchito Maulosi
  • Kuchita Mafunsowo Amene Mumakonda Dongosolo Pogwiritsa Ntchito ORDER BY

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani udindo wa T-SQL mwa kulemba ZOCHITA mawu.
  • Fotokozani zinthu za chilankhulo cha T-SQL ndi zinthu zomwe zingakhale zothandiza polemba mafunso.
  • Fotokozani mfundo za chiphunzitso chokhazikitsidwa, chimodzi mwa ziwerengero za masamu zamabuku, komanso kukuthandizani kuzigwiritsa ntchito momwe mukuganizira za kuyesa SQL Server
  • Fotokozani mfundo zowonongeka ndi kuyang'ana momwe akugwiritsira ntchito poyesa SQL Server.
  • Fotokozani zomwe zili mu ndondomeko ya SELECT, fotokozani momwe zinthu zikuyendera, ndiyeno mugwiritse ntchito kumvetsetsa kwa njira yeniyeni yolemba mafunso.

XMUMX ya moduli: Kulemba SELECT Mafunso

Mutu uwu umayambitsa zikhazikitso za ndondomeko ya SELECT, kuyang'ana pa mafunso pa tebulo limodzi.Zimenezi

  • Kulemba Zosavuta SELECT Statements
  • Kuchotsa Zophatikiza ndi DISTINCT
  • Kugwiritsira ntchito Phukusi ndi Zowonjezera Zakudya
  • Kulemba Mawu Osavuta CASE

Lab: Kulemba Basic SELECT Statements

  • Kulemba Zosavuta SELECT Statements
  • Kuchotsa Zophatikiza Pogwiritsa ntchito DISTINCT
  • Kugwiritsira ntchito Phukusi ndi Zowonjezera Zakudya
  • Kugwiritsa Ntchito Zowoneka Zowoneka CASE

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani kapangidwe ndi maonekedwe a SELECT statement, komanso zowonjezera zomwe zidzawonjezera ntchito ndi kuwerenga kwa mafunso anu
  • Fotokozani momwe mungachotsere zowerengera pogwiritsa ntchito ndime ya DISTINCT
  • Fotokozani kugwiritsiridwa ntchito kwa mgwirizano wamtundu ndi patebulo
  • Kumvetsetsani ndi kugwiritsa ntchito mawu akuti CASE

XMUMX ya moduli: Kufufuzira Matebulo Ambiri

Mutu uwu ukufotokoza momwe mungalembe mafunso omwe akuphatikizana ndi data kuchokera kuzinthu zambiri ku Microsoft SQL Server 2016. Tikuphunzirapo

  • Kumvetsa kumayanjana
  • Kufufuza ndi Kulowa Kwawo
  • Kufufuza ndi Outer Joins
  • Kuphunzira ndi Cross Joins ndi Self Joins

Lab: Kufufuzira Ma Matebulo Ambiri

  • Malembo Olemba omwe amagwiritsa ntchito Zowonjezera
  • Malembo Olemba omwe amagwiritsa ntchito Multiple-Table Inner Joins
  • Malembo Olemba omwe amagwiritsa Ntchito Ogwirizana
  • Malembo Olemba omwe amagwiritsira ntchito Zowonjezera
  • Kulemba Mafunso omwe amagwiritsa ntchito Cross Joins

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani zikhazikitso za maundanidwe mu SQL Server 2016
  • Lembani mafunso olowa mkati
  • Lembani mafunso omwe amagwiritsa ntchito kunja
  • Gwiritsani ntchito mitundu yowonjezera

XMUMX ya moduli: Kusankha ndi Kusuta Data

Mutu uwu umalongosola momwe mungagwiritsire ntchito kukonza ndi kusinthasintha

  • Dongosolo la Kusankha
  • Kuwonetsa Data ndi Maulosi
  • Kusuta Data ndi TOP ndi OFFSET-FETCH
  • Kugwira Ntchito ndi Malamulo Osadziwika

Lab: Kukonza ndi Kusanthula Deta

  • Malembo Olemba omwe Sakusintha Data pogwiritsa ntchito MALO OYAMBA
  • Kulemba Mafunso omwe Sungani Dongosolo Pogwiritsa Ntchito KULAMBIRA NDI Mndandanda
  • Malembo Olemba omwe Sakusintha Data pogwiritsa ntchito CHOCHOKERA

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozerani momwe mungapangire ndondomeko ya ORDER BY mafunso anu kuti muzitsatira dongosolo la mizere yomwe ikuwonetsedwa mu funso lanu.
  • Fotokozerani momwe mungamangire ziganizo za WHERE kuti muzisungunitse mizere yomwe siyifanane ndi ndondomekoyi.
  • Fotokozerani momwe mungachepetse mzere wa mizere mu ndime ya SELECT pogwiritsa ntchito CHOCHITIKA.
  • Fotokozani momwe mungachepetse mizere ya mizera pogwiritsa ntchito OFFSET-FETCH chotsatira cha GAWO lolembedwa.
  • Fotokozerani momwe ziwerengero zamaganizo zamtengo wapatali zodziwika ndi zosowa, momwe SQL Server imagwiritsira ntchito NULL kuwonetsera machitidwe osowa, ndi momwe mungayesere NULL mu mafunso anu.

XMUMX ya moduli: Kugwira ntchito ndi mitundu ya data ya SQL Server 6

Mutu uwu umatulutsira deta mitundu SQL Server imagwiritsira ntchito kusunga data.Zimenezi

  • Tikuyambitsa mitundu ya data ya SQL Server 2016
  • Kugwira ntchito ndi Character Data
  • Kugwira ntchito ndi Date ndi Data Time

Lab: Kugwira ntchito ndi mitundu ya data ya SQL Server 2016

  • Kulemba Mafunsowo kuti Tsiku la Kubwerera ndi Nthawi
  • Kulemba Mafunsowo omwe amagwiritsa ntchito Ntchito ndi Tsiku ndi Nthawi
  • Kulemba Mafunso Omwe Amabwerera Makhalidwe Anu
  • Kulemba Makhalidwe Amene Munthu Wobwerera Akugwira Ntchito

Pambuyo pomaliza gawoli, mudzatha:

  • Fufuzani mitundu yambiri ya deta SQL Server ikugwiritsira ntchito kusungiramo deta komanso momwe mitundu ya deta imatembenuzidwira pakati pa mitundu
  • Fotokozani mitundu ya deta ya SQL Server, momwe mafananidwe a anthu amagwirira ntchito, ndi ntchito zina zomwe mungapeze zothandiza mafunso anu
  • Fotokozani mitundu ya deta yomwe imagwiritsidwa ntchito kusunga deta yamtundu, momwe mungalowetse masiku ndi nthawi kuti iwonongeke bwino ndi SQL Server, ndi momwe mungagwiritsire ntchito nthawi ndi nthawi ndi ntchito zowonjezera.

XMUMX ya module: Kugwiritsa ntchito DML kuti Sinthani Deta

Mutu uwu umalongosola momwe mungapangire mafunso a DML, ndi chifukwa chake mungafunire

  • Kuika Deta
  • Kusintha ndi Kutulutsa Deta

Lab: Kugwiritsa ntchito DML kuti Sinthani Deta

  • Kuika Deta
  • Kusintha ndi Kuchotsa Deta

Pambuyo pomaliza gawoli, mudzatha:

  • Gwiritsani ntchito SUNGANI ndi SANKHA mawu
  • Gwiritsani ntchito POPEREKEZA, KUKHALA, KUSULUKA, ndi TRUNCATE.

8 ya moduli: Kugwiritsa Ntchito Ntchito Yowongedwa

Mutu uno umatchula ena mwa ambiri omwe amamanga ntchito mu SQL Server 2016.Zimenezi

  • Kulemba Mafunso ndi Ntchito Yowongedwa
  • Kugwiritsa Ntchito Ntchito Yotembenuza
  • Kugwiritsa Ntchito Ntchito Zokwanira
  • Kugwiritsa Ntchito Ntchito Zogwira Ntchito ndi NULL

Lab: Kugwiritsa Ntchito Ntchito Yowongedwa

  • Kulemba Mafunso Amene Amagwiritsa Ntchito Kutembenuza
  • Malembo Olemba omwe amagwiritsira ntchito Ntchito zomveka
  • Kulemba Mafunso Amene Amayesedwa Kuti Asayende

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani mtundu wa ntchito zomwe zinaperekedwa ndi SQL Server, ndiyeno muganizire kugwira ntchito ndi zokopa
  • Fotokozani momwe mungasinthire deta pakati pa mitundu pogwiritsa ntchito ntchito zingapo za SQL Server
  • Fotokozani momwe mungagwiritsire ntchito ntchito zomveka zomwe zimafufuzira mawu ndi kubwezera zotsatira zowonongeka.
  • Fotokozani ntchito zina zogwirira ntchito ndi NULL

XMUMX ya module: Kugululira ndi Kugawana Deta

Mutu uwu umalongosola momwe mungagwiritsire ntchito magulu osiyanasiyana

  • Kugwiritsa ntchito Ntchito Zachigawo
  • Pogwiritsa ntchito ndime ya GROUP
  • Kuwonetsa Magulu ali ndi HAVING

Lab: Kugawa ndi Kugawana Deta

  • Kulemba Mafunso Amene Amagwiritsa Ntchito GROUP NDI Mgwirizano
  • Kulemba Mafunso omwe amagwiritsira ntchito Ntchito Zonse
  • Kulemba Mafunso Amene Amagwira Ntchito Zapadera Zosiyana
  • Malembo Olemba omwe Amawonetsa Magulu ndi GAWO LOYAMBA

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani ntchito yowonjezeredwa mu SQL Server ndi kulemba mafunso akugwiritsa ntchito.
  • Lembani mafunso omwe akulekanitsa mizere pogwiritsa ntchito ndime ya GROUP BY.
  • Lembani mafunso omwe amagwiritsa ntchito GAVING clause kuti awononge magulu.

10 yamagulu: Kugwiritsa ntchito subqueries

Mutu uwu umalongosola mitundu yambiri ya subquery ndi momwe angayigwiritsire ntchito komanso nthawi yanji

  • Kulemba Zopindulitsa Zopindulitsa
  • Kulemba Zowonongeka Kwa Correlated
  • Pogwiritsa ntchito EXISTS Predicate ndi Subqueries

Lab: Kugwiritsira ntchito subqueries

  • Kulemba Mafunso Amene Amagwiritsa Ntchito Zomwe Mumaphunzirira Zomwe Mumakonda
  • Kulemba Mafunso Amene Amagwiritsa Ntchito Zowonjezera Zowonjezera ndi Zowonjezera
  • Kulemba Mafunso Amene Amagwiritsa Ntchito Zowonongeka Zogwirizanitsa ndi CHISANGIZO CHA EXISTS

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani komwe kusungunulira kungagwiritsidwe ntchito mu ndondomeko ya SELECT.
  • Lembani mafunso omwe amagwiritsa ntchito subqueries molumikizana mu ndemanga YA SELECT
  • Lembani mafunso omwe amagwiritsira ntchito zowonetsera EXISTS mu ndime WHERE kuyesa kukhalapo kwa mizere yoyenerera
  • Gwiritsani ntchito ndondomeko ya EXISTS kuti mufufuze bwinobwino kuti pali mizere m'ndondomeko.

11 ya moduli: Kugwiritsa ntchito ndemanga zazithunzi

Poyamba muyiyiyi, mudaphunzira za kugwiritsa ntchito subqueries ngati ndemanga yomwe inabweretsa zotsatira ku funso lakutanthawuza kunja. Monga maulendo apamwamba, mawu a pa tebulo ndi mafotokozedwe a mafunso, koma mawu a patebulo amatambasula lingaliro ili mwa kukulolani kuwatcha iwo ndi kugwira ntchito ndi zotsatira zawo momwe mungagwiritsire ntchito ndi deta mu tebulo lililonse lovomerezeka. Microsoft SQL Server 2016 imathandizira mitundu inayi ya mafotokozedwe a tebulo: matebulo ochotsedwera, mawonedwe ofanana omwe amapezeka (CTEs), mawonedwe, ndi ntchito zamtengo wapatali (TVFs). Mu gawo ili, mudzaphunzira kugwira ntchito ndi mitundu iyi ya ma tebulo ndikuphunzirani momwe mungagwiritsire ntchito kuthandizira njira yolemba mafunso.

  • Kugwiritsa Ntchito Views
  • Pogwiritsa ntchito mapepala apakati-Ntchito yofunika
  • Pogwiritsa ntchito matebulo olembedwa
  • Kugwiritsa Ntchito Mawu Omwe Amagwiritsa Ntchito

Lab

  • Malembo Olemba Amene Amagwiritsa Ntchito
  • Kulemba Mafunso Amene Amagwiritsa Ntchito Matebulo Othandizidwa
  • Malembo Olemba Amene Amagwiritsa Ntchito Zolemba Zowonjezera (CTEs)
  • Malembo Olemba Amene Amawonetsera Mapu Okhala Pamodzi-Mawu Ofunika

Pambuyo pomaliza gawoli, mudzatha:

  • Lembani mafunso omwe amabwezera zotsatira kuchokera kuwona.
  • Gwiritsani ntchito CREATE FUNCTION mawu kuti mupange TVF zosavuta.
  • Lembani mafunso omwe amalenga ndi kupeza zotsatira kuchokera ku matebulo ochotsedwera.
  • Lembani mafunso omwe amapanga CTEs ndi kubwezera zotsatira kuchokera kuwonetsera kwa tebulo.

12 ya moduli: Kugwiritsa Ntchito Opanga Machitidwe

Mutu uwu umayambitsa momwe mungagwiritsire ntchito opanga opangira UNION, INTERSECT, ndi EXCEPT kuti muyereze mizera pakati pa mawiri olowera.

  • Kulemba Mafunso ndi woyang'anira UNION
  • Pogwiritsa ntchito EXCEPT ndi INTERSECT
  • Mukugwiritsa ntchito APPLY

Lab: Kugwiritsira Ntchito Opanga Opangira

  • Kulemba Mafunso Amene Amagwiritsa Ntchito UNION Ogwiritsa Ntchito ndi UNION ALL
  • Kulemba Mafunso Amene Amagwiritsa Ntchito CROSS APPLY ndi OUTER APPLY Operekera
  • Malembo Olemba Amene Amagwiritsa Ntchito PAKATI ndi Operekera INTERSECT

Pambuyo pomaliza gawoli, ophunzira athe:

  • Lembani mafunso omwe amagwiritsa ntchito UNION kuti agwirizane ndi zopangira zolemba.
  • Lembani mafunso omwe amagwiritsa ntchito UNION ALL kuti agwirizane ndi zopangira zoyenera
  • Lembani mafunso omwe amagwiritsa ntchito EXCEPT operekera kuti abwerere mzere wokha payekha koma osati wina.
  • Lembani mafunso omwe amagwiritsira ntchito wogwiritsa ntchito INTERSECT kuti abwerere mizere yokha yomwe ilipo mu zonsezi
  • Lembani mafunso pogwiritsa ntchito CROSS APPLY operekera.
  • Lembani mafunso pogwiritsa ntchito OUTER APPLY operekera

XMUMX Module: Kugwiritsa ntchito Windows Ranking, Offset, ndi Ntchito Yogwirizana

Mutu uwu ukufotokoza ubwino wogwiritsa ntchito zenera zogwirira ntchito. Onetsetsani mawindo kuti agwire mizere yomwe imatanthauzidwa mu GAWO LOYAMBA, kuphatikizapo magawo ndi mafelemu. Lembani mafunso omwe amagwiritsira ntchito mawindo kuti agwire ntchito pawindo la mizera ndi kubwereza chiwerengero, kuphatikiza, ndi zotsatira zofananitsa zofanana.

  • Kupanga Mawindo ndi OVER
  • Kufufuza Ntchito za Window

Lab: Kugwiritsa ntchito Windows Ranking, Offset, ndi Aggregate Ntchito

  • Kulemba Mafunsowo omwe amagwiritsa ntchito Mndandanda wa Ntchito
  • Malembo Olemba omwe amagwiritsa ntchito Offset Functions
  • Kulemba Mafunso omwe amagwiritsa ntchito Window Mgwirizano Wonse

Pambuyo pomaliza gawoli, ophunzira athe:

  • Fotokozani zigawo za T-SQL zomwe zimagwiritsidwa ntchito pofotokozera mawindo, ndi maubwenzi pakati pawo.
  • Lembani mafunso omwe amagwiritsa ntchito ndime ya OVER, powagawana, kulamula, ndi kukhazikitsa kumasulira mawindo
  • Lembani mafunso omwe amagwiritsa ntchito mawindo a zenera.
  • Lembani mafunso omwe amagwiritsa ntchito mawindo a mawindo.
  • Lembani mafunso omwe amagwiritsa ntchito zenera kuti zisokoneze ntchito

14 ya moduli: Mitundu Yotsutsa ndi Kugawa

Mutu uwu umalongosola mafunso olembedwa omwe amawoneka ndi zotsatira zosagwirizana. Lembani mafunso omwe amatsimikizira magulu angapo ndi magulu a magulu Phunziro

  • Kulemba Mafunso ndi PIVOT ndi UNPIVOT
  • Kugwira Ntchito ndi Magulu Ogwirizanitsa

Lab: Zoyika Zokambirana ndi Zagawo

  • Kulemba Mafunso omwe amagwiritsa ntchito PIVOT Operekera
  • Mafunso Olemba omwe amagwiritsa ntchito UNPIVOT Operekera
  • Malembo Olemba omwe amagwiritsa ntchito GROUPING SETS CUBE ndi ROLLUP Subclauses

Pambuyo pomaliza gawoli, ophunzira athe:

  • Fotokozani momwe deta yosinthira ingagwiritsidwe ntchito pa mafunso a T-SQL.
  • Lembani mafunso omwe amachokera dera kuchokera ku mizere kupita kuzitsulo pogwiritsa ntchito opanga PIVOT.
  • Lembani mafunso omwe amatsitsa deta kuchokera pazitsulo kumbuyo pogwiritsa ntchito wogwiritsa ntchito UNPIVOT.
  • Lembani mafunso pogwiritsa ntchito zilembo za GROUPING SETS.
  • Lembani mafunso omwe amagwiritsa ntchito ROLLUP NDI CUBE.
  • Lembani mafunso omwe amagwiritsa ntchito GROUPING_ID ntchito.

XMUMX ya moduli: Kuchita Njira Zosungidwa

Mutu uwu ukulongosola momwe mungabwezerere zotsatira pochita ndondomeko yosungidwa. Pitani magawo ku njira. Pangani ndondomeko zosungiramo zosavuta zomwe zimakhazikitsa ndondomeko ya SELECT. Pangani ndi kupanga SQL yamphamvu ndi EXEC ndi sp_executesql.Lessons

  • Kuchokera Deta ndi Ndondomeko Zosungidwa
  • Kupititsa Zomwe Zimasungidwa
  • Kupanga Njira Zosavuta Zosungidwa
  • Kugwira ntchito ndi Dynamic SQL

Lab: Kuchita Njira Zosungidwa

  • Kugwiritsa ntchito mawu a EXECUTE ku Invoke Stored Procedures
  • Kupititsa Zomwe Zimasungidwa
  • Kuchita Ndondomeko Zosungidwa Zowonongeka

Pambuyo pomaliza gawoli, ophunzira athe:

  • Fotokozani njira zosungidwa ndi ntchito zawo.
  • Lembani mawu a T-SQL omwe amachititsa njira zosungira kubwezera deta.
  • Lembani mawu a EXECUTE omwe amapereka magawo olowera kuti asungidwe.
  • Lembani magulu a T-SQL omwe amakonzekera magawo otuluka ndikupanga njira zosungidwa.
  • Gwiritsani ntchito CREATE PROCEDURE mawu kuti mulembe njira yosungidwa.
  • Pangani ndondomeko yosungidwa yomwe imalandira magawo olowera.
  • Fotokozani momwe T-SQL ingakhalire mwamphamvu.
  • Lembani mafunso omwe amagwiritsa ntchito SQL yamphamvu.

XMUMX ya moduli: Kukonzekera ndi T-SQL

Mutu uwu umalongosola momwe mungapititsire kachidindo yanu T-SQL ndi zinthu zokonza mapulogalamu

  • T-SQL Programming Elements
  • Kuyendetsa Mapulogalamu Akumayenda

Lab: Kukonzekera ndi T-SQL

  • Kufotokozera Zosintha ndi Magulu Operewera
  • Kugwiritsira ntchito Control-Of-Flow Elements
  • Kugwiritsa ntchito Zosintha mu Chidindo Chachidule cha SQL
  • Kugwiritsa Ntchito Zizindikiro

Pambuyo pomaliza gawoli, ophunzira athe:

  • Fotokozani momwe Microsoft SQL Server imachitira zolemba za batches.
  • Pangani ndi kupereka ma batchi a T-SQL code kuti aphedwe ndi SQL Server.
  • Fotokozani momwe SQL Server imasungira zinthu zakanthawi ngati zinthu.
  • Lembani kalata yomwe imalengeza ndikuyika zosiyanasiyana.
  • Pangani ndi kupempha mafananidwe
  • Fotokozani zinthu zowonongeka mu T-SQL.
  • Lembani kachidindo ka T-SQL pogwiritsa ntchito IF ...
  • Lembani code T-SQL yomwe imagwiritsa ntchito WHILE.

XMUMX ya Module: Kugwiritsa Ntchito Mankhwala Opotoka

Mutu uno umayambitsa kusokoneza kwa T-SQL.Zimenezi

  • Kugwiritsa ntchito T-SQL kulakwitsa kolakwika
  • Kugwiritsa ntchito njira yosankhidwa yokha

Lab: Kukhazikitsa Kuthana ndi Zolakwitsa

  • Zowonongeka zolakwika ndi TRY / CATCH
  • Pogwiritsa ntchito THROW kudutsa uthenga wolakwika kubwereza

Pambuyo pomaliza gawoli, ophunzira athe:

  • Tsatirani zolakwika za T-SQL.
  • Tsatirani njira yosamalidwa yosamalidwa.

XMUMX ya moduli: Kugwiritsa ntchito zochitika

Mutu uwu umalongosola momwe mungagwiritsire ntchito malonda

  • Kugulana ndi injini zachinsinsi
  • Kulamulira malonda

Lab: Kukhazikitsa Zochitika

  • Kulamulira malonda ndi BEGIN, COMMIT, ndi ROLLACK
  • Kuwonjezera kulakwitsa kumalo osungira CATCH

Pambuyo pomaliza gawoli, ophunzira athe:

  • Fotokozerani zochitika ndi kusiyana pakati pa magulu ndi zochitika.
  • Fotokozani magulu ndi momwe amachitira ndi SQL Server.
  • Pangani ndi kuyendetsa zosamalana ndi malankhulidwe oyendetsera chinenero (TCL).
  • Gwiritsani ntchito SET XACT_ABORT kuti mudziwe SVL Servers yoyendetsa malonda kunja kwa TRY / CATCH mabwalo.

Zochitika Mtsogolomu

Palibe zochitika zomwe zikubwera panthawiyi.

Chonde tilembereni pa info@itstechschool.com & tilankhulani nafe ku 91-9870480053 pa mtengo wamtengo wapatali & ndondomeko mtengo, ndondomeko & malo

Tisiyeni Funso

Kuti mudziwe zambiri, tiuzeni mwachifundo.


Reviews