mhandoChikoro Kudzidzisa
nguva5 Days
nyoresa

Taura nesu

Minda yakaiswa ne * zvinodiwa

 

Kutungamirira SQL Database Infrastructure

Kudzora SQL Database Zvidzidzo Zvekudzidzisa Dzidzo & Chiratidzo

tsananguro

Vateereri & Prerequisites

Course Outline

Purogiramu nemitengo

kutaura kuti ichokwadi

Kutungamira SQL Database Zvidzidzo Zvekudzidzisa Dzidzo

Iri rekudzidzisa vatungamiri vemazuva mashanu rinopa vadzidzi vanotungamirira nekuchengetedza SQL Server databases ne ruzivo uye unyanzvi hwokutungamirira SQL server database inoshandiswa. Zvakare, zvichava zvekushandisa kune vanhu vanogadzira zvinyorwa zvinopa zvinyorwa kubva kuSQL Server databases.

Zvinangwa zvekutungamira SQL Database Zvidzidzo zvekuvaka

  • Iva nechokwadi uye gamuchira vashandisi
  • Ita basa revhareji uye dheseji
  • Bvumidza vashandisi kuti vawane zviwanikwa
  • Chengetedza dheta nekukanda uye kuongorora
  • Rondedzera mhando dzekudzidzira uye maitiro ekuchengetedza
  • Backup SQL Server databases
  • Dzosera SQL Server databases
  • Automate database management
  • Saronga kuchengetedzwa kweSquL Server
  • Gadzira zvinyorwa uye zviziviso
  • Kutarisira SQL Server kushandisa PowerShell
  • Tsvaga kuwana SQL Server
  • Chengetedza SQL Server hupfumi
  • Troubleshoot a SQL Server infrastructure
  • Tumira uye tumira zvinhu zvese

Inzwi revateereri vekutungamirira SQL Database Infrastructure course

Vakuru vateereri veiyi ndiyo vanhu vanotungamirira nekuchengetedza SQL Server databases. Vanhu ava vanoita basa rekuchengetedza mabhuku uye kuchengetedza sevanonyanya kunzvimbo yekuita basa, kana kushanda mumamiriro ezvinhu Databases kutamba basa rinokosha mubasa ravo guru. Vateereri vechipiri chechidzidzo ichi vanhu vanogadzira zvinyorwa zvinopa zvinyorwa kubva kuSQL Server databases.

Nzira Yokubuda Nenguva Inguva: 5 Days

Module 1: SQL Server Security

Kudzivirirwa kwedhesi mukati meMicrosoft SQL Server databases kunokosha uye kunoda ruzivo rwebasa rezve nyaya uye SQL Server kuchengetedza zvinhu. Iyi moduku inotsanangura SQL Server kuchengetedza mhando, logins, vashandisi, zvishoma zvine databases, uye cross-server mvumo. Zvidzidzo

  • Kutsigisa Connections kune SQL Server
  • Kubvumira Logins kuChina kune databases
  • Chibvumirano Pamwe Chevhisi
  • Partially Contained Databases

Bhuku: Kutsigira Vashandi

  • Gadzira Logins
  • Gadzira Database Users
  • Kururamisa Kushanda Login Login Issues
  • Saronga kuchengeteka kwezvekudzivirirwa kweDatabases

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • SQL Server basic concepts.
  • SQL Server kuvimbiswa kwehutano.
  • User login mvumo kune zvinyorwa.
  • Partially contained databases.
  • Chibvumirano pane yeseva.

Module 2: Kupa Server uye Database Doro

