Lecture Review

Before you move on, be sure you have mastered the following concepts.

  1. What ANSI is.

  2. What ANSI standard SQL is.

  3. The differenced between ANSI SQL and T-SQL.

  4. The different types of SQL statements.

  5. What the elements of SQL statements do.

  6. Memorize all functions spoken about in lecture.

  7. Understand how to create both table and column aliases.

  8. Understand boolean logic.

  9. Understand how to filter and order datasets.

Last updated