#Create View from a base table(Tamil) #SQLViewsinTAMIL #RDBMSinTamil

SQL Views | How to create a view from single base table | DATABASE OBJECTS | #CREATEVIEW | DROP VIEW | DML COMMANDS ON VIEWS | Can update a view | Can we insert records using views | PGTRB COMPUTER SCIENCE #PGTRB #RDBMSINTAMIL | #SQLINTAMIL #PGTRB #PGTRBCOMPUTERSCIENCE | #PGTRBCOMPUTERSCIENCE2021 #ComputerInstructorGradeI #TRBCOMPUTERINSTRUCTORGRADE I - 2021 #DDL #DML #TCL #SEQUENCE #GROUPFUNCTIONS #CREATEVIEW #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 R Programming video lectures Click https://www.youtube.com/playlist?list=PLBVehx96bLfe8BRE62Lgc5edoLVykp1W3

For Python Programming video lectures Click https://www.youtube.com/watch?v=TyzcinkdSu0&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