Skip to content

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

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″
ComputersComputers & Technology

Customer Reviews

0 customer ratings | 0 reviews
Write a Review

There are currently no reviews. Be the first to review this work.