SQL Zero To Hero | Session-3 | DDL Commands | Working with Table Structures | @vitechtalks6017 |

Hi Welcome to ViTech Talks , In this video you can learn how to perform DDL operations
Create
Alter
Drop
truncate
Rename
Assignment - https://github.com/VITechTalks/Sql-Practice/blob/main/HR%20Database%20ER%20Diagram.png

SQL data Types- https://learn.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-ver16

SQLServerInstallation - https://www.microsoft.com/en-in/sql-server/sql-server-downloads
SQLServerManagementStudio - https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

SQL Zero to Hero - https://www.youtube.com/watch?v=LlwfFnjrYwc&list=PLFPnaYaZXRwzWLz11y-4_eBlSse6C-J2I
Join this channel to get access to perks:
https://www.youtube.com/channel/UCOCmIxlnxT4NICdOR1E36vQ/join

SQL Sever Install : https://youtu.be/FqYBtXPLWfI

Class Notes:
--------------------------------

--Create database with the name as HR
create database hr;

use hr;
create table student (
sno int, -- 101
sname varchar(20), --Nani
marks int --90
);

select * from student;

-- add the new column nas as city varchar(20)
alter table student
add city varchar(20),
state varchar(30) ;

alter table student drop column marks;

alter table student drop column state;

alter table student
alter column city varchar(50) ;

alter table student
add emails varchar(20);

--drop the column and add new column
---alter table student rename column emails TO email ; -- mysql/oracle

exec sp_rename 'student.emails', 'email' , 'column';

--rename student TO student1 ; -Mysql /oracle

exec sp_rename 'student' , 'student-1' ;

exec sp_rename 'student-1' , 'emp' ;
select * from student ;

--truncate and drop

--Create -- in order to create database /tables/views/fucntions and storedprocedure ...etc
--Alter -- in order to modify the columns/add the columns with existing tables
--Rename -- in order to rename the existing table names
--truncate -- is the keyword in order to delete the entire table data
--drop -- in order to delete table permanently we are going to use (delete the data then table structure will delete)
select * from emp ;

insert into emp (sno,sname,city,email) values
(101,'Nani' ,'BLr' ,'nani@test.com') ;
insert into emp (sno,sname,city,email) values
(102,'Anu' ,'Hyd' ,'anu@test.com') ;
truncate table emp ;
drop table emp ;

@vitechtalks6017
@ViVisionTechnologies
#sql
#sqlzerotohero
#vivision
#vivisiontechnologies
#snowflake
#vivision technologies
#snowflaketraining
#sqlzerotohero
#database
#snowflakeintegration
#sqlroadmap
#vivisiontech
#sqltutorial
#sqlforbeginners
#snowflaketraining
#sqlzerotohero
#database
#snowflakeintegration
#sqlroadmap
#vivisiontech
#sqltutorial
#sqlforbeginners
#snowflakes
#snowflake
#snowflakeonlinetraining
#ADF #DBT #AZuredatafactory
#softwarejoborientedtraining
#DBTCloud #Oracledatabase
#Git #AWS #Snowflake
#vivisiontechnologies
#SnowflakeScenariobasedInterviewQuestion
#snowflakedatawarehouse #snowflaketutorial
#snowflakedatabase #snowflaketutorial #snowflakeonline #adf #dbt
#Snowflake #WhatIsSnowflake #WhatIsSnowflakeDatawareHouse #SnowflakeTutorial #WhatIsSnowflakeDatabase #SnowflakeArchitecture #SnowflakeFeatures
#mysql
#mysqlsoftware
#mysqlsetup
#sqlserverinstallation
#sqlserversetup
#sqlservertutorial
#SQLServer2022Installation
#sqlservermanagementstudio
#databasemanagement
#sqlinstallationguide
#SQLServerExpressInstallation
#SQLServerDeveloperEdition
#StepByStepSQLServerInstallation
#SQLServerConfig
#SQLServerInstall
#ddl
#create
#alter
#truncate
#rename
#drop

Видео SQL Zero To Hero | Session-3 | DDL Commands | Working with Table Structures | @vitechtalks6017 | канала ViTechTalks