SQL Tutorial 3: Create Database,Table, Inserting Records and Retrieving Data

แชร์
ฝัง
  • เผยแพร่เมื่อ 4 ธ.ค. 2024

ความคิดเห็น • 178

  • @RastsisaluRudziankou
    @RastsisaluRudziankou 5 หลายเดือนก่อน +3

    Thank you, my favourite teacher

  • @USMANALIANSARI-t3j
    @USMANALIANSARI-t3j ปีที่แล้ว +9

    What a Video I don't expect these type of information is on the youtube, Thank you sir.

  • @shahinmadani184
    @shahinmadani184 2 ปีที่แล้ว +30

    Hi sir you are the best person in this entire world. You gave us so many resources for free.

    • @sdetpavan
      @sdetpavan  2 ปีที่แล้ว +3

      It's my pleasure

    • @shashavalijava9
      @shashavalijava9 11 หลายเดือนก่อน

      Thanks sir ❤❤❤

    • @priyankapundir9449
      @priyankapundir9449 5 หลายเดือนก่อน +1

      @@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.

  • @GamalIslam-ps3ql
    @GamalIslam-ps3ql 5 หลายเดือนก่อน +1

    you are really best teacher ever

  • @aditisharma1132
    @aditisharma1132 ปีที่แล้ว +9

    Best channel where you can learn in best way. Thank You Sir for sharing such great content :)

  • @KrishanKumar-jo7ss
    @KrishanKumar-jo7ss ปีที่แล้ว +6

    You teach very well even a person having zero knowledge about database can also understand very easily.
    You teach from scratch abcd...z

  • @rajapuramjeevanreddy8737
    @rajapuramjeevanreddy8737 7 หลายเดือนก่อน +1

    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.

    • @priyankapundir9449
      @priyankapundir9449 5 หลายเดือนก่อน

      @sdetpavan - Yes, it will be very helpful sir.

  • @Poonambhakare123
    @Poonambhakare123 10 หลายเดือนก่อน +1

    Thank you sir...
    Best way to learn mysql......

    • @sdetpavan
      @sdetpavan  10 หลายเดือนก่อน +1

      Always welcome

  • @sutriv1725
    @sutriv1725 3 ปีที่แล้ว +6

    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.

  • @Lilia-pi8pf
    @Lilia-pi8pf 5 ปีที่แล้ว +8

    Thank you, Sir. I follow all your videos. No one explain better than you..

  • @sanjaymarathe5249
    @sanjaymarathe5249 2 ปีที่แล้ว +5

    Great sir your teaching style really awesome. Thanks for creating the videos.

    • @sdetpavan
      @sdetpavan  2 ปีที่แล้ว

      most welcome

    • @SumeetRaj-kt8en
      @SumeetRaj-kt8en ปีที่แล้ว +3

      @@sdetpavan Where Can I Get the SQL FILE named as ' HR ' which is used in this Video ??

    • @ravinaidu8938
      @ravinaidu8938 ปีที่แล้ว

      You found that file 'HR' ,, if you have that file can you please share with me

    • @hustler1287
      @hustler1287 10 หลายเดือนก่อน

      Guys did you get the HR file to practise

  • @priyankas1665
    @priyankas1665 2 หลายเดือนก่อน +1

    Thank you so much very nice easy way explanation 🙏🏻🙏🏻🙏🏻

    • @sdetpavan
      @sdetpavan  2 หลายเดือนก่อน +1

      Welcome

    • @priyankas1665
      @priyankas1665 2 หลายเดือนก่อน

      Sir clear nahi dikh raha

  • @basanagoudabiradar8669
    @basanagoudabiradar8669 7 หลายเดือนก่อน +1

    Good explanation sir 👍

    • @sdetpavan
      @sdetpavan  7 หลายเดือนก่อน

      Thanks

  • @maheshbapanapalli
    @maheshbapanapalli 2 หลายเดือนก่อน

    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.

  • @amardeepkumar7370
    @amardeepkumar7370 6 หลายเดือนก่อน

    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

  • @vishalb6427
    @vishalb6427 6 หลายเดือนก่อน +2

    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.

  • @saurabhpandey4427
    @saurabhpandey4427 9 หลายเดือนก่อน +1

    Thank You sir ....
    Sir where is ppt ?

  • @shehuabdulsalam117
    @shehuabdulsalam117 ปีที่แล้ว

    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.

  • @arthi890
    @arthi890 4 ปีที่แล้ว +4

    Hello Sir,is it enough to study this sql video for gaining knowledge in sql for data analyst career ?

  • @gopireddyseelam2295
    @gopireddyseelam2295 5 ปีที่แล้ว +3

    perfect explanation sir...

  • @TalhaEvilTester
    @TalhaEvilTester 15 วันที่ผ่านมา

    Hi Pavan,
    I've been following your TH-cam channel since many years and your content and way of teaching is outstanding

  • @fisahaberhe1121
    @fisahaberhe1121 2 ปีที่แล้ว +3

    Good bless you.

  • @abdulsukkur419
    @abdulsukkur419 ปีที่แล้ว

    Such a wonderful sessions created with detailed contents.

  • @tukaramgawade807
    @tukaramgawade807 3 ปีที่แล้ว +7

    Sir please provide me SQL file for hr database... For practice purpose it will be helpful... Please help..

  • @sukumarchintha4178
    @sukumarchintha4178 3 ปีที่แล้ว +16

    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

    • @avineshsrivastava571
      @avineshsrivastava571 2 ปีที่แล้ว +2

      Yes i also need

    • @myvideos6819
      @myvideos6819 2 ปีที่แล้ว

      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

    • @myvideos6819
      @myvideos6819 2 ปีที่แล้ว +1

      @@mounikareddy3294 I thought the same but we don't have the data which the one is explained in it😂

    • @anithareddy8861
      @anithareddy8861 2 ปีที่แล้ว +1

      Ya I also need to practice

  • @vaibhavpatharkar6794
    @vaibhavpatharkar6794 ปีที่แล้ว +1

    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

  • @hamzakasmani6286
    @hamzakasmani6286 2 ปีที่แล้ว +3

    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.

  • @walebalogunk
    @walebalogunk 4 ปีที่แล้ว +3

    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.

    • @sreejx
      @sreejx 4 ปีที่แล้ว

      hi @kazeem how far have u reached in your data science journey.

    • @walebalogunk
      @walebalogunk 4 ปีที่แล้ว +2

      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

    • @sreejx
      @sreejx 4 ปีที่แล้ว

      @@walebalogunk that's great all the best to you.

  • @alexs3846
    @alexs3846 4 ปีที่แล้ว +1

    Thank you for the lesson.
    P.S. When you highlight the syntax it's not visible.

  • @errors264
    @errors264 3 ปีที่แล้ว +1

    Are the power point presentations available ?

  • @tulikarai3960
    @tulikarai3960 ปีที่แล้ว +1

    Thank you sir

  • @keshavbhagat8318
    @keshavbhagat8318 2 ปีที่แล้ว +1

    Very Very Thank You Sir 🙏

    • @sdetpavan
      @sdetpavan  2 ปีที่แล้ว

      Most welcome

  • @oc7834
    @oc7834 3 ปีที่แล้ว +1

    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

  • @devopsjockey
    @devopsjockey ปีที่แล้ว

    Love from kerala

  • @rushikeshchandra9686
    @rushikeshchandra9686 2 ปีที่แล้ว +2

    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

  • @ayushichauhan6097
    @ayushichauhan6097 ปีที่แล้ว +2

    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 🙏🙏🙏🙏🙏🙏🙏🙏

  • @PK-iu9nc
    @PK-iu9nc 7 หลายเดือนก่อน

    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.

  • @siyarsahar9954
    @siyarsahar9954 4 ปีที่แล้ว +3

    Really nice explained. How can I get the power point slides?

  • @affanshariq3905
    @affanshariq3905 ปีที่แล้ว +1

    Hi sir,
    where can i download the hr data set

  • @rajansethi6767
    @rajansethi6767 2 ปีที่แล้ว +2

    Please make video or add link from where we can download and import HR schema.

    • @ravinaidu8938
      @ravinaidu8938 ปีที่แล้ว

      Where we can download that HR schema ?

  • @benjaminvictor1051
    @benjaminvictor1051 ปีที่แล้ว

    You are the best teacher sir, wow this is awesome teacher but how can I access the hr database?

  • @soniluv
    @soniluv 2 หลายเดือนก่อน

    Sir, please could you provide me with HR db. thanks

  • @srikanthreddy5161
    @srikanthreddy5161 5 หลายเดือนก่อน

    any advance mqsql videos sir

  • @balakrishnareddyreddy575
    @balakrishnareddyreddy575 2 ปีที่แล้ว

    Sir it's enough for full stack java developers

  • @muhammadjunaidmajeed1211
    @muhammadjunaidmajeed1211 3 ปีที่แล้ว +1

    Excellent!

    • @sdetpavan
      @sdetpavan  2 ปีที่แล้ว

      Thanks

    • @shivabhargav827
      @shivabhargav827 ปีที่แล้ว

      @@sdetpavan can you please share HR DATABASE LINK

  • @romanyakymets738
    @romanyakymets738 2 ปีที่แล้ว +1

    Thank you so much

    • @sdetpavan
      @sdetpavan  2 ปีที่แล้ว

      You're most welcome

  • @annujsawant1514
    @annujsawant1514 ปีที่แล้ว

    sir from where i can get that HR database ?

  • @Srinivasm-f5t
    @Srinivasm-f5t ปีที่แล้ว +1

    how can we download these mysql documentation?

  • @b.mallikarjunamalli2724
    @b.mallikarjunamalli2724 ปีที่แล้ว

    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

  • @santoshvairale2449
    @santoshvairale2449 ปีที่แล้ว

    Hello sir, please upload the spring framework playlist

  • @saranyachandrabos3541
    @saranyachandrabos3541 3 ปีที่แล้ว +1

    Thank you....

  • @sanjayyadav-xe7mf
    @sanjayyadav-xe7mf ปีที่แล้ว +1

    could you plz provide link to download hr database?

  • @srinivaschamakuri2690
    @srinivaschamakuri2690 2 ปีที่แล้ว +2

    how can we import hr data sir?????

  • @sivamariserla7126
    @sivamariserla7126 5 หลายเดือนก่อน

    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🙏🙏🙏

  • @ahmedsamir7882
    @ahmedsamir7882 ปีที่แล้ว

    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 ?

  • @pandikuntamaidhili
    @pandikuntamaidhili 3 ปีที่แล้ว +1

    THANK YOU SIR

  • @poorenglish3107
    @poorenglish3107 2 ปีที่แล้ว +1

    where is the link to import hr details pls reply

  • @Dheerajkumar-oi8jq
    @Dheerajkumar-oi8jq ปีที่แล้ว

    Where can i get Employee table document for import into my local sysytem.

  • @dn9431
    @dn9431 ปีที่แล้ว

    Hi sir, I can' find resources for 'hr' table, where is it?

  • @CRNEntertainments
    @CRNEntertainments ปีที่แล้ว

    where can i download hr data base?

  • @sindhujavasireddy9921
    @sindhujavasireddy9921 2 ปีที่แล้ว

    Hii sir..sql and MySQL is different??

  • @yashbajaj2984
    @yashbajaj2984 ปีที่แล้ว

    sir where is the resource of hr data base

  • @desigirlpreeti
    @desigirlpreeti ปีที่แล้ว

    Hello Sir how can I export hr database in my system

  • @premkumarramanathan8848
    @premkumarramanathan8848 ปีที่แล้ว

    From where can I download the hr schema, please help.

  • @satishkumarkunchanapalli9225
    @satishkumarkunchanapalli9225 ปีที่แล้ว

    where you give sql file Sir as you told in this video??

  • @sanjayyadav-xe7mf
    @sanjayyadav-xe7mf ปีที่แล้ว

    how can i get hr demo data for practise

  • @pratapmaity5412
    @pratapmaity5412 ปีที่แล้ว

    Sir, how can I get the 'hr ' database?

  • @Thelearningcenter_byharry
    @Thelearningcenter_byharry ปีที่แล้ว

    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?

  • @basanagoudabiradar8669
    @basanagoudabiradar8669 7 หลายเดือนก่อน

    Where is the link for HR database sir?

  • @SumeetRaj-kt8en
    @SumeetRaj-kt8en ปีที่แล้ว

    Where Can I Get the SQL FILE named as ' HR ' which is used in this Video ??

  • @sj5594
    @sj5594 2 ปีที่แล้ว

    How to import database for practice

  • @sanketmeshram4895
    @sanketmeshram4895 3 ปีที่แล้ว

    While practicing this the commands in the query are executing multiple times what is the solution for this..?

  • @surajkamble3538
    @surajkamble3538 ปีที่แล้ว

    From where I can get (hr file 📁) database?

  • @sharanyacherry3390
    @sharanyacherry3390 2 ปีที่แล้ว

    Sir how I should create title record ?

  • @hemalatha9863
    @hemalatha9863 4 ปีที่แล้ว

    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

    • @_saii
      @_saii 2 ปีที่แล้ว +1

      if we leave empty it leads to error

  • @mekhron
    @mekhron 4 ปีที่แล้ว

    Hello sir. I need dump of database ORG? Do you have it anywhere in your website? Couldn't find it

  • @Poojachandel-r3n
    @Poojachandel-r3n ปีที่แล้ว

    How to import HR schema ?

  • @mayusdining26
    @mayusdining26 ปีที่แล้ว

    Where is the database link ,sir?
    I want to import that

  • @sonamchoudhary8235
    @sonamchoudhary8235 2 ปีที่แล้ว

    how i download sql file to implement queries

  • @ukstravelenthusiast6355
    @ukstravelenthusiast6355 3 ปีที่แล้ว +1

    FROM WHERE SHOULD I GET THE 'HR' DATABASE IT IS NOT SHOWING IN MY SQL. @SDET

    • @nikunjkumar555
      @nikunjkumar555 3 ปีที่แล้ว +2

      You can download from here : github.com/nomemory/hr-schema-mysql

    • @ukstravelenthusiast6355
      @ukstravelenthusiast6355 3 ปีที่แล้ว

      @@nikunjkumar555 but after extracting in MYSQL workbench there no tables are coming only HR file is showing inside that it is empty

    • @nikunjkumar555
      @nikunjkumar555 3 ปีที่แล้ว +1

      @@ukstravelenthusiast6355 import the file in mysql workbench and run , then refresh the left panel to see the db and tables

    • @ukstravelenthusiast6355
      @ukstravelenthusiast6355 3 ปีที่แล้ว

      @@nikunjkumar555 done the same but not visible inside material of hr file

    • @nikunjkumar555
      @nikunjkumar555 3 ปีที่แล้ว +1

      @@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"

  • @srinubabu2350
    @srinubabu2350 ปีที่แล้ว

    Sample HR database where I can get... Please help me friends

  • @MsGourish
    @MsGourish 5 ปีที่แล้ว +2

    Is it possible to become a SQL developer after taking this course or this is only for testers. Please reply..

    • @sdetpavan
      @sdetpavan  5 ปีที่แล้ว

      You have to learn SQL programming to become developer.

    • @MsGourish
      @MsGourish 5 ปีที่แล้ว

      @@sdetpavan Going through this entire course is enough for me to become a SQL developer?

    • @MsGourish
      @MsGourish 5 ปีที่แล้ว +2

      @@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?

    • @sujithkumar3925
      @sujithkumar3925 ปีที่แล้ว

      @@MsGourish as sir mentioned you need to learn SQL programming to become SQL developer, this course is not enough to become SQL developer.

  • @golden-dragon1442
    @golden-dragon1442 2 ปีที่แล้ว

    Where is the SQL file for the hr database?

  • @saurabharbal4474
    @saurabharbal4474 2 ปีที่แล้ว

    Please send the datasets links

  • @samratkeshri
    @samratkeshri 2 ปีที่แล้ว +1

    how to get HR table file

    • @sdetpavan
      @sdetpavan  2 ปีที่แล้ว

      Pleaase google HR schema

  • @priyankas1665
    @priyankas1665 2 หลายเดือนก่อน

    Sir clear nahi dikh raha😐

  • @pavanisarada
    @pavanisarada ปีที่แล้ว

    Please share that data sir...that hr data

  • @animeshrawal5263
    @animeshrawal5263 2 ปีที่แล้ว

    plz share link of database file, so that we can practise. TIA.

  • @SriDevi-rk2bv
    @SriDevi-rk2bv 3 ปีที่แล้ว

    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

  • @harshkhandelwal2818
    @harshkhandelwal2818 5 ปีที่แล้ว +3

    Sir please provide HR Database

    • @sdetpavan
      @sdetpavan  5 ปีที่แล้ว +4

      HR Database download link:
      github.com/nomemory/hr-schema-mysql.git

    • @NAVEENKUMAR-du9nm
      @NAVEENKUMAR-du9nm 5 ปีที่แล้ว

      @@sdetpavan not working when added as sql scripts in workbench.

    • @walebalogunk
      @walebalogunk 4 ปีที่แล้ว

      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

    • @pramodgaikwad3129
      @pramodgaikwad3129 4 ปีที่แล้ว

      @@sdetpavan Thank you sir. It worked

    • @kavyapondugula1085
      @kavyapondugula1085 3 ปีที่แล้ว

      @@sdetpavan it worked

  • @mohamediburahimp7661
    @mohamediburahimp7661 2 ปีที่แล้ว +1

    Loveeeuuuuuuusomuchhhhhh

  • @shuvamdebbarman5113
    @shuvamdebbarman5113 3 ปีที่แล้ว

    CAN YOU TELL ME HOW TO CHANGE THE DATATYPE OF A COLUMN (HERE, FOR SALARY)????

    • @sumarampur
      @sumarampur 3 ปีที่แล้ว

      Use Alter command

  • @aishwaryagaddam710
    @aishwaryagaddam710 3 ปีที่แล้ว +2

    Sir please reply is this enough for test engineer as a beginner?

  • @stay2code523
    @stay2code523 ปีที่แล้ว

    can anyone share the link to download Hr database

  • @shavezalam9086
    @shavezalam9086 ปีที่แล้ว

    If we got the HR database for partice then it will be so easily to learn kindly someone provide me same HR database 🙏🙏🙏🙏

  • @srinivasreddy-nz7bk
    @srinivasreddy-nz7bk 2 ปีที่แล้ว

    SIR PLZ SHARE HR DATABASE

  • @sunilkumarbr5539
    @sunilkumarbr5539 2 ปีที่แล้ว

    KINDLY ATTACH THE HR DATABASE LINK IN DESCRIPTION

  • @sanghamitrabadole2117
    @sanghamitrabadole2117 2 ปีที่แล้ว

    sir please provide the notes!...

  • @chandarith4555
    @chandarith4555 ปีที่แล้ว

    Mr. Pavan, do u have any udemy course on spring and springboot framework? I would like to register. Thanks

  • @snigdhapradhan666
    @snigdhapradhan666 ปีที่แล้ว

    Sir please provide the hr file