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

Topics:
-----------
1) Create database
2) Create Table Student
3) Insert data into Student table.
4) Select/Retrieve data from a table
#########################
Udemy Courses:
#########################
Manual Testing+Agile with Jira Tool
************************************
► shorturl.at/xNXZ4
Selenium with Java+Cucumber
********************************
► shorturl.at/aIKMW
Selenium with Python & PyTest
********************************
► shorturl.at/ELW09
Selenium with python using Robot framework
****************************************
► shorturl.at/bcDPZ
API Testing(Postman, RestAssured & SoapUI)
*****************************************
► shorturl.at/uAWY7
Web & API Automation using Cypress with Javascript
********************************************
► rb.gy/4uum2n
Playwright with Javascript
**************************
► shorturl.at/gALZ1
Jmeter-Performance Testing
************************
► rb.gy/ocj7r2
SDET Essencials(Full Stack QA)
*************************
► rb.gy/hlnf2v
Appium-Mobile Automation Testing
************************************
► rb.gy/wmzv64
Java Collections
*****************
► bit.ly/3S66ezE
Python Programming
*********************
► urlis.net/gdsfpb0s
Cucumber BDD Framework
***************************
► bit.ly/3F7d69r
Protractor with Javascript
***************************
► urlis.net/4uddm1qb
####################################
KZbin Playlists:
####################################
Manual Testing & Agile
***********************
► bit.ly/3ujvaYa
► bit.ly/3OYzxQj
SQL
*************************
► bit.ly/3R6XjeG
► bit.ly/3nE0a1s
► bit.ly/3IeKuuJ
linux & Shell Scripting
**********************
► bit.ly/3up1Z6a
► bit.ly/3nzvGxx
Java
**********************
► bit.ly/3R9QfOs
► bit.ly/3AoRMKM
► bit.ly/3IbTTDn
► bit.ly/3ybXInv
► bit.ly/3yCoHdw
Selenium With Java+Cucumber
********************************
► bit.ly/3P2FMm4
► bit.ly/3yhiIt4
► bit.ly/3uokzet
► bit.ly/3a7XIND
► bit.ly/3umN2S9
► bit.ly/3aar7GW
► bit.ly/3y9kD2S
► bit.ly/3uhLskn
Python
********************************
► bit.ly/3agNgU0
► bit.ly/3NJNnoy
► bit.ly/2CTQ4mR
► bit.ly/3OIYWh1
Selenium With Python,Pytest&Behave
***************************************
► bit.ly/3OHHoC9
► bit.ly/3IeNLdv
► bit.ly/2J4tPeT
► bit.ly/3ydSkAq
Selenium With Python Using Robert Framework
(Web&API Testing)
*************************************************
► bit.ly/3nUvlpr
► bit.ly/3nUvE3z
API Testing (Postman,SoapUi,&Rest Assured)
**********************************************
► bit.ly/3OXacWY
► bit.ly/3yh0UhE
► bit.ly/3nC9DWQ
► bit.ly/3yGfhNS
► bit.ly/3OJa11H
► bit.ly/3P2slCC
Mobile App Testing Appium
****************************
► bit.ly/3Al49HG
Performance Testing Jmeter
*******************************
► bit.ly/3nz4fE7
Maven,Jenkins,Git,Github,CI/CD
*******************************
► bit.ly/3P16HPj
► bit.ly/3yhlUVA
► bit.ly/3afYfwT
► bit.ly/3yGzweG
► bit.ly/3yF73Ws
► bit.ly/3NCOmH7
SQL,DB Testing&ETL,Bigdata
*******************************
► bit.ly/3NKOcNY
► bit.ly/3OVpDyI
► bit.ly/3NEvUy0
► bit.ly/3IryxlT
► bit.ly/3RkWBLh
JavaScript Based Automation Tools
********************************
► bit.ly/3nUx51X
► bit.ly/3AqI6Q0
► bit.ly/3yeurbT
► bit.ly/3ujzpTK
Selector Hub Tools
********************
►rb.gy/h3h424
GraphQL
******************
► rb.gy/sj3gys
Cypress API Testing
********************
► shorturl.at/fjKPX
Cypress Web Testing
**********************
► shorturl.at/agjlK
Playwright with Javascipt
**************************
► shorturl.at/adSTY
#SQLTutorial
#DatabaseCreation
#TableCreation
#InsertingRecords
#DataRetrieval
#SQLBeginner
#SQLQueries
#DatabaseDesign
#TableStructure
#DataManipulation
#SQLCommands
#SQLBasics
#LearnSQL
#DatabaseManagement
#SQLMastery
#SQLFundamentals
#SQLTraining
#DatabaseSetup
#TableSchema
#SQLInsert
#SQLSelect
#SQLTips
#SQLLearning
#DatabaseDevelopment
#TableDesign
#SQLData
#SQLSkills
#SQLQueries101
#DatabaseTutorial
#TableManagement
#DataInsertion
#SQLTutorialSeries
#SQLSyntax
#SQLForBeginners
#DatabaseCreation101
#TableCreationTips
#DataManipulationSQL
#SQLCommands101
#SQLEssentials
#LearnSQLNow
#DatabaseDesign101
#SQLTableSchema
#SQLInsertion
#SQLDataRetrieval
#SQLDatabaseSkills
#TableDesign101
#SQLDataTips
#SQLQueryMastery
#SQLDataManagement
#DatabaseAndSQL

