Cargando…

Beginning SQL /

Exercises; Chapter 3: Extracting Information; The SELECT Statement; Logical Operators and Operator Precedence; Ordering Results with ORDER BY; Selecting Data from More Than One Table; Introducing NULL Data; Summary; Exercises; Chapter 4: Advanced Database Design; Normalization; Ensuring Data Validit...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Wilton, Paul, 1969-
Otros Autores: Colby, John W., 1954-
Formato: Documento de Gobierno Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, IN : Wiley Pub., ©2005.
Colección:Wrox beginning guides.
Temas:
Acceso en línea:Texto completo
Texto completo
Tabla de Contenidos:
  • Introduction
  • Introduction to SQL
  • Entering information
  • Extracting information
  • Advanced database design
  • Manipulating data
  • Grouping and aggregating data
  • Selecting data from different tables
  • Queries within queries
  • Advanced queries
  • Views
  • Transactions
  • SQL security
  • Database tuning
  • Appendix A: Exercise answers
  • Appendix B: Setting up and using the five database systems
  • Appendix B: Initial data setup.