Loading Revision Notes. Please Wait, it may take upto a minute
DBMS - Advantages, Data Abstraction, Data independence, Schema, Instance of DB, Data Models, and related Topics.
Data, Database, Properties of Database, Database Management System, File Systems, Drawbacks of File Systems, and other topics.
DBMS - Advantages, Data Abstraction, Data independence, Schema, Instance of DB, Data Models, and other topics.
Database Languages, DDL, Data Dictionary, DML, DataBase Users, DataBase Administrator, System Architecture, Application / Multi User Architecture, and other topics.
Introduction, Data Types, Schema And Catalog, Select-From-Where, Cross Product, Aliasing / Rename, Star Symbol (*), SQL results as MultiSet, Set Operations, Generalized Projection - Use of Math. Ops, Order By, String Comparison - Like, and other topics.
Table Creation, Domain Creation, Deleting a table - Drop Table, Modifying a Table - Alter Table, Views, and other topics.
Introduction, NULL Comparison, Nested Queries - In/ Some/ Any/ All, Co-Related Query - Exist/ Not Exist, and other topics.
Joins , Aggregate Functions, Grouping, Having Clause, Insert, Delete, and other topics.
Assertions, Triggers, Privileges, Roles, Embedded SQL, and other topics.