General Discussions

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.

which weekly challenge used in-database tools?

Gualigee
8 - Asteroid

Hi 

 

I wonder which weekly challenge used in-database tools?

https://community.alteryx.com/t5/Weekly-Challenge/Weekly-Challenge-Index-amp-Welcome/td-p/48275

 

Thanks

8 REPLIES 8
Qiu
18 - Pollux

@Gualigee 
I dont think there is one so far.
In-Database tool requires database operation, which is not necessarily available to every Alteryx user.

atcodedog05
21 - Polaris

Hi @Gualigee 

 

Your answer would be None

 

If you are looking sample Db connection endpoint there is no exact actual practice example workflow which is provided by Alteryx. Because of the Db endpoint.

Gualigee
8 - Asteroid

@Qiu @atcodedog05

 

 

https://s3-us-west-1.amazonaws.com/ayx.policies/Alteryx+Expert+Certification+Exam+Prep+Guide.pdf?tag...

 

The reason I asked is that these tools are tested in the expert exam.

The guide mentioned I should look into weekly challenge.  

😞

atcodedog05
21 - Polaris

Hi @Gualigee 

 

I have completed all weekly challenges and even @Qiu is a active participant too.

 

From experience i can say weekly challenges will boost your skills. It alone wont be enough even predictive palates is not covered much.

 

You need a lot of experience for Expert and its suggestable that you try to cover all tools in the suggested palates.

Gualigee
8 - Asteroid

You must be a super power user just like your profile pic. so energetic:) 

Qiu
18 - Pollux

@atcodedog05 
Thank you for noticing. Trying to do more but you always get ahead of me.

Gualigee
8 - Asteroid

Hi @JoeM , 

 

I found three in-database tools training videos presented by you. 

 

https://community.alteryx.com/t5/Videos/In-Database-Workflows/td-p/330566

https://community.alteryx.com/t5/Videos/Your-First-In-Database-Workflow/td-p/148073

https://community.alteryx.com/t5/Videos/In-Database-Tools/td-p/45285

 

Are they similar? are they following topics covered in the training? Thanks. 

 

In-Database Analysis
Create new in-database connection strings
Connect to SQL database tables
Stream data into an in-database workflow
Analyze data using in-database tools and appropriate SQL syntax
Change data types and sort data in-database
Create and update tables in the database

Gualigee
8 - Asteroid

Attached is my notes for in-database tool. 

Actually, I still have not got a chance to have access to any database. 

So not confident in the in-database tool questions in the exam:(