Cargando…

Sams teach yourself Microsoft SQL Server T-SQL in 10 Minutes /

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Forta, Ben
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : Sams, 2007.
Colección:Sams teach yourself.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 1. Understanding SQL
  • 2. Introducing SQL Server
  • 3. Working with SQL Server
  • 4. Retrieving data
  • 5. Sorting retrieved data
  • 6. Filtering data
  • 7. Advanced data filtering
  • 8. Using wildcard filtering
  • 9. Creating calculated fields
  • 10. Using data manipulation functions
  • 11. Summarizing data
  • 12. Grouping data
  • 13. Working with subqueries
  • 14. Joining tables
  • 15. Creating advanced joins
  • 16. Combining queries
  • 17. Full-text searching
  • 18. Inserting data
  • 19. Updating and deleting data
  • 20. Creating and manipulating tables
  • 21. Using views
  • 22. Programming with T-SQL
  • 23. Working with stored procedures
  • 24. Using cursors
  • 25. Using triggers
  • 26. Managing transaction processing
  • 27. Working with XML
  • 28. Globalization and localization
  • 29. Managing security
  • 30. Improving performance
  • App. A. Getting started with SQL Server and T-SQL
  • App. B. The example tables
  • App. C. T-SQL statement syntax
  • App. D. SQL datatypes
  • App. E. T-SQL reserved words.