Kushandisa nheyo kunowedzera kushandiswa kwemvumo yevashandi. Nebasa, unogona kudzora vashandisi vechokwadi kuti vasvike pane zvishandiso zvehurongwa zvinoenderana nebasa rega rega yevashandi-panzvimbo yekupa mvumo mushumiri-ne-user, iwe unogona kupa mvumo kune rimwe basa, zvino ita vashandisi nhengo dzebasa. Microsoft SQL Server inosanganisira rubatsiro rwekuchengetedzwa kwebasa rinotsanangurwa pazinga re server nepamusoro pezinga re database. Zvidzidzo

  • Kushanda neshevha dzebasa
  • Kushanda ne Fixed Database Roles
  • Kupa Dhiyabhorosi-Dhiyabhorosi Dhiyabhorosi Basa

Lab: Kupa seva uye dheseti dhesi

  • Kupa Server Roles
  • Kupa Dare Rakachengetedzwa Roro
  • Kupa Dhiyabhorosi-Dhiyabhorosi Dhiyabhorosi Basa
  • Kutsigira kuchengeteka

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Rondedzera uye shandisa mashizha ehurumende kuti uchengetedze server-level kuchengeteka.
  • Rondedzera uye shandisa dhiyabhorosi dhigirii.
  • Shandisa tsika dzekodzero dzebasa uye mabasa ekushandisa kuti uchengetedze nheyo yehutano-yepamusoro.

Module 3: Kubvumira Vashandi Kuwana Resources

Mune ma modules apfuura, waona kuti shanduro yeMicrosoft SQL Server yakarongeka sei uye mitsara yemvumo inogona kugoverwa pavhareji nepamusoro pezinga rekushandisa kuburikidza uchishandisa dhiyabhorosi dzebasa, mabasa akashandurwa sevavharesi, mabasa akachengetedzeka evhareji, uye mabasa ekushandisa. Nhanho yekupedzisira mukubvumira vashandisi kuwana SQL Server zvigadziro ndiyo mvumo yevashandi uye mabasa kuti vawane sese uye zvinhu zvepa database. Muchidzidzo ichi, uchaona kuti zvibvumirano izvi zvakagadzirirwa sei. Mukuwedzera kune mvumo yekuwana pane zvinhu zvepa database, SQL Server inopa mano ekutsanangura kuti vashandisi vanobvumirwa kuita code, zvakadai sekuchengetedzwa kwemitemo uye mabasa. Mune zviitiko zvizhinji, zvibvumirano izvi uye zvibvumirano pane zvinyorwa zvemashoko zvakanakisisa zvakagadziriswa pazinga rechima pane panzvimbo yehumwe chinhu. Schema-based grant permits inogona kuita kuti zvigadziriro zvenyu zvekuchengetedza zvive nyore. Iwe uchaongorora kubvumirwa kwemvumo kune imwe shirma muchidzidzo chekupedzisira chemu module. Zvidzidzo

  • Authorizing User Access to Objects
  • Kubvumira Vashandi Kuita Code
  • Kugadzira Zvimvumo paZvima Level

Lab: Kubvumira vashandi kuwana zvigadziriswa

  • Kupa, Kuda, uye Kubvumira Zvimvumo pazvinhu
  • Kupa KUDZIDZISA Mvumo pamutemo
  • Kupa Mvumo ku Schema Level

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Bvumidza kushandiswa kwevashandi kune zvinhu.
  • Bvumidza vashandisi kuti vaite code.
  • Gadzira mvumo kune imwe shirma.

Module 4: Kuchengetedza Dhiyabhorosi neKunyora Kuchengeta uye Kuongorora

