home libri books ebook dvd e film top ten sconti 0 Carrello


Torna Indietro
ARGOMENTO:   > > > >

vieira robert - beginning microsoft sql server 2008 programming

Beginning Microsoft SQL Server 2008 Programming




Disponibilità: Non disponibile o esaurito presso l'editore

PREZZO
€ 32,00



Questo prodotto usufruisce delle SPEDIZIONI GRATIS
selezionando l'opzione Corriere Veloce in fase di ordine.


Facebook Twitter Aggiungi commento


Spese Gratis

Dettagli

Genere:Libro
Lingua: Inglese
Editore: Wrox
Pubblicazione: 01/2009





Sommario

Introduction.

Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?

Chapter 2: Tools of the Trade.

Chapter 3: The Foundation Statements of T–.

Chapter 4: JOINs.

Chapter 5: Creating and Altering Tables.

Chapter 6: Constraints.

Chapter 7: Adding More to Our Queries.

Chapter 8: Being Normal: Normalization and Other Basic Design Issues.

Chapter 9: SQL Server Storage and Index Structures.

Chapter 10: Views.

Chapter 11: Writing Scripts and Batches.

Chapter 12: Stored Procedures.

Chapter 13: User–Defined Functions.

Chapter 14: Transactions and Locks.

Chapter 15: Triggers.

Chapter 16: A Brief XML Primer.

Chapter 17: Reporting for Duty, Sir! A Look At Reporting Services.

Chapter 18: Getting Integrated with Integration Services.

Chapter 19: Playing Administrator.

Appendix A: System Functions.

Appendix B: Very Simple Connectivity Examples.

Index.





Trama

Starting simply and gradually progressing to increasingly advanced topics, this introduction to the SQL Server database focuses on what is distinctive about the SQL environment SQL Server 2008, in particular versus other programming environments. Author Robert Vieira draws on his experience as one of the leading authorities on Microsoft SQL Server and uses his unique tutorial approach to explain the significant changes to the fundamental core components of SQL Server 2008.

You'll begin with an overview of database design concepts and learn how to implement these fundamental concepts with Microsoft SQL Server 2008. Then, you'll take a look at the role of an RDBMS (relational database management system) and where it fits in the grand scheme of system development. Thorough coverage of the key additions and changes to the 2008 version of SQL Server include discussions on DATE and TIME datatypes, hierarchyID datatypes, MERGE and multiple inserts, recursive queries, and more. With this book, you will conquer the many changes and challenges of Microsoft SQL Server 2008.

What you will learn from this book

  • How RDBMSs store, manage, and retrieve data
  • Ways to create and alter tables

  • Various "forms" of database normalization

  • Techniques for writing scripts and working with stored procedures

  • The positives and negatives of indexes

  • Myriad consequences that locks and deadlocks have on system performance

  • An understanding of triggers and how they are used

Who this book is for
This book is for developers who are looking for a complete introduction to database design concepts and learning SQL. A basic understanding of development fundamentals is helpful.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.





Autore

Experiencing his first infection with computing fever in 1978, Rob Vieira knew right away that this was something really cool. In 1980 he began immersing himself in the computing world more fully splitting time between building and repairing computer kits, and programming in Basic as well as Z80 and 6502 assembly. In 1983, he began studies for a degree in Computer Information Systems, but found the professional mainframe environment too rigid for his tastes, and dropped out in 1985 to pursue other interests. Later that year, he caught the PC bug and began the long road of programming in database languages from dBase to SQL Server. Rob completed a degree in Business Administration in 1990, and since has typically worked in roles that allow him to combine his knowledge of business and computing. Beyond his Bachelor s degree, he has been certified as a Certified Management Accountant as well as Microsoft Certified as a Solutions Developer (MCSD), Trainer (MCT), and Database Administrator (MCDBA). Rob is currently the DBA Team Lead for the Stockamp practice of The Huron Consulting Group in Portland, Oregon, and makes occasional speaking appearances on database development, business intelligence, and other topics. He resides with his youngest daughter Adrianna (aka Addy, aka Trillian, aka T ) in Vancouver, WA.




Consigliati dai Librai

Professional Microsoft SQL Server 2008 Programming
Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports
SQL E EXCEL
POSTGRESQL
SQL SERVER 2012 GUIDA ALL'USO




Altre Informazioni

ISBN: 9780470257012
Condizione: Nuovo
Collana: Wrox - Programmer to Programmer
Dimensioni: 235 x 38.72 x 189 mm Ø 1106 gr
Formato: Brossura
Pagine Arabe: 720






Utilizziamo i cookie di profilazione, anche di terze parti, per migliorare la navigazione, per fornire servizi e proporti pubblicità in linea con le tue preferenze. Se vuoi saperne di più o negare il consenso a tutti o ad alcuni cookie clicca qui. Chiudendo questo banner o proseguendo nella navigazione acconsenti all’uso dei cookie.

X