Introduction to SQL and
  • Introduction
  • Understand the characteristics and difference of MySQL and SQL offered by Oracle
SQL, SeQUEL, Queries/SQL statements, Data Types
  • Understand the difference between SQL and SEQUEL, SQL statement and Data Types
MySQL - open source database - structured query language
  • 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 clause
  • DML statements with where condition and relational operators
  • Assignment on update statement
Delete statement with where condition and how to use logical operators
  • Delete statement with where condition and how to use logical operators
Understanding Entity Relationship Model
  • 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
  • Learning Constraints, Foreign Key
Understanding Integrity, Foreign and Business Constraints
  • Understanding Integrity, Foreign and Business Constraints
How to create many to many(m:n) relationship in SQL
  • How to create many to many(m:n) relationship in SQL
To understand few more Operators/Clauses
  • To understand few more Operators/Clauses