Faʻamatalaga Faʻamatalaga ma Faʻatino-SQL

Faʻasalalau Faʻamatalaga ma Faʻamaumauga Faʻamaumauga Faʻatonu a le Transact SQL & Tusi Faamaonia

faʻamatalaga

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

Taʻiala o le Vasega

Faamatalaga & Totogifuapauina

faʻamaoniga

Faʻasalalau Faʻamatalaga ma Faʻasalalauga Vaʻaia a Transact SQL

O lenei vasega ua mamanuina e faʻalauiloa ai tamaiti aoga i le Transact-SQL. E mamanuina i se auala e mafai ona aʻoaʻoina ai aso muamua e tolu o se vasega i tamaiti aoga e manaʻomia le malamalama mo isi vasega i le Tūmau SQL mataupu aoaoina. Aso 4 & 5 aʻoaʻo atu tomai manaʻomia e ave suʻega 70-761.

Sini o le Suʻeina o Faʻamatalaga ma Faʻamaumauga a le SQL Transact

  • Faʻamatala uiga gafatia ma vaega o le SQL Server 2016.
  • Faʻamatala le T-SQL, seti, ma le faʻamatalaga faʻavae.
  • Tusi se laulau se tasi SELECT faamatalaga.
  • Tusi se faʻamatalaga SELECT e tele laulau.
  • Tusi FILIFILIA faʻamatalaga i le fesuiaiga ma le fesuiaiga.
  • Faʻamatala pe faʻapefea ona faʻaaogaina e le Sosa SQL ia ituaiga faʻamaumauga
  • Tusi ia faʻamatalaga DML.
  • Tusi fesili e faʻaaoga ai galuega fai.
  • Tusi fesili e tuufaatasia ai faʻamatalaga.
  • Tusi tusitusi.
  • Fausia ma faʻatino vaaiga ma laulau-faʻatatau galuega.
  • Faʻaaoga faʻapipiʻi tuʻufaʻatasia e faʻapotopoto ai fesili fesili.
  • Tusi fesili e faʻaaoga ai le mamalu o le fenumiai, faʻasalaga, ma galuega faʻatasia.
  • Faʻaliliuina faʻamatalaga e ala i le faʻaaogaina o mea taua, faʻaogaina, lisiina ma le fagu.
  • Fatuina ma faʻaaogaina faʻamaumauga.
  • Faʻaopoopo faʻalauiloa polokalame e pei o fesuiaiga, tulaga, ma faʻaopoopoga i le T-SQL code.

Aufaʻatau mo le Manulauti mo Manulauti o Faʻamatalaga Faʻamatalaga ma Faʻatauga - SQL

O le autu autu o le kosi o le tuʻuina atu lea i tamaiti o le vasega se malamalamaaga lelei i le gagana Transact-SQL lea e faʻaaoga e faʻaupuga uma a le SQL Server; ua taua, Database Administration, Atinaʻeina o Faʻamatalaga ma Faʻamatalaga Tau Pisinisi. I lea tulaga, o le aufaʻatasiga muamua mo lenei vasega, o le: Faʻatonuina o Faʻamaumauga o Faʻamaumauga, Atinaʻeina Faʻamatalaga ma Faʻatonu a le BI.

Taʻiala o le Taimi Taimi: 5 Days

Faʻavae 1: Folasaga i le Microsoft SQL Server 2016

O lenei module e faʻalauiloa ai le SQL Server, o faʻaliliuga o le SQL Server, e aofia ai le gagana, ma le faʻafefea ona fesoʻotaʻi atu i le SQL Server e faʻaaoga ai le SQL Server Management Studio.Lessons

  • O le Faʻatulagaga Autu o le SQL Server
  • SQL Server Editions ma Fuaiupu
  • Amataina i le SQL Server Management Studio

