Checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql11
@shashankseth3041 Жыл бұрын
On classifying as Diploma and Masters we can also do group by to see how many course in each category select count(course_id) as 'Number of courses', CASE when course_duration_months >= 6 then 'Masters Programme' else 'Diploma Certificate' END as Degree_Type from course group by Degree_Type;
@vishnujatav63292 жыл бұрын
I am very desperate to do your big data course but I can't pay. However, I am following every single of your video. You are giving very much knowledge free of cost. And I believe that in future I will have the fortune to do your course definitely, when will be become capable to purchase your course
@vishnujatav63292 жыл бұрын
Sumit sir, you have made my day. Very useful video. Thank you.
@poojag43353 ай бұрын
Best videos
@dineshjawalekar59612 жыл бұрын
The way you elaborates the things is just awesome 🔥✌️
@jsj7572 жыл бұрын
Doubts cleared from basics of SQL. It feels good to learn from you. Thank you for kind efforts that you put in for us 🤓
@hasanmougharbel8030 Жыл бұрын
Hey there, God bless your efforts. I have a simple enquiry as a new sql learner. How is sessions handled in sql applications? Are sessions related only to transactions or it is much broader than that? Thanks a lot.
@rajiv3444 Жыл бұрын
Thank you Sumith sir 🙏
@sudarshanmhaisdhune1039 Жыл бұрын
Great session Sumit Sir!!!!!
@ishwarkumar8919 Жыл бұрын
Thankyou sir🙏
@vineethreddy80967 ай бұрын
Hello sir Please mention the notepad you are using.
@Jksprw2 жыл бұрын
Good going
@MSNAHD2 жыл бұрын
Sir, i want to practice MySQL in my laptop. Could you plz let me know what i need to download and from where?
@DANstudiosable Жыл бұрын
Now is there any way to mege that new column(compnay_type) with the students table?
@nitinrao1133 Жыл бұрын
Rather to merge yu may add new col via alter table.
@syednaveed161910 ай бұрын
Can anyone tell me how to change the column name ?
@hamzamehmoodkhan77299 ай бұрын
D.
@navneet26492 жыл бұрын
sir you told that after a few sessions you will switch to MYSQL but all 10 sessions happened in goormide only!! so how to use MYSQL and use the same codes we learnt to create database, tables etc in MySQL?
@nitinrao1133 Жыл бұрын
This IDE uses to provide prototype or replica of mysql. You may use same commands ok in mysql to run any type of query or create table, databse.
@navneet2649 Жыл бұрын
@@nitinrao1133 okay will try, just wanted him to once guide through the interface of MYSQL also, but thanks 👍👍
@sanketvarma8550 Жыл бұрын
What is the name of the text editor you are writing notes on ?
@sushyyyyyyyy Жыл бұрын
u can use any IDE either VSCode or Sublime..., it's just he opened the text files in one of these IDEs.