Free eBook - SQL Tips and Techniques
Jan 21, 2010
SQL Tips and Techniques
This books mainly for beginner who learn SQL server. This ebook covers the below 25 topics with samples.
Chapter 1 - Understanding SQL Basics and Creating Database Files
Chapter 2 - Using SQL Data Definition Language (DDL) to Create Data Tables and Other Database Objects
Chapter 3 - Using SQL Data Manipulation Language (DML) to Insert and Manipulate Data Within SQL Tables
Chapter 4 - Working with Queries, Expressions, and Aggregate Functions
Chapter 5 - Understanding SQL Transactions and Transaction Logs
Chapter 6 - Using Data Control Language (DCL) to Setup Database Security
Chapter 7 - Creating Indexes for Fast Data Retrieval
Chapter 8 - Using Keys and Constraints to Maintain Database Integrity
Chapter 9 - Performing Multiple-table Queries and Creating SQL Data Views
Chapter 10 - Working with Functions, Parameters, and Data Types
Chapter 11 - Working with Comparison Predicates and Grouped Queries
Chapter 12 - Working with SQL JOIN Statements and Other Multiple-table Queries
Chapter 13 - Understanding SQL Subqueries
Chapter 14 - Understanding Transaction Isolation Levels and Concurrent Processing
Chapter 15 - Writing External Applications to Query and Manipulate Database Data
Chapter 16 - Retrieving and Manipulating Data Through Cursors
Chapter 17 - Understanding Triggers
Chapter 18 - Working with Data BLOBs and Text
Chapter 19 - Working with Ms-sql Server Information Schema View
Chapter 20 - Monitoring and Enhancing MS-SQL Server Performance
Chapter 21 - Working with Stored Procedures
Chapter 22 - Repairing and Maintaining MS-SQL Server Database Files
Chapter 23 - Writing Advanced Queries and Subqueries
Chapter 24 - Exploiting MS-SQL Server Built-in Stored Procedures
Chapter 25 - Working with SQL Database Data Across the Internet
Download:
Hope this book will be useful. 'A thanks' would be nice.
This books mainly for beginner who learn SQL server. This ebook covers the below 25 topics with samples.
Chapter 1 - Understanding SQL Basics and Creating Database Files
Chapter 2 - Using SQL Data Definition Language (DDL) to Create Data Tables and Other Database Objects
Chapter 3 - Using SQL Data Manipulation Language (DML) to Insert and Manipulate Data Within SQL Tables
Chapter 4 - Working with Queries, Expressions, and Aggregate Functions
Chapter 5 - Understanding SQL Transactions and Transaction Logs
Chapter 6 - Using Data Control Language (DCL) to Setup Database Security
Chapter 7 - Creating Indexes for Fast Data Retrieval
Chapter 8 - Using Keys and Constraints to Maintain Database Integrity
Chapter 9 - Performing Multiple-table Queries and Creating SQL Data Views
Chapter 10 - Working with Functions, Parameters, and Data Types
Chapter 11 - Working with Comparison Predicates and Grouped Queries
Chapter 12 - Working with SQL JOIN Statements and Other Multiple-table Queries
Chapter 13 - Understanding SQL Subqueries
Chapter 14 - Understanding Transaction Isolation Levels and Concurrent Processing
Chapter 15 - Writing External Applications to Query and Manipulate Database Data
Chapter 16 - Retrieving and Manipulating Data Through Cursors
Chapter 17 - Understanding Triggers
Chapter 18 - Working with Data BLOBs and Text
Chapter 19 - Working with Ms-sql Server Information Schema View
Chapter 20 - Monitoring and Enhancing MS-SQL Server Performance
Chapter 21 - Working with Stored Procedures
Chapter 22 - Repairing and Maintaining MS-SQL Server Database Files
Chapter 23 - Writing Advanced Queries and Subqueries
Chapter 24 - Exploiting MS-SQL Server Built-in Stored Procedures
Chapter 25 - Working with SQL Database Data Across the Internet
Download:
Mediafire
http://www.mediafire.com/?imz0kilqojz
Rapidshare
http://rapidshare.com/files/309655849/183.chm.html
Hope this book will be useful. 'A thanks' would be nice.
Share
Labels:
Database,
eBooks,
SQL SERVER
