Amathebula asebenza njengeyunithi eyisisekelo yenhlangano kunoma iyiphi idatha, kuhlanganise nalabo abaphethwe yi- SQL Server 2012 . Ukuklama amatafula afanele ukugcina idatha yakho kuwumthwalo obalulekile womthuthukisi we database kanye bobabili abaklami nabaphathi kumele bajwayele inqubo yokwakha amatafula amasha wesisekelo se-SQL Server. Kulesi sihloko, sihlola inqubo ngokuningiliziwe.
Qaphela ukuthi lesi sihloko sichaza inqubo yokudala amatafula ku-Microsoft SQL Server 2012. Uma usebenzisa inguqulo ehlukile ye-SQL Server, sicela ufunde Ukudala Amathebula ku-Microsoft SQL Server 2008 noma Ukwakha Amathebula ku-Microsoft SQL Server 2014.
Isinyathelo 1: Yakha Ithebula Lakho
Ngaphambi kokuba ucabange ngokuhlala ekhibhodi, susa ithuluzi lokuklama elibaluleke kakhulu elitholakalayo kunoma yimuphi umthuthukisi wedatha - ipensela nephepha. (Kulungile, uvunyelwe ukusebenzisa ikhompiyutha ukwenza lokhu uma uthanda - I-Microsoft Visio inikeza izifanekiso ezinhle zokwakha.)
Thatha isikhathi sokudweba ukuklanywa kwedatha yakho yakho ukuze ihlanganise zonke izakhi zedatha nobuhlobo obudinga ukuhlangabezana nezidingo zebhizinisi lakho. Uzoba ngcono kakhulu ngokuhamba kwesikhathi uma uqala inqubo ngesakhiwo esiqinile ngaphambi kokuba uqale ukudala amatafula. Njengoba uhlela database yakho, qinisekisa ukuthi ufake i- normalization database ukuze uqondise umsebenzi wakho.
Isinyathelo sesi-2: Qala Is Studio Studio Management SQL
Uma usuhlele i-database yakho, yisikhathi sokuqala ukuqaliswa kwangempela. Indlela elula yokwenza lokhu ukusebenzisa i-SQL Server Management Studio. Qhubeka futhi uvule i-SSMS bese uxhuma kuseva elondoloza idatha lapho ungathanda ukudala itafula elisha.
Isinyathelo sesi-3: Hamba kuFolda Ekulungile
Ngaphakathi kwe-SSMS, kuzodingeka uhambe uye kufolda ifolda yedatha efanele. Qaphela ukuthi isakhiwo sefolda ngakwesokunxele sefasitela siqukethe ifolda ebizwa ngokuthi "Amadokhumenti". Qala ngokukhulisa le folda. Khona-ke uzobona amafolda ahambisana naso yonke yolwazi olugcinwe kuseva yakho. Nwebisa ifolda ehambelana nedatha lapho ufisa ukudala itafula elisha.
Okokugcina, yandisa ifolda yeThebula ngaphansi kwalolu datha. Thatha isikhashana ukuhlola uhlu lwamatafula asevele ekhona ku-database bese uqinisekisa ukuthi kubonisa ukuqonda kwakho kwesakhiwo se-database esivele sikhona. Ufuna ukuqinisekisa ukuthi ungadala ithebula eliphindwe kabili, njengoba lokhu kuzokubangela izinkinga eziyisisekelo phansi komgwaqo okungase kube nzima ukulungisa.
Isinyathelo 4: Qala Ukudala Ithebula
Chofoza ngakwesokudla kwifolda yeTables bese ukhetha ithebula elisha kusuka kwimenyu e-pop-up. Lokhu kuzovula iwindi elisha ngaphakathi kwe-SSMS lapho ungakha khona ithebula lakho lokuqala le-database.
Isinyathelo 5: Yakha Amakholomu Wethebula
I-design interface ikunikeza ngegridi yamakholomu amathathu ukuze ucacise izindawo zetafula. Ngomqondo ngamunye ofisa ukukugcina etafuleni, uzodinga ukukhomba:
- Igama lekholomu : Lokhu, ngokusobala, igama lezimfanelo. Inhlamvu ngayinye yedatha ifana nokuguquguquka; kuyinto eyodwa yedatha ukuthi i-database yakho izolondoloza irekhodi ngalinye. Isibonelo, uma unetafula elinolwazi lokuxhumana, ungase ube namakholomu okuthiwa i-FirstName, LastName, HomePhone, ne-imeyiliI-imeyili enolwazi olumayelana nomuntu ngamunye kumininingwane yokuxhumana.
- Uhlobo Lwedatha : Uhlobo lwedatha luchaza uhlobo lwazi oluzoligcina kukholomu ngayinye. Isibonelo, igama lomuntu lokuqala liqukethe izintambo zezinhlamvu, ngakho-ke ungasebenzisa uhlobo lwedatha ye - varchar (50) ukuze ukhombise ukuthi ikholomu izokuqukatha ucingo olude lokuhluka olungafani nezinhlamvu ezingu-50. Ngokufanayo, usuku lokuzalwa luzosebenzisa usuku lwedatha yedatha. Ukuze uthole ukwaziswa okwengeziwe, bheka isihloko sethu kwizinhlobo zedatha ye-SQL Server.
- Vumela izintambo : Lokhu kumane nje ibhokisi lokuhlola. Uma uhlola, i-database izokuvumela ukuthi ugcine amanani angenalutho (noma angenalutho) kuleyo kholomu. Ukuze uthole ukwaziswa okwengeziwe, bheka Ukuqonda ama-NULL Amanani .
Qhubeka futhi ugcwalise umthamo wegridi, unikeza ngayinye yalezi zicucu ezintathu zolwazi kukho konke ikholomu kuthebula lakho elisha lemininingwane.
Isinyathelo 6: Thola Isihluthulelo Esiyinhloko
Okulandelayo, qokomisa ikholomu (ama) oyikhethile ukhiye oyinhloko wetafula lakho. Bese uchofoza isithonjana esikhiye kubha yomsebenzi ukusetha ukhiye oyinhloko. Uma unekhibhodi eyisisekelo eningi, sebenzisa ukhiye we-CTRL ukugqamisa imigqa eminingi ngaphambi kokuchofoza isithonjana esikhiye.
Uma usuwenzile lokhu, ikholomu eyinhloko yokhiye izobonisa uphawu olubalulekile ngakwesokunxele kwegama lekholomu, njengoba kuboniswe esithombeni ngenhla. Uma udinga usizo, ungase ufune ukufunda isihloko sokukhetha ukhiye oyinhloko .
Isinyathelo 7: Igama futhi Gcina Ithebula Lakho
Ngemuva kokudala ukhiye oyinhloko, sebenzisa isithonjana sediski kubha yamathuluzi ukulondoloza ithebula lakho kuseva. Uzocelwa ukuba unikeze igama letafula lakho uma ulondoloza okokuqala. Qinisekisa ukukhetha into echazayo ezosiza abanye baqonde injongo yetafula.
Yilokho okukhona kulokho. Siyakuhalalisela ngokudala ithebula lakho lokuqala le-SQL Server!