JU VUE UV FU SQL Server By Mr.Sudhkar L Naresh Technology sri RAGHAVENDRA XEROX ae ra on fe aa cain ac een meer Hyderabad. i. "call 9549506309 veae oO > 807. Dm ts a collactron ob Sry Applicaton Frontend Racked j enter [Towa] pp ¢— Frout-eud <— elt prlicatron Aplin | O1-10- 2015 , Thursday Lubeduction tp 0gms: _ oes pes O persou hag tp Paterach wot th aL Ou obo matter every Dey - Tnovder bo inlet with huge aumowdt of daformatron we vied a System ran be Cau ste Movipulate providleg Security oud short tn Low * “4 a Exbovnalton allovey thc world. For Het) Reason | : qomiaabtous wotll motes Dabbare Mosogemsent systia Dalz: pale ts plolf . - ts Noth bub tHe Rawfacl where ak Rowfact a Collechon of plumbers , chanaclen 2Ctap . se dyes. o , Spectal chsnacleya, hateve EB luoion os ot ever we inpul prow Mie fergboard ey — valk Never provide Bia. Measgbal slaternedS t tax oter. Brbmrrsalon r= proceéRing tt Dale 2s called af Informatie > Tabrymalion always provide Hie eautigpul ‘_ ' : opt Slabewer| 1 Ta user : a b SRI RAGHAVENDRA XEROX ‘Software Languages Material Available ‘esl Bangalore Ayyagat Baker, ‘Opp. CDAC, Balkampet Road, ‘Ameerpet, Hyderabad.palnase:— Ft to a collectton of rbormation hake hoa been uovtttin tn pre-detivatned manney aud Store into a particular Cocatton ts cabled a Ootrbare ) DBMS: DEMS fs a Soffwawe of TOO Sed to olakulined aud Mewege The wo pala Databare ty whe Sewer. KDBy ie — _ DEMS [coset } 4 “rel An Catavbace. — Here, Pans Toot cotll act as au Prtzvbace bekixen fs UseY ove pababare - models of pams— pams Covilaing thy Plowing & model Ir Fel Mouageuout Systinn Cm) 2 Hverorchy Mawagenant- gystain (Hs) 3 Networks DalaBare Mauagenueuk- Systein (nu pems) Ar Relation patitore Management System (RD6MS) 5+ object Relabion DBMS (oRDBMS) G» abject ovteuted Relation pems Coornems) Mauagenent System (FM S\i— Ms ts a Feyst mede) of Dams Which wab Intoduced tr 1950's > In This model Te patK voll) be stored fo the form of- or Couttnuous Stream of cbaractir& mManney.2oloq|isAmeerpele 103 SrTvam guooe Lapa] SR Wager 10 Rarntyoo 20|t0lis@alarngay - ~~ == = - - Nodar? 23000 filse1Bavakaespele Prloweacks 3 > Maxe t3.& no Seuvslg to ttn tabormation wotlintn tik Plus. ~ Re trteuteg Stim. dalx ts Time Consuming Becau ever requtred Bhhormation purpose tt user has be perborm O Search operation ona gle. > Inconsistingy off Ua oel® CTusre #5 no proper omer) = This Medel Soloesnit eupportsd Dali bipes machoui Sn 3 We Caunot shane fa vyequtred tnhermatten to Ha mulkiple LSsers a. tHterarchy Mamaemaut systim CHMS) = Tk FS Ws. Second w moda of pams rhsel ws destyn avd developed by wm mm Company . olin tha web developing a prefect c &S keen 03 Inbeomation Mavagemet Systar (ms) in 1460's - In To model Te dala word be steve te te form of atyee Stach aud tt Conbxing Me follecomg levels, Thoxe are. 1 Root level wil) Represeads Dale bare Nawe &, SF. & parent (wel cll Repreteuts Tables Nae. Sie 2. bed lok wil Represele columns Nowe & ves?M, ie eee er SAI aspoo tor Kawal (2000 1o% SAV 2u000 ies Romane [uoed i } , ’ ‘ ‘ ae Havi 33000 Advantages 3 ee % Ss pastiy Thay pms model spats frelvoulsge ob tris sede means aafog [is ao[oris 22307] ollo]1s 1 false re Languages Material Available ide Bangalore Ayyagar Bakery, SRI RAGHAVENDRA XEROX Besic Softwar CDAC, Balkampet Road, ‘Ameacpet, Hyderabad Opp. fesse] Ee] [Ber] Csi) madhapy Arnecrpel SANager Balonager « y i Bovakempele ~ tt vebeving (te > Bali, rotll be Maintained tm Constslaxcg Manner Cie. poepes, order):¢ yran0 > Thy Modal tS Supported oaletypes Machatim (Trlger, choy, Dectual, Date aud Time Dalebppe ote), Drawback st + Ta tts model ouly cue Peston cow tateratl cits Ma Dalaloase at o tue > lanwer we add a Navualue t add extitiny chiuctire Tin tte oser has vecoushiuct ta entive shiurchave so ft Lesch Tha tue Consuming aud alto burden of Be Proqromue —> Tess Medel & abo mot Supported shartug thal tnbsremalton bo the multtple Users, GB networks Daliware Mawagement Systiun CNOSMs): Tk ts (ta Third mods of cams coluich was devtgned aud develeped by tee Lem compauy tn (769 > Ta he saedal Tha Dale whl be shoved en tte form of Tree chuclitee oud Tubiqratad wet Neloorks GR main Aduautage ob Nogms ts t Share te equived tnbor mation to tte mulbpl veers acl abjo multiple programmers Can totivath wth fla Same Dafabake ot a tue.foswse, Mondey DisAdvoutages | There Ts no proper Setotly to te Certtroliges| palileare. 5 Dabe's Under fhe nijo's. = a palate Qeduudauey will be nCreartd. Gucreas.tag 5 Apliatz values) O 3. TE occupy mmom Masog o fe Oute Tae Hamer vol be Occupied Hien “ttc Server burden voll be Excreated 5. Application performance §s Crduted ; 6. user wll get dilog Qesponces frowctr catalase Gervet> O Note: - > [le Above 2 medals (Ems, Hus, ND@ms) ave ouldlabad ~ U Relational pats Base Mownageunout System Ceoems) + > Ta RoRMS are’ study ov Q-tation @ alich comLe defied ob the Commonness bebween Wa objects . > THs Relation ogetn chiuthied tnt 2-tpes. Lone -one Relation:- A Rowin a Fable is arsoctalid with a Row tr an otherToble fs Known ay One -one Relalton. > eA £ a sticleut HNOOr GG) 9909000 2. Oue —TO- : a ee * Row in a Table ts anoctitid wrth Rows in an other Table ts Known a5 7 os Hoy —tr-one. Relalton. ott 12M 3B. Mow —TO— MO x ma M4 r Maw Cowk in a Table tA arhoctabed Lowy Rows in an otter Tabls 7¢ Krown of Mowg To maw Relationship Mam [Vendor | product 1] vendor 2 Prduct >| Verdor 3 oduk 2 “ SRI RAGHAVENDRA XEROX Software Languages Material Avaliable Beside Bangalore Ayyagar Bakery. ‘Opp. CDAC, Balkampet Road, ‘Ameerpet, Hyderabad. > Ae a Pelatron chips ans called a Degree Relatisnshey wee “ : ree ia ashy oe stoned by Tha Germam SckeiliSt Mr. ERcedd * ite a Woltendlical concept %3 Called as nal-Algebra @n (940-Feataves of ROBMS :— oe Os Putty meds Tee dafx cot be Stored) ite form & cabler Formal = > A Table re a collection ch Rows aud columns. Me ~ Horizontal (gus are abled a5 Rows @ pecords @ Toples . oud the yerttad net are called as Columns @atrtiadey 5 @ Feelds- 5 > dn Gulzv section with tte bebween a Bow aud a column % 5 gnown as Cell. eobere o& call bs roti bub-idhere we Cam Stove Te Origiral Cal ® = owns produce rotll provide The High book Security me ~' DE Gupormation v9 The Help of puttsirticatcen ov itherizition modes. Acowule oud Cmsstinny Atlas dette: tn thas Dalrtote Tables by ving Dalit Zitzgrily machauttm Cosing end Comsbiauly aud Tlygers) Oo 2 @ — pastly accent Wa oul From Tt palaloake Tablas tty Ma Help of Frolaces Machaulsen ~ @ Share tn Ta coltbar Tably te multiple eo by stig Syrorgyms aud views objectt, *) O providtiy Revsabltly Fauctitn worti tt help of - Stored procedure aud shred Funttionk- >) © shaving Ue Required cole bare tubermebion From one : + ae ee ont Sle tp wh ober op vote wits ma bolp les (-mBp aud Lap PIb4) aud abs 7] Back-up Files (:ba0k fe) c ~ mS= @ Tre Falter of Ua prams ts my. EF.codd * Groupe of ROBMs:- D carsewer (© dor . : @ owcle @ Snbormebtey SRI RAGHAVENDRA XEROX SQL Ss. software Lar Material Available ® ™ $¢ @ Sugren Beste Bangalore Ayyagar Bakery, C @& sybue @ Tuborenir ‘Opp. CDAC, Balkampet Road, Ameerpet, Hyderabad. Cc @ Teradae. C [6 Ho-Ro1s + Tuesdey, © E-R Model Relove eveloping the oviginel DE App'n FIGE o DB programmer or Avclitze ill falta Maual De Zubormatfon (Clieml vegutcenady) loki thay oll Comet) whe te pictavial formal: > Wis pidefal repremitition ts called ay E- Diogram > Bebere wetcnt te design Th ER Diagrous we should ellos Tha fatlousing Sreeols Tse, Owe 5 ot ws] Repraed a THe None® Enbvome Cc Cc G c ago0000 C™> —5 Lt wll Reprereut Us cxlimy Nawey < ct will Geprepede tte Gelotmalep beheeen - ie erteties ond la enteties “ Wa ve ' —> es Te will ~ Sai genni Ts a eackend tod wlth Ps Uned & design oud c clevelep tin Backend appltalions tor story Some Lustners © relat tabormalion ob 0 pantzalar organtgotion . 7 > Searservey stl Pun ov tnstlled on windows eperatig syste only. CTE TS o Complele platform dependaut (only ot cpenting Spslen c (& Supportial -s(ustndows)) C > SQL Server will provide wore Grophical user inti face (GUE) c Fatelttes, thomas Mat Ha user Gr gnbcxacd sith Oalbteare c withouk Comember In Quartes oF Comroancls « > The Fevst version of SQLServe ts HO whic es releaseof Cc ry (989. Ma Coupleti versions of Sal sewer c VeSsions Yeny @eleabename — eadlottauce c ho 1485 Saqrserver 1-0 - ¢ hl 1991 SaLServer joy c a2 1992 SQLServer U2] SQUNT ‘ Go 9S" sRLSewer Go seca . Ce Wb saiSener bes Hydra. | Cc Fo 1998 ei Server 7-0 Sphinx 8:0 000 secServe! 200 shiloh 490 2905" SALSEVEY 20057 YvuRon {0-0 a00@ = SalserveY reox Kabuas alo." 2010 SQrCevver 2008R2 — pF[Ruaqujavo (ro Qo)r SAL servev 20/2 Deval \2°0 Aol Sarsevver ROlY Seri. ¥ working wii SAL Serer: SQL Sewer > SAL Server ts a Collection ob paligares ilu 03 (pletion Or -<—] Dak bose ta Collection oedy cf object (nke Tables , ahh ggromges, UEeo8, prrcedens. ( Syronoas Fignety Foes - toys ey vows a ete in f so Traders 2k entormation pees Tages Lrdores 5st Sewer £5 abso Called as, pate bose. eurivorment cohare we Cam Creat Ola Backend Applicatron - > we Cou Create Manin Bra6F polabare, Under a stugle instance of s@Lservet~ > olan Loe pexbooren work on Sal Lerver we nest « tol fs Callest os “sems tom wolich wil be geb whan we qaslilld Sarsewey Softwor To the Sgstim- SSMS2 Zt ctiuds tor Sq Server Mouagewst Stadio wleck welll proutele too types ef euvrormend™ poke are 1s Cheaciy gared Environment (cuz) 2 Graphical pared Envivonweul” (GUL). COOD0OLZVO0000CL UUUU ES¢c aaanaAA: ial = =@s (0) (9) (@) @) > The above a euurtonmeuth ave ote to Pperborm Sous dobitarc operations bute Creaking. patalore obje Altving ttn pig objeus , droping te De objec, insert * date, Update data, olobtig data, cole ctig dat fron Ui De Tabs in server ewstron mint. > Ouce we cledeon ssmg tod Cicon) we gk a whulow ts Called 0s Conneck be Sener Adit Calaty ta Golloscinge opto" Thope are Sssms counect to Server Pa - 32. Server TYPE Ts aly x<83 5 3° Sewer Nome % CF sine o2z8 Authulicolion » [Te] gies reess Uses Nome + gaase _ eae pass word 5 53 Conmect} [tp | oftion b+ Server Gpes SQrSever Corts ta following. Services TipAR areServer Types T= rr DolaBoke Analysis Ceportang Tisteqration 2 Exgtoe Services services Services 5 CssAs) Csses) lsstS) 5 j as Desolopig 2 -pool =) U MSBI (microsoft Busines 5 a / Trtalltgenoe) : Devalopinn ao 5 BIOS (Businen Tribal gence Development studio) De TS a Cove Cowponsul of A Sql Servev wWLSch Cau be Oxy for steoing tea Lye amoundof- dob preening Eclat aud providing ta Seat ty the oborrniliBy corti Me, Server - . YVGOGOUG > In pateBase Ege TS Dale WIL oe Stored thU foxen ck AS Format Crit was collecttin b- Rows ave} climes > we Awaly sis Service 7- CSSAS) > xt ts of one d& tte MSBX Toot witch Ts ore ty Delioanhourig ewirenhet tot stovieg The ¢nbormaltn tn BD Format Graphical Lepreeutation %§ “ta Dalz)e a Reporting Service Css) in > sses ts a MSBE Tot lich wil) Ose te qeumrole ov Cebit tte Vantous tetol d-~ Dreamers such af ms-oovel , ms-Eiced , -pde filer, xml fils, . atepe Pele . —> Leper & Note but O documed witch fb. Urea to Shre Some burke Qelalid tobormalion of a partioulor oganigedin. a Integration Services CSSIS) > SSES us OSe to Converl from one Oabibare Tables into ou Cher DataBase urdeslivdable fryrmat- > For mowpk, SQL Sewer DeTable an Converting tnto Oral. 08 understandable. format: Ba@a@a (aaa aA: C 2. Server Nowe > Ta whitch sydiin or Madde we tnstalled s@r sewer Sobkimre Then The Syst ome wil ke as a Senvernlaue. for Goonesting th Det paleose Sewer: > Th cltet oud cener applicalted axe having utthin the Come plackiat tan Et we Gu ako Ut » (ox) Loalhost »O0000 as a Sener daue - ° anise NON a oan a - gpd Baraat Ne BO ; eee3 Authenticalion t- 3 Autheuttcation bs Notting bub +o vertty Ha Usex credimonoly Cuser tok, pamword) behore euler thty Server ewtreoments G (COO meen) > SOL Senev contin 2 tapes f- Oullentiealion mectes Those Oe ~ J+ Usindows Puttautication 2. SQL Sewer Autkentialtoo Woivdows AubkembcakON?— Dn windewt OullkenBeation we. wr Perbom"O usey Admindkaboy. When we Work witty windours Aubhatication There 28 mo reguared Ux User-td ancl partusotel Became Ware Td ome paswords aw. Creatiol by Te operating 53 System ty debault- 2 SAL Sever Autheubcation'- Sn Calserver Aullenls alter 5 We Work on Te Curret vgev. when we work uwxtlh s@Servey 5 Acthedtiattion ne should exter vsertd awl pastecord 5 Tree td aud parunrl ave credtad ly the User bth tunaf- 5 caLserver Sobfwmr gwrlallatpin. CAL mined mode option wll erctalling SQLServer Sebfure) + USe iy. Ae sey noes oes; Dy , > TE pebraithiardinawe of CarSewer ES Sa (sqsteea Adincn’ stabs “ Boag te a Ss: password : ee =) 5 Te wt Create by te user ab ta fame ob s@tserver installa tion- 3ANNNNNOAASA YOO 0000 steps t cometh to sar cervey: => Got AU programs > GotO microsoft sarerwer ZOly = Click On SQLsewer avity Mamopersit ideo option > Seleck tt server tape os patabare Exgta. ~ we Mee Servey name 05 Etter systzcnaue] @ | [bocathest 28 te Autkeratton etter windews or SeLServer PDutheub¥eation- 5 Th we lect wirdouss Authentication then there ts no ¥eeutre} verDd aud pomwod Sth we select car Server Aultinbicedtin then we Alould enter User Td - aud password 5 chek 09 Connect Bubton once we Connect ty SQ Server we well ge a window €5 nome aS object Explorer window: object expler- re ustll provide. Groplical vier Laker hace podlitea te the vier te perbern Some clalmbarr epevabions (eke Creatiig a new pilabaye , a news Table, inserting Te pal, poling Tha cate, celeting Ue dalx , Coleoking me dete from Tle Dalaba ty Seyver Enutronment. = obgect Explor’ Conlatus thc follewry option, those ave Delxbars, gecurtty, Cerver okfe Replica bon, pasacgonnbat eetc. EROK oR Shh Dra ate ena ns “ae ee merabad- rnentpeh FDalcbases; Sal Server Conlitng srootyper of dalrbars Bi Readers , dala poxes > oN 5 Systondebind — Seer lebiuad 2.) pabrboases Doliloayes, - ee 9 mts ° Mastey modal sdb Temp 5 10 -lo -2018, “salieedo >} Syslow, pabxBares - 5 > The dobeBare, are Menaged, aud modnbsin 1 opti cabal > These ove ( types oO bmastiy>y Tk will Stove AUl Systia level dabomatzon of oO SAL servers Hore Systiy Loud Inbormation 15 Noting bat systion OC configuration setting debit , all chelaRares, detalg, all uses clabiils,, Login defile aud abject cefatlr. ° o- TS view Conbiguectiin acta, : Sebel a-=Grom Sys Conbigures. * . SELECT # FROM SYSCONFIGURES ¢ b. To view Aut vabtlares Oefeils SELECT x From SYSDATABASES © 70 view aff users Details UUUGOUBVE~ Te view All Login oekssls SELECT &¥ FROM SYSLOGTINS e- 76 viud AU systim Oebtne object. C SELECT « FRom sySoBIECTs Fe model rs ct will wor asa Temple tor Creatyy Te Cy New DalaBotes tn Server Ervtvonment . Hg. MSdb >> at chick fo HitreLoft DalxBase okich ufll sto Alerts aud Rackup file tnbormation. cy Tempde > Te te a Temporoy Dabmbare Mowery eobitele aotll allocate by te oy stoun wolun the vier Connect ty SQL Server Dalnbare- Lb Tin Ts “Teunparory maven thao Sclion vol She rey Jaldes, views, procedures, fondtions, T~ once ths User Ofscennedtad tb Sau sener Dalaba Then Ar Cursors: user- Dehined DaltxBases :- > These ane Creed by tha User por storing Sous busine elated trbor malion NDRA XEROX 2 re exr Employee potash , SRI RACH es atre abe . ore Ayyagar " Department Deka , Bese OKC, ‘Balkampet Road, product cell, . Amearet, Hyderabae: —s Te User On welt He a Database by Using ay enutronmenty Those ove Delwutk Based Environment (cot) @ Craplital bared Enuirvorrmsat (Gur) ANNODONAND NOOO Te Temporary clatibare Mamory estll Le alestroyed Prukoneatically