Lautusi: Galulue faʻatasi ma le SQL Server 2016 Tools

  • Galulue faʻatasi ma le SQL Server Management Studio
  • Fausia ma le Faʻatulagaina o T-SQL Scripts
  • Faaaogaina o Tusi Online

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

  • Faamatala faʻamatalaga fesoʻotaʻiga ma fesili a le Transact-SQL.
  • Faʻamatala i luga o fale ma fale faʻavae ma faʻavae o le SQL Server.
  • Faʻamatala pe faʻapefea ona faʻaaoga le SQL Server Management Studio (SSMS) e faʻafesoʻotaʻi ai i se taimi o le SQL Server, suʻesuʻe faʻamaumauga o loʻo i ai i le tulaga, ma galue i faila faila e aofia ai fesili a le T-SQL.

Module 2: Folasaga i le T-SQL Querying

O lenei module o loʻo faʻamatalaina elemene o le T-SQL ma a latou matafaioi i le tusiaina o fesili. Faamatala le faʻaaogaina o seti i le SQL Server. Faʻamatala le faʻaaogaina o faʻamatalaga i le SQL Server. Faamatala le faasologa saʻo o gaioiga i faʻamatalaga SELECT. Lesona

  • Faailoaina o le T-SQL
  • Malamalama Ito
  • Malamalama i le Fuafuaina o Mea Mataʻutia
  • Malamalama i le Faʻatonuga o le Faʻatonuga o Faʻamaumauga i faʻamatalaga SELECT

Lautusi: Folasaga i le T-SQL Querying

  • Faʻaaogaina Faamatalaga FUAFUAGA SELETE
  • Faʻaaogaina Queries e Filiga Data e faʻaaoga ai Predicates
  • Faʻaaogaina o Queries E Faʻasese le Faʻamatalaga Faʻaaogāina LE SAUNIA E

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

  • Faʻamatala le matafaioi o le T-SQL i le tusitusi Faʻasoa faamatalaga.
  • Faʻamatala mai elemene o le gagana T-SQL ma o a elemene o le a aoga i fesili tusitusia.
  • Faamatala faʻamatalaga o le komiti faʻatulagaina, o se tasi o laasaga matatiki o faʻamaumauga fesoʻotai, ma fesoasoani ia te oe e faʻaaogaina i lou mafaufau e uiga i le fesiligia o le SQL Server
  • Faʻamatala le faʻamatalaga manino ma iloilo lana talosaga i le fesiligia o le SQL Server.
  • Faʻamatala mea elemene o se faʻamatalaga SELET, faʻasalalau le faasologa lea e iloilo ai elemene, ona faʻaaoga lea o lenei malamalamaaga i se auala aoga e tusia ai fesili.

Module 3: Tusitusi SAUNOA FESILI

O lenei vaega e faʻaalia ai faʻavae o le faʻamatalaga SELECT, e taulaʻi atu i fesili e faasaga i se laulau se tasi.Lessons

  • Faʻamatalaga Faʻamatalaga FILIFILI FUAʻI
  • Faʻateʻaina kopi faʻatasi ma le faʻasologa
  • Faʻaaogaina o Polokalame Lisi ma Laulau
  • Faʻamatalaga faigofie FAASOLOGA FAASOLOGA

Lautusi: Tusitusiga Tusitusi FUAFUAGA

  • Faʻamatalaga Faʻamatalaga FILIFILI FUAʻI
  • Faʻaitiitia o kopi e ala i le faʻaaogāina o TALA
  • Faʻaaogaina o Polokalame Lisi ma Laulau
  • Faʻaaogāina o se Faʻaaliga Faʻatauvaa Faʻapitoa

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

  • Faʻamatala le fausaga ma le faatulagaga o le faʻamatalaga SELECT, faʻatasi ai ma faʻaleleia atili o le a faʻaopoopoina ai le faʻatinoga ma mafai ona faitauina i au fesili
  • Faʻamatala pe faʻapefea ona faʻaaoga faʻataʻitaʻiga e faʻaaoga ai le fuaiupu FAASOLOGA
  • Faʻamatala le faʻaogaina o le koluma ma laupepa
  • Malamalama ma faʻaaoga faʻamatalaga CASE

