Tag: oracle
-
Session 4: Working with Data Main Topics Covered: SQL Examples from the Session 1. Using Logical Operators SELECT * FROM students WHERE age >= 18 AND name LIKE ‘J%’; SELECT * FROM training_exercises WHERE difficulty_level = ‘hard’ AND is_completed = false; 2. Sorting Data SELECT * FROM students ORDER BY…
-
Session 3: Working with Data – Part 1 Selecting & Retrieving Data SELECT Statements Basic Syntax: SELECT column_name FROM table_name; Example: Selecting student names and IDs from a students table: SELECT student_id, name FROM students; To select all columns, use *: SELECT * FROM students; Using Aliases (AS) Syntax:SELECT column_name…
KaiRaiChu 