Overview

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

Full Product Details

9798883643339

Table of Contents

Reviews

Author Information

Tab Content 6

Customer Reviews

Recent Reviews

Countries Available