Chapter 1: Introduction 1 Database 2 DBMS 3 RDBMS different from DBMS 4 SQL 5 Difference between SQL and MySQL 6 Tables and Fields 7 Constraints in SQL 8 Primary Key 9 UNIQUE constraint 10 Foreign Key 11 Join and List its different types 12 Self-Join 13 Cross-Join 14 Index and its different types 15 Difference between Clustered and Non-clustered index 16 Data Integrity Chapter 2: Query 1 Query 2 Subquery and its types 3 SELECT statement 4 Common clauses used with SELECT query in SQL 5 UNION, MINUS and INTERSECT commands 6 Cursor and How to use a Cursor Chapter 3: Relationships 1 Entities and Relationships 2 List of different types of relationships in SQL 3 Alias in SQL 4 View 5 Normalization 6 Denormalization 7 Various forms of Normalization Chapter 4: Table 1 TRUNCATE, DELETE and DROP statements 2 Difference between DROP and TRUNCATE statements 3 Difference between DELETE and TRUNCATE statements 4 Aggregate and Scalar functions 5 User-defined function and its various types 6 OLTP 7 Differences between OLTP and OLAP 8 Collation different types of Collation Sensitivity 9 Stored Procedure 10 Recursive Stored Procedure 11 Creating empty tables with the same structure as another table 12 Pattern Matching in SQL 13 ACID properties 14 Transaction Isolations Chapter 5: Software Installation Introduction Eclipse Installation Jdk1.6 Installation And Configuring to Eclipse Tomcat1.6 Installation And Configuring to Eclipse MySql5.0 Installation Eclipse Font Size Increase