DBS

• DB, DBS
• View of Data
  • Architecture of DBMS
  • Data Model
  • Instance and Schemas
• Database Languages
  • DDL
  • DML
• Introduction to Database Desgin, Database Engine
• Database Architecture and Database Application Architecture
• Database Users and DBA(Database Administrators)

• Structure of Relational DB
• Keys
  • superkey
  • candidate key
  • primary key
  • alternate key
  • foreign key
• Relational Algebra
  • select, project, cartesian product, join, set operations(union, intersection, set difference), assignment, rename

• Introduction to SQL
• SQL Data definition
  • built-in basic data types
  • basic schema definition
  • updating table
• Basic Structure of SQL queries
• Additional Operations
  • rename operation
  • string operations
  • order by
  • where-between-and
  • where ; tuple comparison
• Set Operations
  • union, intersect, except
• Null Values
• Aggregate Functions

• Nested Subqueries

  
  

• Database Design Using the ER Model

  
  

• Intermediate SQL

• Normalizaion

  
  

• JDBC