ituaigaAoaoga a le potuaoga
taimiAso 5
Tusi Resitala

Taitaiina o se Infrastructure Database Database

Taitaiina o aʻoaʻoga faʻapitoa mo le faʻatinoina o faʻavaomalo ma faʻamaumauga

faʻamatalaga

Tagata o loʻo faʻalogo ma faʻamuamua

Taʻiala o le Vasega

Faamatalaga & Totogifuapauina

faʻamaoniga

Taitaiina o le Vasega o Aʻoaʻoga Faʻapitoa o Aseta a le SQL

O lenei aso lima-aʻoaʻoga e taʻitaʻia e le aʻoga, e tuʻuina atu ai i tamaiti o le vasega o loʻo faʻatino ma tausia faʻamaumauga faʻamaumauga a SQL Server ma le malamalama ma tomai e faʻatino ai Faʻamaumauga database o faʻamaumau SQL. E le gata i lea, o le a faʻaaogaina i tagata taʻitoʻatasi o loʻo atiinaʻeina talosaga e tuʻuina atu ai faʻamatalaga mai faʻamaumauga o SQL Server.

Sini o le Faʻasoaina o le SQL Database Infrastructure Training

  • Faʻamaoni ma faʻatagaina tagata faʻaoga
  • Tuʻuina se 'auʻaunaga ma faʻamaumauga faʻamaumauga
  • Faʻamaonia tagata e faʻaoga avanoa
  • Puipuia faʻamatalaga faʻatasi ai ma faʻamatalaga ma suʻega
  • Faamatala faʻataʻitaʻiga toe faʻaleleia ma faʻasologa o togafitiga
  • Tuatusi database o SQL Server
  • Faʻamaumauga database o SQL Server
  • Faʻamasino le puleaina o faʻamatalaga
  • Faʻasigoa le saogalemu mo le saini SQL Server
  • Pulea matala ma faʻamatalaga
  • Puleaina o le SQL Server e faʻaaoga ai le PowerShell
  • Suʻe avanoa i le SQL Server
  • Mataitu se atinaʻe SQL Server
  • Faʻasalaina se atinaʻe SQL Server
  • Faʻasalaga ma faʻatau atu faʻamatalaga

Tagata faʻalogo mo le faʻaleleia o le SQL Database Infrastructure

O le aufaʻatasiga autu mo lenei vasega o tagata taʻitoʻatasi o loʻo faʻatino ma tausia faʻamaumauga o SQL Server. O nei tagata taʻitoʻatasi latou te faʻatino le puleaina o faʻamaumauga ma le tausiga o latou vaega autu o le tiutetauave, poʻo le galue i siosiomaga pe a Nofoaga fa'amaumauga faia se sao taua i la latou galuega muamua. O le aufaʻasalalau lona lua mo lenei vasega, o tagata taʻitoʻatasi o loʻo atinaʻeina talosaga e tuʻuina atu ai faʻamatalaga mai faʻamaumauga o SQL Server.

Taʻiala o le Taimi Taimi: 5 Days

Module 1: Sosaiete Tūmau SQL

Puipuiga o faʻamaumauga i totonu o au database data Microsoft SQL Server e taua ma e manaʻomia ai se malamalamaʻaga galue i faʻasalalauga ma faʻamaoniga o le saogalemu o le SQL Server. O lenei vaega o loʻo faʻamatalaina ai faʻamaoniga o le saogalemu o le Server SQL, logins, users, vaega o faʻamaumauga, ma le faʻatagaina o faʻasalalauga. Lesona

  • Faʻamaoniaina Sootaga i le SQL Server
  • Faʻasalaga Lisi e Fesootai i luga o faʻamaumauga
  • Faʻatagaina I le isi itu o Servers
  • Nofoaga Faʻatino Faʻamaumauga

Lautusi: Faʻamaonia Tagata Faʻamaumauga

  • Fausia Fatuga
  • Fatufatu Tagata Faʻamaumauga
  • Faʻatoʻaina le Talosagaina o Talosaga Ulufale
  • Faʻasaʻo le Puipuiga mo Nofoaga Faʻamaumauga Toefuataiina

