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

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

[irfandyhmad]

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

[sumitgoyal]

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

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

[shameemahamad]

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

[Imana]

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

[sivaprasad]

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

[basanagoudabiradar]

Understandable knowledge for DDL ....👍sir

[revathylakshminarasimhan]

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

[ukshahrukh]

how to add HR database with all tables?

[dilliprasad]

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

[mahamoodulhasanmd]

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

[twinkleyadav]

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

[sivaprasad]

Really Your Presentation is Awesome to listen.

[shubhamsinha]

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

[payalpatel-ftdf]

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

[jainhimanshu]

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.

[akshatan]

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);

ALTER table student MODIFY COLUMN (LastName varchar(10)); Doesnot work

[santoshkumar-tolb]

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

[vishalkoundal]

hello sir u mentioned that how to add new column in the table GRADE when I am trying to populate the column query will next execute please help me it the correct query to update the record of new added column....you also mentioned the same but not run the query am trying to execute but it will run




Update table Student set grade='A' where s_id=1;

[DineshKumar-mltm]

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