ISBN13: 9798883643339
Book 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
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
- Format:
- Paperback
- Language:
- English
- ISBN13:
- 9798883643339
- Release Date:
- March 2024
- Publisher:
- Independently Published
- Length:
- 128 Pages
- Weight:
- 0.69 lbs.
- Dimensions:
- 0.3″ × 8.5″ × 11.0″
Related Subjects
Customer Reviews
There are currently no reviews. Be the first to review this work.