6 - Simple Querys

Contents

After this lesson, the learner will be able to use all the SQL commands to retrieve data from database tables in Lesson 6 - Simple Querys:

  • Queries / Select statement
  • SQL queries *
  • WHERE Clause
  • Comparison Operators
    • =,>,>
    • Between
    • Like
    • IN
    • AND and OR
  • Arithmetic Expressions
  • Preventing the selection of duplicate rows - DISTINCT
  • Column Alias Name
  • Use of Not
  • ORDER BY

Tasks:

  • Lesson 6 - Simple Querys
  • Send Database Creation Script for the Database Project

Last modified: Wednesday, 19 April 2023, 2:39 PM