Комментарии:
could you please make video series for pl/sql developer role sir
ОтветитьBy far the best Sql series available
ОтветитьSir How to practice SQL, After watching your tutorials. I mean there is no dataset in any SQL tutorial. Please suggest
Ответить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 .
Ответить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.
Looking forward for more videos on SQL.
Ответить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?
ОтветитьThank you for these sessions. You explain the concepts so well
Ответить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
ОтветитьThank you so much sumit sir for teaching sql so clearly. Can you please make a vedio on window functions sir
ОтветитьPERFECT 11/10
Thank You !
Sweet. Thank you!
ОтветитьSir this video concept is not pretty clear
ОтветитьThanks a lot sir. It was very useful.
ОтветитьThis is the best explanation so far than other tutorial ever...
ОтветитьGreat explanation sir
ОтветитьFrom where we get this huge dataset??
ОтветитьThank you sumit sir always faced problem in understanding the order of execution. Your explanation has cleared out everything.
Ответить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)).
ОтветитьVery well explained. Good job done. Keep it up.
Ответить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
@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
ОтветитьAmazing sir thank you!
Ответить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.
Ответить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
Ответитьgreat
Ответить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?
ОтветитьThank you Sumit sir for the wonderful explanation... Can you please videos on more topics like stored func/ procs, Triggers, Pivot.
ОтветитьWow! Amazing Video.. you have made me very clear about it Thank you. Really Amazing
ОтветитьCan anyone tell me in which video Sumit sir shared how to install MySQL please?
ОтветитьFilter befor join or after join.. in case of concat and othe scenario.. what is better??
ОтветитьWhat is binary search
Ответитьis machine learning required to join your big data course ? or ML is even required to become big data developer
Ответить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🙂
Ответить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.
ОтветитьAmazing it is...never did i realize the internals of database is so intresting
ОтветитьWhich env or IDE is used here for querying
ОтветитьThanks for the beautiful in-depth explanation, this makes things simple
Ответить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.
This is really powerful session
Ответить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
ОтветитьIn-depth knowledge gained
ОтветитьFinally I understood the order of execution😅. Awesome content.
Ответить