Pakugadzirisa kuchengeteka kweMicrosoft SQL Server maitiro, unofanirwa kuve nechokwadi kuti unosangana nezvose zvekutevedza kwesangano rako kuchengetedza data. Masangano anowanzodikanwa kutevedzera mitemo-yepamutemo yekuteerera mitemo, iyo inotarisirwa kuongororwa kwehuwandu hwekuwana. Kuti igadzirise zvinodiwa izvi, SQL Server inopa huwandu hwezvingasarudzwa zvekushandisa kuongorora. Chimwe chinhu chinowanzodiwa chekuteerera ndeyekuvharidzirwa kwedheta kuchengetedza kusabvumirwa kusina mvumo muitiko apo kuwanika kune mafaira e database kunokanganisa. SQL Server inotsigira izvi zvinoda kuburikidza nekupa pachena zvakavanzika zvinyorwa (TDE). Kuti kuderedze njodzi yehuwandu hwemashoko kuburikidza nevashandisi vane hutungamiri hwehutungamiri kune database, mapurumoni ane data yakajeka-yakadai semakadhi emakadhi ekwereti kana nhamba dzese dzekuzivikanwa-inogona kunyorwa kuburikidza kushandiswa kweNyaya yeChirangaridzo. Iyi moduku inotsanangura maikirwo anowanikwa ekugadzirisa muSQL Server, mashandisiro ekushandisa uye nekutarisa SQL Server Audit feature, uye nzira yekutevedza zvinyorwa.

  • Sarudzo dzekuongorora dhidhiro dzekuwana muSQL Server
  • Kushandisa SQL Server Audit
  • Kutarisira SQL Server Audit
  • Kuchengetedza Data neKunyorwa Kwekunyora

Bhuku: Kushandisa Auditing uye Kuchengeta

  • Kushanda neSQL Server Audit
  • Chengetedza Column seNyaya Yakanyorwa
  • Encrypt a Database using TDE

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Rondedzera zvingasarudzwa zvekunyoresa kuwanikwa kwe data.
  • Shandisa SQL Server Audit.
  • Shandisa SQL Server Audit.
  • Rondedzera uye ushandise nzira dzekuvhara deta muSQL Server.
  • Shandisa kuvhara

Module 5: Kudzokorora Models uye Mazano Okuchengetedza

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

  • Kunzwisisa mazano ekuchengetedza
  • SQL Server Transaction Logs
  • Kugadzirisa Kuita Mazano

Bhi: Kunzwisisa SQL Server yekuwana mienzaniso

  • Rongedza hurongwa hwekuchengetedza
  • Saronga Database Recovery Models

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Tsanangura nzira dzakasiyana-siyana dzokuchengetedza.
  • Tsanangura kuti mabhigi ekutengesa mabhizinesi anoita sei.
  • Ronga zvirongwa zvekuchengetedza SQL Server.

Module 6: Kutsigira Up SQL Server Databases

Muchikamu chekutanga, wakadzidza kuronga nzira yekuchengetedza yeSQL Server system. Iwe zvino unokwanisa kudzidza kuti ungaita sei maScl Server mazvigadziro, kusanganisira zvizere zvakakwana uye zvakasiyana-siyana zvinyorwa zvekuchengetedza, zvinyorwa zvekutengesa mabhuku, uye zvigadziro zvishoma. Muchidzidzo ichi, iwe uchadzidza nzira yekushandisa maitiro akasiyana-siyana ekuchengetedza

  • Kutsigira Up Database uye Transaction Logs
  • Kutarisira Database Database Backups
  • Advanced Database Options

Bhuku: Kutsigira Up Databases

  • Kutsigira Up Databases
  • Kuita Database, Kusiyana, uye Transaction Log Backups
  • Kuita Bhuku Rakasiyana

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Ita zvigadziro zveSQL Server nhepfenyuro uye zvinyorwa zvekutengesa.
  • Shandisa mabhakkusi epa database.
  • Rondedzera zvakasarudzwa zvekuchengetedza zvisarudzo.

Module 7: Kudzorera SQL Server 2016 Databases

