Intro to DBAccess and SQL

Start Here


Contents

  1. Intro to DBAccess and SQL

  2. Topics

  3. Informix in AWIPS

  4. Informix Utilities

  5. Backup

  6. Queries

  7. DBAccess

  8. Structured Query Language - SQL

  9. Data Types in Informix

  10. Statements in SQL

  11. SQL Syntax Diagrams

  12. The INFO Statement

  13. The SELECT Statement

  14. The SELECT Statement

  15. The SELECT Clauses

  16. The SELECT Statement Structure

  17. Building a SELECT statement

  18. Starting Dbaccess for SQL

  19. SQL in DBAccess

  20. SQL in DBAccess (con't)

  21. Linking two tables together with SELECT

  22. Two Table SELECT

  23. Using Temporary Tables

  24. Using INTO TEMP

  25. Be Careful

  26. Lets Fix the Problem

  27. More about WHERE clauses

  28. Searching CHARACTER Fields

  29. Subscripts

  30. More SELECT Statements

  31. Test Your Knowledge

  32. Test Your Knowledge

  33. Date Functions

  34. Using Date Functions

  35. Functions

  36. The GROUP BY Clause

  37. Subqueries

  38. Subqueries

  39. Test Your Knowledge

  40. The UNLOAD TO Statement

  41. The UNLOAD TO Statement

  42. The UNLOAD TO Clauses

  43. A sample UNLOAD TO Statement

  44. Using UNLOAD TO

  45. The UPDATE Statement

  46. The UPDATE Clauses

  47. A sample UPDATE statement

  48. Another Look at DBAccess

  49. Converting Queries to Scripts

  50. Converting Queries to Scripts

  51. Converting Queries to Scripts

  52. Resources

  53. Slide 53

Comments or Questions?

Home page

Information:
Presentation Created by Mike Callahan

Last updated:
February 13, 2001 (Tuesday)

Download presentation file