Hi ఫ్రెండ్స్ ఈ వీడియోలో SQL లో Class Day 05 ని తెలుగులో Explain చేసాము. By Excel Telugu Videos (Srinivas Reddy).
This Short is About SQL Class Day #05 in Telugu for SQL Developers, Data Analyst and Business Analyst. By Srinivas Reddy Excel Telugu Videos
SQL is divided into the following Types:
1) Data Definition Language (DDL)
2) Data Manipulation Language (DML)
3) Data Query Language (DQL)
4) Transaction Control Language ( TCL)
5) Data Control Language ( DCL)
Data Definition Language:
==================
CREATE - Used to create an object
ALTER - Used to modify an existing object
DROP - Used to delete the object
TRUNCATE - Used to delete only the data of an object
RENAME - Used to Changing the name of an object
Creating a Table Using Query:
======================
Syntax:
CREATE TABLE tablename
(colname datatype(size), Colname2....);
--Creating a Table Using Query:
CREATE TABLE EMP
(
EID VARCHAR(5),
ENAME CHAR(15),
BASIC_SAL INT
)
go
SP_HELP EMP
#sql #excel #shorts #telugu #excelteluguvideos #mysql #sqltelugu
Please Follow us on Instagram: / excelteluguvideos
Telegram: https://t.me/EXCELTELUGUVIDEOS