Відео

this is no snowflake snowflake unique constrain is not enforced (i think)

Best explanation to handle nulls

❤

Really useful for the interview...Thanks again for this gem of a video , multiple questions asked in my interview..

Good information @praveen kumar very precise..Thanks!

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 is your training classes are available in udemy?

I am unable to connect snowflake connector can u help me out on this?

Good Effort Brother

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 ?

Col 1 values Col2 Null Output should be values but 1 to 0 and 0 to 1.

How many stages could you use in ur project? Today I have given an interview they have asked😢

Good Content,,,🤗

Hi brother nice video. Please upload videos on DBT Model Materializations(incremental, empharal). What,Why,when.

Hi I want to join your class

❤

Crystal Clear Explanation..🙏

❤

Cam u teach only dbt tool

i need solution in my sql , my version doesnt support reg_exp

Hi sir, any new batch starting, please let me know

Awesome ❤

❤

Explained very neat n clear 😊

Thank you, very much useful

❤

you are too good Sir! Thank You!

Awesome feature Sir🎉

Hi sir example of Sjsjs.T17282 How separate this (.T17282)

can we use LAG function here ?

Amazing Praveen bro it's very helpful content thnk u❤

Most helpful information anna

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

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

Data Lineage Diagram is only for DBT cloud right? or it is available in dbt core?

Thanks for sharing all the deatils😊

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.

Thanks a lot sir

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.

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.

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.

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.

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.

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.

Good job! You exactly explained what is Snowflakes in the first 60 seconds, which I could not find that info in other videos.

What is the fee for dbt & snowflake?