DENG100 Workbook Sample
  • Fundamentals of Database Programming Workbook Sample
  • Syllabus
    • About This Workbook
    • Meet Your Instructor
    • Lecture Organization
      • Lecture Structure
      • Lecture
      • Sample Code
      • Side Quests
      • Lab Assignments
      • Lecture Review
    • Quizzes And Exams
      • Exam Gut Check
      • Lecture Quizzes
      • Final Exam
      • Grading
    • Stay Up To Date With MSDS News Sources
    • Setting Up Your Dev Environment
      • Get A Gmail Account
      • Downloading SQL Server
      • Download SQL Server Management Studio
      • Install PyCharm
      • Ancillary Tools
  • Unit 2: Introduction To SQL Fundamentals
    • SQL Language Basics
      • Lecture Slides
        • Code Tutorials
        • SQL Background
        • Writing Analytic Queries
        • Types of SQL Statements
        • Basic Syntax
        • Code Comments
        • The SELECT Clause
        • Column Aliases
        • Built In Functions
        • String Functions
        • The Format Function
        • The FROM Clause
        • Boolean Logic
        • The WHERE Clause
        • Logic Operators
        • The BETWEEN Operator
        • Filtering With Wildcards
        • The IN Operator
        • The ORDER BY Clause
      • Sample Code
        • Hello World
        • Your First Query
        • Aliases
        • String Functions
        • Filtering Data
        • Ordering Data
      • Side Quests
        • T-SQL Reference
      • Lab Assignment #4
        • Lab Overview
        • Task #1
        • Task #2
        • Task #3
        • Task #4
        • Task #5
        • Task #6
        • Task #7
      • Lecture Review
Powered by GitBook
On this page

Was this helpful?

  1. Unit 2: Introduction To SQL Fundamentals
  2. SQL Language Basics

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.

PreviousTask #7

Last updated 3 years ago

Was this helpful?