SQL Tips & Techniques (Miscellaneous)
ISBN: 1931841454
EAN: 2147483647
EAN: 2147483647
Year: 2000
Pages: 632
Pages: 632
Authors: Konrad King, Kris Jamsa
SQL Tips and 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 Setup 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 Multiple-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
SQL Tips & Techniques (Miscellaneous)
ISBN: 1931841454
EAN: 2147483647
EAN: 2147483647
Year: 2000
Pages: 632
Pages: 632
Authors: Konrad King, Kris Jamsa
- Article 110 Requirements for Electrical Installations
- Article 225 Outside Branch Circuits and Feeders
- Article 312 Cabinets, Cutout Boxes, and Meter Socket Enclosures
- Article 324 Flat Conductor Cable Type FCC
- Example No. D2(a) Optional Calculation for One-Family Dwelling Heating Larger than Air Conditioning [See Section 220.82]