SQL tips and techniques:
Saved in:
Bibliographic Details
Main Author: King, Konrad (Author)
Format: Electronic eBook
Language:English
Published: [Indianapolis, IN] Premier Press 2002
Subjects:
Online Access:FAW01
FAW02
Volltext
Item Description:Paralleltitel: SQL tips & techniques
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
Physical Description:1 Online-Ressource (xxi, 1127 pages)
ISBN:0585439966
1931841454
9780585439969
9781931841450

There is no print copy available.

Interlibrary loan Place Request Caution: Not in THWS collection! Get full text