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 ,
- Insert into table
- Delete from table
- Where clause while using select and delete.
- primary key unique key.
- Constrains (Check)
- stored procure
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.