SQL BASIC QUERIES PART1 IN TAMIL | RDBMS | SQL | DDL | DML | #TRB COMPUTER INSTRUCTOR GRADE I - 202

RDBMS LAB | SQL SIMPLE QUERIES | STRUCTURED QUERY LANGUAGE | #CREATE TABLE #INSERTrecordsinTable #ALTER- ADD MODIFY #SELECT #UPDATEcommand #DELETEcommand #DROPTABLE #SQLCOMMANDS #DDLCOMMANDS | DML COMMANDS | TCL COMMANDS | PGTRB COMPUTER SCIENCE #RDBMSINTAMIL | #SQLINTAMIL #PGTRB #BCE-CSC11 #UNIVERSITY OF MADRAS #RELATIONAL DATABASE MANAGEMENT SYSTEM #AnnamalaiUniversity #AdvancedRDBMS#PGTRBCOMPUTERSCIENCE | #PGTRBCOMPUTERSCIENCE2021 | #ComputerInstructorGradeI | #TRBCOMPUTERINSTRUCTORGRADEI | #TRBCOMPUTERINSTRUCTORGRADE I - 2021 #DDL #DML #TCL #SEQUENCE #GROUPFUNCTIONS #CREATEVIEW #LIKEOPERATOR #INOPERATOR #WHERECLAUSE #PDS1505
2. Creating a table
3. Inserting records in a table
4. Altering the table structure.
5. Deleting data from table
6. Updating data from table.
7. Select command
8. Where clause
9. Aggregate functions
10. Numeric functions ( Absolute, ceiling, floor, modulo, round off, square, Square Root,
power)
11. Constraints
12. Group By, Having
13. Operators (and, or, not between, In , not in, is null, is not null, like, Order By)
14. String Functions (Lower, Upper, Replace, left-trim, right-trim, substring, Length,
rename)
15. Drop (table, database)
16. Truncate



For Python Programming video lectures Click https://www.youtube.com/playlist?list=PLBVehx96bLfd8ULxbTbOaM2U63FiyE-bP

For Computer Graphics video lectures Click https://www.youtube.com/watch?v=C4i0Uz0Aw3g&list=PLBVehx96bLfd3Rs2TvX9nzMJrxPoHfh2S

For RDBMS (PL-SQL/SQL) Lab Solutions Click https://www.youtube.com/watch?v=4klpOJUx_g4&list=PLBVehx96bLffgLvbLlOCvj0knsDaUitYf

For Data Mining videos lectures in Tamil Click https://www.youtube.com/playlist?list=PLBVehx96bLff6XBNXBsoGyMoi-3kDfFIP

For more topics, Subscribe our Channel https://www.youtube.com/channel/UC06rg-b7Jc7Wb59NZMS7x5g