Résumé
Owning this reference, which covers everything from the
components of a table to performing batch updates, is a
must! Beginning with tips for the person who is programming
with SQL for the first time, SQL Tips and Techniques grows
with your skills. You can start with Tip 1, "Understanding
the Definition of a Database," and by the last Tip, "Using
ADO to Perform Transaction-Based Processing", you will have
covered all aspects of SQL. Or, you can simply keep this
book as a comprehensive reference for answering specific
SQL questions quickly. However you read it, this invaluable
reference will be the only SQL book you need on your shelf!
Covers all aspects of SQL!
- Speeding Up Table to Table Data Transfers
- Preventing Null Values in a Column
- Removing Duplicate Data
- Using Wildcard Characters
- Using a Trigger to Send an Email Message
- Combining the Results of Two Queries
- Understanding Nested Subqueries
- Using Keywords to Introduce a Subquery
- Creating MS-SQL Server Temporary Tables
- Building Dynamic Web Pages
- Removing a Default from a Database
- Using Nested Queries to Work with Multiple Tables
- Changing Primary and Foreign Keys
- Creating a MS-SQL Server Backup Device
- Adding Data to Specific Columns in a Row
- Changing Values in Multiple Rows at Once
- Executing Dynamic SQL Statements
- Working with Multiple Recordsets
Contents
- Understanding SQL Basics And Creating Database Files
- Using SQL Data Definition Languages To Create Data Tables And Other Database Objects
- Using SQL Data Manipulation Language 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 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 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 Views
- 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
L'auteur - Kris Jamsa
Kris Jamsa, Ph.D., MBA is the author of more than 85 computer books, with cumulative sales of several million copies. In 1992, Jamsa and his wife Debbie founded Jamsa Press, a computer-book publishing company. After expanding the company's presence to 70 countries and 28 languages, Jamsa sold Jamsa Press to a larger publishing house. Today, Jamsa is the founder of the Jamsa Media Group, which produces high-quality computer books for Prima-Tech.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Premier Press |
| Auteur(s) | Konrad King, Kris Jamsa |
| Parution | 22/03/2002 |
| Nb. de pages | 1126 |
| Format | 18,5 x 23,2 |
| Couverture | Broché |
| Poids | 1920g |
| Intérieur | Noir et Blanc |
| EAN13 | 9781931841450 |
| ISBN13 | 978-1-931841-45-0 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
