Bro stop making videos. And who tf asks all these stupid questions? It’s materialised as a view or as a table. And by default there are two models already, which when you run materializes as a view in snowflake. But that depends on the profile.yml file. But why tf will an interviewer ask that? There are better questions to ask.
Hi Praveen, Question - Suppose I transformed data using DBT and new target table is created in snowflake. But after transformation some new records inserted into raw data table . Now this new records will get transformed automatically into target table or not? If no then how it will be happen ?
Hi Bro.. Really I am getting more motivation and interest by seeing you way of teaching... Your teaching like our concentration not going anywhere except that video.. thanks for your awesome video
@@praveenkumarbommisetty6093 Hi bro... Pls upload video about snowflake cost management concept like table, data transfer cost, etc... with clear explanation. Thanks
Hi Praveen, Hope you are doing good. I have my interview next week. Can you please share the advanced concepts and complex interview questions to prepare
Hi, I think taking a back up of a table won't extract all the indices & constraints, etc., from the original table. It will only extract the table column structure.
Hi all, I am a fan of Praveen Kumar Bommisetty Sir. He is indeed a fabulous and exemplary faculty for SQL, Snowflake, and DBT. I have troubled him many times whenever I got stuck in my learning process, and he was always readily available to help me out. I am thankful to him for making me confident in SQL and Snowflake, even though I am not from a technical background. His way of teaching SQL and Snowflake concepts is simply amazing. He repeats the concepts in his classes multiple times and also sends you assignments to complete regularly, so ultimately, those concepts become part of your permanent memory. His specialization is in breaking down difficult SQL and Snowflake concepts and explaining these in a very simple and easy manner for Non-IT/Non-technical students. I have done market research on the currently trending IT technologies and found out that Snowflake with SQL is in high demand in India and abroad. The demand for a good SQL and Snowflake professional is very high. Countries like the US, Canada, Australia, and EU countries are paying around 40-60 lakhs per annum to a Snowflake Developer. So, moving abroad is another great option after doing the Snowflake and SQL course and then applying for work permits or going to a foreign country via studies. After doing Praveen Sir's Snowflake and SQL course, I can tell you that one can easily reach the level of a Snowflake Developer or Snowflake Data Engineer with 3-4 years of work experience. With that, one can easily demand a salary of 8 to 15 LPA in India. It can also go up to 20 LPA if one has some domain experience in industries like Finance, Insurance, Banking, Healthcare, Ecommerce, etc. The course by Praveen Sir is just 45 days long, and the fee is really affordable. I don't think that 8-20 LPA in India is bad for 45 days of dedicated preparation on Snowflake and SQL. Additionally, knowing Snowflake and SQL can open other avenues for you to enter highly paid IT professions like Data Analyst, Data Scientist, Data Engineering, and Business Analyst. Just pick up additional skills/tools like one cloud platform (either Azure or AWS), Python and Databricks for EDA and ETL, Power BI/Tableau for Data Visualization, MS Excel for basic analysis, and wireframing tools for Business Analysis like Axure, Microsoft Visio, Balsamiq, and Jira for Project Management, and you would be good to apply to a diverse range of jobs. The amazing and exciting news is that SQL and Snowflake are required in all of the IT professions mentioned above. SQL is a mandatory skill to have in IT, and Praveen Sir makes you comfortable with SQL by the end of the course. That is the backbone for any data job nowadays. To tell you more, a good understanding of SQL means you already have the necessary skills and a logical mindset to easily learn other tools like Python, PySpark, PySQL, and Databricks. Most of the codes and logics are similar. Half of your battle is won if you have a good grasp of SQL. Just imagine, this Snowflake and SQL course by Praveen Sir is giving you a strong foundation to enter the job market in just 45 days. It also opens up opportunities in other IT professions mentioned above. The fee is really minimal for the effort he puts into his training. I highly recommend that you can blindly take his training and benefit from it. I know that after the training, you can confidently face any Snowflake Developer or Snowflake Data Engineering interviews. I believe that it's a very good opportunity for students who want to go abroad via work permits or higher studies in the future, as the demand for Snowflake Developers is quite high. On average, people are earning around 40-60 lakhs abroad. The compensation in India is also excellent. Take a step in faith, learn Snowflake and SQL from Praveen Sir, grab a job in no time, and make your dreams come true to be a successful IT professional. God bless you all.