- Introduction
- Understand the characteristics and difference of MySQL and SQL offered by Oracle
- Understand the difference between SQL and SEQUEL, SQL statement and Data Types
- MySQL - open source software for databases - structured query language
- Various Data Types in Oracle 10g along with Select and Insert statement
- DML statements with where condition and relational operators
- Assignment on update statement
- Delete statement with where condition and how to use logical operators
- Understanding ERD and Normalization Concepts
- Draw an Entity Relationship Model diagram for the given case study.
- Understanding Entity Relationship Model
- Learning Constraints , mainly Primary Key constraint
- Learning Constraints, Foreign Key
- Learning Constraints, Foreign Key
- Understanding Integrity, Foreign and Business Constraints
- How to create many to many(m:n) relationship in SQL
- To understand few more Operators/Clauses