TypeKuphunzira Maphunziro
Time5 Masiku
Register

Lumikizanani nafe

Minda yodziwika ndi * zofunikira

 

Kulamulira SQL Database Infrastructure

Kulamulira SQL Database Zipangizo Zophunzitsira Kosi & Zovomerezeka

Kufotokozera

Omvetsera ndi Zoperekera

Zolembera Mwachidule

Ndandanda ndi Malipiro

chitsimikizo

Kulamulira SQL Database Njira Zophunzitsira Maphunziro

Maphunziro aphunzitsi a masiku asanu awa amapereka ophunzira omwe akutsogolera ndi kusunga SQL Server zolinga ndi chidziwitso ndi luso lothandizira Zida zachinsinsi za seva ya SQL. Kuonjezerapo, izo zidzakhala zothandiza kwa anthu omwe amapanga mapulogalamu omwe amapereka zinthu kuchokera ku SQL Server.

Zolinga Zowonetsera SQL Zophunzitsira Zopangira Maziko

  • Onetsani ndi kulamulira ogwiritsa ntchito
  • Perekani ntchito za seva ndi deta
  • Lolani ogwiritsa ntchito kuti apeze zosowa
  • Tetezani deta ndi encryption ndi auditing
  • Fotokozani zitsanzo zakutulutsira ndi njira zosungira
  • Kusunga SQL Server ndondomeko
  • Bweretsani zidule za SQL Server
  • Gwiritsani ntchito kasamalidwe ka deta
  • Konzani chitetezo kwa wothandizira wa SQL Server
  • Sungani machenjezo ndi maulendo
  • Kusamalira SQL Server pogwiritsa ntchito PowerShell
  • Tsatirani mwayi wopita ku SQL Server
  • Onetsetsani zitsulo za SQL Server
  • Sungani zitsulo za SQL Server
  • Dulani ndi kutumiza deta

Omvera Ovomerezeka Otsogolera SQL Database Infrastructure course

Oyikira makamaka maphunzirowa ndi anthu omwe amachititsa ndikusunga SQL Server zolongosoka. Anthu awa amachita masitidwe ndi mausungidwe a deta monga malo awo oyambirira a udindo, kapena kugwira ntchito kumalo kumene kuli Zolemba athandizidwe pa ntchito yawo yoyamba. Ophunzira awiri a maphunzirowa ndi anthu omwe amapanga mapulogalamu omwe amapereka zinthu kuchokera ku SQL Server.

Nthawi Yoyendetsera Nthawi Yomweyi: Masiku a 5

1 ya module: SQL Server Security

Chitetezo cha deta mkati mwazitsulo za Microsoft SQL Server ndizofunikira ndipo zimafuna kudziwa ntchito zokhudzana ndi nkhaniyi ndi zida za chitetezo cha SQL Server. Mutu uwu umapereka mafayilo otetezedwa a SQL Server, logins, ogwiritsa ntchito, mbali zina zomwe zili ndi zidziwitso, ndi chilolezo cha mtanda. Tikuphunzirapo

  • Mauthenga Ovomerezeka ku SQL Server
  • Kuvomereza Logins kuti Zigwirizanitse ku mazenera
  • Kuvomerezeka Kwa Zipangizo Zonse
  • Pakati pa Zigawo Zathu

Lab: Ovomerezeka Ogwiritsa Ntchito

  • Pangani zolumikiza
  • Pangani Ogwiritsa Ntchito Zina
  • Zolondola Zotsatira Zolowera Mauthenga
  • Konzani Tsatanetsatane wa Zomwe Zidasinthidwe

Pambuyo pomaliza gawoli, mudzatha:

  • Mfundo za Basic SQL Server.
  • Kuvomerezedwa kwa kugwirizana kwa SQL Server.
  • Chilolezo cholowetsamo mauthenga kwa mazenera.
  • Zina mwadongosolo zili ndizithunzi.
  • Kuvomerezeka kudutsa ma seva.

XMUMX ya Module: Kuika Ntchito ndi Masewera Othandizira