A maeʻa lenei faʻavae, o le a mafai ona e:

  • SQL Server autu faavae.
  • Faʻamaoniga faʻamaonia faʻamaonia SQL Server.
  • Faʻatagaina le faʻamaonia a le tagata i faʻamaumauga.
  • Faʻamatalaga tuʻufaʻatasia o faʻamaumauga.
  • Faatagaina i luga o le televise.

Faʻataʻitaʻiga 2: Faʻasoaina o le Tūmau ma Matafaioi a le Faʻamaumauga

O le faʻaaogaina o tiute e faʻafaigofieina ai le puleaina o faʻatagaga a tagata faʻaaoga. Faatasi ai ma matafaioi, e mafai ona e pulea le faʻamaoni o tagata faaaoga i punaoa faʻavae e faavae i luga o galuega a tagata taʻitoʻatasi-nai lo le atofaina o faʻatagaga tagata e faʻaaogaina, e mafai ona e faatagaina faʻatagaga i se matafaioi, ona faia lea o tagata e faʻaaogaina matafaioi. O le Microsoft SQL Server e aofia ai le lagolago mo faʻamatalaga malu puipuia ua faʻamautuina i le tulaga o le auʻaunaga ma le laʻasaga database. Lesona

  • Galulue faʻatasi ma galuega faʻaumau
  • Galulue ma Faʻamaumauga Faʻamaumauga Faʻamaumauga
  • Tofiaina o le Faʻamaumauga o Faʻamaumauga a le Tagata-Faʻamatala

Lautusi: Tuuina atu o le 'auʻaunaga ma faʻamaumauga faʻamaumauga

  • Tofiaina o Matafaioi Faʻatonu
  • Faʻatulagaina o Faʻamaumauga Faʻamaumauga Faʻamaumauga
  • Tofiaina o le Faʻamaumauga o Faʻamaumauga a le Tagata-Faʻamatala
  • Faamaonia o le Puipuiga

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faʻamatala ma faʻaaoga matafaioi tūmau e pulea ai le malupuipuia o le 'auʻaunaga.
  • Faʻamatala ma faʻaaoga tulaga faʻamaumauga database.
  • Faaaoga faʻamaumauga faʻamaumauga faʻasalalau masani ma matafaioi faʻaaoga e pulea ai le malupuipuia o faʻamaumauga.

Faʻataʻitaʻiga 3: Faʻatagaina Tagata e Faaaogaina i Avanoa Fesoasoani

I totonu o mamanu na muamua atu, ua e vaʻaia le faʻapipiʻiina o le saogalemu o Microsoft SQL Server ma le auala e mafai ai ona tuʻuina atu faʻasalaga i le 'auʻaunaga ma le database i le faʻaaogaina o tūmau faʻamaumau, matafaioi a le tagata e faʻamatalaina le tagata, tulaga faʻamaumauga tuʻufaʻatasia, ma le faʻatinoina o galuega. O le laasaga mulimuli i le faatagaina o tagata faaaoga e maua ai punaoa a le SQL Server o le faʻatagaina lea o tagata faʻapitoa ma matafaioi e maua ai le mea faigaluega ma mea faʻamaumauga. I lenei vaega, o le a e vaʻai pe faʻapefea ona pulea nei faatagaga. I le faaopoopo atu i faʻatagaga avanoa i luga o faʻamaumauga autu, o loʻo tuʻuina atu e le SQL Server le mafai e fuafua ai po o fea tagata faʻaaoga e faʻatagaina le faʻamaonia o code, e pei o faʻasologa ma faʻamaumauga. I le tele o tulaga, o nei faʻatagaga ma faʻatagaga i luga o mea o le database e sili ona lelei ona faʻasoa i le faatulagaga o le komepiuta nai lo le maualuga o le mea faitino. O faʻatagaga e faʻatagaina e le Scheme e mafai ona faʻafaigofieina ai lau faʻataʻitaʻiga saogalemu. O le ae suʻesuʻeina le tuʻuina atu o faʻatagaga i le tulaga o le polokalame i le lesona faaiu o lenei module.Lessons

  • Faʻatagaina le Tagata Avanoa i Avanoa
  • Faatagaina Tagata e Faaaogaina e Avea le Tulafono Laiti
  • Faʻasalalau Faʻatagaga i le Fua o le Faasologa

