What you'll learn

You will learn the concept of relational data base management system (RDBMS)
You will learn the basics of SQL
You will learn how to use Microsoft SQL Server
You will learn ETL concepts (Extract Transform Load)
You will learn how to use Alteryx Designer 2018.4
How to use different tool available in Alteryx
How to get certified (Alteryx Designer Core)
You will learn, how to use Qlik sense to visualize your data

Requirements

A working Computer/Laptop
Should Understand English
Internet connection to watch this videos

Description

This course is divided into three modules :

Database design using SQL server.

Alteryx Designer 2018.4.4

QlikSense, 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 IF NOT EXISTS ,

Insert into table

Delete from table

Where clause while using select and delete.

primary key unique key.

Upcoming topics:

Constrains (Check)

View

Index

Join

Union

stored procure

Functions

At 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 modeling
This course is not for experienced data engineers.
Those who want to learn about Alteryx ETL