
dayta niyantrana bhasha

dayta niyantrana bhasha (dii. sii. ell) anedi database (adhikaram) loe nilva chesina daetaaku praapyatanu niyantrinchadaaniki upayoginche computer prograaming bhasha maadirigaane vaakyanirmaanam. mukhyamgaa, idhi nirmaanaatmaka prasna bhasha (SQL) loe oka bhaagam. dayta niyantrana bhasha anedi SQL aadeshaalalo taarkika samoohaalalo okati. SQL anedi relational database management systems kosam praamaanika bhasha. databaseku daetaanu choppinchadam, databaselo daetaanu tolaginchadam ledhaa naveekarinchadam ledhaa database nundi daetaanu tirigi pondadam vanti panulanu nirvahinchadaaniki SQL statementlu upayoginchabadataayi.
database vyavasthalu SQL nii upayoginchinappatiki, avi saadhaaranamgaa vaari vyavasthalo matrame upayoginche vaari swantha adanapu yajamanya podigimpulanu kooda kaligi untaayi.  udaaharanaku microsoft ess. kyuu. ell sarvar transact-ess. kyuu. ell (tii-ess. kyuu. ell) nuu upayogistundi, idhi ess. kyuu. ell yokka podigimpu. adevidhamgaa orakil vaari yajamanya podigimpu ayina pl-sql nuu upayogistundi. ayithe, "enchukondi", "choppinchandi", "naveekarinchandi", "tolaginchandi", "srushtinchandi" mariyu "drop" vanti praamaanika SQL aadesaalanu databaseto cheyavalasina daadaapu pratidaanni saadhinchadaaniki upayoginchavacchu.
dii. sii. ell aadesaala udaaharanalu
viniyogadaaru ledhaa paatra nundi pratyeka hakkulu manjuru cheyabadavachhu ledhaa raddu cheyabadavachhu, dayta definition longuage (ddl) mariyu dayta manipulation longuage (dml) rendintikee vartistundi, mariyu connect cheyadam, enchukovadam, choppinchadam, naveekarinchadam, tolaginchadam, amalu cheyadam mariyu upayoginchadam vantivi undavacchu.
microsoft SQL sarvar.
microsoft ess. kyuu. ell sarvar prakaram ess. kyuu. ell aadesaala yokka naalugu samuuhaalu unnaayi.
database looni viniyogadaarula kosam access controll mariyu anumati nirvahana kosam dii. sii. ell. aadesaalanu upayogistaaru. vaaritho manam pattikalu ledhaa recordula (varusa sthaayi bhadrata) looni viniyogadaarula kosam konni charyalanu sulabhamgaa anumatinchavacchu ledhaa tiraskarinchavacchu.
dii. sii. ell. aadesaalu
udaaharanakuh oka nirdishta pattika ledhaa bahula pattikallo enchukoovadaaniki, choppinchadaaniki, naveekarinchadaaniki mariyu tolaginchadaaniki viniyogadaaruku adhikaaraalanu ivvadaaniki graantnu upayoginchavacchu.
upasamharana aadesam anedi pratyeka hakkunu (default) tirigi teesukondi ledhaa avasaraala aadhaaramgaa naveekarana ledhaa tolagimpu vanti nirdishta aadesaanni upasamharinchukovadaaniki upayoginchabadutundi.
udaaharana.
modati sandarbhamlo manjuru cheyandi, memu user 1 kii employees anie piluvabade tablepy enchukoovadaaniki, choppinchadaaniki, naveekarinchadaaniki mariyu tolaginchadaaniki adhikaaraalanu icchaamu.
eee aadesamto upasamharinchukondi, manamu defaultga unna hakkunu tirigi teesukovachhu, eee sandarbhamlo, user 1 kosam table employees paie command insertnu tirigi teesukuntamu.
tiraskarana anedi oka nirdishta aadesam. prati viniyogadaaruku hakkula jabita undani, adhi tiraskarinchabadindi ledhaa manjuru cheyabadindi anie memu nirdhaarinchavacchu, kabatti database vastuvulapai meeku konni adhikaaraalanu spashtamgaa nishedhinchadaaniki aadesam niraakarinchadam undhi.:
orakil database.
orakil database SQL aadesaalanu vividha rakalaku vibhajistundi. avi.
vivaraala kosam orakil-tii. sii. ell. nuu chudandi         
dayta definition longuage (ddl) statementlu eee panulanu nirvahinchadaaniki mimmalni anumatistaayih
kabatti orakil database ddl aadeshaalalo manjuru mariyu upasamharana adhikaralu untaayi, idhi vaastavaaniki microsoft SQL sarvarlo dayta niyantrana bhaashalo bhaagam.
orakil database loe manjuru mariyu upasamharana kosam vaakyanirmaanamh
orakillo lavadevila niyantrana prakatanalu.
lavadevila niyantrana prakatanalu dml prakatanala dwara chesina maarpulanu nirvahistaayi. lavadevila niyantrana prakatanalu
mysql.
mysql sarvar vaaru ess. kyuu. ell statementlanu vividha rakaala statemenlugaa vibhajistaaru
vivaraala kosam mysql lavadevila prakatanalanu chudandi
grant, upasamharinchukune vaakyanirmaanam anevi database administration statementla khaataa nirvahana vyavasthalo bhaagamgaa untaayi.
grant statement system administratorlaku viniyogadaarula khaataalu mariyu paatralaku manjuru cheyagala adhikaralu mariyu paatralanu manjuru cheyadaaniki veelu kalpistundi. eee vaakyanirmaana parimitulu vartistaayih
upasamharana prakatana vyavastha nirvaahakulaku viniyogadaarula khaataalu mariyu paatrala nundi upasamharinchukovachhu, adhikaralu mariyu paatralanu upasamharinchukovadaaniki veelu kalpistundi.
udaaharanalu.
postgreskwal loe, dii. sii. ell. nuu amalu cheyadam lavadevi, mariyu tirigi tippavacchu.
databaselalo viniyogadaarulaku icchina adhikaaraalanu niyantrinchadaaniki SQL aadesaalanu manjuru mariyu upasamharinchukovadam upayogistaaru.
Sqlite kii etuvanti dcl aadesaalu laevu endukante dheeniki viniyogadaaru paerlu ledhaa laaginlu laevu. badulugaa, databasenu evaru teravagalaru mariyu access cheyagalaro nirvachinchadaaniki sclite file-system anumatulapai aadharapadi untundi.