Muchikamu chepakutanga, wakadzidza kugadzira zvinyorwa zveMicrosoft SQL Server 2016 databases. Nzira yekuchengetedza inogona kusanganisira mhando dzakasiyana siyana dzekuchengetedza, saka zvinokosha kuti iwe unogona kubudirira kuzvidzorera. Iwe kazhinji uchadzorera dhesiyo mumamiriro ekukurumidzira. Iwe unofanirwa, zvisinei, iva nechokwadi chokuti une chirongwa chakajeka chekuti ungafamba sei uye kubudirira kugadzirisa dhesiro kune imwe nyika inoda kudiwa. Chirongwa chakanaka uye kunzwisisa kwekudzorera kunogona kubatsira kudzivisa kuita kuti mamiriro acho akawedzere. Rimwe rekodhi rezvekodhi rakadzorerwa rinowirirana nehurongwa hwekukundikana Muzviitiko izvi, iwe unoda kudzorera sangano iri pedo nepamunogona kuhurumende yaive iripo kusati kwasakundikana. Zvimwe kukundikana, kunyange zvakadaro, kwakabatana nekukanganisa kwevanhu uye iwe unogona kuda kupora hurongwa kune imwe nzvimbo isati yatadza. Nheyo-mu-nguva yekudzikinura zvinhu zveSQL Server 2016 inogona kukubatsira kuti uite izvi. Nemhaka yokuti ivo vanowanzova makuru, kushandiswa kwemashandisi ekushandisa kunowanzove kwakakanganiswa nekutadza kwehurongwa kudarika zvinyorwa zvemashoko. Zvisinei, hurongwa hwehuwandu hwemashoko hunogona kukanganiswa nekukundikana, uye kutarisirwa kwakananga kunofanira kutorwa kana uchidziwana. Kunyanya, iwe unoda kunzwisisa kuti ungawana sei imwe nhepfenyuro yehurongwa nokuti haugoni kushandisa nzira imwe chete yehutano hwemashoko ose. Muchidzidzo ichi, uchaona nzira yekudzorera kushandiswa kwemashandisirwo ehurumende uye maitiro uye nzira yekuita nayo pfungwa-in-time recovery. Zvidzidzo

  • Kunzwisisa Kudzorera Nzira
  • Kudzorera zvinyorwa
  • Yakafambiswa Kudzorera Zviratidzo
  • Point-in-Time Recovery

Lab: Kudzorera SQL Server Databases

  • Kudzorera Bhuku Rekuchengetedza
  • Restring Database, Kusiyana, uye Transaction Log Backups
  • Kuita Piecemeal Kudzorera

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Tsanangura kudzorera.
  • Dzosera databases.
  • Ita zvakadzama kudzorera mabasa.
  • Ita pfungwa-mu-nguva yekudzikinura.

Module 8: Kushandura SQL Server Management

Zvishandiso zvinopiwa neMicrosoft SQL Server zvinoita kuti hutungamiri huve nyore kana uchienzaniswa nedzimwe mhando dzemadhina. Zvisinei, kunyange kana mabasa ari nyore kuita, zvinowanzofanira kudzokorora basa kakawanda. Vanonyatsokwanisa vatungamiri vekudzidzira vanodzidza kugadzirisa kudzoka kwemabasa. Izvi zvinogona kubatsira kudzivisa mamiriro ezvinhu apo mutongi anokanganwa kuita basa panguva yakakodzera. Zvimwe zvinonyanya kukosha, kushandiswa kwemabasa kunobatsira kuchengetedza kuti vanoitwa nguva dzose, nguva imwe neimwe pavanourawa. Iri moduku rinotsanangura kuti ungashandisa sei SQL Server Agent kuti ushandise mabasa, kuti ungagadzirisa sei mamiriro ekuchengetedza emabasa, uye kuti ungaita sei multisver jobs. Zvidzidzo

  • Automating SQL Server management
  • Kushanda neSquL Server Agent
  • Kutarisira SQL Server Jobs Agent
  • Multi-server Management

Lab: Kushandura SQL Server Management

  • Gadzira SQL Server Agent Job
  • Edza Jobho
  • Rongedza Jobho
  • Gadzira maSeva aMadzidzisi uye Target

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Tsanangura nzira dzokugadzira SQL Server Management.
  • Gadzira mabasa, maitiro emabasa, uye zvirongwa.
  • Shandisa SQL Server Agent mabasa.
  • Rongedza mazano uye mazano mavhareji.

