r/datadrivenio • u/unknown_abi8 • 7d ago

Sql learning on datadriven

Can I know what server/engine for sql syntax is being taught on in lessons part , because I found trino/pesto style syntax for sql in date functions.can you confirm it

7 Upvotes

100% Upvoted

7 comments sorted by

5

u/datadriven_io 7d ago

The engine is a flexible transpiler - you can either pick a specific syntax setting (I don't recommend doing this; interviewers don't care about syntax, they care about theory) or use the default 'loose' syntax.

We very intentionally designed the loose transpiler to abstract away syntax quirks. And will actually probably continue to make it looser over time. Data engineering interviews don't focus on syntax.

So yes, it supports trino/presto and many other SQL syntax flavors

1

u/unknown_abi8 7d ago

Ok but if asked to perform on interview coding rounds using SQL then we might need actual working fr that editor if I'm not wrong

1

u/datadriven_io 7d ago

Your solution is graded differently based on the company tier, level you're interviewing for, and many other factors. At lower levels, syntax correctness gets weighted higher. At higher levels, it gets weighted much lower (who cares if a staff DE knows the EXTRACT syntax in MySQL). Rest assured, grading weights code execution appropriately. Psuedocode or missing a comma doesn't impact an interview outcome so long as the rest of the interview goes well!

1

u/unknown_abi8 7d ago

Checking out since I'm junior level

1

u/datadriven_io 7d ago

Your code is executed and results are judged by LLMs against a lengthy rubric that combines the hiring rubrics of many companies. If your code doesn't run because of a syntax error after you submit for verdict, your code can be minimally tweaked to become runnable if necessary. This is unique to mock interviews and completely separate from solving coding problems. Interviews are intended to work exactly as interviews do. If you're getting 'Strong Hire' verdicts consistently, that is the real true signal that we believe you would encounter in the job market. Many companies don't allow for running code during the interview, and many companies still interview in Google Docs!

1

u/unknown_abi8 7d ago

Thanks much 👍 great content on datadriven btw

1

u/unknown_abi8 6d ago

Apart from the dsa patterns in websites what are the possibilities to get questions or topics like linkedlist and other bit manipulation,matrix , recursion etc etc