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. ..!!
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 :)
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.
Thank you so much for sharing your knowledge with us.
Amazing teaching skills.
Sir, the sessions are amazing and well explained. Thanks for this amazing stuff.
Will you be covering the Normalisation?
Yes, soon
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.
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
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 :)
like '_____' thanks for this scenario.Since i having exp of 9 year and i don't about this. Thanks sir.
Very good turorial.
Thanks sumit sir ! This series is amazing .
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 :)
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.
Crazy good❤
Loved it
thanku sir..
Thanks Sir
Could you please include Analytical functions and Pivot too
Will be included in the upcoming sessions.
Amazing lecture
Please provide the notes you use during the session. Also let me from where can I download them.
Thank you sir ..
11:00 doesn't know this syntax. Thanks
Can you please upload the notepad on google drive to refer the queries?
Which recording sw are you using?
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.
Good session
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 |
+-------------------+
first view
in previous video
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';
WHERE CAN WE FIND THAT NOTEPAD WHERE YOU WRITING COMMAND SIR
PLZ TELL
please help
where can i find this notepad file?
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
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