Module 9: Kugadzirisa kuchengetedzwa kweSquL Server Agent

Zvimwe ma modules munharaunda iyi zvakaratidza kudiwa kwekudzikisa zvibvumirano zvinopiwa kuvashandisi, kutevera mutemo we "kashoma ropafadzo." Izvi zvinoreva kuti vashandi vane chete zvibvumirano zvavanoda kuita mabasa avo. Pfungwa imwechete inoenderana nekubvumirwa kwemvumo kune SQL Server Agent. Kunyange zvazvo zviri nyore kuita mabasa ose mumamiriro ekushandiswa kweSquel Server Agent account, uye kugadzirisa iyo account sekodha yekutarisira, nzvimbo isina kuchengeteka yezvokuchengetedza inogona kuguma nekuita izvi. Zvakakosha kunzwisisa nzira yekugadzira nzvimbo shoma yekuchengetedzwa kwekodzero yemabasa ayo anoshanda muSQL Server Agent.Zvino

  • Kunzwisisa SQL Server Agent Security
  • Kugadzira Credentials
  • Kugadzira Proxy Accounts

Lab: Kugadzirisa kuchengetedzwa kweSquL Server Agent

  • Kuongorora Matambudziko muSQL Server Agent
  • Kugadzira Credential
  • Kugadzira Akaunti yePurogi
  • Kugadzirisa uye kuedza kuchengetedzwa kweKachengeteka kweJobho

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Tsanangura SQL Server Agent kuchengeteka.
  • Rongedza zvidzidzo.
  • Rongedza proxy maakaunti.

Module 10: Kutarisa SQL Server neZveruzhinji uye Notifications

Chimwe chinhu chinokosha chekutarisira Microsoft SQL Server nenzira yakagadzikana ndeyekuti uone kuti unoziva zvinetso nezviitiko zvinowanikwa muvhavha, sezvazvinenge zvichiitika. SQL Server mabhuku ane ruzivo rwehutano pamusoro pezvinhu. Iwe unokwanisa kugadzirisa iyo kuti ikukurudzire iwe pakarepo kana nyaya idzi dzikaitika, uchishandisa zvayenzi uye zviziviso. Nzira yakakurumbira iyo SQL Server database vatungamiri vanogamuchira tsanangudzo yezviitiko zvekufarira ndeyomutumwa we email. Iri gwaro rinosangana nekugadzirwa kweDatabase Mail, maziso, uye zviziviso zveSquL Server chitubu, uye sarudzo yezaziso zveMicrosoft Azure SQL Database. Zvidzidzo

  • Kuongorora SQL Server Mhosva
  • Kugadzira Database Database
  • Operators, Alerts, and Notifications
  • Alerts in Azure SQL Database

Lab: Kuongorora SQL Server neZverayenzi neZvaziso

  • Kugadzira Database Database
  • Kugadzira Operators
  • Kugadzira Alerts uye Notifications
  • Kuedza Nyevero Nemaziso

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Chengeta mapepa eSQL Server.
  • Gadzirai mail mail.
  • Gadzira vafambisi, maziso, uye zviziviso.
  • Shanda nemazita muAzure SQL Database.

Module 11: Nheyo yekutungamirira SQL Server nekushandisa PowerShell

Iyi moderi inotarisa kuti ungashandisa sei Windows PowerShell neMicrosoft SQL Server. Mabhizinesi anogara achiwedzera kuve nekugadzikana nekuvimbika kwekuchengetedza maitiro avo eI; uye PowerShell, unogona kuvandudza hutano hwakanaka uye kuvimbika kuburikidza nekugadzira zvinyorwa kuti uite mabasa. PowerShell zvinyorwa zvinogona kuongororwa uye kushandiswa kakawanda kune dzimwe sevhavha, kuchengetedza sangano rako zvose nguva nemari.Zvirevo

  • Kutanga ne Windows PowerShell
  • Saronga SQL Server uchishandisa PowerShell
  • Kutarisira uye kuchengetedza SQL Server ne PowerShell
  • Kugadzirisa Utsi SQL Databases dzinoshandisa PowerShell