Faʻataʻitaʻiga 4: Faʻasalalau Tele Laulau

O lenei vaega o loʻo faamatalaina le auala e tusia ai fesili e faʻapipiʻi ai faʻamaumauga mai le tele o punaoa i le Microsoft SQL Server 2016. Lesona

  • Malamalama e Faʻatasi
  • Faʻasalaga ma Faʻatasi Faʻatasi
  • Faʻasalaga ma le Other Joins
  • Faʻatalanoa ma le Koluse Faatasi ma le Faatasi

Laʻu: Faʻatalosaga Tele Tele Laulau

  • Tusiga Faʻamatalaga e faʻaaogaina Totonu o Fale
  • Faʻamaumauga o Faʻamatalaga e faʻaogaina le tele o Laupapa Faʻatasi
  • Tusiaina o fesili e faʻaaoga ai le tagata lava ia
  • Tusiaina o Fesili e faʻaaoga ai le Outer Joins
  • Tusiaina o fesili e faʻaaogaina le Koluse

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

  • Faamalamalama mea faavae o le auai i le SQL Server 2016
  • Tusi fesili o loʻo i totonu
  • Tusi fesili e faʻaaoga ai sooga i fafo
  • Faʻaaogā faʻaopoopo tuʻufaʻatasia

Faʻataʻitaʻiga 5: Faʻatulagaina ma Faʻasaʻo Faʻamaumauga

O lenei vaega o loʻo faʻamatalaina le auala e faʻaaogaina ai le viliina ma le filiga.Lessons

  • Faʻasologa o Faʻamatalaga
  • Faʻamaumauga Faʻamaumauga i Faʻamatalaga
  • Faʻamaumauga Faʻamaumauga i le TOP ma le OFFSET-FETCH
  • Galulue Faatasi ma Tulaga le Masani

Lautusi: Faʻasalalau ma Faʻamaumauga Faʻamaumauga

  • Faʻamaumauga o Fesili e Filiga Data e faʻaaoga ai se Clause WHERE
  • Faʻamaumauga o Faʻamatalaga o le Faʻaseseina o le Faʻamatalaga Faʻaaogāina o se FUAFUAGA Saunia e le Fuaiupu
  • Faʻamaumauga o Faʻamatalaga o Faʻamaumauga Faʻamaumauga Faaaogaina o le Filifiliga TOP

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

  • Faʻamatala pe faʻafefea ona faʻaopoopo se TULAFONO E ala i le vaitau i au fesili e pulea ai le faasologa o laina o loʻo faʻaalia i totonu o lau sailiga
  • Faʻamatala pe faapefea ona fausia AII fuaiupu e faamama ai laina ia e le fetaui ma le mea taua.
  • Faʻamatala pe faʻapefea ona faʻatapulaaina laina o laina i totonu o le fuaiupu SELECT e faʻaaoga ai se filifiliga TOP.
  • Faʻamatala pe faʻapefea ona faʻapulaaina laina o laina e faʻaaoga ai le filifiliga OFFSET-FETCH o se TALIINA E le fuaiupu.
  • Faʻamatala pe faapefea ona faʻaogaina le tolu-tau aogā faʻamaonia mo mea e le o iloa ma faʻamaonia, pe faʻapefea e le SQL Server ona faʻaaoga le NULL e maka ai mea taua o loʻo misi, ma le auala e suʻe ai mo le NULL i au fesili.

Module 6: Faʻatasi ma Pusa Faʻamaumau SQL 2016 Faʻamaumauga

O lenei module e faʻaalia ai faʻamatalaga faʻamaumauga o loʻo faʻaoga e SQL Server e teu ai data.Lessons

  • Faʻailoaina o Faʻamaumauga o le SQL Server 2016 Data
  • Galulue ma Faʻauiga Faʻamaumauga
  • Galulue faʻatasi ma Aso ma Taimi o Taimi