Kugwiritsira ntchito maudindo kumachepetsa kayendetsedwe ka zilolezo za ogwiritsira ntchito. Pokhala ndi maudindo, mutha kuyang'anira ogwiritsidwa ntchito ovomerezeka kuti athe kugwiritsa ntchito zipangizo zamagetsi pogwiritsa ntchito ntchito ya wosuta-m'malo mogawira zilolezo ogwiritsa ntchito ndi wogwiritsa ntchito, mungapereke zilolezo ku gawo, ndikupangitsa ogwiritsa ntchito maudindo. Microsoft SQL Server imaphatikizapo kuthandizira pa maudindo otetezedwa omwe amafotokozedwa pa seva ndi pa deta. Tikuphunzirapo

  • Kugwira ntchito ndi maudindo a seva
  • Kugwira ntchito ndi Fixed Database Maudindo
  • Kuika Ntchito Zowonongeka Zogwiritsa Ntchito

Lab: Kuika ntchito seva ndi maudindo

  • Kuika Ntchito Zothandiza
  • Kuika Ntchito Yopangidwira Ntchito
  • Kuika Ntchito Zowonongeka Zogwiritsa Ntchito
  • Kutsimikizira Chitetezo

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani ndikugwiritsa ntchito ntchito za seva kuti muyang'anire chitetezo cha seva.
  • Fotokozani ndikugwiritsanso ntchito maudindo osinthika.
  • Gwiritsani ntchito maudindo omwe mumakhala nawo pazinthu zomwe mukugwiritsa ntchito kuti mukhale osamala.

XMUMX ya Module: Kuvomereza Ogwiritsa Ntchito Kupeza Zida

Mu ma modules apitawo, mwawona mmene Microsoft SQL Server chitetezera ndiyendetsedwe ndi momwe zikhazikitso za zilolezo zingaperekedwe pa seva ndi deta lamasamba pogwiritsa ntchito maudindo a seva, maudindo osankhidwa ndi ogwiritsira ntchito, maudindo omwe akugwiritsidwa ntchito, ndi maudindo a ntchito. Gawo lomaliza la kuwonetsa ogwiritsa ntchito kuti lifike ku SQL Server zothandizira ndizovomerezeka kwa ogwiritsa ntchito ndi maudindo kuti akwaniritse zinthu za seva ndi zinthu zachinsinsi. Mu gawo ili, muwona momwe zilolezozo zimayendetsedwa. Kuphatikiza pa zilolezo zowonjezera pazinthu zamatabwa, SQL Server imapereka mphamvu yodziwitsa omwe akuloledwa kupanga code, monga njira zosungidwa ndi ntchito. Nthaŵi zambiri, zilolezozi ndi zilolezo pazinthu zamatabwa zimakonzedwa bwino pa level schema osati pa mlingo wa chinthuchokha. Zothandizira zovomerezeka za Schema zikhoza kuchepetsa mapangidwe anu otetezeka. Mudzafufuza kupatsidwa kwa zilolezo pa chigawo cha schema mu phunziro lomaliza la gawoli

  • Kuvomereza Wogwiritsa Ntchito Kupeza Zinthu
  • Kuloleza Ogwiritsa Ntchito Kuchita Code
  • Kukonzekera Zilolezo pa Level Schema

Lab: Kutsegula ogwiritsa ntchito kupeza zowonjezera

  • Kupereka, Kukaniza, ndi Zilolezo Zowonongeka pa Zinthu
  • Kupereka Mavoti a EXECUTE pa Code
  • Kupatsa Zilolezo pa Ndalama ya Schema

Pambuyo pomaliza gawoli, mudzatha:

  • Lolani kugwiritsira ntchito kwa zinthu.
  • Lolani ogwiritsa ntchito kupanga code.
  • Sungani zilolezo pa mlingo wa schema.

4 ya module: Kutetezera Deta ndi Kujambula ndi Kufufuza

