- Видео 31
- Просмотров 38 688
Tech And Talk
Индия
Добавлен 17 сен 2023
🚀 Welcome to Tech and Talk with Nikhil Kurkure! 😊
👨💻 I'm Nikhil Kurkure, Passionate Full Stack Developer and Architect with over 10+ years of experience. I specialize in Microsoft. NET technologies, cloud platforms (AWS, Azure Google), SQL/NoSQL databases. I excel in building enterprise applications and bring valuable experience in AI, ML, and ETL processes.
On this channel, we cover:
💻 Full Stack Development with .NET technologies
☁️ Microservices
📊 Databases (MSSQL, PostgreSQL, MongoDB, PL/SQL, Oracle SQL)
☁️ Cloud Technologies (AWS, Azure, Google Cloud)
🐳 Containerization (Docker, Kubernetes)
🛠️ Software Development Life Cycle (SDLC)
Join our thriving tech community for insightful tech talks and stay updated with the latest tech news.
Our motto is simple: 'Learn Tech, Grow Skills, Stay Patient.' 🌱
Join us on this journey to master new programming languages, conquer cloud computing, and stay ahead in tech.
Hit 'Subscribe' and let's embark on this adventure together. 🚀💻📚👨💻
👨💻 I'm Nikhil Kurkure, Passionate Full Stack Developer and Architect with over 10+ years of experience. I specialize in Microsoft. NET technologies, cloud platforms (AWS, Azure Google), SQL/NoSQL databases. I excel in building enterprise applications and bring valuable experience in AI, ML, and ETL processes.
On this channel, we cover:
💻 Full Stack Development with .NET technologies
☁️ Microservices
📊 Databases (MSSQL, PostgreSQL, MongoDB, PL/SQL, Oracle SQL)
☁️ Cloud Technologies (AWS, Azure, Google Cloud)
🐳 Containerization (Docker, Kubernetes)
🛠️ Software Development Life Cycle (SDLC)
Join our thriving tech community for insightful tech talks and stay updated with the latest tech news.
Our motto is simple: 'Learn Tech, Grow Skills, Stay Patient.' 🌱
Join us on this journey to master new programming languages, conquer cloud computing, and stay ahead in tech.
Hit 'Subscribe' and let's embark on this adventure together. 🚀💻📚👨💻
ROW_NUMBER, RANK, and DENSE_RANK In SQL Explained | Tech and Talk
In this episode of Tech and Talk, dive deep into the world of SQL window functions! Learn everything you need to know about ROW_NUMBER, RANK, and DENSE_RANK functions, including how they work, their differences, and practical use cases. Whether you're a beginner or an experienced SQL user, this video will enhance your understanding of window functions and empower you to write more efficient and powerful SQL queries. Watch now and level up your SQL skills!
#sqltips #WindowFunctions #ROW_NUMBER #RANK #DENSE_RANK #TechAndTalk #SQL #WindowFunctions #ROW_NUMBER #RANK #DENSE_RANK #TechAndTalk
Subscribe Link:
ruclips.net/channel/UCrhNezSLNCAojblfC0MSihg
#sqltips #WindowFunctions #ROW_NUMBER #RANK #DENSE_RANK #TechAndTalk #SQL #WindowFunctions #ROW_NUMBER #RANK #DENSE_RANK #TechAndTalk
Subscribe Link:
ruclips.net/channel/UCrhNezSLNCAojblfC0MSihg
Просмотров: 309
Видео
Installing Node.js on Windows: A Beginner's Guide | Tech and Talk
Просмотров 257 месяцев назад
Welcome to Tech and Talk! In this video, we'll walk you through the process of installing Node.js on Windows, step-by-step. Whether you're new to programming or an experienced developer, Node.js is a powerful tool that can enhance your web development projects. In this tutorial, we'll cover: How to download the Node.js installer for Windows from the official website. Step-by-step instructions f...
How to Practice SQLs Without Creating Tables in a Database? | SQL Tips and Tricks
Просмотров 2487 месяцев назад
Are you looking to sharpen your SQL skills but hesitant to create tables in your database? In this video, I've got you covered! Join me on Tech and Talk as I walk you through three ingenious ways to practice SQL without cluttering your database with unnecessary tables. Temporary Tables: Learn how to create temporary tables that exist only for the duration of your session. I'll demonstrate how t...
Top 10 Interview Question in SQL : Step by Step Approach for Writing Stored Procedure
Просмотров 5678 месяцев назад
Welcome to Tech and Talk! In this video, we dive deep into SQL Stored Procedures, covering the top 10 must-know interview questions and providing a step-by-step approach for writing them. Whether you're preparing for an interview or looking to enhance your SQL skills, this video has got you covered. 🔍 In this video, we answer key questions including: 1.What is a Stored Procedure and why do we n...
Top 10 SQL Interview Questions Answered: Understanding Transactions Locking
Просмотров 6668 месяцев назад
In this video, we delve into the fundamental concepts of SQL transactions and transaction locking. We explore why SQL transactions are necessary for ensuring data integrity and consistency in databases, along with real-life use cases where transaction locking is crucial. Learn how to initiate, maintain, and manage transactions in SQL, including rollback procedures and handling uncommitted recor...
SQL Interview Question Answered: 10 Must-Know Questions Answered on SQL Functions
Просмотров 1,7 тыс.8 месяцев назад
Unlock the secrets of SQL Functions with this in-depth video covering essential concepts and practical applications. From understanding the purpose of SQL Functions to exploring real-world examples, you'll gain insights into built-in functions, aggregate functions, and the significance of user-defined functions. Dive into the world of scalar functions, table-valued functions, and discover the a...
Top 10 SQL Interview Questions: Basic to Pro Sql Views Simplified
Просмотров 3,8 тыс.8 месяцев назад
Welcome to Tech And Talk! 🚀 In this video, we embark on a journey from Basic to Pro in SQL Interview Questions, focusing on simplifying the intricacies of SQL Views. Whether you're a beginner or an experienced SQL enthusiast, these insights will help you navigate through common interview scenarios with confidence. 🔍 Interview Questions Covered: 1.What is View? Why do we need it? 2.How to modify...
SQL Views Essentials: From Basics to Interviews, Everything You Need to Know
Просмотров 8769 месяцев назад
Welcome to TechAndTalk! 🚀 In this video, we delve into the fascinating realm of SQL views, covering everything from the basics to advanced concepts. Whether you're a beginner looking to understand what views are or an experienced developer aiming to enhance your SQL skills, this video has something for everyone. 🔍 Topics Covered: Understanding the fundamentals of SQL views Exploring the reasons...
Database Tree Problems in SQL : Unlock the Power of Self Join
Просмотров 3949 месяцев назад
🌐 Dive into the intricate world of Database Tree Problems in SQL with our latest video at Tech and Talk! 🚀 Unlock the Power of Self-Join as we explore the fundamentals, use cases, and practical applications of self-joins in SQL. From building family trees to navigating hierarchical structures, we've got you covered. Whether you're a SQL enthusiast or prepping for an interview, this video is you...
SQL Interview Questions: Real-Time Scenarios & Aggregate Function Tips
Просмотров 9 тыс.9 месяцев назад
Welcome to "SQL Interview Questions: Real-Time Scenarios & Aggregate Function Tips"! 🚀 In this video, we'll explore essential SQL interview questions focusing on real-time scenarios and tips for mastering aggregate functions. Whether you're a seasoned pro or just getting started, these insights will elevate your SQL interview game. 🔍💼 Question List: 1.Calculate the total number of employees? 2....
The Expert Guide to AGGREGATE FUNCTION in SQL - Count, SUM, AVG, MIN, MAX | Group By | Having
Просмотров 2189 месяцев назад
🚀 Welcome to Tech and Talk! 🎓 The Expert Guide to AGGREGATE FUNCTION in SQL Mastering AGGREGATE FUNCTIONS is essential for data analysis and reporting in SQL. In this video, we dive deep into the world of SQL aggregates, exploring powerful functions like COUNT, SUM, AVG, MAX, and MIN. 📊✨ 🔍 What's Covered: Understanding the role of aggregate functions. In-depth explanations and examples for each...
Cracking Interviews: Top 15 SQL Interview Questions and Answered | Joins Secret
Просмотров 6 тыс.10 месяцев назад
"🚀 Ready to crack your SQL interviews? Join us at Tech and Talk as we dive deep into the top 15 SQL interview questions! Whether you're a beginner or a seasoned pro, these questions cover everything from SQL Joins to Cartesian Products. We provide real-time examples, practical insights, and tips to help you ace your next database interview. Watch now and boost your SQL skills! 💻🔍 Questions Cove...
Most Asked Interview Question For beginner | Truncate Table vs. Drop Table
Просмотров 34010 месяцев назад
🚀 Welcome back to Tech and Talk! In this SQL tutorial, we're tackling a fundamental question for beginners: Truncate Table vs. Drop Table. If you've ever wondered when to use one over the other, this video is for you! 📌 Truncate Table: Ever wanted a fresh start with your table but didn't want to delete the entire structure? Truncate Table is your go-to. Learn the simple syntax and when to apply...
Mastering SQL Joins: A Simple Guide for Beginners | Tech and Talk
Просмотров 79411 месяцев назад
Welcome to Tech and Talk! 🚀 In this video, we're breaking down the complexities of SQL Joins, making it easy for beginners to understand. Join us as we explore the four main types of SQL Joins - INNER JOIN, LEFT JOIN (also known as LEFT OUTER JOIN), RIGHT JOIN, and FULL JOIN (also known as OUTER JOIN). 🔍 What You'll Learn: The purpose of SQL Joins and why they're crucial in database management....
How to Apply Constraints on an Existing table? | SQL Tips | Tech and Talk
Просмотров 59411 месяцев назад
In this informative video, we explore the essential topic of applying constraints to an existing SQL table. Constraints play a crucial role in maintaining data accuracy and integrity within a database. Join us as we delve into the world of SQL constraints, covering primary key, unique, check, and foreign key constraints. We provide practical, step-by-step examples to guide you through the proce...
Broo if there is each keyword We also use inner join Yes or No broo
very good information shared
Nicely explained.
Thanks bro👍🏻
Most welcome 🤗
Waste of Time 😒
May I know what your expectations here?
Pls make a video on sql relationship with example
😉 Promo SM
Thank you
You're welcome
Please make Master tables View Primary kay Create Master Table or Main Tables
Bro please upload sql videos more
Thanks for the suggestion! It sounds like you're interested in learning how to create a master table with primary keys. I'll make sure to cover that topic in an upcoming video tutorial. Stay tuned for more content!
Bro pls upload classes about stored procedure and triggers
Hey there! Thanks for your interest in learning about stored procedures and triggers. I appreciate your support! I'm currently working on creating classes on these topics, and I'll be uploading the video very soon. Stay tuned and thank you for your patience
yes we can write the user defined function create function function_name return begin end
Thanks for the video ❤ It boosts my confidence
🌟 Thank you for the support! 🌟
sir please upload stored procedure and subquery question related.
Thank you for your suggestion! I appreciate your interest. I'm currently working on creating a detailed video covering stored procedures and addressing various query questions. Stay tuned, as I'll be uploading it very soon 😊
can you please make video on sub-queries by writing complex sub-queries and tell us how does it get executed i mean way of execution of subqueries or sequence of execution in subqueries and performance optimization (regarding performance optimization i have no idea)
Please check out the post I have answered in the post section with details
i did able to find about performance optimization but not able to find about sub-queries@@TechAndTalkConnect
i have a question:- suppose i have to fetch data in my db like mysql daily at fixed time suppose at morning 7 am what kind of query should i write so it can fetch data at that time automatically i think i need to use even schedule but how to schedule it for that specific time. is it possible to do that
please refer the post for this question. I have explained in details what steps you should have to refer for Schedule.
@@sumitchaudhari5815 Please refer the community post URL ruclips.net/channel/UCrhNezSLNCAojblfC0MSihgcommunity?pvf=CAE%253D
what's keyword and function in sql
I am glad that i found your channel. plz do more videos on sql, like how to write queries , interview questions on topic wise sql. queries asked in interview, how to learn query writing with logics. plz . Thank you
Thank you so much for your kind words and support! I'm thrilled to hear that you're finding value in the content. I'll definitely take your suggestions to heart and work on more SQL-related videos, including topics like query writing, interview questions, and logical approaches. Stay tuned for exciting and informative content ahead!
Good explanation, please one more concept stored procedure and sub query . Please sir
Thank you so much for your positive feedback! I'm thrilled to hear you found the explanation helpful. I appreciate your suggestion and I'm working on creating content about stored procedures and subqueries. Stay tuned to Tech and Talk for more exciting content! Your patience is much appreciated
@@TechAndTalkConnect Tq u Sir
Useful Video....thank u..
Thank you for your kind Word ☺️
what is the indexes and how to use
I appreciate your suggestion and I'm working on creating content about index and how we can effectively use them. Stay tuned to Tech and Talk for more exciting content! Your patience is much appreciated
Please make a interview video on stores procedure
I appreciate your suggestion and I'm working on creating content about stored procedures. Stay tuned to Tech and Talk for more exciting content! Your patience is much appreciated
Thank you so much
thank you, i had question in interview could you please solve this issue, "as a sql developer if you will face the issue on front end to get the data takes lot of time , but in backend sql code, indexes and performance all is good, then how you will solve the issue as a sql developer"
Thanks for your insightful question. Please check out post it will help you to tackle this type of questions
Awesome, Could you please make videos how to store data from front end to back end , and how works sql server database
Thank you for the awesome feedback! I'm glad you're interested in a video on storing data from frontend to backend and understanding SQL Server Database. I'm already working on creating a detailed tutorial for you. It might take a bit of time to ensure it's comprehensive and clear. Stay tuned to Tech and Talk for the upcoming video! Your patience is greatly appreciated.
Awesome🙂
Thank you 😊
Create view max_salary As Select dept_name,max(salary) from employee Group by dept_name;
Could you Plz share data set.
thanks for comment please refer the dataset scripts from this link: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link
Create view Total_Salary As Select Max(Salary),dep_name from departments group by dep_name;
Great 👍 please make a video on most asked interview questions for Fresher Data Analyst.
Thank you! I appreciate your suggestion. I'll work on a video covering the most asked interview questions for fresher data analysts. Stay tuned!
if u provide the dataset then it is much more useful to us
thanks for comment please refer the dataset scripts from this link: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link
Create view max_dept as select dept_name ,max(salary) from emp group by dept_name;
Thank you bhava
Welcome 🤗
Everyone is telling basics .....but no one in youtube have guts to touch sql...performance
Thanks for the comment! Get ready for some exciting videos showcasing skill performances!
Thank you for the video bring more such videos
More to come!You're welcome! I'm thrilled you enjoyed the video. More similar content is on the way. Stay tuned for upcoming videos!
Impressive work and well taught. Hope to see more advanced sql material.
Thank you for your positive feedback! I'm glad you found the content helpful. I appreciate your suggestion for more advanced SQL material. Stay tuned for upcoming videos!
please release videos every day, your explanation is good, please explain about CTE, Temp Tables, Table Variables, Temp Variables,
Thank you so much for your kind words and encouragement! I truly appreciate your support. I'm glad you find the explanations helpful. Creating videos on CT, temp tables, table variables, and temp variables sounds like a great idea, and I'll definitely add them to my content plan. While I may not be able to release videos every day due to work commitments, I'll do my best to bring you valuable content as frequently as possible. Stay tuned, and thanks again for being a part of the community!
QUERY FOR Q 10: SELECT 'non_mgr' as avg_sal ,AVG (Salary) avg_sal FROM Employees WHERE EmployeeID NOT IN (SELECT ManagerID FROM Employees WHERE ManagerID IS NOT NULL) UNION all SELECT 'mgr' as avg_sal ,AVG (Salary) avg_sal FROM Employees WHERE EmployeeID IN (SELECT ManagerID FROM Employees WHERE ManagerID IS NOT NULL)
Thank you for sharing your query! It's great to see different perspectives. Your approach is valid, and it's interesting to explore SQL scenarios from various angles. Appreciate your contribution to the discussion! Happy coding
10.Calculate the average salary for managers and non-managers? THERE IS NOT ONLY ONE MANAGER, EVERY EMPLOYYE HAS A MANAGER FIRST WE HAVE TO INNER JOIN THEN TAKE AVG SALARY I THINK. .. BUT U TOOK ONLY FOR ONE MANAGER WHY? I THINK ITS WRONG QUERY.
Thanks for pointing that out! Your observation is spot-on. When I crafted this question, my intent was to identify the 'ultimate manager' (like John Doe) and treat others as managers of lower-level employees- so it won't be the ultimate manager so we are considered as Non manager. It's more about the hierarchy in management. I appreciate your perspective, and your understanding aligns with a different interpretation, considering them as non-managers. SQL scenarios can indeed have various valid interpretations. If you have more insights or if there's anything specific you'd like to explore, feel free to share. Happy coding!
Amazing video sir,👌
Thank you for watching and expressing your appreciation 😊
Helpful, Thanks :)
You're welcome! I'm glad you found it helpful☺️
Anything for 2 3 yr exp.
Thank you for your comment! For specific tips on interviews with 2 to 3 years of experience, you might find valuable insights in my dedicated interview playlist: [Interview Playlist](ruclips.net/p/PLFXSOrOKP0AreAxv3CJksu2f6_rI3LACl&si=M4246tn-h_uTSIKA). Feel free to check it out, and if you have any more questions, don't hesitate to ask!
Ur explanation is very clear pls upload sql interview perspective questions it's very useful for all candidates It's my request
Thank you for your kind words! I appreciate your support. If you're interested in more interview-related content, check out my interview playlist where I regularly upload SQL interview questions. Here's the link: ruclips.net/p/PLFXSOrOKP0AreAxv3CJksu2f6_rI3LACl&si=ccwk-I7O9VRwYsUc
Can you share the important SQL must do questions from platforms like leetcode, stratascratch, data lemur etc in one video to watch before every interview
Thanks for your suggestion! Creating a video on important SQL questions from platforms like LeetCode, Startscratch, Data, and Lemur is a great idea. I'll definitely work on that and share it soon. Stay tuned for the comprehensive video to boost your SQL interview preparation!
Bhai please upload videos related to interview preparation for a Data Analyst role covering SQL, Python, Power BI and Excel .
Thank you for your feedback! I appreciate your suggestion for interview preparation videos for a data analyst role covering SQL, Python, Power BI, and Excel. I'll prioritize creating content that caters to your needs. Stay tuned for detailed tutorials, and feel free to ask specific questions on any topic you'd like more guidance on. Happy learning!
Very informative
Thank you 😊
Google Drive link for Scripts: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link
Nice
Thanks for your comments ☺️