Sql Programming: Beginners
(Paperback)
Amit K,
Independently Published (Publisher)
Published
2024
Reviews
0
Ships within 12-14 days
Out Of Stock
₹2296.00
₹2609.00
12% off(Paperback)
Amit K,
Independently Published (Publisher)
Ships within 12-14 days
Out Of Stock
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