Pamene mukukonzekera chitetezo kwa machitidwe anu a Microsoft SQL Server, muyenera kuonetsetsa kuti mukukumana ndi zomwe gulu lanu likufuna kuti muteteze deta. Mabungwe kawirikawiri amafunika kutsatila ndondomeko zotsatila zamagulu, zomwe zimayang'anira kafukufuku wopezeka konse. Pofuna kuthana ndi zofunikirazi, SQL Server imapereka njira zosiyanasiyana zomwe zingagwiritsidwe ntchito pofufuza. Chofunika china chotsatira chotsatira ndikutumizira deta kuti muteteze kuntchito yosaloledwa mwakupezeka kuti zofikira pa mafayilo a deta yanu zasokonezedwa. SQL Server ikuthandizira izi podalumikiza deta yanu (TDE). Pochepetsa kuchepetsa chidziwitso chodziwitsidwa ndi ogwiritsira ntchito pazomwe akuyendetsera polojekiti, zipilala zomwe zili ndi data zovuta-monga nambala ya ngongole kapena nambala za chidziwitso-zikhoza kulembedwa pogwiritsa ntchito chida chodziwika nthawi zonse. Mutu uwu ukulongosola njira zomwe zilipo zogulira ku SQL Server, momwe mungagwiritsire ntchito ndi kuyang'anira mbali ya SQL Server Audit, ndi momwe mungagwiritsire ntchito kufotokozera.

  • Zosankha kuti muwerenge kupeza deta mu SQL Server
  • Kugwiritsa ntchito SQL Server Audit
  • Kusamalira SQL Server Audit
  • Kuteteza Data ndi Kutsegula

Lab: Kugwiritsa ntchito Audit ndi Kufikira

  • Kugwira ntchito ndi SQL Server Audit
  • Lembani Kholamu Monga Nthawi Zonse Zidatchulidwa
  • Lembani Databata pogwiritsa ntchito TDE

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani zomwe mungachite kuti muwone momwe mungapezere deta.
  • Tsatirani SQL Server Audit.
  • Sinthani Audit SQL Server.
  • Fotokozani ndikugwiritsira ntchito njira zokopera deta mu SQL Server.
  • Sungani kufotokozera

XMUMX ya Module: Ma Modesedwe Obwezera ndi Njira Zosungira

One of the most important aspects of a database administrator’s role is ensuring that organizational data is reliably backed up so that, if a failure occurs, you can recover the data. Even though the computing industry has known about the need for reliable backup strategies for decades—and discussed this at great length—unfortunate stories regarding data loss are still commonplace. A further problem is that, even when the strategies in place work as they were designed, the outcomes still regularly fail to meet an organization’s operational requirements. In this module, you will consider how to create a strategy that is aligned with organizational needs, based on the available backup models, and the role of the transaction logs in maintaining database consistency.Lessons

  • Kumvetsetsa Njira Zosunga
  • SQL Server Transaction Logs
  • Kukonzekera Njira Zosungira

Lab: Kumvetsetsa zitsanzo za SQL Server

  • Konzani ndondomeko yobwezera
  • Sungani Ma Models Recovery Models

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani njira zosiyanasiyana zobwezeretsera.
  • Fotokozani momwe zolemba zogulitsira malonda zimagwirira ntchito.
  • Sungani njira zothandizira SQL Server.

XMUMX ya moduli: Kusungira Zida Zogwiritsa Ntchito SQL Server

Mu gawo lapitayi, mudaphunzira momwe mungakonzekere njira yopezera zosowa za SQL Server. Mukutha tsopano kuphunzira momwe mungapangire zosamalitsa za SQL Server, kuphatikizapo zida zogwiritsira ntchito zamtundu uliwonse, zosungira zamalonda, ndi zosakaniza zapadera. Mu gawo ili, mudzaphunzira momwe mungagwiritsire ntchito njira zosiyanasiyana zosungira zinthu

  • Kuwongolera Mapu ndi Mauthenga Ogulitsa
  • Kusamalira Zosungira Zosintha Zina
  • Zolemba Zapamwamba Zopangira

Lab: Kusungira Zosintha

  • Kusungiratu Zomwe Zinalembedwa
  • Kupanga Maina Achikhalidwe, Kusiyanitsa, ndi Kukonza Mapulogalamu Opangira
  • Kuchita Backup Partial

