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;
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
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.
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?
Checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql11
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;
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
Sumit sir, you have made my day. Very useful video. Thank you.
Doubts cleared from basics of SQL.
It feels good to learn from you.
Thank you for kind efforts that you put in for us 🤓
The way you elaborates the things is just awesome 🔥✌️
Great session Sumit Sir!!!!!
Thank you Sumith sir 🙏
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.
Hello sir Please mention the notepad you are using.
Thankyou sir🙏
Sir, i want to practice MySQL in my laptop.
Could you plz let me know what i need to download and from where?
Best videos
Now is there any way to mege that new column(compnay_type) with the students table?
Rather to merge yu may add new col via alter table.
Good going
What is the name of the text editor you are writing notes on ?
u can use any IDE either VSCode or Sublime..., it's just he opened the text files in one of these IDEs.
Hii sir please upload complete course of pyspark
Can anyone tell me how to change the column name ?
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?
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.
@@nitinrao1133 okay will try, just wanted him to once guide through the interface of MYSQL also, but thanks 👍👍
D.
1st
I'm last!!