MTU Library Catalogue

Syndetics cover image
Image from Syndetics

SQL tips and techniques / Konrad King ; contributing editor, Kris Jamsa.

By: King, Konrad.
Contributor(s): Jamsa, Kris, 1960-.
Material type: materialTypeLabelBookPublisher: [Indianapolis, IN] : Premier Press, c2002Description: xxi, 1127 p. : ill. ; 24 cm.ISBN: 1931841454; 9781931841450.Subject(s): SQL (Computer program language) | Database programmingDDC classification: 005.75 KIN
Holdings
Item type Current library Call number Copy number Status Barcode
General lending MTU Kerry North Campus Library Ground Floor Main 005.75 KIN (Browse shelf(Opens below)) 1 Available 38888000470090
Total holds: 0

Enhanced descriptions from Syndetics:

Beginning with tips for the person who is programming with SQL for the first time, this reference covers all aspects of SQL, from creating database files through performing multiple-table queries, understanding transaction levels and concurrent processing, working with data blobs and text, and explo

Includes index.

Table of contents provided by Syndetics

  • Understanding SQL Basics and Creating Database Files
  • Using SQL Data Definition Language (DDL) to Create Data Tables and Other Database Objects
  • Using SQL Data Manipulation Language (DML) to Insert and Manipulate Data Within SQL Tables
  • Working with Queries, Expressions, and Aggregate Functions
  • Understanding SQL Transactions and Transaction Logs
  • Using Data Control Language (DCL) to Set Up Database Security
  • Creating Indexes for Fast Data Retrieval
  • Using Keys and Constraints to Maintain Database Integrity
  • Performing Multiple-table Queries and Creating SQL Data Views
  • Working with Functions, Parameters, and Data Types
  • Working with Comparison Predicates and Grouped Queries
  • Working with SQL JOIN Statements and Other Muliple-table Queries
  • Understanding SQL Subqueries
  • Understanding Transaction Isolation Levels and Concurrent Processing
  • Writing External Applications to Query and Manipulate Database Data
  • Retrieving and Manipulating Data Through Cursors
  • Understanding Triggers
  • Working with Data Blobs and Text
  • Working with MS-SQL Server Information Schema View
  • Monitoring and Enhancing MS-SQL Server Performance
  • Working with Stored Procedures
  • Repairing and Maintaining MS-SQL Server Database Files
  • Writing Advanced Queries and Subqueries
  • Exploiting MS-SQL Server Built-in Stored Procedures
  • Working with SQL Database Data Across the Internet