Pambuyo pomaliza gawoli, mudzatha:

  • Pangani zolemba za SQL Server zolumikiza ndi zida zogulitsa.
  • Sungani zosungira zamadontho.
  • Fotokozani zosankha zakusungira zakutsogolo.

XMUMX ya moduli: Kubwezeretsanso zidule za SQL Server 7

Mu gawo lapitayi, mudaphunzira momwe mungapangire zosungira za ma SBL Server 2016. Njira yobwezeretsa ikhonza kukhala ndi mitundu yosiyanasiyana ya zosungira, kotero ndikofunikira kuti mutha kubwezeretsa. Nthawi zambiri mumabwezeretsa mndandanda mwachangu. Komabe, muyenera kutsimikiza kuti muli ndi ndondomeko yoyenera ya momwe mungapititsire ndikuthandizani kuti mupeze bwinobwino deta yanu kudziko lofunika. Ndondomeko yabwino ndi kumvetsetsa kwa kubwezeretsa kungathandize kupeŵa kuti zinthu zikhale zovuta kwambiri. Zosungiranso zina zamasitomala zokhudzana ndi kusokonekera kwadongosolo. Pazochitikazi, mudzafuna kubwezeretsa dongosololo mwatcheru ku dziko lomwe linalipo musanalephereke. Zolakwitsa zina, zokhudzana ndi zolakwika za anthu ndipo mungafune kubwezeretsa dongosololo mpaka mphothoyo isanachitike. Zinthu zowonongeka kwa nthawi ya SQL Server 2016 zingakuthandizeni kukwaniritsa izi. Chifukwa chakuti kawirikawiri zimakhala zazikulu kwambiri, zida zogwiritsira ntchito zimakhala zosakhudzidwa ndi zolephera za dongosolo kusiyana ndi malemba. Komabe, mauthenga a machitidwe angathe kuthandizidwa ndi zolephereka, ndipo chisamaliro chapadera chiyenera kutengedwa pamene akuchira. Makamaka, muyenera kumvetsetsa momwe mungayambitsire kachidindo kachitidwe kalikonse chifukwa simungagwiritse ntchito ndondomeko yofananayo ya mauthenga onse. Mu gawo ili, mudzawona momwe mungabwezeretsenso mauthenga a mawotchi ndi machitidwe ndi momwe mungagwiritsire ntchito ndondomeko yowonongeka. Tikuphunzirapo

  • Kumvetsetsa Kubwezeretsa Njira
  • Kubwezeretsa Zosintha
  • Zosintha Zongobweretsani Zochitika
  • Kubwezeretsa Pakati ndi Nthawi

Lab: Kubwezeretsa Zomwe Zomwe Zidasungira SQL Server

  • Kubwezeretsanso Kusungidwa kwa Database
  • Zosungira Zosungira Zina, Zosiyana, ndi Zosintha Zogulitsa Manambala
  • Kuchita Chiyero Chobwezeretsa

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani kubwezeretsa.
  • Bwezeretsani zolinga.
  • Pangani ntchito yobwezeretsa kubwezeretsa.
  • Chitani nthawi yowonongeka.

XMUMX ya moduli: Kusintha SQL Server Management

Zida zomwe zimaperekedwa ndi Microsoft SQL Server zimapanga zosavuta poyendetsa poyerekeza ndi injini zina. Komabe, ngakhale ntchito zili zosavuta kuchita, zimakhala zofunikira kubwereza ntchito nthawi zambiri. Otsogolera ogwira ntchito mndandanda amaphunzira kugwira ntchito mobwerezabwereza. Izi zingathandize kupeŵa zochitika zomwe wotsogolera amaiwala kuti achite ntchito panthawi yofunikira. Mwina chofunika kwambiri, ntchito yodziwikiratu imathandizira kuti azichita nthawi zonse, nthawi iliyonse yomwe aphedwa. Mutu uwu umalongosola momwe mungagwiritsire ntchito SQL Server Agent kuti muzitha ntchito, momwe mungakhazikitsire zochitika zachitetezo za ntchito, ndi momwe mungagwiritsire ntchito multiserver ntchito. Tikuphunzirapo

  • Kusuntha SQL Server kasamalidwe
  • Kugwira ntchito ndi Aganyu a SQL Server
  • Kusamalira Ntchito za Aganyu a SQL Server
  • Mautumiki a Multi-server

