SQL Tutorial 5: DDL (Data Definition Language) Commands

Topics:-
-------------------------
1) CREATE
2) ALTER
3) DROP
4) TRUNCATE
5) RENAME
6) Differences Between DROP, TRUNCATE & DELETE
#########################
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/gdsf...
Cucumber BDD Framework
***************************
► bit.ly/3F7d69r
Protractor with Javascript
***************************
► urlis.net/4udd...
####################################
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
#DDLCommands
#DatabaseDesign
#DataDefinitionLanguage
#SQLBasics
#CreateTable
#AlterTable
#DropTable
#AddColumn
#ModifyColumn
#PrimaryKey
#ForeignKey
#UniqueConstraint
#Indexing
#SQLSchema
#TableDesign
#DataNormalization
#SQLForBeginners
#DatabaseManagement
#SQLDatabase
#DatabaseSchema
#DataModeling
#SQLCommands
#DatabaseDevelopment
#SQLTips
#DataManipulation
#SQLQueries
#DatabaseAdministration
#SQLDesign
#LearnSQL
#StructuredQueryLanguage
#SQLServer
#DatabaseCreation
#SQLMastery
#SQLSyntax
#SQLTraining
#SQLCertification
#DatabaseTutorial
#DataOrganization
#SQLSkills
#TableNormalization
#DDLStatements
#DatabaseBasics
#SQL101
#DataIntegrity
#SQLSchemaDesign
#AdvancedSQL
#DatabaseOptimization
#SQLBestPractices
#DDLConcepts

[@irfandy4hmad]

Shortcut key : CTRL + ENTER : Execute the current line CTRL + SHIFT + ENTER : Execute all line

[@baxtables]

thanks bro

[@sourabhdesai4254]

THANKS MAN!

[@woodworksgeek]

Pavan = God of Free Education

[@dilliprasad5675]

When i started watching your vedios compleately my brain getting knowledge from this tutorials . any ways thank you very much sir i personally recomended this chanel for 50 members .🙏🙏🙏🙏🙏🙏🙏

[@sdetpavan]

Glad to hear that

[@basanagoudabiradar8669]

Understandable knowledge for DDL ....👍sir

[@sdetpavan]

Thanks

[@shameemahamad2617]

very nice series of videos for anyone to get good understanding of SQL.

[@sdetpavan]

Thanks

[@sumitgoyal385]

EXCELLENT FOR FIRST TIME CRYSTAL CLEAR DIFFERENCE BETWEEN DROP,DELETE AND TRUNCATE EXCELLENT VIDEO

[@sivaprasad6739]

Even it is lengthy more informative, thanks for your kind time do videos like this...

[@sdetpavan]

Welcome

[@saranyachandrabos3541]

Thank you so much

[@sdetpavan]

Most welcome!

[@abhinavgarg1988]

I am feeling so lucky to have a teacher like you. Thank you so much for making this informative video ☺️🙏

[@sdetpavan]

Glad to hear that

[@santoshkumar-to7lb]

such a great video and great human being your. thanks for uploading and sharing this information. god bless

[@sdetpavan]

My pleasure

[@sivaprasad6739]

Really Your Presentation is Awesome to listen.

[@sdetpavan]

Thanks

[@Eng-Mohamed-Ahmed]

thanks sir you helped more

[@sdetpavan]

It's my pleasure

[@romanyakymets738]

Thank you very much!

[@sdetpavan]

welcome

[@reshma1375]

Tnk u sir very informative 👍🏻

[@sdetpavan]

Welcome

[@allmyfans9782]

Super sir...,,your Explanation....

[@sdetpavan]

Thanks

[@keshavbhagat8318]

Very Very Thank You Sir 🙏

[@sdetpavan]

Most welcome

[@ukshahrukh]

how to add HR database with all tables?

[@bharathenishetty1550]

Great explanation

[@sdetpavan]

Thanks

[@muhammadjunaidmajeed1211]

Excellent!

[@twinkleyadav2272]

hello sir This SQL playlist is superb but i want to know if this is only for testers or there is something different topics for SQL for campus preparation

[@Nikhil-qi4oz]

is this playlist is useful for BigData?

[@supriyapawar8417]

Thank you !!

[@sdetpavan]

Welcome

[@sonamjangbusherpa8018]

thankyou sir

[@sdetpavan]

Welcome

[@dilipkumarp7533]

Thanks sir

[@sdetpavan]

Welcome

[@Imana23]

how do i import the employer datebase to my database? can anybody help?

[@suhananadaf5993]

Sir, will you provide the dataset so that we can practise

[@lordkrishna2775]

God bless...