Lautusi: Faʻatagaina tagata e faʻaoga avanoa

  • Tuuina atu, Faʻatau, ma Faʻasalaga Faʻatagaga i luga o Aʻa
  • Tuuina atu o Faʻatagaga TULAGA FAʻAVAE i luga o Tulafono
  • Faʻatagaina o Faʻatagaga i le Fua Faʻatonu

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faʻatagaina le faʻaaogaina o tagata i mea faitino.
  • Faʻamaonia tagata e faʻapipiʻi le code.
  • Faʻasigoa faʻatagaga i le faatulagaga o le polokalame.

Module 4: Puipuia o Faʻamatalaga i Faʻasalaga ma Suʻetusi

Pe a faʻapipiʻi le malupuipuia mo lau polokalama Microsoft SQL Server, e tatau ona e mautinoa o loʻo e fetaui ma soʻo se mea e manaʻomia e le faʻapotopotoga mo le puipuiga o faʻamatalaga. E masani ona manaʻomia e faʻalapotopotoga le tausisia o faiga faʻavae o le tausisia o pisinisi, lea e faʻamautinoa ai le suʻeina o faʻamatalaga uma. Ina ia faʻatalanoaina lenei manaʻoga, e tuʻuina atu e le SQL Server le tele o filifiliga mo le faʻatinoina o le sueina o suʻega. O le isi manaoga masani e tausisia o le faʻamalamalamaina lea o faʻamatalaga e puipuia ai mai avanoa e le faʻatagaina pe afai o le avanoa i faila o faʻamaumauga o fesoʻotaiga e faʻasalalau. E lagolagoina e le SQL Server lenei manaoga e ala i le tuʻuina atu o faʻamatalaga manino faʻamatalaga (TDE). Ina ia faʻaitiitia le ono lamatiaina o faʻamatalaga faʻamatalaga e tagata e faʻaaogaina le pulega i se nofoaga faʻamaumauga, o koluma e aofia ai faʻamatalaga maʻaleʻale-e pei o numera o le kaini aitalafu poʻo numera o faʻamatalaga o le atunuʻu-e mafai ona faʻailogaina e faʻaaoga ai le uiga Faʻasalaga Uma. O lenei vaega o loʻo faamatalaina ai avanoa avanoa mo le suʻega i le SQL Server, le auala e faʻaaoga ai ma pulea le faʻatulagaina o le Suʻega a le SQL Server, ma le auala e faʻaogaina ai le faʻailoga .Lessons

  • Filifiliga mo le suʻeina o faʻamatalaga i totonu o le SQL Server
  • Faʻatinoina o le suʻeina o suʻega SQL
  • Puleaina o Suʻega Faʻatonu a le SQL
  • Puipuia o Faʻamatalaga i Faʻasalaga

Lautusi: Faʻaaogaina o Suʻega ma Faʻasalaga

  • Galulue faʻatasi ma le Suʻega a le SQL Server
  • Faʻasalaina se Faʻasologa e Pei Ona Taofia Tonu
  • Faʻamaonia se Database e faʻaaoga ai le TDE

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faamatala avanoa mo le suʻeina o faʻamatalaga.
  • Faʻaauau le Suʻeina o Suʻega SQL.
  • Pulea le Suʻeina o Suʻega Faʻamaumau.
  • Faʻamatala ma faʻaogaina metotia o le faʻamaonia o faʻamaumauga i le SQL Server.
  • Faʻaaoga faʻamalamalamaga

Faʻaaogaina 5: Faʻataʻitaʻiga Toe Faʻaleleia ma Laasaga Faʻavae

O se tasi o itu sili ona taua o le matafaioi a le pule o le database o le faamautinoaina lea o le faʻamautuina o faʻamatalaga faʻatulagaga e mafai ona faʻalagolago i luga ina ia, pe a fai o se toilalo e tupu, e mafai ona e toe maua mai le faʻamaumauga. E ui lava ua iloa e le aufaipisinisi e uiga i le manaʻomia o ni tulaga faʻalagolago mo le tele o tausaga-ma talanoaina lenei mea i taimi e tele-le fiafia e uiga i le leiloloa o faʻamaumauga e masani lava ona masani. O le isi faʻafitauli o le, tusa lava pe faʻaaogaina fuafuaga i totonu o le nofoaga e pei ona fuafuaina, o le taunuuga e masani lava ona le mafai ona ausia manaoga o le faʻalapotopotoga. I lenei vaega, o le ae mafaufau pe faʻapefea ona fatuina se fuafuaga e fetaui ma manaoga o faʻalapotopotoga, e faʻavae i luga o faʻataʻitaʻiga faʻasoasoa, ma le matafaioi o le faʻatautaia o ogalaau i le tausia o le faʻamaumauga o faʻamaumauga.

  • Malamalama i Lagolago Toe Faʻaleleia
  • Faʻamaumauga o Fesoʻotaʻiga SQL Server
  • Fuafuaga o le Toe Faʻaleleia

