SQL என்றால் என்ன | SQL Tutorial | What is SQL Database | SQL Basics & Advanced
ฝัง
- เผยแพร่เมื่อ 21 พ.ย. 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
SQL இவ்வளவு சுலபமான்னு யோசிக்க வைத்த வீடியோ... 👏.
என்ன Sir புடிச்சிருந்தா comment பண்ண சொல்றீங்க. இவ்வளவு அழகா சொல்லி தறீங்க. உங்கள புடிக்காம போகுமா. டெக்னாலஜி வாழ்க. அத சொல்லி தர நீங்களும் வாழ்க ❤❤❤
Your speech is very motivated 🎉, 👏
டெக்னாலஜி வாழ்க. அத சொல்லி தர நீங்களும் வாழ்க
Best teacher for me with simple unique way teaching in technology skills. Thank you brother 🙏
உண்மையிலே ஒவ்வொரு மணித்துளி உழைப்பு வீண் போகாது,நான் நிறைய உங்களின் வீடியோ பார்த்து தெரிந்து கொண்டேன்,நன்றி,,நன்றி நன்றி,
unga nala mansuku neeega yapovum enga irudhalum nala irukanum sir neegalum unga familys ku indha credit sir thankyou for this use full video sir
Yesterday, I started watching ur videos. Extraordinary.
Ur hardwork never fails
அய்யா உங்கள் speech அருமை நான் புதுது. இப்பதான் கேட்டு கொண்டு இருக்கேன்..
Anna na inniketha pathe...romba help full ahh iruku...romba nanri annaaH 🙏
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
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....
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
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.
Sema sir ..na clg padichapa neeinga professor ah iruntha kandipa coding expert ah irunthurupa sir...
Sir 🎉 Unga motivate speech la gud vibe irukku sir thank you so much sir 🙏
Thank you sir
I m so motivated
Balaji MS in computer science pursue
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 TH-cam...awesome feeling and really good to see you again
Sql well defined explanation
thanks alot brother its help me to developed my assignments
Most Underrated TH-camr 😭😭Sir You will win one day 🔥🔥❤️❤️❤️
Thala … live video la join panna solli quiz kelunga bro
Athu semmaya irukkum
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
Anna ninga rj Balaji sir pola speach irrukkuna and usefullhairrukkuna tq na
Super ah solli tharinga anna
Unaga siripu ungala engiyo kuditu pokapovuthu ji
Very useful video sir... Thank you for this video sir..🎉
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 TH-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!!!
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.
sir feel pannathaga sir unga videos na regular view pannuven sir neenga nalla teach pannriga sir super sir🔥🔥...
What a Deep explain & teaching methods 🙏
Nice 💐💐💐 valga valamudan 💐💐💐🙏🙏🙏🙏🙌
your teaching method is tooo good sir
First time I I watched your vedio & watched fully sir , keep it up for your technical helping way
Tq so much sir ....romba usefull la iruku sir...itha apdiye continue pannunga...pls
thank you so much sir. It is very useful for me sir.
Very usefull video for beginners to advance
hi iam beginer no idea of sql.but i took it as a challange im going to learn.its a career change
Sir unga video motivated irruku sir unga voice positive energy create panndhu sir THANK YOU SIR 😊
Thankyou sir,very useful video
Too late, just I saw this vedio is very useful to me.Thanks Sir!
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
th-cam.com/play/PLKeuwWMXS8xThDuRf9-Cr1kUKWQ2gjgU6.html
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.
i love the way how your explaining .. such a humble person.!
நீங்க மேலும் மேலும் வளர வாய்துக்கள் ❤️❤️❤️❤️
Super sir very useful for technical interview
Hi kashiv...thanks for this video...I am searching to learn SQL..finally got this best video to learn easily
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.
Very Useful Brother...Thanks!
Thank you sir your video is useful
yaru bro sonna hit ✨️akathunu athala akum
Niga neraya video potunga 🤗 always I like it
useful video thank you sir....
Super bro. I am very happy to listen your words.
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
I am engineering student
Very useful information thanks for your support 😊.....
Learn Oracle SQL & PLSQL tutorial in Tamil
th-cam.com/play/PLKeuwWMXS8xThDuRf9-Cr1kUKWQ2gjgU6.html
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,😄😄❤️
Vera Level bro .. it's really very helpful ... easily understandable
Very Very Useful bro, particularly for students......Keep it up bro
Hi sir , ur videos are very useful me☺
Good for fecture in sql 😀
Super boss...kalakureenga.... appreciate your skills
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.
I am trying through your channel
Thanks for the content sir
excellent down to earth person u r
Thanks
Very useful bro. Thanks for this video. Please keep doing such educational videos. I will share with my friends too. Hats off.
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
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 .
Excellent content
Congrats bro.... really useful for us
Sir .. I'm ur new Student 🤩
bro neenga vera level 👍👏👏👏👏👏👏
Thank you sir
Name: Jothi
Way of speech is very impressive.
Nan recent ah thaan paaka aarambichurukken.
Nalla pannunga and Nan ennoda Juniors ku refer pandren unga videos ellathayum.
Amount ah Kashtapadra pasangaluku sponshirp panna innum nalla irukum (request thaan not a advice)...May I call you ,Sila vishayangal phone la pesuna nalla irukumnu namburen
Hardwork never fails!!!! 🔥🔥🔥
Sirji SQL injection pathi sollunga ji
How to learn sql and to code sql bro
You are really amazing this help me a lot
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.
If you couldn't reach by call. Whatsapp : 7667663035 or 7667664842 our team will surely respond you within 24 hours.
Or
Email to kaashiv.info@gmail.com
View more details on the courses/internship at www.kaashivinfotech.com/internship
Thanks for contacting us. Have a nice day
(Office work timing - 9 am to 7 pm - sunday holiday )
Note:
1. 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
2. If you couldn't reach us. Pls send ur number via email or via insta. We will call you back.
Thank you
Your are all videos good usefully sir,keep doing this
Very useful sir
Superb sir. Thank you 👍
Iam seen full video
Nan Frank aah solraen sir. 7years before course pana apo ewlo theliva yaaru soli kodukala. Unfortunately nan epo backend developer work panala but teaching way enakku pidichrukku... Innum neraya SQL pathi podunga . Thanks for giving this video sir
THANKS ANNA...............
Your video very useful bro
Thank you so much sir
We will support for our technology don't worry 😜👍👍✌️
Hello bro... Thanks for this video bro🙏🙏 it is very useful..... Keep doing....
Thank for make this video sir 🙏...mske unix command information video sir
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.
Vindhiya
Qus:wt is SQL
Ans: Language with query in a structured format
You are Really awesome sir.... 🔥✨🤩
very useful info, good explanation
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.
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???????????
So final technologies study will win thru yuo you sir 🙏
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 👍
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.
Very good sir