SQL என்றால் என்ன | SQL Tutorial | What is SQL Database | SQL Basics & Advanced
Вставка
- Опубліковано 6 жов 2024
- Contact: +91 7449000533,+91 9962066262
➡️ 📞Whatsapp Link 1 : wa.link/k6py87 📞⬅️
➡️ 📞Whatsapp Link 2 : wa.link/rauc5b 📞⬅️
Apply for Course: www.kaashivinf...
For more information, call us or Whatsapp at +91 7667663035 | +91 7667664842 | +91 9840678906 Please write back to us at kaashiv.info@gmail.com
SQL என்றால் என்ன | SQL Tutorial | What is SQL Database | SQL Basics & Advanced
what is sql,what is sql database,what is sql injection,what is database,what is tcl,what is sql?,what is dbms,what is apex,what is mysql,what is nosql,what is rdbms,what is ddl in sql,what is dql in sql,what is dml in sql,what is dcl in sql,what is postgres,what is sql server,what is postgresql,what is sql used for,what is sql ledger?,what is sql language,whata is data control language,what is sql and its uses,what is normalization,what is database and sql,what is sql programming
என்ன Sir புடிச்சிருந்தா comment பண்ண சொல்றீங்க. இவ்வளவு அழகா சொல்லி தறீங்க. உங்கள புடிக்காம போகுமா. டெக்னாலஜி வாழ்க. அத சொல்லி தர நீங்களும் வாழ்க ❤❤❤
SQL இவ்வளவு சுலபமான்னு யோசிக்க வைத்த வீடியோ... 👏.
உண்மையிலே ஒவ்வொரு மணித்துளி உழைப்பு வீண் போகாது,நான் நிறைய உங்களின் வீடியோ பார்த்து தெரிந்து கொண்டேன்,நன்றி,,நன்றி நன்றி,
Your speech is very motivated 🎉, 👏
Yesterday, I started watching ur videos. Extraordinary.
Ur hardwork never fails
Name : Gajenthiran.T
Question: what is Sql.?
Answer : SQL means Structured Query Language. It is used to communicate the database.In SQL we have five functions
1.Data Definition Language
2.Data manipulation language
3.Data control language
4.Transaction control language
5.Data Query Language .
*Data Query Language
It is used to retrieve the data from database.
There have 4 main features
1.Select
2.Projection
3.Selection
4.Joins
*Data Definition Language
It is used to Construct a table in the database.
1.create
2.Remove
3.drop
4.truncate
5.alter
*Data manipulation language
It is used to insert, update, delete the data in the table.
*Data control language
It is used to control the flow of data between the users .
*Transaction control language
It is used to perform some operation on DML statements.
12th book copy
Super
Jayasree V
Answer:
SQL is a programming language designed to get information out of and put it into a relational database. Queries are constructed from a command language that lets you select, insert, update and locate data.
Thus, a visual programming tool for developing database-enabled applications may have an appealing, object-oriented graphical interface. But once the programming is done, the system will convert all the underlying database calls and commands into SQL. This simplifies the integration of front-end and back-end systems, especially in multi-tiered client/ server applications.
Oh my God today I find a good teacher thala u r rocking 😍😍I want to study full course
Pls contact our customer care number at 7667662428 or 7667664842. Our team will help you in this regard. In case, you couldn't reach our team, whatsapp our team at 7667662428 or 7667664842 our team will surely respond you within 24 hours. Thanks for contacting us. Have a nice day
(Office work timing - 8 am to 8 pm)
God bless
Best teacher for me with simple unique way teaching in technology skills. Thank you brother 🙏
Hi sir... I have shared with 4 people who asked me to teach about sql... I have learnt when i was 11th std on 2001.. I got a grade A+.. This i used in my company now.. But i know a little query about how to write.. I am searching today on UA-cam.. I got your video.. I am very happy to learn this through your video.. I need to learn depth in sql importantly in DRL language..My ambition is to join a big corporate company... I am the first educated person in my family.... As you said, you are spending the money which is coming from this video to participate and answer people.... You are great... Super... Keep it up... Ungal thondu seiyum manam(kind heart) menmelum onguga(reaching top).. So many people's wishes will grow you more and more in the way of being wealthy and healthy!!!! All the very bast!!!
Name: Hariganesh.K
Question: What is SQL?
Answer: SQL is one of system language of data. SQL is the short form of the "Structured Query Language". It is used to communicate with a database, which is the standard language for relational database management systems. Structured Query Language (SQL) is a specialized language for creating, updating, deleting, and requesting information from database.
Structured Query Language contains Five Major Functions.
Those are following below:
1. Data Definition Language. - Create, Alter, Drop
2. Data Manipulation Language. - Insert, Update, Delete
3. Data Control Language. - Grant, Revoke
4. Data Retrieval Language and - Select (Getting the data)
5. Transaction Control Language. - Commit, Rollback
Those are the major functions happening in SQL.
1. Data Definition Language - (DDL)
Data Definition Language is the primary function of SQL. In this can create the table for the data.
For Example:- I'm Working as Professor in the Department of MBA. I should collect the students data and store them. The management requested the students database with individual profile. Now I using the SQL I can collect and store the data.
So The initial stage I Create the Table, which contains rows and columns.
a. Create - I Create the table with heading of Student_Table by using 1 row and 2 column of date ID, Name.
Using Comment - Create table Student_Table ( id int, Name Carchar(100))
b. Alternate - I forgot the another data of the students or I should add the more data. I can add additional data of Age.
Using Comment - Alter table Student_Table add column age int
c. Drop - I don't want the data. The students are completed their Degree. so I don't want their data in current database. So I want to delete them.
Using Comment - drop table Student_Table
2. Data Manipulation Language - (DML)
Data Manipulation Language is the secondary function in SQL. In primary Function (DDL) can created the table and Stored the data. In DML can insert the data, update the data and delete the data.
For Example: Same Scenario From DDL. I want to collect the data, so I created the table.
a. Insert - So now I insert the data of student of 1 in ID and Ganesh In Name and 22 in Age Column.
By Using Comment - Insert into Student_Table ( ID, Name, Age) Values ( 1, 'Ganesh',22)
b. Update - Oops sorry I mistakes in Ganesh's data. His age is 23 but I entered as 22. so I want to change it, and update it.
By Using Comment - Update Student_Table set age=23 where id = 1
c. Oops one student was dropped out from the college. I want to remove his name from Student_Table.\
By Using Comment - delete from Studnet_Table
3. Data Control Language - (DCL)
Data Control Language is Tertiary Function. It is the Optional or permission type function. In this yes or no, Come and Go Type Function.
In this the collected data can access or not for the Person.
For Example: Same Scenario from DML. I Collected from student and stored in Database. Now Someone can see that data. So I should give access for that person.
a. Grant - I grant the permission to the student. I Give the Access for the date to student Ganesh.
By Using Comment - Grant insert on Student_Table to ganesh
b. Revoke - I want to cancel the access to Ganesh to see the data.
By Using Comment - Revoke insert on Student_Table to ganesh
4. Data Retrieval Language - (DRL)
Data Retrieval Language is the final function on the data in SQL. In this can use the data.
For Example: Same Scenario from DCL. I collected the data and stored the data everything done in data. Now I want to use the data.
a. Select - In this I want to use the data. So I Select the data.
BY Using Comment - Select * from student_table
5. Transaction Control Language - (TCL) - Commit, Rollback
Transaction Control Language is the function happened by the user. Every function happened and one by the user. But in this Third party or Third person will involved.
For Example: Same Scenario From DRL. I selected the data and I want to share the data to 100 people.
a. Commit - I Would like to share his details to 100 companies for work.
b. Rollback - I Want to share the details to 100 companies. But unfortunately in between Power is gone. So I Get back, (i.e) undo the message. I cancelled the messages. For Cancellation Using Rollback Comment.
Phonepe, Google Pay, Paytm : 8883035986 - Hariganesh
Massss kamichita bro GOOD 👍
Really Super info. Eventhough i am not in this field,it is very much helpful to share my children. I will salute for your effort for preparation. God bless you. Dont discourage .
Learn Oracle SQL & PLSQL tutorial in Tamil
ua-cam.com/play/PLKeuwWMXS8xThDuRf9-Cr1kUKWQ2gjgU6.html
unga nala mansuku neeega yapovum enga irudhalum nala irukanum sir neegalum unga familys ku indha credit sir thankyou for this use full video sir
Sir today only am seeing 1st time your video and still not completed full video,but really u r great and very helpful person u r ...thanks sir
What a Deep explain & teaching methods 🙏
Anna na inniketha pathe...romba help full ahh iruku...romba nanri annaaH 🙏
Thank you sir
I m so motivated
Balaji MS in computer science pursue
I am R Dinesh
What is SQL?
SQLis a structured Query Language . It is used to Add a data and retrievel the data in the database.There are four types.They are DML,DDL,DCL and TCL .These language includes comments used for creating a database , retrieval and manipulation.
Thank you sir you will teach in a awesome because , in the middle session some funny comments and this videos are more useful and easily absorbed by us.once more thank you sir,😄😄❤️
Most Underrated UA-camr 😭😭Sir You will win one day 🔥🔥❤️❤️❤️
SQL (Structured Query Language) is a programming language used to manage data stored in relational databases, which store structured data in tables. Its syntax is easy to read.so it's easy to pick up on even if you're completely new to programming, and it's even useful for non-technical careers.
1.SQL can execute queries against a database
2.SQL can retrieve data from a database
3.SQL can insert records in a database
4.SQL can update records in a database
5.SQL can delete records from a database
6.SQL can create new databases
7.SQL can create new tables in a database
8.SQL can create stored procedures in a database
9.SQL can create views in a database
10.SQL can set permissions on tables, procedures, and views.
Thanks So Much Sir. Its Really Nice Video. Its very helpful for my career. Its easy to understand and main Important thing your slang and way of speech really nice. Very Motivative and Very Supportive speech. Really Thank So Much for everything.
i love the way how your explaining .. such a humble person.!
thanks alot brother its help me to developed my assignments
Name: venkatesalu.B
Question: what is SQL
Answer
Structured Query Language, it is used to communicate with a database.It is the standard language for relational database management system . SQL statements are used to update data on a database and retrieve data from database.
Vignesh /what is sql?
Answer :
Structured Query Language (SQL) is a standard data-oriented language which is primarily used to store, retrieve and manipulate data using simple code snippets, called queries, in an RDBMS (relational database management system).
The data is stored in the RDBMS in a structured way, where there exist relations between the different entities and variables in the data. These relations are defined by the database schema which does not only specify the relation between various entities but also the organization of data associated with those entities in the database.
Sir first time unga channel visit panran i always won't subscribe a channel very easily but within the first video I saw that is full stack development full detailed video I love it sir. Pls don't worry for anything sir you will paid off highly by this universe one day for your these much efforts sir. Love you sir thank you sir.
அய்யா உங்கள் speech அருமை நான் புதுது. இப்பதான் கேட்டு கொண்டு இருக்கேன்..
Hi am Janani
Qes: What is SQL?
Ans:
SQL - Structured Query Language
Sql is used to store the database. For eg: Login user name and password can be stored in requierd database.
There are main 5 commands used in SQL:
1) DDL(Data Definition Language)- Create, Alter and Drop.
2)DML(Data Manipulation Language)- Insert,Update and Delete
3)DCL(Data Control Language)- Grant and Revoke
4)TCL(Transaction Control Language)- Commit and Rollback
5)DRL(Data Retrieval Language)- Select Query is used to retrive the data.
டெக்னாலஜி வாழ்க. அத சொல்லி தர நீங்களும் வாழ்க
Tq so much sir ....romba usefull la iruku sir...itha apdiye continue pannunga...pls
Sir 🎉 Unga motivate speech la gud vibe irukku sir thank you so much sir 🙏
Sir unga video motivated irruku sir unga voice positive energy create panndhu sir THANK YOU SIR 😊
Kaviya what is SQL? Ans; SQL is a data transfer language nama kudukara data SQL la convert namku data reply panum this is oru website or application la kudukara data va database ku SQL la pogum next data reply agum then idhu 4types that is data def lang is first create ,then alter ,data manipulation language is data insert panum ,then update and delete then data control lang is granted for user ,data ret Lang is select so that is SQL it is a data va SQL la convert pani output varum that os SQL .
Sir then I have 1 doubt sir user grant panum nu sonigala user ra epdi system ku therium Venkat la neriya member irupanga so epdi edhuku ans solunga sir then this very useful video c language and c++ um video podunga sir for beginers
Good job sir keep it up
Thank u 🙏
i think user la neraya peru irunthalum avangaloda tables la any one record unique va tha iruku records ya primary key vachurunthanga na easy ya grant paniduvanga
eg : user Id name age
1 venkat 21
2 venkat 34
3 venkat 21
ipdi irukunu vachukongalye kandipa primary key ya oru table la only one records la matum tha panna mudiyum useri(primary key) name (varchar) age (int)
athey mathiri sql vanthu backend
user ya namba front end la tha input kudukka vapom apdi user kudura input la database la vanthu store akum database is a back end
confuse pannikathinga itha neeinga frontend and backend connectivity panum pothu easy ya puriyum ungalukku eg: dotnet like front end ithuku use pandra programing languge c#
backend use pandrathu sql >> intha c# and sql la yum connect pandrathu tha ado.net
ithu rendayum connet pandrathu tha ado.net
// yethuvum thappa eduthukathinga yenaku therinja visayatha sonna
Very Very Useful bro, particularly for students......Keep it up bro
thank you so much sir. It is very useful for me sir.
Oh god I really happy to see you kaashiv info . Because in 2014 I learned Java in ur institute now in 2024 I see you in UA-cam...awesome feeling and really good to see you again
hi iam beginer no idea of sql.but i took it as a challange im going to learn.its a career change
Congrats bro.... really useful for us
Name :Dinesh
What is SQL?
It is a structure query language..
It was a standard language database creation and manipulation.my sql is a relational database program that uses SQL queries..
Sql is used to communicate with a database .sql statement are used to perform tasks such update data on a database or retrieve data from a database
Hi kashiv...thanks for this video...I am searching to learn SQL..finally got this best video to learn easily
Very usefull video for beginners to advance
Very useful bro. Thanks for this video. Please keep doing such educational videos. I will share with my friends too. Hats off.
Super sir very useful for technical interview
Thankyou sir,very useful video
Thalaiva..... U are ultimate mass, My MBA degree ungala la than kadaika pothu
Anna nalaiku SQL b. Ed practical exam Anna... Unga video romba useful ah iruka pogudhu Anna....
Vera Level bro .. it's really very helpful ... easily understandable
Hii sir, starting la ena da ithu irunthathu Ellam you tube speaker pola.....but full ahh videos paathen sir .....Truly Respected sir Veera level.Not boring, how to speak and then extraordinary....sir
Yuvaraj D
What is SQL?
SQL stands for Structured Query Language.
It was developed at IBM company by Donald D. Cham berline and Reymond F. Boyce. Its main aim is to store, access and manipulate the data in relational database.
The SQL can perform some main actions such as Create, Read, Update and Delete.
It is a tool to retrieve the required information from the database.
Highly secured
Code reusability
Error Handling
Procedural Language and
Reduces Network Traffic and also..
Narmadha
SQL?
SQL = structured query language
Structured>writing in a structured format .
Query>writing query in structured format.
=>Language with query in structured format.
Explanation: sql is used to operate the database and also retrieval the needed database .
SQL has the functions of create,alter,drop,insert,update,delete,grant,revoke and select.
I am engineering student
Very useful information thanks for your support 😊.....
Learn Oracle SQL & PLSQL tutorial in Tamil
ua-cam.com/play/PLKeuwWMXS8xThDuRf9-Cr1kUKWQ2gjgU6.html
Anna ninga rj Balaji sir pola speach irrukkuna and usefullhairrukkuna tq na
Vindhiya
Qus:wt is SQL
Ans: Language with query in a structured format
Too late, just I saw this vedio is very useful to me.Thanks Sir!
your teaching method is tooo good sir
Sir, You are an amazing human.... Hope you continue to do this work. Sir I'm new to this field and struggling to picking up the IT concepts.What is the procedure to get a job in IT sir. Plz tell me sir
I - Happy to see your message and thanks for contacting us. Pls contact our customer care number at 7667663035 or 7667664842. Our team will help you in this regard. In case, you couldn't reach our team, whatsapp our team at 7667663035 or 7667664842 our team will surely respond you within 24 hours. Thanks for contacting us. Have a nice day
(Office work timing - 9 am to 7 pm - sunday holiday ) If you didn't reach the contact numbers u can send an email to kaashiv.info@gmail.com view more details on the courses at www.kaashivinfotech.com/internship
Note: I will be available in my chennai office from Monday to Saturday (10 AM to 5PM) you can meet me in person for any guidance and support
Thank you
@@kaashiv is it possible to get job only learning SQL???????????
Sir , this is the first time I’m impressed on the video and commenting for the first time . You are awesome sir and hats off to ur good work ! Thanks a lot for sharing your knowledge ! 👌
Thank for make this video sir 🙏...mske unix command information video sir
Hardwork never fails!!!! 🔥🔥🔥
you are great in explaing basics of everything😃
Super boss...kalakureenga.... appreciate your skills
excellent down to earth person u r
For data analysis I have to learn full sql or partial sql which means special sql for data analysis.I am beginner level person.I have this doubt in python for data analysis also.
useful video thank you sir....
Thank you sir
G.Gowtham
What is SQL?
A.structured query language.It is used to communicate with rdbms(relational database management system)data is stored in the form of tables.rdbms is a type of DBMS(database management system) software where DBMS is used to maintain and manage database.
Learn Oracle SQL & PLSQL tutorial in Tamil
ua-cam.com/play/PLKeuwWMXS8xThDuRf9-Cr1kUKWQ2gjgU6.html
Superb sir. Thank you 👍
Sql well defined explanation
Vera level explaining. I like ur exprssing way anna 🔥
G. Balaji
What is SQL ?
Ans : Structured Query Language (SQL) is a language used to view or change data in databases. The statements used in this language are called SQL queries.
Basic use of SQL queries is, to:
INSERT data INTO a database,
DELETE data FROM a database,
UPDATE data in a database,
SELECT (extract) data FROM a database.
Sema sir ..na clg padichapa neeinga professor ah iruntha kandipa coding expert ah irunthurupa sir...
Nice 💐💐💐 valga valamudan 💐💐💐🙏🙏🙏🙏🙌
Hi sir , ur videos are very useful me☺
Your are all videos good usefully sir,keep doing this
S.G.Jeyachandran
What is SQL?
Answer:
SQL is a structured query language and it is used in backend development.It is used to manage data in relational database management system. It is used in handling the structured data. SQL is a ANSI(American National Standards Institute) standard language.SQL is considered a fourth generation language(4GL).
Structured Query Language refers to a standard programming language utilized to extract, organize, manage, and manipulate data stored in relational databases.
Thanks for the content sir
Super bro. I am very happy to listen your words.
Super sir vera level 🔥
I support you. You transfer your knowledge. Good thing keep it up. I watch daily videos. I Working in Singapore. I have wached your daily .
Sirji SQL injection pathi sollunga ji
Super ah solli tharinga anna
NAME : KISHORE.K
QUESTION: WHAT IS SQL?
ANS: standardized programming language that is used to manage relational databases and perform various operations on the data in them.
Very useful video sir... Thank you for this video sir..🎉
very useful info, good explanation
Thank you so much sir
Bharathi.C
What is SQL?
SQL is a standard language for storing, manipulating and retrieving data in databases.SQL stands for Structured Query Language.SQL lets you access and manipulate databases.SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987.
Since I have been training with you, I have more energy, and I feel better about myself. I never knew how much potential I had until I started following your training program. It was hard in the beginning, but now I feel amazing. Thanks so much! Unga voice la oru power irukku thalaivarea, unga video watch pannum pothu thukkam la varavea varathu, robha interestinga irukkum, neenga vera level Bro! robha casuala sirichukitea yeadupinga! Thank you so much for all your videos, all the best! Do well
Heartiest thanks for your feedback
First time I I watched your vedio & watched fully sir , keep it up for your technical helping way
நீங்க மேலும் மேலும் வளர வாய்துக்கள் ❤️❤️❤️❤️
I am trying through your channel
Hello bro... Thanks for this video bro🙏🙏 it is very useful..... Keep doing....
Sorry to say sir according to me the animations can be viewed one time for a slide but it is viewing a lot of time due to this the concentration on your words is getting missed. Other than this your explanation is really awesome. 😇👍
R u a sql expert sis?? Could any ans me 5 query's
Sir super
Name : Vairavel
Q) what is sql
A) 1)Structured Query Language (SQL) is a programming language that is typically used in relational database or data stream management systems. It was developed by IBM in the early 1970s
2)SQL has been incorporated into numerous commercial database products, such as MySQL, Oracle, Sybase, SQL Server, Postgres and others.
3) Four Categories of SQL Commands
*,Data Definition Language
*, Data Manipulation Language (DML)
*,Data Control Language
*,Database Indexing
4) Advantages :
Faster Query Processing
Standardised Language
Portable
Multiple data views
Thanks
Sri Sasikumar SJ
QUESTION : What is SQL?
ANSWER : SQL is a programming language which is used to communicate with the database.
Sir very very thanks 👍😊👍😊👍
Sir i am support for you 🥳?
Sir i study in 11 th std i am becoming data scientist....
What I do first, which course was taken..... Pls sollunga
Good for fecture in sql 😀
Very Useful Brother...Thanks!
Dear sir,
Your videos are very good clarity and we are get good understanding. I like your IT related videos and keep it up sir.Definetily one day you will reach your fixed goal.