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
  • How to Resolve Query Exercises Tutorial
  • (6)  Simple Querys SQL Exercises

Last modified: Wednesday, 26 April 2023, 11:11 AM