Lautusi: Galulue faʻatasi ma ituaiga SQL Server 2016 Data Types

  • Tusiaina o Faʻamatalaga o le Aso Toe Foi ma le Taimi o Taimi
  • Tusiaina o Fesili e faʻaaoga Aso ma Taimi o Taimi
  • Faʻamaumauga o Faʻamatalaga O Faʻamatalaga Faʻamaumauga o Tagata Foi
  • Faʻamaumauga o Faʻamatalaga O Galuega Toe Faʻafoʻi Mai

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

  • Suʻe le tele o faʻamaumauga o loʻo faʻaogaina e SQL Server e teu ai faʻamaumauga ma pe faʻafefea ona suia ia ituaiga faʻamaumauga i le va o ituaiga
  • Faʻamatala le ituaiga o faʻamaumauga o fatufatuga o le SQL Server, pe faapefea ona faʻatusatusa amio, ma nisi o galuega masani e mafai ona e aoga i au fesili
  • Faʻamatala faʻamaumauga o faʻamatalaga e faʻaaogaina e teu ai faʻamaumauga faaletino, pe faʻapefea ona e ulufale i aso ma taimi ina ia mafai ona faʻasalalau lelei e le SQL Server, ma pe faʻapefea ona faʻaaogaina aso ma taimi faʻatasi ai ma galuega faʻatulagaina.

Module 7: Faʻaaogaina o le DML e Suʻe ai Faʻamatalaga

O lenei vaega o loʻo faʻamatalaina le auala e fatuina ai fesili a le DML, ma pe aisea e te manaʻo ai .Lessons

  • Faʻaofiina o Faʻamatalaga
  • Faʻataʻitaʻia ma Faʻateʻa Faʻamaumauga

Lautusi: Faʻaaogaina o le DML e suia ai faʻamatalaga

  • Faʻaofiina o Faʻamatalaga
  • Faʻafouina ma Aveese faʻamatalaga

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

  • Faʻaaogā MULIMULI ma FILIFILIA I totonu o faʻamatalaga
  • Faʻaaoga le UPDATE, MERGE, TUʻUINA, ma le TRUNCATE.

Faʻaaogaina o le 8: Faʻaaogaina o Galuega Fausia

O lenei module e faʻaalia nisi o le tele o loʻo fausia i galuega i le SQL Server 2016.Lessons

  • Faʻasalalau Fesili ma Galuega Fausia
  • Faaaogaina o Matafaioi o le Liuaina
  • Faaaogaina o Matafaioi Faʻatonu
  • Faaaogaina o Galuega e Galue ai ma le NULL

Lautusi: Faʻaaogaina o Galuega Fausia

  • Tusi Faʻamatalaga e Faʻaaogā ai Taunuuga Faʻaliliuga
  • Tusiaina o Faʻamatalaga e faʻaaoga ai Galuega Faʻatino
  • Tusiaina o Fesili ole Suʻega mo le Mausali

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

  • Faʻamatala le ituaiga o galuega tauave o loʻo tuʻuina atu e le SQL Server, ona taulai atu lea i le galue ai ma galuega a scalar
  • Faʻamatala pe faʻapefea ona faʻamalamalama faʻamalamalama faʻamatalaga faʻaliliu i le va o ituaiga e faʻaaoga ai le tele o galuega SQL Server
  • Faʻamatala pe faʻapefea ona faʻaaoga galuega talafeagai e iloilo ai se faʻamatalaga ma toe foʻi mai se iuga.
  • Faʻamatala galuega faaopoopo mo le galulue faatasi ma le NULL

Faʻataʻitaʻiga 9: Faʻatasi ma Faʻasoaina Faʻamaumauga

