SQL Internals | Indexes in SQL | Order of Execution in SQL | Advanced SQL | SQL Scenario based
ฝัง
- เผยแพร่เมื่อ 6 ก.ย. 2024
- 𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫!
"𝐀 8 𝐰𝐞𝐞𝐤 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐨 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐜𝐫𝐚𝐜𝐤 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐨𝐩 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐨𝐮𝐠𝐡𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐨𝐛𝐥𝐞𝐦."
𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 -
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLINR
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐨𝐮𝐭𝐬𝐢𝐝𝐞 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLUSD
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐥𝐞𝐚𝐫𝐧 𝐁𝐢𝐠 𝐃𝐚𝐭𝐚 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫?
𝐜𝐡𝐞𝐜𝐤𝐨𝐮𝐭 𝐭𝐡𝐞 𝐛𝐢𝐠 𝐝𝐚𝐭𝐚 𝐜𝐨𝐮𝐫𝐬𝐞 𝐝𝐞𝐭𝐚𝐢𝐥𝐬
𝐖𝐞𝐛𝐬𝐢𝐭𝐞 : trendytech.in/...
I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.
SQL Internals | Indexes in SQL | Order of Execution in SQL | Advanced SQL | SQL Scenario based
In this session I have talked about
1. clustered index vs non clustered index
2. scan vs seek
3. how to read an execution plan in sql
4. various operators in the execution plan in sql
5. order of execution in sql
6. how sql server do optimisation internally
J𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
🔅Sumit LinkedIn - / bigdatabysumit
🔅Sumit Instagram - / bigdatabysumit
If you haven't subscribed to the channel then please do subscribe for more insightful content
#SQLinternals #AdvancedSQL #OrderOfExecution #bigdata #dataengineering
![[Re:all TREASURE] EP.6 in 방콕ㅣ🚩 쩡캠의 방콕 투어 빵 마이 와이 👍](http://i.ytimg.com/vi/uyFw-nItA_s/mqdefault.jpg)
Checkout the Big Data course details here: trendytech.in/?referrer=youtube_sqladv2
link is not working says proxy or vpn detected
do you have resources on SQL optimization and in general Big data optimization techniques, for interview preparation.?
🔰This is the best series of learning SQL on TH-cam I've ever seen.
The way you teach here is quite similar to your big data program which is really really commendable.
As you've mentioned, before going into a big data program, first we need to learn SQL, at least the basics of it.
And I can say, this series of SQL is a perfect recipe to have a good understanding of a big data program.
You're really putting your hard work into it.
Thank you very much and please keep bringing this valuable content likewise. 🙏
thank you very much Sandip.. will keep adding more interesting content.
have been using SQL queries for so many years, however not knowing or caring much about what is happening behind the scenes, now this video is making knowing the internals fun & interesting, thank you very much sir :)
Sumit Sir Thank you for this video. I am using SQL from 2-3 years. I can write hard and complex queries, but the things mentioned in this video are so in depth that i didnt know anything such kind exists. Overall I can say optimizations are your thing.
Really very helpful @Trendytech Insights!! 59:26, does it mean that engine has kind of stats on the data already where it knows about the distribution of orders in certain ranges. (e.g. count >10 , count>100, etc.) in order to decide the execution order of operation??? 🤔🤔🤔
This one is going to help lot of data geeks to get the internals sorted! 😃 Thank you so much!!!
I never understood why I can't use the alias of aggregates in the where / having clause. To avoid the error I used sub queries/ ctes so that I can use alias in where and having clauses. With this video, I have finally understood why alias cannot be used in the where and having clause but can be used in the order by clause.
Thank you for the great content.
thank you very much Arslan :)
Sir, This video is much more helpful compared to all others that are available in TH-cam but you mentioned you will do the series of videos for further detailed explanation. Can please release those asap so that it will be helpful for many others like me.
By far the best Sql series available
@Sumit Sir Thanks for the video. I have just one doubt in this when we talk about composite clustered index , that we have multiple column in that E.g. (Order_id,cust_id). So firstly it will sort on basis of order_id and if there is any tie then on cust_id. But how will there be clash as this is primary key and we cannot have duplicate value in that. So what is the actual benefit of composite clustered index
This is the best explanation so far than other tutorial ever...
Sir How to practice SQL, After watching your tutorials. I mean there is no dataset in any SQL tutorial. Please suggest
Thank you sumit sir always faced problem in understanding the order of execution. Your explanation has cleared out everything.
Hi sir
I have been watching your video, as a beginner I would say it's a great explanation.
One request from my end, pls make a video on the difference among the views, stored procedures and functions along with the triggers in detail in SQL.
Thanks.
Thank you so much sumit sir for teaching sql so clearly. Can you please make a vedio on window functions sir
could you please make video series for pl/sql developer role sir
Sumit Sir, Thank you so much for this awesome video, I request you to please tell us how can we install sql in VS code, thank you .
Sumit, this is great. I followed all your sql sessions and look forward for many more. I have been working on sql for 6 years now . This is amazing playlist found so far. only one suggestion I have is when you write a sql query , can you please write in multiple lines instead of one line ( Eg in 27 min 19 sec of this video). I think that is recommended sql format. Thanks.
thats a very good suggestion.. will take care of this going forward.
Kudos to Bigdata LORD Sumeet
As you mentioned you’ll do this in series of videos , can you comment the following videos, also you mentioned you did a video on optimising queries please provide that link as well
Wow! Amazing Video.. you have made me very clear about it Thank you. Really Amazing
I guess for the top-N search it might have used max-heap data structure whose complexity will be O(total_no_records*log(N)) which is faster than sorting O(total_no_records*log(total_no_records)).
Looking forward for more videos on SQL.
Thank you for these sessions. You explain the concepts so well
Thank you for indepth explanation sir. Can you please make a video on date functions in SQL , it is quite confusing to use them in queries.please consider this request sir .Thank you sir
surely will try to make a video on date
Amazing it is...never did i realize the internals of database is so intresting
I am glad that you liked the video :)
This is really good ! Please continue on reducing the cost and optimizing. It always depends on data and other variable but a baseline would be great🙂
th-cam.com/play/PLDYqU5RH_aX1VSVvjdla9TOKf939UhIDB.html
This is really powerful session
thank you Njoy
Filter befor join or after join.. in case of concat and othe scenario.. what is better??
Thanks for the beautiful in-depth explanation, this makes things simple
thank you Mallikarjun
God bless your great efforts in this channel.
I have a simple question to ask as a newbie sql learner.
Could i manage to channel or extract all sql data generated from an accounting program (based on sql) to our new sql server.
The reason that we are bounded with the graphical interface of this accounting software as we cant
come up with any solutions regarding analytics and automation, unless we can tailor and rearrange this sql database based to our specific needs.
Thanks for helping me
PERFECT 11/10
Thank You !
Thanks a lot sir. It was very useful.
Great explanation sir
Finally I understood the order of execution😅. Awesome content.
thank you Atishay
When the count* and select * query is executed in the beginning the number of rows keeps changing in the bar at the bottom near the console box.. what is that and why did that happen?
Very well explained. Good job done. Keep it up.
Sweet. Thank you!
Thank you Sumit sir for the wonderful explanation... Can you please videos on more topics like stored func/ procs, Triggers, Pivot.
Amazing sir thank you!
In-depth knowledge gained
is machine learning required to join your big data course ? or ML is even required to become big data developer
Sir, please upload the data set for the practice query
Hi Summit , correct me if I am wrong. You mentioned for non-clustered index there will be a separate table. But what I believe is that for whatever indexing it is,a separate table will get created. Also why not Primary Index is getting created when we use primary key?
for clustered index there is no external thing thats created. when we have a primary key its clustered index and the storage of data in actual table happens in ascending order.
@@sumitmittal07 Okay thank you for clearing my doubt.
@@sumitmittal07 Okay thank you for clearing my doubt.
This is a very nice demo n session. Could you share your vscode setup that was used for data browsing here? Thanks a lot in advance
What add on or extension in VS Code was used here for the mySQL setup? Please share.
great
What is binary search
Can anyone tell me in which video Sumit sir shared how to install MySQL please?
You will get a lot of videos on Mysql installation.
The concepts he is dealing with are really important and not that well explained in other instructors' videos.
Learn and enjoy 👍🏻
From where we get this huge dataset??
Which env or IDE is used here for querying
I think it is vs code
Azure Data Studio
th-cam.com/play/PLDYqU5RH_aX1VSVvjdla9TOKf939UhIDB.html
Sir this video concept is not pretty clear
if someone need notes, here they are
drive.google.com/file/d/1J8ULa8yGB90ymbtAp2ysG0gbfOFVyAjj/view?usp=share_link