Troubleshooting SQL (Application Development) - Softcover

Houlette, Forrest

Softcover

ISBN 10: 0072134895 ISBN 13: 9780072134896

Verlag: Osborne/McGraw-Hill, 2001

Inhaltsangabe

Explains optimizing SQL statements and procedures and creating a customized SQL debugging environment for error-free applications. This work includes programming tips and coverage of Oracle SQL and PL/SQL and T-SQL for SQL Server.

Über diesen Titel

Über die Autorin bzw. den Autor

Forrest Houlette is a computer writer and consultant and president of Write Environment, Inc., a consulting firm that specializes in Visual Basic software development, custom documentation, training, and software for both education and business. Forrest focuses on writing about computers and creating custom software. He is a former Learning Tree International instructor, for whom he taught courses Windows 95, Windows NT, Office 97, and Visual. He has authored or co-authored books for IDG, New Riders Publishing, Que, and Sybex. He is also a Microsoft Certified Product Specialist.

Von der hinteren Coverseite

The Ultimate Resource for Developing Error-Free SQL Operations

Create a functional debugging environment to develop Structured Query Language solutions efficiently and troubleshoot SQL statements effectively. Use best practices to help perform maintenance, and to find and fix bugs when they do occur. Explore and familiarize yourself with SQL programming problems, learn to write code that's portable across databases, and realize efficiencies by expressing data in a variety of types. Develop the skills you need to debug SQL, and learn to move deftly and creatively around almost every limitation that SQL imposes on your operating environment.Write trouble-free SQL statements and procedures Optimize SQL statements and avoid problem areas Join and aggregate data and other SQL Select statements Debug and use practical regions and sequences Use and debug arrays, sets, and graphs Understand tree structures and hierarchies Secure data and protect response time Examine the appropriate use of data types Select, insert, update, and delete data using SQL syntax Recognize and mitigate fatal and logical errors Format SQL for single queries or extensive procedures using best practices

Details zur Ausgabe

• Verlag: Osborne/McGraw-Hill
• Erscheinungsdatum: 2001
• Sprache: Englisch
• ISBN 10: 0072134895
• ISBN 13: 9780072134896
• Einband: Taschenbuch
• Anzahl der Seiten: 400
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Buchbär; info@buchbaer.de; ; Weberstr. 67; Osnabrück; 49084; Deutschland