O lenei taʻiala o loʻo faʻamatalaina le ala e faʻaaoga ai galuega faʻatasi.Lessons

  • Faʻaaogaina Faʻatonu Galuega
  • Faaaogaina o le GROUP BY Clause
  • Fesuiaʻiina o kulupu ma NOFOAGA

Lautusi: Faʻatasi ma Faʻasoa Faʻamaumauga

  • Tusi Faʻamatalaga e Faʻaaoga le GROUP BY Fuaiupu
  • Tusi Faʻamatalaga e Faʻaaoga ai Taunuuga Faʻatasi
  • Faʻamaumauga o Faʻamatalaga e Faʻaaoga ai Matafaioi Faʻatasi Faʻatasi
  • Faʻamaumauga o Faʻamaumauga e Faʻasusu Groups faatasi ma le Fuaiupu

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

  • Faʻamatala le galuega tuufaatasia i totonu o le SQL Server ma tusi fesili e faʻaaoga ai.
  • Tusi fesili e vavae ese ai laina e faʻaaoga ai le GROUP BY clause.
  • Tusi fesili e faʻaaoga ai le Fuaiupu i vaega faʻapitoa.

Faʻavae 10: Faʻaaogaina o Subqueries

O lenei vaega o loʻo faamatalaina ai le tele o ituaiga o subquery ma le auala ma le taimi e faʻaaoga ai .Lessons

  • Tusi Tusitusi Tusitusiga a le Tagata Lava Ia
  • Tusitusi Correlated Subqueries
  • Faʻaaogaina o le VAEGA FAʻATASI MA SUʻESUʻEGA

Lautusi: Faaaogaina o Subqueries

  • Faʻamaumauga o Faʻamatalaga o loʻo Faʻaaogaina ia Manatu Faʻatasi
  • Faʻamaumauga o Faʻamatalaga e Faʻaogaina ai Scalar ma Faʻasologa Taua
  • Faʻamaumauga o Faʻamatalaga e Faʻaogaina Faʻatauga Subqueries ma se Faʻasalaga Fuaiupu

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

  • Faamatala pe o fea e mafai ona faʻaaogaina ai subqueries i se faʻamatalaga SELET.
  • Tusi fesili e faʻaaoga ai faʻamaumauga faʻatasi i se faamatalaga SELECT
  • Tusi fesili e faʻaaoga ai le EXISTS i se vaega o le WHERE e suʻe ai le i ai o laina saʻo
  • Faaaoga le faʻasologa o le EXIST i le siakiina lelei o le i ai o laina i se subquery.

Faʻataʻitaʻiga 11: Faʻaaogāina o Faʻaaliga Ripoti

I le taimi muamua i lenei vasega, na e aʻoaʻo ai e uiga i le faʻaaogaina o subqueries e fai ma faʻamatalaga na toe foʻi mai i se fesili i tua atu o le telefoni. E pei o subqueries, o faʻamatalaga laulau e fesiligia ai faʻamatalaga, ae o laulau e faʻalauteleina lenei manatu e ala i le faataga oe e taʻu igoa ma galulue faatasi ma a latou taunuʻuga ao e galue faʻatasi ma faʻamaumauga i totonu o soʻo se faʻatalatalanoaga. O le Microsoft SQL Server 2016 e lagolagoina ituaiga e fa o faʻamatalaga o le laulau: laupepa na maua, faʻamatalaga masani o le laulau (CTE), vaaiga, ma le faʻatulagaina o le faʻatulagaga o le laulau-valu (TVFs). I totonu o lenei atulaulau, o le ae aoao e galue ma nei ituaiga o faʻataʻitaʻiga o le laulau ma aʻoaʻo pe faʻapefea ona faʻaaogaina e fesoasoani ai i le faia o se auala faigofie i le tusia o fesili.

  • Faʻaaogaina o Manatu
  • Faʻaaogaina o le Faʻatonuina o Ata-Faʻatinoina Taunuuga
  • Faaaogaina o Laulau Faʻamatala
  • Faʻaaogaina o Ripoti Masani