Lab: Malamalama i faʻataʻitaʻiga o le toe faʻaleleia o le SQL Server

  • Fuafua se Taiala Faʻavae
  • Faʻasaʻo Faʻamaumauga o Faʻamaumauga o le Database

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faʻamatala faʻataʻitaʻiga eseese.
  • Faʻamatala pe faʻapefea ona faʻaogaina le faʻaogaina o lola faʻamaumauga.
  • Fuafua Fuafuaga Faʻatonu a Sāmoa Tūmau.

Faʻataʻitaʻiga 6: Faʻatoʻaina o Faʻamatalaga Faʻatonu a le SQL Server

I le iunite muamua, na e aʻoaʻo ai pe faʻapefea ona fuafua se fuafuaga mo le faʻamaumauga mo se polokalama SQL Server. E mafai nei ona e aʻoaʻo pe faʻapefea ona e faʻatinoina faʻamaumauga a le SQL Server, e aofia ai faʻamaumauga o faʻamaumauga, faʻamaumauga o faʻamaumauga faʻasalalauga, ma faʻamaumauga ole vaega. I lenei vaega, o le ae iloa ai pe faʻapefea ona faʻaaogaina le tele o auala faʻapitoa

  • Faʻailogaina o Faʻamatalaga ma Lisi Faʻatino
  • Puleaina o Backups Database
  • Maualuga Faʻamatalaga Filifilia

Lautusi: Faʻatoʻaina o Faʻamaumauga

  • Tuʻuina o Faʻamaumauga
  • Faatinoina o Nofoaga Faʻamaumauga, Faʻasalalau, ma Faʻasalalauga Faʻasalalauga
  • Faia se Suiga Faʻasalalau

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faia ni faʻamaumauga o faʻamaumauga o SQL Server ma fefaʻatauaʻiga.
  • Puleaina faʻamaumauga faʻamaumauga.
  • Faʻamatala faʻasologa o filifiliga faʻapitoa.

Modu 7: Toe faʻafouina o Faʻamaumauga SQL 2016 Server

I le iunite muamua, na e aʻoaʻo ai pe faʻapefea ona fai ni kopi o faʻamaumauga o Microsoft SQL Server 2016. E mafai ona aofia ai se fuafuaga mo le tausiga o le tele o ituaiga eseese o faʻamaumauga, o lea e taua ai e mafai ona e faʻafoisia lelei. E masani ona e toe faʻaleleia se faʻamaumauga i se tulaga faanatinati. Ae ui i lea, e tatau ona e mautinoa o loʻo ia te oe se fuafuaga manino o auala e faʻaauau ai ma toe manuia le toe maua o le faʻamaumauga i le tulaga manaomia. O se fuafuaga lelei ma le malamalama i le toe faʻaleleia o le faagasologa e mafai ona fesoasoani e aloese mai le leaga o le tulaga. O nisi faʻamatalaga tuʻufaʻatasiga e fesoʻotaʻi ma le faaletonu o le polokalama I nei tulaga, o le ae manao e toe faʻafoʻi le faiga i le latalata i le setete na i ai ao le i faia le toilalo. O nisi o toilalo, e ui i lea, e fesootaʻi atu i mea sese a tagata ma atonu e te manaʻo e toe faʻaleleia le faiga i se pito i luma o lena mea sese. E mafai ona fesoasoani ia te oe le ausia o lenei mea ile tulaga o le toe faʻafouina o le SQL Server 2016. Talu ai ona e sili atu le telē tele, o faʻamaumauga a le au faʻaoga e sili atu ona aʻafia i faʻaletonu o le system nai lo faʻamaumauga o faʻamaumauga. Ae ui i lea, e mafai ona aafia faʻamaumauga o faʻamaumauga i faʻaletonu, ma e tatau ona faʻaeteete faapitoa pe a toe faʻafouina. Aemaise lava, e tatau ona e malamalama i le auala e toe faʻaleleia ai le 'auʻaunaga tuʻufaʻatasiga taʻitasi aua e le mafai ona e faʻaogaina le faiga lava e tasi mo faʻamaumauga uma. I totonu o lenei atulaulau, o le a e vaʻai i le auala e toe faʻafoʻisia ai faʻamaumauga o tagata e faʻaaogaina ma faʻalapotopotoga ma le auala e faʻaaogaina ai le toe faʻaleleia o le taimi. Lesona

  • Malamalama i le Toefuataiga o Taualumaga
  • Faʻamaumauga o Faʻamaumauga
  • Avanoa Faʻaleleia Faʻalelei
  • Faʻasologa o le Faʻailoga

