Syndetics cover image
Image from Syndetics

Teach yourself SQL in 24 hours / Ryan Stephens and Ronald Plew.

By: Contributor(s): Material type: TextTextPublication details: Indianapolis, Ind. : Sams, 1998.ISBN:
  • 067231245X
Subject(s): DDC classification:
  • 005.756 21
Partial contents:
Hour 1. Welcome to the World of SQL -- Hour 2. Defining Data Structures -- Hour 3. Managing Database Objects -- Hour 4. The Normalization Process -- Hour 5. Manipulating Data -- Hour 6. Managing Database Transactions -- Hour 7. Introduction to the Database Query -- Hour 8. Using Operators to Categorize Data -- Hour 9. Summarizing Data Results from a Query -- Hour 10. Sorting and Grouping Data -- Hour 11. Restructuring the Appearance of Data -- Hour 12. Understanding Dates and Time -- Hour 13. Joining Tables in Queries -- Hour 14. Using Subqueries to Define Unknown Data -- Hour 15. Combining Multiple Queries into One -- Hour 16. Using Indexes to Improve Performance -- Hour 17. Improving Database Performance -- Hour 18. Managing Database Users -- Hour 19. Managing Database Security -- Hour 20. Creating and Using Views and Synonyms -- Hour 21. Working with the System Catalog -- Hour 22. Advanced SQL Topics -- Hour 23. Extending SQL to the Enterprise, the Internet, and the Intranet -- Hour 24. Extensions to Standard SQL -- A. Common SQL Commands -- B. ASCII Table -- C. Answers to Quizzes and Exercises -- D. Create Table Statements for Book Examples -- E. Insert Statements for Data in Book Examples -- F. Glossary.
Summary: In 24 1-hour sessions, you will have a firm grasp on SQL (Structured Query Language) and understand all the bells and whistles that come along with this powerful tool. Whether you're a database programmer, administrator, or designer, Sams' Teach Yourself SQL in 24 Hours provides all the information you need to apply SQL fundamentals in today's world. SQL is the standard language used to communicate with relational database management systems, including Oracle, Microsoft SQL Server, Sybase, Informix, and even Microsoft Access. Using step-by-step instructions, real-world examples, and expert advice, you'll improve your productivity and be pleased with quick and successful results.
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.756 STA (Browse shelf(Opens below)) Available 4404407624
Total holds: 0

Enhanced descriptions from Syndetics:

Hour 1. Welcome to the World of SQL -- Hour 2. Defining Data Structures -- Hour 3. Managing Database Objects -- Hour 4. The Normalization Process -- Hour 5. Manipulating Data -- Hour 6. Managing Database Transactions -- Hour 7. Introduction to the Database Query -- Hour 8. Using Operators to Categorize Data -- Hour 9. Summarizing Data Results from a Query -- Hour 10. Sorting and Grouping Data -- Hour 11. Restructuring the Appearance of Data -- Hour 12. Understanding Dates and Time -- Hour 13. Joining Tables in Queries -- Hour 14. Using Subqueries to Define Unknown Data -- Hour 15. Combining Multiple Queries into One -- Hour 16. Using Indexes to Improve Performance -- Hour 17. Improving Database Performance -- Hour 18. Managing Database Users -- Hour 19. Managing Database Security -- Hour 20. Creating and Using Views and Synonyms -- Hour 21. Working with the System Catalog -- Hour 22. Advanced SQL Topics -- Hour 23. Extending SQL to the Enterprise, the Internet, and the Intranet -- Hour 24. Extensions to Standard SQL -- A. Common SQL Commands -- B. ASCII Table -- C. Answers to Quizzes and Exercises -- D. Create Table Statements for Book Examples -- E. Insert Statements for Data in Book Examples -- F. Glossary.

In 24 1-hour sessions, you will have a firm grasp on SQL (Structured Query Language) and understand all the bells and whistles that come along with this powerful tool. Whether you're a database programmer, administrator, or designer, Sams' Teach Yourself SQL in 24 Hours provides all the information you need to apply SQL fundamentals in today's world. SQL is the standard language used to communicate with relational database management systems, including Oracle, Microsoft SQL Server, Sybase, Informix, and even Microsoft Access. Using step-by-step instructions, real-world examples, and expert advice, you'll improve your productivity and be pleased with quick and successful results.