Introduction to SQL : mastering the relational database language /

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Lans, Rick F. van der
Otros Autores: Cools, Diane
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Upper Saddle River, N.J. : Addison Wesley Professional, 2006.
Edición:4th ed., 20th anniversary ed.
Temas:
SQL (Computer program language)
SQL (Langage de programmation)
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 1. Introduction to SQL
  • 2. tennis club sample database
  • 3. Installing the software
  • 4. SQL in a nutshell
  • 5. SELECT statement : common elements
  • 6. SELECT statements, table expressions, and subqueries
  • 7. SELECT statement : the FROM clause
  • 8. SELECT statement : the WHERE clause
  • 9. SELECT statement : SELECT clause and aggregation functions
  • 10. SELECT statement : the GROUP BY clause
  • 11. SELECT statement : the HAVING clause
  • 12. SELECT statement : the ORDER BY clause
  • 13. Combining table expressions
  • 14. Updating tables
  • 15. Creating tables
  • 16. Specifying integrity contraints
  • 17. Character sets and collating sequences
  • 18. Changing and dropping tables
  • 19. Designing tables
  • 20. Using indexes
  • 21. Views
  • 22. Creating databases
  • 23. Users and data security
  • 24. Creating sequences
  • 25. Creating schemas
  • 26. Introduction to embedded SQL
  • 27. Transactions and multi-user usage
  • 28. Introduction to ODBC
  • 29. Optimization of statements
  • 30. Stored procedures
  • 31. Stored functions
  • 32. Triggers
  • 33. User-defined data types, functions, and operators
  • 34. Inheritance, references, and collections
  • 35. future of SQL.

Ejemplares similares