Lautusi: Toe faʻafoʻiina o Faʻamaumauga Faʻamaumau SQL

  • Faʻafoʻisia se Faʻamaumauga Faʻamaumauga
  • Toe faʻafoʻoina o Nofoaga Faʻamaumauga, Faʻasalalau, ma Faʻasalalauga Faʻasalalauga Galuega
  • Faʻaalia o se Toe Faʻafoʻiina o se Fale

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faamalamalama le toe faʻaleleia o le faagasologa.
  • Faʻamaumauga o faʻamaumauga.
  • Faʻaalia galuega toe faʻafouina.
  • Faʻatino le toe faʻaleleia o le taimi.

Modu 8: Faʻateʻaina le Faʻatonuina o Tūlaga SQL

O meafaigaluega na tuʻuina atu e le Microsoft SQL Server e faʻafaigofie ai le pulega pe a faʻatusatusa atu i isi masini komepiuta. Peitai, e tusa lava pe faigofie galuega, e masani ona toe fai se galuega i le tele o taimi. Faʻatautaia o pulega faʻamaumauga o faʻamaumauga e aʻoaʻo ai e faʻaaoga galuega toe fai. E mafai ona fesoasoani lenei mea e aloese mai tulaga e galo ai se pule e faia se galuega i le taimi manaomia. Atonu o le mea e sili atu ona taua, o le masini o galuega e fesoasoani e faʻamautinoa ai o loʻo faia i taimi uma, i taimi uma e fasiotia ai. O lenei vaega o loʻo faʻamatalaina le faʻaogaina o le SQL Server Agent e faʻatinoina ai galuega, auala e faʻapipiʻi ai siosiomaga saogalemu mo galuega, ma pe faapefea ona faʻaaoga galuega multiserver. Lesona

  • Faʻamuta le puleaina o SQL Server
  • Galulue ma le Faʻatonu Setema SQL
  • Puleaina o Galuega Faʻatonu a le Tūmau SQL Server
  • Faʻateleina le puleaina

Lautusi: Faʻamuta le Faʻatonuina o Tūlaga SQL

  • Fausia se Sosaiete Tūmau SQL Iopu
  • Suʻe se Iopu
  • Faʻamatala se Iopu
  • Faʻasaga le Matai ma Faʻatonu Sini

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faʻamatala auala mo le faʻaaogaina o le Faʻatonuga o Tūmau SQL.
  • Faʻasalaga galuega, ituaiga galuega, ma faʻatulagaga.
  • Puleaina galuega a le Agent SQL Server.
  • Faʻatonu faʻauluuluga ma faʻalauiloa ūtusi.

Faʻataʻitaʻiga 9: Faʻasalalau le Puipuiga mo le Faʻatonu Setema SQL

O isi modula i lenei vasega ua faʻaalia ai le manaʻoga e faʻaitiitia le faʻatagaina ua tuʻuina atu i tagata faʻapitoa, mulimuli i le mataupu o le "leai se avanoa." O lona uiga e na o faʻatagaga latou te manaʻomia e fai ai a latou galuega. O le manatu lava lea e tasi e faatatau i le faʻatagaina o faʻatagaga i le Agelu Tūmau SQL. E ui lava e faigofie le faʻatinoina o galuega uma i le faʻamatalaga o le faʻamaumauga a le SQL Server Agent service, ma le faʻamautuina o lena tala o se faʻamatalaga tau pulega, o le a oʻo mai se tulaga saogalemu le siosiomaga i le faia o lenei mea. E taua le malamalama pe faʻapefea ona fatuina se siʻosiʻomaga mo le saogalemu o avanoa mo galuega e taʻavale i le SQL Server Agent.Lessons

  • Malamalama i le Security Agent Security
  • Faʻasagaina o Aʻoaʻoga
  • Faʻasaʻoina o Faʻamatalaga Faatulaga

