Database Session Topics - Newbies

Database Session Topics

What is RDBMS – Abstraction Layers

Concepts

§  SQL

§  Relationships

§  Transactions

§  ACID – Atomicity Consistency Isolation Durability

§  CRUD

§  DATABASE – data file & log file

§  ODBC / JDBC

§  Database Objects

§  Table -- column row

§  View

§  Transaction Log

§  Trigger

§  Index

§  Stored procedure

§  Functions

§  Cursor

§  Indexes:  Primary key, foreign key 

Components

§  Concurrency control

§  Data dictionary

§  Query language

§  Query optimizer

§  Query plan

Conclusion

§  Data Models : ER Models / Dimensional Models

§  OLTP/OLAP/ETL