Syndetics cover image
Image from Syndetics

Teach yourself SQL in 21 days / Ryan K. Stephens ... [et al.].

Contributor(s): Stephens, Ryan KMaterial type: TextTextPublication details: Indianapolis, Ind. : Sams, 1997. Edition: 2nd edISBN: 0672311100Subject(s): SQL (Computer program language) | Relational databases | Database managementDDC classification: 005.7'565
Contents:
1. Introduction to SQL -- 2. Introduction to the Query: The SELECT Statement -- 3. Expressions, Conditions, and Operators -- 4. Functions: Molding the Data You Retrieve -- 5. Clauses in SQL -- 6. Joining Tables -- 7. Subqueries: The Embedded SELECT Statement -- 8. Manipulating Data -- 9. Creating and Maintaining Tables -- 10. Creating Views and Indexes -- 11. Controlling Transactions -- 12. Database Security -- 13. Advanced SQL Topics -- 14. Dynamic Uses of SQL -- 15. Streamlining SQL Statements for Improved Performance -- 16. Using Views to Retrieve Useful Information from the Data Dictionary -- 17. Using SQL to Generate SQL Statements -- 18. PL/SQL: An Introduction -- 19. Transact-SQL: An Introduction -- 20. SQL*Plus -- 21. Common SQL Mistakes/Errors and Resolutions -- A. Glossary of Common SQL Statements -- B. Source Code Listings for the C++ Program Used on Day 14 -- C. Source Code Listings for the Delphi Program Used on Day 14 -- D. Resources -- E. ASCII Table.
Summary: Discover effective database design structures; learn to use functions and clauses to query data; discover faster, easier methods for manipulating data; create tables and advanced queries with ease; learn to identify and solve common SQL errors; tune your database using stored procedures and triggers; gain valuable insight, tips, techniques, and advice from industry experts; gain an understanding of PL/SQL, Transact SQL, and SQL Plus.
Holdings
Item type Home library Call number Status Date due Barcode Item holds
Two Week Loan Two Week Loan College Lane Learning Resources Centre
Main Shelves 		005.7565 SQL (Browse shelf(Opens below)) Available 4404159940
Total holds: 0

Enhanced descriptions from Syndetics:

Includes index.

1. Introduction to SQL -- 2. Introduction to the Query: The SELECT Statement -- 3. Expressions, Conditions, and Operators -- 4. Functions: Molding the Data You Retrieve -- 5. Clauses in SQL -- 6. Joining Tables -- 7. Subqueries: The Embedded SELECT Statement -- 8. Manipulating Data -- 9. Creating and Maintaining Tables -- 10. Creating Views and Indexes -- 11. Controlling Transactions -- 12. Database Security -- 13. Advanced SQL Topics -- 14. Dynamic Uses of SQL -- 15. Streamlining SQL Statements for Improved Performance -- 16. Using Views to Retrieve Useful Information from the Data Dictionary -- 17. Using SQL to Generate SQL Statements -- 18. PL/SQL: An Introduction -- 19. Transact-SQL: An Introduction -- 20. SQL*Plus -- 21. Common SQL Mistakes/Errors and Resolutions -- A. Glossary of Common SQL Statements -- B. Source Code Listings for the C++ Program Used on Day 14 -- C. Source Code Listings for the Delphi Program Used on Day 14 -- D. Resources -- E. ASCII Table.

Discover effective database design structures; learn to use functions and clauses to query data; discover faster, easier methods for manipulating data; create tables and advanced queries with ease; learn to identify and solve common SQL errors; tune your database using stored procedures and triggers; gain valuable insight, tips, techniques, and advice from industry experts; gain an understanding of PL/SQL, Transact SQL, and SQL Plus.

Powered by Koha