Another amazing video. Just one point though, I believe the ANSI standard in the video is called ANSI-92 standard which introduced the JOIN and ON clauses. And the non ANSI one is called ANSI-89 standard where tables are listed in FROM clause and filters on PK and FK are specified in WHERE clause.
First time read ANSI and non ANSI method . It was good to know . First time from your example understood that without using join keyword tables can be joined via. Non ANSI way . Looking forward to have more learning on SQL , Python . If possible , please give some database and problem statement which users like me will try to solve in 4 to 5 days and after that you can explain that in video form . It will be form of active learning . Thank you very much . You are doing great work.
Whenever I found some time I regularly watch your videos... Everyday I'm learning new things... Excellent Teaching... Need some clarification over different kind of locks
Hii, Thoufiq hope you are fine. This the first time I got to know that terms like ANSI n NON-ANSI also exists. Thank you Thoufiq for delivering the best content through your videos you never disappoint us. Looking forward for your advance Sql sessions.
I recently discovered your channel! Let's get connected! I have a passion for SQL and actually I learned how to understand and troubleshooting plus 20 years ago and we were using TOAD. Until so far I never created a query by my self but I used the reports but needed to understand if there was an error in the reports. I need to do an assessment and need to write SQL query which will be validated against the database. I will have to use only basic ANSI SQL statements
Hey there, glad to meet again. I am working my way around sql language and still have one major enquiry. Should i care about if a database is ANSI SQL compliant? If an implementation is not completely compliant shall i read the documentations from ansi or should i work only within the boundaries of the dbms and ignore ansi. Thanks a lot for taking care of this.
Hi Toufiq, Thanks for explaining the concepts in detail. I have been learning from your channel since last one month and all your explanation videos are worth watching. I have one request, can you please upload an explanation video on stored procedures (pl/sql)as well? Thanks in advance
Yes some do. And personnaly i find non ansi much easier to read. All the tables used in the from clause. All the where clauses in the same place. No concept of right or left you order le clause as you see fit so for equijoin the plus on the right is much more visible. The online views are alqo much more visible. As working on oracle i will never go back to ansi
You are good!!! Keep going with videos like this and perhaps in the future you will do others with solving different problems as you have done in the past. All the best!
Thanks for the video man, really awesome material, just one QQ, I'm used to work on postgre and mySQL, Oracle, but now I landed a job with a company that heavily uses MS SQL Server (not my favorite engine) still, are all of this concepts, also CTE applicable to this RDMS? thank you.
thank you buddy. And yes MSSQL is very similar to any other RDBMS. 90% of concepts will be common. there may be some minor changes in some of the syntax and some additional functions. But will not be major difference
Can you please explain why right join was used to join the manager table to employee table. Why not left join since the employee table is the reference table. Thanks
Hi, can you share table data as well? And I also would like to tell you that I was able to clear the interview for a data analyst at Delhivery today. Your video helps a lot. I will let you know if I get the offer letter. and also can you share good resources for learning google data studio?
I really want to practice questions on subqueries and joins but I can't find it anywhere for free. I have tried everywhere, please suggest some good places where I can get good practice questions. Currently I m pursuing data science course.
Could make a real-life project from the beginning to end .how to handle stakeholders, what are the questions should we ask, how to structure the problem, how to find the data, how to analyse, how to create a report and whatnot
Not really aware of such courses bro but I do conduct some live sql training sessions and will be announcing the next one pretty soon.. other than these the courses on LearnSQL are pretty good too
Visit brilliant.org/techTFQ/ to get started learning STEM for free, and the first 200 people will get 20% off their annual premium subscription.
Can you make a video on Cursors and Dateformats of changing UNIX Timestamp to Date conversion
The best SQL tutor , sound knowledge , good voice and great explanation .
Thank you very much Chanu :)
Another amazing video. Just one point though, I believe the ANSI standard in the video is called ANSI-92 standard which introduced the JOIN and ON clauses. And the non ANSI one is called ANSI-89 standard where tables are listed in FROM clause and filters on PK and FK are specified in WHERE clause.
Thank you Vickar :)
and yes you are right
First time read ANSI and non ANSI method . It was good to know . First time from your example understood that without using join keyword tables can be joined via. Non ANSI way .
Looking forward to have more learning on SQL , Python . If possible , please give some database and problem statement which users like me will try to solve in 4 to 5 days and after that you can explain that in video form . It will be form of active learning .
Thank you very much . You are doing great work.
Thank you Ashutosh and noted on the suggestion.. am already thinking about it
Whenever I found some time I regularly watch your videos... Everyday I'm learning new things...
Excellent Teaching...
Need some clarification over different kind of locks
Thank you Karthick :)
and noted on the request
As always you add value to people's lives by making learning easy👌🏻 Kudos.. Keep going.. MashaAllaah🥰
Thank you ❤️
Please @TECHTFQ make a video on INDEXES.
It might take a day for you but it will Help many many people. Just a suggestion. Thanks
Noted Raghav, It's in my list of videos. will make it
Hii, Thoufiq hope you are fine. This the first time I got to know that terms like ANSI n NON-ANSI also exists. Thank you Thoufiq for delivering the best content through your videos you never disappoint us. Looking forward for your advance Sql sessions.
Thank you Agrim 🙏🏼
Glad this helped
I guess this is not used in MySQL n SQL server...it confused me
I recently discovered your channel! Let's get connected! I have a passion for SQL and actually I learned how to understand and troubleshooting plus 20 years ago and we were using TOAD. Until so far I never created a query by my self but I used the reports but needed to understand if there was an error in the reports. I need to do an assessment and need to write SQL query which will be validated against the database. I will have to use only basic ANSI SQL statements
Awesome!!!! Very useful... Clear details given. Thanks
Awesome bro in seeing thumbnail only i got to know ANSI vs non ANSI
Thanks buddy
Hey there, glad to meet again.
I am working my way around sql language and still have one major enquiry.
Should i care about if a database is ANSI SQL compliant? If an implementation is not completely
compliant shall i read the documentations from ansi or should i work only within the boundaries of the dbms and ignore ansi.
Thanks a lot for taking care of this.
The way of explanation is easily understandable..Can you recommend some books for SQL..That will be appreciated.
Thank you 🙏🏼
Regarding books, I’ll need to do some research bro
Introduction to database system by c.j dates
Please upload 1 video related to SQL on Every Saturday morning ❣️
Hi ,
from where i can get create tables and insert query so we can do practice easy
As usual , Loved it👌🏻👍🏻 Keep posting such awesome content brother🤩
Thank you bro 😍
Hi Toufiq,
Thanks for explaining the concepts in detail. I have been learning from your channel since last one month and all your explanation videos are worth watching. I have one request,
can you please upload an explanation video on stored procedures (pl/sql)as well?
Thanks in advance
Thank you Shubham 🙏🏼
Glad you liked my videos..
I will cover procedure video very soon
You truly are amazinggggg!!!
Thank you :)
thanks for the explanation. Are people using the Non-ANSI way of queries anymore?
Yes some still do .. especially the ones who use oracle ..
Yes some do. And personnaly i find non ansi much easier to read. All the tables used in the from clause. All the where clauses in the same place. No concept of right or left you order le clause as you see fit so for equijoin the plus on the right is much more visible. The online views are alqo much more visible. As working on oracle i will never go back to ansi
You are good!!!
Keep going with videos like this and perhaps in the future you will do others with solving different problems as you have done in the past.
All the best!
Thank you 🙏🏼 n will do
what about full outer join in non-ANSI model.
you classes soo good.
Thanks for the video man, really awesome material, just one QQ, I'm used to work on postgre and mySQL, Oracle, but now I landed a job with a company that heavily uses MS SQL Server (not my favorite engine) still, are all of this concepts, also CTE applicable to this RDMS? thank you.
thank you buddy.
And yes MSSQL is very similar to any other RDBMS. 90% of concepts will be common. there may be some minor changes in some of the syntax and some additional functions.
But will not be major difference
Can you please explain why right join was used to join the manager table to employee table. Why not left join since the employee table is the reference table.
Thanks
Hi, can you share table data as well? And I also would like to tell you that I was able to clear the interview for a data analyst at Delhivery today. Your video helps a lot. I will let you know if I get the offer letter. and also can you share good resources for learning google data studio?
I’ll share the scripts in discord..
So happy for you and thank you.. glad my videos helped..
And will consider your request
love your method so much. can next video cover for hierarchy tree please?
Thank you and I’ll consider it
Hi Thoufiq, hope you are doing well. I want to learn about pl sql. Can you please make a video on that topic please . Thanks
I’ll cover that in the future ..
Informative
Next please make a detailed video on Stored procedure.
Yes planning on it
Please suggest some places where I can get good practice questions for sakila or any other pre-installed database in MySQL.
StrataScratch is good
Nice concepts, if u have more time, please make video on power bi. I will be thank for u👏👏👌👌👌
Noted bro, perhaps in the future
which platform do you use for sql
I really want to practice questions on subqueries and joins but I can't find it anywhere for free.
I have tried everywhere, please suggest some good places where I can get good practice questions.
Currently I m pursuing data science course.
You can look at the free sql questions available on StrataScratch and LeetCode
Can you please make some videos on how to combine SQL and python to manipulate data from scratch
Noted, i'll make some projects using both in the near future
Thanks for nice explanation
Could make a real-life project from the beginning to end .how to handle stakeholders, what are the questions should we ask, how to structure the problem, how to find the data, how to analyse, how to create a report and whatnot
I’ll try bro
@@techTFQ do you think a data analyst can get into a product manager role. Is it possible for?
Yes it is possible …
For full join can we put (+) on both side
This is also called as implicit and explicit method of join. Am I right, if not correct me.
TANKS A LOT ............
Your welcome 🙏🏼
Guys, where can I dinf the scripts w/ the insert statements for this video, to practice on my local, thanks
you can join my discord and request there.. ill share it over there
@@techTFQ Will do for sure thanks mate
Nice sir..
Thank you 🙏🏼
Hi
can you Stored procedures videos
Yes will do it soon
nailed it
Thank you 🙏🏼
Hii sir...I want to join for the classes you are going say for next upcoming dates .for 25 queries ua going solve
..I need tht link sir...
You can go to my channel and find the community post with all the details about the class.
Or just go to Lighthall and register for my class directly
Hi Toufiq, I am actually looking for an advanced SQL real-time course, Can I get more info regarding this?
Not really aware of such courses bro but I do conduct some live sql training sessions and will be announcing the next one pretty soon..
other than these the courses on LearnSQL are pretty good too
@@techTFQ thanks a lot bro, I am interested to join your live SQL Trainings , pls do give me more info regarding these sessions…
Sure bro
How create I'd no with alphabet like M1, M2, M3
both table are in different db but I didn't understand of writing @