Lab: Kushandisa PowerShell Kutarisira SQL Server

  • Kutanga neChina PowerShell
  • Kushandisa PowerShell Kuchinja SQL Server zvirongwa

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Rondedzera zvakabatsiro zvePowerShell nemafungiro aro.
  • Saronga SQL Server uchishandisa PowerShell.
  • Gadzirisa uye kuchengeta SQL Server kuburikidza uchishandisa PowerShell.
  • Shandisa an Azure SQL Database uchishandisa PowerShell.

Module 12: Kutarisa Kuwana SQL Server neZviitiko Zvakawedzerwa

Kuongorora kushanda kwemaseri kunopa nzira yakanaka yekuongorora kushanda kwese kwechinhu chekugadzirisa deta. Zvisinei, kune dzimwe nguva apo iwe unoda kuita tsanangudzo yakazara yebasa rinoitika mukati memuenzaniso weMicrosoft SQL Server-kutarisana nezvinetso uye kuziva nzira dzokugadzirisa basa rekuita basa. SQL Server Zviitiko Zvakawedzerwa iine mafaira, lightweight event-handling system yakagadzirwa muMicrosoft SQL Server Database Engine. Uyu mutsetse unotarisa pamusoro pezvigadzirwa zvekugadzira, matambudziko ekugadzirisa matambudziko uye zvinoshandiswa zvinoshandiswa zveZviitiko Zvakawedzerwa. Zvidzidzo

  • Zviitiko Zvakanyanyiswa Core Concepts
  • Kushanda Nezviitiko Zvakawedzerwa

Bhuku: Zviitiko Zvakawedzerwa

  • Achishandisa Sangano_Health Extended Events Session
  • Tsamba Yekutsvaga Tsamba Splits Zvichishandisa Zviitiko Zvakawedzerwa

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Rondedzera Zviitiko Zvakawedzerwa pfungwa huru.
  • Dza uye ugoita Zvimwe Zviitiko Zvimwe Zviitiko.

Module 13: Kuongorora SQL Server

Injini yeMicrosoft SQL Server Database inogona kufamba kwenguva yakareba pasina kudiwa kwekutarisira. Zvisinei, kana iwe nguva dzose uchicherechedza basa rinoitika pavhareji ye database, unogona kugadzirisa nyaya dzinogona kuitika vasati vasimuka. SQL Server inopa huwandu hwezvidzidzo zvaungashandisa kuongorora basa remazuva ano uye zvinyorwa zvezvinyorwa zvemabasa apfuura. Iwe unofanirwa kuziva kuti chii chimwe chezvishandiso zvinoita uye kuti ungashandise sei. Zviri nyore kukanganiswa nehuwandu hwehuwandu hwekuongorora zvigadzirwa zvinogona kupa, saka iwe unodawo kudzidza nzira dzekuongorora zvabuda.

  • Kuongorora basa
  • Kubata uye Kutarisa Dhigiri Dheyo
  • Kuongorora Kuchengetedzwa Kwekuita Data
  • SQL Server Utility

Lab: Kuongorora SQL Server

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Chengeta basa rezvino.
  • Tora uye ita basa rekushanda.
  • Ongorora kukohwa kwesekuita.
  • Saronga SQL Server Utility.

Module 14: Troubleshooting SQL Server

