- 478
- 118 505
Tech Nest Academy
India
Приєднався 8 чер 2012
Welcome to TechNest Academy, your one-stop destination for mastering the art of data-driven decision-making! Whether you're a beginner looking to jumpstart your career or a seasoned professional aiming to enhance your skills, we've got you covered with a comprehensive range of courses.
📊 SQL: Dive into the world of structured query language and learn how to manipulate and extract valuable insights from databases.
🐍 Python: Harness the power of Python for data analysis and automation.
📈 PowerBI: Transform raw data into stunning visuals and interactive dashboards.
📊 Tableau: Create captivating data visualizations and share insights seamlessly.
📈 Excel: The indispensable tool for data analysis and reporting.
📊 Data Analytics: Develop a deep understanding of data analysis techniques, statistical tools, and data-driven decision-making.
Join us today and embark on your journey towards becoming a data expert.
📞 Mobile: +91 8056187685
📧 Email: technestacademy147@gmail.com
📊 SQL: Dive into the world of structured query language and learn how to manipulate and extract valuable insights from databases.
🐍 Python: Harness the power of Python for data analysis and automation.
📈 PowerBI: Transform raw data into stunning visuals and interactive dashboards.
📊 Tableau: Create captivating data visualizations and share insights seamlessly.
📈 Excel: The indispensable tool for data analysis and reporting.
📊 Data Analytics: Develop a deep understanding of data analysis techniques, statistical tools, and data-driven decision-making.
Join us today and embark on your journey towards becoming a data expert.
📞 Mobile: +91 8056187685
📧 Email: technestacademy147@gmail.com
SQL Interview Question
Below question posted by me on Linkedin was discussed during todays session.
www.linkedin.com/posts/mohammad-tanweer-khan-6ba27953_sql-sqltraining-dataanalyst-activity-7280076768386953216-f1jn?
www.linkedin.com/posts/mohammad-tanweer-khan-6ba27953_sql-sqltraining-dataanalyst-activity-7280076768386953216-f1jn?
Переглядів: 14
Відео
S30 Day1
Переглядів 4612 годин тому
We have started a new SQL weekday evening batch on 01st Jan 2025. Below is the course detail. Mon-Fri 6:15pm-7:15pm IST Duration: Approx 1.5 months Interested folks are requested to connect on the below number. 91 8056187685
S30 Batch
Переглядів 5314 годин тому
We have started a new sql weekday evening batch today(01st Jan 2025). Those who are interested to join the course can connect with us on the below number. 91 8056187685 Course Details: Mon-Fri 6:15-7:15pm IST Duration: Approx 2 months Fees: Rs.4000
S29 Demo
Переглядів 28521 день тому
Topics Covered Today(12th Dec): 1. What is a table? 2. What are rows and columns? 3. How to create a table? 4. How to insert data in a table? 5. How to display data? 6. How to filter data?
Types of Load
Переглядів 104Місяць тому
Topics Covered Today: Historical Load Full Load Incremental Load
"Step-by-Step Guide to Registering on Graphy "
Переглядів 46Місяць тому
"Step-by-Step Guide to Registering on Graphy "
Excel from scratch to advance _ Demo Session
Переглядів 70Місяць тому
Excel from scratch to advance _ Demo Session
SQL _ 1. IN 2. Difference between 0,blank and NULL 3. IS NULL (07-11-2024)
Переглядів 1072 місяці тому
SQL _ 1. IN 2. Difference between 0,blank and NULL 3. IS NULL (07-11-2024)
SQL _ 1. Upper 2. Lower3. And _6-11-2024
Переглядів 722 місяці тому
SQL _ 1. Upper 2. Lower3. And _6-11-2024
SQL DEMO _ Master SQL from Scratch in 30 days.
Переглядів 2552 місяці тому
SQL DEMO _ Master SQL from Scratch in 30 days.
Python _Session #1: Let’s Get Started!
Переглядів 1432 місяці тому
Python _Session #1: Let’s Get Started!
Python from Scratch to Expert | Weekend Course Demo | Learn Python the Right Way!
Переглядів 4612 місяці тому
Python from Scratch to Expert | Weekend Course Demo | Learn Python the Right Way!
Please add me to the group.
Please whatsapp us on the below number +91 8056187685
good expiations
Best video, clear and straight forward.
@@SAURAVVISHNUGITTE Thanks a lot
Thank you very much for this session Tanweer Sir.
Thanks sir, you are best
Thanks Vijay
pl provide practice files.thankyu
Currently i am working as a Oracle databases developer with 10 yrs exp so to boost the profile which technology or language should be learn?
You should learn Data Engineering skills.
@@technestacademy490 means python, snowflake,power bi
Tanweer is very good teacher and he explains SQL in a way that you can easily understand in simple language and in extreme depth ..he make sure no corners are left behind.. just imagine 40+ hrs content so how much depth it would be ... Best teacher for SQL I have ever seen.😊
Thanks a lot Ronak
Superb explanation 🎉
Great
looking forward for a session on RANGE Tanweer Sir.
Sure Naveen.We will take a session on Range shortly.
Superb explanation 🎉
Very informative and easy to understand...Thank you!
Thanks a lot Aarti You can connect with us on the below number if interested to enroll for the course. +91 8056187685
Great session looking forward for upcoming excel videos
This was the demo class. Please connect with us on the below number in order to enroll for the course. 8056187685
@@technestacademy490 Mobile no. to enquiry about other courses ?
Devise powered by source.?
Sir ur not visible
Great Session Tanweer Sir Appreciate your effort for putting such insightfull videos Your content is quality rich Learned a lot watching your videos
Thanks a lot
Great video! How about the dataset used so one can follow up with the practice?
Wonderful way of teaching ma'am 👌
@Tanweer please provide table script also in the video description for viewers engagement and practice.
Thats a good suggestion Tushar.We will implement it.Thanks a lot for your suggestion.
How to join
Please connect on the below number +91 8056187685
This is the best PBI tutorial I have watched till now so much information and imp details in one session only…thankyou so much.
Thanks a lot
other approach: with cte as( select val,val%10 as rem,val/10 as new from input union all select val,rem+(new%10) as rem, new/10 as new from cte where new>0 ) select val,max(rem) as [sum(id)] from cte group by val
Good to see Tanweer Sir doing in Camera session.
Thanks a lot Naveen.We have to work a lot on moving the quality of video.
Write a SQL query to find the txnmonth which has the maximum txnamount. create table eshop(txnmonth varchar(50),clothing varchar(50),electronics varchar(50),sports varchar(50)); insert into eshop values('Jan',2000,1500,3000); insert into eshop values('Feb',1000,2500,4000); insert into eshop values('Mar',2000,1400,1000); insert into eshop values('Apr',3000,1500,1000);
Thanks a lot Tushar.I appreciate your idea of including Table Script and will implement the same down the line.Thanks a lot again !
Hello Sir, It was very Interesting Question Thanks for the question. However I have doubts How we can includes nulls using SQL Server?
Bro you are 1 year behind. Nowadays everyone knows about ChatGPT and how it works😅
Clear step by step explanation Thankyou for the scenario. Kindly do more scenarios like this so that we will get more helpful in getting a proper job sir.
Thanks a lot Sreekanth
Your instruction and guidance are truly outstanding.
Thanks a lot
Tanweer please keep this short video content so that we can reach to more and more people who really need to understand how sql works internally. Awesome content as always. Looking forward to more short videos.
Thanks a lot Tushar!
very well explained 🙂
Thank you 🙂
Very well explained
Thanks for liking
Good Informative Video
Thanks a lot
Twas an interesting classs
Please connect on below number if interested to join this course. +91 8056187685
Kids are too smart 😃
Well explained tutorial.. Good Job
Thanks a lot
It's a very interactive as well as knowledgeable session. Tremendous effort to teach kids programming language!
When is the next batch of Power BI is starting?
Tanweer that was amazing session. Thank you for sharing details :)
Thanks a lot Naveen
Great Content !Thanks for sharing
Truly inspiring.
Indeed
Great journey congrats tanweer sir and Anil ❤
Thanks a lot Peter
Insightful
Great Content !
Thanks for sharing! Great Content !
Great share and well explained.
Amazing content .
Amazing content
Great content and well explained !