- 430
- 631 815
Praveen Kumar Bommisetty
India
เข้าร่วมเมื่อ 3 ก.ย. 2020
#sql #plsql #snowflaketraining #snowflake #snowflaketeaching #dbt #dbtcloud
#sqlinterviewquestionsandanswersforexperienced #sqlforbeginners #snowflaketutorial #sqlinterviewquestions #oracle #snowflakevideos #sqlvideos #sqlforbeginners #snowflaketeaching
This channel is a Knowledge sharing on Oracle Database ,DBT (Data Build Tool) and Snowflake Data Warehouse.
I will regularly post Videos on Oracle SQL, PLSQL Topics, DBT, Snowflake DWH and Interview Questions.
This channel will guide you to learn Oracle SQL
/PLSQL ,DBT and Snowflake DWH concepts and improve the coding skills.
Helps to easily crack the PLSQL ,DBT and Snowflake Interviews .
Quote :
If you are not willing to learn, no one can help you.
If you are determined to learn, no one can stop you.
For Real Time SQL, Snowflake and DBT Training reach us below:
Contact:
bommisettypraveenps@gmail.com
9703180969
#sqlinterviewquestionsandanswersforexperienced #sqlforbeginners #snowflaketutorial #sqlinterviewquestions #oracle #snowflakevideos #sqlvideos #sqlforbeginners #snowflaketeaching
This channel is a Knowledge sharing on Oracle Database ,DBT (Data Build Tool) and Snowflake Data Warehouse.
I will regularly post Videos on Oracle SQL, PLSQL Topics, DBT, Snowflake DWH and Interview Questions.
This channel will guide you to learn Oracle SQL
/PLSQL ,DBT and Snowflake DWH concepts and improve the coding skills.
Helps to easily crack the PLSQL ,DBT and Snowflake Interviews .
Quote :
If you are not willing to learn, no one can help you.
If you are determined to learn, no one can stop you.
For Real Time SQL, Snowflake and DBT Training reach us below:
Contact:
bommisettypraveenps@gmail.com
9703180969
Case Statement and Decode in SQL | Snowflake Case Statement
#sql #sqlinterviewquestionsandanswers #sqlinterviewquestions #sqllearning #learningvideos #learning
Case Statement Use Case
-------------Sample Data:
CREATE TABLE VACCINE_DETAILS(NAME VARCHAR2(100),
DOSES NUMBER);
INSERT INTO VACCINE_DETAILS VALUES('Praveen',1);
INSERT INTO VACCINE_DETAILS VALUES('KuMAR',2);
INSERT INTO VACCINE_DETAILS VALUES('RAJ',3);
INSERT INTO VACCINE_DETAILS VALUES('Ravi',4);
INSERT INTO VACCINE_DETAILS VALUES('Suresh',0);
INSERT INTO VACCINE_DETAILS VALUES('RaJU',5);
Case Statement Use Case
-------------Sample Data:
CREATE TABLE VACCINE_DETAILS(NAME VARCHAR2(100),
DOSES NUMBER);
INSERT INTO VACCINE_DETAILS VALUES('Praveen',1);
INSERT INTO VACCINE_DETAILS VALUES('KuMAR',2);
INSERT INTO VACCINE_DETAILS VALUES('RAJ',3);
INSERT INTO VACCINE_DETAILS VALUES('Ravi',4);
INSERT INTO VACCINE_DETAILS VALUES('Suresh',0);
INSERT INTO VACCINE_DETAILS VALUES('RaJU',5);
มุมมอง: 31
วีดีโอ
SQL Set Operators | CTAS Backup of a Table | SQL Videos
มุมมอง 13019 ชั่วโมงที่ผ่านมา
SQL Set Operators | CTAS Backup of a Table | Cast Function | To_Char CTAS : Create Table new_table As Select * from old_table;
DBT Macros | DBT Macro Example | DBT Data Build Tool Videos | Case Macro
มุมมอง 14019 ชั่วโมงที่ผ่านมา
DBT Macro: Macros are Piece of SQL code that can be reused UDFS Code Reusability Data Build Tool Used for Data Transformation Not a ETL Tool ELT = T Raw Data = DBT =Transformed Data Advantages of DBT: Easy Testing Reusable Code (Macros & JINJA ) CI CD Integration Data Lineage Documentation Prerequisites: Snowflake Account DBT cloud Account Snowflake Database Snowflake Schema Snowflake Tables Cl...
SQL String Functions in Snowflake | Trim in SQL
มุมมอง 153วันที่ผ่านมา
#sql #snowflake #snowflaketraining #snowflake #snowflaketraining #snowflaketeaching #sql #snowflake #snowflaketraining #snowflaketeaching #sql #snowflakeoverview#snowflaketrainingvideos #softwaretrainingcoursesonline#snowflaketrainingcourses #snowflakearchitecture#onlinesoftwareclass #snowflaketraining#snowflaketrainingonlineindia #snowflaketrainingonlineus#snowflaketrainingonlineuk #snowflaket...
Snowflake Internal Stages - User, Table and Named Stages | SnowSQL
มุมมอง 244วันที่ผ่านมา
#snowflaketraining #snowsql #snowsight #classicconsole #snowflaketeaching #bestonlinesoftwarecourses #putcommand #snowflakeoverview#snowflaketrainingvideos #softwaretrainingcoursesonline#snowflaketrainingcourses #snowflakearchitecture#onlinesoftwareclass #snowflaketraining#snowflaketrainingonlineindia #snowflaketrainingonlineus#snowflaketrainingonlineuk #snowflaketrainingonlineaustralia#snowfla...
Filtering and Sorting in SQL || Column Alias || Distinct || #sqlvideos
มุมมอง 1Kวันที่ผ่านมา
#sql #sqltraining #sqltutorial #sqltutorialforbeginners #sqltips #snowflaketraining #snowflake Snowflake Filtering and Sorting | Flipkart and Myntra Use Case SELECT FROM WHERE AND BETWEEN IN OR ORDER BY
DBT Cloud Setup || Snowflake Snowsight UI Setup || New DBT Batch Jan 7th 2025
มุมมอง 292วันที่ผ่านมา
In this video will cover how to connect to snowflake from dbt Prerequisites: Snowflake Account DBT cloud Account Snowflake Database Snowflake Schema #dbtsetupsnowflake #dbtsetup #dbtcoresnowflakesetup #dbtcloudsnowflakesetup #dbtcloud#databuildtool #dbtwithsnowflake#snowflakeanddbt #snowflakewithdbt#snowflakedbtcloud #setupsnowflakewithdbt #dbtmodels#dbtseeds #dbtmacros#dbtanalysis #dbtincremen...
What is DBT | Data Build Tool | Real Time Project Flow | New DBT Batch - Jan 6h 2025
มุมมอง 22814 วันที่ผ่านมา
Data Build Tool Used for Data Transformation Not a ETL Tool ELT = T Raw Data = DBT =Transformed Data Advantages of DBT: Easy Testing Reusable Code (Macros & JINJA ) CI CD Integration Data Lineage Documentation Prerequisites: Snowflake Account DBT cloud Account Snowflake Database Snowflake Schema #dbtcloud#databuildtool #dbtsnowflake #learningdbt #dbtdemovideos #dbtwithsnowflake#snowflakeanddbt ...
SQL Statements in Snowflake | DDL DML TCL DRL DCL | New Snowflake Batch 6th 2025
มุมมอง 41314 วันที่ผ่านมา
Data Build Tool Used for Data Transformation Not a ETL Tool ELT = T Raw Data = DBT =Transformed Data Advantages of DBT: Easy Testing Reusable Code (Macros & JINJA ) CI CD Integration Data Lineage Documentation Prerequisites: Snowflake Account DBT cloud Account Snowflake Database Snowflake Schema #dbtcloud#databuildtool #dbtsnowflake #learningdbt #dbtdemovideos #dbtwithsnowflake#snowflakeanddbt ...
Snowflake Timezone | how to set timezone in snowflake
มุมมอง 17814 วันที่ผ่านมา
#snowsight #sql #snowflake #snowflaketraining #snowflakeoverview #snowflaketrainingvideos#softwaretrainingcoursesonline#snowflaketrainingcourses#snowflakearchitecture #onlinesoftwareclass #snowflaketraining #snowflaketrainingonlineindia #snowflaketrainingonlineus #snowflaketrainingonlineuk #snowflaketrainingonlineaustralia #snowflakefullcourse #snowflakeclass #snowflaketrainingforbeginners #onl...
Snowflake Demo - 1 | New SQL and Snowflake Batch on Dec 3rd | Demo Videos
มุมมอง 34914 วันที่ผ่านมา
#snowsight #sql #snowflake #snowflaketraining #snowflakeoverview #snowflaketrainingvideos#softwaretrainingcoursesonline#snowflaketrainingcourses#snowflakearchitecture #onlinesoftwareclass #snowflaketraining #snowflaketrainingonlineindia #snowflaketrainingonlineus #snowflaketrainingonlineuk #snowflaketrainingonlineaustralia #snowflakefullcourse #snowflakeclass #snowflaketrainingforbeginners #onl...
Snowflake Interview Questions and Answers for Experienced | Time Travel
มุมมอง 16314 วันที่ผ่านมา
Snowflake Interview Questions and Answers for Experienced | Time Travel #Stage#snowflake #snowflaketraining #snowflakeinterview #snowflakeinterviewquestions #snowflakevideos #snowflakelearning #snowflakearchitecture #snowflakesql #SnowflakeInterviewQuestions, #SnowflakeDataWarehouse, #SnowflakeTraining, #DataEngineering, #CloudDataWarehouse, #DataAnalytics, #SnowflakeSQL, #SnowflakeTutorial, #I...
Snowflake Demo | Snowflake Training Videos | New Batch - Jan 2nd 2025
มุมมอง 40014 วันที่ผ่านมา
#snowflake #snowflaketraining #snowflaketeaching #sql Snowflake Demo Day 1: Introduction to Snowflake Real Time Project Architecture Data Migration Project Team Members Database Creation Schema Creation Table Creation
Snowflake Time Travel || How To Restore the Deleted/Modified Data #timetravel
มุมมอง 21614 วันที่ผ่านมา
#learningvideos #trending #training What is Snowflake Time Travel : It is Snowflake Feature that allows you to Access Historical Data at any point within a Defined Period. How to access Time Travel: Query ID Timestamp Offset How to Enable/Disable TT: data_retention_time_in_days Interview Questions: How to Access Time Travel Default Table Retention Time Ways to Access Time Travel How to Enable/ ...
Top 10 Snowflake Interview Questions and Answers #snowflaketraining
มุมมอง 17914 วันที่ผ่านมา
Top 10 Snowflake Interview Questions and Answers #snowflaketraining
Snowflake Zero Copy Cloning || Does it Occupy Storage
มุมมอง 34814 วันที่ผ่านมา
Snowflake Zero Copy Cloning || Does it Occupy Storage
DBT top 50 Interview Questions and Answers - Part 5 | DBT Interview Questions
มุมมอง 27514 วันที่ผ่านมา
DBT top 50 Interview Questions and Answers - Part 5 | DBT Interview Questions
Constraints in SQL | Snowflake Constraints | Does Constraints Enforces
มุมมอง 17321 วันที่ผ่านมา
Constraints in SQL | Snowflake Constraints | Does Constraints Enforces
DBT Macro | DBT Real Time Use Case | Cloning Tables in DBT
มุมมอง 21321 วันที่ผ่านมา
DBT Macro | DBT Real Time Use Case | Cloning Tables in DBT
SQL Joins Interview Question | Number of Records for each Join | Must Watch SQL Video | #joins
มุมมอง 26921 วันที่ผ่านมา
SQL Joins Interview Question | Number of Records for each Join | Must Watch SQL Video | #joins
Snowflake Zero Copy Cloning || Does Cloning Occupies Storage
มุมมอง 23228 วันที่ผ่านมา
Snowflake Zero Copy Cloning || Does Cloning Occupies Storage
Snowflake Interview Question | Print 5 table using UDF | UDFS in Snowflake
มุมมอง 50128 วันที่ผ่านมา
Snowflake Interview Question | Print 5 table using UDF | UDFS in Snowflake
Analytical Functions in SQL | Nth Highest Salary | Row_Number Rank Dense Rank | Qualify in Snowflake
มุมมอง 32128 วันที่ผ่านมา
Analytical Functions in SQL | Nth Highest Salary | Row_Number Rank Dense Rank | Qualify in Snowflake
DBT Seeds || Snowflake DBT Seeds || DBT Seed Full Refresh
มุมมอง 268หลายเดือนก่อน
DBT Seeds || Snowflake DBT Seeds || DBT Seed Full Refresh
SQL Pattern Matching | SQL Like Operator | SQL Videos
มุมมอง 197หลายเดือนก่อน
SQL Pattern Matching | SQL Like Operator | SQL Videos
DBT top 50 Interview Questions and Answers - Part 1 | DBT Interview Questions
มุมมอง 474หลายเดือนก่อน
DBT top 50 Interview Questions and Answers - Part 1 | DBT Interview Questions
What is DBT | Data Build Tool | DBT Demo Videos
มุมมอง 280หลายเดือนก่อน
What is DBT | Data Build Tool | DBT Demo Videos
What is Null - NVL, NVL2, Coalesce - IS NULL - IS NOT NULL
มุมมอง 305หลายเดือนก่อน
What is Null - NVL, NVL2, Coalesce - IS NULL - IS NOT NULL
SQL String Functions in Snowflake | Round in SQL
มุมมอง 279หลายเดือนก่อน
SQL String Functions in Snowflake | Round in SQL
SQL String Functions in SQL | Snowflake Videos | Replace in sql
มุมมอง 335หลายเดือนก่อน
SQL String Functions in SQL | Snowflake Videos | Replace in sql
Excellent session 👏👏
AFTER INSTALLING IT ALSO I AM GETTING ERROR LIKE 'snowsql' is not recognized as an internal or external command, operable program or batch file. WHAT I HAVE TO DO IS THERE ANY SOLUTION TO IT.
Snowsql is not instaled correclty Try to isntall one more time
Thank you sir ✌
😀
any videos for snowflakes admin
As of now only Snowflake and Dbt dev profile
I'm getting error after entering the password in cmd sir
Password is case sensitive And it is not visible. Needs to enter carefully
Awesome explanation thank you for repeating main concepts.really helped
Thanks a lot
Very much helpful.. nice sessions
Thankyou Praveen
Sir the join you have mentioned seems to be incorrect For the example provided Inner will have =4 records Left will have =6 records Right will have =5 records Full will have =6 records
which data ur checking Naveen
Awsm explained
Thank you
Thank you bro for making the video
Thankyou
NEW BATCH FOR SNOWFLAKE, IAM INTERESTED, LET ME KNOW MORE DETAILS
U can reach me on 9703180969
good trainer in hyd
Thankyou so much ☺️
Good
When is next snowflake batch starting?
Today only new batch
@praveenkumarbommisetty6093 Is it ? Duration of batch , daily or weekly classes etc..
@@praveenkumarbommisetty6093 no mention in linkedin or on community here bout new batch
@@syedkamran4121 ping me on 9703180969
cost?
Reach on 9703180969
Sir, what is the future growth of Snowflake? I am a middleware admin looking for an opportunity in Snowflake. Please suggest. 😊
Snowflake and Dbt is having good demand in the market
Hi sir,is it a course?
Reach on 9703180969
How yo enroll ? Where can i find course information
Reach me on 9703180969
snowflake interview questions kuda video cheyandi sir..
Upload chesanu check cheyandi
@praveenkumarbommisetty6093 thank you sir
Nice explanation
Thank you
DBT course fees please
5000
<3
you are wrong on UNION vs UNION ALL. UNION only returns a unique record, while UNION ALL returns all the records (including duplicates)
Joins లో ఏ ఏ joins ఏ ఏ scenarios లో వాడుతారు ఏ cases లో వాడుతారు దీని గురించి కొద్దిగా కొన్ని videos chesthe బాగుంటుంది examples తోటి praveen గారూ!
❤❤❤❤❤❤❤❤
it's very much understandable video thank you for sharing
Thank you
Listagg is in Oracle, ain't it? MS SQL Server has STRING_AGG.
Yes correct
excellent explanation with real-time tools. It's very helpful to new joiners. Good.
Thankyou
Can you share the PPT?
Ping me on 9703180969
Thanks for posting. It's really helpful
Thankyou sonu
Very nice 🎉
God bless her❤❤❤❤
Thanks lakshmi
Please teach PLSQL topics
Sure ranjan
what is the fee?
5000
🎉🎉🎉❤❤❤
Thankyou Jay
Overloading 😂
Superb 🎉🎉🎉🎉❤
How to do this incrementally , only new files
How decode (1,2,3,4,5,6) output is 6
Correct
How Temporary table have by default retention period is one day?? it is not possible.
Create table and see in show tables
Fantastic ❤🎉🎉 take above
Thankyou
All doubt cleared
Nice
Do you have any group
Reach on 9703180969
Sir,Can you share the demo link to attend
Hi
notes please?
For training candidates only Notes will be shared
How many days Snowflake+dbt training
Reach on 9703180969
Praveen garu some doubts please explain me
Yes tell me
Very nice 👍 explanation
Thanks Bharathi
👍
Way of teaching is best
Thanks Ghouse