The sessions have been really good till now. I really appreciate the efforts that you put in to provide your knowledge to us. A small request from my end that would really help us, is if you could provide the data as an attachment. So it will be really handy and good to practice with the same set of data that you teach. Thank-you. ..!!
Hello Sumit Sir, I have installed in my Laptop MYSQL 8.0 and using SQL Yog IDE and I run "SELECT DISTINCT source_of_joining FROM students ORDER BY enrollment_date DESC LIMIT 5;" --- its work perfectly. No error showing in the result section Also I used same table DDL & DML....as you write in your note pad.
Hello Sir, loving the sessions. Could you also attach some practice questions along with the sessions if and only if possible. Also, thankyou for such easily explained insightful sessions.
Sir, the sessions are well explained. But one imp. thing missing is practice data sets with practice questions. Could not find anyome atleast till session-6..
Hi Sir, I got the output for below query which you got error. mysql> SELECT DISTINCT source_of_joining FROM students ORDER BY enrollment_date DESC LIMIT 5; +-------------------+ | source_of_joining | +-------------------+ | friend | | youtube | | google | | quora | | linkedin | +-------------------+
SELECT student_id, student_fname FROM students WHERE student_fname LIKE '%\%ul'; SELECT student_id, student_fname FROM students WHERE student_fname LIKE '%\_ul'; both are giving output "Empty set (0.00 sec)" but i have one record whose name ends with ul, that is rahul. Sir please Solve my Issues.
yes both the statements will give empty set since both the statements which you have mentioned cannot return "rahul". If instead of 'rahul' you had 'rah%ul' or 'rah_ul' then you would got the desired results! For getting 'rahul' simply write : SELECT student_id, student_fname FROM students WHERE student_fname LIKE '%ul';
Checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql7
The sessions have been really good till now. I really appreciate the efforts that you put in to provide your knowledge to us. A small request from my end that would really help us, is if you could provide the data as an attachment. So it will be really handy and good to practice with the same set of data that you teach.
Thank-you. ..!!
select DISTINCT source_of_joining from student ORDER BY enrollment_date DESC LIMIT 3; this worked for me
Hi Sumit, really great lessons, but I agree with a lot of other commentors about how sharing the notepad seed data would be very helpful.
3rd day of Learning SQL.
Specially the multi level limit clause, that's something I found very new. As I have already did some courses from YT.
order by using column serial no was very new for me and amazing too. Excited for for session on joins.
I hope you will find the upcoming sessions even more interesting :)
Hello Sumit Sir, I have installed in my Laptop MYSQL 8.0 and using SQL Yog IDE and I run
"SELECT DISTINCT source_of_joining FROM students ORDER BY enrollment_date DESC LIMIT 5;" --- its work perfectly. No error showing in the result section
Also I used same table DDL & DML....as you write in your note pad.
Thank you so much for sharing your knowledge with us.
Amazing teaching skills.
Thanks sumit sir ! This series is amazing .
Sir, the sessions are amazing and well explained. Thanks for this amazing stuff.
Will you be covering the Normalisation?
Yes, soon
Sir, please include Cte and window functions soon.. I have to understnd thm very well. And getting understood by you is best sir. Crystal clear❤
Definitely, as soon as possible
Very good turorial.
thanku sir..
Crazy good❤
like '_____' thanks for this scenario.Since i having exp of 9 year and i don't about this. Thanks sir.
11:00 doesn't know this syntax. Thanks
Hello Sir, loving the sessions. Could you also attach some practice questions along with the sessions if and only if possible. Also, thankyou for such easily explained insightful sessions.
Will definitely try sharing the practice questions :)
Amazing lecture
Loved it
Hello sir , will you cover things like when to use index and how to optimise query performance
Definitely in the upcoming sessions. Keep watching the series :)
Thank you sir ..
Which recording sw are you using?
Sir, the sessions are well explained. But one imp. thing missing is practice data sets with practice questions. Could not find anyome atleast till session-6..
Will try to provide a link to download the practice questions and data sets in the description.
Could you please include Analytical functions and Pivot too
Will be included in the upcoming sessions.
Please provide the notes you use during the session. Also let me from where can I download them.
Can you please upload the notepad on google drive to refer the queries?
where can i find this notepad file?
Hi Sir, I got the output for below query which you got error.
mysql> SELECT DISTINCT source_of_joining FROM students ORDER BY enrollment_date DESC LIMIT 5;
+-------------------+
| source_of_joining |
+-------------------+
| friend |
| youtube |
| google |
| quora |
| linkedin |
+-------------------+
WHERE CAN WE FIND THAT NOTEPAD WHERE YOU WRITING COMMAND SIR
PLZ TELL
please help
first view
Good session
Can you provide the written notes ,which you write while explaining
Will try including them in the description.
can you plz provide the notepad 'sql course'
we need to revise
SELECT student_id, student_fname FROM students WHERE student_fname LIKE '%\%ul';
SELECT student_id, student_fname FROM students WHERE student_fname LIKE '%\_ul';
both are giving output "Empty set (0.00 sec)"
but i have one record whose name ends with ul, that is rahul.
Sir please Solve my Issues.
yes both the statements will give empty set since both the statements which you have mentioned cannot return "rahul". If instead of 'rahul' you had 'rah%ul' or 'rah_ul' then you would got the desired results!
For getting 'rahul' simply write :
SELECT student_id, student_fname FROM students WHERE student_fname LIKE '%ul';
in previous video
One question, if I learn SQL, where I can find SQL related jobs? Does it possible to get a job If I only know SQL.
No ,You must know one programming language also.
Smash the like for "LIKE Keyword"...👊🏻👍🏻
I am continuing every episode regularly...
Keep watching and upskilling :)
where can we find the document which sir is preparing side by side?plz tell
please sir reply my ducts
Sir, can you please add a text file containing all the records, so that we can practice ourselves. Thank You
Thanks Sir