Vatungamiri veDatabase vanoshanda naMicrosoft SQL Server vanoda kubata basa rinokosha rekushungurudza matambudziko apo nyaya dzinomuka-kunyanya kana vashandisi vezvidzidzo zvebhizimisi vanovimba neSquL Server databases zviri kudziviswa kushanda. Zvakakosha kuva netsika yakasimba yekugadzirisa nyaya munharaunda yose, uye kuti uzive nenyaya dzinowanzoitika dzinogona kuitika pakushanda neSQL Server maitiro. Zvidzidzo

  • A Trouble Shooting Methodology kwaSQL Server
  • Kugadzirisa Matambudziko Akabatana Nebasa
  • Kugadzirisa Kukurukurirana uye Log-in issues

Bhuku: Zvinetso Zvokukurukura Zvimwe

  • Troubleshoot uye Sarudza SQL Login Issue
  • Troubleshoot uye Sarudza Sangano rebasa
  • Troubleshoot uye Resolve Windows Login Issue
  • Troubleshoot uye Kugadzirisa Dambudziko Rokuuraya Jobho
  • Troubleshoot uye Kugadzirisa Kuda Kwebasa

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Rondedzera nzira yekutambudza yeSQL Server.
  • Kugadzirisa nyaya dzine chokuita neshumiro.
  • Kugadzirisa kupindirana nekubatanidza nyaya.

Module 15: Kuisa uye Kudzingesa Dhiyabhorosi

Kunyange zvazvo deta yakawanda iri kugara muMicrosoft SQL Server system inopindurwa zvakananga nevashandisi vari kushandisa mapurogiramu ezvidzidzo, pane kazhinji kudiwa kutamisa data kune dzimwe nzvimbo, uye kubva kuSQL Server. SQL Server inopa seti yezvidzidzo zvaungashandisa kutumira dheta mukati nekunze. Zvimwe zvezvinhu izvi, zvakadai seBcp (Bulk Copy Program) uye SQL Server Integration Services, iri kunze kwejini injini. Zvimwe zvishandiso, zvakadai seshoko reBULK INSERT uye basa re OPENROWSET, rinoshandiswa mune injini ye database. Ne SQL Server, unogonawo kugadzira zvinyorwa-zvidzidzo zvekushandisa zvinotakura zvose tafura, maonero, nekuenzanisa zvinhu zvinosanganiswa nedhesi yevashandi mune imwechete yekutumira. Muchidzidzo ichi, uchaongorora zvishandiso izvi nemagadzirirwo kuitira kuti iwe unogona kutumira uye kutumira dhidha kune uye kubva kuSQL Server. Zvidzidzo

  • Kudzingisa Dhiyabhorosi kuenda uye kubva kuSQL Server
  • Kuisa uye Kubudisa Dhawende Data
  • Kushandisa bcp uye BULK INSERT kuIka Data
  • Kutumira uye Kuvandudza Data-Tier Application

Bhuku: Kuendesa nekutsvaga Dhidha

  • Tumira uye Excel Data uchishandisa Import Wizard
  • Tumira Mutengo Wakawandisa Mifananidzo Kushandisa bcp
  • Tumira Indaneti Mufaira Mifananidzo uchishandisa BULK INSERT
  • Dza uye Edza SSIS Package kuti Idonhedze Dheyo
  • Shandisa Data-Tier Application

Mushure mekunge mazadza iyi moduku, iwe uchakwanisa ku:

  • Rondedzera zvishandiso nemagadzirirwo ekutumira data.
  • Tumira uye kutumira patafura data.
  • Shandisa bcp uye BULK INSERT kuti inyore data.
  • Shandisai data-tier applications yekuisa uye kutumira zvidzidzo zvemashoko.

kuuya Events

Hapana zviitiko zvinouya panguva ino.

Ndapota nyorera kwatiri pane info@itstechschool.com & taura nesu pa + 91-9870480053 pamutengo wemari uye chechivimbiso, purogiramu & nzvimbo

Dhidzai Mhinduro

Kuti uwane mamwe mashoko nemutsa Taura nesu.


Reviews