Lautusi: Faʻasalalau le Puipuiga mo le Faʻatonu Setema SQL

  • Iloiloga o Faʻafitauli i le Faʻatonu Setema SQL
  • Faʻasoaina o se Faʻatagaga
  • Faʻasaʻoina o se Faʻataʻitaʻiga Suʻega
  • Faʻasalalau ma suʻe le Sosaiete Puipuiga o se Iopu

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faʻamatala le saogalemu o Agent Server.
  • Faʻatonu faʻamaonia.
  • Faʻasaʻo faʻamatalaga sui.

Module 10: Mataʻituina o le SQL Server ma Alert ma Faʻamatalaga

O se tasi o vaega autu o le puleaina o Microsoft SQL Server i se auala faʻamalosi o le mautinoa o loʻo e nofouta i faafitauli ma mea tutupu e tutupu i totonu o le upega tafaʻilagi, aʻo latou tutupu. Faʻamaumau e le SQL Server se tamaoaiga o faʻamatalaga e uiga i mataupu. E mafai ona e faʻapipiʻiina e fautuaina oe i se taimi otometi pe a tulaʻi mai nei faafitauli, e ala i le faʻaaogaina o matala ma faʻamatalaga. O le auala sili ona taatele e maua e faʻamaumauga o faʻamaumauga o SQL Server auiliiliga o mea e fiafia i ai o le i-meli. O lenei vaega e aofia ai le faʻatulagaga o le Mail Database, matala, ma faʻamatalaga mo se faʻataʻitaʻiga SQL Server, ma le faʻatulagaga o matala mo le Microsoft Azure SQL Database. Lesona

  • Mataʻituina o Faʻasologa Tapa o SQL
  • Faʻasaʻoina o le Meli Meli
  • Faʻatonuga, Aleki, ma Faʻamatalaga
  • Alerts i Azure SQL Database

Lisi: Mataʻituina o le SQL Server ma Alert ma Faʻamatalaga

  • Faʻasaʻoina o le Meli Meli
  • Faʻasagaina o Faʻatonu
  • Faʻasalalau Alert ma Faʻamatalaga
  • Alerts Test ma Faʻamatalaga

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Mataitu mea sese a le SQL Server.
  • Faʻasaʻo le meli o le komepiuta.
  • Faʻasalalauga faʻamaonia, faʻasalalauga, ma faʻamatalaga.
  • Galue ma faʻamalo i le Azure SQL database.

Module 11: Faʻatomuaga i le puleaina o le SQL Server e ala i le faʻaaogaina o le PowerShell

O lenei elemene e vaʻavaʻai pe faʻapefea ona faʻaaoga le Windows PowerShell ma le Microsoft SQL Server. O pisinisi o loʻo faʻaauau pea le faʻaleleia ma le faʻamaoni o le tausia o latou gaosiga faʻapitoa; ma le PowerShell, e mafai ona e faʻaleleia lenei lelei ma le faʻamaoni e ala i le fatuina o ni tusitusiga e faʻatino galuega. E mafai ona tofotofoina ma faʻaaogaina i le tele o taimi ni faʻamaumauga o le PowerShell, i le tele o taimi, ma faʻasaoina ai lau faʻapotopotoga i taimi uma ma tupe.Lessons

  • Amataina i le Windows PowerShell
  • Faʻasaʻo le SQL Server e faʻaaoga ai le PowerShell
  • Faaulu ma Tausia le Server SQL i le PowerShell
  • Pulea Azure SQL Database e faʻaaoga ai le PowerShell

Lautusi: Faʻaaogaina o le PowerShell e Pulea ai le Faʻatonu SQL

  • Amataina i le PowerShell
  • Faʻaaogaina o le PowerShell e Suia ai Tūlaga SQL Tūmau

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faamatala mai aoga o le PowerShell ma ona manatu faavae.
  • Faʻatulagaina le Tūmau SQL e ala i le faʻaaogaina o le PowerShell.
  • Faʻatonu ma tausia le Tūmau SQL e ala i le faʻaaogaina o le PowerShell.
  • Puleaina le Database Database Azure i le faʻaaogaina o le PowerShell.

