Relational data Model and Language:
Relational data model concepts,
Integrity& constraints, entity integrity, referential integrity, Keys constraints, Domain constraints, Relational Algebra, relational calculus, tuple and domain calculus.
Introduction on SQL:
Characteristics of SQL,
Advantage of SQL.
SQL data type and literals.
Types of SQL commands.
SQL operators and their procedure. Tables, views and indexes. Queries and sub queries. Aggregate functions.
Insert, update and delete operations, Joins, Unions, Intersection, Minus, Cursors, Triggers, Procedures in SQL/PL SQL
Relational data model concepts,
Integrity& constraints, entity integrity, referential integrity, Keys constraints, Domain constraints, Relational Algebra, relational calculus, tuple and domain calculus.
Introduction on SQL:
Characteristics of SQL,
Advantage of SQL.
SQL data type and literals.
Types of SQL commands.
SQL operators and their procedure. Tables, views and indexes. Queries and sub queries. Aggregate functions.
Insert, update and delete operations, Joins, Unions, Intersection, Minus, Cursors, Triggers, Procedures in SQL/PL SQL
No comments:
Post a Comment