教程-How To Use Alteryx To Visualise SQL Server Data In Qliksense
MP4|Video:h264,1280x720|Audio:AAC,44.1KHz,2Ch
Genre:eLearning|Language:English|Duration:4hours| 

DesignADatabase->StoreData->RetrieveData->TransformYourDataWithAlteryx->VisualiseYourDatainQliksense

Whatyou'lllearn

Youwilllearntheconceptofrelationaldatabasemanagementsystem(RDBMS)
YouwilllearnthebasicsofSQL
YouwilllearnhowtouseMicrosoftSQLServer
YouwilllearnETLconcepts(ExtractTransformLoad)
YouwilllearnhowtouseAlteryxDesigner2018.4
HowtousedifferenttoolavailableinAlteryx
Howtogetcertified(AlteryxDesignerCore)
Youwilllearn,howtouseQliksensetovisualizeyourdata

Requirements

AworkingComputer/Laptop
ShouldUnderstandEnglish
Internetconnectiontowatchthisvideos

Description

Thiscourseisdividedintothreemodules:

DatabasedesignusingSQLserver.

AlteryxDesigner2018.4.4

QlikSense,APersonalised,interactivedatavisualisationstool.

Module1:DatabasedesignusingSQLserver:

Thismodulewillcoververybasicsofanydatabasesystem.Wewillstartbydesigningasimpledatabase.ThenwilllearnhowtouseSQL,toretrievedatastoredinSQLServer.Howtodesigntablessothatyoucouldstoredatainthat.ThenwillshowyouhowtouseotherdatamanipulationstatementsavailableinSQL.

WewillcoverfollowingkeywordsinSQL.

Selectfromtable,

createtable,

Insertintotable

Deletefromtable

Whereclausewhileusingselectanddelete.

primarykeyuniquekey.

Upcomingtopics:

Constrains(Check)

View

Index

Join

Union

storedprocure

Functions

Attheendofthismodulewewilllistfewofthemostcommoninterviewquestion,thatyoucouldexpectfromdatabasemanagementsystem.

Module2:AlteryxDesigner2018.4.4:

PrimaryfocusofthismoduleistoclearAlteryxDesignercorecertification.Wewillstartbycreatingasmallworkflowinalteryx.Thenwilltrytoexplainmostcommonlyusedtoolinalteryxandwillexplainhowtoconfigurethistools.

Wewillshowhowtocreateacommunityaccountandwhereapplyfortheexam.Alsowillshowhowyoucouldattendthisdesignercoreexamfromyourhome.wewilltrytoexplainalltheexpectedquestionthatmightaskinyourexam.Wearenotprovidinganydatadumps,insteadwearetryingtoexplainalltheimportanttopics/toolthatyoushouldknowinordertoworkwithalteryx.Asitisimportantandmostcommonlyusedtool,youcouldexpectmultiplequestionsaboutthistool.

Module3:QlikSenseVisualisation.

Thispartisinpostproductionstageandwewillpublishallourqliksensevideossoon.

Whothiscourseisfor:

BeginnersQliksensedeveloperscuriousaboutdatamodeling
Thiscourseisnotforexperienceddataengineers.
ThosewhowanttolearnaboutAlteryxETL