[@user-wo3uc5oh5o]

Thank you, my favourite teacher

[@user-gi9ve6uj6g]

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

[@sdetpavan]

Welcome

[@user-dd8xm8hk9f]

WHERE CAN I DOWNLOAD HR DATASET?

[@shahinmadani184]

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

[@sdetpavan]

It's my pleasure

[@shashavalijava9]

Thanks sir ❤❤❤

[@priyankapundir9449]

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

you are really best teacher ever

[@Lilia-pi8pf]

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

[@gopireddyseelam2295]

perfect explanation sir...

[@abdulsukkur419]

Such a wonderful sessions created with detailed contents.

[@aditisharma1132]

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

[@sdetpavan]

Welcome

[@arthi890]

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

[@Poonambhakare123]

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

[@sdetpavan]

Always welcome

[@basanagoudabiradar8669]

Good explanation sir 👍

[@sdetpavan]

Thanks

[@sutriv1725]

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.

[@oc7834]

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

[@sanjaymarathe5249]

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

[@sdetpavan]

most welcome

[@SumeetRaj-kt8en]

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

[@ravinaidu8938]

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

[@hustler1287]

Guys did you get the HR file to practise

[@alexs3846]

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

[@walebalogunk]

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]

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

[@walebalogunk]

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 KZbin video tutorials

[@sreejx]

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

[@rushikeshchandra9686]

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

[@errors264]

Are the power point presentations available ?

[@rajapuramjeevanreddy8737]

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]

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

[@vishalb6427]

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.

[@fisahaberhe1121]

Good bless you.

[@sdetpavan]

My pleasure

[@keshavbhagat8318]

Very Very Thank You Sir 🙏

[@sdetpavan]

Most welcome

[@KrishanKumar-jo7ss]

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

[@sdetpavan]

Thanks

[@amardeepkumar7370]

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

[@siyarsahar9954]

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

[@devopsjockey]

Love from kerala

[@romanyakymets738]

Thank you so much

[@sdetpavan]

You're most welcome

[@mekhron]

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

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

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

[@saranyachandrabos3541]

Thank you....

[@sdetpavan]

Welcome

[@pandikuntamaidhili]

THANK YOU SIR

[@sdetpavan]

Welcome

[@affanshariq3905]

Hi sir, where can i download the hr data set

[@sanketmeshram4895]

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

[@muhammadjunaidmajeed1211]

Excellent!

[@sdetpavan]

Thanks

[@shivabhargav827]

@@sdetpavan can you please share HR DATABASE LINK

[@vaibhavpatharkar6794]

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

[@tukaramgawade807]

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

[@Dheerajkumar-oi8jq]

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

[@balakrishnareddyreddy575]

Sir it's enough for full stack java developers

[@benjaminvictor1051]

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

[@ramyaasuresh]

Thank you sir

[@sdetpavan]

Welcome

[@sharanyacherry3390]

Sir how I should create title record ?

[@desigirlpreeti]

Hello Sir how can I export hr database in my system