Lautusi: Faʻaaogaina o Faʻaaliga Ripoti

  • Faʻamaumauga o Fesili e Faʻaaoga Vaaia
  • Faʻamaumauga o Faʻamatalaga e Faaaoga Laulau Faʻataʻoto
  • Faʻamaumauga o Faʻamatalaga e Faʻaaogā Faʻamatalaga Lelei Masani (CTE)
  • Faʻamaumauga o Faʻamatalaga e Faʻailoa ai Faʻamatalaga Faʻataʻatia-Ata Faatauaina

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

  • Tusi fesili e toe tali mai ai mai manatu.
  • Faʻaaogā le faʻamatalaga FRECTION FAʻAMATALAGA e fatu ai se laina faigofie o le TVFs.
  • Tusi ni fesili e fatuina ma toe maua ai tali mai laulau na maua mai.
  • Tusi ni fesili e fatuina ai CTE ma toe foʻi mai i luga o le laulau.

Module 12: Faʻaaogaina o le Faʻatonuina o le Faʻatonu

O lenei vaega e faʻaalia ai le faʻaogaina o le UNION, INTERSECT, ma le EXCEPT e faʻatulaga ai laina i le va o seti faʻatonu lua.

  • Faʻasalalau Fesili ma le UNION operator
  • Faʻaaoga VAEGA TUSI MA INTERSECT
  • Faaaogaina o le APPLY

Lautusi: Faʻaaogaina o le Faʻatulagaina o Faʻatonu

  • Faʻamaumauga o Fesili e Faʻaaoga le UNION Set Set Operators ma UNION ALL
  • Faʻamaumauga o Faʻamatalaga e Faʻaaogaina le CROSS APPLY MA LE TULAGA TAUSI TALOSAGA FAIGALUEGA
  • Faʻamaumauga o Faʻamatalaga o loʻo Faʻaaogaina TAGATA MATAFAIOʻI MA INTERSECT Operators

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

  • Tusi fesili e faʻaaoga ai le UNION e tuʻufaʻatasia ai seti faʻasoa.
  • Tusi fesili e faʻaaoga UNION ALL e faʻapipiʻi ai seti faʻasoa
  • Tusi fesili e faʻaaoga ai le tagata EXCEPT operator e toe foi mai na o laina i se seti se tasi ae le o se isi.
  • Tusi fesili e faʻaaoga ai le INTERSECT operator e toe faafoi na o laina o loʻo i ai i seti uma e lua
  • Tusi fesili e faʻaaoga le CROSS APPLY operator.
  • Tusi fesili e ala i le faʻaaogaina o le PULEGA APPLY operator

Faʻaaogaina o le 13: Faʻaaogaina o le Faʻatulagaina o le Windows, Offset, ma Fonctions Faʻatasi

O lenei vaega o loʻo faʻamatalaina ai le lelei i le faʻaaogaina o galuega faʻamalama. Faʻateʻaina galuega o le faamalama i laina o loʻo faʻamatalaina i totonu o le fuaiupu OVER, e aofia ai vaega ma fusi. Tusi ni fesili e faʻaaoga ai galuega faʻatalama e faagaoioi ai i luga o le faamalama o laina ma toe faʻaleleia le faʻavasegaina, faʻaputuina, ma le faʻatusatusaina o le faʻatusatusaga o taunuuga .Lessons

  • Faʻatuina o le komepiuta ma le ATUA
  • Suʻesuʻeina o Matapihi

