Cargando…

Beginning Microsoft SQL Server 2012 programming.

The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Serve...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Atkinson, Paul (Software engineer)
Otros Autores: Vieira, Robert
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Hoboken : John Wiley & Sons, 2012.
Temas:
Acceso en línea:Texto completo
Tabla de Contenidos:
  • RDBMS basics : what makes up a SQL server database?
  • Learning the tools of the trade
  • The foundation statements of T-SQL
  • Joins
  • Creating and altering tables
  • Keys and constraints
  • Adding more to your queries
  • Being normal : normalization and other basic design issues
  • SQL server storage and index structures
  • Views
  • Writing scripts and batches
  • Stored procedures
  • User-defined functions
  • Transactions and locks
  • Triggers
  • A brief XML primer
  • Business intelligence fundamentals
  • BI storage and reporting resources
  • Reporting for duty, Sir! : a look at reporting services
  • Getting integrated with integration services
  • Playing administrator.