[@sindhujavasireddy9921]

Hii sir..sql and MySQL is different??

[@annujsawant1514]

sir from where i can get that HR database ?

[@saurabhpandey4427]

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

[@sanjayyadav-xe7mf]

how can i get hr demo data for practise

[@premkumarramanathan8848]

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

[@hemalatha9863]

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]

if we leave empty it leads to error

[@user-le4kv6pr1h]

how can we download these mysql documentation?

[@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]

Hello sir, please upload the spring framework playlist

[@dn9431]

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

[@SriDevi-rk2bv]

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

[@sj5594]

How to import database for practice

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

[@PK-iu9nc]

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.

[@CRNEntertainments]

where can i download hr data base?

[@mohamediburahimp7661]

Loveeeuuuuuuusomuchhhhhh

[@poorenglish3107]

where is the link to import hr details pls reply

[@hamzakasmani6286]

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.

[@user-dd8xm8hk9f]

WHERE CAN I DOWNLOAD THAT HR DATABASE?

[@SumeetRaj-kt8en]

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

[@srikanthreddy5161]

any advance mqsql videos sir

[@sivamariserla7126]

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

[@sonamchoudhary8235]

how i download sql file to implement queries

[@user-on5zl8je7s]

From where we can download hr database file?

[@satishkumarkunchanapalli9225]

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

[@pratapmaity5412]

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

[@mindvalleyacademy5877]

how to install hr schema ?

[@saurabharbal4474]

Please send the datasets links

[@surajkamble3538]

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

[@sukumarchintha4178]

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]

Yes i also need

[@myvideos6819]

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]

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

[@anithareddy8861]

Ya I also need to practice

[@user-wl4kf7cf5v]

How to import HR schema ?

[@yashbajaj2984]

sir where is the resource of hr data base

[@ayushichauhan6097]

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

[@brizeshhh]

Same

[@mayusdining26]

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

[@animeshrawal5263]

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

[@rajansethi6767]

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

[@ravinaidu8938]

Where we can download that HR schema ?

[@srinubabu2350]

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

[@golden-dragon1442]

Where is the SQL file for the hr database?

[@shavezalam9086]

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

[@stay2code523]

can anyone share the link to download Hr database

[@srinivasreddy-nz7bk]

SIR PLZ SHARE HR DATABASE

[@sanghamitrabadole2117]

sir please provide the notes!...

[@pavanisarada]

Please share that data sir...that hr data

[@sunilkumarbr5539]

KINDLY ATTACH THE HR DATABASE LINK IN DESCRIPTION

[@srinivaschamakuri2690]

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

[@shreyashtewari7603]

Same question

[@snigdhapradhan666]

Sir please provide the hr file

[@shuvamdebbarman5113]

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

[@sumarampur]

Use Alter command

[@basanagoudabiradar8669]

Where is the link for HR database sir?

[@priyankapundir9449]

Sir, please provide.

[@rudreshruu7997]

Plz send that import file

[@shalakhabisht3496]

Hello sir Actually I download mysql software but still not working , is it necessary to download oracle software?

[@samratkeshri]

how to get HR table file

[@sdetpavan]

Pleaase google HR schema

[@MsGourish]

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

[@sdetpavan]

You have to learn SQL programming to become developer.

[@MsGourish]

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

[@MsGourish]

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

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

[@bharathenishetty1550]

31:37 sairam

[@ukstravelenthusiast6355]

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

[@nikunjkumar555]

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

[@ukstravelenthusiast6355]

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

[@nikunjkumar555]

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

[@ukstravelenthusiast6355]

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

[@nikunjkumar555]

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

[@mallikarjunhiremath1673]

hai sir .. m not getting dummy database for practise purpose kindly suggest me

[@chandramohanbhuvana]

HI Mallikarjun, did you get the dummy database, i am not getting it either.

[@harshkhandelwal2818]

Sir please provide HR Database

[@sdetpavan]

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

[@NAVEENKUMAR-du9nm]

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

[@walebalogunk]

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]

@@sdetpavan Thank you sir. It worked

[@kavyapondugula1085]

@@sdetpavan it worked

[@chandarith4555]

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

[@aishwaryagaddam710]

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

[@sdetpavan]

Yes.