Database Management Systems

Basic concepts: Advantages of a DBMS over file processing system, Data Abstraction, Database Languages, Data Independence. , Components of a DBMS and overall structure of a DBMS, Three views of Data (External View, Conceptual View, Internal View), Three level architecture of DBMS, Data Independence, Client Server Architecture SQL: Data definition language, Data manipulation language, SQL, Object naming conventions, Object naming guidelines, Data types, Tables (Creating , Inserting, Updating and deleting tables and using constraints), Views, Indexes, SQL Command :- DESCRIBE, SELECT, WHERE CLAUSE, DISTINCT CLAUSE, ORDER BY,HAVING, LOGICAL OPERATIONS, SQL OPERATORS, JOIN Aggregate functions, String functions and date time functions, Null values