Faʻataʻitaʻiga 12: Faʻataʻitaʻiina o le Access i le SQL Server ma Faʻalautele mea tutupu

Mataʻituina o metotia faʻatinoga o loʻo maua ai se auala sili e iloilo ai le tulaga atoa o le faʻaogaina o se faʻamaumauga tuʻufaʻatasiga. Ae ui i lea, ei ai taimi e manaʻomia ai le faʻatinoina o auiliiliga auiliili o le gaoioiga o loʻo tutupu i totonu o se faʻataʻitaʻiga Microsoft SQL Server-e foia ai faafitauli ma iloa auala e faʻamalosia ai galuega faʻatino galuega. O Faʻasalalauga Faʻasalalau Faʻamaumau SQL o se fetuutuunaiga faʻapitoa, faʻapipiʻiina le faʻaleleia o le tino ua fausia i le Microsoft SQL Server Database Engine. O lenei laupepa e taulaʻi i luga o faʻataʻitaʻiga o faʻataʻitaʻiga, faʻavasegaina o taʻiala ma faʻataʻitaʻiga o faʻataʻitaʻiga o Mea Faʻatupulaia. Lesona

  • Faʻatinoga Faʻatinoga Manatu Autu
  • Galulue Faatasi ma Mea Faʻatino

Lautusi: Faʻasalalau Faʻatupulaia

  • Faaaogaina o le Fonotaga a le System_Health Faʻasalalau
  • Faʻasalalau Faʻasologa o Itulau Faʻatino Mea Faʻaopoopo

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faʻamatala faʻamatalaga faʻateleina o mea taua.
  • Faʻatino ma fesiligia Faʻasalalauga Faʻasalalau.

Module 13: Mataituina o le SQL Server

O le Microsoft SQL Server Database Engine e mafai ona tamoe mo ni taimi uumi e aunoa ma le manaʻomia mo le tausiga o le pulega. Ae peitaʻi, afai e te siaki i taimi uma le gaoioiga o loʻo tupu i luga o le 'auʻaunaga tuʻufaʻamatalaga, e mafai ona e taulimaina mataupu ono tulaʻi mai ae leʻi tulaʻi. O le SQL Server e maua ai le tele o meafaigaluega e mafai ona e faʻaogaina e mataituina ai le taimi nei ma faʻamaumauga faʻamaumauga o gaoioiga muamua. E tatau ona e faamasani i mea o meafaigaluega uma e fai ma auala e faaaoga ai. E faigofie lava ona lofituina e le tele o mea e mafai ona maua e meafaigaluega e mataituina, o lea e tatau ai foi ona e aoaoina ni metotia mo le auiliiliina oa latou galuega.

  • Mataituina gaoioiga
  • Fausia ma le Puleaina o Faʻamatalaga o Galuega
  • Iloiloina o le Aoina o Faʻamaumauga o Faʻamaumauga
  • Sosaiete Tūmau SQL

Lisi: Mataʻituina o le SQL Server

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Mataitu le gaoioiga oi ai nei.
  • Pueina ma pulea faamatalaga o faʻatinoga.
  • Iloilo faamaumauga na faʻatinoina.
  • Faʻasaʻo le Faʻaaogaina o le Server SQL.

Modu 14: Faʻasalalau Taʻutuʻu SQL

O tagata faʻapipiʻi faʻamaumauga o loʻo galulue faʻatasi ma Microsoft SQL Server e tatau ona faʻaaogaina le taua o le matafaioi o le fofo pe'ā tulaʻi mai faafitauli - aemaise lava pe a taofia tagata e faʻaaogaina pisinisi faʻapitoa e faʻatau i luga o faʻamaumauga o SQL Server mai le galue. E taua le i ai o se auala mautu mo le foia o mataupu lautele, ma faamasani i mataupu sili ona taatele e mafai ona tulai mai pe a galue i le faiga o SQL Server. Lesona

  • O se Faʻasologa o le Faʻaleleia o Faʻafitauli mo le Tūmau SQL
  • Faʻavaeina Auaunaga Fefaʻatauaʻiga Faʻatatau
  • Faʻavaeina Fesoʻotaʻiga ma Faʻailoga i totonu

