MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English | Duration: 4 hours | Size: 1.79 GBDesign A Database -> Store Data -> Retrieve Data -> Transform Your Data With Alteryx-> Visualise Your Data in QliksenseWhat you’ll learnYou will learn the concept of relational data base management system (RDBMS)You will learn the basics of SQLYou will learn how to use Microsoft SQL ServerYou will learn ETL concepts (Extract Transform Load)You will learn how to use Alteryx Designer 2018.4How to use different tool available in AlteryxHow to get certified (Alteryx Designer Core)You will learn, how to use Qlik sense to visualize your dataRequirementsA working Computer/LaptopShould Understand EnglishInternet connection to watch this videosDescriptionThis course is divided into three modules :Database design using SQL server.

Alteryx Designer 2018.4.4QlikSense, A Personalised, interactive data visualisations tool.

Module 1: Database design using SQL server:This module will cover very basics of any database system.

We will start by designing a simple database.

Then will learn how to use SQL , to retrieve data stored in SQL Server.

How to design tables so that you could store data in that.

Then will show you how to use other data manipulation statements available in SQL.

We will cover following keywords in SQL.

Select from table ,create table ,Insert into tableDelete from tableWhere clause while using select and delete.

primary key unique key.

Upcoming topics:Constrains (Check)ViewIndexJoinUnionstored procureFunctionsAt the end of this module we will list few of the most common interview question, that you could expect from database management system.

Module 2: Alteryx Designer 2018.4.4:Primary focus of this module is to clear Alteryx Designer core certification.

We will start by creating a small workflow in alteryx.

Then will try to explain most commonly used tool in alteryx and will explain how to configure this tools.

We will show how to create a community account and where apply for the exam.

Also will show how you could attend this designer core exam from your home.

we will try to explain all the expected question that might ask in your exam.

We are not providing any data dumps, instead we are trying to explain all the important topics/tool that you should know in order to work with alteryx.

As it is important and most commonly used tool , you could expect multiple questions about this tool.

Module 3: QlikSense Visualisation.

This part is in post production stage and we will publish all our qliksense videos soon.

Who this course is for:Beginners Qliksense developers curious about data modelingThis course is not for experienced data engineers.

Those who want to learn about Alteryx ETL