@@sdetpavan Sir, I am following your video on database but now i am stuck because of HR database , unable to perform queries. Can u pls let me know how can i get that.
Great content for beginners. I have seen many people asking for HR database but no reply has been given. I am assuming that it was provided for students that you have taught live. It would be great if it is provided to all the viewers. Thankyou for the free course.
You have created the HR database for your personal use and then you applied the commands without creating the database in the same time with the users.
Hi Sir, Thank you so much for your lectures and it is easy to learn. I've completed manual testing now learning SQL. Could you please if I still can follow this videos because it was uploaded 5 years ago. Also, help us with the hr data file if you have it. Thank you again.
Hello sir, please where can I get the HR data base or any of the material you used in this lecture. This is very explicit and you made it very simple to understand. Thank you.
Hi sir the classes are excellent. Thankyou for providing immense knowledge on software testing and SQL but I was wondering where can i find the HR database which I can inport. Please provide me the information to navigate to the HR database. Thankyou Sir
Now i downlooaded the mysql, but sakila, and other data bases are not available at all. Can u make a video how to download these db from google and load them in mysql to follow the operations u did. Pl consider the above request
Sir your videos are awesome for understanding purposes. Also, sir kindly share the link from where I can get these PPTs of yours. Because these PPts are on slide share but i am not able to download.
This is the best explanation I've seen so far of any online course in my quest to become a data scientist. You know. He explained every concept all the way, even the elementary, such: sql, mysql, gui, cli, server, client, and so on. So, I'm not at a loss at any point. I understand everything he's talking about. Thank you so much. I'm on the 3rd lesson. Please do you have videos for courses leading to being a data scientist or on Python to be specific? I'd love to watch that too.
Sreejith Menon Thank you for asking Sreejith. I'm concentrating on sql for now, using MySql. I've also been doing some bits of Python programming classes but because I don't have a laptop is kind of slowing me down. Meanwhile, I've ordered for a laptop, and I'm expecting it by Wednesday, when I'll now start serious practice. Thank you so much. I'm relying on free TH-cam video tutorials
once downloaded you got sys, world and few others under your schema. I only got sys. why? How would I create the reset of it in schema myself since it don't come with the rest? I got version 8.0
Hi sir what if there is both int and varchar in my table because in my table i have a column name as hiredate in that the date should be like 21-DEC-88 what should do now. If iam giving int(5) varchar(5) it is showing error kindly help me out with this error
hello sir , thank you so much for explaining everything is the easiest manner however I have a doubt- if marks value should be in INT and how can we write NULL there? please reply... so are the only only hope for a person like me who is planning to change the career after a long break 🙏🙏🙏🙏🙏🙏🙏🙏
At 32:18, What does the Null column tell about, Why it is showing NULL values YES. I tried having rows inserted without null values, Even though the NULL columns are showing Yes. Kindly clear this.
I have small dout sir, how to get huge amount of data like your using hr data base like that and also i am not get any default database sir, installation perfect sir, could please give suggesstion how to get databases
Sir, Can these topics is enough to learn Mysql Database...This video 5years ago right Now, same type lo topics upto atill 2024 also applicable..? Please can give some clarity about this pls sirrrr🙏🙏🙏
sir please when i want to delete post on facebook for example , in this case my personal pc is considering as a client database or the client database and server database are located in the server of facebook in the database layer ?
sir i did not get any database when i installed mysql ? while installing mysql i was only getting the option to install developer version which i did and i didnot have any database, can you help?
Hi sir ,have a doubt when we are inserting the values instead of giving null if we leave the row empty ,does it take values later point when we are update the column or table
@@ukstravelenthusiast6355 You should be able to see , i have done the same and successfully created all the objects. I think the download was incomplete. Just wait for few minutes to get downloaded properly. The file name is "hr-schema-mysql.sql"
@@sdetpavan Pavan Sir, please reply as it is ver important for me to know. Going through this entire course is enough for me to become a SQL developer?
SDET Please do you provide training on how to become a data scientist, I mean on all the tools one need to become a data scientist, like Python, R, Tableau, Power BI, Oracle, etc? I'd like to join please
Thank you, my favourite teacher
What a Video I don't expect these type of information is on the youtube, Thank you sir.
Welcome
WHERE CAN I DOWNLOAD HR DATASET?
Hi sir you are the best person in this entire world. You gave us so many resources for free.
It's my pleasure
Thanks sir ❤❤❤
@@sdetpavan Sir, I am following your video on database but now i am stuck because of HR database , unable to perform queries. Can u pls let me know how can i get that.
you are really best teacher ever
Best channel where you can learn in best way. Thank You Sir for sharing such great content :)
Welcome
You teach very well even a person having zero knowledge about database can also understand very easily.
You teach from scratch abcd...z
Thanks
Great content for beginners. I have seen many people asking for HR database but no reply has been given. I am assuming that it was provided for students that you have taught live. It would be great if it is provided to all the viewers. Thankyou for the free course.
@sdetpavan - Yes, it will be very helpful sir.
Thank you sir...
Best way to learn mysql......
Always welcome
You have created the HR database for your personal use and then you applied the commands without creating the database in the same time with the users.
Thank you, Sir. I follow all your videos. No one explain better than you..
Great sir your teaching style really awesome. Thanks for creating the videos.
most welcome
@@sdetpavan Where Can I Get the SQL FILE named as ' HR ' which is used in this Video ??
You found that file 'HR' ,, if you have that file can you please share with me
Guys did you get the HR file to practise
Thank you so much very nice easy way explanation 🙏🏻🙏🏻🙏🏻
Welcome
Sir clear nahi dikh raha
Good explanation sir 👍
Thanks
Hi Sir,
Thank you so much for your lectures and it is easy to learn. I've completed manual testing now learning SQL. Could you please if I still can follow this videos because it was uploaded 5 years ago. Also, help us with the hr data file if you have it.
Thank you again.
Hi sir the way you are teaching it makes very easy for me to learn thank you
Can you please tell me how can i get hr database
Hi sir, can I get this ppt for practice purpose? and also I need this HR table for practice so where can i get these.
Thank You sir ....
Sir where is ppt ?
Hello sir, please where can I get the HR data base or any of the material you used in this lecture. This is very explicit and you made it very simple to understand. Thank you.
Hello Sir,is it enough to study this sql video for gaining knowledge in sql for data analyst career ?
perfect explanation sir...
Hi Pavan,
I've been following your TH-cam channel since many years and your content and way of teaching is outstanding
Good bless you.
My pleasure
Such a wonderful sessions created with detailed contents.
Sir please provide me SQL file for hr database... For practice purpose it will be helpful... Please help..
Hi sir the classes are excellent. Thankyou for providing immense knowledge on software testing and SQL but I was wondering where can i find the HR database which I can inport. Please provide me the information to navigate to the HR database. Thankyou Sir
Yes i also need
its not mandate to do like that only buddy you can create any database name it like mydb or hr database too and work on it
@@mounikareddy3294 I thought the same but we don't have the data which the one is explained in it😂
Ya I also need to practice
Now i downlooaded the mysql, but sakila, and other data bases are not available at all. Can u make a video how to download these db from google and load them in mysql to follow the operations u did.
Pl consider the above request
Sir your videos are awesome for understanding purposes.
Also, sir kindly share the link from where I can get these PPTs of yours.
Because these PPts are on slide share but i am not able to download.
WHERE CAN I DOWNLOAD THAT HR DATABASE?
This is the best explanation I've seen so far of any online course in my quest to become a data scientist. You know. He explained every concept all the way, even the elementary, such: sql, mysql, gui, cli, server, client, and so on. So, I'm not at a loss at any point. I understand everything he's talking about. Thank you so much. I'm on the 3rd lesson.
Please do you have videos for courses leading to being a data scientist or on Python to be specific? I'd love to watch that too.
hi @kazeem how far have u reached in your data science journey.
Sreejith Menon
Thank you for asking Sreejith. I'm concentrating on sql for now, using MySql. I've also been doing some bits of Python programming classes but because I don't have a laptop is kind of slowing me down. Meanwhile, I've ordered for a laptop, and I'm expecting it by Wednesday, when I'll now start serious practice.
Thank you so much. I'm relying on free TH-cam video tutorials
@@walebalogunk that's great all the best to you.
Thank you for the lesson.
P.S. When you highlight the syntax it's not visible.
Are the power point presentations available ?
Thank you sir
Welcome
Very Very Thank You Sir 🙏
Most welcome
once downloaded you got sys, world and few others under your schema. I only got sys. why? How would I create the reset of it in schema myself since it don't come with the rest? I got version 8.0
Love from kerala
Hi sir what if there is both int and varchar in my table because in my table i have a column name as hiredate in that the date should be like 21-DEC-88 what should do now. If iam giving int(5) varchar(5) it is showing error kindly help me out with this error
hello sir , thank you so much for explaining everything is the easiest manner however I have a doubt- if marks value should be in INT and how can we write NULL there? please reply... so are the only only hope for a person like me who is planning to change the career after a long break 🙏🙏🙏🙏🙏🙏🙏🙏
Same
At 32:18, What does the Null column tell about, Why it is showing NULL values YES. I tried having rows inserted without null values, Even though the NULL columns are showing Yes. Kindly clear this.
Really nice explained. How can I get the power point slides?
Hi sir,
where can i download the hr data set
Please make video or add link from where we can download and import HR schema.
Where we can download that HR schema ?
You are the best teacher sir, wow this is awesome teacher but how can I access the hr database?
Sir, please could you provide me with HR db. thanks
any advance mqsql videos sir
Sir it's enough for full stack java developers
Excellent!
Thanks
@@sdetpavan can you please share HR DATABASE LINK
Thank you so much
You're most welcome
sir from where i can get that HR database ?
how can we download these mysql documentation?
I have small dout sir, how to get huge amount of data like your using hr data base like that and also i am not get any default database sir, installation perfect sir, could please give suggesstion how to get databases
Hello sir, please upload the spring framework playlist
Thank you....
Welcome
could you plz provide link to download hr database?
how can we import hr data sir?????
Same question
Sir, Can these topics is enough to learn Mysql Database...This video 5years ago right Now, same type lo topics upto atill 2024 also applicable..? Please can give some clarity about this pls sirrrr🙏🙏🙏
sir please when i want to delete post on facebook for example , in this case my personal pc is considering as a client database or the client database and server database are located in the server of facebook in the database layer ?
THANK YOU SIR
Welcome
where is the link to import hr details pls reply
Where can i get Employee table document for import into my local sysytem.
Hi sir, I can' find resources for 'hr' table, where is it?
where can i download hr data base?
Hii sir..sql and MySQL is different??
sir where is the resource of hr data base
Hello Sir how can I export hr database in my system
From where can I download the hr schema, please help.
where you give sql file Sir as you told in this video??
how can i get hr demo data for practise
Sir, how can I get the 'hr ' database?
sir i did not get any database when i installed mysql ? while installing mysql i was only getting the option to install developer version which i did and i didnot have any database, can you help?
Where is the link for HR database sir?
Sir, please provide.
Where Can I Get the SQL FILE named as ' HR ' which is used in this Video ??
How to import database for practice
While practicing this the commands in the query are executing multiple times what is the solution for this..?
From where I can get (hr file 📁) database?
Sir how I should create title record ?
Hi sir ,have a doubt when we are inserting the values instead of giving null if we leave the row empty ,does it take values later point when we are update the column or table
if we leave empty it leads to error
Hello sir. I need dump of database ORG? Do you have it anywhere in your website? Couldn't find it
How to import HR schema ?
Where is the database link ,sir?
I want to import that
how i download sql file to implement queries
FROM WHERE SHOULD I GET THE 'HR' DATABASE IT IS NOT SHOWING IN MY SQL. @SDET
You can download from here : github.com/nomemory/hr-schema-mysql
@@nikunjkumar555 but after extracting in MYSQL workbench there no tables are coming only HR file is showing inside that it is empty
@@ukstravelenthusiast6355 import the file in mysql workbench and run , then refresh the left panel to see the db and tables
@@nikunjkumar555 done the same but not visible inside material of hr file
@@ukstravelenthusiast6355 You should be able to see , i have done the same and successfully created all the objects. I think the download was incomplete. Just wait for few minutes to get downloaded properly.
The file name is "hr-schema-mysql.sql"
Sample HR database where I can get... Please help me friends
Is it possible to become a SQL developer after taking this course or this is only for testers. Please reply..
You have to learn SQL programming to become developer.
@@sdetpavan Going through this entire course is enough for me to become a SQL developer?
@@sdetpavan Pavan Sir, please reply as it is ver important for me to know. Going through this entire course is enough for me to become a SQL developer?
@@MsGourish as sir mentioned you need to learn SQL programming to become SQL developer, this course is not enough to become SQL developer.
Where is the SQL file for the hr database?
Please send the datasets links
how to get HR table file
Pleaase google HR schema
Sir clear nahi dikh raha😐
Please share that data sir...that hr data
plz share link of database file, so that we can practise. TIA.
hi
While trying add hr database in mysql its throwing some error.
sequence item 6:expected str instance,bytes found
can you help me sir
Sir please provide HR Database
HR Database download link:
github.com/nomemory/hr-schema-mysql.git
@@sdetpavan not working when added as sql scripts in workbench.
SDET
Please do you provide training on how to become a data scientist, I mean on all the tools one need to become a data scientist, like Python, R, Tableau, Power BI, Oracle, etc? I'd like to join please
@@sdetpavan Thank you sir. It worked
@@sdetpavan it worked
Loveeeuuuuuuusomuchhhhhh
CAN YOU TELL ME HOW TO CHANGE THE DATATYPE OF A COLUMN (HERE, FOR SALARY)????
Use Alter command
Sir please reply is this enough for test engineer as a beginner?
Yes.
can anyone share the link to download Hr database
If we got the HR database for partice then it will be so easily to learn kindly someone provide me same HR database 🙏🙏🙏🙏
SIR PLZ SHARE HR DATABASE
KINDLY ATTACH THE HR DATABASE LINK IN DESCRIPTION
sir please provide the notes!...
Mr. Pavan, do u have any udemy course on spring and springboot framework? I would like to register. Thanks
Sir please provide the hr file