Lab: Faʻasalalau Mataupu Masani

  • Faʻafitauli ma Faʻasaʻo se Faʻasinomaga Faʻasao SQL
  • Faʻafitauli ma Faʻafoe se Faʻamatalaga o Auaunaga
  • Faʻafitauli ma Faʻasaʻo se Lisi Faʻamatalaga i le Initaneti
  • Faʻafitauli ma Faʻafoe se Suiga o Suiga Iopu
  • Faʻafitauli ma Faʻafoe se Faʻamatalaga o Galuega

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faʻamatala se faʻafitauli faʻafitauli mo le SQL Server.
  • Faʻafoe mataupu tau fesoʻotaiga.
  • Faʻasalaga faʻasalaga ma fesoʻotaiga.

Faʻafanua 15: Faʻasalaga ma Faʻasalalau Faʻamatalaga

E ui o le tele o faʻamatalaga o loʻo nofo i totonu o se polokalama Microsoft SQL Server na ulufale saʻo mai e tagata faʻapipiʻi o loʻo faʻatino polokalama polokalama, e tele lava ina manaʻomia le siitia o faʻamaumauga i isi nofoaga, i ma mai le SQL Server. E tuʻuina atu e le SQL Server se seti o meafaigaluega e mafai ona e faʻaaoga e fesiitai ai faʻamatalaga i totonu ma fafo. O nisi o nei meafaigaluega, e pei o le Pc Cop (Bulk Copy Program) ma le SQL Server Integration Services, o fafo atu i le masini komepiuta. O isi meafaigaluega, e pei o le BULK INSERT faʻamatalaga ma le OPENROWSET, o loʻo faʻatinoina i le masini komepiuta. Faʻatasi ai ma le SQL Server, e mafai foi ona e fatuina mea e faaaoga ai le data-tier e faʻapipiʻi uma ai laulau, manatu, ma mea faʻapitoa e fesoʻotai ma se faʻamaumauga tuʻufaʻatasiga i se iunite tasi o le faʻapipiʻiina. I lenei vaega, o le ae suʻeina nei meafaigaluega ma auala ina ia mafai ai ona e faaulufale mai ma auina atu faʻamatalaga i ma mai le SQL Server. Lesona

  • Tuuina atu o Faʻamatalaga i ma mai le SQL Server
  • Faʻaulufale mai ma Faʻasalalau Faʻamaumauga o Ata
  • Faaaogaina o le Bcp ma le BULK INERTERT i le Faaulufaleina o Faʻamatalaga
  • Faʻaleleia ma le faʻaleleia o faʻamatalaga o faʻamaumauga

Lautusi: Faʻasalaga ma Faʻatau atu Faʻamatalaga

  • Faʻasalalau ma Excel Data Faʻaaogaina le Wizard o Faʻaulufale mai
  • Faʻasalaga atu i le Faʻasalalau Faʻamaumauga Faʻamatalaga Faʻaaogaina le
  • Faʻaliliu atu se Failautusi Faʻasalalau e faʻaaoga ai le BULK INSERT
  • Fausia ma Suʻe se SSIS Package e Faʻasaʻo Faʻamaumauga
  • Faʻapipiʻiina o se Faʻamatalaga o Faʻamatalaga-Tier

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faamatala meafaigaluega ma auala mo le fesiitaiga o faamatalaga.
  • Faʻamaumauga o laulau ma faʻatau atu i fafo.
  • Faʻaaoga le Bcp ma le BULK INERTERT e faʻaulu mai ai faʻamatalaga.
  • Faʻaaogā faʻamatalaga faʻamatalaga i luga o faʻamatalaga e faʻapipiʻi ma faʻatau atu ai faʻamatalaga faʻapipiʻi.

Aʻoaʻoga Faʻaauau

E leai ni mea tutupu i le taimi nei.

Faamolemole tusi mai ia i matou i le info@itstechschool.com & faʻafesoʻotaʻi i matou i le 91-9870480053 mo le tau aʻoaʻoga & tusi tau tusi, faʻasologa ma le nofoaga

Tuʻu mai ia i matou se Fesili

Mo nisi faʻamatalaga agalelei Faafesootai matou.


iloiloga