Lab: Kusintha SQL Server Management

  • Pangani Job Agent Server Job
  • Yesani Ntchito
  • Sungani Ntchito
  • Konzani Masitera a Master ndi Target

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani njira zowonetsera SQL Server Management.
  • Konzani ntchito, mawonekedwe a ntchito, ndi ndandanda.
  • Sinthani ntchito za SQL Server Agent.
  • Sungani ma seva ndi malingaliro omasulira.

XMUMX ya Module: Kukonzekera Chitetezo kwa Wothandizira SQL Server

Ma modules ena mu maphunziro awa asonyeza kufunika kochepetsa zilolezo zomwe amapatsidwa kwa ogwiritsa ntchito, kutsatira ndondomeko ya "mwayi wapadera." Izi zikutanthauza kuti ogwiritsa ntchito ali ndi zilolezo zomwe akufunikira kuti achite ntchito zawo. Zolingaliro zomwezi zimagwirizana ndi kupatsidwa kwa zilolezo kwa SQL Server Agent. Ngakhale kuti ndi zophweka kuchita ntchito zonse mu nkhani ya SQL Server Agent Account Service, ndikukonzekera akauntiyo monga akaunti yothandizira, malo osauka otetezeka angapezeke chifukwa chochita izi. Ndikofunika kumvetsetsa momwe mungakhalire malo osungira malo otetezeka a ntchito zomwe zimayenda mu SQL Server Agent

  • Kumvetsetsa SQL Server Agent Security
  • Kusintha Zovomerezeka
  • Kukonzekera Maakaunti a Proxy

Lab: Kukonzekera Security kwa SQL Server Agent

  • Kusanthula Mavuto mu SQL Server Agent
  • Kukonzekera Kuvomerezeka
  • Kukonzekera Akaunti ya Proxy
  • Kukonzekera ndi kuyesa Chigwirizano cha Tsatanetsatane wa Ntchito

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani chitetezo cha Aganyu a SQL Server.
  • Sungani zizindikiro.
  • Sungani akaunti za proxy.

XMUMX ya Module: Kuwunika SQL Server ndi Alerts ndi Notifications

Mbali imodzi yofunikira pa kuyang'anira Microsoft SQL Server ndi njira yogwira ntchito ndikuonetsetsa kuti mukudziwa mavuto ndi zochitika zomwe zikuchitika mu seva, monga zikuchitika. Zipangizo za SQL Server zambiri zokhudzana ndi nkhani. Mukhoza kuyisungira kuti ikukulangizeni pokhapokha ngati izi zikuchitika, pogwiritsira ntchito machenjezo ndi zidziwitso. Njira yowonjezereka imene SQL Server olemba ma data akulandila zambiri za zochitika ndi chidwi ndi uthenga wa imelo. Mutuwu umaphatikiza kukonza kwa Database Mail, machenjezo, ndi zinsinsi za SQL Server chitsanzo, ndi kasinthidwe ka machenjezo a Microsoft Azure SQL Database. Tikuphunzirapo

  • Kuwunika Zowononga SQL Server
  • Kukonzekera Ma Mail Database
  • Ogwira Ntchito, Alerts, ndi Zidziwitso
  • Zowonongeka mu Azure SQL Database

Lab: Kuyang'anira SQL Server ndi Alerts ndi Notifications

  • Kukonzekera Ma Mail Database
  • Kukonzekera Ogwira Ntchito
  • Kukonzekera Alerts ndi Notifications
  • Mayesero Oyesera ndi Zidziwitso

Pambuyo pomaliza gawoli, mudzatha:

  • Yang'anani zolakwika za SQL Server.
  • Konzani makalata achinsinsi.
  • Konzani operekera, machenjezo, ndi zidziwitso.
  • Gwiritsani ntchito machenjezo mu Azure SQL Database.

11 Module: Kuyamba Kulamulira SQL Server pogwiritsira ntchito PowerShell

Njira iyi ikuyang'ana momwe mungagwiritsire ntchito Windows PowerShell ndi Microsoft SQL Server. Mabungwe akuyenera kuwonjezera nthawi zonse ndikukhala ndi chitsimikizo cha kusungirako zipangizo zawo; ndi PowerShell, mungathe kusintha njirayi ndi kudalirika polemba malemba kuti mugwire ntchito. PowerShell malemba angayesedwe ndikugwiritsidwa ntchito nthawi zambiri ku ma seva ambiri, kupulumutsa gulu lanu nthawi ndi ndalama

  • Kuyamba ndi Windows PowerShell
  • Konzani SQL Server pogwiritsa ntchito PowerShell
  • Sungani ndi kusunga SQL Server ndi PowerShell
  • Kusintha Zambiri Zogwiritsa Ntchito SQL Zogwiritsa ntchito PowerShell

Lab: Kugwiritsira ntchito PowerShell Poyang'anira SQL Server

  • Kuyamba ndi PowerShell
  • Kugwiritsa ntchito PowerShell kusintha SQL Server makonzedwe

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani ubwino wa PowerShell ndi mfundo zake zofunika.
  • Konzani SQL Server pogwiritsira ntchito PowerShell.
  • Sungani ndi kusunga SQL Server pogwiritsira ntchito PowerShell.
  • Gwiritsani ntchito SQL Database Yogwiritsira ntchito PowerShell.

XMUMX ya module: Kutsegula Access kwa SQL Server ndi Zochitika Zowonjezera

Kuwunika kayendedwe ka kayendedwe ka ntchito kumapereka njira yabwino yowunika momwe ntchitoyi ikuyendera. Komabe, nthawi zina mumafunika kufufuza zambiri zomwe zikuchitika mkati mwachithunzi cha Microsoft SQL Server-kuthetsa mavuto ndi kupeza njira zowonjezeretsa ntchito yogwira ntchito. Zochitika Zowonjezeredwa ndi SQL Server ndizowonongeka, zosavuta zochitika zomwe zikuchitika mu Microsoft SQL Server Database Database. Mutu uwu umayang'ana pa malingaliro apangidwe, njira zothetsera mavuto ndi zochitika zogwiritsira ntchito Zochitika Zowonjezera. Tikuphunzirapo

  • Mfundo Zofunika Zowonjezera
  • Kugwira Ntchito ndi Zochitika Zowonjezereka

Lab: Zochitika Zowonjezera

  • Kugwiritsa Ntchito Gawo la Nkhani Zowonjezera Zachikhalidwe
  • Tsamba la Tsatsatane Kutaya Ntchito Zowonjezera

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozerani Zochitika Zowonjezera mfundo zazikulu.
  • Pangani ndikufunsanso magawo Owonjezera a Zochitika.

XMUMX ya module: Kuwunika SQL Server

Injini ya Microsoft SQL Server Database ingagwire ntchito kwa nthawi yaitali popanda kufunika koyang'anira. Komabe, ngati nthawi zonse mumayang'anitsitsa ntchito yomwe imapezeka pa seva ya deta, mungathe kuthana ndi mavuto omwe angakhalepo musanayambe. SQL Server imapereka zida zingapo zomwe mungagwiritse ntchito kuti muwone zochitika zamakono ndi zolemba za ntchito yapitayi. Muyenera kudziwa zomwe zipangizozi zimachita komanso momwe mungagwiritsire ntchito. Zimakhala zosavuta kukhumudwa ndi kuchuluka kwa zida zogwiritsira ntchito zowunika, kotero muyenera kuphunzira njira zowunika zomwe zatuluka.

  • Ntchito yowunika
  • Kutenga ndi Kusamalira Machitidwe Ogwira Ntchito
  • Kusanthula Deta Yogwira Ntchito
  • SQL Server Utility

Lab: Kuwunika SQL Server

