Beginning SQL Programming - John Kaufman , Brian Matsik , Kevin... - Librairie Eyrolles
Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
Beginning SQL Programming
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

Beginning SQL Programming

Beginning SQL Programming

John Kaufman, Brian Matsik, Kevin Spencer

723 pages, parution le 01/03/2001

Résumé

What does this book cover?
  • Database structure from Tables to Normalisation
  • Basic SQL, including DDL, DCL, DML
  • The only tutorial that is comprehensive and up-to-date with coverage of SQL '99
  • Tutorial exercises tied into each element of database structure - as it appears
Book overview Structured Query Language is the industry standard for querying data held in relational databases. SQL can be used to create and alter the structure of databases, add new data, and access or modify existing data. Beginning SQL Programming begins by looking at what SQL is, then moves on to teach you the fundamentals of ANSI SQL, using the familiar Northwind database that comes with versions of Microsoft Access and SQL Server.

The book gives step-by-step instructions, alerts readers to common pitfalls, tricks and traps, and uses real-world examples, including two extensive case studies, to create a thorough tutorial. It will furnish readers with a firm grasp of SQL concepts that you can work with straight away, as well as provide solid foundations and challenging ideas with which you can later develop more advanced SQL techniques.

Included with this book is a 120-day evaluation enterprise edition of Microsoft's SQL Server 2000. An end user license agreement is contained in this licensed software. Who is this book for?

  • Novice database programmers and administrators
  • Highly suitable for Visual Basic novices
  • Highly suitable for web developers who have wandered into the world of dynamic page creation from databases
  • Chapter 01 Introduction
  • Chapter 02 Getting Started with SQL
  • Chapter 03 Introduction to Databases
  • Chapter 04 SQL Syntax and Basic SELECT
  • Chapter 05 More Techniques with SELECT
  • Chapter 06 Creating and Modifying Tables
  • Chapter 07 Table Constraints
  • Chapter 08 Relating Tables
  • Chapter 09 Creating Records and Cleaning Data
  • Chapter 10 Deleting Records
  • Chapter 11 Changing Existing Data
  • Chapter 12 SQL Functions - Date, Time and String
  • Chapter 13 SQL Functions - Math and Data Type Conversion
  • Chapter 14 Grouping - using aggregate functions
  • Chapter 15 Stored Procedures
  • Chapter 16 Views and Indices
  • Chapter 17 Schema
  • Chapter 18 Case Study 1
  • Chapter 19 Case Study 2
  • Chapter 20 What to Study Next
Appendices
  • Appendix A Intro to DCL
  • Appendix B Schema for example databases
  • Appendix C SQL Quick Reference
  • Appendix D Notes on Flavours of SQL
  • Index

Caractéristiques techniques

  PAPIER
Éditeur(s) Wrox Press
Auteur(s) John Kaufman, Brian Matsik, Kevin Spencer
Parution 01/03/2001
Nb. de pages 723
Format 18,3 x 23,5
Couverture Broché
Poids 1285g
Intérieur 2 couleurs
EAN13 9781861001801

Avantages Eyrolles.com

Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription