modern-elt-demo VS sqlfluff

There's this bootcamp https://dataengineercamp.com/ I haven't taken it myself, though I've seen some of the content (which was very good). Jonathan who runs it is a great guy and great at teaching too!

How is https://dataengineercamp.com/ ? The course is from Australia

Amazing post, lots of great tips and a comprehensive breakdown. Are these covered in https://dataengineercamp.com/?

With that, I am deciding whether: - to take up a Masters in Information Technology in one of the schools here in our country (An anonymous draft of the program can also be sent to hide the identity of the school), or - enroll in this bootcamp (https://dataengineercamp.com/) since based on some reviews and my limited knowledge, this could be a great help for me if I ever decide to find better opportunities.

P.S. I teach a data engineering bootcamp, if you'd like to learn more check out Data Engineer Camp.

If you're looking for a data engineering bootcamp, why not check out https://dataengineercamp.com/

Hello there, I'd suggest checking out Data Engineer Camp if you haven't already. Our next cohort is kicking off July/August 2023. Student testimonial here.

If your interest to become an applied data engineer and do data engineering for a company, then research (PhD) might be overkill. Having a computer science background (degree, or masters, or bootcamp) is sufficient. Most of the learnings will come from being on the job and learning data engineering patterns. I would recommend two books that are great at diving deeper into this topic: Fundamentals of Data Engineering, and Designing Data Intensive Applications. If you are looking for a course that introduces you to the concepts of data engineering, check out Data Engineering Zoomcamp. Disclaimer, I teach a paid data engineering bootcamp called Data Engineer Camp for people that want to be trained by experienced practitioners.

I was looking for some courses online about data engineering, and I came across this bootcamp from Australia (Data Engineer Camp. Has someone ever heard of it or taken it? The curriculum looks solid and the structure seems to be fine. The price is around usd$2,900, not that bad in comparison with other bootcamps, and has payment options.

Hey there, not a masters degree, but I teach a 14 week data engineering bootcamp if you're interested to find out more: https://dataengineercamp.com/

Repo : https://github.com/sqlfluff/sqlfluff

I'm surprised sqlfluff hasn't been mentioned yet. Perhaps not a comprehensive list, but it's worked for everything I've thrown at it. There's an ANSI keyword list [0], and then dialect-specific lists for everything from DB2 [1] to Snowflake [2].

[0]: https://github.com/sqlfluff/sqlfluff/blob/main/src/sqlfluff/...

It has tons of annoying quirks, but I couldn't imagine running a DBT project without it: https://github.com/sqlfluff/sqlfluff

Move SQL queries to sql files and read from files (Use sqlfluff to lint the code https://github.com/sqlfluff/sqlfluff)

SQLFluff is a good CLI tool for this and includes support for jinja and dbt. I don't think there's a VSCode plugin for it yet.

This linter can really enforce some best practices https://github.com/sqlfluff/sqlfluff

A list of best practices:

BigQuery SQL and SQLFluff

There's a SQL parser/linter called SQLFluff that my team uses for our CI/CD. I've made a few pull requests to fix the parser for the particular SQL dialect we used, and my college compiler classes definitely helped.