Lautusi: Faʻaaogaina o le Faʻasalaga, Tausiga, ma le Faʻatulagaina o Matafaioi

  • Tusiga Faʻamatalaga e faʻaaoga ai Galuega Faauluuluga
  • Tusiga Faʻamatalaga e faʻaaoga ai Taunuuga Taunuuga
  • Faʻamaumauga o Faʻamatalaga e faʻaaoga ai Mataitusi Faʻatasi Faʻatasi

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

  • Faamatala vaega o le T-SQL na faʻaaogaina e faʻamatala ai faamalama, ma sootaga i le va oi latou.
  • Tusi fesili e faʻaaoga ai le fuaiupu OVER, faʻatasi ai ma le vaeluaina, faʻatonuga, ma le faʻapipiʻi e faʻamalamalama ai matala
  • Tusi fesili e faʻaaoga ai faʻamalamalamaga faʻamalama.
  • Tusi fesili e faʻaaoga ai le faʻatulagaga o le faʻamalama.
  • Tusi fesili e faʻaaoga ai le faʻamalo o galuega

Faʻataʻitaʻiga 14: Faʻasologa o Faiga Faʻavae ma Faiga Faʻavae

O lenei module o loʻo faʻamatalaina ai fesili e faʻaogaina ma le faʻaogaina o faʻaiʻuga. Tusi fesili e faʻamaonia ai le tele o kulupu ma le faʻavaeina o lesona

  • Tusi Faʻamatalaga ma PIVOT ma UNPIVOT
  • Galulue ma Faiga Faʻavae

Lautusi: Pivoting and Grouping Sets

  • Tusiga Faʻamatalaga e faʻaaoga le PIVOT Operator
  • Tusiga Faʻamatalaga e faʻaaoga le UNPIVOT Operator
  • Tusiaina o Faʻamatalaga e faʻaaoga ai le GROUPING SETS CUBE ma ROLLUP Subclauses

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

  • Faamatala pe faʻapefea ona faʻaogaina faʻamatalaga faʻamatalaga i faʻamaoniga T-SQL.
  • Tusi i lalo ia fesili ole taua mai i laina i koluma e faʻaaoga ai le PIVOT operator.
  • Tusi ni fesili e faʻamaonia ai faʻamatalaga mai koluma i tua i laina e faʻaaoga ai le UNPIVOT.
  • Tusi fesili e ala i le faʻaaogaina o le GROUPING SETS subclause.
  • Tusi fesili e faʻaaoga ROLLUP MA CUBE.
  • Tusi fesili e faʻaaoga ai le GROUPING_ID galuega.

Faʻataʻitaʻiga 15: Faʻaaogaina o Taʻiala Faʻasaoina

O lenei vaega o loʻo faʻamatalaina le auala e toe faʻafoʻi ai taunuuga e ala i le faʻatinoga o faʻamaumauga e teuina Faʻasologa o faʻamaumauga i taualumaga. Faʻatino ni faʻamatalaga faigofie e teuina e faʻamalosi ai se faʻamatalaga FILIFILIA. Fausia ma faʻatino faʻamalosi SQL i EXEC ma sp_executesql.Lessons

  • Faʻamatalaga Faʻamatalaga i Faʻamaumauga Faʻasaoina
  • Faʻamasalaina o Taʻitoʻatoa i Faʻamaumauga Faʻasaoina
  • Fausiaina o Faʻamaumauga Faʻasaoina Faʻatasi
  • Galulue faʻatasi ma le faʻamalosi SQL

Lautusi: Faʻatinoina Taʻiala Faʻasaoina

  • Faʻaaogāina o le EXECUTE faʻamatalaga i Taʻiala Faʻasaoina o le Invoke
  • Faʻamasalaina o Taʻitoʻatoa i Faʻamaumauga Faʻasaoina
  • Taʻiala Faʻamaumauga Faʻamaumauga

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

  • Faʻamatala auala faʻapipiʻi ma lo latou faʻaaogaina.
  • Tusi ia faʻamatalaga T-SQL o loʻo faʻatinoina faʻasologa o faʻamaumauga e toe faafoi ai faʻamatalaga
  • Tusi Faʻamatalaga faʻamatalaga e pasi atu ai faʻamaumauga o fesoʻotaʻiga i faʻamaumauga e teuina.
  • Tusi faʻailoga T-SQL e saunia tapulaa faʻataʻitaʻiga ma faʻatino faʻasologa o faʻamaumauga.
  • Faʻaaogā le faʻasologa o le faʻasologa o faʻamatalaga e tusia ai se faʻatulagaga teuina.
  • Faʻatulagaina se faʻamaumauga e teuina e talia ai faʻasalalauga o fesoʻotaiga.
  • Faʻamatala le auala e mafai ai ona fausia ma le malosi le T-SQL.
  • Tusi fesili e faʻaaogaina ai le faʻamalosi SQL.

