SQL:1999 understanding relational language components /
This book is the best way to make the leap from SQL-92 to SQL:1999, but it is much more than just a simple bridge between the two. The latest from celebrated SQL experts Jim Melton and Alan Simon, SQL:1999 is a comprehensive, eminently practical account of SQL's latest incarnation and a potent...
| Κύριος συγγραφέας: | Melton, Jim, 1946- |
|---|---|
| Άλλοι συγγραφείς: | Simon, Alan R. |
| Μορφή: | Ηλεκτρονική πηγή |
| Γλώσσα: | English |
| Στοιχεία έκδοσης: |
San Francisco, Calif. ; London :
Morgan Kaufmann,
c2002.
|
| Σειρά: |
Morgan Kaufmann series in data management systems.
|
| Θέματα: | |
| Διαθέσιμο Online: |
http://www.sciencedirect.com/science/book/9781558604568 |
| Ετικέτες: |
Προσθήκη ετικέτας
Δεν υπάρχουν, Καταχωρήστε ετικέτα πρώτοι!
|
Πίνακας περιεχομένων:
- Database and technology foundations
- Introduction to SQL: 1999
- Basic table creation and data manipulation
- Basic data definition language (DDL)
- Values, basic functions, and expressions
- Advanced value expressions : CASE, CAST, and row value expressions
- Predicates
- Working with multiple tables : the relational operators
- Advanced SQL query expressions
- Constraints, assertions, and referential integrity
- Active databases and triggers
- Accessing SQL from the real world
- Cursors
- Privileges, users, and security
- Transaction management
- Connections and remote database access
- Routines and routine invocation (functions and procedures)
- Dynamic SQL
- Call-level interface (CLI)
- Diagnostics and error management
- Internationalization aspects of SQL: 1999
- Information schema
- A look to the future.