Izicwangciso zoLondolozo lweDatabase zivumela ukuba wenze ngokuzenzekelayo imisebenzi eminingi yokulawula idatha kwi- Microsoft SQL Server . Unokwenza izicwangciso zokondla usebenzisa inkqubo elula ye-wizard ngaphandle kolwazi lwe-Transact- SQL .
Ungenza le mi sebenzi elandelayo kwisicwangciso sokugcinwa kwedatha:
- Ukunciphisa idatha
- Ukuxhaswa kwedatha
- Ukwenza isaziso somsebenzisi
- Ukuhlaziya iinkcukacha zeenkcukacha
- Ukuqinisekisa ubungqina beziko leenkcukacha
- Ukucoca iifayile zokulondoloza ezisele
- Ukusebenzisa umsebenzi we-SQL Server Agent
- Ukusebenzisa isitatimende se-Transact-SQL
- Ukwakha kwakhona isalathisi
- Ukuhlela kwakhona isalathisi
- Ukucoca iinkcukacha zeenkcukacha
01 ngo 07
Ukuqala iNdiza yeSondlo yeSondlo soLondolozo lweDatha
Vula i-Microsoft SQL Server Management Studio (SSMS) kwaye wandise ifolda yoLawulo. Ukucofa kwesokudla kwiFolda yeSicwangciso soPhuhliso uze ukhethe iMenu yeSicwangciso sokuSondeza kwi menu ekuphumayo. Uya kubona iskrini sokuvula, njengokuba kuboniswe ngasentla. Cofa Okulandelayo ukuze uqhubeke.
02 we-07
Gama iSicwangciso soSondlo seNgcaciso
Kwiskrini esilandelayo ebonakalayo, unike igama kunye nenkcazo yesicwangciso sakho sokugcinwa kwedatha. Kufuneka unike ngolwazi apha oluya kunceda omnye umlawuli (okanye wena!) Ozama ukuqonda injongo yesicwangciso okanye inyanga ukususela ngoku.
03 we-07
Shedyuli iSicwangciso soSondlo sakho seNgcaciso
Mhlawumbi ufuna ukukhetha okukhethiweyo apha "Ihedyuli yedwa kwisicwangciso sonke okanye akukho cwangciso". Unakho ukhetho lokudala iishedyuli ezahlukeneyo kwimisebenzi eyahlukileyo, kodwa ndikhetha ukudala izicwangciso ezahlukeneyo kwiishedyuli ezahlukeneyo ukunceda ukugcina izinto ngokuchanekileyo.
Cofa iqhosha lokutshintsha ukuguqula ishedyuli esingagqibekanga uze ukhethe usuku kunye nexesha eliza kwenziwa. Cofa iqhosha elilandelayo xa ugqibile.
04 we-07
Khetha Imisebenzi yeSicwangciso sakho soSondlo
Uza kubona iwindi eboniswe ngasentla. Khetha umsebenzi (o) ofuna ukuyifaka kwisicwangciso sakho sokugcinwa kwedatha. Xa uqedile, nqakraza iqhosha elilandelayo ukuze uqhubeke.
05 we-07
UkuLawula iMisebenzi kwisiCwangciso seNgcaciso yeSondlo
Iwindow elandelayo, eboniswe ngasentla, ikuvumela ukuba utshintshe umyalelo wemisebenzi kwisicwangciso sakho sokugcina ngokusebenzisa i-Move Up and Move Down.
06 we-07
Qwalasela iinkcukacha zeSicwangciso soSebenzi
Emva koko, uya kuba nethuba lokuqwalasela iinkcukacha zomsebenzi ngamnye. Izinketho ezinikezelwe kuwe ziyahlukahluka ngokusekelwe kwimisebenzi oyikhethile. Umfanekiso ongentla uchaza umzekelo weskrini esetyenziselwa ukumisela umsebenzi wokugcina. Xa uqedile, nqakraza iqhosha elilandelayo ukuze uqhubeke.
07 we-07
Khetha iSicwangciso seNgcaciso yokuPhathwa kweSicwangciso
Ekugqibeleni, unako ukufumana iSQL Server yakha ingxelo ngethuba ngalinye isicwangciso senza iqulethe iziphumo ezinzulu. Unokukhetha ukuba le ngxelo ithunyelwe kumsebenzisi nge-imeyile okanye igcinwe kwifayili yombhalo kwiseva.