[@sdetpavan]

My pleasure

[@mahamoodulhasanmd4078]

unable to find session on DML. Kindly share the video of DML

[@Aunestly]

At 14:23 Wondering how you would modify the data type by type if you wanted to change it from a varchar to a integer instead of the size of the data type.

[@DineshKumar-ml2tm]

your videos are really awesome sir, Can anyone tell me in which part the UPDATE CONCEPT is there?

[@NeverStopLearning56]

DML

[@shubhamsinha9037]

Hello Sir, your video is so good. One thing i want to tell that update and delete videos for DML is not there.

[@Ajaykumar-hd7dt]

sir while I am deleting data using delete command I am unable to rollback the data as I am using autocommit=0 but it is not effecting could you please help me in this.

[@AbdulHannan-dg6dl]

use this command to insert values. select all these commands together to commit changes and then follow the same process. I solved my problem through this process. INSERT INTO STUDENT VALUES (101,'DAVID'); INSERT INTO STUDENT VALUES (102,'SMITH'); INSERT INTO STUDENT VALUES (103,'SCOTT'); COMMIT; SET SQL_SAFE_UPDATES=0; SELECT * FROM STUDENT; DELETE FROM STUDENT; ROLLBACK;

[@divyaram1237]

that’s really great thank you

[@akshatan4520]

Just a question for alter command Add command works with or without () around LastName. but it does not work the same way to Modify?. is there any specific reason. ALTER table student ADD COLUMN (LastName varchar(10)); ALTER table student ADD COLUMN LastName varchar(10); ALTER table student MODIFY COLUMN LastName varchar(15); -------->Works ALTER table student MODIFY COLUMN (LastName varchar(10)); --------> Doesnot work

[@amarnadhreddy9746]

I want your sql ppt sir where can i get it

[@vishalkoundal5008]

hello sir u mentioned that how to add new column in the table GRADE .....But when I am trying to populate the column .....the query will next execute please help me ........Is it the correct query to update the record of new added column....you also mentioned the same but not run the query ......I am trying to execute but it will run ...... Update table Student set grade='A' where s_id=1;

[@sreejx]

hi Vishal do not use table keyword after update.

[@akkhileshv4323]

@@sreejx 😂

[@revathylakshminarasimhan1141]

Can you please explain how truncate and drop works when autocommit is set to 0?

[@lalithala4040]

Hi sir i created a table . i got 2 warnings like integer display width is deprecated and will be remove in future release. and In table values not displayed. please help me on this.

[@akulavenkatesh1587]

problem with integer size

[@divyaram1237]

Still If you face same problem don’t give any number in “INT “

[@payalpatel-ft1df]

DESCRIBE command don't work in bdeaver .. Can anyone please help which command we can use in bdeaver to view table

[@chandradeepkumar2038]

while watching video parallelly i want to practice

[@nbkmpat]

How to add new values in newly created column

[@villagecookingwithak9724]

Insert

[@Sam-vv1gu]

Using update query bro

[@jainhimanshu439]

sir HR ka ye database hmare pas bhi a jaye same . hmare work bench m. to hm ye commands execute kr ke dekh lenge. please help in this.

[@chandradeepkumar2038]

Hi sir, How I will get Hr table for practice

[@meghashreebhat7596]

ROLLBACK command is not working I tried enabling autocommit =0 and sql safe updates =0 . Still it cannot be rollback. Please help me

[@bharathenishetty1550]

might be you are doing some wrong operatiosn orderwise carefully, do the operations , it will work.

[@retbao]

@@bharathenishetty1550 i faced the same issue. 1-query to check table 2- delete.. 3- rollback 4- query again ==> data is gone

[@AnilSharma-co6iw]

hello sir ..can you plz share SQL notes?that's really a big help for me.

[@pegahmoeini1350]

Can you provide the PowerPoint, please?

[@rajivraushan1387]

ALTER TABLE STUDENT CHANGE COLUMN SNAME STUNAME VARCHAR(20);

[@woodworksgeek]

THANK YOU!

[@lokeshp1929]

Can anyone help me to get that hr database?

[@lokeshp1929]

That given link doesn't have that database

[@nhjosi8929]

sir i want to start my career in testing please help me please share testing tutorial link

[@r.sankaranrajasimhan630]

23:20

[@anushasandy]

SIR ANY NOTES AVABLE FOR THIS SERIES?

[@sdetpavan]

www.pavantestingtools.com/p/sql-tutorials.html

[@anushasandy]

@@sdetpavan Thank you sir

[@er.nikhilmehta8367]

Sir in video many times the screen is not visible.

[@amolvijay309]

Kuch bhi🙄