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

Selenium with Java+Cucumber
********************************

Selenium with Python & PyTest
********************************

Selenium with python using Robot framework
****************************************

API Testing(Postman, RestAssured & SoapUI)
*****************************************

Web & API Automation using Cypress with Javascript
********************************************

Playwright with Javascript
**************************

Jmeter-Performance Testing
************************

SDET Essencials(Full Stack QA)
*************************

Appium-Mobile Automation Testing
************************************

Java Collections
*****************

Python Programming
*********************

Cucumber BDD Framework
***************************

Protractor with Javascript
***************************

####################################
Youtube Playlists:
####################################

Manual Testing & Agile
***********************

SQL
*************************

linux & Shell Scripting
**********************

Java
**********************

Selenium With Java+Cucumber
********************************

Python
********************************

Selenium With Python,Pytest&Behave
***************************************

Selenium With Python Using Robert Framework
(Web&API Testing)
*************************************************

API Testing (Postman,SoapUi,&Rest Assured)
**********************************************

Mobile App Testing Appium
****************************

Performance Testing Jmeter
*******************************

Maven,Jenkins,Git,Github,CI/CD
*******************************

SQL,DB Testing&ETL,Bigdata
*******************************

JavaScript Based Automation Tools
********************************

Selector Hub Tools
********************

GraphQL
******************

Cypress API Testing
********************

Cypress Web Testing
**********************

Playwright with Javascipt
**************************

#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

[shahinmadani]

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

[giveujg]

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

[aditisharma]

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

[Lilia-pipf]

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

[sanjaymarathe]

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

[rajapuramjeevanreddy]

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.

[sutriv]

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.

[KrishanKumar-joss]

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

[tukaramgawade]

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

[amardeepkumar]

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

[vishalb]

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.

[abdulsukkur]

Such a wonderful sessions created with detailed contents.

[arthi]

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

[vaibhavpatharkar]

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

[rushikeshchandra]

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

[sukumarchintha]

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

[saurabhpandey]

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

[oc]

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

[shehuabdulsalam]

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.

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