Beginning Sql - Wilton Paul; Colby John | Libro John Wiley & Sons 03/2005 - HOEPLI.it


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


Torna Indietro
ARGOMENTO:   > > > >

wilton paul; colby john - beginning sql

Beginning SQL

;


Disponibilità: Normalmente disponibile in 10 giorni

PREZZO
€ 36,40
NICEPRICE
€ 30,94
SCONTO
15%



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
Pubblicazione: 03/2005





Note Editore

SQL works with databases to insert and extract data and is an international standard for manipulating data in databases. This hands–on resource covers everything from a review of SQL basics and database design to creating your own databases and using the SQL language in a variety of database applications.

Packed with essential code, theories, concepts, and techniques, as well as a cache of useful examples, this comprehensive text will have you quickly designing your own databases and writing SQL code sufficient for many real–world situations. Practice exercises in each chapter help speed up your comprehension. By the end of the book, you'll be prepared to handle any surprise that SQL might throw your way.

What you will learn from this book

  • How to get the answers you want from a database
  • Procedures for using and manipulating data with SQL's built–in functions
  • Ways to retrieve data from numerous and diverse tables
  • How to create various levels of security in a database so you can edit data or change the database's structure
  • Theories and practical applications of normalization
  • Advanced database design

Who this book is for

This book is for programmers with some prior programming experience who are seeking to develop their database programming skills using SQL. The book assumes no previous programming experience, so it is also suitable for database programming beginners including database administrators.

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.





Sommario

About the Authors.

Acknowledgments.

Introduction.

Chapter 1. Introduction to SQL.

Chapter 2. Entering Information.

Chapter 3. Extracting Information.

Chapter 4. Advanced Database Design.

Chapter 5. Manipulating Data.

Chapter 6. Grouping and Aggregating Data.

Chapter 7. Selecting Data from Different Tables.

Chapter 8. Queries within Queries.

Chapter 9. Advanced Queries.

Chapter 10. Views.

Chapter 11. Transactions.

Chapter 12. SQL Security.

Chapter 13. Database Tuning.

Appendix A: Exercise Answers.

Appendix B: Setting up and Using the Five Database Systems

Appendix C: Initial Data Setup.

Index.





Trama

* Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all times
* Focuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendix
* Paul Wilton is a successful Wrox "Beginning" book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particular database product
* SQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others




Autore

Paul Wilton has been working professionally as a programmer for over 6 years. He is experienced with SQL, database design, development and deployment, as well as RDBMS systems including SQL Server and Access. He is currently working freelance developing functionality for websites database driven web sites including e–commerce, message boards, chat applications, and more. His most recent work includes a case tracking system for a law firm and an online booking system for a holiday cottage rental company.

John Colby is database consultant providing database analysis and design as well as Access, SQL Server, and Visual Foxpro programming to companies in the United States, Mexico, and Europe.





Note Libraio

SQL works with databases to insert and extract data and is an international standard for manipulating data in databases.This hands-on resource covers everything from a review of SQL basics and database design to creating your own databases and using the SQL language in a variety of database applications.Packed with essential code, theories, concepts and techniques as well as a cache of useful examples, this comprehensive text will have you quickly designing your own databases.







Altre Informazioni

ISBN: 9780764577321
Condizione: Nuovo
Collana: Wrox - Programmer to Programmer
Dimensioni: 233 x 26.78 x 188 mm Ø 892 gr
Formato: Brossura
Illustration Notes:Illustrations
Pagine Arabe: 520






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