Module 16: Polokalama ma le T-SQL

O lenei vaega o loʻo faʻamatalaina pe faʻafefea ona faʻaleleia lau code T-SQL i elemene polokalama .Lessons

  • T-SQL Programming Elements
  • Polokalame Pulea Polokalama

Lautusi: Polokalama ma le T-SQL

  • Faailoaina o Variables ma le Delimiting Batches
  • Faʻaaogaina o le Pule-Of-Flow Elements
  • Faʻaaogāina o Variables i se Faʻamatalaga Faʻamatalaga Mataʻutia
  • Faʻaaogaina o upu faʻamaoni

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

  • Faʻamatala pe faʻafefea ona togafitia e Microsoft SQL le aoina o faʻamatalaga e pei o piʻo.
  • Fausia ma tuʻuina atu piʻo o le T-SQL code mo le faʻatinoina e le SQL Server.
  • Faʻamatala pe faʻapefea ona tuʻuina atu e le SQL Server ni mea le tumau faʻapitoa.
  • Tusi le faʻailoga e faʻailoa ai ma tuʻuina atu suiga.
  • Faia ma faʻatoga faʻamaonia
  • Faamatala mea e pulea-o-flow i le T-SQL.
  • Tusi le tulafono T-SQL e faʻaaoga ai poloka IF ... ELSE.
  • Tusi le code T-SQL lea e faʻaaogaina WHILE.

Faʻavae 17: Faʻatinoina o le Faʻasalalau Manua

O lenei module e faʻaalia ai le faʻaaogaina sese o T-SQL.Lessons

  • Faʻaaogaina o le faʻaaogaina o T-SQL
  • Faʻaaogaina o le faʻaaogaina o le faʻaaogaina o tuusaunoaga

Lautusi: Faʻaaogaina o le Faʻasalaga Manua

  • Toe faasaʻo mea sese ma TRY / CATCH
  • Faʻaaogaina o le THROW e pasi atu ai se savali sese ile tagata o tausia

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

  • Faʻaaogaina le T-SQL faʻamalosi mea sese.
  • Faatino le faʻatulagaina o le faʻaaogaina o tuusaunoaga.

Faʻavae 18: Faʻatinoina o Gaoioiga

O lenei vaega o loʻo faʻamatalaina le auala e faʻaaogaina ai fefaʻatauaiga

  • Gaoioiga ma masini komepiuta
  • Puleaina o fefaʻatauaiga

Lautusi: Faʻatinoina o Gaoioiga

  • Puleaina o fefaʻatauaiga ma BEGIN, COMMIT, ma ROLLBACK
  • Faʻaopoopoina faʻamatalaga sese i se poloka CATCH

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

  • Faʻamatala le fefaʻatauaʻiga ma le eseesega i le va o paso ma fefaʻatauaiga.
  • Faʻamatala auivi ma pe faapefea ona taulimaina e le SQL Server.
  • Fausia ma pulea fefaʻatauaiga ma faʻamatalaga faʻatautaia o fefaatauaiga (TCL).
  • Faʻaaoga SET XACT_ABORT e faʻamalamalama ai Servers SQL o loʻo faʻafoe feuiaiga i fafo o poloka TRY / CATCH.

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 faʻafesoʻotaʻi lelei i matou.


iloiloga