Pambuyo pomaliza gawoli, mudzatha:

  • Yang'anirani ntchito yamakono.
  • Tsatirani ndi kuyendetsa deta ya ntchito.
  • Fufuzani deta yosonkhanitsa.
  • Konzani SQL Server Utility.

14 ya moduli: Kusokoneza maganizo SQL Server

Olamulira ogwira ntchito ndi ogwira ntchito a Microsoft SQL Server ayenera kutenga mbali yofunikira yothetsera mavuto pakabuka mavuto-makamaka ngati ogwiritsa ntchito mapulogalamu ofunika kwambiri a bizinesi omwe amadalira SQL Server akudziwidwa kuti asagwire ntchito. Ndikofunika kukhala ndi njira zoyenera kuthetsera nkhani zonse, ndikudziŵa bwino lomwe nkhani zomwe zimachitika pogwira ntchito ndi ma SQL Server. Tikuphunzirapo

  • Njira Yopseza Mavuto kwa SQL Server
  • Kuthetsa Nkhani Zogwirizana ndi Utumiki
  • Kuthetsa Kuyanjana ndi Zolemba-kulowerera

Lab: Zosokoneza Mavuto Amodzi

  • Kambiranani ndi Kuthetsa SQL Login. Nkhani
  • Sungani Mavuto ndi Kuthetsa Nkhani Yothandiza
  • Zingathetsani ndi Kuthetsa Mawindo Omasulira Windows
  • Kambiranani ndi Kuthetsa Nkhani Yopha Ntchito
  • Sakanizani ndi kuthetsa vutoli

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani njira yothetsera mavuto kwa SQL Server.
  • Sungani nkhani zokhudzana ndi utumiki.
  • Sankhani zolowera ndi zovomerezeka.

XMUMX ya moduli: Kutumiza ndi Kutumiza Deta

Ngakhale kuti deta yambiri ikukhala mu seva ya Microsoft SQL Server imalowa mwachindunji ndi ogwiritsa ntchito mapulogalamu, nthawi zambiri pamafunika kusuntha dera kumalo ena, kuchokera ku SQL Server. SQL Server imapereka zida zomwe mungagwiritse ntchito kutumiza deta mkati ndi kunja. Zina mwa zipangizozi, monga bcp (Bulk Copy Program) ndi SQL Server Integration Services, zili kunja kwa injini yachinsinsi. Zida zina, monga mawu a BULK INSERT ndi ntchito OPENROWSET, ikugwiritsidwa ntchito mu injini yachinsinsi. Ndi SQL Server, mungathe kukhazikitsa mapulogalamu omwe amagwiritsira ntchito deta, mawonedwe, ndi zinthu zomwe zimagwirizanitsidwa ndi deta yosungiramo zida. Mu gawo ili, mufufuze zida izi ndi njira kuti muthe kulowetsa ndi kutumizira deta kuchokera ku SQL Server. Tikuphunzirapo

  • Kutumizira Data ku SQL Server ndi kuchokera
  • Kulowetsa ndi Kutumiza Zapamwamba Zamatabuku
  • Kugwiritsa ntchito bcp ndi BULK INSERT kuti Import Data
  • Kutumiza ndi Kupititsa patsogolo Chidziwitso cha Deta

Lab: Kutumiza ndi Kutumiza Deta

  • Dongosolo la Import ndi Excel Pogwiritsa Ntchito Import Wizard
  • Lembani Ndemanga Yopanda malire Pakompyuta Pogwiritsa ntchito bcp
  • Tengerani Ndemanga Yopanda malire Pulogalamu pogwiritsa ntchito BULK INSERT
  • Pangani ndi kuyesa Phukusi la SSIS kuti muchotse Deta
  • Sungani Zotsatira za Data

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani zida ndi njira zothetsera deta.
  • Dinani ndondomeko ya tebulo.
  • Gwiritsani ntchito bcp ndi BULK INSERT kuti mulowetse deta.
  • Gwiritsani ntchito mapulogalamu othandizira kuti mulowetseni ndi kutumizira zolemba zamtunduwu.

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, mverani mwachifundo Lumikizanani nafe.


Reviews