Skip to content
Scan a barcode
Scan

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

Recommended

Format: Paperback

Temporarily Unavailable

We receive fewer than 1 copy every 6 months.

Save to List

Customer Reviews

0 rating
Copyright © 2026 Thriftbooks.com Terms of Use | Privacy Policy | Do Not Sell/Share My Personal Information | Cookie Notice | Cookie Preferences | Accessibility Statement
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
GoDaddy Verified and Secured