SQL Tutorial 3: Create Database,Table, Inserting Records and Retrieving Data
Вставка
- Опубліковано 19 тра 2019
- 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
####################################
UA-cam 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
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
Thank you, Sir. I follow all your videos. No one explain better than you..
Best channel where you can learn in best way. Thank You Sir for sharing such great content :)
Welcome
Thank you, my favourite teacher
Such a wonderful sessions created with detailed contents.
You teach very well even a person having zero knowledge about database can also understand very easily.
You teach from scratch abcd...z
Thanks
perfect explanation sir...
Thank you sir...
Best way to learn mysql......
Always welcome
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.
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.
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
Good explanation sir 👍
Thanks
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
Very Very Thank You Sir 🙏
Most welcome
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 UA-cam video tutorials
@@walebalogunk that's great all the best to you.
Love from kerala
Good bless you.
My pleasure
Excellent!
Thanks
@@sdetpavan can you please share HR DATABASE LINK
Hello Sir,is it enough to study this sql video for gaining knowledge in sql for data analyst career ?
Thank you so much
You're most welcome
Thank you for the lesson.
P.S. When you highlight the syntax it's not visible.
THANK YOU SIR
Welcome
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.
Thank you....
Welcome
Really nice explained. How can I get the power point slides?
Sir please provide me SQL file for hr database... For practice purpose it will be helpful... Please help..
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.
You are the best teacher sir, wow this is awesome teacher but how can I access the hr database?
Thank you sir
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
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
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
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?
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
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 ?
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
Are the power point presentations available ?
Hello sir. I need dump of database ORG? Do you have it anywhere in your website? Couldn't find it
While practicing this the commands in the query are executing multiple times what is the solution for this..?
Sir it's enough for full stack java developers
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
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
Thank You sir ....
Sir where is ppt ?
Loveeeuuuuuuusomuchhhhhh
Hi sir,
where can i download the hr data set
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
Hello sir, please upload the spring framework playlist
Sir how I should create title record ?
Where can i get Employee table document for import into my local sysytem.
Please make video or add link from where we can download and import HR schema.
Where we can download that HR schema ?
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?
Hii sir..sql and MySQL is different??
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🙏🙏🙏
From where can I download the hr schema, please help.
sir from where i can get that HR database ?
Hello Sir how can I export hr database in my system
Hi sir, I can' find resources for 'hr' table, where is it?
how can i get hr demo data for practise
How to import database for practice
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.
how can we download these mysql documentation?
Where Can I Get the SQL FILE named as ' HR ' which is used in this Video ??
where is the link to import hr details pls reply
where you give sql file Sir as you told in this video??
where can i download hr data base?
Sir, how can I get the 'hr ' database?
how i download sql file to implement queries
From where we can download hr database file?
Please send the datasets links
plz share link of database file, so that we can practise. TIA.
any advance mqsql videos sir
sir where is the resource of hr data base
From where I can get (hr file 📁) database?
Where is the database link ,sir?
I want to import that
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.
how to install hr schema ?
Sample HR database where I can get... Please help me friends
Where is the SQL file for the 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 🙏🙏🙏🙏
How to import HR schema ?
Hello sir
Actually I download mysql software but still not working , is it necessary to download oracle software?
KINDLY ATTACH THE HR DATABASE LINK IN DESCRIPTION
how can we import hr data sir?????
Same question
CAN YOU TELL ME HOW TO CHANGE THE DATATYPE OF A COLUMN (HERE, FOR SALARY)????
Use Alter command
SIR PLZ SHARE HR DATABASE
Mr. Pavan, do u have any udemy course on spring and springboot framework? I would like to register. Thanks
Please share that data sir...that hr data
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"
sir please provide the notes!...
can anyone share the link to download Hr database
Sir please reply is this enough for test engineer as a beginner?
Yes.
hai sir .. m not getting dummy database for practise purpose kindly suggest me
HI Mallikarjun, did you get the dummy database, i am not getting it either.
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
how to get HR table file
Pleaase google HR schema
Where is the link for HR database sir?
Sir, please provide.
Sir please provide the hr file
Plz send that import file
31:37 sairam