Loading Revision Notes. Please Wait, it may take upto a minute
Database Languages, DDL, Data Dictionary, DML, DataBase Users, DataBase Administrator, System Architecture, Application / Multi User Architecture, 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.