Written by the world's top SQL programmers, this eBook utilizes their substantial knowledge in SQL database programming. With combined experience of over a century, these experts share their secrets for programming with SQL. This is an advanced eBook that explores topics such as using advanced SQL constructs and writing programs that utilize complex SQL queries. Not for the beginner, this eBook explores complex time-based SQL queries, managing set operations in SQL, and relational algebra with SQL. This is an indispensable handbook for any developer who is challenged with writing complex SQL inside applications
CONTENTS
Conventions Used in this Book
About the Authors
Foreword
Chapter 1 - SQL as a Second Language
Chapter 2 - SQL View Internals
Chapter 3 - SQL JOIN
Chapter 4 - SQL UNION
Chapter 5 - SQL NULL
Chapter 6 - Specifying Time
Chapter 7 - SQL TIMESTAMP datatype
Chapter 8 - Internals of the IDENTITY datatype Column
Chapter 9 - Keyword Search Queries
Chapter 10 - The Cost of Calculated Columns
Chapter 11 - Graphs in SQL
Chapter 12 - Finding the Gap in a Range
Chapter 13 - SQL and the Web
Chapter 14 - Avoiding SQL Injection
Chapter 15 - Preventing SQL Worms
Chapter 16 - Basic SQL Tuning Hints
Index
CONTENTS
Conventions Used in this Book
About the Authors
Foreword
Chapter 1 - SQL as a Second Language
Chapter 2 - SQL View Internals
Chapter 3 - SQL JOIN
Chapter 4 - SQL UNION
Chapter 5 - SQL NULL
Chapter 6 - Specifying Time
Chapter 7 - SQL TIMESTAMP datatype
Chapter 8 - Internals of the IDENTITY datatype Column
Chapter 9 - Keyword Search Queries
Chapter 10 - The Cost of Calculated Columns
Chapter 11 - Graphs in SQL
Chapter 12 - Finding the Gap in a Range
Chapter 13 - SQL and the Web
Chapter 14 - Avoiding SQL Injection
Chapter 15 - Preventing SQL Worms
Chapter 16 - Basic SQL Tuning Hints
Index
Páginas : 113
Peso : 1mb.
Formato : PDF.
Edición : Primera
Año de Publicación :2003
ISBN : 9780974435527
Editorial : Rampant TechPress
Autor Donald K. Burleson, Joe Celko
0 comentarios:
Publicar un comentario