Teach yourself SQL in 21 days, second edition
Abstract
Description
WEEK 1: 1.Day 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
WEEK 2: 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
WEEK 3: 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