Sql Programming: Beginners

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